dbccdb error message

i'm trying to install dbccdb database on a 12.5.03 sun solaris server
and i got the following error,after configure everything :

dbcc checkstorage(vrac_italie)

Checking vrac_italie: Logical pagesize is 4096 bytes
Server Message: Number 9978, Severity 20
Server 'DUDIVD_10010', Line 1:
The 32K buffer pool in the configured cache is too small. 1280K is the
minimum size.
Server Message: Number 9975, Severity 10
Server 'DUDIVD_10010', Line 1:
DBCC CHECKSTORAGE for database 'vrac_italie' encountered an error.
Some results may not be available. Correct the problems reported and
reexecute the CHECKSTORAGE command.


this is the setting of my server :

Because i want to do it in low activity i used the default data cache
with is configure with 16kb buffer.

sp_poolconfig "default data cache"

default data cache Active Default 1100.00 Mb 1100.00 Mb


io size wash size config_size run_size
apf_percent
4 Kb 61440 Kb 0.00 Mb 800.00 Mb 10
16 Kb 61440 Kb 300.00 Mb 300.00 Mb 10


sp_plan_dbccdb give me this :

dbname scan ws text ws cache process
count
vrac_italie 12320K 3104K 3085K 3


sp_dbcc_configreport give me this :
Parameter Name Value Size

database name DEFAULT_VALUES
scan workspace def$scan$ws (id = 416001482) 512K
text workspace def$text$ws (id = 448001596) 256K


Reporting configuration information of database vrac_italie.

Parameter Name Value Size

database name vrac_italie 1024000K
dbcc named cache default data cache 60000K
text workspace text_vrac_ita (id = 960003420) 3104K
scan workspace scan_vrac_ita (id = 928003306) 12320K
max worker processes 3
operation sequence number 0

and for finish

sp_dbcc_evaluatedb vrac_italie

Recommended values for workspace size, cache size and process count
are:

Database name : vrac_italie
current suggested
scan workspace size : 13M 13M
text workspace size : 3104K 3104K
cache size : 59M 1920K
process count : 3 3


any idea?

Hi Stef,

dbcc checkstorage will always look for the largest pool size that is
configurable. On a server with a 4k logical page size you can configure
a large I/O pool of 32k. If you configure a 32k pool in the default
data cache checkstorage should run OK ...

sp_poolconfig "default data cache","200M","32K"
go

Cheers,

Sara ...


stef wrote:
 > i'm trying to install dbccdb database on a 12.5.03 sun solaris server
 > and i got the following error,after configure everything :
 >
 > dbcc checkstorage(vrac_italie)
 >
 > Checking vrac_italie: Logical pagesize is 4096 bytes
 > Server Message: Number 9978, Severity 20
 > Server 'DUDIVD_10010', Line 1:
 > The 32K buffer pool in the configured cache is too small. 1280K is
the
 > minimum size.
 > Server Message: Number 9975, Severity 10
 > Server 'DUDIVD_10010', Line 1:
 > DBCC CHECKSTORAGE for database 'vrac_italie' encountered an error.
 > Some results may not be available. Correct the problems reported and
 > reexecute the CHECKSTORAGE command.
 >
 >
 > this is the setting of my server :
 >
 > Because i want to do it in low activity i used the default data cache
 > with is configure with 16kb buffer.
 >
 > sp_poolconfig "default data cache"
 >
 > default data cache Active Default 1100.00 Mb 1100.00 Mb
 >
 >
 > io size wash size config_size run_size
 > apf_percent
 > 4 Kb 61440 Kb 0.00 Mb 800.00 Mb 10
 > 16 Kb 61440 Kb 300.00 Mb 300.00 Mb 10
 >
 >
 > sp_plan_dbccdb give me this :
 >
 > dbname scan ws text ws cache process
 > count
 > vrac_italie 12320K 3104K 3085K 3
 >
 >
 > sp_dbcc_configreport give me this :
 > Parameter Name Value Size
 >
 > database name DEFAULT_VALUES
 > scan workspace def$scan$ws (id = 416001482) 512K
 > text workspace def$text$ws (id = 448001596) 256K
 >
 >
 > Reporting configuration information of database vrac_italie.
 >
 > Parameter Name Value Size
 >
 > database name vrac_italie
1024000K
 > dbcc named cache default data cache 60000K
 > text workspace text_vrac_ita (id = 960003420) 3104K

 > scan workspace scan_vrac_ita (id = 928003306) 12320K
 > max worker processes 3
 > operation sequence number 0
 >
 > and for finish
 >
 > sp_dbcc_evaluatedb vrac_italie
 >
 > Recommended values for workspace size, cache size and process count
 > are:
 >
 > Database name : vrac_italie
 > current suggested
 > scan workspace size : 13M 13M
 > text workspace size : 3104K 3104K
 > cache size : 59M 1920K
 > process count : 3 3
 >
 >
 > any idea?<!-- ~MESSAGE_AFTER~ -->