IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Alter Table Space- DB2 V 9


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
jsk

New User


Joined: 20 Feb 2006
Posts: 12

PostPosted: Thu Sep 22, 2011 2:14 pm
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Thu Sep 22, 2011 2:20 pm
Reply with quote

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
View user's profile Send private message
jsk

New User


Joined: 20 Feb 2006
Posts: 12

PostPosted: Thu Sep 22, 2011 2:27 pm
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Thu Sep 22, 2011 2:41 pm
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Sep 22, 2011 8:15 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top