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
Steps 1 - 9 will collect data that is output to your joblog.   This joblog is collected as part of steps 10 - 15.

1. Issue CHGJOB LOG(4 00 *SECLVL) LOGCLPGM(*YES)
2. Issue CALL QSYS/QSQIBMCHK
3. Issue RCLDBXREF *CHECK

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

4. Issue STRDBG UPDPROD(*YES)
5.  WRKCFGSTS *DEV *ASP
6. Option 1=Vary on to vary on the iASP if needed and note the name for step 7
7.  SETASPGRP ASPGRP(-iaspname-)
8.  CALL QSYS/QSQIBMCHK
9.  RCLDBXREF *CHECK
Collect joblog, etc., and send in to IBM

10. ADDLIBLE QMGTOOLS

11. GO MG

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

14. Option 8 - SQL catalog
SQLINFO
15. Change Failing Job Name to * and press Enter

16. 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
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. CALL QSYS/QSQIBMCHK
3. RCLDBXREF *CHECK

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

 
Direction for transferring files to IBM if QMGTOOLS was NOT used

MustGather: Instructions for Sending Data to IBM i Support
 

[{"Type":"SW","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
15 September 2022

UID

nas8N1012164

Page Feedback