Chat now with support
Chat with Support

Quest has tools and processes in place to identify, protect, detect, and remediate vulnerabilities and incidents when they occur, including external security partners. As part of our standard security operations, Quest does not use CrowdStrike in any of our operations. We are reviewing our third parties, and so far, there is minimal affect. It is Quest's policy not to provide further technical details unless they directly impact customer data.

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

AIX/UNIX

1
Locate the StageDB2-UNIX.sql script in the scripts\DB2\Staging folder.
2
Find and replace the following variables:
Table 2. AIX®/UNIX® variables
Variable
Replacement

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

Select Rating

I easily found the information I needed.

Select Rating