IBM Support

QSYS2.ANALYZE_CATALOG

News


Abstract

he ANALYZE_CATALOG table function returns one row for each inconsistency it finds in the database catalog, returns rows that indicate the current database cross reference server status, or returns one or more rows that indicate whether maintenance for SQL services is in progress.

Content

 

Enhanced with IBM i 7.6 SF99860 Level 2 and IBM i 7.5 SF99950 Level 11:

  • Add support for the SQL SERVICES option 

Enhanced with IBM i 7.4 SF99704 Level 10 and IBM i 7.3 SF99703 Level 22:

  • Add support for the DBXREF SERVER option 

analyze the health of the database cross reference
 

For complete detail, visit this IBM Documentation page: ANALYZE_CATALOG table function

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]

Document Information

Modified date:
05 October 2025

UID

ibm16172935