Troubleshooting
Problem
This document describes the necessary information that needs to be collected to aid in quicker resolution of hung jobs (etc.) for
IBM i database issues.Symptom
Hung Job, job does not appear to be doing anything, etc.
Resolving The Problem
For issues concerning hung jobs that appear to be in database code, 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.
NOTE: Before running below steps, please make sure the following PTF for APAR MA49489 is applied to the system:
V7R4: MF69518
V7R3: MF69517
V7R2: MF69516
Database Hung Job specific MustGather information
If you encounter a job in a database function / code that appears to be hung and will not end, collect the following information using either method A or method B as it is related to the issue:
| Method A - QMGTOOLS |
MustGather: How to obtain and Install QMGTOOLS and keep it current
Data collection:
1.
ADDLIBLE QMGTOOLS2.
GO MG3.
option 13 - Check IBM for updated QMGOOLS4.
option 6 - Database menu5.
option 9 - Hung job
6. Put in job information for the hung job and press enter.
7. Specify the Case number and specify FTP option.
Anonymous is no longer allowed (GDPR) - Supported FTP options (Search for FTP Type)
Use
NOTE: If
Use
*STDFTP for standard FTP / *BDFTP for Blue Diamond Customers / *NO to not FTP.NOTE: If
*NO is used to FTP then you must manually send the IBM via:
| Method B - Manual Collection |
PTF information and Doc collection:
1. Version, release, and modification level of system (in other words, V7R1M0, V7R2M0, and so on)
2. WRKPTFGRP and F6 to get a QSYSPRT spool file
3. DSPPTF OUTPUT(*PRINT)
4. DSPJOBLOG JOB(-job number-/-job user-/-job name-) OUTPUT(*PRINT)
NOTE: Replace job number/job user/job name with job information of job that is hung
5. CRTOUTQ OUTQ(-LIB-/PMRyyyyy)
NOTE: Replace LIB with the user's library name and yyyyy is the first portion of the PMR number
6. OVRPRTF FILE(QPCSMPRT) OUTQ(-LIB-/PMRyyyyy) MAXRCDS(*NOMAX)
7. CHGOUTQ OUTQ(-LIB-/PMRyyyyy) MAXPAGES(*NONE)
8. CHGJOB OUTQ(-LIB-/PMRyyyyy)
9. STRSST and sign in with SST ID and PW
10. Option 1, Start a service tool, and press the Enter key,
11. Option 4, Display/Alter/Dump, and press the Enter key,
12. Option 2, Dump to printer, and press the Enter key,
13. Option 2, Licensed Internal Code (LIC) data, and press the Enter key,
14. Option 14, Advanced analysis, and press the Enter key,
15. SERVICEDOCS from the list, and press the Enter key,
16. Leave OPTIONS blank, and press the Enter key,
Note: By default, the SERVICEDOCS macro no longer collects the LOCKINFO information.
If you need to collect the lock information also, please enter one of the following OPTIONS:
-lock to collect the lockinfo TABLE
-lockd to collect the lockinfo TABLE = D
17. The next screen asks for a Dump Title.
You must give it a title that does not contain the name and number of the hung job (for search reasons)
Increase the Through Page to 9999999.
After the title and Through Page are set, press the Enter key.
18. After pressing the Enter key, you will immediately see the Dump to printer successfully submitted message at the bottom of the screen.
NOTE: This does not mean that the dump is done; exiting SST before it is done will cause it to be incomplete. To determine when the dump is done, you should do the following:
19. Press F12 back to the Display/Alter/Dump Output Device screen (press F12 four times).
20. Option 7. Display dump status.
21. Do not exit the service tools until the Dump requests not complete is 0 (F5 to refresh status)
NOTE: The spooled file will be named QPCSMPRT
** All spool files generated from above steps needs to be sent to IBM. **
| Direction for transferring files to IBM if MGTOOLS was NOT used |
Refer to TechNote doc - MustGather: Instructions for Sending Data to IBM i Support - http://www.ibm.com/support/docview.wss?uid=nas8N1019224
[{"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":"a8m3p000000LRY8AAO","label":"IBM i Db2-\u003EHang \/ Hung \/ Stuck"},{"code":"a8m0z0000000CHbAAM","label":"IBM i Db2-\u003EMustGather Database"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Historical Number
N1021320
Was this topic helpful?
Document Information
Modified date:
15 September 2022
UID
nas8N1021320