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 (AT) web (DOT) de> wrote

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 (AT) sybase (DOT) com> wrote




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