Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Unanswered: How to increase dbccdb size

    Hi All,
    I am kinda new learner in sybase now, I am try to increase my dbccdb size. Can anyone could provide me procedure or step i need to take before increase dbccdb size. Any input would be appreciate.
    Thanks so much
    CN

  2. #2
    Join Date
    Jan 2010
    Posts
    72
    Did you tried alter database command to increase the dbccdb size?

  3. #3
    Join Date
    Aug 2010
    Posts
    2
    Yes, i did disk init and alter database,
    Now what i like to do is to modify dbcc workspaces like <DBCCDB_SCAN_PAGES>, <DBCCDB_TEST_PAGES>...how you do that?

    when i run this command below:

    use dbccdb
    go
    sp_dbcc_createws dbccdb, scanseg,scan_sps, scan,
    '<DBCCDB_SCAN_PAGES>'
    go
    sp_dbcc_createws dbccdb,textseg,text_sps,test,
    '<DBCCDB_TEXT_PAGES>'
    go

    its complain about "scan_sps" already exists.

    So how am i modify this DBCCDB_SCAN? and DBCCDB_TEXT?

    Thanks

  4. #4
    Join Date
    Jan 2010
    Posts
    72
    You can use sp_dbcc_alterws to change the size of the specified work space to a specified number.

Posting Permissions

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