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