One month ago, we lost a RAID array on an AIX 4.3 RS6000 server. This server contains our DB2 database. We have another similar config in another city. All our DB2 data was safe, however, we lost all our home directories, which stores user files. In order to access the DB2 database and Data Warehouse, we needed to use some accounts from our other location as templates. So that being said, here is my problem.
We run the backup on our DB2 databases from Windows using the Command Center and Journal. While the backups work fine, it seems that there is an issue with the toolsdb, because I can only seem to catalog the backups to our other location. To this point, this solution has been working. We are able to catalog and run our backups without a problem. However, it annoys me to have our catalogs stored remotely and require a network connection to go back and view archived jobs. When I create the job (DB2 8.1 wizard), only the remote catalog shows up as an option.
I issued a db2 create new catalog cc create new database toolsdb, however, it says the alias already exists. So toolsdb is here locally somewhere, but may be unaccessable.
As you can see by my username, I am new to DB2 and am taking over since our Unix admin (who was the one responsible for not backing up the home folders) was shown the exit.