By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

I would like to find a log about a DELETE

P: n/a
We've got a DB2 installed on AIX server;
now I can't find many records related to a specif table, so my opinion
is that these records have been CANCELLED in a way I don't Know maybe
with some delete instructions..

the question is:
is there a log file where have been registered the DELETE/UPDATE
operations on the tables?

Thank You!
Domenico.

Feb 8 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
gd*****@libero.it wrote:
We've got a DB2 installed on AIX server;
now I can't find many records related to a specif table, so my opinion
is that these records have been CANCELLED in a way I don't Know maybe
with some delete instructions..

the question is:
is there a log file where have been registered the DELETE/UPDATE
operations on the tables?
The regular DB2 logs would contain such changes. But I don't think that's
really what you are asking for, is it?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Feb 8 '07 #2

P: n/a
On 8 Feb, 21:08, Knut Stolze <sto...@de.ibm.comwrote:
gdor...@libero.it wrote:
We've got a DB2 installed on AIX server;
now I can't find many records related to a specif table, so my opinion
is that these records have been CANCELLED in a way I don't Know maybe
with some delete instructions..
the question is:
is there a log file where have been registered the DELETE/UPDATE
operations on the tables?

The regular DB2 logs would contain such changes. But I don't think that's
really what you are asking for, is it?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Yes it is....
where I can found it?

Feb 9 '07 #3

P: n/a
gd*****@libero.it wrote:
On 8 Feb, 21:08, Knut Stolze <sto...@de.ibm.comwrote:
>gdor...@libero.it wrote:
We've got a DB2 installed on AIX server;
now I can't find many records related to a specif table, so my opinion
is that these records have been CANCELLED in a way I don't Know maybe
with some delete instructions..
the question is:
is there a log file where have been registered the DELETE/UPDATE
operations on the tables?

The regular DB2 logs would contain such changes. But I don't think
that's really what you are asking for, is it?

Yes it is....
where I can found it?
You should explain what your goal is. Do you want to restore the deleted
data? Or do you want to figure out who deleted it when?

The DB2 logs can be found in the directory specified in your DB CFG
parameter "Path to log files". Those are binary files and used by DB2 to
ensure the durability and atomicity of transactions (basic DBMS admin
knowledge). You could use the log reader API to access those log file.
However, the API
(http://publib.boulder.ibm.com/infoce...n/r0001910.htm)
does not explain each and every bit in the log records. The log record can
and does change with new requirements being implemented in DB2.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Feb 9 '07 #4

P: n/a
I want to figure out who deleted it and when..

Sorry for my not perfect English!! : ))

On 9 Feb, 08:39, Knut Stolze <sto...@de.ibm.comwrote:
gdor...@libero.it wrote:
On 8 Feb, 21:08, Knut Stolze <sto...@de.ibm.comwrote:
gdor...@libero.it wrote:
We've got a DB2 installed on AIX server;
now I can't find many records related to a specif table, so my opinion
is that these records have been CANCELLED in a way I don't Know maybe
with some delete instructions..
the question is:
is there a log file where have been registered the DELETE/UPDATE
operations on the tables?
The regular DB2 logs would contain such changes. But I don't think
that's really what you are asking for, is it?
Yes it is....
where I can found it?

You should explain what your goal is. Do you want to restore the deleted
data? Or do you want to figure out who deleted it when?

The DB2 logs can be found in the directory specified in your DB CFG
parameter "Path to log files". Those are binary files and used by DB2 to
ensure the durability and atomicity of transactions (basic DBMS admin
knowledge). You could use the log reader API to access those log file.
However, the API
(http://publib.boulder.ibm.com/infoce...ic/com.ibm.db2....)
does not explain each and every bit in the log records. The log record can
and does change with new requirements being implemented in DB2.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -

Feb 13 '07 #5

P: n/a
gd*****@libero.it wrote:
I want to figure out who deleted it and when..
The logs don't tell you _who_ deleted data. You could only figure out when
that happened.

I guess what you really need (or had needed) is some auditing facility.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Feb 13 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.