Re: SQL2062N: Reason code =406
2006-07-11 03:10:37
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
|
|
|