IBM Support

SQL Error Logging Facility (SELF)

News


Abstract

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

Content

 
 

Enhanced with IBM i 7.6 SF99960 Level 3 & IBM i 7.5 SF99950 Level 12: 

  • Users can view rows in SQL_ERROR_LOG added by their own user ID
  • The key used to identify duplicate rows is expanded to include the statement operation

Enhanced with IBM i 7.6 SF99960 Level 2 & IBM i 7.5 SF99950 Level 11: 

  • QSYS2.SQL_ERRORT table is pruned using the SYSIBMADM.QIBM_SELF_BY_DAYS global variable

Enhanced with IBM i 7.6 SF99960 Level 1 & IBM i 7.5 SF99950 Level 9 & IBM i 7.4 SF99704 Level 30: 

  • Logging can be ended for all jobs
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":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"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:
14 July 2026

UID

ibm16828091

Page Feedback