Monitoring Question

Richard Arnold

Monitoring Question
Hello List,

I just got a request from a developer. He wants to monitor all of the
changes to
a table over time. Basically, he wants a report of all the inserts,
updates, and
deletes that happen to the table daily.

Outside of putting count reports in all of the programs that manipulate the
table,
is there an easy way to extract this information. We have DB2 PM, though I
am
not yet familiar with it's batch capabilities. Can PM do this?

I don't want to go so far as to extract log data and parse through it.

Any suggestions or ideas?

Thanks in advance for your help.

Richard Arnold
JPMorganChase

This message is for LISTSERVE purposes only, and MUST NOT be quoted
by any VENDORS!!



Smike Toppins

Re: Monitoring Question
(in response to Richard Arnold)
If you're on V6, you can add triggers to accomplish the trick.


SMike Toppins
Great-West Life
[login to unmask email]
(303) 737-5094


> ----------
> From: Richard Arnold[SMTP:[login to unmask email]
> Reply To: DB2 Data Base Discussion List
> Sent: Thursday, January 04, 2001 8:06 AM
> To: [login to unmask email]
> Subject: Monitoring Question
>
> Hello List,
>
> I just got a request from a developer. He wants to monitor all of the
> changes to
> a table over time. Basically, he wants a report of all the inserts,
> updates, and
> deletes that happen to the table daily.
>
> Outside of putting count reports in all of the programs that manipulate
> the
> table,
> is there an easy way to extract this information. We have DB2 PM, though
> I
> am
> not yet familiar with it's batch capabilities. Can PM do this?
>
> I don't want to go so far as to extract log data and parse through it.
>
> Any suggestions or ideas?
>
> Thanks in advance for your help.
>
> Richard Arnold
> JPMorganChase
>
> This message is for LISTSERVE purposes only, and MUST NOT be quoted
> by any VENDORS!!
>
>
>
>
>
>



Terry Shockey

Re: Monitoring Question
(in response to Smike Toppins)
richard:
ca-platinums log anlayzer product will do that and so much more for you, it
will also tell you
when the change was made.

-----Original Message-----
From: Toppins, Smike [mailto:[login to unmask email]
Sent: Thursday, January 04, 2001 10:09 AM
To: [login to unmask email]
Subject: Re: Monitoring Question


If you're on V6, you can add triggers to accomplish the trick.


SMike Toppins
Great-West Life
[login to unmask email]
(303) 737-5094


> ----------
> From: Richard Arnold[SMTP:[login to unmask email]
> Reply To: DB2 Data Base Discussion List
> Sent: Thursday, January 04, 2001 8:06 AM
> To: [login to unmask email]
> Subject: Monitoring Question
>
> Hello List,
>
> I just got a request from a developer. He wants to monitor all of the
> changes to
> a table over time. Basically, he wants a report of all the inserts,
> updates, and
> deletes that happen to the table daily.
>
> Outside of putting count reports in all of the programs that manipulate
> the
> table,
> is there an easy way to extract this information. We have DB2 PM, though
> I
> am
> not yet familiar with it's batch capabilities. Can PM do this?
>
> I don't want to go so far as to extract log data and parse through it.
>
> Any suggestions or ideas?
>
> Thanks in advance for your help.
>
> Richard Arnold
> JPMorganChase
>
> This message is for LISTSERVE purposes only, and MUST NOT be quoted
> by any VENDORS!!
>
>
>
>
>
>








Max Scarpa

Re: Monitoring Question
(in response to Terry Shockey)
But if I remeber well (I saw log manager years ago) you need DATA CAPTURE
YES in the table ...or is it only to rebuild inserts, updates...statements
???

THX


Max Scarpa

'If your programmer doesn't understand what he must do, beat him.'

Bluto Blutarsky



Rob Wright

Re: Monitoring Question
(in response to Max Scarpa)
Hi Richard

Try the following:

ALTER the table to add the auditing required:
ALTER TABLE <tbname> AUDIT CHANGES
Start a DB2 audit trace with audit class 4
-start trace audit class(4)
To analyse the output, use the DB2PM AUDIT Report Set. See the DB2PM Report
Reference

I haven't used these reports, but I'm sure you will get the detail you want.

Note that the audit changes only records the first such change
(INSERT/UPDATE/DELETE) in a unit of work. This may not be what is required by
the developer.

Regards
Rob Wright



Roger Miller

Re: Monitoring Question
(in response to Rob Wright)
DSN1LOGP can extract and print if what you want is simple. You can specify
a DBID and OBID, so that you get only the tablespace that you're interested
in. If you run something like Quiesce, then getting the RBA or LRSN values
is fairly simple. See Utility Guide and Reference for more.

The other options noted as audit trace (Administration Guide, Security and
Auditing section), and triggers (V6 SQL Ref.). A number of vendors have
programs which format the log data.

Roger Miller, DB2 for OS/390