RE: QZDASOINIT impact

[Bryan Dietz <BDietz@xxxxxxxxxx>]

This is cut from a document I use:


Substitute (your_lib) with the library you want to contain the subsystem
i.e. QGPL.

WRKSHRPOOL and setup a shared pool with appropriate amout of menory and
activity levels
use the shrpool name in the step below.

Create Subsystem Description:
CRTSBSD SBSD(your_lib/ODBC) POOLS((1 *SHRPOOLx))
        TEXT('Subsystem for ODBC jobs')

Duplicate the Default ODBC class:
CRTDUPOBJ OBJ(QPWFSERVER) FROMLIB(QSYS)
      OBJTYPE(*CLS) TOLIB(QSYS)  NEWOBJ(QPWFODBC)

Change its attributes:
CHGCLS CLS(QSYS/QPWFODBC ) RUNPTY(35)      **Or whatever RUNPTY you need**

Add a routing entry:
ADDRTGE SBSD(your_lib/ODBC) SEQNBR(1) CMPVAL(*ANY)
      PGM(QCMD) CLS(QSYS/QPWFODBC) POOLID(1)

Add a pre start Job Entry:
ADDPJE SBSD(your_lib/WEBODBC) PGM(QZDASOINIT) INLJOBS(21)
       THRESHOLD(20) ADLJOBS(5) CLS(QSYS/QPWFODBC)

Start the subsystem:
STRSBS SBSD(your_lib/ODBC)

You will need to add the starting of this subsystem to the system start up
program.

=======================

The next steps are in iSeries Navigator:

Navigate <yoursystem><Network><Servers><iSeries Access>

Right Click on DataBase and select [Properties]
Click on the [Subsystems] tab
Click [Specific Clients] and click [Add]

In the Add Client screen: fill in the details

Click OK on each of the screens to save your changes and exit iSeries
Navigator.

Changes take effect immediately.

To back-out changes:
>From iSeries Navigator
Remove the selection from above,
then end the ODBC subsystem.
The jobs will then run the default QUSRWRK subsystem



**I used V5R3 of iSeries Navigator**



----------------------------
Bryan Dietz
Aktion Associates


midrange-l-bounces@xxxxxxxxxxxx wrote on 03/29/2005 09:18:50 AM:

> Is there any sort of IBM document which a link could be provided on the
> granularization of these QZDASOINIT jobs?  I've called support line
> multiple times about this and they haven't offered any information as is
> being presented here.
>
> TIA!
>
> Justin C. Haase - iSeries System Administrator