IBM Support

MustGather: SQ Catalogs

Troubleshooting


Problem

This document describes what to collect for problems with the various SQL catalog tables.

Resolving The Problem

For issues concerning SQL catalog issues, this document includes the recommended data collection for debug.
This is by no means all inclusive; however, it is meant as a starting point for document collection.

If you encounter an SQL catalog issue collect the following information by using either method A or method B.
 
Method A - QMGTOOLS
 
a. ADDLIBLE QMGTOOLS

b. GO MG

c. Option 13 - Check IBM for updated QMGTOOLS
 
d. Option 6 - Database menu

e. Option 8 - SQL catalog
 
New Catalog Collection screen shot
 
-Update Failing Job Name, if applicable.
 
- Provide the iASP name, if applicable.
       - if you are using one or more, *ALL is an option.    Note the iASP has to be AVAILABLE to retrieve information.
 
Press Enter.
 
f. Specify the Case number and specify FTP option
 
     Anonymous is no longer allowed (GDPR) - Supported FTP options (search for FTP Type)
 
 
NOTE: If *NO is used for FTP then you must manually send to IBM via:
 
 
QMGTOOLS_IFS
 
 
You are done if you used QMGTOOLS - update the Case that the data has been collected and sent uploaded to Case.
 
 
 
 
 
Method B - Manual Collection


PTF information:

1. IBM i release of system (in other words, IBM i 7.3, IBM i 7.4, and so on)
2. WRKPTFGRP and F6 to get a QSYSPRT spool file
3. DSPPTF OUTPUT(*PRINT)

Data collection:

1. Log off and back on to get a clean job log.
2. Catalog checks:     

Via command line:

      CALL QSYS/QSQIBMCHK
 
      CALL QSQSYSIBM 'CHECKONLY'
 
Via Run SQL Scripts:   (change current timestamp as needed)
 
SELECT MESSAGE_TIMESTAMP,FROM_USER,FROM_JOB,MESSAGE_TEXT
     FROM TABLE (QSYS2.HISTORY_LOG_INFO(START_TIME => 'current timestamp'))
   WHERE FROM_PROGRAM = 'QSQSYSIBM'
       OR FROM_PROGRAM = 'QSQSIBMUTL'
       OR FROM_PROGRAM = 'QDBXREF2'
         ;

3. System job QDBSRVXR2 information: 
 

    WRKJOB JOB(QDBSRVXR2) OPTION(*SPLF)

     - we'll want each joblog

    DSPJOBLOG JOB(QDBSRVXR2) OUTPUT(*PRINT)

    (repeat step 3 for each iASP as needed)

Perform steps 4-9 only if catalog problems are on an iASP:

4. STRDBG UPDPROD(*YES)
5. WRKCFGSTS *DEV *ASP
6. Option 1=Vary to vary on the iASP.
7. SETASPGRP ASPGRP(iASP NAME)
8. CALL QSYS/QSQIBMCHK
9. RCLDBXREF *CHECK
10. DSPJOBLOG * *PRINT


MustGather: Instructions for Sending Data to IBM i Support
 

[{"Type":"SW","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CQMAA2","label":"IBM i Db2-\u003EDatabase Cross Reference"},{"code":"a8m0z0000000CHbAAM","label":"IBM i Db2-\u003EMustGather Database"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Version(s)"}]

Historical Number

N1012164

Document Information

Modified date:
20 November 2025

UID

nas8N1012164

Page Feedback