Section 2, Task 2: Create Your Production PDB

You now have the test PDB customized the way that you want it. This task will walk you through creating your production PDB and copying the structure and settings and data of your test PDB to your production PDB.

1. Your test PDB is the active PDB.
   
   
2. You have write access to your test PDB.
   
   
3. You have chosen a name for the PDB that this task will produce.

   In this task you will create a permanent PDB for your collector's data. In this document, we will refer to that PDB as your production PDB.

   A typical name is something like:

1. Estimate the size of your production PDB.

   Use an operating system utility such as:

   MVS	ISPF 3.4
   UNIX	du -s
   WNT	Windows Explorer

   to check for the amount of space used by each library (DETAIL, DAY, WEEK, MONTH, YEAR) of your PDB. This amount indicates the amount needed for one unit of data (where a unit is a day for the DETAIL library and the DAY library, a week for the WEEK library, a month for the MONTH library, and a year for the YEAR library). Extrapolate for the length of time (age limit) that you selected for each level.

   The amount of data at the day, week, month, and year reduction levels is a function of the number of unique combinations of class variables values that are present in your data.

   Note: The amount of space used at week, month, and year levels does not show any appreciable increase until data for another week, month, or year are processed. The data currently stored in the week level, for example, represent a summarization of the whole week and, as such, will be modified by updates to the data during the week, not by additions.

2. Decide where to create your production PDB.

   Your estimate of the size of the fully populated PDB may affect where you want the production PDB to reside.

3. Create your production PDB.
   
   

Section 2, Task 2: Create Your Production PDB