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

[Former Member]

Dear all,

I've problems with a backup with MaxDB Databse Studio.

Here are the Log, hope you can help me:

Complete data backup
(Apr 11, 2013 8:26:57 PM)

*** DBA Action starts:

Timestamp:
20130411202657 Function: sda Object: DATA

2013-04-11 20:26:57

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
IBM's TSM with client adint2.

2013-04-11 20:26:57

Checking existence and
configuration of adint2.

Using configuration variable 'ADINT' =
'/SZIR/adsm/adint' as adint2 directory.

Setting environment variable 'ADINT' for the
adint2 directory to configuration value '/SZIR/adsm/adint'.

Using TSM program '/SZIR/adsm/adint/adint2'.

Using configuration variable 'ADA_OPT' =
'/SZIR/adsm/adint/initP44.utl' as TSM options file.

Setting environment variable 'ADA_OPT' for the
TSM options file to configuration value '/SZIR/adsm/adint/initP44.utl'.

Check passed
successful.

2013-04-11 20:26:57

Checking medium.

Check passed
successfully.

2013-04-11 20:26:57

Preparing backup.

Constructed save label 'Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA'.

Constructed adint2 call
'/SZIR/adsm/adint/adint2 -b -n Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA
-c 65536 -p /sapdb/P44/sapbackup/adint_P44'.

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

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

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

Prepare passed
successfully.

2013-04-11 20:26:57

Creating pipes for data
transfer.

Creating pipe '/sapdb/P44/sapbackup/adint_P44'
...

Done.

All data transfer pipes
have been created.

2013-04-11 20:26:57

Starting database
action for

the backup.

Requesting 'SAVE DATA QUICK TO '/sapdb/P44/sapbackup/adint_P44'
PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'ADSM_DATA'' from db-kernel.

The database is working
on the request.

2013-04-11 20:26:57

Waiting until database
has prepared the backup.

Asking for state of database.

2013-04-11 20:26:57 Database is still
preparing the backup.

Waiting 1 second ...

Done.

Asking for state of database.

2013-04-11 20:26:58 Database has finished
preparation of the backup.

The database has
prepared the backup successfully.

2013-04-11 20:26:58

Starting adint2.

Calling backup tool process
'/SZIR/adsm/adint/adint2 -b -n Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA
-c 65536 -p /sapdb/P44/sapbackup/adint_P44 </var/tmp/temp1365704817-0
>>/var/tmp/temp1365704817-1 2>>/var/tmp/temp1365704817-2' ...

OK.

adint2 has been started
successfully.

2013-04-11 20:26:58

Waiting for end of the
backup operation.

2013-04-11 20:26:58 The backup tool is
running.

2013-04-11 20:26:58 The database is working on
the request.

2013-04-11 20:27:01 The backup tool process
has finished work with return code 255.

2013-04-11 20:27:03 The database is working on
the request.

2013-04-11 20:27:13 The database is working on
the request.

2013-04-11 20:27:28 The database is working on
the request.

2013-04-11 20:27:49 The database is working on
the request.

2013-04-11 20:28:02 Canceling Utility-task
after a timeout of 60 seconds elapsed ...

OK.

2013-04-11 20:28:03 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.

2013-04-11 20:28:03

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.

2013-04-11 20:28:03

Cleaning up.

Removing data transfer pipes.

Removing data transfer pipe /sapdb/P44/sapbackup/adint_P44
...

Done.

Removed data transfer pipes successfully.

Copying output of TSM to this file.

---------- Begin of output of TSM
(/var/tmp/temp1365704817-1)----------

awk -f /SZIR/adsm/adint/adint2.awk
</SZIR/adsm/adint/initP44.utl 1>/WORK/TMP/initSID.utl.20130411202659

ADINT Interfacetool between MaxDB and TSM

Version 2, Release 4, Modification 3 for Linux
x86_64

Build: 118 compiled on May 25 2012

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

ADI0047E: Syntax error in line 45 with content
><<

