IBM Support

SQL Error Logging Facility (SELF)

News


Abstract

The SQL Error Logging Facility (SELF) provides a new and different technique on Db2 for i to understand, study, and resolve SQL errors and warnings.

Content


Enhanced with IBM i 7.5 SF99950 Level 5 & IBM i 7.4 SF99704 Level 26:
  • Logging can be requested for all error SQLCODEs (*ERROR), all warning SQLCODEs (*WARN), or all errors and warnings (*ALL)
  • SQL_ERROR_LOG includes thread ID

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;and future releases"}]

Document Information

Modified date:
06 October 2023

UID

ibm16828091