IBM Mainframe Forum

Hi all,

I need to gather information about DB/2 usage of "Under 2GB" storage.

But the output of command "-DSNA DIS THREAD(*) SERVICE(STORAGE)" is truncated.

Is there anyway to have the complete output of the command?


Or,what is the best way to gather information about DB/2 usage of "under 2GB" storage?



all the best,
Mehrdad Rastegar

Hi mehi1353,

• if you'd look at DB2 Command Reference, you would recognize a 'LIMIT' keyword that comes along with the -DIS THREAD command.
• You may have this PDF as a starting point: http://public.dhe.ibm.com/software/hk/Systemz/DB2-Storage-tuning-V3.pdf. Written 2010, related to DB2 for z/OS V8 & V9.
• IBM's developerworks offers you a REXX called memu2. Google it > IBM developerworks MEMU2.
  Find a description here: http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS3431
• There's another piece of information available from here: http://public.dhe.ibm.com/software/dw/data/bestpractices/db2zos/DB2_BestPractices_VirtualStorageTuning.pdf
• ...and 5000 other places in the web that relate to this topic...

Best regards,
alexm