CA Datacom How to change area blocksize in datadictionary?


Article ID: 130217


Updated On:


CA Datacom CA DATACOM - AD CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware


 What modifications are needed in datadictionary to change the block size of an area?


Release: DATABB00200-14.0-Datacom/AD


You can make the datadictionary changes directly to PROD structure. However if a history of changes is required, then copy the structure to TEST first, modify the blocksize in TEST with the 3002 transaction then copy to PROD and catalog the database. 

The PROD structure can be modified directly using the 1000 ALTER transaction which also updates the CXX without having to close the database.

Sample DDUPDATE cards to make the block size change:

-UPD AREA,area_name(PROD)
1000 ALTER
1500 BLOCK-SIZE,27998

The new blocksize will not take effect until you INIT and re-LOAD the area.

In Datacom 15.1 there is a new Alter Area Block Size (BA24) feature which allows a change to the block size while the data stays available.

Additional Information

See DocOps section 1000 ALTER Transaction
and Performing a Block Size Alter 24x7 or Online Table Move