by Ed Lufke » Sun, 02 Sep 2001 09:38:35
We lost our drive where the db2as, db2inst1, and db2fenc1
directories. The db2 is install in a partition that was not harmed. Of
course there was no backup. Is there a way to install just the users
again, without installing db2.
Thanks
Eddie Lufker
by Darin McBrid » Sun, 02 Sep 2001 13:10:14
Yup. In the DB2 product directory (depends on platform - you don't mentionQuote:> We lost our drive where the db2as, db2inst1, and db2fenc1
>directories. The db2 is install in a partition that was not harmed. Of
>course there was no backup. Is there a way to install just the users
>again, without installing db2.
Personally, I'd rather lose the drive with DB2 on it than my instances -
instances have configuration (and the default database path is in the
instance owner's home directory). The DB2 drive only has an installation
plus any fixpaks. Much easier to recover that from CD plus any archive of
the fixpak I may have (or just download the latest again).
1. avoiding schema prefix db2inst1
I wonder how can I set up some general aliasing so that I don't have
to prefix all the table names with db2inst1. I'm given a read-only
access to an important database owned by someone else, hence all the
tables live in the schema db2inst1 and as my user name is different, I
have to call all tables in all SQL statements db2inst1.blah, which is
increasingly pixel-consuming. Is there a general way to set up my db2
client so that the prefix db2inst1 is automatically assumed? Is there
some aliasing for table spaces, so my user name space becomes
equivalent to db2inst1?... I'm more interested in a general solution,
not just on a per table basis, so I or DBAs don't have to track down
tables and add them into some alias clauses -- however, even such a
solution will help as a last resort, so anything goes! :-)
Cheers,
Alexy Khrabrov
2. DSNless Database Connection
3. $ db2cc /home/db2inst1/sqllib/bin/db2c
5. Problems adding 21 columns (but success when adding less than 20)
6. VFP5.0's program run on Windows 3.1
7. to add or not to add 4GB of memory
8. select into/bulkcopy and log dumps
9. To add or not to add 4GB worth of physical memory
10. to add or not to add 2 GB of memory
11. How to add add column in a specific spot in table with SQL
12. Add regression tests for ADD PRIMARY KEY
13. Add regression test for ALTER TABLE / ADD UNIQUE