-650 error code with Reason code 24 solution?



IBM's flagship relational database management system

-650 error code with Reason code 24 solution?

Postby MFDEV » Mon Feb 08, 2016 9:28 pm

Hi All, I am getting -650 error code , Reason 24 while trying to drop column from the table as ALTER TABLE DATABASENAME.TSNAME DROP COLUMN COLUMN1 RESTRICT . I have tried Reorg table space and before that took image copy but still getting same error.

Error message: 24
An ALTER TABLE statement with pending options is allowed only for universal table spaces.

Any help ?
MFDEV
 
Posts: 15
Joined: Mon Dec 01, 2014 3:25 pm
Has thanked: 2 times
Been thanked: 0 time

Re: -650 error code with Reason code 24 solution?

Postby Akatsukami » Mon Feb 08, 2016 9:49 pm

Use the DISPLAY DATABASE command with the SPACENAM keyword to determine the status of the table space in question, and take the appropriate action(s) to return it to RW status.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day

These users thanked the author Akatsukami for the post:
MFDEV (Thu Aug 04, 2016 9:59 am)
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: -650 error code with Reason code 24 solution?

Postby MFDEV » Sat Feb 13, 2016 5:35 pm

Thanks for the details and I found that it is segment table space which needs to be converted to UTB first to clear this error.
MFDEV
 
Posts: 15
Joined: Mon Dec 01, 2014 3:25 pm
Has thanked: 2 times
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post