Whenever we acquire a new customer that often requires several million of records to be mass loaded to our existing databases that utilizes DB compression. This causes a problem in being able to estimate the amount of DASD space needed to be available to a DBID to hold all of the new set of records. Is there anything that would estimate the space needed before a MASSADD?
Release : 15.1
Component : Datacom/DB
Here is a process to determine how many tracks or cylinders to add to your DATA area through the MASSADD function. You may need to also increase your INDEX areas, but we cannot tell you that amount here.
AREA TABLE RECORDS
C02 43,194
TOTAL 43,194
CASE NO COMPRESSION EXTRACT INPUT DB
COMPRESSION TYPE NONE DB DB
STORED BYTES 4,146,624 2,935,906 2,935,906
PERCENT OF UNCOMPRESSED 70.8
CPU TO COMPRESS 000:00:00.023669
CPU TO EXPAND 000:00:00.014594
...+....10...+....20...+....30...+....40...+....50...+....60...+....70...+....80...+..|
---------------------------------------------------------------------------------------
# RCD # MINM # DEVICE # LOGICAL # DATA SPACE REQUIRED #
# PER # BLOCK # BLOCK # RECORDS PER # PRIMARY # GROWTH # TOTAL ## TOTAL #
# BLK # SIZE # SIZE # TRACK # CYLIN # TRACKS # TRACKS # TRACKS ## CYLIN / TRK
#-----#-------#--------#-------#-------#---------#---------#---------##---------/-----#
# 1 # 576 # 588 # 46 # 690 # 760870 # 0 # 760870 ## 50724 / 10 #
# 2 # 1150 # 1154 # 64 # 960 # 546875 # 0 # 546875 ## 36458 / 5 #
# 3 # 1724 # 1748 # 72 # 1080 # 486112 # 0 # 486112 ## 32407 / 7 #
# 4 # 2298 # 2376 # 76 # 1140 # 460527 # 0 # 460527 ## 30701 / 12 #
# 5 # 2872 # 2942 # 80 # 1200 # 437500 # 0 # 437500 ## 29166 / 10 #
# 6 # 3446 # 3768 # 78 # 1170 # 448718 # 0 # 448718 ## 29914 / 8 #
# 7 # 4020 # 4136 # 84 # 1260 # 416667 # 0 # 416667 ## 27777 / 12 #
# 8 # 4594 # 5064 # 80 # 1200 # 437500 # 0 # 437500 ## 29166 / 10 #
# 9 # 5168 # 5726 # 81 # 1215 # 432099 # 0 # 432099 ## 28806 / 9 #
Find the largest entry in the DEVICE BLOCK SIZE column that is equal to or less than your current area block size. For example, if your current blocksize is 4096, the largest value equal to or less than 4096 is 3768 (6 records per block) shown in the highlighted row of the report
Using the highlighted row found in the previous step, locate the TOTAL TRACKS or TOTAL CYLIN/TRK column to get the amount of storage that is estimated to be required for the planned MASSADD.
If you need further assistance understanding these reports, please open a support case for Datacom and include a full CXX report for the database, the Data Area Space Estimation Report (the DEVICE report), and the WHATIFCP report.