Chat now with support
Chat mit Support

Stat 6.3 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Issue Tracking 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: REST Web Services API Appendix: SOAP-Based Web Services API Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Mainframe

1
Locate the StageDB2-ZOS-855.sql script.
2
Find and replace the following variables:
•
[DATABASENAME1] Replace with the name of the database (the name used on the system that connects to the database)
•
[TABLETBSPC1] Replace with tablespace for the new table. Usually use an existing tablespace, so DB2 utilities (that run at the tablespace level) do not have to be modified for the new tablespace (example: image copy).
•
[DATABASENAME2] Replace with the name of the database (for example PSPTDMOX)
•
[CREATORID] Replace with the creator/owner id. Requires the [USERID] to be able to set current sqlid to this [CREATORID] secondary authorization RACF group. Would need to connect [USERID] to the RACF group [CREATORID].
•
[STOGRPNAME] Replace with the Stogroup name for the index. Requires the grant “GRANT USE OF STOGROUP [STOGRPNAME] TO [CREATORID]”

Aix/Unix

1
Locate the StageDB2-UNIX-855.sql script.
2
Find and replace the following variables:
•
[DATABASENAME] Replace with the name of the database
•
[USERID] Replace with the correct user access id
•
[PASSWORD] Replace with the correct access password
•
[TABLETBSPC] Replace with tablespace for the table
•
[CREATORID] Replace with the creator/owner ID of the tables
•
[PEOPLESOFTID] Replace with PeopleSoft login ID

Appendix: Database Tuning

This appendix provides tuning information for Stat databases running on Oracle and MS SQL Server.

Oracle Database Instance Tuning

 
Table 19. Init.ora recommended parameters settings
Name
Recommended

session_cached_cursors

150

sort_area_size

1048576

optimizer_index_cost_adj

35

optimizer_index_caching

90

pga_aggregate_target

25165824

workarea_size_policy

AUTO

open_cursors

300

Run the following command on a weekly basis:

exec dbms_stats.gather_schema_stats(ownname=>'STAT', CASCADE => TRUE);
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen