Chat now with support
Chat with Support

Stat 6.0 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class Rights Appendix: Creating a Staging Database Appendix: Database Tuning Appendix: Oracle Applications File Type Directory Appendix: Ports and Firewalls Appendix: Stat Web Services Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Administrative Utilities

Stat INI Editor

The Stat INI Editor is a GUI application designed to create new INI files and edit existing ones. The INI Editor displays all the database profile records contained in the Stat.ini file in an easy-to-read format.

The Stat.ini file contains the information Stat needs to connect to Stat databases. It is located in the Stat version-specific documents folders: C:\ProgramData\Quest\Stat\.

Access to the Stat INI Editor from within Stat is controlled by the user class right, Launch Ini Editor.

The following is a sample Stat.ini file:

To open the Stat INI Editor, select Tools | Launch INI Editor, or select Stat Ini File Editor from the Windows Start menu. The Editor opens with the default Stat.ini file displayed.

To open a different Stat.ini file, select File | Open, or click the Open toolbar button in the Stat INI Editor toolbar. Then select the file you want. Each INI file opens in a separate record window.

In the INI record window, you can edit all relevant database parameters, including the DBMS, Login ID, and other options.

The record window is comprised of two tabs: Database and Options.

The Database Tab

The Database tab lists the database(s) that Stat can connect to. From here you can edit an existing INI file entry or create a new one. The figure below shows how the INI information appears in the INI Editor. The information is taken directly from the sample INI file on the previous page. The INI Editor helps edit a file by asking for the exact information it needs. For example, if the DSN field is not required for a particular database, that field is grayed out.

1
Select File | New.
2
Select Edit | New Record.
4
In the DBMS field, select a DBMS.
5
Enter the STATLOGIN password in the Encrypted Login Password field, either by entering an encrypted password from another stat.ini file or by clicking Change Password and entering the STATLOGIN password.
7
Select File | Save as. Then specify a name for the INI file.
8
Click Save.

General Setting Information

The following table contains general database connection settings for the Stat INI Editor. Each record in the Stat INI Editor represents a database in the INI file. For more general information on available DBMS settings, see any of the Environment Connection Maintenance sections in Chapter 4, General Maintenance Tables .

DBMS

Database interface identifier. This identifier is DBMS and DBMS release specific.

Server Name (MS Sql Server)

NET_SERVICE_NAME (Oracle)

The name of the database server that houses the Stat Repository. Formatting for this entry is DBMS-specific.

LoginId

The login ID used for the Stat first-pass login. Not used by all DBMS. This entry should always be STATLOGIN.

Encrypted Login Password

The encrypted password of STATLOGIN. This value can be changed, as described below.

Connect Time Out Secs

Number of seconds to wait for a connection to the database before timing out. Not supported by all RDBMS.

OtherDbParm

Additional database connection parameters, if needed. For Oracle databases that use a comma rather than a period as a decimal separator, enter the value: DecimalSeparator=','.

Unicode

Type Y if you are running Stat on a Unicode database (in order to support PeopleSoft Unicode databases) and the DBMS is SQL Server. Otherwise leave blank.

Enable DB Trace

Configures Stat to write a trace log of all commands. Selecting this option impacts the client application’s processing speed and should only be selected if directed to by Support.

Related Documents