How to calculate space for new Datacom table?

book

Article ID: 14931

calendar_today

Updated On:

Products

CA Datacom CA DATACOM - AD CA Datacom/AD

Issue/Introduction



How to calculate the space that is needed for a new Datacom TABLE  with following attributes?

 

New table XXX049

 

- Col_A - UZ 2

- Col_B - UZ 5

- Col_C - UZ 4

- Col_D - UZ 3

- Col_E - X 3

- Col_F - UZ 4

- Col_G - UZ 4

- Col_H - X 1

- Col_I - NP 15.2

- Col_J - NP 15.2

- Col_K - NP 15.2

- Col_L - NP 15.2

- Col_M - NP 15.2

 

The row length based on those column definitions is 71 bytes.

 Key - Col_A, Col_B, Col_C, Col_D, Col_H

 Records expected in the table - 2 000 000

Environment

z/OS CA Datacom 15.1

Resolution

Run a  DBUTLTY Data Area Space Estimation Report .

See the online documentation in Techdocs.broadcom.com here .

Run  DBUTLTY REPORT DEVICE=3390,RECSIZE=71,RECORDS=2000000,RECOVERY=YES.