ADI0047E: Syntax error in line 45 with content
>><

ADI0044E: Error while checking the profile
>/WORK/TMP/initSID.utl.20130411202659<

ADI0003E: ADINT has ended with an error.

---------- End of output of TSM (/var/tmp/temp1365704817-1)----------

Removed TSM's temporary output file
'/var/tmp/temp1365704817-1'.

Copying error output of TSM to this file.

---------- Begin of error output of TSM
(/var/tmp/temp1365704817-2)----------

#------------------------------------------------------------------------------

#

# IBM ADINT/TSM interface for MaxDB and Tivoli
Storage Manager

#

# Sample Profile for ADINT/TSM

#

#------------------------------------------------------------------------------

#------------------------------------------------------------------------------

# Range: 0-32768

# A value of '0' means all versions will be
kept.

#------------------------------------------------------------------------------

# MAX_VERSION 3    

#------------------------------------------------------------------------------

# Range: 0-100

# '15' is a good default for daily work.
Increase only if instructed by

# support.

#------------------------------------------------------------------------------

TRACE 15      

#------------------------------------------------------------------------------

# This is where the ADINT/TSM logfile will be
written to. Also a user defined

# name for the ADINT/TSM logfile can be
specified.

#------------------------------------------------------------------------------

LOGFILE /SZIR/adsm/adint/adint2.log

#------------------------------------------------------------------------------

# Range: 0-1048576

# Specifies the size (Byte) of the data transfer
buffer for ADINT/TSM

# and TSM API.

#------------------------------------------------------------------------------

BUFFERSIZE 131072  

#------------------------------------------------------------------------------

# Range: 1-2

# Specifies the number of redolog copies
created by ADINT/TSM

#------------------------------------------------------------------------------

REDOLOGCOPIES      1

#------------------------------------------------------------------------------

# Statement for alternate/parallel TSM
servers.

#------------------------------------------------------------------------------

SERVER tsm232d

NODENAME C21

PASSWORDREQUIRED yes # use a TSM password

FULLSESSIONS 4 # Max TSM sessions (full
backup)

UPDATESESSIONS 2 # Max TSM sessions (incr.
backup)

LOGSESSIONS 1 # Max TSM sessions (log backup)

FULLMANAGEMENTCLASS mgmtclass_a

NCUPDATEMANAGEMENTCLASS <mgmtclass_b> #
TSM mgmtclass for incr. backup

LOGMANAGEMENTCLASS mgmtclass_c

#SERVER <server_b> # TSM servername
(max. 64 chars.)

# NODENAME <node_b> # TSM nodename (max.
64 chars.)

# PASSWORDREQUIRED yes # use a TSM password

# FULLSESSIONS 4 # Max TSM sessions (full
backup)

# UPDATESESSIONS 2 # Max TSM sessions (incr.
backup)

# LOGSESSIONS 1 # Max TSM sessions (log
backup)

# FULLMANAGEMENTCLASS <mgmtclass_d> #
TSM mgmtclass for full backup

# NCUPDATEMANAGEMENTCLASS <mgmtclass_e>
# TSM mgmtclass for incr. backup

# LOGMANAGEMENTCLASS <mgmtclass_f> # TSM
mgmtclass for log backup

#------------------------------------------------------------------------------ 

# End of profile

UPDATEMANAGEMENTCLASS mgmtclass_b

Running in TSM environment as ...

ASNODENAME:

NASNODENAME:

NODENAME: C21

OFFLOADNODENAME:

SERVERNAME: TSM232D

VIRTUALNODENAME: C21

ANS9999E dsmdirect2.sh had errors

---------- End of error output of TSM
(/var/tmp/temp1365704817-2)----------

Removed TSM's temporary error output file
'/var/tmp/temp1365704817-2'.

Removing temporary adint2 input pipe
/var/tmp/temp1365704817-0 ...

Done.

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:
20130411202803 State: Failure

[former_member188883 · Accepted solution]

Hi Holger,

