Viewing Db2 DBM1 storage usage
To view Db2 DBM1 storage usage
From EZDSSI, hyperlink on Db2 Storage Use to see the Db2 Storage Entries view (DB2STOR).
>W1 =DB2STOR==========(ALL======*=======)30MAR2015==10:33:55====MVDB2====D====4============
Db2 Real Available Total DBM1 In Use Storage Fixed Getmained
Target Frames < 2GB In Use By MVS Cushion > 2GB > 2GB
B2DEFG 92105 1034.49 6.25 103.50 228.72 6.16 134.38
B2DEHF 83469 1031.43 5.46 106.57 227.82 6.13 240.51
B2DIT2 49096 1036.86 5.87 101.13 239.95 6.05 168.53
B2DJP2 52405 1031.16 5.79 106.83 252.40 6.05 240.38From this view, you can set an alarm to give you a warning if the amount of available storage below the 2-GB bar falls below the specified threshold. A sample alarm is provided. You can change the defined thresholds and assigned colors by customizing the view. For more information, see .
You might want to set this alarm either for one critical Db2 or for several production Db2s.
Hyperlink on a Db2 Target to access the Db2 Storage Details view (Db2STORD).This view provides a complete picture of storage usage for the selected Db2. You can see information about storage usage below the 2-GB bar (See figure below), and above the bar (Db2 storage details (Db2STORD)–above the bar). For Db2 10, this view shows storage information for the DBM1 and DIST address spaces.
The first section of this view provides a summary of storage usage below the 2-GB bar, with pointers to subsequent sections that provide further details.
>W1 =DB2STOR==Db2STORD=DEHF=====*========30MAR2015==05:48:37====MVDB2====D====1
Db2 and MVS Storage Usage................ Quantity in MB
Storage Summary Below 2 GB............... 05:48 30MAR
Address Space........................... DBM1 DIST
Storage Available....................... 1031.50 1123.28
Total Db2 Storage In Use (1)............ 5.38 1.41
Total MVS Storage In Use Below 2GB (5).. 106.49 25.86
Storage Cushion (4)..................... 227.82 227.89
Average Thread Footprint................ 0.04
Maximum Number of Possible Threads...... 4654
1) Total Db2 Storage In Use.............. 5.38 1.41
Total Getmained Storage (2)............. 0.22 0.00
Total Variable Storage (3).............. 0.52 0.32
Total Fixed Storage..................... 0.08 0.08
Total Getmained Stack Storage........... 4.56 1.00
Total Stack Storage in Use.............. 4.33 0.91
System Stack Storage in Use........... 3.80 0.72
Current 24 bit high address............. 0003E000 00043000
Current 31 bit high address............. 3D952000 39B7F000
2) Total Getmained Storage Below 2GB..... 0.22 0.00
EDM Pool................................ n/a
Total Buffer Manager control blocks..... 0.10
3) Total Variable Storage................ 0.52 0.32
Total Agent Local Storage............... 0.32
Total Agent System Storage............ 0.22
Number of PreFetch Engines.......... 8
Number of Deferred Write Engines.... 6
Number of Castout Engines........... 0
Number of GBP Write Engines......... 0
Number of P-Lock/Notify Exit engines 0
Total Agent Non-System Storage........ 0.09
Total Number Of Active User Threads.. 7
Total Number of Active DBATs........ 0
Thread High Water Mark.............. 7
DBAT High Water Mark................ 0
Active and Disconnected DBATs....... 0
Active Parallel Child Threads....... 0
RDS OP Pool............................ n/a
RID Pool............................... n/a
Pipe Manager Sub Pool.................. 0.00
Local Dynamic Stmt Cache Cntl Blks..... n/a
Thread Copies Of Cached SQL Statements. 0.00
In Use Storage....................... 0.00
Statement Count...................... 0
HWM For Allocated Statements......... 0.00
Statement Count At HWM............. 0
Date At HWM........................ 2015-MAR30
Time At HWM........................ 05:48:11.2
Buffer & Data Manager Trace Table...... 0.00
4) Storage Cushion....................... 227.82 227.89
Contract Warning Cushion................ 113.80 113.80
Reserved For Must Complete.............. 113.80 113.80
Reserved For MVS Usage.................. 0.22 0.29
5) Total MVS Storage Below 2GB...........
24 bit Low Private...................... 0.22 0.24
24 bit High Private..................... 0.68 0.27
31 bit Extended Low Private............. 75.11 13.50
31 bit Extended High Private............ 31.38 12.36
Extended Region Size (MAX).............. 1138.00 1138.00
Extended CSA Size....................... 750.32Information about storage usage above the 2-GB bar is displayed at the bottom portion of this view.
Storage Above 2 GB.......................
Total Storage Above the Bar.............
Fixed Storage......................... 6.13 0.09
Getmained Storage..................... 240.51 0.00
Variable Storage...................... 25.25 0.02
Total Shared Storage Above the Bar......
Fixed Shared Storage.................. 3.33
Getmained Shared Storage.............. 4.93
Variable Shared Storage............... 8.20
Agent Local Storage................... 7.19
System Agent Storage.................. 4.99
Storage Manager Structures.............. 1.34 1.34
Allocated for Thread Copies............. 0.00
HWM Allocated for Thread Copies......... 0.00
Total Stmt Cache Block Storage.......... 0.09
DBD Pool................................ 22.85
Statement Cache Pool.................... 110.73
Virtual Buffer Pools.................... 39.06
Virtual Pool Control Blocks............. 0.58
Castout Buffers......................... 0.00
Compression Dictionary.................. 0.00
Total xPROC Storage for Static SQL...... 0.02
Total array variable storage............ 0.00
Real Storage Usage.......................
Number Of Real Frames(4K)............... 88855 4252
Number Of Auxiliary Slots(4K)........... 0 0
Log Manager storage......................
Write buffers Real Frames............... 256
Write buffers Aux Frames................ 0
Control Structures Real Frames.......... 1
Control Structures Aux Frames........... 0- Press F3 until you return to EZDSSI.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*