I am receving bSQL3340N error while trying to LOAD REPLACE in DB2 LUW
[dbserver1]/mnt/loads:> db2 “load from 10.out of DEL MODIFIED BY coldel, messages msg.out replace INTO db2inst1.customer NONRECOVERABLE ALLOW READ ACCESS”
SQL3340N Unable to perform a load with concurrent read access to the table.
Reason code = “1”.
db2 ? SQL3340N
SQL3340N Unable to perform a load with concurrent read access to the
table. Reason code = “<reason-code>”.
The ALLOW READ ACCESS option of the LOAD command is not supported in the
following cases as specified in the “<reason-code>”:
1. When using LOAD REPLACE.
2. When using INDEXING MODE DEFERRED.
3. When the target table is in the Set Integrity Pending state and is
not in the Read Access only state.
4. When the indexes are marked invalid.
5. When using LOAD TERMINATE or LOAD RESTART on a load that did not use
the ALLOW READ ACCESS option, or when temporary files from the
original load are missing.
Resubmit the command using the ALLOW NO ACCESS option.
We need to resubmit the load by taking out “ALLOW READ ACCESS”