Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 
.
.
SQL compatibility exception trace by event report (BSQTRCCC)
The following figure shows a sample of the SQL compatibility exception trace by event report.
1 BSQTRCCC: SQL COMPAT EXCEP TRC BY EVENT mm/dd/yy hh:mm:ss PAGE 1
LOCATION: DGR DATA FROM: mm/dd/yyyy hh:mm:ss
D/S GRP: DSNDGR MBR: DGR1 SQL COMPATIBILITY EXCEPTION TRACE BY EVENT TO: mm/dd/yyyy hh:mm:ss
SSID: DGR1 VER: 10.1
* PRIMAUTH: RDHJMB CONNECT: TSO CONNTYPE: TSO
ORIGAUTH: RDHJMB PLAN : DSNESPCS CORRNAME: RDHJMB
ENDUSER : RDHJMB WSNAME : TSO TRXNAME : RDHJMB
- COLLID: DSNESP
PKGNAM: DSNESM
PACKAGE VERSION:
PRECOMPILE TIME: 1991-12-19-01.01.45.70163
EXEC CNT STMT# SECT# TYPE ISSUE DESCRIPTION
-------- ------ ------ ------- ------ -------------------------------------------
2 245 1 DYNAMIC 1 DB2 9 SYSIBM.CHAR(DECIMAL-EXPR) USED
LOCATION: DGR DATA FROM: mm/dd/yyyy hh:mm:ss
D/S GRP: DSNDGR MBR: DGR1 SQL COMPATIBILITY EXCEPTION TRACE BY EVENT TO: mm/dd/yyyy hh:mm:ss
SSID: DGR1 VER: 10.1
* PRIMAUTH: RDHJMB CONNECT: TSO CONNTYPE: TSO
ORIGAUTH: RDHJMB PLAN : DSNESPCS CORRNAME: RDHJMB
ENDUSER : RDHJMB WSNAME : TSO TRXNAME : RDHJMB
- COLLID: DSNESP
PKGNAM: DSNESM
PACKAGE VERSION:
PRECOMPILE TIME: 1991-12-19-01.01.45.70163
EXEC CNT STMT# SECT# TYPE ISSUE DESCRIPTION
-------- ------ ------ ------- ------ -------------------------------------------
2 245 1 DYNAMIC 1 DB2 9 SYSIBM.CHAR(DECIMAL-EXPR) USED
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*