Stat 6.1 - System Administration Guide


Value	Description
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 database
PS Version (Required Value)	The tools release of the environment
Data Obj Version	The version number of the PeopleSoft application, as defined in the Data Objects Maintenance table. Select a value in this field only if you plan on using Stat to manage data objects within this environment.
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)	Oracle
Syntax Override	N/A
ODBC DSN	N/A
Database Name	The name of the environment (TNS Alias). Used by the Stat Client for auto-migration to the staging database and to the target.
DB User ID	N/A
DB Password	N/A
Database Server	The name of the environment (TNS Alias). The same as the Database Name above. Neither should be preceded by a “@” sign.
Srv Logon ID	The Oracle user ID for the PeopleSoft schema owner. The PeopleSoft default is “sysadm.”
Server Pwd	The Oracle password for the Srv Logon ID
Host Name	Name of the machine hosting the database. Required value for the Stat Central Agent connection. However, N/A if the Use Tns option is selected.
Service Name	The listener service of the database. Used by the Stat Central Agent and the Stat Oracle Agent to establish JDBC connections to the Oracle database. Required value for the Stat Central Agent connection. However, N/A if the Use Tns option is selected.
DB Listener Port	Port number for the database listener (Oracle default value is 1521). Required value for the Stat Central Agent connection. However, N/A if the Use Tns option is selected.
Use Tns	For RAC Oracle databases, configures Stat to invoke TNS
Tns Entry	The full description as it appears in the tnsnames.ora file with no line breaks or carriage returns
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. CAUTION: Specifying an incorrect value in this field can result in the deletion of a user’s configuration data during a migration in which CLI functionality is invoked.
Base Language	For PeopleSoft 8.4.x or higher, the base language of the environment. The default is ENG. CAUTION: When migrating archive sets, the base language of the staging database must be the same as the base language of the environment that the archive set came from (i.e., the source).
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

Microsoft SQL Server


Value	Description
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. NOTE: If the database is running on a SQL Server instance, the format must be “host name\instance name”
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. NOTE: If the database is running on an SQL Server instance, you must define the name of the instance using the following format: “instance=instance name” NOTE: If you enabled ssl on a Stat Database server running SQL Server, you must add ssl=require to the list of properties.
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. CAUTION: Specifying an incorrect value in this field can result in the deletion of a user’s configuration data during a migration in which CLI functionality is invoked.
Base Language	For PeopleSoft 8.4.x or higher, the base language of the environment. The default is ENG. CAUTION: When migrating archive sets, the base language of the staging database must be the same as the base language of the environment that the archive set came from (i.e., the source).
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


Value	Description
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. NOTE: An alternative to the mainframe currentSQLID is to create an alias to all the DB2 PeopleSoft Staging tables accessed through Stat. An example of this can be found in the comments found at the end of the DB2 mainframe staging script StageDB2-OS390-855.sql.
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. CAUTION: Specifying an incorrect value in this field can result in the deletion of a user’s configuration data during a migration in which CLI functionality is invoked.
Base Language	For PeopleSoft 8.4.x or higher, the base language of the environment. The default is ENG. CAUTION: When migrating archive sets, the base language of the staging database must be the same as the base language of the environment that the archive set came from (i.e., the source).
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


Value	Description
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. CAUTION: Specifying an incorrect value in this field can result in the deletion of a user’s configuration data during a migration in which CLI functionality is invoked.
Base Language	For PeopleSoft 8.4.x, the base language of the environment. The default is ENG. CAUTION: When migrating archive sets, the base language of the staging database must be the same as the base language of the environment that the archive set came from (i.e., the source).
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

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Stat 6.1 - System Administration Guide

Oracle 10g, 11i, and 12c

Microsoft SQL Server

UDB for OS/390

UDB for AIX/Unix