Is there any system table in AS/400 to get the journal information

10 pts.
Tags:
AS/400
AS/400 journaling
I am looking for a system table where I can get the journalled information for all objects in a specific library AS/400. I am able to get the objects list from system table QSYS/QADBXREF and am getting the record counts from system table QSYS2/SYSTABLESTAT. I need to check whether the object is journaled before I do any action. Please help.

Software/Hardware used:
AS400
ASKED: August 7, 2013  7:36 AM
UPDATED: August 8, 2013  2:28 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Don’t know if you can find it in some systable or not, but if you
DSPFD FILE(YOURLIB/*ALL) TYPE(*ATR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(QTEMP/FILES)
you’ll find the information you need in the generated file


Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Do not access QADBXREF directly. It's a system table used by DB2, and you should not be reading it. If you need data from it, use one of the logical views provided by IBM. Use one of the views in QSYS2. Besides, there are better tables to use.   SYSTABLESTAT should be okay for deleted record counts. But it seems like a lot of processing for a single value that shouldn't be very meaningful.   I'm not aware of any database catalog table that contains journal references. But you shouldn't need one; nor should you need the other two files above. All three can be collected into a single temporary file with a single command:
    DSPFD FILE(*ALLUSR/*ALL) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE( QTEMP/mymbrdta )
    All of the data you're mentioning (and much more) will be in the MYMBRDTA file in QTEMP after you run that command. You can name the output file whatever you want and put it in any library. It doesn't have to go in QTEMP.   Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    You can use the TYPE(*ATR) output if you only want names of files and journal associations. The TYPE(*MBR) output gives those plus the various record counts, and it's likely to be an easier format to query. You might review both formats (and the others) to see which attributes can be retrieved. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following