You can alter the PRIQTY and SECQTY without stopping it. The changes
will not take effect until it is reorged with redefine yes or another
extent is needed.

Wayne Stevens
Wayne.[Email address protected]

-----Original Message-----
From: JAMES PARK
[mailto:db2udbdba-ezmlmshield-x22250469.[Email address protected]
Sent: Monday, November 19, 2007 10:24 AM
To: LazyDBA Discussion
Subject: alter tablespace

Hi, listers.

DB2 v7 on z/OS.


I am going to alter PQTY and SQTY of a tablespace.

Do I need to stop only the tablespace or the database where the
tablespace is in?
My guess is that I need to stop only the tablespace.

Thanks,

James Park
Database Specialist II
Annapolis Data Center
410-260-7489
[Email address protected]




------------------------------------------------------------------------
------
This email and any file transmitted with it may be confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. If you received this email in error, please notify the
Comptroller's System Manager by forwarding this message to [Email
address protected]
========================================================================
======



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page