News
Abstract
Blocked insert is extended to include tables containing generated columns.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > Blocked insert support of generated columns
Prior to this enhancement, attempts to use blocked insert for data load into a table that included one or more generated columns would succeed, but the joblog would include the CPF4028 message with reason code 11.
CPF4028:
Member <member> file <file> in library <library> was opened with the SEQONLY(*YES) parameter specified in the program or on the Override Database File (OVRDBF) command.
Member <member> file <file> in library <library> was opened with the SEQONLY(*YES) parameter specified in the program or on the Override Database File (OVRDBF) command.
However, the parameter has been changed to SEQONLY(*NO) because of condition 11 shown below:
11 - The file, or a physical file on which the file is based, has a column that is a
ROW-BEGIN, ROW-END, TRANSACTION-START-ID, or generated expression.
With this enhancement, the database is able to implement the blocked insert request and the CPF4028 with Reason 11 will no longer be seen.
11 - The file, or a physical file on which the file is based, has a column that is a
ROW-BEGIN, ROW-END, TRANSACTION-START-ID, or generated expression.
With this enhancement, the database is able to implement the blocked insert request and the CPF4028 with Reason 11 will no longer be seen.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
13 April 2021
UID
ibm16442059