IKYSBIND

IKYSBIND is a sample job to create the DB2® package and plan for the object store and issued certificate list (ICL). IKYSBIND is a member of SYS1.SAMPLIB.

//IKYSBIND JOB <job parameters>
//*********************************************************************
//* SAMPLE: IKYSBIND
//*
//* Licensed Materials - Property of IBM
//* 5650-ZOS
//* Copyright IBM Corp.  2011, 2013
//* Status = HKY7790
//*
//*********************************************************************
//*
//* This sample job may be used to build the DB2 package for
//* PKI Services.
//*
//*********************************************************************
//*
//* Before running this job, you may need to make the following
//* modifications:
//*
//* 1) Change all the occurences of 'MASTERCA' to the package name.
//*    The package name should match the first eight characters of
//*    the associated CA domain name and match the value used when
//*    creating the DB2 database, tablespaces, tables, and indexes.
//*
//* 2) Change 'DSN9' to the DB2 subsystem name which PKI Services
//*    will be running under.
//*
//* 3) Change 'PKISRVD' to the ID you would like to be the owner of
//*    the package.
//*
//* To issue the following BIND instruction, the user must have at
//* least one of the following DB2 privileges:
//*    - BIND privilege WITH GRANT OPTION on the PACKAGE
//*      specified in the following BIND instruction
//*    - Ownership of the PACKAGE specified in the following
//*      BIND instruction
//*    - SYSADM authority
//*
//*********************************************************************
//* Change Activity:
//*
//*   $L0=PKIS13D      HKY7780   100706  PDWFC1: DB2 support
//*   $L1=PKIS21D      HKY7790   120612  PDRRG1: DB2 Enhancements
//*
//* Change Description:
//*
//*   A: Initial code                                              @L0A
//*   C: Remove ISOLATION clause from BIND PACKAGE, since the SQL
//*      instructions in IKYPDBRM specify isolation levels that
//*      will override any setting used in the BIND PACKAGE.
//*      Removed BIND PLAN.                                        @L1A
//*
//*********************************************************************
//EXECTSO  EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//DBRMLIB  DD DSN=SYS1.CBRDBRM,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN  DD *
DSN SYSTEM(DSN9)
BIND PACKAGE(MASTERCA)   -
     MEMBER(IKYPDBRM)    -
     QUALIFIER(MASTERCA) -
     VALIDATE(BIND)      -
     ENABLE(RRSAF)       -
     ENCODING(1047)      -
     ACTION(REPLACE)     -
     CURRENTDATA(NO)     -
     DBPROTOCOL(DRDA)    -
     RELEASE(COMMIT)     -
     OWNER(PKISRVD)
END