Antwort: Error ANR1134W

2003-10-09 Thread Schmitz Garnebode
Hi, the device type is not correct. Have you define the devclass correct ?? It's must be DLT and not Generic. But look first in the TSM Management Console if the TSM-Driver is loaded and identifiy the drives correct regards Michael Garnebode Diplom-Informatiker Systemberater Schmitz RZ

Re: Point in time restore vs Archiving

2003-10-09 Thread Henrik Wahlstedt
Hello Arnaud, *SM will treat the backup as 'full' for 35 days. If you change copymode from modified to absolute wont make a difference. But the amount of backup data will increase with absolute.. If I´m wrong, please correct me. //Henrik

Re: Point in time restore vs Archiving

2003-10-09 Thread John Naylor
Henrik, You are correct . Point in time restore will enable recovery to the same state as if you had taken a full backup on that particular day. This is the way TSM was designed to work. Using absolute mode would have significant impact both on your media use and the size of your database. John

AW: Encryption for API clients

2003-10-09 Thread Schaub Joachim Paul ABX-SECE-ZH
the encryption is DES56bit (hackable in 12 hours with freeware) and runs not on the API. SQL BackTrack sends only blocks? what should a highjacker do with this? -Ursprüngliche Nachricht- Von: Thomas Denier [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 8. Oktober 2003 18:18 An: [EMAIL

Backup definition

2003-10-09 Thread Bernd Schemmer
I want to implement the following backup definitions: Create a fullbackup every 1st day of each month Create an incremental backup every further day of the month The fullbackup should be stored for 12 month; the incremental backups only until the next fullbackup is done. The fullbackups and

Re: Backup definition

2003-10-09 Thread Henrik Wahlstedt
Hi, Use 2 nodenames (node and node-monthly) associated with 2 different schedules in same domain but with 2 different mgmtclasses. Ex. Daily-incr: vere nolimit, verd nolimit, rete 35, reto 35. Use rete=365 and reto=365 in monthly mgmtclass. Define 2 schedules, Daily-incr action=incr and Monthly

Re: Using the EXPORT command

2003-10-09 Thread Ken Sedlacek
Thanks for the tip. I will give it a try. Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] Agilysys, Inc. (formerly Kyrus Corp.) IBM eServer Certified Specialist: pSeries AIX v5 Support IBM Certified Specialist: RS/6000 SP PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager

Hyper-threaded CPU's

2003-10-09 Thread Brian L. Nick
Good morning, Running a TSM 5.x server with the new licensing scheme how does TSM report on hyper-threaded CPU's? We have several of them and are in the process of moving to 5.2 and want to make sure that we are only counting physical CPU's. Anyone have any insight on this. Thanks,

Anyone using ACSLS/L5500/LTO gen 2 drives?

2003-10-09 Thread Jolliff, Dale
Anyone using LTO Gen 2 in an STK L5500 with ACSLS? If you are what versions of TSM and ACSLS are you using? Are you sharing the library with anything else? Any big gotchas to be aware of? We have an L5500 dedicated to Veritas NetBackup Datacenter 4.5 fp5 using ACSLS version 6.1.1 with LTO Gen 2

Re: Point in time restore vs Archiving

2003-10-09 Thread PAC Brion Arnaud
Henrik, You're absolutely right, from a TSM perspective you'll have a virtual full backup, but my understanding of Mr Hansson question was that he really wanted to perform full backups everyday : I need to do FULL backups days a week for 4 weeks Probably an misinterpretation from my side ;-)

Re: Backup definition

