Calculating space required for TEXTDATA

The TEXTDATA backstore data set contains dynamic SQL text on a summary level if OPTKEYS(TEXT) is specified. If OPTKEYS(TEXT) is not in effect, we recommend TEXTDATA_PRIMARY(1) and TEXTDATA_SECONDARY(0) specified in CQMPARMS.

About this task

To determine the average quantity of space required for the TEXTDATA data set:

Procedure

  1. Determine the average length of dynamic SQL text within an interval.
  2. Take the average length of dynamic SQL text and divide by 32000, round up, and multiply by 28.
  3. Determine the number of Cis required and use the METRDATA calculation. Replace the METRDATA record length with the value computed in step 2. Replace the number of unique SQL calls with the number of unique dynamic SQL statements per interval.