Problem solve Get help with specific problems with your technologies, process and projects.

Redirect ODBC jobs to your own subsystem

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

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

WRKSHRPOOL and setup a shared pool with appropriate amount of memory and activity levels use the shrpool name in the steps 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)
**Use numbers specific to your installation**

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 done in iSeries Navigator:

Navigate <your_system><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
Either single IP address or a range of addresses
Select the subsystem you just created and setup

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

You can use the same logic for any of the iSeries Access Servers Central, Data Queue, File, Net Print, Remote Command, Signon and Server Mapper


Dig Deeper on iSeries system performance and monitoring

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close