Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extend a DMS tablespace

Status
Not open for further replies.

kozlow

MIS
Mar 3, 2003
326
US
I am not a DB2 admin, but we do not have one anymore...
Database manager configuration release level = 0x0900
Running on a AIX server.

I have a DMS tablespace that I would like to extend:
db2 -v "ALTER TABLESPACE INDEX02 EXTEND ( DEVICE '/dev/rindex02lv' 131136 )"

I have already added the space to the logical volume rindex02lv. Will it know that I added the space to the raw device, or should I have created a new logical volume?

I am also looking to find out if I extend the tablespace, will it stop the database? In other words, do I need to schedule downtime to run the EXTEND?

I have made the mistake of running RUNSTATS on tables and users where unable to do anything.....

Thanks in advance.....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top