Troubleshooting
Problem
This document gives the steps on how to collect information for Batch jobs when debugging CQE performance or database issues.
See this TechNote for more information on Database Monitor impacts: www.ibm.com/support/docview.wss?uid=ibm10882914
Resolving The Problem
Use the following steps to collect information for Batch jobs when debugging CQE performance or database issues:
Step 1: Create the QAQQINI file.
To create the QAQQINI file that is used when collecting traces, do the following:
Note: If you are currently using a QAQQINI file that uses values other than DEFAULT, talk to your Support Representative to determine if that should be included in the new QAQQINI file you create below.
Step 2: Collect the traces.
To collect the traces, do the following:
Step 3: Use IBM iSeries Navigator to bring the joblog spooled file to your PC.
To get your spooled files off the system as a .txt file, do the following:
Step 4: Prepare the DBMON file.
To prepare the DBMON file, do the following:
Step 5: FTP the files to the PC.
To FTP the files to your PC, do the following:
Step 6: Send the information to your Support Representative.
Step 1: Create the QAQQINI file.
To create the QAQQINI file that is used when collecting traces, do the following:
| 1. | Create a copy of the QAQQINI file in QSYS. On the operating system command line, type the following: CRTDUPOBJ OBJ(QAQQINI) FROMLIB(QSYS) OBJTYPE(*FILE) TOLIB(PMRxxxxx) DATA(*NO) where PMRxxxxx is your library. Press the Enter key. |
| 2. | On the operating system command line, type the following: STRSQL Press the Enter key. Type the following statements, separately, and replace PMRxxxxx with your library from above; ensure that the first values are in uppercase letters: |
| Caution: Putting the QAQQINI file in QUSRSYS with full debug on can cause significant overhead. All of the following are internal options except MESSAGES_DEBUG and REOPTIMIZE_ACCESS_PLAN. IBM supports only external options. |
Note: If you are currently using a QAQQINI file that uses values other than DEFAULT, talk to your Support Representative to determine if that should be included in the new QAQQINI file you create below.
| INSERT INTO PMRxxxxx/QAQQINI VALUES('MESSAGES_DEBUG','*YES', default) INSERT INTO PMRxxxxx/QAQQINI VALUES('MESSAGES_COST','*BASIC', default) INSERT INTO PMRxxxxx/QAQQINI VALUES('MESSAGES_FINAL_PLAN','*BASIC', default) INSERT INTO PMRxxxxx/QAQQINI VALUES('MESSAGES_INFORMATIONAL','*BASIC', default) INSERT INTO PMRxxxxx/QAQQINI VALUES('REOPTIMIZE_ACCESS_PLAN','*FORCE', default) |
Step 2: Collect the traces.
To collect the traces, do the following:
| 1. | Submit the job with HOLD(*YES) on the SBMJOB command. |
| 2. | Find the job; for example, use the WRKSBMJOB command. |
| 3. | Note the full job name (number/user/name). It will be used in the following steps. |
| 4. | Type the following command: STRSRVJOB JOB(number/user/name) Press the Enter key. |
| 5. | Type the following command: STRDBG UPDPROD(*YES) Press the Enter key. |
| 6. | Type the following command: RLSJOB JOB(number/user/name) Press the Enter key. |
| 7. | Press F10 for a command line. |
| 8. | Type the following command: CHGQRYA JOB(NUMBER/USER/JOBNAMANE) QRYOPTLIB(PMRxxxxx) Press the Enter key. |
| 9. | Type the following command: CHGJOB LOG(4 00 *SECLVL) LOGCLPGM(*YES) Press the Enter key. |
| 10. | Type the following command: STRDBMON OUTFILE(LIBRARY/FILE) JOB(NUMBER/USER/JOBNAMANE) TYPE(*DETAIL) Press the Enter key. |
| 11. | Press F3 to Exit. |
| 12. | Press the Enter key to let the job run. |
| 13. | Re-create the problem. |
| 14. 15. |
The monitor ends when the job ends. If you have the PT1 product, collect a list of indexes and files: ANZDBF LIBL(LIB) ANZDBFKEY FILE(FILEX) |
Step 3: Use IBM iSeries Navigator to bring the joblog spooled file to your PC.
To get your spooled files off the system as a .txt file, do the following:
| 1. | Click on the Microsoft Windows Start button. |
| 2. | Click on Programs. |
| 3. | Click on IBM i Access for Windows. |
| 4. | Click on System i Navigator. |
| 5. | When iSeries Navigator opens, sign on the system that has the job log. |
| 6. | Click on Basic Operations. |
| 7. | Click on Printer Output. |
| 8. | You should now see the QPJOBLOG file for your job. If you do not see it, click on Basic Operations and select Customize this view and select Include to include another user or output queue to view. |
| 9. | When you find the file, click on it and drag it to your desktop. |
Step 4: Prepare the DBMON file.
To prepare the DBMON file, do the following:
| 1. | On an operating system command line, type the following: CRTSAVF FILE(PMRxxxxx/PMRxxxxx) Press the Enter key. |
| 2. | Type the following: SAVOBJ OBJ(DBMON) LIB(PMRxxxxx) DEV(*SAVF) SAVF(PMRxxxxx/PMRxxxxx) DTACPR(*YES) Note: If the DBMON is very large, consider using DTACPR(*HIGH). DTACPR(*HIGH) will cause the SAVOBJ command to take longer and potentially use more CPU; however, the end result will be a smaller SAVF (which will likely reduce the transfer time) than if you had used DTACPR(*YES). Press the Enter key. |
Step 5: FTP the files to the PC.
To FTP the files to your PC, do the following:
| 1. | From a command window, type FTP MYAS400 and press the Enter key (where MYAS400 is your system's name). |
| 2. | Log in with your IBM OS/400 user profile and password. |
| 3. | Type bin, and press the Enter key. |
| 4. | Type cd PMRxxxxx, and press the Enter key. |
| 5. | Type get PMRxxxxx.savf PMRxxxxx.savf, and press the Enter key. |
Step 6: Send the information to your Support Representative.
| o | Debug joblog - it is the file on your desktop that was moved from iSeries Navigator in Step 3. |
| o | PMRxxxxx.savf - it is the file in c:\ that was moved from FTP in Step 5. For ease of use, compress all of the attachments into a single ZIP/RAR file. The ZIP/RAR file should be named 'xxxxx.yyy.zzz.debuglogs.zip' (or .rar) where xxxxx = your PMR number, yyy = your branch office number, and zzz = your country code (for example, 12345.L6Q.000.debuglogs.zip, if your full PMR number is 12345,L6Q,000). If the data you will be submitting is less than 20 MBs and you would like to e-mail the data to IBM, use the following information. You can send and e-mail to ibmi_support@ecurep.ibm.com, with the PMR number in the Subject Line, using the instructions from the following URL: http://www-01.ibm.com/software/support/exchangeinfo.html#email If the data you will be submitting is greater than 20 MBs, you will need to FTP the data to IBM. Refer to the following URL for complete instructions: http://www-01.ibm.com/software/support/exchangeinfo.html#ecurep o In Step 1: Use ftp ftp.ecurep.ibm.com, if you are outside of the United States or ftp testcase.boulder.ibm.com, if you are within the United States. o In Step 4: Use cd /toibm/os400 |
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"Db2 for i","Platform":[],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Historical Number
336946456
Was this topic helpful?
Document Information
Modified date:
18 December 2019
UID
nas8N1016113