如何查看表绿屏 DB2 的日志数据 [英] 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.
我使用以下命令获得了有关表的信息:DSPFD文件(P6PRDBDB00/P6OIDPF)
I got info on the table by using the following command: DSPFD FILE(P6PRDBDB00/P6OIDPF)
获得了日志名称和库,但我不知道如何查看对象 P6OIDPF?
Got the journaled name and library but I dont know how to view it for the object P6OIDPF?
我确实去了图书馆#MXJRN,什么时候去了P6,得到了以下信息:
I did go to library #MXJRN and whent to P6 and got the following :
如何查看对象 P6OIDPF 数据?或者查看它的命令?P6中有很多对象.
How can I view the object P6OIDPF data? Or a command to view it? Theres a lot of objects in P6.
推荐答案
使用的命令是DSPJRN JRN(#MXJRN/P6) FILE((P6PRDBDB00/P6OIDPF))
您可以过滤开始和结束日期时间.
You can Filter on start and end date time.
这篇关于如何查看表绿屏 DB2 的日志数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!