Chatta subito con l'assistenza
Chat con il supporto

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

1
Locate the StageMSS.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.

PeopleSoft on DB2

Execute the script corresponding to your DB2® platform:

Mainframe

1

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

AIX/UNIX

1

[DATABASENAME]

Replace with the name of the database.

[USERID]

Replace with the correct user access id.

[PASSWORD]

Replace with the correct access password.

[TABLETBSPC]

Replace with tablespace for the table.

[CREATORID]

Replace with the creator/owner ID of the tables.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione