iSeries: Creation of Dedicated SUBSYSTEM and JOB QUEUE

Important Note: The following are steps to create an iSeries subsystem that will allow optimum performance for loading or modifying data into your warehouse. This subsystem only needs to be started prior to submitting a job to load or modify data. This allows the allocated memory to be used for other subsystems. We recommend turning off auto-tuning when making these changes.

1. At a command line enter command WRKSHRPOOL (Work with Share Pools) and enter
Decide which shrpool is available for use and return to the command line.

2. At the command line, enter CHGSHRPOOL (Change Share Pool) and prompt (F4)
Enter the parameters as follows:

Pool identifier . . . . Enter the name of the shrpool
Storage size . . . . . . This is determined by the amount of memory available at runtime.
Activity level . . . . . 1
Paging . . . . . . . . . . *calc
Text description . . ‘DataTracker Share Pool’

3. Once the share pool has been set up, attach the pool to a new subsystem. On a command line enter command CRTSBSD (Create Subsystem Description) and prompt (F4)
Enter the parameters as follows:

Subsystem description . . Name to your company’s standards, however we suggest DABATCH.
Library . . . . . . . . . . QGPL
Pool identifier . . . . 1
Storage size . . . . . . Enter the shrpool name (ex. SHRPOOL1)
Activity level . . . . . (leave blank)
Maximum jobs . . . 1
Text description . . ‘DataTracker Batch Subsystem’

4. A routing entry is needed for the new subsystem. At a command line enter command ADD RTGE (Add routing Entry) and prompt (F4)
Enter the parameters as follows:

Subsystem description . . . . . . . . . .DABATCH
Library . . . . . . . . . . . . . . . . . . . . . . . QGPL
Routing entry sequence number . . 9999
Compare value . . . . . . . . . . . . . . . . . *ANY
Starting position. . . . . . . . . . . . . . . . 1
Program to call . . . . . . . . . . . . . . . . .QCMD
Library . . . . . . . . . . . . . . . . . . . . . . . .QSYS
Class. . . . . . . . . . . . . . . . . . . . . . . . . . QBATCH
Library . . . . . . . . . . . . . . . . . . . . . . . .QSYS
Maximum active routing steps . . . .*NOMAX
Storage pool identifier . . . . . . . . . . . 1

5. Create a job queue. At a command line enter command CRTJOBQ (Create job queue) and prompt (F4)
Enter parameters as follows:

Job queue . . . . . . . . . . DABATCH
Library . . . . . . . . . . . . .QGPL
Text description . . . . . ‘DataTracker Batch JOBQ’

6. Now add the job queue to the subsystem. At a command line enter ADDJOBQE (Add Job Queue Entry) and prompt (F4)
Enter the parameters as follows:

Subsystem description . . . DABATCH
Library . . . . . . . . . . . . . . . . . QGPL
Job queue . . . . . . . . . . . . . . DABATCH
Library . . . . . . . . . . . . . . . . . QGPL
Maximum active jobs . . . . 1

The subsystem and job queue is now ready to use. The next two steps assign the job queue to the client and set the memory size on frequently used DataTracker commands. The ‘Silvon’ and any other profiles that will be submitting jobs from the server should be changed to use the new job queue.

7. Run the DataTracker Client Configuration and change the Job Queue to the queue just creaetd (ie DABATCH). This step needs to be repeated on any PC that will be submitting jobs from the client. This includes the submission of planning updates.

8. The command CHGCMDDFT needs to be run for DataTracker commands using DALOAD and the parameter MEMORYSZ. The memory size should be about 90% of what is set up in the share pool. (Ex. if share pool is 1GB, MEMORYSZ should be 900MB) At a command line, enter command CHGCMDDFT and prompt (F4)
Enter the parameters as follows:

Command . . . . . DALOAD
Library . . . . . . . . *LIBL

New default parameter string “MEMORYSZ(nnn)’ The ‘nnn’ represents the memory size in megabytes. These changes will need to be rerun every time a new version of the server library (STCSOBJ) is restored. Therefore, the commands can be maintained more efficiently by creating a CL that executes the change default command for each of the following DataTracker commands:

DAADDDSL – Adding a DSL
DACHGSET – Applying a change set
DAGRPCHG – Applying group change sets
DALOAD – Loads data
DARELCHG – Applying a relationship change set
SECVLBTUP – Update secondary planning values
WRTBCK – Executes a Planning update