Tuesday, March 20, 2012

Operation not allowed for reason code "7" on table "YourTableHere" in DB2

Note to self: When you make a change to a DB2 table and you see the following database error in the logs:
Operation not allowed for reason code "7" on table "YourTableHere"

It is time to issue a reorg on the table via this:
CALL sysproc.admin_cmd('REORG TABLE YourTableHere');

14 comments:

Unknown said...

Thanks, this helped me out!

Agustin Collado said...

Thanks very much, it help me a bunch

Unknown said...

Thank you very much

Anonymous said...

Thanks a lot!!!!

Anonymous said...

Thanks! This was extremely helpful!

Anonymous said...

MUCHAS GRACIAS.

Anonymous said...

lifesaver!

Anonymous said...

I was two seconds from unleashing total destruction on my computer, then I found this and totally saved the day. Thank you good sir.

Anonymous said...

Thanks. That fixed it for me!

Excellent error message from IBM DB2.

Muthu and Mufi said...

NANDI

Anonymous said...

Thanks a lot - that worked!

Anonymous said...

Saved my bacon, thanks!

Anonymous said...

Salvou a minha vida!

Anonymous said...

Thank you man you saved me, blessings to you