How to calculate space for new table?

Document ID:  TEC1734122
Last Modified Date:  07/05/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Datacom/DB

Releases

  • CA Datacom/DB:Release:14.0
  • CA Datacom/DB:Release:15.0
  • CA Datacom/DB:Release:15.1

Components

  • CA DATACOM/DB:DB
Question:

How do I calculate the space that is needed for a new Datacom AREA/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

 

 

 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.0
Answer:

The ROW length is  71 bytes.

Run a  DBUTLTY Data Area Space Estimation Report .See the DBUTLTY Reference Guide or the online documentation in Docops.ca.com . 

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

 

There are other parameters that you can code. 

Additional Information:

For more details see the Online Documentation DocOps.ca.com

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >