SAP backup is failing when it running through tsm scheduler service

[shaaha85]

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:




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

 

[LED888]

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]

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]

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]

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]

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]

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]

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.

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