IBM Support

SYSIBMADM.QIBM_SQEDEBUG_BY_DAYS global variable

News


Abstract

The QIBM_SQEDEBUG_BY_DAYS global variable indicates the number of days to keep integrated file system (IFS) directories that were created by the SQL query engine that contain debug information primarily for use by IBM service.

This global variable controls removal of directories that the SQL query engine writes within the /QIBM/UserData/OS400/SQE directory. To prevent accumulation of data in this directory, Db2 for i will automatically remove (or prune) directories and their contents based on the value of the QIBM_SQEDEBUG_BY_DAYS global variable. The /QIBM/UserData/OS400/SQE and /QIBM/UserData/OS400/SQE/ERRORS directories are not removed. The age of a directory is based on the value of the OBJECT_CHANGE_TIMESTAMP column returned by QSYS2.IFS_OBJECT_STATISTICS.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates >  Db2 for i Database Engineer (DBE) Enhancements  > SYSIBMADM.QIBM_SQEDEBUG_BY_DAYS global variable
 
 
For complete detail, visit this IBM Documentation page: QIBM_SQEDEBUG_BY_DAYS global variable
 

[{"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":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.5.0;and future releases"}]

Document Information

Modified date:
14 July 2026

UID

ibm17278294

Page Feedback