|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.