Troubleshooting
Problem
This document contains the steps required to end the current database prestart jobs and prevent new jobs from starting.
Resolving The Problem
The command to end the server daemon and also end all PJs that service existing database connections (QZDASOINIT, QZDASSINIT, and QZDAINIT) is:
ENDHOSTSVR SERVER(*DATABASE) ENDACTCNN(*DATABASE)
When the jobs are to be started again, the STRHOSTSVR and STRPJ commands can be used.
The remainder of this document is focused on an alternate method of preventing new database host server connections from starting in the default SBS.
IBM i database host server prestart jobs can be ended using the following command:
ENDPJ SBS(QUSRWRK) PGM(QZDASOINIT) OPTION(*IMMED)
If after that command is run, new requests for connections are received, new QZDASOINIT jobs will start as BCI (batch immediate) jobs in QSERVER (the subsystem in which the database host server daemon job, QZDASRVSD, runs).How can this behavior be prevented?
The behavior noted previously is the correct, default behavior for the database host server; however, there are several ways to change this behavior.
One option is to change the alternate action for the host server to take when prestart jobs are not available. Customize the IBM i database host server job to reject requests that are received during the time prestart jobs are not active:
- Start IBM Navigator for i
- Expand "Network".
- Expand "Servers".
- Click "IBM Host Servers". A list of IBM host servers is shown in the right pane of the window.
- Right-click "Database" and select "Subsystem Routing".
- Select "All Clients".
- Set "Allow Rollover" to "Reject".
- Save the changes.
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Component":"Host Servers","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Historical Number
391825917
Was this topic helpful?
Document Information
Modified date:
21 January 2025
UID
nas8N1015365