RE: serial jumps

Posted in 2003

Alexey Sonkin — Wed, 12 Nov 2003 12:34:56 -0500 — source: Usenet: comp.databases.informix

Hi, Bill, One possible reason is that some application (or programmer) inserts non-zero value into the serial column ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: Bill Hamilton [mailto:laidback@finsco.com] > Sent: Wednesday, November 12, 2003 11:56 AM > To: informix-list iiug > Subject: serial jumps > > I have a user who complains frequently that certain serial columns take > a jump for no reason (like from 3000+ to 250000+) . This person worries > that they will wrap in production and make inserts fail. > > I suspect an errant program or a developer's fat finger in dbaccess. > This is IDS 9.4 . > > Has anyone ever had any problem with a serial column jumping unexpectedly? > > Also is there a system table that shows the serials, or are they stored > invisibly within each table? > sending to informix-list sending to informix-list