Chat now with support
Chat with Support

We are currently experiencing issues on our phone support and are working diligently to restore services. For support, please sign in and create a case or email for assistance

Stat 6.3 - Install Notes

Installing Stat
Prepare for installation Unpack the 6.3.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 SQL Server

Locate the StageMSS.sql script in the scripts\MSSQLServer\Staging folder.
Find and replace the variable [DATABASENAME] with the name of the database.
Using Enterprise Manager, go into SQL Server® Analyzer from Tools on the menu bar.
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:




Replace with the name of the database.


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).


Replace with the name of the database.


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].


Replace with the Stogroup name for the index.





Replace with the name of the database.


Replace with the correct user access id.


Replace with the correct access password.


Replace with tablespace for the table.


Replace with the creator/owner ID of the tables.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating