Implementing CA Compliance Manager for CA Chorus for Security and Compliance Management › Implement the Data Mart › Load the CA Datacom/AD Data Mart Repository › Estimate the Storage Space for Data Mart CA Datacom/AD Conversion Utility Output Data Sets

Estimate the Storage Space for Data Mart CA Datacom/AD Conversion Utility Output Data Sets

The first step of the CMGRDLDC job converts the information in the UNLOAD data set from a DB2 load format into a CA Datacom/AD load format. This data set is created by the Data Mart unload utility.

The CMGRDLDC job then separates the data sets by target table as required by the CA Datacom/AD load process. The following statements define these data sets in the job:

ADMACCOUNT DD

Specifies the output data set where data converted to CA Datacom/AD load format is placed for the CA Datacom/AD Data Mart repository ADMACCT table.

ADMMISC DD

Specifies the output data set where data that is converted to CA Datacom/AD load format is placed for the CA Datacom/AD Data Mart repository ADMMISC table.

ADMPOLICY DD

Specifies the output data set where data that is converted to CA Datacom/AD load format is placed for the CA Datacom/AD Data Mart repository ADMPOL table.

OBJACCESS DD

Specifies the output data set where data that is converted to CA Datacom/AD load format is placed for the CA Datacom/AD Data Mart repository OBJACC table.

SECCONTROL DD

Specifies the output data set where data that is converted to CA Datacom/AD load format is placed for the CA Datacom/AD Data Mart repository SECCTRL table.

SYSACCESS DD

Specifies the output data set where data that is converted to CA Datacom/AD load format is placed for the CA Datacom/AD Data Mart repository SYSACC table.

USSFILE DD

Specifies the output data set where data that is converted to CA Datacom/AD load format is placed for the CA Datacom/AD Data Mart repository USSFILE table.

USSUSER DD

Specifies the output data set where data that is converted to CA Datacom/AD load format is placed for the CA Datacom/AD Data Mart repository USSUSER table.

These data sets can contain large amounts of event data. Because of this, data sets must be allocated with enough space to allow Conversion Utility processing to complete.

Follow these steps:

1. Use the following equation to calculate the amount of space that is needed for each output data set:

   Total number of DB2 load table records x [(6,395 bytes) [OR] (max record length of a table record)] / 849,960 bytes = ______________ Total space (in cylinders)

2. Review the Data Mart Statistical Report to find the total load records generated in the Data Mart Unload DD data set.
3. Multiply the total number of unloaded records by the maximum Data Mart CA Datacom/AD table record length (6395 bytes). This determines the maximum number of bytes of storage that is needed for each CA Datacom/AD output data set.

   Note: To more accurately determine the amount of space to allocate, use the maximum record lengths for each CA Datacom/AD load table that is listed in the following table.

1. Divide the total number of bytes of storage needed by the number of bytes on a cylinder. The number of bytes per cylinder depends on the hardware disk model you are using. IBM disk model 3390 has 849,960 bytes per cylinder.

   You have determined the total number of cylinders of space to allocate for each CA Datacom/AD load format data set.