View previous topic :: View next topic
|
Author |
Message |
jsk
New User
Joined: 20 Feb 2006 Posts: 12
|
|
|
|
Hi,
I faced an issue recently while issuing an ALTER Table space via Batch Job.The SQLCODE was -626 indicating Page set not stopped.
ALTER TABLESPACE <>
USING STOGROUP <>
BUFFERPOOL <>
PART 01
PRIQTY 3
SECQTY 3
Code: |
DSNT408I SQLCODE = -626, ERROR: THE ALTER STATEMENT IS NOT EXECUTABLE BECAUSE THE PAGE SET IS NOT STOPPED
DSNT418I SQLSTATE = 55015 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXIATS SQL PROCEDURE DETECTING ERROR
|
Do this mean the DB needs to be stopped before issuing ALTER command? I also happen to see the status of DB on which ALTER needs to be performed as AREO(Advisory Reorg Pending) and do have 16 Partitions, Does this contribute to issue.
Thanks,
JSK. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Quote: |
DSNT408I SQLCODE = -626, ERROR: THE ALTER STATEMENT IS NOT EXECUTABLE BECAUSE THE PAGE SET IS NOT STOPPED |
Quote: |
Do this mean the DB needs to be stopped before issuing ALTER command? |
How about looking up the message itself and taking note of suggested remedial action? Talk to your DBA. The usual sort of stuff. |
|
Back to top |
|
|
jsk
New User
Joined: 20 Feb 2006 Posts: 12
|
|
|
|
Hi Bill,
Thanks for reply,
Yes even I thought and checked with DBA; but got response no need to stop the DB as it is V9 as opposed to DB2 V8.
But the meesage say's it is, So thought to get suggetions from experts.
Thanks, |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
OK, you need to tell us all that sort of stuff when you state the problem, otherwise we just get this sort of wasted time.
I'd re-approach the DBA. Diplomatically. Say that you have a problem that you can't sort out and you don't understand. Show them the control statements you have and the message you are getting. Don't ask any technical-sounding questions. Play dumb. Maybe they'll want to impress you with an answer.
Before/after try to check out in manuals for V9 if what they said is true. If it is, is your particular DB actually up to V9? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
for "alter bufferpool" you still and probably always will have to stop the page set, not the complete database.
"page set" stands for tablespace or partition |
|
Back to top |
|
|
|