Troubleshooting
Problem
This document contains information on using the QRWOPTIONS IBM DRDA/DDM debug data area.
Resolving The Problem
Data area QRWOPTIONS may be created on the Target/Server/AS system to facilitate the collection of IBM DRDA/DDM debug materials.
The Target/Server/AS system is the IBM i conversation partner where the QRWTSRVR jobs are allocated for the server-side of the conversation.
The following information can be collected via the data area:
The following information can be collected via the data area:
- Spooled job log before job(s) recycle
- Generate DSPJOB spooled file before job(s) recycle
- Job trace of the DDM/DRDA job(s)
- Start debug for the DDM/DRDA job(s)
- Set a QAQQINI file library
- Shadow debug options from AR job
- Collect database monitor for DDM/DRDA job(s)
The data area must be named QRWOPTIONS, it must reside in QGPL, and the type of data area must be *CHAR. All data entered must be entered in uppercase in CCSID 37 or CCSID 500.
The data area is created with the following command:
CRTDTAARA DTAARA(QGPL/QRWOPTIONS) TYPE(*CHAR) LEN(48)
Data area structure:
|
Columns
|
Contents
|
| Data area format | |
| 1-15 | Client IP address in dotted decimal format for use when I is specified as a switch value (ignored otherwise). |
| 16 | Reserved area ignored by server (can contain a character for human usability) |
| 17–26 | User profile name for comparison when U is specified as a switch value (ignored otherwise) |
| 27 | Switch to cause job log to be kept if set to A, I or U (see notes 1 and 2) |
| 28 | Switch to cause DSPJOB output to be printed if set to A, I or U (see notes 1 and 2) |
| 29 | Switch to cause job to be traced if set to A, I or U (see notes 1 and 2). |
| 30 | Switch to cause debug to be started for job if set to A, I or U (see note 1). |
| 31 | Switch to invoke the Change Query Attributes (CHGQRYA) command with a QRYOPTLIB value if set to A, I or U. The QRYOPTLIB value is extracted from columns 39-48 which must contain the name of the library containing the proper QAQQINI file (see Note 1) Note: If an I or A is specified in this column, QUSER must have *JOBCTL special authority for it to take effect. |
| 32 | Switch to shadow client debug options if set to A, I or U (see note 1). |
| 33 | Switch to use old TRCJOB instead of new STRTRC for job trace if set to T and column 29 requests tracing. Note: If this column is set to T, TRCJOB will be used for the job trace. Set it to blank or S to use STRTRC. |
| 34 | Set this to N to suppress CPI3E34 messages in the history log (This is available in OS/400® V5R1 only with PTF SI02613) |
| 35 | Switch to cause database monitor to be collected if set to A, I or U (see note 1 and 4). Requires new function PTFs SJ001585 for 7.5 or SJ001586 for 7.4. |
| 36–38 | Reserved |
| 39–48 | General data area (contains library name if the Change Query Attributes (CHGQRYA) command is triggered by the appropriate value in column 31) |
Notes:
1. These are the switch values that activate the function corresponding to the column in which they appear:
- A - activates the function for all uses of the server job.
- I - activates the function if the client IP address specified in columns 1-15 matches that used on the connect attempt.
- U - activates the function if the user ID specified in columns 17-26 matches that used on the connect attempt.
2. To find the spooled files resulting from this functionality, use:
WRKSPLF SELECT(<DDM_USRPRF>)
...where "<DDM_USRPRF>" is the USRPRF that was used for the DDM/DRDA connection.
|
File
|
Device or queue
|
User data
|
| File list from WRKJOB user-profile/QPRTJOB command | ||
| QPJOBLOG | QEZJOBLOG | QRWTSRVR |
| QPDSPJOB | PRT01 | |
| QPSRVTRC | PRT01 |
3. The file containing the special DRDA subroutine trace will be created in library QGPL, with a name in this format: QRWDBmmddy, where mm represents the month, dd the day, and y the last digit of the year in which the trace was recorded. Not all system programs are traced.
4. The database monitor will be created as a file in the QGPL library with the following naming convention: QRWTSRVR jobs will create files with names QRWTnnnnnn and QDBMSRVR jobs will create files with names QDBMnnnnnn where nnnnnn is the job number.
Examples:
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (27 1)) VALUE('A') /* keep All QRWTSRVR joblogs */
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (29 1)) VALUE('A') /* cause All QRWTSRVR jobs to be traced */
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (30 1)) VALUE('A') /* start debug */
To turn off the logging of CPI3E34 messages in the history log:
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (34 1)) VALUE(N)
To print the joblog of the QRWTSRVR job for user QBRMS only:
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (17 10)) VALUE('QBRMS ')
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (27 1)) VALUE('U')
Wildcards ('*') are not resolved.
To print the joblog and a display job for connections coming from IP address 1.2.3.4:
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (27 1)) VALUE('I')
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (28 1)) VALUE('I')
CHGDTAARA DTAARA(QGPL/QRWOPTIONS (1 16)) VALUE('1.2.3.4')
Consideration for TRCJOB and STRTRC:
For the TRCJOB and STRTRC functions of data area to be 100% functional, you need to change the job description QGPL/QDFTSVR to specify that inquiry messages be replied using the system reply list entries if possible. If this is not done, the requested trace may not print as documented.
To change the job description, do the following:
| 1. | CHGJOBD JOBD(QGPL/QDFTSVR) INQMSGRPY(*SYSRPYL) |
| 2. | ADDRPYLE SEQNBR(4072) MSGID(CPA4072) RPY(NOMAX) |
| 3. | End any QRWTSRVR prestart jobs that have a status of PSRW when viewed in : WRKACTJOB SBS(QUSRWRK) JOB(QRWTSRVR) ... <F14> |
When done tracing, remove the reply list entry from the user system when you remove the data area:
| 1. | CHGJOBD JOBD(QGPL/QDFTSVR) INQMSGRPY(*RQD) |
| 2. | RMVRPYLE SEQNBR(4072) |
| 3. | Restart QRWTSRVR prestart jobs as previous. |
Related Information
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Component":"Data Access","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Historical Number
23453033
Was this topic helpful?
Document Information
Modified date:
08 August 2025
UID
nas8N1017342