paging space not getting released.

Prashant Shettar

paging space not getting released.

Hello Everyone,

 

In our production database , paging space used by DB2 is not getting released. I am using DB2 10.5 fp5 on AIX 7.1 (DPF with 4 logical nodes).

$ svmon -Pt 15 -O summary=basic,unit=GB
Unit: GB

-------------------------------------------------------------------------------
Pid Command Inuse Pin Pgsp Virtual
10551456 db2sysc 55.6 0.05 16.2 51.2
11665526 db2sysc 53.7 0.04 11.0 49.3
9502724 db2sysc 53.7 0.04 16.5 49.5
11141250 db2sysc 53.5 0.04 8.89 49.4
37814414 db2vend 46.7 0.04 15.3 47.3
32440382 db2vend 46.0 0.04 16.1 47.3
39911506 db2vend 46.0 0.04 8.50 47.2
17629316 db2vend 45.8 0.04 10.7 47.2
13435044 db2vend 0.53 0.04 0.07 0.66
13369496 db2vend 0.52 0.04 0.07 0.65
12648614 db2vend 0.51 0.04 0.07 0.64
13303958 db2vend 0.51 0.04 0.06 0.63
15663348 db2fmp 0.39 0.04 0.01 0.47
10944668 db2fmp 0.38 0.04 0.01 0.46
11599890 db2fmp 0.38 0.04 0.01 0.46

 

I did check db2pd with memset and mempool (please find attached files) but memory used by db2 is less than what is allocated. 

I have also attached db2mtrk.a (application) db2mtr.i (instance) and svmon.out (svmon)

If you can provide me hints to reduce pageing space , it will be of great help.

 

Regards

Prashant Shettar 

 

 

Attachments

  • memsets.txt (10k)
  • mempools.txt (77k)
  • db2mtrk.i (<1k)
  • db2mtrk.a (9.5k)
  • svmon.out (499.3k)
Edited By:
Prashant Shettar[Organization Members] @ Apr 11, 2017 - 05:51 PM (Europe/Berlin)