Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to view Journal data of a Table Green screen DB2

How do you view journal data from a specified table? I want to see what happended to a table in a specified time frame.

I got info on the table by using the following command: DSPFD FILE(P6PRDBDB00/P6OIDPF)

enter image description here

enter image description here

Got the journaled name and library but I dont know how to view it for the object P6OIDPF?

I did go to library #MXJRN and whent to P6 and got the following : enter image description here

How can I view the object P6OIDPF data? Or a command to view it? Theres a lot of objects in P6.

like image 913
Renier Avatar asked Aug 31 '25 18:08

Renier


2 Answers

The command to use is DSPJRN JRN(#MXJRN/P6) FILE((P6PRDBDB00/P6OIDPF))

You can Filter on start and end date time.

like image 106
Renier Avatar answered Sep 03 '25 18:09

Renier


The EXPJRNE utility from Tools/400 provides a higher level interface to the DSPJRN command.

like image 29
James Allman Avatar answered Sep 03 '25 19:09

James Allman