QZDASOINIT

From MidrangeWiki
Revision as of 15:55, 29 March 2012 by Bdietz (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

QZDASOINIT is the jobname for the database SQL server jobs on the System i.

These jobs are used to serve SQL to JDBC and ODBC client applications.

Changing Memory Pools

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/ODBC) 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

(created by Bryan Dietz)

Categories

This article is a stub. You can help by editing it.