Creating a DB2/400 Physical Schema

A Physical Schema corresponds to a pair of libraries (or collections) in DB2/400:

• A (Data) Schema, in which Oracle Data Integrator will look for the source and target tables and files for the interfaces.

• A Work Schema in which Oracle Data Integrator can create and manipulate temporary work tables associated to the sources and targets contained in the Data Library.

Note: The user profile specified in the data server to which the Physical Schema is attached must have appropriate privileges to perform such operations.

Note: Most of the Knowledge modules make use of commitment control in the staging area and when writing to the target datastores. We strongly recommend that you use collections as staging areas on AS/400, and to have the target tables journaled.

Creation of the Physical Schema

To Create a DB2/400 Physical Schema:

Note: If you have just created a Data Server, then ignore step 1. The  Physical Schema window should already be opened.

1. Select the DB2/400 Data Server, right-click and select Insert Physical Schema. The Physical Schema window appears.

2. Select the Data Library for this Oracle Data Integrator physical schema in Schema (Schema). A list of the DB2/400 database's libraries appears in this field.

3. Select the Work Library for this Oracle Data Integrator physical schema in Schema (Work Schema).  A list of the of the DB2/400 database's libraries appears in this field.

4. Check the Default box if you want this schema to be the default one for this data server (The first physical schema is always the default one). For more information, see Physical Schema

5. Go to the Context tab.

6. Select a Context and an existing Logical Schema for this new Physical Schema, then go to step 9.
   If no DB2/400 Logical Schema exists yet, proceed to step 7.

7. Click the button.

8. Select an existing Context in the left column, the type the name of a Logical Schema in the right row. This DB2/400 Logical Schema is automatically created and associated to this physical schema in this context.

Warning ! A Logical Schema can be associated to only one Physical Schema in a given Context.

9. Click OK.