Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.