Manually setting up the property extension repository for DB2 for iSeries or DB2 for z/OS
Use this task to set up the property extension repository for DB2® for iSeries or DB2 for z/OS®.
Before you begin
The information in this topic applies in the following
scenarios:
- The application server and the database both exist on the IBM® i operating system.
- The application server and the database both exist on the z/OS operating system.
- The application server exists on a distributed operating system, but the database exists on either the IBM i or z/OS operating system.
If you do not have WebSphere® Application
Server installed in the system on which you are setting up the database,
copy the following files from a system where WebSphere Application Server is installed
to the system on which you are setting up the database:
- DB2 for iSeries
app_server_root/etc/wim/setup/lookaside/db2iseries/dbclean.sql app_server_root/etc/wim/setup/lookaside/db2iseries/schema.sql app_server_root/etc/wim/setup/lookaside/db2iseries/primarykeys.sql app_server_root/etc/wim/setup/lookaside/db2iseries/indexes.sql app_server_root/etc/wim/setup/lookaside/db2iseries/references.sql app_server_root/etc/wim/setup/lookaside/keys.sql app_server_root/etc/wim/setup/lookaside/bootstrap.sql
- DB2 for z/OS
app_server_root/etc/wim/setup/lookaside/db2zos/dbclean.sql app_server_root/etc/wim/setup/lookaside/db2zos/schema.sql app_server_root/etc/wim/setup/lookaside/db2zos/primarykeys.sql app_server_root/etc/wim/setup/lookaside/db2zos/indexes.sql app_server_root/etc/wim/setup/lookaside/db2zos/references.sql app_server_root/etc/wim/setup/lookaside/keys.sql app_server_root/etc/wim/setup/lookaside/bootstrap.sql
About this task
For information about how to create a database and run SQL queries in DB2 for iSeries, see the DB2 Universal Database for iSeries in the IBM iSeries Information Center.
For information about how to create a database and run SQL queries in DB2 for z/OS, see the Information Management Software for z/OS Solutions documentation.