Re: SQL command to query Sessions with MediaWait or Idle

.254.8904 Internet richard.che...@santos.com Sent by: ADSM-L@VM.MARIST.EDU 12/04/2008 11:13 PM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject [ADSM-L] SQL command to query Sessions with MediaWait or Idle Hello all I am trying to figure out an effective way to get alerted if

Re: SQL command to query Sessions with MediaWait or Idle

>>select avg(wait_seconds) from sessions where state='MediaW'<< Is there a join that would give an average per library or devclass or domain? David

Re: SQL command to query Sessions with MediaWait or Idle

Hi, the sql query I'd use would be something along the lines of: select count(*) from sessions where state='MediaW' and WAIT_SECONDS>1800 (no spaces round the > to avoid output redirection). Now, if you use a dsmadmc -tab -dataonly=y you'll get a nice piece of output that you can use to determ

Re: SQL command to query Sessions with MediaWait or Idle

Try select * from sessions and see if that gives you what you need Steven Harris Tivoli Storage Manager SME Backup & Recovery Team Storage Services Group Cumberland Forest Phone: IBM Internal :70-75130 External:02 9407 5130 Mobile: 0422 932 065

SQL command to query Sessions with MediaWait or Idle

Hello all I am trying to figure out an effective way to get alerted if a backup job is idle or not proceeding due to a MediaWait state. I want it to have the smarts to maybe only alert me if it finds the same successive node has been in the same MediaWait state for a predetermined period (eg

Re: SQL command

ew Raibeck <[EMAIL PROTECTED]> > To: ADSM-L@VM.MARIST.EDU > Sent: Friday, April 4, 2008 3:19:52 PM > Subject: Re: SQL command > > Try this: > > (datetime1 - datetime2)hours > > For example: > > select lastacc_time, \ >reg_time, \ >

Re: SQL command

Andrew, Is there an option to get this result in HH:MM format? Thank you. Mario - Original Message From: Andrew Raibeck <[EMAIL PROTECTED]> To: ADSM-L@VM.MARIST.EDU Sent: Friday, April 4, 2008 3:19:52 PM Subject: Re: SQL command Try this: (datetime1 - datetime2)hours For e

Re: SQL command

unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2008-04-04 10:39:39: > Hi list, > > Which SQL command or function returns the difference, in hours, from > two date-time fields when issued against

SQL command

Hi list, Which SQL command or function returns the difference, in hours, from two date-time fields when issued against the TSM database? I need to issue this command or function inside a SELECT statement. I´ve tried some functions from DB2 and SQL Server (like datediff) but it does not work

Re: JR-Can I type in a SQL command that will show what has been archived

friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2005-03-08 10:09:47: > Is there a specific reason why you need an SQL command? If you just want > to know who has any archived data, QUERY OCCUPANCY will show it to you. > Add the TY

Re: JR-Can I type in a SQL command that will show what has been archived

Is there a specific reason why you need an SQL command? If you just want to know who has any archived data, QUERY OCCUPANCY will show it to you. Add the TYPE=ARCHIVE option to limit the output strictly to archive occupancy info. Use HELP QUERY OCCUPANCY for further info on this command. There is

JR-Can I type in a SQL command that will show what has been archived

We are currently not using the archive feature of TSM. I would like to know if I can run a SQL command that will tell me if anyone has archived files/directories. In addition, how can I disable the archive feature from running? Thanks in advance.

Re: SQL command insteda of QUERY EVENT?

cc: Sent by: "ADSM: Dist Stor Subject: SQL command insteda of QUERY Manager" <[EMAIL P

SQL command insteda of QUERY EVENT?

Hello Can I run "select something from actlog" command instead of "q event * * ..." Where are the events saved? The actlog table? Regards Niklas Lundström Swedbank

Re: SQL command

by filespace and even then it will take a while. Let me know what you are trying to do and I will try to answer the question. -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 3:40 PM To: [EMAIL PROTECTED] Subject: SQL command

Re: SQL command

ver. Good luck. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 2:40 PM To: [EMAIL PROTECTED] Subject: SQL command Looking for an SQL comm

Re: SQL command

--- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 2:44 PM To: [EMAIL PROTECTED] Subject: Re: SQL command Do you mean by domain? Nodes don't have management classes, files do -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PRO

Re: SQL command

10_DAY_RETENTION 30_DAY_RETENTION 5_DAY_RETENTION 60_DAY_RETENTION 90_DAY_RETENTION etc... -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 2:40 PM To: [EMAIL PROTECTED] Subject: SQL command Looking for an SQL command that will

Re: SQL command

Do you mean by domain? Nodes don't have management classes, files do -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 3:40 PM To: [EMAIL PROTECTED] Subject: SQL command Looking for an SQL command that will show me

SQL command

Looking for an SQL command that will show me nodes by management class. Can anyone help? Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018 Page: 888-637-7450 E-mail: [EMAIL PROTECTED]