ADSM-L

Re: DB2 6.1 TSM 4.1 SQL2062N "406" Errors attempting to backup

2001-05-15 14:10:43
Subject: Re: DB2 6.1 TSM 4.1 SQL2062N "406" Errors attempting to backup
From: James Thompson <mezron AT HOTMAIL DOT COM>
Date: Tue, 15 May 2001 11:11:34 -0700
Login as the Instance owner and provide the output of "env | grep DSMI"

If the values are not there, then add them to the .profile of the instance
owner.  If they are there, stop and start the db2instance (db2stop).

James Thompson


From: MORGAN TONY <TONY.MORGAN AT FORTISBANK DOT COM>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: DB2 6.1 TSM 4.1 SQL2062N "406" Errors attempting to backup
Date: Tue, 15 May 2001 14:17:49 +0200

Hi *SMers,

I am trying to set up a DB2 backup using the internal ADSM API....

But.... It fails with ...

SQL2062N  An error occured while accessing media
"C:\SQLLIB\bin\db2adsm.dll".
Reason code: "406"

The file mentioned exists....

The variables DSMI_DIR, DSMI_CONFIG and DSMI_LOG all point to "c:\Program
Files\Tivoli\TSM\baclient"

I have run dsmapipw to set the password.

My DSM.opt looks like...

PASSWORDACCESS generate
NODENAME   db2server
TCPSERVERADDRESS ADSM
SCHEDLOGRETENTION 3
DIRM STANDARD
DATEFORMAT 2
TIMEFORMAT 1
*
* tuning parameters *
TXNBYTElimit      2097152
TCPBUFFSIZE            32
TCPWINDOWSIZE          63
TCPNODELAY            YES
LARGECOMmbuffers       NO
Compression               YES
Compressalways         YES
***
*DOMAIN C: D: E: F:
RESOURC   3
Quiet                          NO
*
*
*===============================================
*  Common NT Exclusions - Applies to all nodes
*===============================================
INCLUDE "*:\*" STANDARD
INCLUDE "*:\...\*" STANDARD
*next line added for testing purposes only*
EXCLUDE "*:\...\*.DLL"
EXCLUDE "*:\...\pagefile.sys"
EXCLUDE "*:\IBMBIO.COM"
EXCLUDE "*:\IBMDOS.COM"
EXCLUDE "*:\MSDOS.SYS"
EXCLUDE "*:\IO.SYS"
EXCLUDE "*:\...\SYSTEM32\CONFIG\*.*"
EXCLUDE "*:\...\SYSTEM32\CONFIG\...\*"
EXCLUDE "*:\winnt\profiles\...\*"
EXCLUDE "*:\...\ntuser.dat"
EXCLUDE "*:\...\ntuser.dat.log"
EXCLUDE "*:\...\*.tmp"
EXCLUDE "*:\...\*.dmp"
EXCLUDE "*:\temp\*"
EXCLUDE "*:\temp\...\*"
Exclude "D:\db2\...\*.*"
*
*===============================================


Any help would be appreciated.... as always.

On ADSM.ORG I found the same question, but no viable responses...

Many Thanks for you Attention

Tony Morgan

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com