But to pull in the new sizes, you do need to run the reorg utility.
>>> "Igor Galperin "
<db2udbdba-ezmlmshield-x75213896.[Email address protected] 11/19/07 11:28
AM >>>
You do not need to stop anything.
-----Original Message-----
From: JAMES PARK
[mailto:db2udbdba-ezmlmshield-x22250469.[Email address protected]
Sent: Monday, November 19, 2007 8: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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail message from State Compensation Insurance Fund and all
attachments transmitted with it may be privileged or confidential and
protected from disclosure. If you are not the intended recipient, you
are hereby notified that any dissemination, distribution, copying, or
taking any action based on it is strictly prohibited and may have legal
consequences. If you have received this e-mail in error, please notify
the sender by reply e-mail and destroy the original message and all
copies.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---------------------------------------------------------------------
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