News
Abstract
The STRDBMON command has been enhanced to have a pre-filter parameter for the result of SQL statements on the FTRSQLCODE() command parameter.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > Add FTRSQLCODE parameter to STRDBMON
The STRDBMON command has been enhanced to have a pre-filter parameter for the result of SQL statements on the FTRSQLCODE() command parameter.
Filter by SQLCODE (FTRSQLCODE) parameter values:
- *NONE - Filtering by SQLCODE is not specified
- *NONZERO - Any non-zero SQLCODE
- *ERROR - SQLCODE < 0, the SQL statement has failed
- *WARN - SQLCODE > 0, a warning condition is indicated
- <user specified SQLCODE>
Example: Collect QQRID=1000 DBMON records for all instance of SQL failures due to lock contention:
STRDBMON OUTFILE(DBMONLIB/LOCKMON) JOB(*ALL/*ALL/QZDASOINIT) TYPE(*DETAIL) FTRSQLCODE(-913)
SQLSTATEs and SQLCODEs for Db2 for IBM i 7.1: SQL messages and codes
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
11 April 2021
UID
ibm11169296