× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2023

RE: Removed member

I did finally get an answer from IBM on this so I thought I would pass it on.

As a reminder, this thread was about DSPJRN not showing when a member was deleted unless the member name was a parm on the command.
DSPJRN JRN(JRNTEST/JRNTEST) FILE((JRNTEST/JRNTEST NEWMBR))...shows the member being deleted.
DSPJRN JRN(JRNTEST/JRNTEST) FILE((JRNTEST/JRNTEST *ALL))...does not show the member being deleted.

Per IBM development...
That is WAD. Not the most intuitive, but that's how it works. I wrote a TechNote about this a while back. While the TechNote is about objects, it applies to members too. For performance reasons, when you specify an object we will first look to see if the object exists. If it does, we'll take the JID from the object and return all entries for that JID. If the object does not exist, we do a costly lookup in our JIDX to find all JIDs that match that object name and return all entries for those JIDs. So for this case, when you do *ALL members for the file, we only look for journal entries with the JIDs for the existing members--the ones that exist the moment the DSPJRN is run. On the other hand, specifying a member name that does not exist means we have to do the lookup to find a match, and we do, and we return entries for that JID.




-----Original Message-----
From: smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Wednesday, August 23, 2023 1:57 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Removed member

Using *NONE for the member shows even less
Opt Sequence Code Type Object Library Job Time
2 D JF JRNTEST JRNTEST QPADEV0002 20:18:05
5 D MA JRNTEST JRNTEST QPADEV0002 20:18:22

At this point, I have given up on using DSPJRN for this analysis and I switched to the SQL function QSYS2.Display_Journal to dump all of the F records for the problem file into an output file so I can query them more efficiently.

I am still going to push on IBM to get an answer on why mbr *ALL does not work in the command.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Charles Wilt
Sent: Wednesday, August 23, 2023 9:16 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Removed member

How about FILE((JRNTEST/JRNTEST *NONE)) ?

Charles

On Tue, Aug 22, 2023 at 9:40 PM <smith5646midrange@xxxxxxxxx> wrote:

I have opened a ticket with IBM on this but here is what I know so far.

I created a test journal, receiver, and file to control my test. The
second member that I added to the file was named NEWMBR.

If I do not specify the file, I get the following DSPJRN
JRN(JRNTEST/JRNTEST)
Opt Sequence Code Type Object Library Job Time
1 J PR QPADEV0002 20:17:31
2 D JF JRNTEST JRNTEST QPADEV0002 20:18:05
3 F JM JRNTEST JRNTEST QPADEV0002 20:18:06
4 F JM JRNTEST JRNTEST QPADEV0002 20:18:22
5 D MA JRNTEST JRNTEST QPADEV0002 20:18:22
6 F MC JRNTEST JRNTEST QPADEV0002 20:18:22
7 F DM JRNTEST JRNTEST QPADEV0002 20:18:28
8 F MD JRNTEST JRNTEST QPADEV0002 20:18:28
9 J XP JRNTEST JRNTEST QDBSRV01 20:18:28


If I specify the file and member *ALL I get the following DSPJRN
JRN(JRNTEST/JRNTEST) FILE((JRNTEST/JRNTEST *ALL))
Opt Sequence Code Type Object Library Job Time
2 D JF JRNTEST JRNTEST QPADEV0002 20:18:05
3 F JM JRNTEST JRNTEST QPADEV0002 20:18:06
5 D MA JRNTEST JRNTEST QPADEV0002 20:18:22


If I specify the file and member NEWMBR I get the following DSPJRN
JRN(JRNTEST/JRNTEST) FILE((JRNTEST/JRNTEST NEWMBR))
Opt Sequence Code Type Object Library Job Time
2 D JF JRNTEST JRNTEST QPADEV0002 20:18:05
4 F JM JRNTEST JRNTEST QPADEV0002 20:18:22
5 D MA JRNTEST JRNTEST QPADEV0002 20:18:22
6 F MC JRNTEST JRNTEST QPADEV0002 20:18:22
7 F DM JRNTEST JRNTEST QPADEV0002 20:18:28
8 F MD JRNTEST JRNTEST QPADEV0002 20:18:28
9 J XP JRNTEST JRNTEST QDBSRV01 20:18:28

Basically, specifying *ALL for the member does not work like it should.
I'll update everyone as I know more.

--
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@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.


--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.