Chat now with support
Chat with Support

Stat 6.0 - Install Notes

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

Stat on SQL Server (2008, 2012, 2014, and 2016)

SQL Server® install scripts are located in <target directory>\scripts\MSSQLServer\Install. Run the following scripts to create the Stat® database regardless of your change management module:
CAUTION: Each script should be run one-time only.

SQL Server settings

Each script is divided into functions with a summary at the beginning of each individual script. To quickly go to the function in the script, do a find on Function xx where xx is the function number of interest.

Verify that the server is installed with BINARY collation.

Each new Stat database will require the tempdb to increase data by 75 MB and log by 25 MB (this is coded into the script by modifying the FILEGROWTH parameters).

NMSSv600-1.sql

1
Locate the NMSSv600-1.sql script.
Replace [DATABASENAME] with the name of the database (the name used on the system that connects to the database).
Replace [DBdirectory] with the entire path information for the database (Example: D:\Mssql\data).
Replace [LOGdirectory] with the entire path information for the log (Example: E:\Mssql\log)
NOTE: If the Stat® database is being installed on SQL Server® and the script syntax is checked before running script #1 (before the database is created), error messages will appear that can be ignored. This is because the database is being created in the same script as the USE [DATABASENAME] statements.

NMSSv600-2.sql

1
Locate the NMSSv600-2.sql script.
Replace [DATABASENAME] with the name of the database (the name used on the system that connects to the database).
Related Documents