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
- 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.
- Modify the JCL job file for your environment.
- Uncomment AOCJBIND if you need to run this section and specify the JDBC URL for connecting to
the subsystem.
- For section AOCJCOPY, change the source collection '!COLLID!' to OPTCOLL0 (if you run AOCJBIND)
or to NULLID.
- Submit the job.