hi, maybe you will have something usefull on this script:
select severity,count(*) as "TOTAAL" from actlog where severity in
('E','W') AND cast((current_timestamp-date_time)hours as decimal (8,0)) <24
group by severity select date(date_time) as "DATUM" , time(date_time) as
"TIJD" , message as "MESSAGE" FROM actlog WHERE severity = 'E' AND msgno
NOT in
(0944,1455,1463,1464,1469,2000,2020,2022,2034,2165,2166,2305,2904,2905,2906,2908,2909,2911,2916,2938,2940)
AND cast((current_timestamp-date_time)hours as decimal (8,0)) <24
or
select nodename,message from actlog where (msgno=4961 or msgno=4964)AND
nodename='$1' AND cast((current_timestamp-date_time)hours as decimal (8,0))
<24 order by nodename
Look in the messages guide 5.1 Messages GC32-0767-00.pdf for other
messagenumbers you would like to see.
At 10:13 21-05-2002 -0700, you wrote:
>Also, there *may* be other messages of interest (if b/a-client, 4961, 4959,
>and others in close numeric proximity are the session statistics messages).
>
>
>Don France
>Technical Architect - Tivoli Certified Consultant
>Professional Association of Contract Employees (P.A.C.E.)
>San Jose, CA
>(408) 257-3037
>[EMAIL PROTECTED]
>
>
>----- Original Message -----
>From: "Steve Harris" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, May 07, 2002 7:26 PM
>Subject: Re: Select Stmt? or Query
>
>
>Try something like
>
>select date_time, message
>from actlog
>where nodename='MYNODE'
>and date_time > current timestamp - 12 hours
>and msgno in (1234, 5678, 9876)
>
>Just tune the where clause to select the messages that you want. Run this
>in commadelimited mode and pipe the output through your scripting tool of
>choice to give you a pretty report.
>
>Steve Harris
>AIX and TSM Admin
>Queensland Health, Brisbane Australia
>
> >>> [EMAIL PROTECTED] 08/05/2002 3:35:57 >>>
>Hello All:
>
>I have a unix client that kicks off an incremental backups thru tivoli
>using an internal dump process for a sql database. I want to provide a
>report to the group that monitors its backup. The only information they
>care about is whether a filespace backed up successfully, what files
>failed, and how much data was transferred. For the time being I am
>running 'q actlog begind=-1 begint=18:00:00 sea='nodename', because we
>try to schedule our backups between 6 p.m. and 6 a.m. This is too much
>information to run thru on a daily basis for them and they were hoping I
>could trim down a report. Does anybody have a select statement or query
>that comes close to the needs I have?
>
>Thanks,
>
>Bud Brown
>Information Services
>Systems Administrator
>
>
>
>**********************************************************************
>This e-mail, including any attachments sent with it, is confidential
>and for the sole use of the intended recipient(s). This confidentiality
>is not waived or lost if you receive it and you are not the intended
>recipient(s), or if it is transmitted/ received in error.
>
>Any unauthorised use, alteration, disclosure, distribution or review
>of this e-mail is prohibited. It may be subject to a statutory duty of
>confidentiality if it relates to health service matters.
>
>If you are not the intended recipient(s), or if you have received this
>e-mail in error, you are asked to immediately notify the sender by
>telephone or by return e-mail. You should also delete this e-mail
>message and destroy any hard copies produced.
>**********************************************************************
met vriendelijke groet,
with regards,
Peter Pijpelink
----------
Bezoek onze website op http://www.plcs.nl
P.L.C.S. Storage Consultants
----------
Postadres: Bezoekadres:
PLCS B.V. PLCS B.V.
Postbus 292 Het Tasveld 23
3340 AG Hendrik Ido Ambacht 3342 GT Hendrik Ido Ambacht
Tel.: 078-6823685 Fax: 078-6823686 mobiel 06-24821621
Op deze email is een disclaimer van toepassing.
http://www.plcs.nl/disclaimer.html
On this email is subject to a disclamier. http://www.plcs.nl/disclaimer.html
----------
