I _think_ I read somewhere that the upgrade should:

1- save all db2 instances
2- deinstall db2 9.5 (and TSM 6.1)
3- install db2 9.7 (and TSM 6.2)
4- run db2icrt on the instances saved
5- run some db2 commands to re-catalog the database

of course I could very well be wrong.

On 25 mrt 2010, at 09:39, Stef Coene wrote:

> On Thursday 25 March 2010, you wrote:
>> On 25 mrt 2010, at 07:59, Stef Coene wrote:
>>> Hi,
>>> 
>>> Yesterday I tried to upgrade our test TSM server from TSM 6.1 to 6.2 (AIX
>>> 6.1).  The installer crashed in the middle of the installation.  I redid
>>> the installation and the second time, everything was ok.
>>> Except that the sqllib directory is missing from the home-directory of
>>> the tsm user....
>>> 
>>> I still have a tsminst1 directory in the home-directory of the tsm user
>>> with all the TSM related files and an other directory my db2 database
>>> files.
>>> 
>>> So, how can I rebuild the sqllib directory?
>> 
>> db2icrt, I'd think.
> Pff, I tried to restore the sqllib directory from mksysb:
> 
> ANR7801I Subsystem process ID is 860386.
> ANR0900I Processing options file /home/tsm/tsminst1/dsmserv.opt.
> ANR7811I Using instance directory /home/tsm/tsminst1.
> ANR4726I The ICC support module has been loaded.
> ANR0990I Server restart-recovery in progress.
> ANR9999D_0627913354 dbiInit(dbiinit.c:512) Thread<1>: Error -1 setting up
> preliminary database environment.
> ANR9999D Thread<1> issued message 9999 from:
> ANR9999D Thread<1>  0x0000000100012f94 StdPutText
> ANR9999D Thread<1>  0x0000000100013afc OutDiagToCons
> ANR9999D Thread<1>  0x000000010000edbc outDiagfExt
> ANR9999D Thread<1>  0x00000001004670f0 dbiInit
> ANR9999D Thread<1>  0x000000010045e554 StartServer
> ANR9999D Thread<1>  0x000000010045e1d0 admStartServer
> ANR9999D Thread<1>  0x0000000100000edc main
> 
> 
> I tried the db2icrt + changed the database directory with
> "/opt/tivoli/tsm/server/bin/rc.dsmserv -u tsm -i /home/tsm/tsminst1":
> 
> ANR7801I Subsystem process ID is 901298.
> ANR0900I Processing options file /home/tsm/tsminst1/dsmserv.opt.
> ANR7811I Using instance directory /home/tsm/tsminst1.
> ANR4726I The ICC support module has been loaded.
> ANR0990I Server restart-recovery in progress.
> ANR0152I Database manager successfully started.
> ANR0172I rdbdb.c(1604): Error encountered performing action ActivateDatabase.
> ANR0162W Supplemental database diagnostic information:  -1031:**No State
> Information Available (76)**:-1031 (**No
> Other Information Available (96)**).
> 
> I think I'm going to reinstall TSM 6.1.3 and redo the upgrade process.
> 
> 
> Stef

-- 
Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622