Actually the LASTSESS_SENT field is for data sent for *any* TSM client
operation, not just for the last backup. So if between the time the backup
finished and the SELECT statement is run, the user performs some other
operation... even something like DSMC QUERY SESSION... then the
LASTSESS_SENT field will reflect data from that operation, not the last
backup. Thus I would not recommend using this, as it is not entirely
reliable for this purpose.
For example:
DSMC INCREMENTAL
LASTSESS_SENT reflects data sent during incremental backup
DSMC SELECTIVE C:\MYFILE.TXT
LASTSESS_SENT reflects data sent during backup of c:\myfile.txt
DSMC QUERY SESSION
LASTSESS_SENT reflects data sent (very small amount) for QUERY SESSION
SELECT NODE_NAME, LASTSESS_SENT FROM NODES
Output reflects value from the above QUERY SESSION command.
As this sequence shows, you could get misleading information using this
method.
Regards,
Andy
Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client Development
e-mail: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."
"Anderson, Chris D." <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 04/06/2001
09:48:38 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: Amount of Data Backed Up Each Night
Run this query command and it will give you the node name and how much data
that node sent from it's last backup.
select NODE_NAME,LASTSESS_SENT from nodes
Chris Anderson
WIC Systems Administrator
[EMAIL PROTECTED]
> -----Original Message-----
> From: Kelly J. Lipp [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 11:09 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Amount of Data Backed Up Each Night
>
> The schedule log file has this in it so you can do an incremental from
the
> schedule rather than running a script to get the same information. This
> info is also kept in the server activity log and is available via select
> statements (I believe) from the node table. One of our SQL gurus should
> leap in at this point and show us how.
>
> Kelly J. Lipp
> Storage Solutions Specialists, Inc.
> PO Box 51313
> Colorado Springs CO 80949-1313
> (719) 531-5926
> Fax: (240) 539-7175
> Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
> www.storsol.com
> www.storserver.com
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Poehlman, James
> Sent: Friday, April 06, 2001 9:51 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Amount of Data Backed Up Each Night
>
>
> My backups run a script on the client that executes the ''dsmc inc''
> command
> for each file system to be backed up. The output is redirected into a
log
> file for each filesystem. Add up all the ''bytes transferred'' in the
> log files.
>
>
> -----Original Message-----
> From: Dearman, Richard [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 11:09 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Amount of Data Backed Up Each Night
>
>
> I am new to the ADSM or TSM world. How do you guys find out how mcuh
data
> you are backing up per night. Is there a command line in ADSM to show
you
> this.
>
> -----Original Message-----
> From: Sean McNamara [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 1:14 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Amount of Data Backed Up Each Night
>
>
> Dwight,
>
> Just curious - how big are your disk storage pools and what tape
> robot
> are you using ?
>
> Sean McNamara
> Senior Analyst
> PJM Interconnection, L.L.C.
> 955 Jefferson Ave
> Norristown, PA 19403
> (610)666-4206
> (610)666-4285 (fax)
>
>
> -----Original Message-----
> From: Cook, Dwight E [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 1:59 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Amount of Data Backed Up Each Night
>
>
> biggest single box is a 2.4 TB db that compresses down to 600 GB backes
up
> every other day/night
> have tons of others that are 500-ish GB's that compress down to 100-200
GB
> and back up nightly
> across all the tsm servers we do 1.5 TB nightly
>
> DWight
>
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Diana J.Cline [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 12:40 PM
> To: [EMAIL PROTECTED]
> Subject: Amount of Data Backed Up Each Night
>
>
> Is there anyone else out there who is backing up 300gb per night or more?
> If so, i'd love to converse with you.
> ***************************EMAIL DISCLAIMER**************************
> This e-mail and any files transmitted with it may be confidential and are
> intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient or the individual
> responsible for delivering the e-mail to the intended recipient, any
> disclosure, copying, distribution or any action taken or omitted to be
> taken
> in reliance on it, is strictly prohibited. If you have received this
> e-mail
> in error, please delete it and notify the sender or contact Health
> Information Management (312) 996-3941.
