Working with the Database Setup Utility

Database Setup

Field or Control	Description
Select Target Database	Select the RDBMS against which to run the database setup script. For instance, if the database that you are creating will run on an Oracle server, select Oracle.
Database Type	PeopleSoft supports non-Unicode (ANSI) and Unicode database types. Select the appropriate type for the system. For some RDBMS types, Unicode is not available.
Select Character Set	Select a character set. Your choices vary depending on the database type that you selected.

Select PeopleSoft Application

Field or Control	Description
PeopleSoft Application	Only the applications that you have licensed appear. Select the applications for which you want to create PeopleSoft Data Mover scripts. To add applications selectively, use the Add button. To add all applications available, use the Add All button.
Data Mover Scripts to Create	Use the Remove button to remove a single application, or use the Remove All button to clear the list box.
Database Type	Specify what the result of running the script should be. There are two database codes: PT for PeopleTools and EP for PeopleSoft applications. Options are: Demo: Select to create a demonstration database. System: Select to create a system database. Add New Language: Select to add support of new languages to an existing database. Add New Product: Select to add a new PeopleSoft product to the current system. With this option selected, only non-PT database codes appear.

Field or Control

Description

PeopleSoft Application

Only the applications that you have licensed appear. Select the applications for which you want to create PeopleSoft Data Mover scripts. To add applications selectively, use the Add button. To add all applications available, use the Add All button.

Data Mover Scripts to Create

Use the Remove button to remove a single application, or use the Remove All button to clear the list box.

Database Type

Specify what the result of running the script should be. There are two database codes: PT for PeopleTools and EP for PeopleSoft applications. Options are:

Demo: Select to create a demonstration database.
System: Select to create a system database.
Add New Language: Select to add support of new languages to an existing database.
Add New Product: Select to add a new PeopleSoft product to the current system. With this option selected, only non-PT database codes appear.

Database Parameters

Field or Control	Description
Database Name	Enter the name of the database against which to run the script. The database name that appears is the database to which you are currently signed on. If the script that you are creating will be run against another database, specify the appropriate name here. If you generate a script for a database other than the current database, the system uses a default database using the following convention: XXDMO for demonstration databases and XXSYS for system databases. The XX represents the product code, such as HR.
Symbolic ID	Enter the ID used as the key to retrieve the access ID and access password. For initial installation, set it equal to the database name.
Access ID	This ID is the RDBMS ID with which PeopleSoft applications are ultimately connected to the database once the PeopleSoft system validates the user or connect ID. It typically has all the RDBMS privileges necessary to access and manipulate data for an entire PeopleSoft application.
Access Password	Enter the password associated with the access ID.
Connect ID	This ID is used for the initial connection to the database. Any two-tier connection requires a connect ID. A connect ID is a valid user ID, that when used during logon, takes the place of PeopleSoft user IDs for the sign-in process.
Table Owner	(DB2 UDB for z/OS) This field populates the CREATOR field in the system catalog table SYSIBM.SYSTABLES. You determine the name of the table owner ID during the initial installation.
Index Storage Group	(DB2 UDB for z/OS) Enter the storage group where the index spaces are created.
Table Space Storage Group	(DB2 UDB for z/OS) Enter the storage group for tablespaces. This value must be the same as that used in the XXDDL.SQL script when you create tablespaces during the installation.