SMF DB2 fields of IFCID 53

QW0053_SQLCODE

(Integer)

SQLcode

outcome

Contains the SQL return code

0 Successful execution (though there might have been warning messages). Positive Successful execution, but with a warning condition or other information. Negative Error condition. For the specific meanings of SQL return codes, see the IBM manual: DB2 10 for z/OS Codes.

QW0053_SQLERRD1

(Integer)

SQLerrd1

For a sensitive static cursor, contains the number of rows in a result table when the cursor position is after the last row (that is, when SQLCODE is equal to +100)

On successful return from an SQL procedure, contains the return status value from the SQL procedure. SQLERRD1 can also contain an internal error code.

QW0053_SQLERRD2

(Integer)

SQLerrd2

For a sensitive static cursor, contains the number of rows in a result table when the cursor position is after the last row (that is, when SQLCODE is equal to +100)

SQLERRD2 can also contain an internal error code.

QW0053_SQLERRD3

(Integer)

SQLerrd3

Contains the number of rows that qualified to be deleted, inserted, or updated after a DELETE, INSERT, UPDATE, or MERGE statement

For the contents after other SQL statements, IBM manual: DB2 10 for z/OS SQL Reference. When an error is encountered in parsing a dynamic statement, or when parsing, binding, or executing a native SQL procedure, SQLERRD(3) contains the line number where the error was encountered. The sixth byte of SQLCAID must be ‘L’ for this to be a valid line number. This value is meaningful only if the statement source contains new line control characters. This information is not returned for an external SQL procedure.

QW0053_SQLERRD4

SQLerrd4

cfp1

Generally, contains timerons, a short floating-point value that indicates a rough relative estimate of resources required

It does not reflect an estimate of the time required. For a particular statement, this number can vary with changes to the statistics in the catalog. It is also subject to change between releases of DB2 for z/OS.

QW0053_SQLERRD5

(Integer)

SQLerrd5

Contains the position or column of a syntax error for a PREPARE or EXECUTE IMMEDIATE statement

QW0053_SQLERRD6

(Integer)

SQLerrd6

Contains an internal error code

QW0053_SQLERRM

(EGNX)

SQLerrm

Contains one or more tokens, separated by X’FF’, that are substituted for variables in the descriptions of error conditions

It might contain truncated tokens. A length of 70 bytes indicates a possible truncation.

QW0053_SQLERRP

(EGNX)

SQLerrp

Eight-character additional DB2 status information

QW0053_SQLSTATE

(EGNX)

SQLstate

Five-character alphabetic DB2 status

QW0053_SQLWARN

(EGNX)

SQLwarn

SQL warnings

An eleven-character field. Each position contains an alphabetic code for a particular warning condition. For the exact meanings of the codes, see the IBM manual: DB2 10 for z/OS SQL Reference.

QW0053CID

QCmdID

Query instance ID

QW0053LN

(EGNX)

Loc

cs4

Location name

QW0053PC

(EGNX)

Collection

Package collection ID

QW0053PN

(EGNX)

Prog

sourceServiceName

Program name

QW0053QID

QInstID

Query instance ID

QW0053SN

(Integer)

Stmt#

Statement number

QW0053SQ

SQLCA

SQLCA contents, formatted as a 136-byte dump

See also the QW0053_SQLxxxxx fields at the top of this table.

QW0053TS

Token

Precompiler time stamp, formatted as a 16-digit hexadecimal token

QW0053TST

TimeStmp

Precompiler time stamp, formatted as a date and time in accordance with the TIME statement parameters