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.
4.
5.
Option 13 - Check IBM for updated QMGTOOLS
4.
Option 6 - Database menu
5.
Option 5 - Cross reference (XREF)
6. Specify a job name that is known to have errors
- Leave
- Else leave
- 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 involvedSpecify 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
MustGather: Instructions for Sending Data to IBM i Support
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 *)
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
Was this topic helpful?
Document Information
Modified date:
15 September 2022
UID
nas8N1012154