backint for SAP MaxDB

[Former Member]

Hi

I am looking for help to configure MaxDB Database backup through backint on Tape.

I have gone through the steps for MaxDB Backup Solution with Backint for Oracle but when executing the backup getting the error :

ERR_COMMAND_FAILED: Command 'backup_save' has ended and failed with return code -24988.

0x00000148 ERR -24988 DBMSrv ERR_SQL: SQL error

Can anyone help ?

Regards,

[Former Member]

Hi

Are you on the latest DB patch level?

[markus_doehr2]

> ERR_COMMAND_FAILED: Command 'backup_save' has ended and failed with return code -24988.

> 0x00000148 ERR -24988 DBMSrv ERR_SQL: SQL error

please post more logs (especially the dbm* files in your work directory) and also your configuration.

Markus

[Former Member]

Hi Markus,

I would like to inform you the steps which i did for the backup through backint.

1. I have copied the init<sid>.utl, init<sid>.bki and agent.lic from an existing Unix - Oracle based installation to MAXDB wrk /sid directory.

2. I have changed the SID i.e. XXX350.

3. I have created the BSI.ENV file manually and kept under wrk/sid directory.

4. I have created the MaDB_Config parameter file manaully and kept under /wrk/sid directory.

5. Then I have created the backup medium with
.\pipe\xyz and tested the backup and got the error.

6. TSM Library & client is already configured and daily file system backup is happening.

7. To take database backup directly on Tape, i am trying to configure with backint for maxdb.

Please let me know any steps, needs to be configured.

Below is the log of dbm.prt

---

2011-06-08 23:35:54 0x00000c34 INF 283 DBMSrv Command 'auto_extend show' is being executed.

2011-06-08 23:35:54 0x00000c34 INF 419 DBMSrv Command 'auto_extend' has ended with return code 0.

2011-06-08 23:35:54 0x00000c34 INF 283 DBMSrv Command 'auto_update_statistics show' is being executed.

2011-06-08 23:35:55 0x00000c34 INF 419 DBMSrv Command 'auto_update_statistics' has ended with return code 0.

2011-06-08 23:36:23 0x00000c34 INF 226 DBMSrv DBM Server client disconnected: PID 3816 on computer az18w3195.global.ds.honeywell.com

2011-06-08 23:42:04 0x00000834 INF 216 DBMSrv DBM Server client connection (established at 2011-06-08 23:41:12): PID 3944 on computer az18w3195.global.ds.honeywell.com

2011-06-08 23:42:04 0x00000834 INF 283 DBMSrv Command 'medium_put TEST
.\pipe\backup PIPE DATA 0 8' is being executed.

2011-06-08 23:42:04 0x00000834 INF 419 DBMSrv Command 'medium_put' has ended with return code 0.

2011-06-08 23:43:35 0x00000148 INF 216 DBMSrv DBM Server client connection (established at 2011-06-08 23:43:34): PID 6100 on computer az18w3195.global.ds.honeywell.com

2011-06-08 23:43:35 0x00000148 INF 283 DBMSrv Command 'db_execute SELECT ID,CREATEDATE,USEDSIZE ...' is being executed.

2011-06-08 23:43:35 0x00000148 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'db_execute' has ended and failed with return code -24988.

0x00000148 ERR -24988 DBMSrv ERR_SQL: SQL error

0x00000148 ERR -24778 DBMSrv 100,Row not found

2011-06-08 23:43:35 0x00000148 INF 283 DBMSrv Command 'auto_extend show' is being executed.

2011-06-08 23:43:36 0x00000148 INF 419 DBMSrv Command 'auto_extend' has ended with return code 0.

2011-06-08 23:43:36 0x00000148 INF 283 DBMSrv Command 'auto_update_statistics show' is being executed.

2011-06-08 23:43:36 0x00000148 INF 419 DBMSrv Command 'auto_update_statistics' has ended with return code 0.

