beautypg.com

IBM Data Server DB2 User Manual

Page 268

background image

254

DB2 Deployment Guide

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

Script name

Description