TSM Scheduler Missed

[Efim]

The next step:
C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc.exe backup * full
Efim

 

[suleman]

Here is the output:

C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc.exe backup * full
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 5, Level 0.0
(C) Copyright IBM Corporation 1997, 2007. All rights reserved.
Connecting to SQL Server, please wait...

Starting SQL database backup...
Connecting to TSM Server as node 'BACKUPSQL'...
ACO5458W The TSM Server 'backup delete' setting for node (BACKUPSQL) is set to N
O. It should be set to YES for proper operation. Processing will continue.
Beginning full backup for database master, 1 of 5.
Full: 0 Read: 3230464 Written: 3230464 Rate: 2,646.60 Kb/Sec
Backup of master completed successfully.
Beginning full backup for database model, 2 of 5.
Full: 0 Read: 2181888 Written: 2181888 Rate: 1,914.42 Kb/Sec
Backup of model completed successfully.
Beginning full backup for database msdb, 3 of 5.
Full: 0 Read: 5328640 Written: 5328640 Rate: 7,022.60 Kb/Sec
Backup of msdb completed successfully.
Beginning full backup for database NetPerfMon, 4 of 5.
Full: 0 Read: 27418368 Written: 27418368 Rate: 23,992.61 Kb/Sec
Backup of NetPerfMon completed successfully.
Beginning full backup for database tsm_testdb, 5 of 5.
Full: 0 Read: 2078535424 Written: 2078535424 Rate: 48,200.51 Kb/Sec
Backup of tsm_testdb completed successfully.

Total SQL backups selected: 5
Total SQL backups attempted: 5
Total SQL backups completed: 5
Total SQL backups excluded: 0
Total SQL backups inactivated: 0
Throughput rate: 44,654.14 Kb/Sec
Total bytes transferred: 2,116,694,784
Elapsed processing time: 46.29 Secs

 

[Efim]

Hi
update node BACKUPSQL backupdel=yes
and try to run script again.
Efim

 

[suleman]

Is it: UPDATE NODE backupsql BACKDEL=YES ok

and now i have to run schedule again or ....???

 

[suleman]

Hi,

Run the script again and same result: Return code was 9009

 

[Efim]

I can't see anything else that can be wrong.
I just test my posted script again and it works.
So you can repeat running provided script manually again and check RC.
Efim

 

[suleman]

Here is the output of the Node:
->q node backupsql f=d
Node Name: BACKUPSQL
Platform: WinNT
Client OS Level: 5.02
Client Version: Version 6, release 2, level 4.0
Policy Domain Name: SQL_POLICY
Last Access Date/Time: 04/01/13 18:55:30
Days Since Last Access: <1
Password Set Date/Time: 03/22/13 15:14:27
Days Since Password Set: 10
Invalid Sign-on Count: 0
Locked?: No
Contact:
Compression: Client
Archive Delete Allowed?: Yes
Backup Delete Allowed?: Yes
Registration Date/Time: 03/22/13 15:14:27
Registering Administrator: ADMIN
Last Communication Method Used: Tcp/Ip
Bytes Received Last Session: 2,018.90 M
Bytes Sent Last Session: 14,601
Duration of Last Session: 46.48
Pct. Idle Wait Last Session: 7.95
Pct. Comm. Wait Last Session: 11.25
Pct. Media Wait Last Session: 0.00
Optionset:
URL: http://myclient.mycompany.com:1581
Node Type: Client
Password Expiration Period: 0 Day(s)
Keep Mount Point?: No
Maximum Mount Points Allowed: 1
Auto Filespace Rename : No
Validate Protocol: No
TCP/IP Name: BACKUP
TCP/IP Address: IP Address of Client Machine
Globally Unique ID: f3.cb.86.a1.92.d4.11.e2.ab.42.00.0c.29.17.9b.c0
Transaction Group Max: 0
Data Write Path: ANY
Data Read Path: ANY
Session Initiation: ClientOrServer
High-level Address:
Low-level Address:

 

[Efim]

Modify script and post output from screen


set sql_dir="C:\Program Files\Tivoli\TSM\TDPSql"
cd /d %sql_dir%
tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull.logs
set RC=%ERRORLEVEL%
echo Return code was %RC% >> %sql_dir%\sqlsched_full.log
pause
exit %RC%

 

