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
z/OS CA Datacom 15.1
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.