Richard,
This is what I made to let me know what session is holding up what process
because it's waiting for media.. Maybe this is what you are looking for?
select sessions.SESSION_ID, sessions.CLIENT_NAME,
sessions.OUTPUT_VOL_ACCESS,processes.process_num as
"PROCESS_NUM",processes.process, TRIM
>>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
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
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
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, \
>
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
Try this:
(datetime1 - datetime2)hours
For example:
select lastacc_time, \
reg_time, \
(lastacc_time - reg_time)hours as "HOURS" \
from nodes
LASTACC_TIME REG_TIME HOURS
-- -- --
2008-04-03
select schedname,message from actlog where schedname='yourschedulename'
select schedule_name,status from events
However , q event is better command to check schedule status
Regards
Raghu S Nivas
Consultant - TSM
DCM Data Systems Ltd
New Delhi
India.
e-mail: [EMAIL PROTECTED],[EMAIL PROTECTED]
Joe,
If you are talking about the default management class of a policy domain
this is a reasonable SQL statement, but if you are trying to figure out what
management classes are being used by a client that requires an entire scan
of the backups table which would take forever unless you limit it by
This actually isn't a very easy question to answer, and I'm not sure how
useful this data would be. Files from a single node can be bound to
multiple management classes, so you would have to check each file. If you
really want to let your TSM database grind away for a while, you can try
this, bu
---
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
from the command
select * from syscat.tables
you can find a table called:
TABSCHEMA: ADSM
TABNAME: MGMTCLASSES
CREATE_TIME: 1996-04-25 14:31:19.025065
COLCOUNT: 12
INDEX_COLCOUNT: 3
UNIQUE_INDEX: TRUE
REMARKS: Management classes
then you can do:
tsm: ADSM>select * fro
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 nodes by
13 matches
Mail list logo
