Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

Overview of the PeopleSoft environment

The PeopleSoft application suite consists of the following applications:

  • Human Resources Management (HRMS)
  • Financials (FIN)
  • Supply Chain Management (SCM)
  • Customer Relationship Management (CRM)

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


Related topic

Managing-your-PeopleSoft-environment-with-Change-Manager

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*