THREE PART QUESTION for "select gurus" ;-) 1. Can someone tell me what the timespan for this summary is based on the: start_time>timestamp(current date - 1 day,'18:00:00')
Does this mean for the last 18 hours? 2. Also, is there a way to sum the various sessions for a single node? Some of my servers, which have Informix databases, back up logical logs all day long and there are dozens of entries per server such as: AFCTEST 10252976 AFCTEST 10252976 AFCTEST 10252976 AFCTEST 10252976 AFCTEST 10252976 AFCTEST 10252976 (((plus a zillion more of these entries))) 3. and is there a way to place BACKUPS and ARCHIVES into this select statement and have separate columns for both backups and archives associated with a node on a row? Such as: NODE_NAME BYTES_XFRD(BACKUP) BYTES_XFRD(ARCHIVE) ------------------ -------------------- -------------------- AFCPROD1 1234567890 1234567890 Thanks - George Lesho Storage/System Admin AFC Enterprises Joe Cascanette <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 10/30/2001 08:28:27 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: George Lesho/Partners/AFC) Fax to: Subject: Re: script: transferred bytes per node/day ???? select ENTITY as Node_Name, BYTES as Bytes_Transferred from summary where activity='BACKUP' and start_time>timestamp(current date - 1 day, '18:00:00')and bytes>0 This was posted by another user, just added some fields. Joe Cascanette The Cumis Group Limited -----Original Message----- From: Winfried Heilmann [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 8:50 AM To: [EMAIL PROTECTED] Subject: script: transferred bytes per node/day ???? Hi I'm looking for a script to calculate the transferred bytes for each node per node and a total for the day. Can anybody help me? Regards Winfried
