SQL3340N Unable to perform a load with concurrent read access to the table

Problem Statement:

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>”.

Explanation:

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.

User response:

Resubmit the command using the ALLOW NO ACCESS option.
Solution:
We need to resubmit the load by taking out “ALLOW READ ACCESS”

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: