Backup error with TSM MAXDB The backup tool failed with 255 as sum of exit

[Former Member]

Dear Forum,

I am tryng to do a Backup on pipe with TSM and when run the follow commands I get the follow error.

dbmcli on LCX>backup_start COM_LOG_TEST

ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 255 as sum of exit codes. The database request was canceled and ended with error -903.

---

dbmcli on LCX>

(host)]/var/tmp > more /sapdb_wrk/LCX/dbm.ebp

2009-03-26 18:06:38

Setting environment variable 'TEMP' for the directory for temporary files and pipes to default ''.

Using environment variable 'TMP' with value '/var/tmp' as directory for temporary files and pipes.

Using connection to IBM's ADSM with client adint2.

2009-03-26 18:06:38

Checking existence and configuration of adint2.

Setting environment variable 'ADINT' for the adint2 directory to default '/usr/adint'.

Using ADSM program '/usr/adint/adint2'.

Setting environment variable 'ADA_OPT' for the ADSM options file to default '/usr/adint/initLCX.opt'.

Check passed successful.

2009-03-26 18:06:38

Checking medium.

Check passed successfully.

2009-03-26 18:06:38

Preparing backup.

Constructed save label 'host_LCX_2009.03.26_18.06.38_SAVEDTNCHK_COM_LOG_TEST'.

Constructed adint2 call '/usr/adint/adint2 -b -n host_LCX_2009.03.26_18.06.38_SAVEDTNCHK_COM_LOG_TEST -c 65536 -p /oracle/AP1

/lvcbackup/LCX_COM_TEST'.

Created temporary pipe '/var/tmp/temp1238087198-0' as input for adint2.

Created temporary file '/var/tmp/temp1238087198-1' as output for adint2.

Created temporary file '/var/tmp/temp1238087198-2' as error output for adint2.

Prepare passed successfully.

2009-03-26 18:06:39

Creating pipes for data transfer.

Creating pipe '/oracle/LCX/lvcbackup/LCX_COM_TEST' ... Done.

All data transfer pipes have been created.

2009-03-26 18:06:39

Starting database action for the backup.

Requesting 'SAVE DATA QUICK TO '/oracle/AP1/lvcbackup/LCX_COM_TEST' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'COM_LOG_TEST'' fro

m db-kernel.

The database is working on the request.

2009-03-26 18:06:39

Waiting until database has prepared the backup.

Asking for state of database.

2009-03-26 18:06:39 Database is still preparing the backup.

Waiting 1 second ... Done.

Asking for state of database.

2009-03-26 18:06:40 Database has finished preparation of the backup.

The database has prepared the backup successfully.

2009-03-26 18:06:40

Starting adint2.

Calling backup tool process '/usr/adint/adint2 -b -n host_LCX_2009.03.26_18.06.38_SAVEDTNCHK_COM_LOG_TEST -c 65536 -p /oracle

/LCX/lvcbackup/LCX_COM_TEST </var/tmp/temp1238087198-0 >>/var/tmp/temp1238087198-1 2>>/var/tmp/temp1238087198-2' ... OK.

adint2 has been started successfully.

2009-03-26 18:06:40

Waiting for end of the backup operation.

2009-03-26 18:06:40 The backup tool process has finished work with return code 255.

2009-03-26 18:06:40 The backup tool is not running.

2009-03-26 18:06:40 The database is working on the request.

2009-03-26 18:06:40 The database is working on the request.

2009-03-26 18:06:45 The database is working on the request.

2009-03-26 18:06:55 The database is working on the request.

2009-03-26 18:07:10 The database is working on the request.

2009-03-26 18:07:30 The database is working on the request.

2009-03-26 18:07:41 Canceling Utility-task after a timeout of 60 seconds elapsed ... OK.

2009-03-26 18:07:42 The database has finished work on the request.

Receiving a reply from the database kernel.

Got the following reply from db-kernel:

SQL-Code :-903

The backup operation has ended.

2009-03-26 18:07:42

Filling reply buffer.

Have encountered error -24920:

The backup tool failed with 255 as sum of exit codes. The database request was canceled and ended with error -903.

Constructed the following reply:

ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 255 as sum of exit codes. The database request was canceled and ended with error -903.

Reply buffer filled.

2009-03-26 18:07:43

Cleaning up.

Removing data transfer pipes.

Removing data transfer pipe /oracle/LCX/lvcbackup/LCX_COM_TEST ... Done.

Removed data transfer pipes successfully.

Copying output of ADSM to this file.

-

---

Begin of output of ADSM (/var/tmp/temp1238087198-1)----

---

ADINT Interfacetool between MaxDB and TSM

Version 2, Release 3, Modification 1 for AIX 64-bit

Build: 108 compiled on Oct 20 2005

(c) Copyright IBM Corporation, 1994-2005, All Rights Reserved.

ADI0052E: TSM API Error: ANS1087E (RC106) Access to the specified file or directory is denied

ADI0003E: ADINT has ended with an error.

-

---

End of output of ADSM (/var/tmp/temp1238087198-1)----

---

Removed ADSM's temporary output file '/var/tmp/temp1238087198-1'.

Copying error output of ADSM to this file.

-

---

Begin of error output of ADSM (/var/tmp/temp1238087198-2)----

---

-

---

End of error output of ADSM (/var/tmp/temp1238087198-2)----

---

Removed ADSM's temporary error output file '/var/tmp/temp1238087198-2'.

Removing temporary adint2 input pipe /var/tmp/temp1238087198-0 ... Done.

Have finished clean up successfully.

Any idea, suggestion?

Thanks in advance

ALF

[Former Member]

Hi,

This is a problem with permission of backint and backfm files.

owner of these files should be root:system

chown root:system backfm backint

& permission should be 4775

