1.1.10 Modifying the PeopleSoft PeopleTools Install for DB2 z/OS

Modifying the Steps to Import Data

For DB2 z/OS, when installing PeopleSoft HCM 9.2, the order of steps that you perform in the chapter "Creating a Database" of the PeopleSoft PeopleTools installation guide changes if you are installing a Demo (DMO) database.

See PeopleSoft 9.2 Application Installation for Db2 z/OS and for your current PeopleTools release, “Creating a Database.”

Before you perform the task Running PeopleSoft Data Mover Import Scripts, you must edit the <DBNAME>dbo.dms script. Edit the script <DBNAME>dbo.dms and create two different PeopleSoft DMS scripts from the original.

Note:

This modification is necessary because the PeopleSoft HCM 9.2 Demo database has some duplicate data definitions and indexes that you must create before loading the Demo database, to avoid duplicates.

To edit the <DBNAME>dbo.dms script:

  1. In <DBNAME>dbo.dms, search for the keyword hcengl.log.

  2. Cut the portion of the script from the line that contains hcengl.log to the end of the script and paste it into a different script called <DBNAME>dbo_2.dms.

  3. Save the original <DBNAME>dbo.dms script after removing the portion of script from the line that has the keyword hcengl.log to the end of the script.

  4. Verify that the original <DBNAME>dbo.dms script only contains the import from hcengs.db and that <DBNAME>dbo_2.dms contains the rest of the import and updates.

  5. Run the <DBNAME>dbo.dms script in bootstrap mode.

    Perform this step by following the instructions in the task Running PeopleSoft Data Mover Import Scripts.

    See PeopleSoft 9.2 Application Installation for Db2 z/OS and for your current PeopleTools release, “Creating a Database.”

  6. Use the instructions in the task Creating Indexes to run the step to create indexes.

  7. Use the instructions in the task Running PeopleSoft Data Mover Import Scripts to run the <DBNAME>dbo_2.dms script.

Modifying the Steps to Create Views

DB2 z/OS customers must modify the steps for creating views in the chapter “Creating a Database” in the PeopleSoft PeopleTools installation guide, when installing PeopleSoft HCM 9.2.

See PeopleSoft 9.2 Application Installation for Db2 z/OS and for your current PeopleTools release, “Creating a Database.”

Note:

This modification is required due to the use of Materialized Query Tables. The associated records are defined in Application Designer as SQL Views and are distinguished from other views by the selection of the Materialized Query Tables checkbox on the Record Type tab. When such records are built in the database, instead of creating views, physical tables are created. Before creating these tables, you must specify a valid database and tablespace for each such record.

In the task Creating PeopleSoft Views, you are given the option of creating views using Data Mover or Application Designer. You must follow the “Creating Views in Application Designer” procedure, with the following modifications:

  1. In the Build Execute Options, select “Build script file.”

  2. Review the resulting DDL script. You will find a CREATE TABLE statement for each Materialized Query Table.

  3. For each CREATE TABLE statement, edit the database and tablespace names as needed.

See Also

PeopleTools: Data Management, "Running DDDAudits"