Steps for converting the object store and ICL from VSAM to DB2

Perform the following steps to convert the object store and ICL from VSAM data sets to DB2® tables.

Before you begin

DB2 must be installed and running.
You need to know the name of the DB2 subsystem or the group attachment name.
You need to know the name you will use for the DB2 package. The default package name is MASTERCA.
You need to know the name of the PKI Services daemon.

Stop the instance of PKI Services for which you want to do the conversion. For information on how to do this, see Starting and stopping PKI Services.
________________________________________________________________
Update the IKYCDB2 sample and run it to create the DB2 objects. See step 1.
________________________________________________________________
Update the sample job IKYSBIND and run it to create the DB2 package. See step 2.
________________________________________________________________
Update the sample job IKYSGRNT and run it to grant execute privilege on the DB2 package for PKI Services to the PKI Services daemon user ID. See step 3.
________________________________________________________________
Use the utility program vsam2db2 to copy the data from your VSAM data sets to the corresponding DB2 tables. See Using the vsam2db2 utility.
________________________________________________________________
Update the configuration file, pkiserv.conf, to indicate that you are using DB2 tables. See step 5.
________________________________________________________________
Restart PKI Services. For information on how to do this, see Starting and stopping PKI Services.
________________________________________________________________

When you are done, you have copied your object store and ICL VSAM data sets to DB2 tables, and set up PKI Services to use the DB2 tables.