2011-06-08 23:43:48 0x00000148 INF 283 DBMSrv Command 'backup_save "TEST" DATA RECOVERY' is being executed.

2011-06-08 23:43:48 0x00000148 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'backup_save' has ended and failed with return code -24988.

0x00000148 ERR -24988 DBMSrv ERR_SQL: SQL error

0x00000148 ERR -24778 DBMSrv -104,DBM command impossible at this time

0x00000148 ERR -24778 DBMSrv 20049,Could not enter critical state 'Backup'.

2011-06-08 23:44:29 0x00000834 INF 421 DBMSrv Command 'medium_get' was executed since 2011-06-08 23:44:29.

2011-06-08 23:44:29 0x00000834 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'medium_get' has ended and failed with return code -24945.

0x00000834 ERR -24945 DBMSrv ERR_TOOFEWPARAM: too few parameters

2011-06-08 23:44:44 0x00000148 INF 283 DBMSrv Command 'backup_save "TEST" DATA RECOVERY' is being executed.

2011-06-08 23:44:44 0x00000148 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'backup_save' has ended and failed with return code -24988.

0x00000148 ERR -24988 DBMSrv ERR_SQL: SQL error

0x00000148 ERR -24778 DBMSrv -104,DBM command impossible at this time

0x00000148 ERR -24778 DBMSrv 20049,Could not enter critical state 'Backup'.

2011-06-08 23:44:58 0x00000148 INF 226 DBMSrv DBM Server client disconnected: PID 6100 on computer az18w3195.global.ds.honeywell.com

2011-06-08 23:50:38 0x00000834 INF 283 DBMSrv Command 'backup_ext_ids_list' is being executed.

2011-06-08 23:50:38 0x00000834 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'backup_ext_ids_list' has ended and failed with return code -24905.

0x00000834 ERR -24905 DBMSrv ERR_NOEBIDLIST: no information on external backup IDs available

2011-06-08 23:50:54 0x00000834 INF 226 DBMSrv DBM Server client disconnected: PID 3944 on computer az18w3195.global.ds.honeywell.com

2011-06-08 23:51:57 0x000019b0 INF 226 DBMSrv DBM Server client disconnected: PID 6512 on computer az18w3195.global.ds.honeywell.com

2011-06-09 04:10:06 0x0000189c INF 216 DBMSrv DBM Server client connection (established at 2011-06-09 04:10:06): PID 5408 on computer az18w3195.global.ds.honeywell.com

2011-06-09 04:10:06 0x0000189c INF 283 DBMSrv Command 'backup_start DATA ' is being executed.

2011-06-09 04:10:07 0x0000189c ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'backup_start' has ended and failed with return code -24988.

0x0000189c ERR -24988 DBMSrv ERR_SQL: SQL error

0x0000189c ERR -24778 DBMSrv -104,DBM command impossible at this time

0x0000189c ERR -24778 DBMSrv 20049,Could not enter critical state 'Backup'.

2011-06-09 04:10:07 0x0000189c INF 226 DBMSrv DBM Server client disconnected: PID 5408 on computer az18w3195.global.ds.honeywell.com

2011-06-09 17:43:09 0x00001950 INF 216 DBMSrv DBM Server client connection (established at 2011-06-09 17:43:08): PID 6176 on computer az18w3195.global.ds.honeywell.com

2011-06-09 17:43:09 0x00001950 INF 283 DBMSrv Command 'db_execute SELECT ID,CREATEDATE,USEDSIZE ...' is being executed.

2011-06-09 17:43:09 0x00001950 ERR -24580 DBMSrv ERR_COMMAND_FAILED: Command 'db_execute' has ended and failed with return code -24988.

0x00001950 ERR -24988 DBMSrv ERR_SQL: SQL error

0x00001950 ERR -24778 DBMSrv 100,Row not found

2011-06-09 17:43:09 0x00001950 INF 283 DBMSrv Command 'auto_extend show' is being executed.

2011-06-09 17:43:09 0x00001950 INF 419 DBMSrv Command 'auto_extend' has ended with return code 0.

2011-06-09 17:43:09 0x00001950 INF 283 DBMSrv Command 'auto_update_statistics show' is being executed.

2011-06-09 17:43:10 0x00001950 INF 419 DBMSrv Command 'auto_update_statistics' has ended with return code 0.

-

---

below is the lof o dbm.mmm

[data]

LOCATION=D:\PROGRA_2\ESKERP1\Storage\EDP350\EDP350_BACKUPDATA

TYPE=FILE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=8

OVERWRITE=YES

AUTOLOADER=NO

OSCOMMAND=

BACKUPTOOL=NONE

CREATED=20101012150158

MODIFIED=20101012150158

[auto]

LOCATION=D:\PROGRA_2\ESKERP1\Storage\EDP350\EDP350_BACKUPLOG

TYPE=FILE

SAVETYPE=AUTO

SIZE=0

BLOCKSIZE=8

OVERWRITE=NO

AUTOLOADER=NO

OSCOMMAND=

BACKUPTOOL=NONE

CREATED=20101012150158

MODIFIED=20101012150158

[TEST]

LOCATION=
.\pipe\backup

TYPE=PIPE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=8

OVERWRITE=NO

AUTOLOADER=NO

OSCOMMAND=

BACKUPTOOL=NONE

CREATED=20110608233255

MODIFIED=20110608234204

[Former Member]

Here is the latest backup log from dbm.ebp

2011-06-13 17:43:29

Using environment variable 'TEMP' with value 'C:\Windows\TEMP' as directory for temporary files and pipes.

Using connection to Backint for MaxDB Interface.

2011-06-13 17:43:29

Checking existence and configuration of Backint for MaxDB.

Reading the Backint for MaxDB configuration file 'C:\Program Files\sapdb\indep_data\wrk\EDP350\bsi.env'.

Found keyword 'BACKINT' with value 'C:\Progra~1\sapdb\depend\bin\backint.exe'.

Found keyword 'INPUT' with value 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.in'.

Found keyword 'OUTPUT' with value 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.out'.

Found keyword 'ERROROUTPUT' with value 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.err'.

Found keyword 'PARAMETERFILE' with value 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\MaxDB_Config.par'.

Found keyword 'ORIGINAL_RUNDIRECTORY' with value 'C:\Progra~1\sapdb\indep_data\wrk\EDP350'.

Finished reading of the Backint for MaxDB configuration file.

Using 'C:\Progra~1\sapdb\depend\bin\backint.exe' as Backint for MaxDB program.

Using 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.in' as input file for Backint for MaxDB.

Using 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.out' as output file for Backint for MaxDB.

Using 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.err' as error output file for Backint for MaxDB.

Using 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\MaxDB_Config.par' as parameter file for Backint for MaxDB.

Using '300' seconds as timeout for Backint for MaxDB in the case of success.

Using '300' seconds as timeout for Backint for MaxDB in the case of failure.

Using 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\dbm.knl' as backup history of a database to migrate.

Using 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\dbm.ebf' as external backup history of a database to migrate.

Checking availability of backups using backint's inquire function.

Check passed successful.

2011-06-13 17:43:29

Checking medium.

Check passed successfully.

2011-06-13 17:43:29

Preparing backup.

Setting environment variable 'BI_CALLER' to value 'DBMSRV'.

Setting environment variable 'BI_REQUEST' to value 'NEW'.

Setting environment variable 'BI_BACKUP' to value 'FULL'.

Constructed Backint for MaxDB call 'C:\Progra_{1\sapdb\depend\bin\backint.exe -u EDP350 -f backup -t file -p C:\Progra}1\sapdb\indep_data\wrk\EDP350\MaxDB_Config.par -i C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.in -c'.

