Symptom
- You have configured ASE DB auto-expansion in DBA Cockpit.
- However, when running sp_dbextend simulate to test, get the result below saying DB was altered by total size '0M'.
1> exec sp_dbextend 'simulate', <dbname>, 'default', '5'
2> go
NO REAL WORK WILL BE DONE. Simulate database / device expansion in a dry-run mode 5 time(s).
These are the series of database/device expansions that would have happened if the threshold on database '<dbname>', segment 'default'were to fire 5 time(s).
Threshold fires: Iteration: 1.
================================
Threshold action procedure 'sp_dbxt_extend_db' fired in db '<dbname>' on segment 'default'. Space left: 65536 logical pages ('1024M').
Database '<dbname>' was altered by total size '0M' for segment 'default'.
- Checking the output of sp_dbextend 'list', get some output like below.
1> sp_dbextend 'list', 'database', '<dbname>'
2> go
name segment item value status
-------------------------------------------- ---------------------------------------- ------------------------------------------------ --------
server-wide (n/a) (n/a) (n/a) enabled
<dbname> default maxsize 0 enabled
<dbname> default growby 1024 enabled
<dbname> logsegment maxsize 0 enabled
<dbname> logsegment growby 200M enabled
default (all) growby 0 disabled
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
auto-expansion, sp_dbextend, Automatic DB Expansion, maxsize, DBA Cockpit , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.