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

Microsoft SQL Server

Active

If selected, indicates that this environment definition is active in Stat

Environment Cd
(Key Value)

A 1-10 character code which uniquely identifies the environment

Staging DB

Indicates if the environment is used as a staging environment

PS Version
(Required Value)

The tools release of the environment

Data Obj Version

N/A

Description
(Required Value)

A 1-35 character description of the environment

Use Physical
Locking

Specifies whether or not physical locking is used for PeopleSoft proprietary objects in this environment

Req. Migr. Approval

If selected, indicates that archive sets cannot be migrated into the environment without migration approval

DBMS
(Required Value)

Microsoft SQL Server

Syntax Override

N/A

ODBC DSN

N/A

Database Name

The name of the environment (database instance).

Used by the Stat Client for auto-migration to the staging database and to the target.

DB User ID

The name of the account used to login to the database

DB Password

The password for the account used to login to the database

Database Server

The name of the machine hosting the SQL Server database.

Srv Logon ID

The login ID (commonly “sa”) that connects you to the SQL Server itself without connecting to a DB. Can be “sa,” but if that is a security concern, it can be another user with similar privileges, or it can be the DB user id for the database being configured.

Server Pwd

The password for the Srv Logon ID above

Host Name

Name of the machine hosting the database.

Required value for the Stat Central Agent connection.

Service Name

N/A

DB Listener Port

Port number for the database listener (SQL Server default value is 1433).

Required value for the Stat Central Agent connection.

Use Tns

N/A

Tns Entry

N/A

Other Database Parameters

Additional DBMS-specific parameters, if needed.

PS Config File

The path and name of the PeopleSoft configuration file, if any, that Stat imports when executing CLI functionality for this environment. You can either enter the location manually, or you can click the folder icon and select the location in the Browse for Folder dialog box.

Base Language

For PeopleSoft 8.4.x or higher, the base language of the environment. The default is ENG.

Stat PS OprId
(Required Value)

Required for PeopleSoft Object Locking in Stat. 30 characters in length maximum. Default is “STAT.”

Last Update
(Read Only)

The date and time this record was last updated

Update By
(Read Only)

The user who last updated this record

UDB for OS/390

Active

If selected, indicates that this environment definition is active in Stat

Environment Cd
(Key Value)

A 1-10 character code which uniquely identifies the environment

Staging DB

Indicates if the environment is used as a staging environment

PS Version
(Required Value)

The tools release of the environment

Data Obj Version

N/A

Description
(Required Value)

A 1-35 character description of the environment

Use Physical
Locking

Specifies whether or not physical locking is used for PeopleSoft proprietary objects in this environment

Req. Migr. Approval

If selected, indicates that archive sets cannot be migrated into the environment without migration approval

DBMS
(Required Value)

ODBC Database

Syntax Override

DB2

ODBC DSN

A valid data source name set up in the DB2 Client Configuration Assistant (CCA)

Database Name

The name of the environment on the mainframe.

For Stat to auto-migrate objects to both the staging database and the target environment of the migration, a name must be specified, regardless of connection type.

DB User ID

The valid RACF user ID for the DB2 environment

DB Password

The password for the DB User ID (password is not case-sensitive)

Database Server

N/A

Srv Logon ID

N/A

Server Pwd

N/A

Host Name
(Required Value)

The IP address or Server name where the database resides.

Required value for the JDBC Type4 driver.

Service Name
(Required Value)

The UDB/DB2 database Name. This is database name as defined during installation, not an alias.

Required value for the JDBC Type4 driver.

DB Listener Port
(Required Value)

The port that is listening for requests against the UDB/DB2 database.

Required value for the JDBC Type4 driver.

Use Tns

N/A

Tns Entry

N/A

Other Database Parameters

Case Sensitive with parameters separated by a semicolon if more than one defined. The correct format is:

currentSQLID=xxxxxxxx, where xxxxxxxx is the implicit qualifier of all table, view, alias, and index names specified in dynamic SQL statements.

PS Config File

The path and name of the PeopleSoft configuration file, if any, that Stat imports when executing CLI functionality for this environment. You can either enter the location manually, or you can click the folder icon and select the location in the Browse for Folder dialog box.

