|
midrange.com
OK So we have this SQL statement that does a select over a join of two
tables with an order by of the results.
Been werkin for years. Then it bombs. Gives an MCH error it does (3404 I
believe). If you take out the order by then it works. V5R3 system. BUT
it's being mirrored to another i5 which is V5R4. AND IT BREAKS THERE TOO!
Hmm Hmm Hmm. Nothing out there at IBM on this one. Nothing we can find at
all.
No other messages, no object damage, no performance issues, not huge
tables. Nuthin. Fails in net.data, interactivly, ODBC and though OpsNav.
Consistant anyway.
Then suddenly, it works. It works on both boxes. Self healing? We did no
PTFs, built no indeces, reorganized no files.... Only thing we did was
keep adding more data.
Anybody ever see this? It's just gotta be a busted piece of IBM code but
we can't reproduce it and they'll never belive us... :-)
- Larry
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.