Created temporary file 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.out' as output for Backint for MaxDB.

Created temporary file 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.err' as error output for Backint for MaxDB.

Writing '
.\pipe\backup #PIPE' to the input file.

Prepare passed successfully.

2011-06-13 17:43:29

Starting database action for the backup.

Requesting 'SAVE DATA QUICK TO '
.\pipe\backup' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'TEST'' from db-kernel.

The database is working on the request.

2011-06-13 17:43:29

Waiting until database has prepared the backup.

Asking for state of database.

2011-06-13 17:43:29 Database is still preparing the backup.

Waiting 1 second ... Done.

Asking for state of database.

2011-06-13 17:43:30 Database has finished preparation of the backup.

The database has prepared the backup successfully.

2011-06-13 17:43:30

Starting Backint for MaxDB.

Starting Backint for MaxDB process 'C:\Progra_{1\sapdb\depend\bin\backint.exe -u EDP350 -f backup -t file -p C:\Progra}1\sapdb\indep_data\wrk\EDP350\MaxDB_Config.par -i C:\Progra_{1\sapdb\indep_data\wrk\EDP350\sapdb.in -c >>C:\Progra}1\sapdb\indep_data\wrk\EDP350\sapdb.out 2>>C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.err'.

Process was started successfully.

Backint for MaxDB has been started successfully.

2011-06-13 17:43:30

Waiting for end of the backup operation.

2011-06-13 17:43:30 The backup tool is running.

2011-06-13 17:43:30 The database is working on the request.

2011-06-13 17:43:31 The database has finished work on the request.

Receiving a reply from the database kernel.

Got the following reply from db-kernel:

SQL-Code

Date :20110613

Time :00174329

Database :EDP350

Server :az18w3195.global.ds.honeywell.com

KernelVersion :Kernel 7.6.06 Build 003-123-202-135

PagesTransfered :2928

PagesLeft

Volumes :1

MediaName :TEST

Location :
.\pipe\backup

Label :DAT_000000231

IsConsistent :true

FirstLogPageNo :10317533

DBStamp1Date :20110613

DBStamp1Time :00174329

BDPageCount :2907

DevicesUsed :1

DatabaseID :az18w3195.dcwsap.honeywell.com:EDP350_20101012_150159

Max Used Data Page

Converter Page Count :12

2011-06-13 17:43:31 The backup tool is running.

2011-06-13 17:43:33 The backup tool process has finished work with return code 2.

The backup operation has ended.

2011-06-13 17:43:33

Filling reply buffer.

Have encountered error -24920:

The backup tool failed with 2 as sum of exit codes.

Constructed the following reply:

ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 2 as sum of exit codes.

Reply buffer filled.

2011-06-13 17:43:33

Updating external backup history.

Using 'C:\Program Files\sapdb\indep_data\wrk\EDP350\dbm.knl' as backup history.

Looking for DAT_000000231 with DB Stamp1 2011-06-13 17:43:29.

Found 1 Internal Backup ID. It was 4DF64C410012|DAT_000000231.

Got '4DF64C410012|DAT_000000231' as Internal Backup ID and '2011-06-13 17:43:29' as start date.

Using 'C:\Program Files\sapdb\indep_data\wrk\EDP350\dbm.ebf' as external backup history.

Wrote '4DF64C410012|DAT_000000231||DATA MIGRATION|2011-06-13 17:43:29|BACK|-24920|The backup tool failed with 2 as sum of exit codes.|TEST|vftPipe|NO|0|8|S|
.\pipe\backup|0|' to the external backup history.

Have updated external backup history successfully.

2011-06-13 17:43:33

Cleaning up.

Copying output of Backint for MaxDB to this file.

-

---

Begin of output of Backint for MaxDB (C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.out)----

---

Reading parameter file C:\Progra~1\sapdb\indep_data\wrk\EDP350\MaxDB_Config.par.

Using staging area D:\TEMP\STAGE1 with a size of 1048576000 bytes.

Using staging area D:\TEMP\STAGE2 with a size of 1048576000 bytes.

Using 2 file per Backint for Oracle call.

Using C:\Progra~1\sapdb\depend\bin\backint.exe as Backint for Oracle.

Using C:\Progra~1\sapdb\indep_data\wrk\EDP350\backint1.in as input of Backint for Oracle.

Using C:\Progra~1\sapdb\indep_data\wrk\EDP350\backint1.out as output of Backint for Oracle.

Using C:\Progra~1\sapdb\indep_data\wrk\EDP350\backint1.err as error output of Backint for Oracle.

Using C:\Progra~1\sapdb\indep_data\wrk\EDP350\initEDP350.utl as parameterfile of Backint for Oracle.

Using C:\Program as history file.

Reading input file C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.in.

Backing up pipe
.\pipe\backup.

Found 1 entry in the input file.

Starting the backup.

Starting pipe2file program(s).

Waiting for creation of temporary files.

1 temporary file is available for backup.

Calling Backint for Oracle at 2011-06-13 17:43:32.

Calling 'C:\Progra_{1\sapdb\depend\bin\backint.exe -u EDP350 -f backup -t file -p C:\Progra}1\sapdb\indep_data\wrk\EDP350\initEDP350.utl -i C:\Progra~1\sapdb\indep_data\wrk\EDP350\backint1.in -c' .

Backint for Oracle ended at 2011-06-13 17:43:32 with return code 2.

Backint for Oracle output: Reading parameter file C:\Progra~1\sapdb\indep_data\wrk\EDP350\initEDP350.utl.

Backint for Oracle output:

Backint for Oracle output:

Backint for Oracle error output: No staging area is defined in the parameter file.

Backint for Oracle error output: The path of Backint for Oracle is not defined in the parameter file.

Backint for Oracle error output: The name of the history file is not defined in the parameter file.

Backint for Oracle error output: The name of the input file of Backint for Oracle is not defined in the parameter file.

Backint for Oracle error output: The name of the output file of Backint for Oracle is not defined in the parameter file.

Backint for Oracle error output: The name of the error output file of Backint for Oracle is not defined in the parameter file.

Backint for Oracle error output:

Finished the backup unsuccessfully.

#ERROR
.\pipe\backup

-

---

End of output of Backint for MaxDB (C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.out)----

---

Removed Backint for MaxDB's temporary output file 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.out'.

Copying error output of Backint for MaxDB to this file.

-

---

Begin of error output of Backint for MaxDB (C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.err)----

---

Backint for Oracle was unsuccessful.

-

---

End of error output of Backint for MaxDB (C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.err)----

---

Removed Backint for MaxDB's temporary error output file 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.err'.

Removed the Backint for MaxDB input file 'C:\Progra~1\sapdb\indep_data\wrk\EDP350\sapdb.in'.

Have finished clean up successfully.

[markus_doehr2]

> Backint for Oracle error output: No staging area is defined in the parameter file.

> Backint for Oracle error output: The path of Backint for Oracle is not defined in the parameter file.

> Backint for Oracle error output: The name of the history file is not defined in the parameter file.

> Backint for Oracle error output: The name of the input file of Backint for Oracle is not defined in the parameter file.

> Backint for Oracle error output: The name of the output file of Backint for Oracle is not defined in the parameter file.

> Backint for Oracle error output: The name of the error output file of Backint for Oracle is not defined in the parameter

Those parameters are all missing in your configuration file.

How does it look like?

Markus

[Former Member]

Hi,

I have observed the same.

But I have also noted that in parameter file, i have mentioned the path of backin as maxdb. I think it needs to be from \programfile\tivoli\TSM\tdp_r3\ora64\bacint.ext"

can you please confirm as backup log states that it is running till it writes to Pipe then it is failing.

ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 2 as sum of exit codes.

Reply buffer filled.

Thank