From: Sandy Cottingham on 12/11/2001 07:18 PM Rick, After I left the computer I decided the best thing to do was the following: logon as root cd /usr/lpp/db2_07_01/instance/./db2ilist To list the instances on this machine ...there was only inst1 ./db2idrop inst1 drop the instance since it was all hosed up ./db2icrt -a server -u db2fenc1 inst1 ...recreate the instance su - inst1 db2start ...worked like a champ but it had semi-forgotten about the databases To catalog japionc database db2 catalog db japionc as japionc on /home/inst1 To catalog was database db2 catalog db was as was on /home/inst1 now you can do a db2 connect to japionc and it comes up fine and shows you are using db2 7.2.0 same for was ... Now you can upgrade to fixpak 4 if you want ... su - inst1 db2 terminate db2stop db2licd end exit logon as root ...install the updates once fixpak is done, still as root cd /usr/lpp/db2_07_01/instance ./db2iupdt inst