2003-10-09 Thread Stapleton, Mark
From: Bernd Schemmer [mailto:[EMAIL PROTECTED] I want to implement the following backup definitions: Create a fullbackup every 1st day of each month Create an incremental backup every further day of the month The fullbackup should be stored for 12 month; the incremental backups only until the

Re: Error ANR1134W

2003-10-09 Thread Stapleton, Mark
From: Robert Ouzen [mailto:[EMAIL PROTECTED] Any Ideas what can be the problem ... My TSM server is a NT 4 server, Tsm version 5.1.5.0 Another suggestion: get off 5.1.5.0. Base-level code can have their share of bugs. Update to the latest version--at least 5.1.7.0. -- Mark Stapleton

Re: New TSM Flash #10251

2003-10-09 Thread Zoltan Forray/AC/VCU
Based on the sentence: Based on IBM support for AIX 4.x Operating systems being withdrawn December 2003 ITSM V5R2 is not supported on AIX 4.x Operating Systems. does this mean that it also won't INSTALL/RUN on AIX 4.3.3 ? or can we install/run TSM 5.2 on AIX 4.3.3 and it just isn't SUPPORTED

Re: Hyper-threaded CPU's

2003-10-09 Thread David McClelland
I don't know the answer to this, but as a side-note, there are big differences between how Windows 2000 and Windows 2003 handle HyperThreading: as a result, Windows 2000 boxes with HyperThreading enabled (toggled in the BIOS usually) can suffer performance hits in some circumstances. It stems, so

Re: Backup definition

2003-10-09 Thread Bernd Schemmer
Hendrik, thanks for the answer. One final question: If I use 2 different node names will the incremental backup Use the full backup or not? In other words: Will TSM store a file that is already backed up in the full backup a second time when the incremental backup runs? Bernd Henrik Wahlstedt

Re: Backup definition

2003-10-09 Thread Henrik Wahlstedt
Oops I can agree with you, Regular backups were never meant to act for long-term storage. Archive sound better but I didnt consider that two different management classes would confuse.. How do you manage first day of the month?? //Henrik Stapleton,

Re: Backup definition

2003-10-09 Thread Henrik Wahlstedt
Hi, The answer is yes. But also consider Marks answer, Archive or Backupsets. //Henrik Bernd Schemmer To: [EMAIL PROTECTED] Bernd.Schemmcc: (bcc: Henrik Wahlstedt) [EMAIL PROTECTED]

supress the more prompt in dsmadmc

2003-10-09 Thread Bernd Schemmer
How can I suppress the more prompt more... (ENTER to continue, 'C' to cancel) in dsmadmc. What I want (if possible) is to interactive turn it off and on as needed. I did not find infos about this in the docs or in the FAQ I'm using the version 5.2 of the TSM Client (and the TSM Server

DB Mirroring Help Urgently needed - [was Re: how to disable TSM d b mirroring?]

2003-10-09 Thread Ward, Stuart
Thanks for your suggestions. If there is anyone else that may have seen this problem or any TSM engineers that may be able to help out I would very much appreciate it. Currently, I am stumped too... Stu -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED] Sent: Tuesday,

Exists a fix to point in time error ?

2003-10-09 Thread Juan Manuel Lopez Azañon
Hi all. I have got several windows NT and Windows 2000 clients running 4.1, 4.2 and 5.1 and my TSM server is 4.2.2.13 over HPUX 11.0. Some of those windows clients works fine using a point in time restore and some of then does not show all the folders save it on tsm server database. If IBM know

Re: New TSM Flash #10251

2003-10-09 Thread Dave Canan
This sentence means that it will NOT INSTALL. (it won't be supported either). :) At 08:54 AM 10/9/2003 -0400, you wrote: Based on the sentence: Based on IBM support for AIX 4.x Operating systems being withdrawn December 2003 ITSM V5R2 is not supported on AIX 4.x Operating Systems. does this

Backup via LAN

2003-10-09 Thread Juan Jose Reale
Hi to all Do you know if it is possibility to perform a backup via LAN in AIX without the available rmtX ? After I ran cfgmgr -v, I ran lsdev -Cc tape but they didn't show up the list of available rmtX. Is it not problem for backup via LAN? I am using 4 drives 3584

Re: DB Mirroring Help Urgently needed - [was Re: how to disable TSM db mirroring?]

2003-10-09 Thread Stapleton, Mark
From: Ward, Stuart [mailto:[EMAIL PROTECTED] Volume Name CopyVolume Name CopyVolume Name Copy (Copy 1) Status (Copy 2) Status (Copy 3) Status -- -- -- F:\ADSM_SERVER\- Off-L-

Netware issue: Can't write files during restore...

2003-10-09 Thread Cahill, Ricky
Try restoring the dir's then the files..we had this during DR and found the only way we could ever restore succesfully was by doing the dir structure first. -Original Message- From: Justin Derrick [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 20:52 To: [EMAIL PROTECTED] Subject: Netware

Re: SQL script for total traffic

2003-10-09 Thread Gable, Josh
I'll check it out and see what I can come up with. Thanks for all the responses. Josh -Original Message- From: Talafous, John G. [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:39 PM To: [EMAIL PROTECTED] Subject: Re: SQL script for total traffic select

Re: DB Mirroring Help Urgently needed - [was Re: how to disable T SM db mirroring?]

2003-10-09 Thread Ward, Stuart
With respect, that is not really my issue - although the v3.1 manual does say to do so for DB and Log volumes in addition to the other types you rightly specify. I am having trouble bringing the sync'd mirror status back up as the 'F' volume is not coming back online. Seems whatever I try, ADSM

Re: Backup via LAN

2003-10-09 Thread Hooft, Jeroen
As long as your TSM-server can see the drives, it should be fine. client doesn't need to see the drives with LAN backups. -Original Message- From: Juan Jose Reale [mailto:[EMAIL PROTECTED] Sent: donderdag 9 oktober 2003 16:06 To: [EMAIL PROTECTED] Subject: Backup via LAN Hi to all

Could those files securely be excluded ?

2003-10-09 Thread PAC Brion Arnaud
Hi list, Everything is in the tittle : I'm trying to find out if those files, regularily reported as missed during backups, could be excluded in a client option set that would be used for all of our windows systems. No idea what those files are made for, and if excluding them would be

TDP for Domino 5.1.5 on Win2003

2003-10-09 Thread Scott, Brian
Mornin' TSM'ers, I just checked the Tivoli website to find out if TDP for Domino 5.1.5 is supported/certified on Win 2003 and it doesn't say. We are looking to go to Lotus Domino R6 on the Win2003 platform using the latest TDP for Domino and TSM Backup Archive 5.2. Can I use TDP for Domino 5.1.5

Re: supress the more prompt in dsmadmc

2003-10-09 Thread Prather, Wanda
dsmadmc has two modes, interactive and batch. You are running interactive, you will get the more prompt. If you run it in batch, you will not get the more prompt. To run in batch, start from a DOS prompt: dsmadmc -id=youradminid -password=youradminpwd the command you want TSM to execute You

Re: dsmsrvc.exe RAM usage

2003-10-09 Thread William Rosette
Does anyone know why dsmsrvc.exe on the Win2000 boxes uses high RAM usage? Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD

Re: dsmsrvc.exe RAM usage

2003-10-09 Thread Remeta, Mark
I think that is the actual TSM Server service. -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:45 AM To: [EMAIL PROTECTED] Subject: Re: dsmsrvc.exe RAM usage Does anyone know why dsmsrvc.exe on the Win2000 boxes uses high RAM

Lanfree and db2 userexit

2003-10-09 Thread Shawn Price
I have a question regarding Lan_free and db2 user exits. We are currently running in an AIX environment (AIX 5.1 and a 5.1.7.1 TSM server and AIX 4.33 on the clients) with SAP on DB2. Last week we implemented lan-free backups on one of our production servers and had great results with backup

licensing (again... :( )

2003-10-09 Thread Remco Post
Hi all, since IBM now diffentiates it's TSM licensing fee based on the worksation of server role a system has in the company, I assume that IBM has some definition of what that it thinks a server or a workstation is. Unfortunately, I have been unable to find this definition on the IBM website.

TSM Client 5.2 is compatible with TSM Server 4.2 ?

2003-10-09 Thread Juan Jose Reale
Hi everyone! I will install the TSM Client 5.2 in AIX 5.1 System Operative, so I am unsure about the compatible between TSM Client 5.2 and TSM Server 4.2.2.7. This means: can TSM Client 5.2 work with TSM Server 4.2.2.7 ? Now I am running TSM server 4.2.2.7 in other

Re: dsmcsvc.exe RAM usage

2003-10-09 Thread William Rosette
I stand corrected it is not dsmsrvc.exe but dsmcsvc.exe, This is on both clients Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD Remeta, Mark [EMAIL PROTECTED]To: [EMAIL PROTECTED] DATA.COM

Re: dsmcsvc.exe RAM usage

2003-10-09 Thread Remeta, Mark
Ok that's the scheduler service that runs on the client, not the server service that runs on the server. -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:24 AM To: [EMAIL PROTECTED] Subject: Re: dsmcsvc.exe RAM usage I stand

Re: TDP for Domino 5.1.5 on Win2003

2003-10-09 Thread Del Hoobler
Brian, Data Protection for Domino does not yet officially support Windows 2003 yet. As you know, Lotus is just now adding their official support for Windows 2003. The Data Protection for Domino test team is in the process of testing this configuration. If I recall correctly, Lotus is adding

Re: dsmcsvc.exe RAM usage

2003-10-09 Thread William Rosette
OK, then how do I make the scheduler service use less RAM? Thank You, Bill Rosette Data Center/IS/Papa Johns International WWJD Remeta, Mark [EMAIL PROTECTED]To: [EMAIL PROTECTED] DATA.COMcc:

Mkcd-AIX help

2003-10-09 Thread PINNI, BALANAND (SBCSI)
All- Please excuse me for asking aix issue .But I think this was pressing issue for me right now. I use mkcd to backup AIX os to DVD . My question is what is equivalent to /etc/exclude.rootvg for mkcd compared to mksysb. I want to exclude file system (application) from backing up on DVD. Thanks

Re: dsmcsvc.exe RAM usage

2003-10-09 Thread Remeta, Mark
What version client are you running and how much ram is it using? Mark -Original Message- From: William Rosette [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: Re: dsmcsvc.exe RAM usage OK, then how do I make the scheduler service use

Re: dsmcsvc.exe RAM usage

2003-10-09 Thread Bill Boyer
Use the managedservices option, then the scheduler service is only running when there is something to do. While it's running use the memoryeffecient option. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of William Rosette Sent:

Re: DB Mirroring Help Urgently needed - [was Re: how to disable T SM db mirroring?]

2003-10-09 Thread Andrew Raibeck
- Can you show the output from a DIR command of the phantom volume file? - Can you show the output from the DELETE DBVOLUME command? - Can you show the output from QUERY DBVOLUME F=D? About the only other thing I can suggest is to create a new database volume and mirror that are the same size

TSM Operational Reporting

2003-10-09 Thread Michael, Monte
Where can I download or get a copy of the TSM Operational Reporting software, and some documentation on installation? As always, your help is appreaciated. Monte This communication is for use by the intended recipient and contains information that may be privileged, confidential or

Re: DB Mirroring Help Urgently needed - [was Re: how to disable T SM db mirroring?]

2003-10-09 Thread Ward, Stuart
Please see remarks below. -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 12:04 PM To: [EMAIL PROTECTED] Subject: Re: DB Mirroring Help Urgently needed - [was Re: how to disable T SM db mirroring?] - Can you show the output from a DIR

Re: dsmcsvc.exe RAM usage

2003-10-09 Thread Andrew Raibeck
Due to possible performance concerns, I would not recommend MEMORYEFFICIENT YES unless there is truly a compelling reason to do so. The real questions (to me) are: - What client version is this? Hopefully very current; back in the 5.1-ish timeframe, we did fix a longstanding bug involving a

Re: Mkcd-AIX help

2003-10-09 Thread Dan Foster
Hot Diggety! PINNI, BALANAND (SBCSI) was rumored to have written: Please excuse me for asking aix issue .But I think this was pressing issue for me right now. I use mkcd to backup AIX os to DVD . My question is what is equivalent to /etc/exclude.rootvg for mkcd compared to mksysb. I want to

Re: DB Mirroring Help Urgently needed - [was Re: how to disable T SM db mirroring?]

2003-10-09 Thread Karel Bos
Maybe a silly question. You said that you had a drive failure and have a new drive and volume in place. TSM is complaining about that volume not being defined as a db volume. How did you recreate the volume? Regard, Karel -Oorspronkelijk bericht- Van: Ward, Stuart [mailto:[EMAIL

Re: supress the more prompt in dsmadmc

2003-10-09 Thread Bleicher, Thomas
Prather, Wanda wrote: dsmadmc has two modes, interactive and batch. You are running interactive, you will get the more prompt. If you run it in batch, you will not get the more prompt. I still geht the prompt, even when I execute commands in batch mode. But redirecting the output to a

TSM Operational Reporting

2003-10-09 Thread Michael, Monte
Where can I download or get a copy of the TSM Operational Reporting software, and some documentation on installation? As always, your help is appreaciated. Monte This communication is for use by the intended recipient and contains information that may be privileged, confidential or

Re: licensing (again... :( )

2003-10-09 Thread Stapleton, Mark
From: Remco Post [mailto:[EMAIL PROTECTED] since IBM now diffentiates it's TSM licensing fee based on the worksation of server role a system has in the company, I assume that IBM has some definition of what that it thinks a server or a workstation is. Is this true? The last I heard, licensing is

Re: Mkcd-AIX help

2003-10-09 Thread PINNI, BALANAND (SBCSI)
Dan Please reply to the point. -Original Message- From: Dan Foster [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:30 AM To: ADSM: Dist Stor Manager Subject: Re: Mkcd-AIX help Hot Diggety! PINNI, BALANAND (SBCSI) was rumored to have written: Please excuse me for asking

Re: licensing (again... :( )

2003-10-09 Thread Prather, Wanda
No. That is badly explained everywhere. Took us 3 tries to get quotes for our maint renewal (1st quote was more than double what it should have been) because EVERYONE is confused. First, a TSM client is either a server client or a workstation client depending on how it is used in YOUR

Re: TSM Operational Reporting

2003-10-09 Thread Bill Boyer
ftp://ftp.software.ibm.com/storage/tivoli-storage-management/techprev/tsmopr eport/latest/ And what documentation there is...The PDF file is empty. The most documentation is the PowerPoint presentation. Bill Boyer -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL

Re: licensing (again... :( )

2003-10-09 Thread Coats, Jack
Now we have some Intel Xenon processors, for each single physical processor, it shows 2 processors when using the M$ perfmonitor. How many processors do I report? (we have several machines with 2 processors, but it looks like 4 processors to perfmon) I havn't been able to get a satisfactory

Re: TDPSQL Restore Problem

2003-10-09 Thread Chris Leonard
Kris: You are on the right track. A differential backup in SQL can only be applied against the last full that was taken before the differential. It sounds like you're trying to apply a differential that was created after the non-TDP backup to the full that was created through TDP. This cannot

Re: licensing (again... :( )

2003-10-09 Thread Murray, Jim
That's the real vs virtual processors Wanda was talking about, you have only 2 processors for licensing. The extras are virtual and only matter to applications that can use them like Micro$oft SQL2000. Jim Murray Senior Systems Engineer Liberty Bank 860.638.2919 [EMAIL PROTECTED] ~~ _/)

Re: licensing (again... :( )

2003-10-09 Thread Prather, Wanda
Seems logical to me that you would only report the real ones, but I've never seen that in writing... -Original Message- From: Coats, Jack [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:02 PM To: [EMAIL PROTECTED] Subject: Re: licensing (again... :( ) Now we have some Intel

tape errors after 3590H upgrade - K tape - 3592s

2003-10-09 Thread Jason Lee
Hi, A couple of months ago we upgraded our 3590E drives to H. Marked everything as readonly.. moved all the data to new (scratch) tape so as not to mix formats on the tape. etc etc etc Now I'm noticing a high number of media errors. I'm assuming that some of the old tape is not up to supporting

TSM Backup client Mac osX

2003-10-09 Thread Bruno Dostie
TSM Backup client Mac osX root passwd asked at client startup. how to bypass? I have installed TSM Backup client version 5.2.0.0 on a Macintosh osX v 10.2.5 to install the client the root password have been supplied. now, each time I start TSM client the root passwd have to be provided to have

Re: licensing (again... :( )

2003-10-09 Thread Levinson, Donald A.
and of course each of these parts has a different number and price depending on whether this is a TSM Standard or TSM Extended edition install. All clients (servers) to a TSM Extended server cost quite a bit more. -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED] Sent:

Re: Hyper-threaded CPU's

2003-10-09 Thread David E Ehresman
Running a TSM 5.x server with the new licensing scheme how does TSM report on hyper-threaded CPU's? Unless something changed from 5.1 to 5.2, TSM does NOT report on cpus on any kind. It counts nodes. For your new licensing scheme cpu count, you have to count them yourself with some process

DB Mirroring Help Urgently needed - [was Re: how to disable TSM d bmirroring?]

2003-10-09 Thread David E Ehresman
any TSM engineers that may be able to help out I would very much appreciate it. Currently, I am stumped too.. Sounds like your overdue for a call to TSM support.

Re: dsmsrvc.exe RAM usage

2003-10-09 Thread Tab Trepagnier
Bill, We use the TSM client service on several large Windows file servers. The primary factor that I know of that affects client memory usage is the size of the client aggregates. In other words, if you have TXNBYTELIMIT set very high, the TSM client must hold the files in memory while it

Re: licensing (again... :( )

2003-10-09 Thread Remco Post
On Thursday, Oct 9, 2003, at 19:27 Europe/Amsterdam, Prather, Wanda wrote: If the machine provides SERVICES to other machines, it is a server. If it is used standalone, it is a workstation/desktop. Now I have an intresting question. What would a sunray server be? In some way it is used it is a

Administrative tools for Unix or Linux servers

2003-10-09 Thread Thomas Denier
We currently have a TSM server running under OS/390. We use the CA-7 batch job scheduler to manage most of the sequencing of housekeeping tasks. For example, there are two batch jobs that run two streams of 'backup stgpool' operations. When both jobs finish CA-7 starts a third job that performs a

Re: licensing (again... :( )

2003-10-09 Thread Thomas Denier
If the machine provides SERVICES to other machines, it is a server. If it is used standalone, it is a workstation/desktop. If it is a 12-processor high-end machine used as a standalone research box, it's still a workstation. If it is a 1-processor 130mhz machine used as a print server or

Re: licensing (again... :( )

2003-10-09 Thread Remco Post
On Thursday, Oct 9, 2003, at 22:47 Europe/Amsterdam, Thomas Denier wrote: If the machine provides SERVICES to other machines, it is a server. If it is used standalone, it is a workstation/desktop. If it is a 12-processor high-end machine used as a standalone research box, it's still a workstation.

Re: TSM Backup client Mac osX

2003-10-09 Thread Luke Dahl
There's no fix - I believe it's been officially requested though. Even worse is the requirement to have a user logged in for scheduled backups to run, how ridiculous. Luke Bruno Dostie wrote: TSM Backup client Mac osX root passwd asked at client startup. how to bypass? I have installed TSM

Re: TSM Backup client Mac osX

2003-10-09 Thread Remco Post
On Friday, Oct 10, 2003, at 00:14 Europe/Amsterdam, Luke Dahl wrote: There's no fix - I believe it's been officially requested though. Even worse is the requirement to have a user logged in for scheduled backups to run, how ridiculous. The last bit is being fixed by IBM, so I heard people

'Maximum Scratch Volumes Allowed' clarrification

2003-10-09 Thread Gordon Woodward
Hi all, I'm after some clarrification about the stgp maxscratch setting for one of our storage pools. We recently decommissioned a server and removed all it's data out of TSM, thus freeing up a lot of tapes for other uses, but I'm now finding that our collocated storage pool has decided to

Re: SQL script for total traffic

2003-10-09 Thread Hector Chan
Try this: SELECT ENTITY AS NODE_NAME, ACTIVITY, BYTES AS BYTES_TRANSFERRED, - START_TIME, END_TIME, IDLE AS IDLE_IN_SEC, MEDIAW AS MEDDIA_WAIT_IN_SEC, - PROCESSES, AFFECTED AS FILES_BACKUP, FAILED, EXAMINED AS ALL - FROM SUMMARY - WHERE START_TIMETIMESTAMP(CURRENT