01/29/10 How to determine the jobs or objects responsible for generating journal entries in a journal receiver?

You may want to determine what jobs or objects are responsible for generating journal entries in a journal's receiver chain, for example, if you notice that many receivers are being created for the journal.

To determine what jobs or objects are responsible for generating journal entries in a journal's receiver chain, create an outfile from the DSPJRN command and run an SQL query on the outfile:

1. Create the outfile by running one of the following DSPJRN commands:

To specify a receiver range:

DSPJRN JRN(/)
RCVRNG(/ /)
OUTPUT(*OUTFILE)
OUTFILFMT(*TYPE1)
OUTFILE(/)

To specify an entry time range:

DSPJRN JRN(/)
RCVRNG(*CURCHAIN)
FROMTIME(

Disclaimer: Vision Solutions makes every effort to provide accurate system management information and programming code; however the company cannot be held liable for the accuracy of information nor its compatibility in your own environment. Please review and test thoroughly before implementing. © Copyright 2010, Vision Solutions, Inc. All rights reserved. Vision Solutions develops and sells System i (iSeries) high availability and AIX replication and clustering solutions. IBM, System i, iSeries, and AS/400 are trademarks of International Business Machines Corporation. All other brands are property of their respective registered owners.


No comments: