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

SAP backup is failing when it running through tsm scheduler service

shaaha85

Active Newcomer
Joined
Nov 23, 2010
Messages
37
Reaction score
0
Points
0
Hi guys,

I am getting error when i try to backup TDP SAP through TSM scheduler service.But when i execute the script in client end its working fine & taking the backup.


* It seems like schedule object is opening the script line but it failed to execute the command in script.

*I gave full permission to the script.

Please help me to fix the issue .

########################################################################
huxd0025:/usr/tivoli/tsm/client/ba/bin# ls -lrt
-rwxrwxrwx 1 root system 174 29 Aug 15:56 sap_weekly_FCQ.sh


########################################################################
huxd0025:/usr/tivoli/tsm/client/ba/bin# cat sap_weekly_FCQ.sh
#!/bin/ksh
# Full DB2 online backup, including logs
su - db2fcq -c "/usr/tivoli/tsm/tdp_r3/db264/backom -c b_db -a FCQ -B 12 -S 4 -P 8 -e /db2/FCQ/dbs/initFCQ_WEEKLY.utl -O"


##########################################################################

dsmsched.log:
30/08/13 09:41:22 TSM Backup-Archive Client Version 5, Release 5, Level 1.13
30/08/13 09:41:22 Querying server for next scheduled event.
30/08/13 09:41:22 Node Name: FCQ_SAP_WEEKLY
30/08/13 09:41:22 Session established with server TSM_BLUE: AIX-RS/6000
30/08/13 09:41:22 Server Version 5, Release 5, Level 5.0
30/08/13 09:41:22 Server date/time: 30/08/13 09:41:22 Last access: 30/08/13 08:41:22


30/08/13 09:41:22 --- SCHEDULEREC QUERY BEGIN
30/08/13 09:41:22 --- SCHEDULEREC QUERY END
30/08/13 09:41:22 Next operation scheduled:
30/08/13 09:41:22 ------------------------------------------------------------
30/08/13 09:41:22 Schedule Name: @879
30/08/13 09:41:22 Action: Command
30/08/13 09:41:22 Objects: /usr/tivoli/tsm/client/ba/bin/sap_weekly_FCQ.sh
30/08/13 09:41:22 Options:
30/08/13 09:41:22 Server Window Start: 09:20:16 on 30/08/13
30/08/13 09:41:22 ------------------------------------------------------------
30/08/13 09:41:22
Executing scheduled command now.
30/08/13 09:41:22
Executing Operating System command or script:
/usr/tivoli/tsm/client/ba/bin/sap_weekly_FCQ.sh
30/08/13 09:41:22 Finished command. Return code is: 1
30/08/13 09:41:22 ANS1909E The scheduled command failed.
30/08/13 09:41:22 ANS1512E Scheduled event '@879' failed. Return code = 1.
30/08/13 09:41:22 Sending results for scheduled event '@879'.
30/08/13 09:41:22 Results sent to server for scheduled event '@879'.
################################################################


query event:
Policy Domain Name: UPPS_LANF_ERP42DV

Schedule Name: @879
Node Name: FCQ_SAP_WEEKLY
Scheduled Start: 30/08/13 09:20:16
Actual Start: 30/08/13 09:41:22
Completed: 30/08/13 09:41:22
Status: Failed
Result: 1
Reason: Failed
###################################################################

query schedule:
tsm: TSM_BLUE>q sched * @879 f=d


Policy Domain Name: UPPS_LANF_ERP42DV
Schedule Name: @879
Description:
Action: Command
Options:
Objects: /usr/tivoli/tsm/client/ba/bin/sap_weekly_FCQ.sh
Priority: 1
Start Date/Time: 30/08/13 09:20:16
Duration: 5 Day(s)
Schedule Style: Classic
Period: One Time
Day of Week: Any
Month:
Day of Month:
Week of Month:
Expiration:
Last Update by (administrator): RAHAMED
Last Update Date/Time: 30/08/13 09:20:16
Managing profile:




#####################################################################
 
Last edited:

LED888

ADSM.ORG Moderator
Joined
Oct 15, 2002
Messages
876
Reaction score
78
Points
0
Website
http
If you manually run the script and the backup work with out any issue.
Update the schedule service with the user id that you use to manually start the script.

Good Luck,
Sias
 

shaaha85

Active Newcomer
Joined
Nov 23, 2010
Messages
37
Reaction score
0
Points
0
Hi ,

I am running the scheduler service as root user only.Let me know if it need to be modified.

huxxxxx:# ps -ef|grep dsm
root 14680660 1 0 29 Aug - 0:03 /usr/bin/dsmc sched -optfile=/db2/FCQ/dbs/dsm_weekly.opt
 

smajl

ADSM.ORG Senior Member
Joined
Dec 10, 2009
Messages
174
Reaction score
22
Points
0
Location
Brno
Please pay more attention what are you scheduling :)
First off you are showing content of file /usr/local/bin/scripts/sap_weekly_FCQ.sh
Then you are showing that exectution of /usr/tivoli/tsm/client/ba/bin/sap_weekly_FCQ.sh failed immediately
 

shaaha85

Active Newcomer
Joined
Nov 23, 2010
Messages
37
Reaction score
0
Points
0
Hi,


I tried by placing the script in both directory.Typo error while pasting the output.


(i have corrected my post.Thanks:))


Still getting the same error.
 

smajl

ADSM.ORG Senior Member
Joined
Dec 10, 2009
Messages
174
Reaction score
22
Points
0
Location
Brno
Can you redirect standard+error output of command
su - db2fcq -c "/usr/tivoli/..........."
into some file to see whether the script is actually launched or not (and if some error appears)
 

shaaha85

Active Newcomer
Joined
Nov 23, 2010
Messages
37
Reaction score
0
Points
0
Hi guys,

The issue has been fixed by running backup through dsmcad.
the issue was with tsm scheduler service.The backup was failed when ran through tsm scheduler service (though the configuration was fine ).

But i couldnt understant why it was failed through scheduler service and successful by dsmcad?
Let me know if anybody have idea on this.
 

DazRaz

ADSM.ORG Senior Member
Joined
Jun 15, 2008
Messages
170
Reaction score
20
Points
0
Have had the same issue. I think you need a little more redirection when starting the scheduler service. Below the command for starting the scheduler which fixed the problem for me. It will be the </del/null bit you need.

Code:
nohup dsmc sched -optfile=/usr/tivoli/tsm/client/api/bin64/dsmnls.opt >/dev/null 2>&1 < /dev/null &
 

Advertise at ADSM.ORG

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

DigitalOcean $100 Credit

Support ADSM.ORG and get DigitalOcean FREE credit. DigitalOcean currently offer a $100, 60-day Free Credit for new accounts. Sign-up here:

DigitalOcean Referral Badge

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

    Votes: 65 60.7%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.1%
  • Other (please comement)

    Votes: 9 8.4%

Forum statistics

Threads
31,884
Messages
135,935
Members
21,784
Latest member
london
Top