How do I force an SQL -999 so that DB00248I program maintenance level messages for all changed object modules of CA Datacom SQL load module DBSRPPR appear in the PXX dump?

Document ID : KB000022186
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How do I force an SQL -999 so that DB00248I program maintenance level messages for all changed object modules of CA Datacom SQL load module DBSRPPR appear in the PXX dump?

Answer:

Starting with CA-Datacom Version 12.0, with PTFs RO21329 and RO22350, an SQL -999 dump can be produced upon request. The PXX dump will include DB00248I messages for all changed object modules of CA-Datacom SQL load module DBSRPPR: 

DB00248I - PARM PGMDT=ALL      DBSRPPR(object module name) date-time release maintenance

First, submit the following SQL request using batch utility DBSQLPR to force the -999 PXX dump:

SELECT * FROM SYSADM.SQL_STATUS_DUMP;

Then, if your CA Datacom Multi-User (MUF) has the startup option SYSOUT (recommended), view the PXX dump in the PXXSQLnn sysout file.

Or, if your MUF was not started with SYSOUT, produce the PXX dump using batch utility DBUTLTY with SYSIN:

REPORT AREA=PXX,DUMPS=FULL

Here is a partial output from the forced -999 PXX dump. The DB00248I messages are within the dumps of the SQL memory:

 S0001 -- DATA BASE SQL ERROR SUMMARY 11/7/2016 09:03:05 -- 
S0001 SQLSTATE 56S19 OCCURRED WITH SQL ERROR CODE -999 IN PROG tblRef.~ AT LINE
S0001 ERROR MESSAGE TEXT: INTERNAL ERROR (tblRef.. LINE 0480): DUMP SQL MEMOR
S0001 AUTH-ID.PLAN NAME: SYSADM.SQL9C6C5E694ABA8E
S0001 COMMAND(STATEMENT ID): QPRPD(STATEMENT 0) S0001 JOB NAME: OBRSQL15, RUN UNIT: 61868 ... dump...
S0001 DB00248I - PARM PGMDT=ALL , DBSRPPR(ATCHCLS ) 2014/09/12-1553 15.0 RO73203
S0001 DB00248I - PARM PGMDT=ALL , DBSRPPR(AGGEXEC ) 2014/12/17-1659 15.0 RO77114
S0001 DB00248I - PARM PGMDT=ALL , DBSRPPR(AGGPREP ) 2016/02/10-1924 15.0 RO88189
S0001 DB00248I - PARM PGMDT=ALL , DBSRPPR(AOBMGR ) 2013/12/05-1339 15.0 NO PTF
... etc...
... dump...

Additional Information:

TEC614157 "How do I use the Multi-User Facility Startup Option called SYSOUT?"

http://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec614157.html

TEC1191855 "CA Datacom Multi-user and DBUTLTY jobs can issue “DB00248I - PARM PGMDT” messages to display the module maintenance level of each module that is being loaded by MUF or DBUTLTY. Is there a way to determine the maintenance levels (RMID) for all module?"

http://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec1191855.html