Logical Log last unique number first new
Danette asked what the maximum "unique id" (uniqid) for logical logs is, and whether the counter wraps back to 1 — she was writing a monitoring script that subtracts tx_logbeg from the current log's uniqid and wanted to know if the formula would eventually break at a rollover. Another user reported IDs well past 250,000 in production, Art Kagel suggested just forcing log switches with onmode -l to observe behaviour, and John Miller gave the answer: the limit is 1,073,741,823 — roughly 170 years of filling a log every 5 seconds. Danette accepted this as resolved.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I was wondering if Informix had a spec for the logical log, where it could tell you what the last number of the unique logical log would be, and then tell you what the logical log unique number will reset to. Example: unique# c00000000ca55b20 40 U-B---- 99995 3:60053 5000 5000 100.00 c00000000ca55b90 41 U-B---- 99996 4:60053 5000 5000 100.00 c00000000ca55c00 42 U-B---- 99997 5:60053 5000 5000 100.00 c00000000ca55c70 43 U-B---- 99998 3:65053 5000 5000 100.00 c00000000ca55ce0 44 U---C-L 99999 4:65053 5000 3020 60.40 c00000000ca55d50 45 U-B---- 99941 5:65053 5000 5000 100.00 c00000000ca55dc0 46 U-B---- 99942 3:70053 5000 5000 100.00 c00000000ca55e30 47 U-B---- 99943 4:70053 5000 5000 100.00 In the case above will the next logical log be 100000 or will it trip back to 1? Does anyone know what is the highest number for unique numbers would be? I have done some research and have not been able to come up with this specific spec. Thanks, Danette
This is what we currently have from one of our production systems (IDS 7.31): b9ee2d8 100 U-B---- 257628 3b7a155 25000 14523 58.09 b9ee2f4 101 U------ 257629 3b802fd 25000 25000 100.00 b9ee310 102 U------ 257630 3b864a5 25000 25000 100.00 b9ee32c 103 U---C-L 257631 3b8c64d 25000 10264 41.06 b9ee348 104 U-B---- 257488 3b927f5 25000 25000 100.00 don't know the limit but wonder why would it reset to 1 just after 100000? if there is then shouldn't it be something like 2**31 (~2147483648) -- just my 2 cents... ----- Original Message ---- From: DANETTE MONDOU <danette.mondou@kaman.com> To: ids@iiug.org Sent: Friday, September 7, 2007 1:28:35 PM Subject: Logical Log last unique number first new [9925] Hi, I was wondering if Informix had a spec for the logical log, where it could tell you what the last number of the unique logical log would be, and then tell you what the logical log unique number will reset to. Example: unique# c00000000ca55b20 40 U-B---- 99995 3:60053 5000 5000 100.00 c00000000ca55b90 41 U-B---- 99996 4:60053 5000 5000 100.00 c00000000ca55c00 42 U-B---- 99997 5:60053 5000 5000 100.00 c00000000ca55c70 43 U-B---- 99998 3:65053 5000 5000 100.00 c00000000ca55ce0 44 U---C-L 99999 4:65053 5000 3020 60.40 c00000000ca55d50 45 U-B---- 99941 5:65053 5000 5000 100.00 c00000000ca55dc0 46 U-B---- 99942 3:70053 5000 5000 100.00 c00000000ca55e30 47 U-B---- 99943 4:70053 5000 5000 100.00 In the case above will the next logical log be 100000 or will it trip back to 1? Does anyone know what is the highest number for unique numbers would be? I have done some research and have not been able to come up with this specific spec. Thanks, Danette ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
Easy enough to find out! Just run onmode -l and change logical logs!
Art S. Kagel
----- Original Message -----
From: Danette Mondou <ids@iiug.org>
To: ids@iiug.org
At: 9/07 13:29:10
Hi,
I was wondering if Informix had a spec for the logical log, where it could
tell you what the last number of the unique logical log would be, and then
tell you what the logical log unique number will reset to.
Example: unique#
c00000000ca55b20 40 U-B---- 99995 3:60053 5000 5000 100.00
c00000000ca55b90 41 U-B---- 99996 4:60053 5000 5000 100.00
c00000000ca55c00 42 U-B---- 99997 5:60053 5000 5000 100.00
c00000000ca55c70 43 U-B---- 99998 3:65053 5000 5000 100.00
c00000000ca55ce0 44 U---C-L 99999 4:65053 5000 3020 60.40
c00000000ca55d50 45 U-B---- 99941 5:65053 5000 5000 100.00
c00000000ca55dc0 46 U-B---- 99942 3:70053 5000 5000 100.00
c00000000ca55e30 47 U-B---- 99943 4:70053 5000 5000 100.00
In the case above will the next logical log be 100000 or will it trip back to
1? Does anyone know what is the highest number for unique numbers would be? I
have done some research and have not been able to come up with this specific
spec.
Thanks, Danette
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I believe the answer is 1073741823.
If you filled a logical log every 5 seconds it would take you 170 year
to reach this number. -:)
John
=
"ART KAGEL, =
BLOOMBERG/ 731 =
LEXIN" =
To
<kagel@bloomberg. ids@iiug.org =
net> =
cc
Sent by: =
ids-bounces@iiug. Subj=
ect
org Re:Logical Log last unique numbe=
r
first new [9929] =
=
09/07/2007 11:18 =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
Easy enough to find out! Just run onmode -l and change logical logs!
Art S. Kagel
----- Original Message -----
From: Danette Mondou <ids@iiug.org>
To: ids@iiug.org
At: 9/07 13:29:10
Hi,
I was wondering if Informix had a spec for the logical log, where it co=
uld
tell you what the last number of the unique logical log would be, and t=
hen
tell you what the logical log unique number will reset to.
Example: unique#
c00000000ca55b20 40 U-B---- 99995 3:60053 5000 5000 100.00
c00000000ca55b90 41 U-B---- 99996 4:60053 5000 5000 100.00
c00000000ca55c00 42 U-B---- 99997 5:60053 5000 5000 100.00
c00000000ca55c70 43 U-B---- 99998 3:65053 5000 5000 100.00
c00000000ca55ce0 44 U---C-L 99999 4:65053 5000 3020 60.40
c00000000ca55d50 45 U-B---- 99941 5:65053 5000 5000 100.00
c00000000ca55dc0 46 U-B---- 99942 3:70053 5000 5000 100.00
c00000000ca55e30 47 U-B---- 99943 4:70053 5000 5000 100.00
In the case above will the next logical log be 100000 or will it trip b=
ack
to
1? Does anyone know what is the highest number for unique numbers would=
be?
I
have done some research and have not been able to come up with this
specific
spec.
Thanks, Danette
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
My assumption would be when it gets to the last number in the unique numbering sequence that it will revert back to 1, like from my example 99999 is the currently number and the next number will be 1, instead of 100000. Regarding Art's response: I don't need to know what the next number is now. I want to know what it will be when we get to the last number in the sequence. From Kern's response I can see that it is well into the 250000 numbers and going. We have writen a script that gets the current log number. We just wanted to base a formula on the last number if that was possible. So that when we subtract the last number from the tx_log_#. We want to know the difference, if we never have to adjust the formula, but we currenlty don't know what the last number is. So at some point our formula will fail in its current state. Here's a line from our current script: and (select uniqid from syslogs where is_current = 1) - tx_logbeg > 20
Hi John, Thanks. That number seems close enough, I guess it really shouldn't be my worry it will take about 170 years give or take the few logs that we have from now. Thanks to Art and Kern, as well. This satisfies my curiosity. Danette