RE: Alternative to QSYS2.OBJECT_STATISTICS to find file journal info

I would report that as a bug.
I would also check the following for messages indicating you need to run a RCLSTG *DBXREF, although it's been a few releases since that has dinged me.
Message_queue_info
History_log_info

I thought there was an alternate way of finding this information, like using a service to look at the journals instead of the objects. But I'm not finding anything directly.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Matt Olson
Sent: Monday, February 11, 2019 9:56 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Alternative to QSYS2.OBJECT_STATISTICS to find file journal info

We have been using the following query to find which files are attached to which journal in our system and recently discovered that it can return incorrect results (showing files attached to journals that no longer exist for instance):

SELECT * FROM TABLE (QSYS2.OBJECT_STATISTICS('libraryname','FILE') ) AS X

Is there another, more reliable way to find all files that are attached to specific journals that can be easily queried ?

Anyone know why QSYS2.OBJECT_STATISTICS might return incorrect information? Perhaps we need to run some routine to "refresh object statistics" or something?

Matt


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com