Modifying/changing DB2 database paths for CLM
Hi All,
Accepted answer
Do any of the databases have tablespace containers stored on these mount points ? ( db2 connect to tha_db, db2 list tablespace containers for X, X is 0,1,2,3,4,5 ... ) An example for the CONTENTTS of a CCM database:
$ db2 list tablespace containers for 4
Tablespace Containers for Tablespace 4
Container ID = 0
Name = /db2/tstinst1/ContentTS/CCM
Type = File
Another more complex example where I have added containers across volumes:
$ db2 list tablespace containers for 3
Tablespace Containers for Tablespace 3
Container ID = 0
Name = /db2/data4/rtcdb11/contentts/c1.dbf
Type = File
Container ID = 1
Name = /db2ts1/rtcinst3/RTCDB11/c0.dbf
Type = File
Container ID = 2
Name = /db2ts2/rtcinst3/RTCDB11/c1.dbf
Type = File
Container ID = 3
Name = /db2ts3/rtcinst3/RTCDB11/c2.dbf
Type = File
If your databases have containers spread across the mounts, it may be simply a matter of adding a new container in that path.
DB2 also uses certain PATH information in the dbm cfg:
Default database path (DFTDBPATH) = /db2/data4
It might be possible to symbolically link new paths under original path names. However, moving db2 storage isn't always a simple matter of copying files around and a backup/restore might be required.
W/o a bit of a description of how these storage paths are wedged into your environment, it's hard to make a more concrete judgment. Maybe post on a DB2 related forum ? e.g.: https://developer.ibm.com/data/db2/