master..sysconfigures

master..sysconfigures

Post by Alfred Zente » Sat, 05 Jul 2003 22:57:32



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

 
 
 

master..sysconfigures

Post by Bret Halfo » Sun, 06 Jul 2003 14:41:28


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


> 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