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

Stat Central Agent Rights

Stat Central Agent rights are not service domain-specific. They control a user’s ability to define printers and jobs for the Stat Central Agent.

Agent Jobs - Add

Enables the user to add new Stat Central Agent Jobs from within Job Maintenance

Agent Jobs - Edit

Enables the user to edit existing Stat Central Agent Jobs from within Job Maintenance

Agent Printers - Add

Enables the user to add new Stat Central Agent Printer definitions from within Stat Central Agent Printer Maintenance

Agent Printers - Edit

Enables the user to edit existing Stat Central Agent Printer definitions from within Stat Central Agent Printer Maintenance

Tool Rights

Some Tool rights are service domain-specific, while others are not. They control a user’s ability to access and work with certain utilities in Stat.

Table 17. Tool Rights

Agent Job Monitor

Gives the user access to the Agent Job Monitor in Stat Web

Agent Test Connect

Gives the user access to the Test Connect Page in Stat Web Client

Create Personal Rules

Enables the user to create Personal Rules

Data Replication - Inbound

Enables the user to replicate data into the current database from a different database

Data Replication - Outbound

Enables the user to replicate data from the current database to a different database

Enterprise Console -Workload Monitor

Enables the user to access the Enterprise Console

Launch INI File Editor

Enables the user to open the INI File Editor from Stat

PS Object Mover Instructions - Upd

Enables the user to update the PS Object Mover Instructions

Purge CSRs Without Doing Export

Enables the user to purge a CSR without creating an export file. CSRs purged this way can never be restored.

Run CSR Purge for Open CSRs

Enables the user to run the purge on Open CSRs. This should be rarely used.

Run CSR Purge Wizard

 

Enables the CSR Purge Wizard to be available on the Tools Menu.

Save System Report Criteria

Enables the user to add and edit system-level Report Criteria from within the Report Library

Schedule Reports

Enables the user to schedule reports to run automatically

Table Dump Utility - Run

Enables the user to run the Table Dump Utility

Wizard Rights

Some Wizard rights are service domain-specific, while others are not. They control a user’s ability to run certain wizards in Stat.

Table 18. Wizard Rights

Archive Set Sync Wizard - Migrate

Enables the user to migrate from the Archive Set Sync Wizard

Obj Archive Purge Wizard - Run

Enables the user to run the Archive Purge Wizard

Obj Archive Search Wizard - Run

Enables the user to run the Object Archive Search Wizard

Obj Mass Migration Wizard - Run

Enables the user to run the Mass Migration Wizard

Obj Migration History Wizard - Run

Enables the user to run the Migration History Wizard

Obj Recovery Wizard - Run

Enables the user to run the Recovery Wizard

Release Recovery - Run

Enables the user to run the Release Recovery Wizard

Undocumented Obj Wizard -Run

Enables the user to run the
Undocumented Object Wizard

Undocumented Patch Wizard - Run

Enables the user to run the Undocumented Patch Wizard.

Appendix: Creating a Staging Database

Staging databases are used when migrating archive sets from your Stat database to a PeopleSoft database. A staging database is essentially a mini-PeopleSoft database with no application data and minimal tools data. Once created it should be maintained and tuned the same as other PeopleSoft databases in your environment.

Depending on the volume of objects moved or number of PeopleSoft tools versions you are supporting, you may decide to have multiple staging databases. This section describes how to create a staging database in Stat.

For PS version 8.x and higher – The staging database can either be a PeopleSoft demo (DEMO) or system (SYS) database. For detailed instructions on creating this database, please see your PeopleSoft Installation and Administration Guide. Financial databases in particular have a large number of tables used for sorting data. These can be dropped from the staging database.

Once you have created your AUD, Demo, or System database, execute the appropriate script

If running on DB2 execute StageDB2-OS390-855.sql (for mainframe), or StageDB2-UNIX-855.sql (for Aix/Unix)

These scripts complete the creation of a staging database. It is recommended that you create at least 2 staging databases. You may need to alter this script to match your platform.

Related Documents