REPORT (Generate Reports) › Statistics and Diagnostics Area (PXX) Report › Dumping SQL Internal Control Structures

Dumping SQL Internal Control Structures

You can dump SQL internal control structures held in memory. This feature should normally be used only at the request of CA Support.

To dump the SQL internal control structures held in memory, generate an SQLCODE -999 (SQLSTATE 56S19) and the associated PXX or PXXSQL dumps using the following:

   SELECT * FROM SYSADM.SQL_STATUS_DUMP;

Note: For information about SQLCODE -999, see the CA Datacom/DB Message Reference Guide.