Overview of the PeopleSoft environment

An initial implementation of one of these applications consists of a very large database. This database contains a few table spaces and thousands of tables. These tables might contain more than 20 object types and more than 15,000 objects. For example, each testing and production environment for a large distribution warehouse might contain the following objects:

• 50 databases
• 400 table spaces
• 10,000 tables
• 7,000 indexes
• 10,000 views

A PeopleSoft database contains these categories of tables:

• Db2 system catalog tables contain characteristics of tables, columns, and views, and store indexes.
• PeopleTools tables, which are internal tables that PeopleSoft supplies, contain object-related data, such as definitions of fields, records, panels, menus, and projects. You use PeopleSoft tools such as the Application Designer to modify these tables.
• Application (data) tables contain data that the user creates. You can use BMC AMI Change Manager for Db2 to modify the definition of these tables.

As a result of having a large number of tables, objects, and transactions, the PeopleSoft database administrator (DBA) faces many challenges:

• Creating copies of an existing environment
  • Making mass changes to data definition language (DDL) attributes
  • Maintaining the data integrity of the PeopleSoft application
  • Identifying dependent objects
  • Managing complicated views
• Optimizing the design of an environment
  • Moving empty tables to a table space
  • Moving tables to a new database in which each table is in its own table space