/var/tsm/report_data/actlog_to_email
#
dsmadmc -id= -pa=xxx macro /flapps/adsm/macros/showtime.mac
[pbsxsz4][/flapps/aix/prod.script]
-Original Message-
From: tsm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: Re: Select Stmt? or Query
Message-
From: tsm [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: Re: Select Stmt? or Query
hi, maybe you will have something usefull on this script:
select severity,count(*) as TOTAAL from actlog where severity in
('E','W') AND cast
21, 2002 10:29 PM
Subject: Re: Select Stmt? or Query
These kind of selects you can run per node or with a wildcard * mostly
will
run a few minutes or so.
Peter
At 15:36 21-05-2002 -0500, you wrote:
How long does this take. For us, it takes forever (we have LOTS of logs
in
24 hours
-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
: 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
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
