| Neueste Versionen | FixList |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
Informix - Problembeschreibung
| Problem IT27851 | Status: Geschlossen |
SHRINKING A TABLE POTENTIALLY LEADING TO -101 'FILE IS NOT OPEN'FOR PREPARED STATEMENTS LAST USED BEFORE THE SHRINK | |
| Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problembeschreibung: | |
This problem occurs since version 12.10.xC8 and so far has been
reported as SQL errors 626, 246, 243, all resulting from ISAM
error 101 ('file is not open').
Given some prepared statement(s) on a table, executed
successfully already in a session that's currently not using
them, now a 'table shrink' on this table comes along, e.g. from
auto_crsd task, before the session re-uses one of these prepared
statements. The next attempt by this session to execute such
statement would run onto 'file is not open' error (101) plus SQL
error depending on statement type. | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Shrinking a table potentially leads to -101 'file is not * * open' for prepared statements last used before the shrink. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
| Local-Fix: | |
| Lösung | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.01.2019 24.09.2019 24.09.2019 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC13 | |
| Problem behoben lt. FixList in der Version | |
