Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4

    Unanswered: DBCC config - parameters missing/insufficient

    I am in the process of configuring a brand new ASE15.5 instance. So far, so good, but the dbccdb-config won't work.
    The following steps were taken:
    Code:
    Recommended size for dbccdb database is 125MB (data = 123MB, log = 2MB).
    dbccdb database already exists with size 1500MB.
    Recommended values for workspace size, cache size and process count are:
     
    dbname                         scan ws  text ws  cache  comp mem  process count       
    master                         3696K    928K     925K   0K        1  
    tempdb                         6208K    1568K    1556K  0K        2  
    model                          64K      48K      640K   0K        1  
    sybsystemdb                    1280K    336K     1280K  0K        2  
    sybsystemprocs                 2464K    624K     640K   0K        1  
    dbccdb                         18448K   4624K    4615K  0K        2
    The dbccdb was the first db to be configured:
    Code:
    use dbccdb
    go
    sp_addsegment scanseg, dbccdb, dbccdb_data_01
    go
    sp_addsegment textseg, dbccdb, dbccdb_data_01
    go
    --
    sp_dbcc_createws dbccdb, scanseg, scan_dbccdb, scan, '20000K'
    go
    sp_dbcc_createws dbccdb, textseg, text_dbccdb, text, '5000K'
    go
    sp_dbcc_updateconfig dbccdb, 'max worker processes', '2'
    go
    sp_dbcc_updateconfig dbccdb, 'scan workspace', 'scan_dbccdb'
    go
    sp_dbcc_updateconfig dbccdb, 'text workspace', 'text_dbccdb'
    go
    sp_dbcc_updateconfig dbccdb, 'dbcc named cache', 'default data cache', '6M'
    go
    To check - doublecheck I ran sp_dbcc_evaluatedb:
    Code:
    Recommended values for workspace size, cache size and process count are:
     
    Database name : dbccdb
                                          current         suggested
    scan workspace size :                     20M               19M
    text workspace size :                   5008K             5008K
    cache size          :                   6144K             1280K
    process count       :                       2                 2
    As far as I know, that is all I need. Yet, when I run sp_dbcc_runcheck dbccdb, I get an error:
    Code:
    Number (9965) Severity (20) State (1) Server (XXXX) Procedure (sp_dbcc_run_runcheck) The entries in dbcc_config for database 'dbccdb' are either missing or invalid. Use sp_dbcc_evaluatedb to determine appropriate values for the entries and sp_dbcc_updateconfig to set them.
    What am I missing?
    I'm not crazy, I'm an aeroplane!

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Never mind. It turned out to be a glitch in my sql-tool. When I fired the sp_dbcc_runcheck through a commandline session it ran without a hitch.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •