Troubleshooting
Problem
Once you have identified the query that is causing an issue, you can try running the same query through Run SQL Scripts from Access Client Solutions (ACS) to verify the issue can be re-created. If so, this document gives the steps on how to collect further debug information for use by the IBM i Global Support Center.
Resolving The Problem
Step 1: Create the QAQQINI file and specify debug options.
| 1. |
Open the Run SQL Script window from IBM i Access Client Solutions by doing the following:
a) Launch IBM i Access Client Solutions b) Under the Database task, click Run SQL Scripts  |
| 2. |
In the Run SQL Script window, go to Edit - Preferences - Results Tab and ensure that Open new Results in separate window is selected.
 |
| 3. |
In the Run SQL Script window, type the following:
Note: This example creates and uses the library Tnnnnnnnnn, where Tnnnnnnnnn is your case number. If you do not want to create a Tnnnnnnnnn library, change the library to the library name that you want to use. Note: If you are currently using a QAQQINI file that uses values other than *DEFAULT, talk to your Support Representative to determine whether that parameter needs to be included in the new QAQQINI file you are about to create.
CAUTION: A long running or large DBMON can cause system-wide performance issues. See the Related Information section at the end of this document for more information.
CL: CRTLIB Tnnnnnnnnn; CL: CRTDUPOBJ OBJ(QAQQINI) FROMLIB(QSYS) OBJTYPE(*FILE) TOLIB(Tnnnnnnnnn) DATA(*NO); INSERT INTO Tnnnnnnnnn.QAQQINI VALUES('MESSAGES_DEBUG','*YES', default); INSERT INTO Tnnnnnnnnn.QAQQINI VALUES('REOPTIMIZE_ACCESS_PLAN','*FORCE', default); CL: CHGQRYA QRYOPTLIB(Tnnnnnnnnn); CL: CHGJOB LOG(4 00 *SECLVL) LOGCLPGM(*YES);
CL: STRDBMON OUTFILE(TNNNNNNNNN/DBMON1) JOB(*) TYPE(*DETAIL);
Go to Run, and select All. |
| 4. | Clear your Run SQL Script window by deleting the CL and SQL statements from section 3 then run the SQL query in question. |
| 5. |
Close the result set window, delete the SQL statement, and type the following statements:
Note: This sets the QAQQINI file back to the default of QUSRSYS. If you use a different library, change the library name on the CHGQRYA command. CL: CHGQRYA QRYOPTLIB(QUSRSYS); CL: ENDDBMON JOB(*);
CL: DSPJOBLOG JOB(*) OUTPUT(*PRINT);
Go to Run, and Select All. |
| 6. | Close the Run SQL Script window. |
Step 2: Prepare the Data
| 1. | From an IBM i command line, type CRTSAVF FILE(Tnnnnnnnnn/IBMDATA) and then SAVOBJ OBJ(DBMON1) LIB(TNNNNNNNNN) DEV(*SAVF) SAVF(TNNNNNNNNN/IBMDATA) DTACPR(*MEDIUM) |
| 2. |
From the Tools menu, select Printer Output:
 Sort on the date column to find the job log for your QZDASOINIT job and then right-click and choose Download...
 Then, specify a target location:
 Make sure 'Use PDF format if available' is UNCHECKED as IBM prefers raw TEXT for ALL Spools.
|
Step 3: Send the data to your support representative.
| Preferred Method for sending the Tnnnnnnnnn/IBMDATA save file, Use QMGTOOLS | |
| Upload the job log via the Support Portal or Enhanced Customer Data Repository tool | |
| Alternate Method, including options for Blue Diamond Customers - other options |
Related Information
[{"Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001iKmAAI","label":"IBM i Db2-\u003EPerformance - Db2 for i"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Type":"MASTER"}]
Historical Number
462591814
Was this topic helpful?
Document Information
More support for:
IBM i
Component:
IBM i Db2->Performance - Db2 for i
Software version:
All Versions
Operating system(s):
IBM i
Document number:
3036093
Modified date:
11 November 2024
UID
ibm13036093
Manage My Notification Subscriptions