• 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.

Need help TDP for SQL fails on a cluster node with Failed 1

pavchinn

ADSM.ORG Member
Joined
Apr 25, 2007
Messages
16
Reaction score
0
Points
0
My daily schedule backup is failing with Failed 1

This is all there in the log file. even after changing the permission for services it failed

11/09/2010 04:00:48 Command will be executed in 10 minutes.
11/09/2010 04:10:48
Executing scheduled command now.
11/09/2010 04:10:48 Node Name: SCFLOKYDCMSQL81_SQL
11/09/2010 04:10:48 Session established with server FLOTSM2: AIX-RS/6000
11/09/2010 04:10:48 Server Version 5, Release 5, Level 1.1
11/09/2010 04:10:48 Server date/time: 11/09/2010 04:10:48 Last access: 11/09/2010 04:00:48
11/09/2010 04:10:48
Executing Operating System command or script:
c:\progra\~1\tivoli\tsm\tdpsql\sqlfull.cmd e
11/09/2010 04:10:48 Finished command. Return code is: 1
11/09/2010 04:10:48 ANS1909E The scheduled command failed.
11/09/2010 04:10:48 ANS1512E Scheduled event 'TESTTDP' failed. Return code = 1.
11/09/2010 04:10:48 Sending results for scheduled event 'TESTTDP'.
11/09/2010 04:10:48 Results sent to server for scheduled event 'TESTTDP'.

I can start the TDP for cluster drive manually and take backup but only scheduled backup fails.

Server win 2003 - SQL 2005 - BACLIEnt - 5.5.2.12 - TDP - 5.5.3.2
 

moon-buddy

ADSM.ORG Moderator
Joined
Aug 24, 2005
Messages
7,033
Reaction score
405
Points
0
Location
Somewhere in the US
First thing to check: does the script call the right location for your SQL database?

On cluster setups, shared environment actions (backups, services, etc) are normally called from the cluster shared resources unless careful attention have been given in setting this up properly to be called from the active node.
 

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: 20 18.9%
  • Keep using TSM for Spectrum Protect.

    Votes: 64 60.4%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.3%
  • Other (please comement)

    Votes: 9 8.5%

Forum statistics

Threads
31,837
Messages
135,770
Members
21,788
Latest member
london
Top