 | |
Sybase ASE 15.0.3 Windows dbcc checkstorage
sybase.public.ase.administration sybase.public.ase.administration
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Sybase ASE 15.0.3 Windows dbcc checkstorage -
02-02-2011
, 11:26 PM
#2
| |||
| |||
|
|
Hi, I'm trying to resolve an "Error: 692, Severity: 20" problem as a Sybase newbie. dbcc mentioned something about the cache size -- 1> dbcc checkstorage (V550) 2> go Checking V550: Logical pagesize is 2048 bytes Msg 9978, Level 17, State 1: Server 'SUM_SYB1', Line 1: The 16K buffer pool in the configured cache 'default data cache' is too small. 640K is the minimum size. DBCC CHECKSTORAGE for database 'V550' encountered an error. Some results may not be available. Correct the problems reported and reexecute the CHECKSTORAGE command. which I don't know how to create/modify -- 1> sp_cacheconfig 2> go *Cache Name * * * * Status * Type * * Config Value * Run Value *------------------ -------- -------- -------------- ------------ *default data cache Active * Default * * 100.00 Mb * * *100..00 Mb *tempdb_cache * * * Active * Mixed * * * 100.00 Mb * * *100.00 Mb * * * * * * * * * * * * * * * * * *------------ ------------ * * * * * * * * * * * * * * Total * * 200..00 Mb * *200.00 Mb ================================================== ======================== Cache: default data cache, * Status: Active, * Type: Default * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strict LRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * *100.00 Mb * *100.00 Mb ** 10 ================================================== ======================== Cache: tempdb_cache, * Status: Active, * Type: Mixed * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strict LRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * * *0.00 Mb * *100.00 Mb * * 10 (return status = 0) 1> sp_poolconfig "default data cache" 2> go *Cache Name * * * * Status * Type * * Config Value * Run Value *------------------ -------- -------- -------------- ------------ *default data cache Active * Default * * 100.00 Mb * * *100..00 Mb (1 row affected) * * * * * * * * * * * * * * * * * *------------ ------------ * * * * * * * * * * * * * * Total * * 100..00 Mb * *100.00 Mb ================================================== ======================== Cache: default data cache, * Status: Active, * Type: Default * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strict LRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * *100.00 Mb * *100.00 Mb ** 10 (return status = 0) Any tip would be much appreciated! Jerry |
#3
| |||
| |||
|
|
Hi What version you have? Select @@version please Tahir On Feb 3, 9:26*am, Jerry <jerryji1... (AT) gmail (DOT) com> wrote: Hi, I'm trying to resolve an "Error: 692, Severity: 20" problem as a Sybase newbie. dbcc mentioned something about the cache size -- 1> dbcc checkstorage (V550) 2> go Checking V550: Logical pagesize is 2048 bytes Msg 9978, Level 17, State 1: Server 'SUM_SYB1', Line 1: The 16K buffer pool in the configured cache 'default data cache' is too small. 640K is the minimum size. DBCC CHECKSTORAGE for database 'V550' encountered an error. Some results may not be available. Correct the problems reported and reexecute the CHECKSTORAGE command. which I don't know how to create/modify -- 1> sp_cacheconfig 2> go *Cache Name * * * * Status * Type * * Config Value * Run Value *------------------ -------- -------- -------------- ------------ *default data cache Active * Default * * 100.00 Mb * * *100.00 Mb *tempdb_cache * * * Active * Mixed * * * 100.00 Mb * * *100.00 Mb * * * * * * * * * * * * * * * * * *------------ ------------ * * * * * * * * * * * * * * Total * * 200.00 Mb * *200.00 Mb ================================================== ======================== Cache: default data cache, * Status: Active, * Type: Default * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strictLRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * *100.00 Mb * *100.00 Mb * * 10 ================================================== ======================== Cache: tempdb_cache, * Status: Active, * Type: Mixed * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strictLRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * * *0.00 Mb * *100.00 Mb* * 10 (return status = 0) 1> sp_poolconfig "default data cache" 2> go *Cache Name * * * * Status * Type * * Config Value * Run Value *------------------ -------- -------- -------------- ------------ *default data cache Active * Default * * 100.00 Mb * * *100.00 Mb (1 row affected) * * * * * * * * * * * * * * * * * *------------ ------------ * * * * * * * * * * * * * * Total * * 100.00 Mb * *100.00 Mb ================================================== ======================== Cache: default data cache, * Status: Active, * Type: Default * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strictLRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * *100.00 Mb * *100.00 Mb * * 10 (return status = 0) Any tip would be much appreciated! Jerry |
Adaptive Server Enterprise/15.0.3/EBF 16550 ESD#1/P/NT (IX86)/Windows
2003/ase1
503/2680/32-bit/OPT/Thu Mar 05 00:21:40 2009
Jerry
#4
| |||
| |||
|
|
Hi, I'm trying to resolve an "Error: 692, Severity: 20" problem as a Sybase newbie. dbcc mentioned something about the cache size -- 1> dbcc checkstorage (V550) 2> go Checking V550: Logical pagesize is 2048 bytes Msg 9978, Level 17, State 1: Server 'SUM_SYB1', Line 1: The 16K buffer pool in the configured cache 'default data cache' is too small. 640K is the minimum size. DBCC CHECKSTORAGE for database 'V550' encountered an error. Some results may not be available. Correct the problems reported and reexecute the CHECKSTORAGE command. which I don't know how to create/modify -- 1> sp_cacheconfig 2> go *Cache Name * * * * Status * Type * * Config Value * Run Value *------------------ -------- -------- -------------- ------------ *default data cache Active * Default * * 100.00 Mb * * *100..00 Mb *tempdb_cache * * * Active * Mixed * * * 100.00 Mb * * *100.00 Mb * * * * * * * * * * * * * * * * * *------------ ------------ * * * * * * * * * * * * * * Total * * 200..00 Mb * *200.00 Mb ================================================== ======================== Cache: default data cache, * Status: Active, * Type: Default * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strict LRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * *100.00 Mb * *100.00 Mb ** 10 ================================================== ======================== Cache: tempdb_cache, * Status: Active, * Type: Mixed * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strict LRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * * *0.00 Mb * *100.00 Mb * * 10 (return status = 0) 1> sp_poolconfig "default data cache" 2> go *Cache Name * * * * Status * Type * * Config Value * Run Value *------------------ -------- -------- -------------- ------------ *default data cache Active * Default * * 100.00 Mb * * *100..00 Mb (1 row affected) * * * * * * * * * * * * * * * * * *------------ ------------ * * * * * * * * * * * * * * Total * * 100..00 Mb * *100.00 Mb ================================================== ======================== Cache: default data cache, * Status: Active, * Type: Default * * * Config Size: 100.00 Mb, * Run Size: 100.00 Mb * * * Config Replacement: strict LRU, * Run Replacement: strict LRU * * * Config Partition: * * * * * *1, * Run Partition: * * * * * *1 *IO Size *Wash Size * * Config Size *Run Size * * APF Percent *-------- ------------- ------------ ------------ ----------- * * *2 Kb * * *20480 Kb * *100.00 Mb * *100.00 Mb ** 10 (return status = 0) Any tip would be much appreciated! Jerry |
sp_plan_dbccdb V550
go
Which will tell you required sizes for dbcc operations. The run a
command like:
sp_poolconfig "default data cache", "40M", "16K"
go
which would take 40mbytes from the 2k pool of the default cache and
allocate it to the 16k pool.
Ben
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.