News
Abstract
The QIBM_SYSIXADV_BY_DAYS global variable indicates the number of days to keep a row in the QSYS2.SYSIXADV table after the most recent update time.
The index advisor adds rows to the QSYS2.SYSIXADV table. To prevent accumulation of data in this table, Db2 for i will automatically delete (or prune) rows based on the value of the QIBM_SYSIXADV_BY_DAYS global variable. The age of a row is based on the value of the LAST_ADVISED column.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > SYSIBMADM.QIBM_SYSIXADV_BY_DAYS global variable
For complete detail, visit this IBM Documentation page: QIBM_SYSIXADV_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"}]
Was this topic helpful?
Document Information
Modified date:
07 October 2025
UID
ibm17246656