|
Hi Folks,Has anyone come across this weird SQL error? We have had it on 2 different systems now, one V5R3 and one V5R2. The program is deleting records in a file and gets to record 468 and fails to do any more, issuing msgs CPF5129 - "I/O is not allowed because the program device or member ACST1 file ACST1 in library V6ARCF is in error". And then message SQL0906 - "A previous error has made curson A1 not usable ..."
It deletes these same records OK if the job is run again. Any ideas anyone? Does this look like a PTF? thanks, Clare----- Original Message ----- From: "Martin Rowe" <dbg400.net@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx> Sent: Saturday, July 08, 2006 6:43 AMSubject: Re: Restored logicals have different format level identifier tooriginals - what gives?
On 08/07/06, qsrvbas@xxxxxxxxxxxx <qsrvbas@xxxxxxxxxxxx> wrote: [snip]Please see PTF 5722SS1-SI23530. I ran into this same problem at V5R3 and this PTF fixed it for me. Might be related PTFs at other VRMs of OS/400; you'll want to cross-reference it.There are apparently at least two somewhat related issues, but your mention of CRTDUPOBJ makes me think that SI23530 is good for you. Besides, it supersedes the second PTF anyway.Hope it helps. This one can be a real surprise when it hits. Tom LiottaHi Tom The more I've looked at this the stranger it gets. I ran the alter table SQL that Mark mentioned, and that corrected the differences between the DSPFFD output between my copy & the original (which had a number of date type fields - I just ran the SQL for the first one that had allowed the null value). What it didn't do was fix the format level ID. That was changed to something different again! As these files are all mirrored to another box for daily backups I've been told to make them all LVLCHK(*NO) for the time being - restoring them in DR would cause problems! We're at V5R2 which needs SI23692, from the cross reference. Regards, Martin -- martin@xxxxxxxxxx AIM/Gaim: DBG400dotNet http://www.dbg400.net /"\ DBG/400 - AS/400 & iSeries Open Source/Free Software utilities \ / Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news X TWiki - an Enterprise Collaboration Platform - http://twiki.org/ / \ --This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing listTo post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx 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-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.
midrange.com
