Script name

Description

 

 

exportdb.cmd

Export data from the ITSODB database to IXF files. It

 

connects to the ITSODB database and then execute the

 

script export.sql. Example:

 

c:>exportdb.cmd

 

Log file: export.log

 

 

importdb.cmd

Import data into the ITSODB database from a set of IXF files

 

using the DB2 import utility. It connects to the ITSODB

 

database and execute the script import.sql. Example:

 

c:>importdb.cmd

 

Log file: importdb.log

 

 

loaddb.cmd

Load data into the ITSODB database from a set of IXF files

 

using the DB2 load utility. It connects to the ITSODB

 

database and execute the script load.sql. Example:

 

c:>loaddb.cmd

 

Log file: loaddb.log

 

 

populatedb.cmd

Populate the tables in the ITSODB database from a set of

 

SQL INSERT statements. It connects to the ITSODB

 

database and execute the three scripts staff.sql,

 

department.sql and employee.sql. Example:

 

c:> populatedb.cmd

 

Log file:populatedb.log

 

 

alterdb.cmd

Alter the ITSODB database to match the database objects of

 

the ITSODB2 database. It connects to the ITSODB database.

 

Remove the shadow table (temporary table) if it exist, then

 

execute the script alterdb.sql.

 

c:>alterdb.cmd

 

Log file: alterdb.log

 

 

254DB2 Deployment Guide

Page 268
Image 268
IBM DB2 Log file export.log, Log file importdb.log, Log file loaddb.log, Log filepopulatedb.log, Log file alterdb.log