• 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
#1
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
#2
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
#3
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
#4
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
#5
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
#6
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
#7
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
#8
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.

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,468
Messages
134,124
Members
21,569
Latest member
srinathkodela
Top