SQL2062N error - DB2 online backup

[mariobehring]

Hi list,



I am trying to configure the online backup for the DB2 for Windows NT. I have configured the LOGRETAIN ON and USEREXIT ON for all databases at my instance and I tried to use the following command at the db2cmd prompt:



db2 backup database <database name> online use tsm



My environment is this:

=> TSM Server 5.1.1.0 running on a Windows 2000 Server machine

=> TSM Backup-Archive Client 4.1.2.14 running on a Windows NT Server 4.0

SP6a machine with 2GB RAM



Anyway ... after entering the above command, I got the error message below:



SQL2062N error An error occurred while accesing media.

"D:\SQLLIB\bin\db2tadsm.dll". Reason code "406".



Is there any documentation for these errors ??



Any help is apreciated.



Thanks.



Mario Behring

IT Consultant

55 11 9540-8383

[email protected]

 

[aixdude]

I got the same error in the dba's log.

pg ibcpm1t.bkout

SQL2062N An error occurred while accessing media

"/u/db2tst01/sqllib/adsm/libtadsm.a". Reason code: "406".



pg ibcpm1t.bkout.d1020020106

SQL2062N An error occurred while accessing media

"/u/db2tst01/sqllib/adsm/libtadsm.a". Reason code: "406"



I opened up a ticket w Tivoli.

Hopefully I'll get a timely response. :evil:

 

[damien]

Well, I'm not sure about the Windows DB2 setup environment

but in the AIX environment you have to

Set the

USEREXIT ON

LOGRETAIN ON

and all the db cfg parameters for TSM

TSM MGMTCLASS managementclass

TSM NODENAME nodename

TSM OWNER owner (usually the same as node)

TSM PASSWORD password



and in AIX you have to compile the db2uext file for your environment.

And don't forget to set the server /klient IP in the /usr/tivoli/tsm/api/bin/dsm.sys file



Before you do a "online" TSM backup after changing USERXIT ON,,you first have to do a offline backup, I don't think that is the problem in this case though since then you would have gotten a different error message.



Don't konw if this info will help in either AIX or Win environment, but I hope it's something to go on...

 

[aixdude]

h

 

[aixdude]

h

 

[aixdude]

I went on the DB2 support website:

http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q=406%2Bcode%253A%2BReason&uid=swg21009378



and I found that the dsm.opt file(s) I assume the one for dsm-udb.opt as well need to be readable to the db2 instance owner ..so I made them readable.. let's see what happens..still waiting for TSM support to call..2 days now.