STEP4.3
:
Create the tables in the database
To continue with the next steps
–
you must have installed a database management system (i.e. DB2).
–
you must have a JDBC Driver for it (i.e. db2java.zip in <db2>\java\).
–
you must be able to connect to the database (userid/password)
Make sure the JDBC driver is in the CLASSPATH. You may have to edit
the
create.bat/create.cmd/create.sh
batch files as well as the
run.bat/run.cmd/run.sh
batch files and add the JDBC Driver Archive to
the classpath:
set CLASSPATH=.;xerces.jar;<db2>\java\
db2java.zip;
%CLASSPATH%
Also the path must setup to contain the DB2 libraries.
Start the "
Create DB2 Tables
" utility (
create.bat/create.sh
or
START -
Programs - VSAM Redirector - Create DB2 Tables
).
The tool prompts you for the following:
–
XML Filename
: enter the name of the XML File you exported in the last
step (i.e.
ffstores.xml
)
–
DB url
: enter a JDBC URL for your database, i.e.
jdbc:db2:sample
–
DB user:
enter a user id you use for accessing the database
–
DB password:
enter the users password
–
DB table name
: Enter the name of the data table, i.e.
FFSTORES
. This
table will later contain the VSAM data.
–
Map table name:
Enter the name of the table that contains the mapping
information, i.e.
FFSTORES_MAP.
You can use the same map table for
several clusters.
–
Map name:
Enter the name of the map, i.e.
FFSTORES.
This name is
independent from the map defined with the VSE Navigator.
–
DB system
: Enter
1 for DB/2
, 2 for Oracle.
–
The tool now imports the XML file and tries to connect to the database.
–
Next, the map info table is created (FFSTORES_MAP). Enter "Yes" to
continue.
–
Then, the data table is created (FFSTORES). Enter "Yes" to continue.
–
Cluster Type
: Enter 1 (
KSDS without AIX
).
–
Primary key field:
Enter the name of the key field:
STOREID
. Press
enter to create the table and indexes.
Redirect a VSAM file to DB2
