Ibm Data Server DB2 Bedienungsanleitung PDF herunterladen (Seite 268)

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

1 2 ... 263 264 265 266 267 268 269 270 271 272 273 ... 297 298

Keine Kommentare

Ibm Data Server DB2 Bedienungsanleitung Seite 268