Hi all,

at the 12.5 server boot I found the following error message:

00:00000:00001:2003/07/04 15:06:42.12 kernel Virtual device 12 started
using asynchronous i/o.
00:00000:00001:2003/07/04 15:06:42.14 server Error: 5859, Severity: 16,
State: 1
00:00000:00001:2003/07/04 15:06:42.14 server The configuration number
'410' is invalid.
00:00000:00001:2003/07/04 15:06:42.32 server Recovering database
'sybsystemdb'.
00:00000:00001:2003/07/04 15:06:42.40 server Redo pass of recovery has
processed 0 committed and 1 aborted transactions.

Looking into the sysconfigure for config 410 I found the following:

1> select * from sysconfigures where config = 410
2> go
config value
comment
status
name
parent
value2
value3 value4
------ -----------

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------

--------------------------------------------------------------------------------
------

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------- -----------
410 20
number of histogram steps
9
number of histogram steps
14
NULL
NULL NULL

(1 row affected)

As one can see with sp_configure "histogram" :

1> sp_configure "histogram"
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
----------- -------------------- ----------
number of histogram steps NULL NULL 20
NULL NULL NULL

(1 row affected)
(return status = 0)

there are a number of NULL values ...

Can someone send me the output of sp_configure "histogram"
so that I can update the sysconfigures to the approbiate values.

Thanks and kind regards - Alfred


--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

This is a fairly new parameter that was added in 12.0.0.4 esd #1 and
12.5.0.1. Did you perhaps recently upgrade from 12.0.0.4 ead #1 or
higher to 12.5 GA? If you are on a 12.5 version before 12.5.0.1, the
simplist solution would probably be to apply the current rollup
(including
running the installmaster script).

-bret


"Alfred Zentek" <zentek@web.de> wrote in message news:<33fb53db2e278851e677ef5af22fb74b.58777@mygat e.mailgate.org>...
> Hi all,
>
> at the 12.5 server boot I found the following error message:
>
> 00:00000:00001:2003/07/04 15:06:42.12 kernel Virtual device 12 started
> using asynchronous i/o.
> 00:00000:00001:2003/07/04 15:06:42.14 server Error: 5859, Severity: 16,
> State: 1
> 00:00000:00001:2003/07/04 15:06:42.14 server The configuration number
> '410' is invalid.
> 00:00000:00001:2003/07/04 15:06:42.32 server Recovering database
> 'sybsystemdb'.
> 00:00000:00001:2003/07/04 15:06:42.40 server Redo pass of recovery has
> processed 0 committed and 1 aborted transactions.
>
> Looking into the sysconfigure for config 410 I found the following:
>
> 1> select * from sysconfigures where config = 410
> 2> go
> config value
> comment
> status
> name
> parent
> value2
> value3 value4
> ------ -----------
>
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> -----------
>
> --------------------------------------------------------------------------------
> ------
>
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> ----------- -----------
> 410 20
> number of histogram steps
> 9
> number of histogram steps
> 14
> NULL
> NULL NULL
>
> (1 row affected)
>
> As one can see with sp_configure "histogram" :
>
> 1> sp_configure "histogram"
> 2> go
> Parameter Name Default Memory Used Config Value
> Run Value Unit Type
> ------------------------------ ----------- ----------- ------------
> ----------- -------------------- ----------
> number of histogram steps NULL NULL 20
> NULL NULL NULL
>
> (1 row affected)
> (return status = 0)
>
> there are a number of NULL values ...
>
> Can someone send me the output of sp_configure "histogram"
> so that I can update the sysconfigures to the approbiate values.
>
> Thanks and kind regards - Alfred

Thank's a lot!

I came from Sybase 12.0 EBF 10869 and upgraded to 12.5 SWR 9609.
After the upgrade I had those problems. Meanwhile I reinstalled 12.5
with EBF 10972
and it works now.

Kind regards - Alfred
"Bret Halford" <bret@sybase.com> wrote in message
news:34c88f2b.0307042141.76de1ac6@posting.google.c om

> This is a fairly new parameter that was added in 12.0.0.4 esd #1 and
> 12.5.0.1. Did you perhaps recently upgrade from 12.0.0.4 ead #1 or
> higher to 12.5 GA? If you are on a 12.5 version before 12.5.0.1, the
> simplist solution would probably be to apply the current rollup
> (including
> running the installmaster script).
>
> -bret
>
>
> "Alfred Zentek" <zentek@web.de> wrote in message news:<33fb53db2e278851e677ef5af22fb74b.58777@mygat e.mailgate.org>...


--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG