252 DB2 Deployment Guide
5.6.1 Scripts
Table5-6 lists the scripts used in the examples in this chapter.
Table 5-6 Scripts containing DDL and SQL statements
5.6.2 Shell scripts
We divide the scripts into supportive shell scripts and plain shell scripts.
Supportive scripts are used to execute the plain scripts when we want to act on
the return code from the executed plain script. Table5-7 lists the suppor tive shell
scripts. The plain scripts are listed in Table5-8.
When we refer to the execution environment, we mean the command shell from
where we invoke the shell script.
Script name Description
itsodb.ddl Contain DDL and SQL statements to create the database layout and
database object for our sample database ITSODB.
itsodb2.ddl Contain DDL and SQL statements to create the database layout and
database objects for the modified sample database ITSODB2.
export.sql Contain statements to export data from either the DB2 sample
database or the ITSODB sample database. Data are exported using
the IXF file format. The tables exported are STAFF, EMPLOYEE
and DEPARTMENT.
import.sql Contain statements to populate data to tables STAFF, EMPLOYEE,
and DEPARTMENT using the DB2 import utility.
load.sql Contain statements to populate data to tables STAFF, EMPLOYEE.
and DEPARTMENT using the DB2 load utility.
alteritso.sql Contain statements to migrate the database objects from ITSODB
to ITSODB2.
department.sql Contain SQL INSERT statements to populate the DEPARTMENT
table.
employee.sql Contain SQL INSERT statements to populate the EMPLOYEE
table.
staff.sql Contain SQL INSERT statements to populate the STAFF table.
populate.sql Contain SQL INSERT statements to populate all three tables.