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');
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:
Thanks, this helped me out!
Thanks very much, it help me a bunch
Thank you very much
Thanks a lot!!!!
Thanks! This was extremely helpful!
MUCHAS GRACIAS.
lifesaver!
I was two seconds from unleashing total destruction on my computer, then I found this and totally saved the day. Thank you good sir.
Thanks. That fixed it for me!
Excellent error message from IBM DB2.
NANDI
Thanks a lot - that worked!
Saved my bacon, thanks!
Salvou a minha vida!
Thank you man you saved me, blessings to you
Post a Comment