Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Alter Table Space- DB2 V 9

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Alter Table Space- DB2 V 9
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Thu Sep 22, 2011 2:20 pm    Post subject: Re: Alter Table Space- DB2 V 9
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    Post subject: Reply to: Alter Table Space- DB2 V 9
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Thu Sep 22, 2011 2:41 pm    Post subject: Reply to: Alter Table Space- DB2 V 9
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts The TS7720 is out of cache space. Rex Montemayor All Other Mainframe Topics 2 Mon Sep 25, 2017 7:18 am
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us