web analytics

Creation and using of Sybase DBCCDB database

Planning:

sp_plan_dbccdb ‘{dbname}’

Creation:

create database dbccdb on … log on … isql -U sa -i $SYBASE/$SYBASE_ASE/scripts/installdbccdb

DBCCDB Configuration:

sp_configure "number of worker processes", {value_from_sp_plan} — create named cache for dbccdb sp_cacheconfig "dbccdb_cache", "{cache_size}M"   — Size is at least 40 * 16K * (number of working processes) sp_poolconfig "dbccdb_cache", "{pool_size}M", "16K"

Working space configuration:

[…]