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.....
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.....