by 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
------ -----------
--------------------------------------------------------------------------- --------------------------------------------------------------------------- --------------------------------------------------------------------------- (1 row affected) As one can see with sp_configure "histogram" : 1> sp_configure "histogram" (1 row affected) there are a number of NULL values ... Can someone send me the output of sp_configure "histogram" Thanks and kind regards - Alfred --
-----------
------
----------- -----------
410 20
number of histogram steps
9
number of histogram steps
14
NULL
NULL NULL
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
----------- -------------------- ----------
number of histogram steps NULL NULL 20
NULL NULL NULL
(return status = 0)
so that I can update the sysconfigures to the approbiate values.
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG