<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
We are developing a program where we read records from a table, process them in a COBOL/RPG program, store the processed record in an array and when a certain block size is reached we do a bulk INSERT.<br />
<br />
How do I derive the optimal block size? What are the factors that I need to keep in mind in deriving the block size.<br />
<br />
If there are any pointers/articles out there which you may have found useful in this regard, could you please share them?<br />
<br />
Regards<br />
Ali.
</div>
</div>


Hi,

We are developing a program where we read records from a table, process them in a COBOL/RPG program, store the processed record in an array and when a certain block size is reached we do a bulk INSERT.

How do I derive the optimal block size? What are the factors that I need to keep in mind in deriving the block size.

If there are any pointers/articles out there which you may have found useful in this regard, could you please share them?

Regards
Ali.

Factors for determining a block size for bulk INSERT's in DB2?

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

IBM System i

COBOL (Common Business-Oriented Language) is a programming language with English-like syntax. It is readable but verbose compared to other programming languages. CODASYL (Conference on Data Systems Languages) created COBOL in 1959 based on design work from Grace Hopper. It was standardized in 1968. COBOL is still present in large-scale batch processing and transaction processing where legacy applications are being used, usually in government, financial, and administrative systems.