To follow-up on the case here when a DB2 DBA accidently overcommitted
storage to DB2 an APAR PK58272 is now open against DB2 to provide a WTO
message that can be automated to notify and escalate if a DBA does this
and gets the message DSNB542I.
PK58272 MAKE DSNB542I A WTO MESSAGE, SO THAT THE CHECKING OF THIS
MESSAGE CAN BE AUTOMATED.
Here a DBA transposed some numbers in a job and got DSNB542I but did not
immediately back out the changes.
DSNB542I -DB2P DSNB1ABP THE TOTAL ACTIVE PGFIX YES BUFFER POOL
STORAGE
EXCEEDS THE DB2 ALLOWED REAL STORAGE CAPACITY
WHEN EXPANDING STORAGE FOR BUFFER POOL BP24
CURRENT VPSIZE = 400000
NEW VPSIZE = 2000000
REAL STORAGE CAPACITY = 73728 MB.
DSN9022I -DB2P DSNB1CMD '-ALT BPOOL' NORMAL COMPLETION
Best Regards,
Sam Knutson, GEICO
System z Performance and Availability
mailto:[EMAIL PROTECTED]
(office) 301.986.3574
"Think big, act bold, start simple, grow fast..."
====================
This email/fax message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution of this
email/fax is prohibited. If you are not the intended recipient, please
destroy all paper and electronic copies of the original message.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
