SAP Knowledge Base Article - Preview

2563763 - ASE DB auto-expansion not work when maxsize is set as 0 - SAP ASE

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.