Bind-copying driver packages to enable the selectivity override feature on DB2 for z/OS V11 new-function mode

Run JCL job AOCCFG11 to bind-copy IBM Data Server Driver for JDBC and SQLJ packages to enable the selectivity override feature on DB2 for z/OS V11 new-function mode. If the packages were not bound with the correct options, this JCL job can bind them correctly.

About this task

The JCL job AOCCFG11 contains two sections:

AOCJBIND
This section binds the packages to the collection OPTCOLL0. Running this step is required if the packages have not been bound, or were not bound with bind options "SYSTIMESENSITIVE YES BUSTIMESENSITIVE YES ARCHIVESENSITIVE YES". If these packages are already under collection NULLID or OPTCOLL0 with the above bind options, you should comment out and not run this section.
AOCJCOPY
This section copies the packages and binds them to collection OPTCOLL1. Running this section is required if you want to enable the selectivity override feature. The packages for the IBM Data Server Driver for JDBC and SQLJ must already be bound with the above bind options under collection NULLID or OPTCOLL0. If they are not bound in either collection, run section AOCJBIND.
Attention: This JCL job creates the two collection IDs OPTCOLL0 and OPTCOLL1. Reserve these collection IDs for use by InfoSphere Optim Query Workload Tuner only.

Procedure

  1. Upload the AOCCFG11 JCL job file in ASCII format to the subsystem from the client system.
    The JCL file is inside the installation directory for the IBM® Data Studio client.
    • If you installed the IBM Data Studio client on a Windows system, the JCL is in the installation_directory\QueryTunerServerConfig\all_features\ZOS\V11 directory.
    • If you installed the IBM Data Studio client on a Linux system, the JCL is in the .installation_directory/QueryTunerServerConfig/all_features/ZOS/V11 directory.
  2. Modify the JCL job file for your environment.
    1. Uncomment AOCJBIND if you need to run this section and specify the JDBC URL for connecting to the subsystem.
    2. For section AOCJCOPY, change the source collection '!COLLID!' to OPTCOLL0 (if you run AOCJBIND) or to NULLID.
  3. Submit the job.