Chat now with support
Chat with Support

Stat 6.0 - Install Notes

Installing Stat
Prepare for installation Unpack the 6.0.0 installer Install the Stat database Create a staging database (PeopleSoft Only) Install the Stat Client Configure the Stat database Update the System Maintenance table Install the Stat Central Agent Install the Stat Oracle Agent (Oracle E- Business Suite only) Configure the SYSTEM user account Update the PS Object Mover Instructions (PeopleSoft Only) Implement Stat

PeopleSoft on Oracle

1
Locate the StageORA855.sql script.
[OWNER/PWD@DATABASENAME] Replace with the correct values for the PeopleSoft® schema owner/password and staging database.
[SPOOLPT] Replace with the directory for the session log.
[PTAPP] Replace with the tablespace for the staging table
[PSINDEX] Replace with the tablespace for the staging table indexes
3
Run the modified script via Sql*Plus or Toad® in the PeopleSoft staging database as the PeopleSoft schema owner

PeopleSoft on SQL Server

1
Locate the StageMSS855.sql script.
2
Find and replace the variable [DATABASENAME] with the name of the database.
3
Using Enterprise Manager, go into SQL Server® Analyzer from Tools on the menu bar.
4
Log in as sa or a login that is a member of the sysadmin fixed server role or the database owner.

PeopleSoft on DB2

Execute the script corresponding to your DB2® platform:

Mainframe

[DATABASENAME1]

Replace with the name of the database.

[TABLETBSPC1]

Replace with the name of the tablespace for the new table STAT_STAGE_CNTRL.

Usually use an existing tablespace, so DB2 utilities that run at the tablespace level do not have to be modified for the new tablespace (example: image copy).

[DATABASENAME2]

Replace with the name of the database.

[CREATORID]

Replace with the creator/owner id.

Requires the [USERID] to be able to set current sqlid to this [CREATORID] secondary authorization RACF group. Would need to connect [USERID] to the RACF group [CREATORID].

[STOGRPNAME]

Replace with the Stogroup name for the index.

Requires the grant GRANT USE OF STOGROUP [STOGRPNAME] TO [CREATORID]

Related Documents