ADSM-L

Re: SQL2062N: Reason code =406

2006-07-11 03:10:37
Subject: Re: SQL2062N: Reason code =406
From: zareyna <zareyna AT ADR-MALAYSIA DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 11 Jul 2006 15:09:47 +0800
I have changed the permission for the errorlog. Still I still have the
error.

On another database server , when I execute dsmapipw in
/usr/opt/db2_08_01/adsm64/dsmapipw, I received " Segmentation Fault
(coredump) and my offline fullbackup failed with error : SQL2079N Return
code 30.

Did I execute the correct dsmapipw? There 2 folders, adsm and adsm64 and I
execute the dsmapipw in adsm64.

Appreciate if anyone could give me any suggestions to troubleshoot this 2
errors.



Thanks,



Regards,



Zareyna Salim


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jacques Van Den Berg
Sent: Monday, July 10, 2006 10:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] SQL2062N: Reason code =406

Check file permissions for your errorlog file...

Jacques van den Berg
TSM / SAP Storage Administrator
Pick 'n Pay IT
Email   : jvandenberg AT pnp.co DOT za
Tel      : 021 - 658 1711
Fax     : 021 - 658 1699
Mobile  : 082 - 653 8164
Dis altyd lente in die hart van die mens wat God
en sy medemens liefhet (John Vianney).

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
zareyna
Sent: Monday, July 10, 2006 11:14 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL2062N: Reason code =406


Hi all,



Has anyone has ever countered this problem:



SQL2062N  An error occurred while accessing media

"/home/db2admin/sqllib/adsm/libtsm.a".  Reason code: "406".



Below are the steps that I have done:

1.      Setup the environment variables as below



DSMI_DIR=/usr/tivoli/tsm/client/api/bin64

DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt

DSMI_LOG=/usr/tivoli/tsm/client/api/bin64



export DSMI_DIR DSMI_CONFIG DSMI_LOG



2.      Copy the dsm.opt and dsm.sys in the
"/usr/tivoli/tsm/client/api/bin64"



/usr/tivoli/tsm/client/api/bin64

# ls -l

total 12168

-r--------   1 root     system       108626 Jul 05 12:33 db2uext2.c

-rwxrwxrwx   1 root     system          763 Jul 10 16:27 dsm.opt

-rw-r--r--   1 root     system          782 Sep 17 2005  dsm.opt.smp

-rw-------   1 root     system         1077 Jul 10 14:08 dsm.sys



DSM.OPT

SErvername      TSM_Server1





DSM.SYS

SErvername             TSM_SERVER1

COMMMethod         TCPip

tcpport                    1500



TCPServeraddress   10.211.214.18

tcpclientaddress      10.211.214.11



passwordaccess     generate

schedmode            prompted

NODENAME          PRDDBLA1_DB2



3.      Set db2 Userexit=YES, LOGRETAIN= YES
4.      Backup database : Offline = SUCCESS
5.      Backup database : Online= FAILED (receive the above error
prompt:
SQL2062N)





 Our database is DB 8.2.4 running on AIX 5.1



 Is there any step that I have missed out?







Thanks,



Regards,





Zareyna Salim


Read our disclaimer at:
http://www.picknpay.co.za/pnp/view/pnp/en/page5093?

If you don't have web access, the disclaimer can be mailed to you on
request.

Disclaimer requests to be sent to it-security AT pnp.co DOT za




Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093?

If you don't have web access, the disclaimer can be mailed to you on
request.

Disclaimer requests to be sent to it-security AT pnp.co DOT za





--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.10/384 - Release Date: 7/10/2006