Should I use blocksize larger than 4096 for my IXX?

book

Article ID: 15909

calendar_today

Updated On:

Products

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

Issue/Introduction

When defining the index for a CA Datacom database, the default blocksize is 4096.  For many types of files, changing a blocksize to a larger value will help performance of that file. However, this is not true for all types of files.



Should I use blocksize larger than 4096 for my IXX?

Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

Resolution

The default value of 4096 has been identified as the optimum blocksize for the index. In fact, this was the only option for the longest time, and an option to use 8192 was introduced for a specific, unique situation. The tradeoff here is that while you might save very minimally on your I/O to the index, you will also increase your CPU usage and search times scanning the index records.

Consequently, there is no real benefit in increasing the blocksize for most databases, and there is a possible detriment to overall performance. In addition, unless the blocksize for every database is changed to this higher value, there is a potential increase in the amount of storage used for index buffers, and a possibility that half of this buffer storage is wasted by having to allocate buffers at the largest blocksize.

Additional Information

As always, please contact CA Technologies support for CA Datacom if you have further questions.