Glad you found something

I added a comment to
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzaki/rzakiautostrjrnl.htm?lang=en
requesting clarification as to when one should use the data area QDFTJRN
and when one should use the command STRJRNLIB.

From what I remember QDFTJRN came out first and was deprecated by
STRJRNLIB.

However, Look at this:
crtlib robdelme
Library ROBDELME created.
CRTJRNRCV JRNRCV(ROBDELME/JRNRCV0001)
Journal receiver JRNRCV0001 created in library ROBDELME.
CRTJRN JRN(ROBDELME/JRNRCV) JRNRCV(ROBDELME/JRNRCV0001)
Journal JRNRCV created in library ROBDELME.
CRTDTAARA DTAARA(robdelme/QDFTJRN) TYPE(*CHAR) LEN(80)
Data area QDFTJRN created in library ROBDELME.
CHGDTAARA DTAARA(robdelme/QDFTJRN (1 10)) VALUE(robdelme)
crtjrnrcv robdelme/x0001
Journal receiver X0001 created in library ROBDELME.
CRTJRN JRN(ROBDELME/X) JRNRCV(ROBDELME/X0001)
Journal X created in library ROBDELME.
CHGDTAARA DTAARA(robdelme/QDFTJRN (11 10)) VALUE(x)
CHGDTAARA DTAARA(OVERRIDE/QDFTJRN (21 10)) VALUE(*ALL)
Library OVERRIDE not found for data area QDFTJRN.
CHGDTAARA DTAARA(robdelme/QDFTJRN (21 10)) VALUE(*ALL)
CHGDTAARA DTAARA(robdelme/QDFTJRN (51 10)) VALUE(*ALLOPR)
crtpf robdelme/huh rcdlen(80)
File HUH created in library ROBDELME.
Member HUH added to file HUH in ROBDELME.
dspfd robdelme/huh

File is currently journaled . . . . . . . . : Yes
Current or last journal . . . . . . . . . . : X
Library . . . . . . . . . . . . . . . . . : ROBDELME

dsplibd robdelme
Journaling information:
Currently journaled . . . . . . . . : YES
Current or last journal . . . . . . : JRNRCV
Library . . . . . . . . . . . . . : ROBDELME
Journal images . . . . . . . . . . . : *AFTER
Omit journal entry . . . . . . . . . : *NONE
New objects inherit journaling . . . : *YES
Inherit rules overridden . . . . . . : YES
Journaling last started date/time . : 10/14/15 11:51:33

STRSQL
CREATE TABLE ROBDELME.DELETETHIS (MYCHAR CHAR (5 ) NOT NULL WITH
DEFAULT)
Table DELETETHIS created in ROBDELME.
File is currently journaled . . . . . . . . : Yes
Current or last journal . . . . . . . . . . : X
Library . . . . . . . . . . . . . . . . . : ROBDELME


Apparently the data area takes precedence, irregardless of whether the
table was created with CRTPF or CREATE TABLE.
(Testing done on 7.2 machine at cume 5135, TR2 and DB2 group 8.)


Rob Berendt

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2019 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].