RE: V5R1 question - CPF4238 & SQL7008

Sounds like if you journal the files you won't have that problem.  =)
Seriously tho, SQL is sort of finicky with doing ops on unjournaled files.
Try making one, let the system manage the receivers at 10Mb a piece...
shouldn't get those messages anymore.

jch

-----Original Message-----
From: Dennis Munro [mailto:DMunro@badgerminingcorp.com]
Sent: Monday, September 30, 2002 11:01 AM
To: Midrange List (E-mail)
Subject: V5R1 question - CPF4238 & SQL7008


AS/400 720 running V5R1 since Labor Day weekend & current with "all" ptf's
at that time.

Ran a "test" of the month-end process on the machine & I got a
escape/diagnostic message that does not make sense.  First CPF4238 (Sev
50/Escape) "Member ILI not journaled to journal *N" which was followed by
SQL7008 (Sev 30/Diagnostic) "ILI in BPCSF not valid for operation" with
reason code 3 "ILI not journaled, or no authority to the journal.  Files
with an RI constraint action of CASCADE, SET NULL, or SET DEFAULT must be
journaled to the same journal."

Did a DSPFD on the file & it shows number of constraints as zero (-0-) & the
file is not being journaled.  So what is causing these messages to occur?
The program seemed to run correctly & the report generated was what I was
expecting.  There are eight files referenced by this program & all eight got
the same two messages & all eight have no constraints & they are not
journaled.

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

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