IBM Support

MustGather: System Cross-Reference File Problems

Troubleshooting


Problem

This document outlines what to collect when a cross-reference file problem on your IBM i is occurring.

Resolving The Problem


This document outlines what to collect when a cross-reference file problem is occurring. The following must be collected before an attempt is made to fix the problem. You can collect the information using either method A or method B.
 
Method A - QMGTOOLS


Data collection:

1. ADDLIBLE QMGTOOLS
2. GO MG
3. Option 13 - Check IBM for updated QMGTOOLS

4. Option 6 - Database menu

5. Option 5 - Cross reference (XREF)
XREFINFO
6. Specify a job name that is known to have errors
  - Leave Failing Job Name of * if the current job reported the problem.
  - Else leave Failing Job Name of *NONE if you don't have a specific job log to send in.
 
  Specify a file name that is known to have problems (if applicable)
  Specify the journal used if file used above is journaled (if applicable)
  Specify the iASP Name if an iASP is involved
  Specify the date and time of the error.  Use DSPJOB OPTION(*DFNA) and page down once for values to use for Date format, Date separator, Time separator.
7. 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 data to IBM via
MustGather: Instructions for Sending Data to IBM i Support 
QMGTOOLS IFS
Method B - Manual Collection

PTF information:
1. Version, release, and modification level of system (in other words, V7R2M0, etc.)

2. WRKPTFGRP (then F6 to get a QSYSPRT spool file)

3. DSPPTF OUTPUT(*PRINT)

Data collection

1. Document your steps and any noted failures.

2. All job logs that experienced a problem. To spool the joblog:

DSPJOBLOG JOB(-job number-/job user-/-job name-) OUTPUT(*PRINT)

3. Any spooled files created by QDBSRVXR or QDBSRVXR2 jobs.

4. DSPJOB JOB(QDBSRVXR) OUTPUT(*PRINT)

5. DSPJOB JOB(QDBSRVXR2) OUTPUT(*PRINT)

6. DSPJOB JOB(SCPF) OUTPUT(*PRINT)

7.  DSPJOBLOG JOB(QDBSRVXR) OUTPUT(*PRINT)

8. DSPJOBLOG JOB(QDBSRVXR2) OUTPUT(*PRINT)

9. DSPJOBLOG JOB(SCPF) OUTPUT(*PRINT)

10. DSPLOG LOG(QHST) PERIOD((*AVAIL *BEGIN)) OUTPUT(*PRTSECLVL)

11. DMPSYSOBJ OBJ(QDBXREFQ*) CONTEXT(QSYS) TYPE(0A) SUBTYPE(C4) SPACE(0 *)

Note: If the problems are occurring on an IASP, do a SETASPGRP prior to DMPSYSOBJ

12. DMPSYSOBJ OBJ(QDBX_DEQA) CONTEXT(QSYS) TYPE(19) SUBTYPE(EE)

Note: If the problems are occurring on an IASP, do a SETASPGRP prior to DMPSYSOBJ

13. Issue RCLDBXREF OPTION(*CHECK)

Note: If the problem occurs on an Independent ASP Group, do a SETASPGRP prior to running this

14. Issue DSPJOBLOG OUTPUT(*PRINT) to create spool file

15. VLOGs (LICLogs)

A) Issue the STRSST command.
B) Select Option 1. Start a service tool
C) Select Option 5. Licensed Internal Code log
D) Select Option 2. Dump entries to printer from the Licensed Internal Code log
E) Select Dump Option 1 1=Header
F) Press Enter.
G) Select Dump Option 3 3=Header and entire entry
H) Specify the date and time of 10 minutes before and 10 minutes after the problem occurred.
I) Press Enter.
J) Press F12 to exit.
K) Select Option 7 Display the status of the Licensed Internal Code log.
L) Refresh until Dump requests not complete is zero.

Collection steps if known file name / library

1. DMPOBJ OBJ(-your IBM i library-/-your IBM i file-) OBJTYPE(*FILE)

Note: If the problems are occurring on an IASP, do a SETASPGRP prior to DMPOBJ.

2. If journaling is being used on the file, ensure the receivers that span the problem time frame are saved.

3. DMPSYSOBJ OBJ(QDBDBROBJ*) CONTEXT(-your IBM i library-) TYPE(19) SUBTYPE(D4)

Note: If the problems are occurring on an IASP, do a SETASPGRP prior to DMPSYSOBJ



Collection steps if an iASP is involved
Replace nnn with the primary iASP number

1. DSPJOB JOB(QDBXnnnXR) OUTPUT(*PRINT)

2. DSPJOB JOB(QDBXnnnXR2) OUTPUT(*PRINT)

3. DSPJOBLOG JOB(QDBXnnnXR) OUTPUT(*PRINT)

4. DSPJOBLOG JOB(QDBXnnnXR2) OUTPUT(*PRINT)

5. iASP Vary on job log
6. SETASPGRP to the IASP name

7. DMPSYSOBJ OBJ(QDBXREFQ*) CONTEXT(QSYS00nnn) TYPE(0A) SUBTYPE(C4) SPACE(0 *)
 
Direction for transferring files to IBM if QMGTOOLS was NOT used

MustGather: Instructions for Sending Data to IBM i Support

 

[{"Type":"MASTER","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 Versions"}]

Historical Number

N1012154

Document Information

Modified date:
15 September 2022

UID

nas8N1012154