Chat now with support
Chat with Support

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

Stat on SQL Server

Stat on SQL Server
1
Locate the necessary scripts.
SQL Server® install scripts are located in <installation package>\scripts\MSSQLServer\Install. Run the following scripts to create the Stat® database regardless of your change management module:
•
NMSSv630-1.sql
•
NMSSv630-2.sql
•
NMSSv630-3.sql
2
Check the SQL Server settings. See SQL Server Settings.
3
Execute the appropriate scripts for your development environment using SQL Server Management Studio or Toad™ for MSS only (Do not use third-party tools).
* 
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).

NMSSv630-1.sql

1
Locate the NMSSv630-1.sql script.
2
Find and replace the bracketed variables with the appropriate values.
•
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.

NMSSv630-2.sql

1
Locate the NMSSv630-2.sql script.
2
Find and replace the bracketed variables with the appropriate values.
•
Replace [DATABASENAME] with the name of the database (the name used on the system that connects to the database).
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating