Understanding Administration ToolsThis chapter provides overview information and discusses:
PeopleTools Security.
PeopleSoft Performance Monitor.
PeopleSoft Diagnostic Framework.
PeopleSoft Data Mover.
Data Integrity Tools.
PeopleTools Utilities.
PeopleSoft Configuration Manager.
Understanding Administration ToolsWith Information Technology infrastructure becoming more complex, Enterprise PeopleTools offers the state-of-the-art tools to make maintenance easy and cost-effective. The Enterprise PeopleTools administration tools enable system administrators to manage the applications you have deployed within your organization. The administration tools enable you to perform numerous administrative tasks, such as configure security, monitor performance, troubleshoot, upgrade to new versions, apply patches, and transfer data from target to source systems. Most of the tasks can be completed using the same browser interface used for completing business transactions in PeopleSoft applications.
PeopleTools SecurityThe PeopleSoft security approach is tailored for the internet. As you implement PeopleSoft, you need a robust and scalable means by which you can grant authorization to users efficiently. When you deploy your applications to the internet, the number of potential users of your system increases exponentially. Suddenly, you have customers, vendors, suppliers, employees, and prospects all using the same system.
You can apply security to all users, including employees, managers, customers, contractors, and suppliers. You group your users according to roles to give them different degrees of access. For instance, there might be an Employee role, a Manager role, and an Administrator role. PeopleTools Security enables you to manage the role-based system, including directory group import capabilities, to leverage your Lightweight Directory Access Protocol (LDAP) directory facilities.
Users who belong to a particular role require a specific set of permissions, or authorizations, within your system so that they can complete their daily tasks. Because of the increase in users due to the internet deployment, PeopleTools Security enables you to perform numerous maintenance tasks programmatically, which enables your system administrators to focus on other tasks.
See Also
Getting Started with Security Administration
PeopleSoft Performance MonitorPeopleSoft Performance Monitor is a built-in diagnostic utility that enables system administrators to monitor performance of the main elements of your PeopleSoft system, such as web servers, application servers, and PeopleSoft Process Scheduler servers. You can monitor real-time performance as well as analyze historical data.
PeopleSoft Performance Monitor reports:
Durations and key metrics of PeopleTools runtime execution, such as SQL statements and PeopleCode events.
Key resource metrics, such as host CPU utilization and web server execution threads.
The metrics provided by PeopleSoft Performance Monitor enable system administrators to:
Monitor real-time system performance.
Identify poorly performing tiers, hosts, domains, servers, application code, and SQL in a PeopleSoft environment.
Identify performance trends.
Address and isolate performance bottlenecks.
See Also
Getting Started with Performance Monitor
PeopleSoft Diagnostic FrameworkThe PeopleSoft Diagnostic Framework is designed to facilitate the diagnosis and resolutions of incidents by PeopleSoft Global Support Center (GSC). It enables the critical system data to be packaged and sent to PeopleSoft Global Support Center without the need for IT intervention. This reduces administration overhead and can help PeopleSoft solve customer issues more quickly.
The diagnostic framework retrieves diagnostic information from a PeopleSoft database enabling you to:
Discover problematic application-related data.
Explore setup details.
Present information to PeopleSoft support in a common format.
See Also
Getting Started with Data Management
PeopleSoft Data MoverPeopleSoft Data Mover enables you to perform the following tasks:
Transfer application data between PeopleSoft databases.
Move PeopleSoft databases across operating systems and database platforms.
Execute Structured Query Language (SQL) statements against any PeopleSoft database, regardless of the underlying operating system or database platform.
Create, edit, and run scripts.
PeopleSoft Data Mover provides a development interface that enables you to create scripts using specific commands. You can run scripts from the development environment or from a command line. You use PeopleSoft Data Mover during the PeopleSoft installation, but it is also used for a variety of maintenance tasks.
See Also
Getting Started with Data Management
PeopleSoft Data Archive ManagerIn any enterprise application, the ability to purge and archive transactional data is critical to data management. You need to have consistent methods to archive transactional data before your database increases to unmanageable sizes. PeopleSoft Data Archive Manager provides an integrated and consistent framework for archiving data from PeopleSoft applications. Using a predefined template, you can select any queries and multiple objects that meet your archiving and restoration requirements. Leveraging the Archive Query in PeopleSoft Query, you can easily define and customize your archive template.
See Also
Using PeopleSoft Data Archive Manager
Data Integrity ToolsPeopleSoft provides several tools to ensure the integrity of the data that is stored in the PeopleSoft system. Typically, you use these tools during installations, upgrades, and system configuration to verify the PeopleSoft system and compare it to the underlying SQL objects to ensure synchronization. Data Integrity tools include:
|
SYSAUDIT |
The System Audit (SYSAUDIT) identifies orphaned PeopleSoft objects and other inconsistencies within the system. An example of an orphaned object is a module of PeopleCode that exists, but which does not relate to any other objects in the system. |
|
DDDAUDIT |
The Database Audit Report (DDDAUDIT) finds inconsistencies between PeopleTools record and index definitions and the database objects. This audit focuses on tables, views, and indexes. |
|
SQL Alter |
The PeopleSoft Application Designer SQL Alter function brings SQL tables into accordance with PeopleTools record definitions. |
See Also
Getting Started with System and Server Administration
PeopleTools UtilitiesAs you work with the PeopleSoft system, you find that there are some administrative tasks that you only need to perform occasionally. The PeopleTools Utilities provides a set of tools for accomplishing some of these more infrequent tasks. Examples of tasks that require the use of the PeopleTools Utilities are:
Setting your base language.
Specifying a specific style sheet.
Setting PeopleBook Help locations.
Editing messages in the message catalog.
Entering values in the URL catalog.
Setting PeopleCode and SQL trace options.
See Also
Getting Started with System and Server Administration
PeopleSoft Configuration ManagerPeopleSoft Configuration Manager simplifies Windows workstation administration by enabling you to adjust PeopleSoft registry settings from one central location. Note that the Configuration Manager applies only to workstations being used by developers and system administrators who need access to the development environment. For example, developers who need to access PeopleSoft Application Designer to view and modify pages, records, components and so on need the appropriate options set in the PeopleSoft Configuration Manager.
PeopleSoft Configuration Manager contains a variety of controls that let you set up workstations for connecting to the database, connecting to application servers, or setting trace options. You can set up one development workstation to reflect the environment at your site, and then export the configuration file, which can be shared among all the development workstations at your site.
See Also
Getting Started with System and Server Administration
Using PeopleSoft Configuration Manager