Could you share dbm.ebp and dbm.ebl logs.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Where can I find these files?

[former_member188883 · Accepted solution]

Hi Holger ,

You can get these files from below location

/sapdb/data/wrk/<DBSID>/<SID>

Regards,

Deepak Kori

[Former Member · Accepted solution]

dbm.ebp:

2013-04-11
20:26:57

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 IBM's TSM with client adint2.

2013-04-11
20:26:57

Checking
existence and configuration of adint2.

    Using configuration variable 'ADINT' =
'/SZIR/adsm/adint' as adint2 directory.

    Setting environment variable 'ADINT' for
the adint2 directory to configuration value '/SZIR/adsm/adint'.

    Using TSM program
'/SZIR/adsm/adint/adint2'.

    Using configuration variable 'ADA_OPT' =
'/SZIR/adsm/adint/initP44.utl' as TSM options file.

    Setting environment variable 'ADA_OPT' for
the TSM options file to configuration value '/SZIR/adsm/adint/initP44.utl'.

Check
passed successful.

2013-04-11
20:26:57

1. Checking
   medium.

Check
passed successfully.

2013-04-11
20:26:57

1. Preparing
   backup.

    Constructed save label 'Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA'.

    Constructed adint2 call
'/SZIR/adsm/adint/adint2 -b -n Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA
-c 65536 -p /sapdb/P44/sapbackup/adint_P44'.

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

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

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

Prepare
passed successfully.

2013-04-11
20:26:57

Creating
pipes for data transfer.

    Creating pipe '/sapdb/P44/sapbackup/adint_P44'
... Done.

All data
transfer pipes have been created.

2013-04-11
20:26:57

Starting
database action for the backup.

    Requesting 'SAVE DATA QUICK TO  '/sapdb/P44/sapbackup/adint_P44' PIPE
BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'ADSM_DATA'' from db-kernel.

The
database is working on the request.

2013-04-11
20:26:57

Waiting
until database has prepared the backup.

    Asking for state of database.

    2013-04-11 20:26:57 Database is still
preparing the backup.

    Waiting 1 second ... Done.

    Asking for state of database.

    2013-04-11 20:26:58 Database has finished
preparation of the backup.

The
database has prepared the backup successfully.

2013-04-11
20:26:58

Starting
adint2.

    Calling backup tool process
'/SZIR/adsm/adint/adint2 -b -n Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA
-c 65536 -p /sapdb/P44/sapbackup/adint_P44 </var/tmp/temp1365704817-0

>>/var/tmp/temp1365704817-1
2>>/var/tmp/temp1365704817-2' ... OK.

adint2 has
been started successfully.

2013-04-11
20:26:58

Waiting for
end of the backup operation.

    2013-04-11 20:26:58 The backup tool is
running.

    2013-04-11 20:26:58 The database is working
on the request.

    2013-04-11 20:27:01 The backup tool process
has finished work with return code 255.

[wagn066@Server1:NOENV]/sapdb/P44/data/wrk/P44:
sudo vi dbm.ebp

2013-04-11
20:26:57

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 IBM's TSM with client adint2.

2013-04-11
20:26:57

Checking
existence and configuration of adint2.

    Using configuration variable 'ADINT' =
'/SZIR/adsm/adint' as adint2 directory.

    Setting environment variable 'ADINT' for
the adint2 directory to configuration value '/SZIR/adsm/adint'.

    Using TSM program
'/SZIR/adsm/adint/adint2'.

    Using configuration variable 'ADA_OPT' =
'/SZIR/adsm/adint/initP44.utl' as TSM options file.

    Setting environment variable 'ADA_OPT' for
the TSM options file to configuration value '/SZIR/adsm/adint/initP44.utl'.

Check
passed successful.

2013-04-11
20:26:57

1. Checking
   medium.

Check
passed successfully.

2013-04-11
20:26:57

1. Preparing
   backup.

    Constructed save label 'Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA'.

    Constructed adint2 call
'/SZIR/adsm/adint/adint2 -b -n Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA
-c 65536 -p /sapdb/P44/sapbackup/adint_P44'.

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

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

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

Prepare
passed successfully.

2013-04-11
20:26:57

Creating
pipes for data transfer.

    Creating pipe '/sapdb/P44/sapbackup/adint_P44'
... Done.

All data
transfer pipes have been created.

2013-04-11
20:26:57

Starting
database action for the backup.

    Requesting 'SAVE DATA QUICK TO  '/sapdb/P44/sapbackup/adint_P44' PIPE
BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'ADSM_DATA'' from db-kernel.

The
database is working on the request.

2013-04-11
20:26:57

Waiting
until database has prepared the backup.

    Asking for state of database.

    2013-04-11 20:26:57 Database is still
preparing the backup.

    Waiting 1 second ... Done.

    Asking for state of database.

    2013-04-11 20:26:58 Database has finished
preparation of the backup.

The
database has prepared the backup successfully.

2013-04-11
20:26:58

Starting
adint2.

    Calling backup tool process
'/SZIR/adsm/adint/adint2 -b -n Server1_P44_2013.04.11_20.26.57_SAVEDTNCHK_ADSM_DATA
-c 65536 -p /sapdb/P44/sapbackup/adint_P44 </var/tmp/temp1365704817-0
>>/var/tmp/temp1365704817-1 2>>/var/tmp/temp1365704817-2' ... OK.

adint2 has
been started successfully.

2013-04-11
20:26:58

Waiting for
end of the backup operation.

    2013-04-11 20:26:58 The backup tool is
running.

    2013-04-11 20:26:58 The database is working
on the request.

    2013-04-11 20:27:01 The backup tool process
has finished work with return code 255.

[Former Member · Accepted solution]

dbm.ebl:

#------------------------------------------------------------------------------

        # Range: 0-100

        # '15' is a good default for daily
work. Increase only if instructed by

        # support.

      
#------------------------------------------------------------------------------

        TRACE                        15

      
#------------------------------------------------------------------------------

        # This is where the ADINT/TSM logfile
will be written to. Also a user defined

        # name for the ADINT/TSM logfile can be
specified.

      
#------------------------------------------------------------------------------

        LOGFILE                    
/SZIR/adsm/adint/adint2.log

      
#------------------------------------------------------------------------------

        # Range: 0-1048576

        # Specifies the size (Byte) of the data
transfer buffer for ADINT/TSM

        # and TSM API.

        #------------------------------------------------------------------------------

        BUFFERSIZE                   131072

      
#------------------------------------------------------------------------------

        # Range: 1-2

        # Specifies the number of redolog
copies created by ADINT/TSM

      
#------------------------------------------------------------------------------

        REDOLOGCOPIES                1

      
#------------------------------------------------------------------------------

        # Statement for alternate/parallel TSM
servers.

      
#------------------------------------------------------------------------------

          SERVER                    tsm232d

          NODENAME                  C21

          PASSWORDREQUIRED          yes             # use a TSM password

          FULLSESSIONS              4               # Max TSM sessions (full backup)

          UPDATESESSIONS            2               # Max TSM sessions (incr.
backup)

          LOGSESSIONS               1               # Max TSM sessions (log backup)

          FULLMANAGEMENTCLASS       mgmtclass_a

          NCUPDATEMANAGEMENTCLASS   <mgmtclass_b>   # TSM mgmtclass for incr. backup

          LOGMANAGEMENTCLASS        mgmtclass_c

        #SERVER                     <server_b>       # TSM servername (max. 64 chars.)

        #
NODENAME               
<node_b>         # TSM
nodename (max. 64 chars.)

        #
PASSWORDREQUIRED          yes             # use a TSM password

      
#  FULLSESSIONS              4               # Max TSM sessions (full backup)

        #
UPDATESESSIONS            2               # Max TSM sessions (incr.
backup)

        #
LOGSESSIONS               1               # Max TSM sessions (log backup)

        #
FULLMANAGEMENTCLASS     
<mgmtclass_d>   # TSM
mgmtclass for full backup

        #
NCUPDATEMANAGEMENTCLASS 
<mgmtclass_e>   # TSM
mgmtclass for incr. backup

        #
LOGMANAGEMENTCLASS      
<mgmtclass_f>   # TSM
mgmtclass for log backup

      
#------------------------------------------------------------------------------

        # End of profile

          UPDATEMANAGEMENTCLASS     mgmtclass_b

        Running in TSM environment as ...

                       ASNODENAME:

                      NASNODENAME:

                         NODENAME: C21

                  OFFLOADNODENAME:

                       SERVERNAME: TSM232D

                  VIRTUALNODENAME: C21

        ANS9999E dsmdirect2.sh had errors

    ---------- End of error output of TSM
(/var/tmp/temp1365704817-2)----------

    Removed TSM's temporary error output file
'/var/tmp/temp1365704817-2'.

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

Have
finished clean up successfully.

[former_member188883 · Accepted solution]

Hi Holger,

As per the link http://maxdb.sap.com/webpts?wptsdetail=yes&ErrorType=1&ErrorID=1134497

could you set the parameter

DBM_KTO_SUCCESS = 600 or higher

Check the results and revert.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

I,ve set the parameter and restart the database.

Backup with the same error.

[former_member188883 · Accepted solution]

Hi Holger,

Could you share the update dbm.prt, dbm.ebp and dbm.ebl files.

Regards,

Deepak Kori

[Former Member · Accepted solution]

dbm.ebl:

        #------------------------------------------------------------------------------
        # Range: 0-100
        # '15' is a good default for daily work. Increase only if instructed by
        # support.
        #------------------------------------------------------------------------------
        TRACE                        15
        #------------------------------------------------------------------------------
        # This is where the ADINT/TSM logfile will be written to. Also a user defined
        # name for the ADINT/TSM logfile can be specified.
        #------------------------------------------------------------------------------
        LOGFILE                      /SZIR/adsm/adint/adint2.log
        #------------------------------------------------------------------------------
        # Range: 0-1048576
        # Specifies the size (Byte) of the data transfer buffer for ADINT/TSM
        # and TSM API.
        #------------------------------------------------------------------------------
        BUFFERSIZE                   131072
        #------------------------------------------------------------------------------
        # Range: 1-2
        # Specifies the number of redolog copies created by ADINT/TSM
        #------------------------------------------------------------------------------
        REDOLOGCOPIES                1
        #------------------------------------------------------------------------------
        # Statement for alternate/parallel TSM servers.
        #------------------------------------------------------------------------------
          SERVER                    tsm232d
          NODENAME                  C21
          PASSWORDREQUIRED          yes             # use a TSM password
          FULLSESSIONS              4               # Max TSM sessions (full backup)
          UPDATESESSIONS            2               # Max TSM sessions (incr. backup)
          LOGSESSIONS               1               # Max TSM sessions (log backup)
          FULLMANAGEMENTCLASS       mgmtclass_a
          NCUPDATEMANAGEMENTCLASS   <mgmtclass_b>   # TSM mgmtclass for incr. backup
          LOGMANAGEMENTCLASS        mgmtclass_c
        #SERVER                     <server_b>       # TSM servername (max. 64 chars.)
        #  NODENAME                 <node_b>         # TSM nodename (max. 64 chars.)
        #  PASSWORDREQUIRED          yes             # use a TSM password
        #  FULLSESSIONS              4               # Max TSM sessions (full backup)
        #  UPDATESESSIONS            2               # Max TSM sessions (incr. backup)
        #  LOGSESSIONS               1               # Max TSM sessions (log backup)
        #  FULLMANAGEMENTCLASS       <mgmtclass_d>   # TSM mgmtclass for full backup
        #  NCUPDATEMANAGEMENTCLASS   <mgmtclass_e>   # TSM mgmtclass for incr. backup
        #  LOGMANAGEMENTCLASS        <mgmtclass_f>   # TSM mgmtclass for log backup
        #------------------------------------------------------------------------------
        # End of profile
          UPDATEMANAGEMENTCLASS     mgmtclass_b
        Running in TSM environment as ...
                       ASNODENAME:
                      NASNODENAME:
                         NODENAME: C21
                  OFFLOADNODENAME:
                       SERVERNAME: TSM232D
                  VIRTUALNODENAME: C21
        ANS9999E dsmdirect2.sh had errors

    ---------- End of error output of TSM (/var/tmp/temp1365758626-2)----------
    Removed TSM's temporary error output file '/var/tmp/temp1365758626-2'.
    Removing temporary adint2 input pipe /var/tmp/temp1365758626-0 ... Done.