chmod 4775 backfm backint

Hope this will helpful to you.

Regards,

Sachin Rane.

[Former Member]

Dear Sachin Rane,

I change the permissions suggested, becouse was wrong. Now I have the same error, but in the file dbm.ebp I found some differences.

[lcx(host)]/sapdb_wrk/LCX > more dbm.ebp

2009-03-27 11:39:49

Setting environment variable 'TEMP' for the directory for temporary files and pipes to default ''.

Using environment variable 'TMP' with value '/var/tmp' as directory for temporary files and pipes.

Using connection to IBM's ADSM with client adint2.

2009-03-27 11:39:50

Checking existence and configuration of adint2.

Setting environment variable 'ADINT' for the adint2 directory to default '/usr/adint'.

Using ADSM program '/usr/adint/adint2'.

Setting environment variable 'ADA_OPT' for the ADSM options file to default '/usr/adint/initLCX.opt'.

Check passed successful.

2009-03-27 11:39:50

Checking medium.

Check passed successfully.

2009-03-27 11:39:50

Preparing backup.

Constructed save label 'host_LCX_2009.03.27_11.39.50_SAVEDTNCHK_BACK_TEST'.

Constructed adint2 call '/usr/adint/adint2 -b -n host_LCX_2009.03.27_11.39.50_SAVEDTNCHK_BACK_TEST -c 65536 -p /oracle/lcx/lv

cbackup/BACK_TEST'.

Created temporary pipe '/var/tmp/temp1238150390-0' as input for adint2.

Created temporary file '/var/tmp/temp1238150390-1' as output for adint2.

Created temporary file '/var/tmp/temp1238150390-2' as error output for adint2.

Prepare passed successfully.

2009-03-27 11:39:50

Creating pipes for data transfer.

Creating pipe '/oracle/lcx/lvcbackup/BACK_TEST' ... Done.

All data transfer pipes have been created.

2009-03-27 11:39:50

Starting database action for the backup.

Requesting 'SAVE DATA QUICK TO '/oracle/lcx/lvcbackup/BACK_TEST' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'BACK_TEST'' from db-k

ernel.

The database is working on the request.

2009-03-27 11:39:50

Waiting until database has prepared the backup.

Asking for state of database.

2009-03-27 11:39:50 Database is still preparing the backup.

Waiting 1 second ... Done.

Asking for state of database.

2009-03-27 11:39:51 Database has finished preparation of the backup.

The database has prepared the backup successfully.

2009-03-27 11:39:51

Starting adint2.

Calling backup tool process '/usr/adint/adint2 -b -n host_LCX_2009.03.27_11.39.50_SAVEDTNCHK_BACK_TEST -c 65536 -p /oracle/AP

1/lvcbackup/BACK_TEST </var/tmp/temp1238150390-0 >>/var/tmp/temp1238150390-1 2>>/var/tmp/temp1238150390-2' ... OK.

adint2 has been started successfully.

2009-03-27 11:39:52

Waiting for end of the backup operation.

2009-03-27 11:39:52 The backup tool process has finished work with return code 255.

2009-03-27 11:39:52 The backup tool is not running.

2009-03-27 11:39:52 The database is working on the request.

2009-03-27 11:39:52 The database is working on the request.

2009-03-27 11:39:57 The database is working on the request.

2009-03-27 11:40:07 The database is working on the request.

2009-03-27 11:40:22 The database is working on the request.

2009-03-27 11:40:42 The database is working on the request.

2009-03-27 11:40:53 Canceling Utility-task after a timeout of 60 seconds elapsed ... OK.

2009-03-27 11:40:54 The database has finished work on the request.

Receiving a reply from the database kernel.

Got the following reply from db-kernel:

SQL-Code :-903

The backup operation has ended.

2009-03-27 11:40:54

Filling reply buffer.

Have encountered error -24920:

The backup tool failed with 255 as sum of exit codes. The database request was canceled and ended with error -903.

Constructed the following reply:

ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 255 as sum of exit codes. The database request was canceled and ended with error -903.

Reply buffer filled.

2009-03-27 11:40:54

Cleaning up.

Removing data transfer pipes.

Removing data transfer pipe /oracle/lcx/lvcbackup/BACK_TEST ... Done.

Removed data transfer pipes successfully.

Copying output of ADSM to this file.

-

---

Begin of output of ADSM (/var/tmp/temp1238150390-1)----

---

ADINT Interfacetool between MaxDB and TSM

Version 2, Release 3, Modification 1 for AIX 64-bit

Build: 108 compiled on Oct 20 2005

(c) Copyright IBM Corporation, 1994-2005, All Rights Reserved.

ADI0052E: TSM API Error: ANS1087E (RC106) Access to the specified file or directory is denied

ADI0003E: ADINT has ended with an error.

-

---

End of output of ADSM (/var/tmp/temp1238150390-1)----

---

Removed ADSM's temporary output file '/var/tmp/temp1238150390-1'.

Copying error output of ADSM to this file.

-

---

Begin of error output of ADSM (/var/tmp/temp1238150390-2)----

---

-

---

End of error output of ADSM (/var/tmp/temp1238150390-2)----

---

Removed ADSM's temporary error output file '/var/tmp/temp1238150390-2'.

Removing temporary adint2 input pipe /var/tmp/temp1238150390-0 ... Done.

Have finished clean up successfully.

Thank in advance !!

Best Regards

Alf

[Former Member]

Hi Alf,

according to the adint log: "ADI0052E: TSM API Error: ANS1087E (RC106) Access to the specified file or directory is denied" there is a problem in accessing the directory for ADINT. The directory is "/oracle/lcx/lvcbackup/BACK_TEST"

Please adjust the directory authorizations and make sure it is accessible for ADINT.

HTH

André