maxdb -complete data backup is failed

[Former Member]

Hi experts,

backups (complete and log ) are failing on livecache system.in our envorment we are using backup tool Backint for maxdb

please find the error logs and assist on this

2015-02-27 00:05:04

Filling reply buffer.

    Have encountered error -24920:

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

    Constructed the following reply:

        ERR

        -24920,ERR_BACKUPOP: backup operation was unsuccessful

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

Reply buffer filled.

Thanks,

siva

[former_member226400]

Hi Srimann,

Check this link: MaxDB PTS - Problem Tracking - Change Request 1134497: DBMServer

and try to increase the parameter DBM_KTO_SUCCESS  from default value 300 to may be 600.

[Former Member]

Hi Siva,

What type of medium have you defined for this backup is it File type or Pipes. Provide the details of medium_getall and dbm.ebl log files.

provide us with the details also one more thing are you using any 3rd party software for this. if yes do check the settings at the tool end for the configuration for pipe and the server settings.

Let us know the details.

Regards,

Ram

[Former Member]

it is pipe .please find details of medium_getall

for complte data backup we are using templete BackData2

/db2/SID/sapdb/programs/bin/dbmcli on SID>medium_getall

OK

BackLog\mem1    /db2/SID/sapdb/data/files/pipe_mem5     PIPE    LOG     0       8       NO      NO              20120927073425  20120927103249          BACK    0

CompleteF\mem1  /db2/SID/sapdb/data/files/complete      FILE    DATA    0       8       YES     NO              20120927073436  20120927110440          NONE    0

BackData2\mem1  /db2/SID/sapdb/data/files/pipe_mem1     PIPE    DATA    0       8       NO      NO              20150216103203  20150216103203          BACK    0

logF    /db2/SID/sapdb/data/backup/SID_LOG      FILE    LOG     0       8       YES     NO              20150224071028  20150224071028          NONE    0

we are taking backup using tool backint for maxdb and it will store tapes using comvault

please find dbm.ebl logs

*** DBA Action starts:

Timestamp: 20150302000001   Function: sda   Object: DATA

2015-03-02 00:00:01

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 MaxDB Kernel Process.

Using connection to Backint for MaxDB Interface.

2015-03-02 00:00:01

Checking existence and configuration of Backint for MaxDB.

    Using configuration variable 'BSI_ENV' = '/commvault/opt/simpana/SapMaxDbAgent/backint.conf' as path of the configuration fi

    Setting environment variable 'BSI_ENV' for the path of the configuration file of Backint for MaxDB to configuration value '/

    Reading the Backint for MaxDB configuration file '/commvault/opt/simpana/SapMaxDbAgent/backint.conf'.

        Found keyword 'BACKINT' with value '/commvault/opt/simpana/SapMaxDbAgent/backint'.

        Found keyword 'INPUT' with value '/commvault/opt/simpana/SapMaxDbAgent/in'.

        Found keyword 'OUTPUT' with value '/commvault/opt/simpana/SapMaxDbAgent/out'.

        Found keyword 'ERROROUTPUT' with value '/commvault/opt/simpana/SapMaxDbAgent/err'.

        Found keyword 'PARAMETERFILE' with value '/commvault/opt/simpana/SapMaxDbAgent/param'.

        Found keyword 'TIMEOUT_SUCCESS' with value '300'.

        Found keyword 'TIMEOUT_FAILURE' with value '300'.

    Finished reading of the Backint for MaxDB configuration file.

    Using '/commvault/opt/simpana/SapMaxDbAgent/backint' as Backint for MaxDB program.

    Using '/commvault/opt/simpana/SapMaxDbAgent/in' as input file for Backint for MaxDB.

    Using '/commvault/opt/simpana/SapMaxDbAgent/out' as output file for Backint for MaxDB.

    Using '/commvault/opt/simpana/SapMaxDbAgent/err' as error output file for Backint for MaxDB.

    Using '/commvault/opt/simpana/SapMaxDbAgent/param' 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 '/sapdb/SID/data/wrk/SID/dbm.knl' as backup history of a database to migrate.

    Using '/sapdb/SID/data/wrk/SID/dbm.ebf' as external backup history of a database to migrate.

    Checking availability of backups using backint's inquire function.

Check passed successful.

2015-03-02 00:00:01

Checking medium.

Check passed successfully.

2015-03-02 00:00:01

Preparing backup.

    Exporting configuration variable 'LD_LIBRARY_PATH' with value '/commvault/opt/simpana/Base'.

    Exporting configuration variable 'SHLIB_PATH' with value '/commvault/opt/simpana/Base'.

    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 '/commvault/opt/simpana/SapMaxDbAgent/backint -u SID -f backup -t file -p /commvault/opt/

    Created temporary file '/commvault/opt/simpana/SapMaxDbAgent/out' as output for Backint for MaxDB.

    Created temporary file '/commvault/opt/simpana/SapMaxDbAgent/err' as error output for Backint for MaxDB.

    Writing '/db2/SID/sapdb/data/files/pipe_mem1 #PIPE' to the input file.

Prepare passed successfully.

2015-03-02 00:00:01

Creating pipes for data transfer.

    Creating pipe '/db2/SID/sapdb/data/files/pipe_mem1' ...

    Done.

All data transfer pipes have been created.

2015-03-02 00:00:01

Starting database action for

     the backup.

    Requesting 'SAVE DATA QUICK TO  '/db2/SID/sapdb/data/files/pipe_mem1' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'BackData2''

The database is working on the request.

2015-03-02 00:00:01

Waiting until database has prepared the backup.

    Asking for state of database.

    2015-03-02 00:00:01 Database is still preparing the backup.

    Waiting 1 second ...

    Done.

    Asking for state of database.

    2015-03-02 00:00:02 Database has finished preparation of the backup.

The database has prepared the backup successfully.

2015-03-02 00:00:02

Starting Backint for MaxDB.

    Starting Backint for MaxDB process '/commvault/opt/simpana/SapMaxDbAgent/backint -u SID -f backup -t file -p /commvault/opt/

    Process was started successfully.

Backint for MaxDB has been started successfully.

2015-03-02 00:00:02

Waiting for end of the backup operation.

    2015-03-02 00:00:02 The backup tool process has finished work with return code 0.

    2015-03-02 00:00:02 The backup tool is not running.

    2015-03-02 00:00:02 The database is working on the request.

    2015-03-02 00:00:02 The database is working on the request.

    2015-03-02 00:00:07 The database is working on the request.

    2015-03-02 00:00:17 The database is working on the request.

    2015-03-02 00:00:32 The database is working on the request.

    2015-03-02 00:00:52 The database is working on the request.

    2015-03-02 00:01:17 The database is working on the request.

    2015-03-02 00:01:47 The database is working on the request.

    2015-03-02 00:02:22 The database is working on the request.

    2015-03-02 00:03:02 The database is working on the request.

    2015-03-02 00:03:47 The database is working on the request.

    2015-03-02 00:04:37 The database is working on the request.

    2015-03-02 00:05:03 Canceling Utility-task after a timeout of 300 seconds elapsed ...

    OK.

    2015-03-02 00:05:04 The database has finished work on the request.

    Receiving a reply from the database kernel.

    Reply from db-kernel:

        SQL-Code              :-903

    End of reply from db-kernel.

The backup operation has ended.

2015-03-02 00:05:05

Filling reply buffer.

    Have encountered error -24920:

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

    Constructed the following reply:

        ERR

        -24920,ERR_BACKUPOP: backup operation was unsuccessful

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

Reply buffer filled.

2015-03-02 00:05:05

Cleaning up.

    Removing data transfer pipes.

        Removing data transfer pipe /db2/SID/sapdb/data/files/pipe_mem1 ...

        Done.

    Removed data transfer pipes successfully.

    Copying output of Backint for MaxDB to this file.

    ---------- Begin of output of Backint for MaxDB (/commvault/opt/simpana/SapMaxDbAgent/out)----------

    ---------- End of output of Backint for MaxDB (/commvault/opt/simpana/SapMaxDbAgent/out)----------

    Removed Backint for MaxDB's temporary output file '/commvault/opt/simpana/SapMaxDbAgent/out'.

    Copying error output of Backint for MaxDB to this file.

    ---------- Begin of error output of Backint for MaxDB (/commvault/opt/simpana/SapMaxDbAgent/err)----------

    ---------- End of error output of Backint for MaxDB (/commvault/opt/simpana/SapMaxDbAgent/err)----------

    Removed Backint for MaxDB's temporary error output file '/commvault/opt/simpana/SapMaxDbAgent/err'.

    Removed the Backint for MaxDB input file '/commvault/opt/simpana/SapMaxDbAgent/in'.

Have finished clean up successfully.

*** SAVE/RESTORE request:

SAVE DATA CANCEL

*** SAVE/RESTORE request accepted:

OK

*** SAVE/RESTORE result:

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time

*** DBA Action ends:

Timestamp: 20150302000505   State:    Failure

[Former Member]

Hi Siva,

As your using Comvault for the backup solution do check below things:-

when you run the backup do the pipe_mem1 get created under below folders, which will confirm that the issue is not at SAP end if the files are getting created.

/db2/SID/sapdb/data/files
 Reading the Backint for MaxDB configuration file '/commvault/opt/simpana/SapMaxDbAgent/backint.conf'.



        Found keyword 'BACKINT' with value '/commvault/opt/simpana/SapMaxDbAgent/backint'.



        Found keyword 'INPUT' with value '/commvault/opt/simpana/SapMaxDbAgent/in'.


   Created temporary file '/commvault/opt/simpana/SapMaxDbAgent/err' as error output for Backint for MaxDB.



    Writing '/db2/SID/sapdb/data/files/pipe_mem1 #PIPE' to the input file.

Also i can see for the logs the backup opration is timing out.:-

Prepare passed successfully.

015-03-02 00:03:47 The database is working on the request.

       2015-03-02 00:04:37 The database is working on the request.

       2015-03-02 00:05:03 Canceling Utility-task after a timeout of 300 seconds elapsed ...

     OK.

       2015-03-02 00:05:04 The database has finished work on the request.

     Receiving a reply from the database kernel.

    Reply from db-kernel:

         SQL-Code              :-903

     End of reply from db-kernel.

 The backup operation has ended.

So check with the backup team about the Backup media server where your taking backups to tape is it timing out. Check the backinit file for same.

Also can you let me know if your using dbmcli command lines and version of your MAXdb as there are some limitation for version support by comvault.

And in meantime can you try to reinstall the Comvault agent and install a SAPMaxDB agent as we are using the specific SAPMAxDB agent of comvault in our setup.

Let me know if this helps.

Regards,

Ram