Chat now with support
Chat with Support

Stat 6.2 - Install Notes

Installing Stat
Prepare for installation Unpack the 6.2.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 StageORA856.sql script in the scripts\Oracle\Staging folder.
2
Replace the following variables:
•
[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 StageMSS856.sql script in the scripts\MSSQLServer\Staging folder.
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.
5
Open the modified scripts.
6
After running each script, copy the output of the script results to a file, and save the file for review.

PeopleSoft on DB2

Execute the script corresponding to your DB2® platform:

•
Mainframe
•
AIX/UNIX

Mainframe

1
Locate the StageDB2-ZOS-856.sql script in the scripts\DB2\Staging folder.
2
Find and replace the following variables.
Table 1. Mainframe variables
Variable
Replacement

[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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating