Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Stat 6.3 - Install Notes

Table of Contents

Installing Stat

Prepare for installation

Installation checklist

Unpack the 6.3.0 installer Install the Stat database

NORAv630-1.sql NORAv630-2.sql NORAv630-3.sql Execute the scripts Oracle patch compare support: Stat database (Oracle E- Business Suite Only)

Running Stat with multiple Oracle versions Stat on SQL Server

SQL Server settings NMSSv630-1.sql NMSSv630-2.sql NMSSv630-3.sql Execute the scripts

Create a staging database (PeopleSoft Only)

PeopleSoft on Oracle PeopleSoft on SQL Server PeopleSoft on DB2

Mainframe AIX/UNIX

Install the Stat Client

Local installation Single Network installation

Configure the Stat database

Edit the INI file

Update the System Maintenance table Install the Stat Central Agent

Installing the Stat Central Agent Configuring the Stat Central Agent

Before starting the Stat Central Agent Resolving port and firewall conflicts Stopping the Stat Central Agent Configuring the Stat Central Agent as a Windows service Installing DB2 Support for the Stat Central Agent Configure the Stat Central Agent character map Setting up support for AES256 Ciphers for SFTP Configure Web Client to use HTTPS Connection pool idle time Configure Web Client and Web Services to use custom URL Installing multiple servers on one host computer

Testing Database and Server Connections

Install the Stat Oracle Agent (Oracle E- Business Suite only)

Configuration Administration Dynamically changing log level Stat Oracle Agent version Custom products and file locations Base directory codes Verifying the Stat Oracle Agent

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

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

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center