Snapshot of the initial environments—use case
Your company just purchased an ERP system. You need to implement the PeopleSoft application suite and create a demonstration (DMO) database environment and a system (SYS) environment.
- The DMO environment includes PeopleTools tables that are loaded with data and application data tables that are loaded with data supplied by PeopleSoft. This environment is not customized; it is used only as a demonstration of the functionality of PeopleSoft.
- The SYS environment includes PeopleTools tables that are loaded with data and application data tables that are not loaded with data. This environment is used as the basis for development and production environments.
To create the environments, you perform vanilla implementations of the applications (that is, you implement the applications without customizing them or modifying the supplied scripts or DDL). You perform these vanilla implementations by using tools that are delivered with PeopleSoft.
After you create the DMO and SYS environments, you can use BMC AMI Change Manager for Db2 to take a snapshot (that is, create a baseline) of the Db2 catalog in each of the environments. Change Manager enables you to establish full-recovery baselines to capture data structures and data at a specific point in time. These baselines act as control points in the change migration process and establish a static set of data structures for an application version.
Taking a snapshot of the initial environments
Baseline tables (named BL_name) are stored in Change Manager. These tables hold critical information that is used to recover database structures.
If you regularly establish baselines, these baseline tables grow over time. You must ensure that these tables are reorganized and that the size of the tables is expanded on a regular basis.
In addition, Change Manager stores the table data in UNLOAD data sets and stores the specified unload options with the baseline. You must retain the UNLOAD data sets for as long as a recovery point might be needed.
To take a snapshot of an environment
- Create a Db2 catalog baseline profile that uses scope rules for the DMO environment.A baseline profile contains information about how baselines are named and established and may also contain scope rules. Scope rules indicate which Db2 objects to include in a baseline. A baseline profile can be created for each environment and can be used repeatedly.
- Create a Db2 catalog baseline of the DMO environment, using the catalog baseline profile to define the scope.
- Create a Db2 catalog baseline profile that uses scope rules for the SYS environment.
- Create a Db2 catalog baseline of the SYS environment, using the second catalog baseline profile to define the scope.
Where to go from here
You can also use Change Manager to generate baseline reports from the baselines that you created. A baseline report includes general information about the baseline, DDL and commented-out GRANT statements for each object, and the unload data set names that are associated with a full-recovery baseline.
Related topic