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 >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing