• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TDP ERP DB2 restore fails SQL2062N RC:18

AjM

ADSM.ORG Member
#1
Hello,

Im setting up new backups on sap servers with tdp erp db2 6.3 on linux, after succesfull backup with tdp erp backom tool, tried a restore but it fails with this code. DB2 starts creating db structure but after that it fails.

Command run with db2sid user
Code:
backom -c r_db -a PRD -b 1024 -B 2 -S 1 -P 2 -e /opt/tivoli/tsm/tdp_r3/initPRD.utl
[B]SQL2062N  An error occurred while accessing media "VENDOR".  Reason code:"18".[/B]
[B]SQL2008N  The utility command could not be processed because the callerac
parameter is not within valid range or the requested action is out ofsequence.[/B]
BKI8548I: Elapsed time: 9 min 26 sec
BKI8618E: Restore command failed due to an error.
BKI8512I: Return code is: 300

backom.log
Code:
BKI8806I: Data Protection for SAP(R) - BackOM 6.3.0.0 (475X) Sep 22 2011
BKI2027I: Using TSM-API version 6.3.0.0 (compiled with 5.5.0.0).
BKI8652I: DB2 version 'SQL09076' with 64 bits detected.
BKI8511I: The command is: -c r_db -a PRD -b 1024 -B 2 -S 1 -P 2 -e /opt/tivoli/tsm/tdp_r3/initPRD.utl
BKI8541I: Using profile '/opt/tivoli/tsm/tdp_r3/initPRD.utl'.
BKI8540I: Using ProLE at sapprd:tdpr3db264
BKI8543I: Querying TSM for file(s) '?*-PRD-NODE????-??????????????.tdi'.
BKI8543I: Querying TSM for file(s) '?*.PRD.?.NODE????.??????????????.?*'.
BKI8610I: Restoring database backup ...
BKI8643I: Using vendor library at '/opt/tivoli/tsm/tdp_r3/db264/libtdpdb264.so' ...
BKI8640I: Using 2 buffers with a size of 1024 ...
BKI8641I: Using 1 session(s) ...
BKI8642I: Using a degree of parallelism of 2 ...
SQL2062N  An error occurred while accessing media "VENDOR".  Reason code:
"18".
SQL2008N  The utility command could not be processed because the callerac
parameter is not within valid range or the requested action is out of
sequence.
BKI8548I: Elapsed time: 9 min 26 sec
BKI8618E: Restore command failed due to an error.
BKI8512I: Return code is: 300

tdpdb2.PRD.NODE0000.log
Code:
BKI8806I: Data Protection for SAP(R) 6.3.0.0 (475X) Sep 22 2011
BKI2027I: Using TSM-API version 6.3.0.0 (compiled with 5.5.0.0).
BKI8816I: DB2 version 'SQL09076' detected.
BKI8800I: The command is: RESTORE
BKI8801I: Time: 2013-01-19-10.37.47.0994 --- PID: 29096
BKI8822I: Configuration parameter(s):
            TDP_DIR=/opt/tivoli/tsm/tdp_r3/tdplog
            XINT_PROFILE=/opt/tivoli/tsm/tdp_r3/initPRD.utl
            CALLER=BACKOM
BKI8814I: Inquired TSM with mask '*.PRD.*.NODE0000.20130117174641.*'.
BKI8802I: Found 1 database image(s) on TSM server.
BKI7049I: The default for environment variable PROLE_PORT will be used.
BKI5016I: Time: 01/19/2013 10:38:02 AM New TSM session created: MGMNT-CLASS: , TSM-Server: TSMxxxx, type: SIMPLE
BKI5010E: Tivoli Storage Manager Error:
ANS1017E (RC-50)  Session rejected: TCP/IP connection failure
(rc=-50).
BKI8810I: Cleaning up resources of process 29096'.
Please advise
Regards
 
Last edited:

DazRaz

ADSM.ORG Senior Member
#2
It looks like the client lost connection to the TSM server. I've seen the "Vendor: Reason Code 18" when running backups are killed either manually or a higher priority process prempts it.

Assuming that network is ok, TSM is up and basic connectivity is ok, I would search the TSM activity log at the time the restore process stopped. You may find more info there.
 

jackyzhang

ADSM.ORG Member
#3
Hi, AjM,

Recenly I have deployed the TSM ERP(DB2) for my customer.

#1, For this file '/opt/tivoli/tsm/tdp_r3/initPRD.utl', please confirm the server_a stanza's nodename and other configration is right.

#2, /opt/tivoli/tsm/api/bin64/dsm.sys, please confirm this file's ip and nodename is right.

#3, /opt/tivoli/tsm/tdp_r3/db264/backom -c password, have you confirm the password setting is OK?
 

AjM

ADSM.ORG Member
#4
It looks like the client lost connection to the TSM server. I've seen the "Vendor: Reason Code 18" when running backups are killed either manually or a higher priority process prempts it.

Assuming that network is ok, TSM is up and basic connectivity is ok, I would search the TSM activity log at the time the restore process stopped. You may find more info there.
I can restore logs using backom and db2 cmd loading tdp library,
I have a PMR with IBM, they asked for actlog and q opt.
 

AjM

ADSM.ORG Member
#5
Hi, AjM,

Recenly I have deployed the TSM ERP(DB2) for my customer.

#1, For this file '/opt/tivoli/tsm/tdp_r3/initPRD.utl', please confirm the server_a stanza's nodename and other configration is right.

#2, /opt/tivoli/tsm/api/bin64/dsm.sys, please confirm this file's ip and nodename is right.

#3, /opt/tivoli/tsm/tdp_r3/db264/backom -c password, have you confirm the password setting is OK?
All config files are fine, logs restore works fine with backom and db2 cmds loading shared library

DB full database restore fails with that code, I guess after database is prepared by db2 on filesystems, you can see them grow
 

smajl

ADSM.ORG Senior Member
#6
Return code 18 from TSM API stands for:

DSM_RS_ABORT_NO_MEMORY 18
Verify if there is enough memory available on server where are you performing the restore and/or settings of ulimit (ulimit -a to see actual settings). Try monitoring memory usage after you start the restore.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 17 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 53 60.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.5%
  • Other (please comement)

    Votes: 7 8.0%

Forum statistics

Threads
31,466
Messages
134,102
Members
21,565
Latest member
Chrescht
Top