gtpo1mfj | Operations |
Use this command to display entries from the structured query language (SQL) trace table on the current subsystem in either of two formats: a summary form or a detail form.
Requirements and Restrictions
The TPF Application Requester (TPFAR) feature must be installed on the TPF system.
Format
|
Notes:
Additional Information
Online help information is available for this command. To display the help information, enter one of the following:
ZSTTD HELP
ZSTTD ?
Examples
The following information is displayed in the examples:
The last 4 entries in the SQL trace table on I-stream 2 are displayed in the following example.
+--------------------------------------------------------------------------------+ |User: ZSTTD 4 IS-2 | | | |System: CRDW0004I 09.04.31 SQL TRACE TABLE FOR I-STREAM 2 | | I SQL SQL SEC STMT STMT ECB | | O CODE STATE NBR NBR TYPE PGM ADDR TIME | | O 1 58 SELECT QXOE 2F9A40 | | I 100 02000 1 58 SELECT QXOE 2F9A40 0.054 | | O 0 47 COMMIT QXOE 2F9A40 | | I 0 00000 0 47 COMMIT QXOE 2F9A40 0.175 | | END OF TABLE, 4 ENTRIES DISPLAYED | +--------------------------------------------------------------------------------+
The last 3 replies to SQL commands are displayed in the following example.
+--------------------------------------------------------------------------------+ |User: ZSTTD 3 REP IS-2 | | | |System: CRDW0004I 08.02.23 SQL TRACE TABLE FOR I-STREAM 2 | | I SQL SQL SEC STMT STMT ECB | | O CODE STATE NBR NBR TYPE PGM ADDR TIME | | I 0 00000 0 42 CONNECT TO QXOE 2F9A40 1.175 | | I 100 02000 1 58 SELECT QXOE 2F9A40 0.154 | | I 0 00000 0 47 COMMIT QXOE 2F9A40 0.075 | | END OF TABLE, 3 ENTRIES DISPLAYED | +--------------------------------------------------------------------------------+
The last 3 requests for SQL commands that were processed by the ECB at the specified address are displayed in the following example. Notice that 6 entries were requested but only 3 exist in the SQL trace table.
+--------------------------------------------------------------------------------+ |User: ZSTTD 6 REQ ECB-2F9A40 | | | |System: CRDW0004I 11.22.50 SQL TRACE TABLE FOR I-STREAM 1 | | I SQL SQL SEC STMT STMT ECB | | O CODE STATE NBR NBR TYPE PGM ADDR TIME | | I 0 42 CONNECT TO QXOE 2F9A40 | | I 1 58 SELECT QXOE 2F9A40 | | I 0 47 COMMIT QXOE 2F9A40 | | END OF TABLE, 3 ENTRIES DISPLAYED | +--------------------------------------------------------------------------------+
All the replies to SQL commands that were processed with an error by the QXOE application program are displayed in the following example. Notice that only one entry exists.
+--------------------------------------------------------------------------------+ |User: ZSTTD ALL ERR PGM-QXOE | | | |System: CRDW0004I 08.02.31 SQL TRACE TABLE FOR I-STREAM 1 | | I SQL SQL SEC STMT STMT ECB | | O CODE STATE NBR NBR TYPE PGM ADDR TIME | | I 100 02000 1 58 SELECT QXOE 2F9A40 0.154 | | END OF TABLE, 1 ENTRIES DISPLAYED | +--------------------------------------------------------------------------------+
The DETAIL parameter provides the most recent entries in the trace table. In the following example program QXOE has returned an SQLCODE of 100.
The information returned is defined by the relational distributed architecture. The previous example gives the definitions for the fields, except for SQLCAID, SQLCABC, SQLWARN, SQLERRD, SQLERRP, SQLERRML, and SQLERRMSG, which provide various kinds of information and warnings as defined by the remote database.
+--------------------------------------------------------------------------------+ |User: ZSTTD 1,DET | | | |System: SQL DETAIL TRACE FOR I-STREAM 1 | | PROGRAM: QXOE ECB ADDRESS: 6B1000 RDB: DB23PRD | | SQL_CODE: 100 SQL_STATE: 2000 | | SECTION NUM: 00001 STMT NUM: 00058 STMT TYPE: SELECT | | SQLCAID: SQLCABC: 00000 SQLWARN: | | SQLERRD: 0, 0, 0, 0, 0, 0 SQLERRP: | | SQLERRML: 0 SQLERRMSG: | | | | END OF TABLE, 1 ENTRIES DISPLAYED | +--------------------------------------------------------------------------------+
The following example shows how the summary trace and the detail trace differ. The fields displayed are defined in a previous example.
+--------------------------------------------------------------------------------+ |User: ZSTTD 8 | | | |System: CRDW0004I 14.40.32 SQL TRACE TABLE FOR I-STREAM 1 | | I SQL SQL SEC STMT STMT ECB | | O CODE STATE NBR NBR TYPE PGM ADDR TIME | | O 0 60 CONNECT TO QXOE 6D6000 | | I -30041 57013 0 60 CONNECT TO QXOE 6D6000 0.003 | | O 1 102 SELECT QXOE 6D6000 | | I -1024 51007 1 102 SELECT QXOE 6D6000 0.000 | | O 0 79 COMMIT QXOE 6D6000 | | I -1024 51007 0 79 COMMIT QXOE 6D6000 0.000 | | O 0 79 COMMIT QXOE 6D6000 | | I -1024 51007 0 79 COMMIT QXOE 6D6000 0.000 | | END OF TABLE, 8 ENTRIES DISPLAYED | | | |User: ZSTTD 4,DET | | | |System: SQL DETAIL TRACE FOR I-STREAM 1 | | PROGRAM: QXOE ECB ADDRESS: 6D6000 RDB: DB23PRD | | SQL_CODE: -30041 SQL_STATE: 57013 | | SECTION NUM: 00000 STMT NUM: 00060 STMT TYPE: CONNECT TO | | SQLCAID: SQLCA SQLCABC: 00136 SQLWARN: | | SQLERRD: 0, 0, 0, 0, 0, 198 SQLERRP: TPF0CRDA | | SQLERRML: 0 SQLERRMSG: | | | | PROGRAM: QXOE ECB ADDRESS: 6D6000 RDB: DB23PRD | | SQL_CODE: -1024 SQL_STATE: 51007 | | SECTION NUM: 00001 STMT NUM: 00102 STMT TYPE: SELECT | | SQLCAID: SQLCA SQLCABC: 00136 SQLWARN: | | SQLERRD: 0, 0, 0, 0, 0, 217 SQLERRP: TPF0CRDA | | SQLERRML: 0 SQLERRMSG: | | | | PROGRAM: QXOE ECB ADDRESS: 6D6000 RDB: DB23PRD | | SQL_CODE: -1024 SQL_STATE: 51007 | | SECTION NUM: 00000 STMT NUM: 00079 STMT TYPE: COMMIT | | SQLCAID: SQLCA SQLCABC: 00136 SQLWARN: | | SQLERRD: 0, 0, 0, 0, 0, 217 SQLERRP: TPF0CRDA | | SQLERRML: 0 SQLERRMSG: | | | | PROGRAM: QXOE ECB ADDRESS: 6D6000 RDB: DB23PRD | | SQL_CODE: -1024 SQL_STATE: 51007 | | SECTION NUM: 00000 STMT NUM: 00079 STMT TYPE: COMMIT | | SQLCAID: SQLCA SQLCABC: 00136 SQLWARN: | | SQLERRD: 0, 0, 0, 0, 0, 217 SQLERRP: TPF0CRDA | | SQLERRML: 0 SQLERRMSG: | | | | END OF TABLE, 4 ENTRIES DISPLAYED | | | +--------------------------------------------------------------------------------+
Related Information
See the TPF Application Requester User's Guide for more information about the structured query language (SQL) and the SQL trace table.