On Jun 20, 5:01 am, "Okonita via DBMonster.com" <u36825@uwewrote:
Hi all,
We install DBv9.5 64-bit on a Linux server. While creating user tablespaces
(e.g., TS0004k regular) we find that DB2 control center does not allow us to
add the container location for the tablespace. DB2 automatically assigns a
location which happens to be the same path as the database path. Obviously,
this is not acceptable.
Has any experienced this situation? What was the solution?
Thanks
--
Message posted via DBMonster.comhttp://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200806/1
Hi,
It's been a while since I used the Control Center myself but at some
point it should be asking you if you want DB2 to manage the storage
(using automatic storage) or if you want to define the storage
manually. It sounds like you might have chosen the first option, in
which case it won't allow you to specify the containers. With
automatic storage, containers will automatically be assigned based on
the storage paths associated with the database. If no storage paths
were explicitly specified when the database was created then the
database path doubles as a storage path.
Regards,
Kelly Schlamb