IBM Support

Database Host Server Fails to Start Because Routing Entry That Is Not Correct

Troubleshooting


Problem

Incorrect routing entry on subsystem description causes the database host server daemon job to fail to start.

Resolving The Problem

The database host server daemon job, QZDASRVSD, fails to start when an incorrect compare value is entered on the routing entry. 

The QSERVER Subsystem contains a routing entry for QZDASRVSD. If the routing entry is missing or deleted, a new one will be automatically created the next time STRHOSTSVR *DATABASE (or STRHOSTSVR *ALL) is issued. The correct routing entry is as follows:
Seq Nbr
Program
Library
Compare Value
Start Pos
600
QZDASRVSD
QSYS
'QZDASRVSD'  
1

It is possible to manually create the routing entry or to edit the existing routing entry as follows:

ADDRTGE SBSD(QSERVER) SEQNBR(100) CMPVAL('QZDASRVSD' 1) + PGM(QSYS/QZDASRVSD) CLS(QSYS/QPWFSERVER)

CHGRTGE SBSD(QSERVER) SEQNBR(600) CMPVAL('QZDASRVSD' *SAME)

The values shown here are correct and do not cause any problems. However, if the routing entry is manually created or changed, and an incorrect compare value is entered, the QZDASRVSD job fails to start. In this scenario, no obvious error messages are generated.

To confirm that this misconfiguration is causing the failure, the following steps can be taken:

Review the routing entry as follows:
  1. On the operating system command prompt, type the following:
    DSPSBSD QSERVER
  2. Select Option 7 to work with routing entries, and press the Enter key.

To generate a job log:
  1. Place the QPWFSERVER job queue on hold; run the command:
    HLDJOBQ QPWFSERVER
  2. Submit the daemon job to the QPWFSERVER job queue; run the command:
    STRHOSTSVR *DATABASE
  3. To view the submitted job:
    WRKJOBQ QPWFSERVER
  4. Select Option 5 to work with the job queue entries, and press the Enter key.
  5. Select Option 5 to work with the QZDASRVSD job, and press the Enter key.
  6. Force a job log to be generated when the job fails:
    Select Option 40 to change the job.
    Press F10 for more parameters
    Page down one time.
    Under Message Logging, change the Text line from *NOLIST to *SECLVL, and press the Enter key. You are on the Work with Job screen again.
    Note the information at the top of the screen: Job: QZDASRVSD User: QUSER Number: ??????
To generate a job trace, do the following:
  1. STRSRVJOB JOB(nnnnnn/QUSER/QZDASRVSD)
    Replace nnnnnn with the job number from the top of the Work with Job screen.
  2. STRDBG UPDPROD(*YES)
  3. TRCJOB SET(*ON) MAXSTG(16000)

To collect the job log and job trace, do the following:
  1. Release the held job queue:
    RLSJOBQ QPWFSERVER
    You might get a break message because your emulation session is servicing a job that is about to be released. In that case, press enter to allow the job to be released.
  2. TRCJOB SET(*OFF) OUTPUT(*PRINT)
  3. ENDDBG
  4. ENDSRVJOB

To find and view the job trace, do the following:
WRKSPLF
Find the job trace, it is named QPSRVTRC

Following is a section of the job trace:

09:41:13.375 0000000C 000001 RETURN QSCWMINT QSYS 0040 0073 02 0.000 0 0 0 0
09:41:13.375 0000000C 000002 RETURN QWTPIIPP QSYS 031E 0914 01 0.000 0 0 0 0
09:41:13.375 0000000C 000003 PTRMTPP *N *N 00 0.000 0 0 0 0
09:41:13.375 0000000C 000004 CALL QWTPITPP QSYS 0001 0076 01 0.005 0 0 2 0
09:41:13.384 0000000C 000005 CALL QSYSAUDR QSYS 0001 027E 02 0.000 0 0 0 0
09:41:13.384 0000000C 000006 CALL QJOSNDJE QSYS 0001 0168 03 0.000 0 0 0 0
09:41:13.384 0000000C 000007 RETURN QSYSAUDR QSYS 027F 012F 02 0.000 0 0 0 0
09:41:13.384 0000000C 000008 RETURN QWTPITPP QSYS 0077 0355 01 0.004 0 1 0 0
09:41:13.399 0000000C 000009 CALL QDMFCLSE QSYS 0001 0249 02 0.000 0 0 0 0
09:41:13.399 0000000C 000010 RETURN QWTPITPP QSYS 0356 0377 01 0.001 0 1 0 0
09:41:13.408 0000000C 000011 CALL QCNSTERM QSYS 0001 081F 02 0.000 0 0 0 0
09:41:13.410 0000000C 000012 RETURN QWTPITPP QSYS 0378 0380 01 0.000 0 0 0 0

The program function QDMFCLSE in line 9 indicates that the job is being ended and is the only clue found in the job trace.

To find and view the QZDASRVSD job log:
  1. WRKJOB JOB(nnnnnn/QUSER/QZDASRVSD)
    Replace nnnnnn with the job number from earlier.
  2. Select Option 4 to work with spooled files.
  3. Select Option 5 to display the spooled file.
The following is a typical error message received when the routing entry was not correct in the active QSERVER subsystem description:

CPC1117 Completion 50 02/21/01 09:41:13 QWTMMERH QSYS 009A *EXT *N
Message . . . . : CPC1117 Routing data does not match routing entry.
Recovery . . . : Either change the routing data or add a routing entry to
match the routing data in the subsystem description (ADDRTGE command).

[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Host Servers","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Historical Number

22404915

Document Information

Modified date:
24 June 2021

UID

nas8N1017497

Page Feedback