[suleman]

Hi Efim,

Here is the output of modified script, please note that i replaced "/d" with "/c" in second line of the script as i don't have d drive.

OutPut:

C:\Documents and Settings\Administrator\Desktop>set sql_dir="C:\Program Files\Ti
voli\TSM\TDPSql"
C:\Documents and Settings\Administrator\Desktop>cd /c "C:\Program Files\Tivoli\T
SM\TDPSql"
The filename, directory name, or volume label syntax is incorrect.
C:\Documents and Settings\Administrator\Desktop>tdpsqlc backup * full /tsmoptfil
e="C:\Program Files\Tivoli\TSM\TDPSql"\dsm.opt /logfile="C:\Program Files\Tivoli
\TSM\TDPSql"\sqlfull.logs
'tdpsqlc' is not recognized as an internal or external command,
operable program or batch file.
C:\Documents and Settings\Administrator\Desktop>set RC=9009
C:\Documents and Settings\Administrator\Desktop>echo Return code was 9009 1>>"C
:\Program Files\Tivoli\TSM\TDPSql"\sqlsched_full.log
C:\Documents and Settings\Administrator\Desktop>pause
Press any key to continue . . .

 

[Efim]

Hi,
Don't touch /D !!!! => Use the /D switch to change current drive in addition to changing current directory for a drive.
Please correct script and run it again.
Efim

 

[suleman]

Ohhhhhh It's running successfully............

Thank you very very very much Efim, I'll never forget your such a timely and kind responses.

Now please guide me if any thing else i have to do?

 

[suleman]

Efim,

Wat's wrong with sqlfull.cmd script, can u identify?

 

[Efim]

Hi.

sqlfull.cmd: try to change cd %sql_dir% to cd /D %sql_dir%, comment @ECHO OFF and run in foreground for the testing.

You also need another 2 scripts:
- backup archive logs
- inactivate database (can be part of sqlfull script)

Efim

 

[suleman]

Hi Efim,

I have changed the sqlfull.cmd but same result as rc=1
One thing i have noticed is that when i place provided script at "c:\test.bat" path it works but if i place it at "c:\program files\tivoli\tsm\tdpsql\test.bat" path it fails and rc=1 throws. Moreover "sqlfull.cmd" not works at any path.

Also will you provide me the mentioned scripts and their purposes.

 

[Efim]

I correct understand that if you run manually script sqlfull.cmd it works from any places?
Efim

 

[suleman]

I'm not sure but it shows following in sqlsched.log file

The current date is: Tue 04/02/2013
Enter the new date: (mm-dd-yy) The current time is: 17:01:15.40
Enter the new time:

 

[Efim]

replace lines:
date < NUL >> %sql_dir%\sqlsched.log
time < NUL >> %sql_dir%\sqlsched.log
to
echo %date% %time% - Full SQL backup >> %sql_dir%\sqlsched.log
Efim

 

[suleman]

Thank You Efim, i also changed the path with tilt sign i-e "c:\Progra~1\Tivoli\TSM\TDPSql\sqlfull.cmd" and it runs successfully.

Now will you please provide me the "backup archive logs" and "inactivate database" scripts.

I shall be thankful to you.

 

[Efim]

Hi,
command for perform archive logs and inactivation:
tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlsched.log

and

tdpsqlc INACTIVate * * /OLDerthan=<DAYS> /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlinac.log >> %sql_dir%\sqlsched.log

Be careful when placing multiple commands in a single script. It is necessary to maintain RC after each command, and stop when a script error.
Therefore it is better for you to use 3 scripts and 3 TSM schedule.
Also, do not forget, as recommended in the documentation to put the metadata on disk.

P.S I forget to add option /OLDerthan=<DAYS>
Efim

 

[opermty]

Please share the procedure to implement the schedule ... maybe forgiven something

bests regards

I have a problem with scheduling the backup. I had scheduled the backup and associated the node, but when i given q event * * begind=+4(where the schedule should run) its not finding the schedule.

I had started the scheduler service from the client also.

My observation is the node is a TDP node, but in the TSM if i give q node it is showing as the platform is WinNT inseat of TDP node, any idea what is the prob ?