Re: Removed member

The SQL is probably a better long term solution anyway.

On Wed, Aug 23, 2023 at 1:57 PM <smith5646midrange@xxxxxxxxx> wrote:

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.


--
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.