Re: Question about UDB on iSeries

I believe this is called journalling.

Just today I had an analyst and his supervisor wondering where thousands 
of records went.  On occasion they go bye-bye.  Some debate as to which 
program in which job is doing this.
All I did was the following
CRTJRNRCV...
CRTJRN...
STRJRNPF...
UPDDTA on the file in question
DSPJRN...
and not only could we see which job, but we could see which program added 
and deleted a particular record.
Now, you can SQL the receivers directly.  You could use SQL against an 
output file created with DSPJRN I suppose.
Now they agree this will be an excellent tool to trap the errant code.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Shields, Ken" <kenshields@xxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
11/30/2004 12:45 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Mailing LIst \(E-mail\)" <Midrange-L@xxxxxxxxxxxx>
cc

Subject
Question about UDB on iSeries






Hi Folks

                                 As it turns out, I believe the DB2 UDB on 
the Iseries has one other very important 'leg up', on the competition.
                                 In the area of SOX compliance, I'm 
hearing some great feedback from some people, that by simply
                                 engaging a feature on the DB2, changes 
that occur to databases are automatically logged, and can be 
                                 inquired on later using SQL...

                                 I'm almost certain, that with the 
requirements of this new law, many companies will expend a great deal 
                                 of money and effort to accomplish the 
same.
                                 Thumbs up definetely to IBM..

 

Ken Shields
PPG Canada Inc
155 First Ave.
Oshawa, Ontario L1H 7L3
PH:905 725 1144 (326) 
FAX:905 433 8712 


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.