Ah. So each database needs a separate namespace then? I'll create a new namespace for each of the 7 databases from the backup and go from there.
Thanks Robert! This is great and definitely a step in the right direction. I created a new Namespace and then created local databases for each of my CACHE.DAT files.
I just have one follow up question: How do I check which namespace a local database is associated with? I would like all of my databases to share the namespace I created. The only way I could find to make an association is to select default global and routine databases for the namespace.
Should I create a new namespace for each of my restored databases and have the defaults set to each database respectively?
I feel that I might not have provided enough info initially, so here is the entire set of databases from the restore.
- MYDATASYS /opt/npc/cachesys/mgr/cache/
- MYDATAAUDIT /opt/npc/cachesys/mgr/cacheaudit/
- MYDATA1 /npc/cachedb/<instance number>_live/mydata1/
- MYDATA2 /npc/cachedb/<instance number>_live/mydata2/
- MYDATA1TEMP /npc/cachedb/<instance number>_live/mydata1temp/
- MYDATA2TEMP /npc/cachedb/<instance number>_live/mydata2temp/
- MYDATA3 /npc/cachedb/<instance number>_live/mydata3/
Unfortunately no .cpf, but this helped a lot. After some trial and error I was able to get them mapped correctly and get all of the tables configured like they should be. Thanks!