Have finished clean up successfully.

[Former Member · Accepted solution]

dbm.ebp:

2013-04-12
11:23:46

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
configuration variable 'DBM_KTO_SUCCESS' = '=' as timeout for database kernel
in case of success.

Using MaxDB
Kernel Process.

Using
connection to IBM's TSM with client adint2.

2013-04-12
11:23:46

Checking
existence and configuration of adint2.

    Using configuration variable 'ADINT' =
'/SZIR/adsm/adint' as adint2 directory.

    Setting environment variable 'ADINT' for the adint2 directory to configuration value '/SZIR/adsm/adint'.

    Using TSM program
'/SZIR/adsm/adint/adint2'.

    Using configuration variable 'ADA_OPT' =
'/SZIR/adsm/adint/initP44.utl' as TSM options file.

    Setting environment variable 'ADA_OPT' for
the TSM options file to configuration value '/SZIR/adsm/adint/initP44.utl'.

Check
passed successful.

2013-04-12
11:23:46

Checking medium.

Check
passed successfully.

2013-04-12
11:23:46

1. Preparing
   backup.

    Constructed save label 'Server1_P44_2013.04.12_11.23.46_SAVEDTNCHK_ADSM_DATA'.

    Constructed adint2 call
'/SZIR/adsm/adint/adint2 -b -n Server1_P44_2013.04.12_11.23.46_SAVEDTNCHK_ADSM_DATA
-c 65536 -p /sapdb/P44/sapbackup/adint_P44'.

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

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

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

Prepare
passed successfully.

2013-04-12
11:23:46

Creating
pipes for data transfer.

    Creating pipe '/sapdb/P44/sapbackup/adint_P44'
... Done.

All data
transfer pipes have been created.

2013-04-12
11:23:46

Starting
database action for the backup.

    Requesting 'SAVE DATA QUICK TO  '/sapdb/P44/sapbackup/adint_P44' PIPE
BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'ADSM_DATA'' from db-kernel.

The
database is working on the request.

2013-04-12
11:23:46

Waiting
until database has prepared the backup.

    Asking for state of database.

    2013-04-12 11:23:46 Database is still
preparing the backup.

    Waiting 1 second ... Done.

    Asking for state of database.

    2013-04-12 11:23:47 Database has finished
preparation of the backup.

The
database has prepared the backup successfully.

2013-04-12
11:23:47

Starting
adint2.

    Calling backup tool process
'/SZIR/adsm/adint/adint2 -b -n Server1_P44_2013.04.12_11.23.46_SAVEDTNCHK_ADSM_DATA
-c 65536 -p /sapdb/P44/sapbackup/adint_P44 </var/tmp/temp1365758626-0

>>/var/tmp/temp1365758626-1
2>>/var/tmp/temp1365758626-2' ... OK.

adint2 has
been started successfully.

2013-04-12
11:23:47

Waiting for
end of the backup operation.

    2013-04-12 11:23:47 The backup tool is
running.

    2013-04-12 11:23:47 The database is working
on the request.

    2013-04-12 11:23:50 The backup tool process
has finished work with return code 255.

    2013-04-12 11:23:52 The database is working
on the request.

    2013-04-12 11:24:02 The database is working
on the request.

    2013-04-12 11:24:17 The database is working
on the request.

    2013-04-12 11:24:37 The database is working
on the request.

    2013-04-12 11:24:51 Canceling Utility-task
after a timeout of 60 seconds elapsed ... OK.

    2013-04-12 11:24:52 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.

2013-04-12
11:24:53

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.

2013-04-12
11:24:53

1. Cleaning
   up.

    Removing data transfer pipes.

        Removing data transfer pipe /sapdb/P44/sapbackup/adint_P44
... Done.

    Removed data transfer pipes successfully.

    Copying output of TSM to this file.

    ---------- Begin of output of TSM (/var/tmp/temp1365758626-1)----------

        awk -f /SZIR/adsm/adint/adint2.awk
</SZIR/adsm/adint/initP44.utl 1>/WORK/TMP/initSID.utl.20130412112348

                          ADINT Interfacetool
between MaxDB and TSM

                   Version 2, Release 4, Modification
3 for Linux x86_64

                              Build: 118  compiled on May 25 2012

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

        ADI0047E: Syntax error in line 45 with
content ><<

        ADI0047E: Syntax error in line 45 with
content >><

        ADI0044E: Error while checking the
profile >/WORK/TMP/initSID.utl.20130412112348<

        ADI0003E: ADINT has ended with an
error.

    ---------- End of output of TSM
(/var/tmp/temp1365758626-1)----------

  
Removed TSM's temporary output file '/var/tmp/temp1365758626-1'.

    Copying error output of TSM to this file.

    ---------- Begin of error output of TSM
(/var/tmp/temp1365758626-2)----------

      
#------------------------------------------------------------------------------

        #

        #     
IBM ADINT/TSM interface for MaxDB and Tivoli Storage Manager

        #

        #                      Sample Profile for
ADINT/TSM

        #

      
#------------------------------------------------------------------------------

      
#------------------------------------------------------------------------------

        # Range: 0-32768

        # A value of '0' means all versions
will be kept.

      
#------------------------------------------------------------------------------

        # MAX_VERSION                  3

      
#------------------------------------------------------------------------------

        # Range: 0-100

        # '15' is a good default for daily
work. Increase only if instructed by

        # support.

      
#------------------------------------------------------------------------------

        TRACE                        15

        #------------------------------------------------------------------------------

        # This is where the ADINT/TSM logfile
will be written to. Also a user defined

        # name for the ADINT/TSM logfile can be
specified.

      
#------------------------------------------------------------------------------

        LOGFILE                    
/SZIR/adsm/adint/adint2.log

      
#------------------------------------------------------------------------------

        # Range: 0-1048576

        # Specifies the size (Byte) of the data
transfer buffer for ADINT/TSM

        # and TSM API.

      
#------------------------------------------------------------------------------

        BUFFERSIZE                   131072

      
#------------------------------------------------------------------------------

        # Range: 1-2

        # Specifies the number of redolog
copies created by ADINT/TSM

      
#------------------------------------------------------------------------------

        REDOLOGCOPIES                1

      
#------------------------------------------------------------------------------

        # Statement for alternate/parallel TSM
servers.

      
#------------------------------------------------------------------------------

          SERVER                    tsm232d

          NODENAME                  C21

          PASSWORDREQUIRED          yes             # use a TSM password

          FULLSESSIONS              4               # Max TSM sessions (full backup)

          UPDATESESSIONS            2               # Max TSM sessions (incr. backup)

          LOGSESSIONS               1               # Max TSM sessions (log backup)

          FULLMANAGEMENTCLASS       mgmtclass_a

          NCUPDATEMANAGEMENTCLASS   <mgmtclass_b>   # TSM mgmtclass for incr. backup

          LOGMANAGEMENTCLASS        mgmtclass_c

        #SERVER                     <server_b>       # TSM servername (max. 64 chars.)

        #
NODENAME               
<node_b>         # TSM
nodename (max. 64 chars.)

        #
PASSWORDREQUIRED          yes             # use a TSM password

        #
FULLSESSIONS              4               # Max TSM sessions (full backup)

        #
UPDATESESSIONS            2               # Max TSM sessions (incr.
backup)

        #
LOGSESSIONS               1             
# Max TSM sessions (log backup)

        #
FULLMANAGEMENTCLASS     
<mgmtclass_d>   # TSM
mgmtclass for full backup

        #
NCUPDATEMANAGEMENTCLASS 
<mgmtclass_e>   # TSM
mgmtclass for incr. backup

        #
LOGMANAGEMENTCLASS        <mgmtclass_f>   # TSM mgmtclass for log backup

      
#------------------------------------------------------------------------------

        # End of profile

          UPDATEMANAGEMENTCLASS     mgmtclass_b

        Running in TSM environment as ...

                       ASNODENAME:

                      NASNODENAME:

                         NODENAME: C21

                  OFFLOADNODENAME:

                       SERVERNAME: TSM232D

                  VIRTUALNODENAME: C21

        ANS9999E dsmdirect2.sh had errors

    ---------- End of error output of TSM
(/var/tmp/temp1365758626-2)----------

    Removed TSM's temporary error output file
'/var/tmp/temp1365758626-2'.

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

Have finished
clean up successfully.

[Former Member · Accepted solution]

dbm.prt:

------------------------------------------------------------------------------

Date       Time   
PID        Typ MsgID      Label  
Message

------------------------------------------------------------------------------

2013-04-12
11:23:46       9422 INF        283 DBMSrv   Command 'backup_start "ADSM_DATA"
DATA' is being executed.

2013-04-12
11:23:46       9422 INF          1 DBMKnl   Sending an administrative statement to the
database P44 on computer localhost

                          9422 INF          8 DBMKnl   Statement:
SAVE DATA QUICK TO  '/sapdb/P44/sapbackup/adint_P44'
PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'ADSM_DATA'

2013-04-12
11:24:53       9422 ERR          3 DBMKnl   Received the result of an administrative
statement from the database P44 on computer localhost

                          9422 ERR          9 DBMKnl   Statement:
SAVE DATA QUICK TO  '/sapdb/P44/sapbackup/adint_P44'
PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'ADSM_DATA'

                          9422 ERR         10 DBMKnl   Returncode: -903

                          9422 ERR          5 DBMKnl   Errortext:
Host file I/O error

2013-04-12
11:24:53       9422 ERR     -24920 DBMSrv   ERR_BACKUPOP: backup operation was
unsuccessful

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

2013-04-12
11:24:53       9422 ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'backup_start'
has ended and failed with return code -24920.

2013-04-12
11:24:53       9422 INF          1 DBMKnl   Sending an administrative statement to the
database P44 on computer localhost

                          9422 INF          8 DBMKnl   Statement:
SAVE DATA CANCEL

2013-04-12
11:24:53       9422 ERR          3 DBMKnl   Received the result of an administrative
statement from the database P44 on computer localhost

                          9422 ERR          9 DBMKnl   Statement:
SAVE DATA CANCEL

                          9422 ERR         10 DBMKnl 
Returncode: -104

                          9422 ERR          5 DBMKnl   Errortext:
DBM command impossible at this time

[former_member188883 · Accepted solution]

Hi Holger,

Could you share output from these 2 commands

1) dbmcli -d <db_name> -u control,<pwd> medium_getall

2) ls -l /sapdb/P44/sapbackup/adint_P44

Regards,

Deepak Kori

[Former Member · Accepted solution]

Dear Deepak,

problem is solved.
Storage department (pipe backup) configured *.utl-files.

Now it is running.

Thanks a lot.

But there is another issues with R3trans problem.......
I will create a new discussion.

[Former Member · Accepted solution]

Hi all,

sorry to write here.

I openned a discution and received an email as being approuved. but

but when click on link to message in email, I receive : 

Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.

thank for help.