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:[EMAIL PROTECTED] On Behalf Of Jacques Van Den Berg Sent: Monday, July 10, 2006 10:05 PM To: [email protected] 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 : [EMAIL PROTECTED] 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:[EMAIL PROTECTED] On Behalf Of zareyna Sent: Monday, July 10, 2006 11:14 AM To: [email protected] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] -- 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
