| Neueste Versionen | FixList |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC77853 | Status: Geschlossen |
MISSING CONDITION IN THE DEFINE OF SYSCAT.SEQUENCES LEADS TO DUPLICATE ENTRIES | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
missing condition in the define of syscat.sequences leads to duplicate entries | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 users on 9.7 FP 4 or prior * **************************************************************** * PROBLEM DESCRIPTION: * * MISSING CONDITION IN THE DEFINE OF SYSCAT.SEQUENCES LEADS TO * * DUPLICATE ENTRIES * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 9.7 FP5 * **************************************************************** | |
| Local-Fix: | |
Use the following query instead select a.seqschema, a.seqname, a.definer, a.definertype, a.owner, a.ownertype, a.seqid, a.seqtype, a.base_seqschema, a.base_seqname, a.increment, a.start, a.maxvalue, a.minvalue, case when a.lastassignedval + a.increment > a.maxvalue and a.increment > 0 then case when a.cycle = 'Y' then a.minvalue else null end when a.lastassignedval + a.increment < a.minvalue and a.increment < 0 then case when a.cycle = 'Y' then a.maxvalue else null end else coalesce(a.lastassignedval + a.increment, a.start) end, a.cycle, a.cache, a.order, a.datatypeid, a.sourcetypeid, a.create_time, a.alter_time, a.precision, a.origin, b.remarks from sysibm.syssequences as a left outer join sysibm.syscomments as b on a.seqid = b.objectid and b.objecttype = 'Q' | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
| Lösung | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.07.2011 19.09.2011 19.09.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.5 |
|