Base Language

For PeopleSoft 8.4.x or higher, the base language of the environment. The default is ENG.

Stat PS OprId
(Required Value)

Required for PeopleSoft Object Locking in Stat. 30 characters in length maximum. Default is STAT.

Last Update
(Read Only)

The date and time this record was last updated

Update By
(Read Only)

The user who last updated this record

UDB for AIX/Unix

Active

If selected, indicates that this environment definition is active in Stat

Environment Cd
(Key Value)

A 1-10 character code which uniquely identifies the environment

Staging DB

Indicates if the environment is used as a staging environment

PS Version
(Required Value)

The tools release of the environment

Data Obj Version

N/A

Description
(Required Value)

A 1-35 character description of the environment

Use Physical
Locking

Specifies whether or not physical locking is used for PeopleSoft proprietary objects in this environment

Req. Migr. Approval

If selected, indicates that archive sets cannot be migrated into the environment without migration approval

DBMS
(Required Value)

ODBC Database

 

Syntax Override

UDB

ODBC DSN

A valid data source name set up in the DB2 Client Configuration Assistant (CCA)

Database Name

The name of the environment on the server.

For Stat to auto-migrate objects to both the staging database and the target environment of the migration, a name must be specified, regardless of connection type.

DB User ID

The valid user ID for the DB2 environment

DB Password

The password for the DB User ID (password is case-sensitive)

Database Server

N/A

Srv Logon ID

N/A

Server Pwd

N/A

Host Name
(Required Value)

Server name or IP address. This value is used by the Stat Central agent to format the JDBC connection to the database.

Service Name
(Required Value)

The database name that is defined during installation (not the Alias or ODBC Name). This value is used by the Stat Central Agent to format the JDBC connection to the database.

DB Listener Port
(Required Value)

Port number where the host server is listening for requests. This value is used by the Stat Central Agent to format the JDBC connection to the database.

Use Tns

N/A

Tns Entry

N/A

Other Database Parameters

Case Sensitivity is required for type 4 driver. The correct format is:

currentSchema=xxxxxxxx, where xxxxxxxx specifies the default schema name that is used to qualify unqualified database objects in dynamically prepared SQL statements-also case sensitive.

PS Config File

The path and name of the PeopleSoft configuration file, if any, that Stat imports when executing CLI functionality for this environment. You can either enter the location manually, or you can click the folder icon and select the location in the Browse for Folder dialog box.

Base Language

For PeopleSoft 8.4.x, the base language of the environment. The default is ENG.

Stat PS OprId
(Required Value)

Required for PeopleSoft Object Locking in Stat. 30 characters in length maximum. Default is STAT.

Last Update
(Read Only)

The date and time this record was last updated

Update By
(Read Only)

The user who last updated this record

Testing Environment Connections

After defining an environment in the maintenance table, you can make sure that you have entered all the information correctly by clicking Test Connection. This makes Stat establish a connection to the newly defined environment. If successful, Stat immediately disconnects from the environment and displays a “Connection Successful” message. If Stat is unable to connect, it displays an error message.

You can also test connections to multiple databases simultaneously. To test multiple connections, hold the <Ctrl> or <Shift> keys and select the databases you want to test. Then click Test Selected. Stat attempts to establish a connection to each database and reports its results in the Database Test Connect window

Note that when you test a single environment, Stat does not validate the values specified in the fields Host Name, Service Name, or DB Listener Port. If any of these fields are not configured properly, the Stat Central Agent will log an error when the user attempts to migrate an object to or from the environment. When you test multiple connections, however, Stat does test both client and agent connections, including Host Name, Service Name, DB Listener Port or (in the case of Oracle-based environments) TNS Entry.

NOTE: When testing environment connections in the Stat Web Client, Stat Web attempts to connect using the Host Name, DB Listener Port, Service Name, or the TNS Entry values specified in the Stat maintenance tables for each particular environment. If there is no TNS Entry value specified for an environment, it uses the Host/Port/Service Name values. If a TNS Entry value is specified, it uses that value and disregards the others.
Related Documents