Redirecting JDBC/ODBC Connections to a Specific Subsystem

[Ken]

Here are the necessary steps to have JDBC/ODBC Connections be directed
to a subsystem other than QUSRWRK

· CRTSBSD SBSD(LIB/SUBSYSTEM) POOLS((x Assigned Share Pool)) Text
('Text Description goes here')
· CRTDUPOBJ OBJ(QPWFSERVER) FROMLIB(QSYS) OBJTYPE(*CLS) TOLIB(QSYS)
NEWOBJ(New Object Name)
· CHGCLS CLS(QSYS/New Object Name) RUNPTY(xx) - What ever priority you
want it to run at
· ADDRTGE SBS(Lib/SUBSYSTEM) SEQNBR(1) CMPVAL(*ANY) PGM(QCMD) CLS(QSYS/
NEWOBJECTNAME) POOLID(x)
· ADDPJE SBSD(LIB/SUBSYSTEM) PGM(QZDASOINIT) INLJOBS(10) THRESHOLD(20)
ADLJOBS(5) CLS(QSYS/NEWOBJECTNAME)
· STRSBS SBSD(LIB/SUBSYSTEM)
· Start iSeries Navigator
· Click on: SystemName -> Network -> Servers -> iSeries Access
· Right Click on Database and select properties
· Click on Subsystem Tab
· Click on Specific Clients and Add Client
· Fill in the Add Client Screen and specifying either the IP address
range or specific IP Addresses
· Click OK

These are the steps which need to be completed and in the event that
the newly created subsystem is not active, the ODBC/JDBC connections
will default back to QUSRWRK.