SQL0668N Operation not allowed for reason code “x” on table

When you loading all database with db2move command, propably most of the tables being loaded are in pending state. To check which ones, execute SQL statement:

SELECT tabname,status,const_checked FROM syscat.tables WHERE status=’C’
This command will list all tables in pending state

Reson code:

* “1” – table is in pending state – to fix this execute
SET INTEGRITY FOR table_name IMMEDIATE CHECKED

* “3” – previous load operation on this table failed. You have to terminate or restart previous load command

source: http://www.dbforums.com/6464822-post1.html

Advertisements

About davidand

Hi, welcome to my blogs. My name is David Andriansyah. I am currently working as an independent Cognos Business Intelligence consultant, and I also as Freelance Web Developer. View all posts by davidand

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: