I would like to find a log about a DELETE

[gdorian]

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.

[Knut Stolze]

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

[gdorian]

On 8 Feb, 21:08, Knut Stolze <[e-mail]:

[e-mail] 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?

[Knut Stolze]

gd*****@libero.it wrote:

On 8 Feb, 21:08, Knut Stolze <[e-mail]:

>[e-mail] 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

[gdorian]

I want to figure out who deleted it and when..

Sorry for my not perfect English!! : ))

On 9 Feb, 08:39, Knut Stolze <[e-mail]:

[e-mail] wrote:

On 8 Feb, 21:08, Knut Stolze <[e-mail]:

[e-mail] 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 -

[Knut Stolze]

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