V5R1 question - CPF4238 & SQL7008 -- MIDRANGE-L

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

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