[Fix Pack 29 or later]

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 i5/OS® 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 i5/OS 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 Information Center.

Procedure

  1. On the z/OS operating system, replace the variables in the SQL files. In a command window, change to the app_server_root/bin directory, and enter the following commands:
    export SCHEMA_LOCATION=app_server_root/etc/wim/setup/lookaside/db2zos
    export DBNAME=zos
    ./ws_ant.sh -f app_server_root/etc/wim/setup/filterbuild.xml
    Important: Set the SCHEMA_LOCATION value to the location where you copied the SQL files if you do not have WebSphere Application Server installed on the same system on which you are setting up the database.
  2. Start the DB2 server.
  3. Create a database.
  4. Run the SQL files, which were previously referenced, to create the tables for the property extension repository. If you are setting up the database on the same system on which the application server is installed, the files are located in the following locations:
    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

    Otherwise, run the SQL files from the location to which you copied the files.

What to do next

Run the setupIdMgrPropertyExtensionRepositoryTables command with the skipDBCreation parameter set to true to populate the tables that are created. For more information, read about setting up an entry mapping repository, a property extension repository, or a custom registry database repository using wsadmin commands.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 4:53:43 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-base-dist&topic=twim_manpropextrepos_db2
File name: twim_manpropextrepos_db2.html