Installing Automatic Database Expansion Procedures

Install automatic expansion using the installdbextend script, which loads rows into master.dbo.sysattributes, which describes defaults for automatic expansion in a database or in a device.

The installation script also creates a control table in the model and tempdb databases.

If you are upgrading to SAP ASE version 12.5.1 or later, you must install this script separately as part of your upgrade process.

  1. Log in with sa_role permissions. In UNIX, installdbextend is located in $SYBASE/$SYBASE_ASE/scripts. If you are running Windows, the location is %SYBASE%/%SYABASE_ASE%/scripts
  2. On UNIX, run:
    isql -Usa -P -Sserver_name <$SYBASE/$SYBASE_ASE/scripts/installdbextend
    On Windows, run:
    isql -Usa -P -Sserver_name <%SYBASE%\%SYBASE_ASE%\scripts\installdbextend

    installdbextend script installs the family of threshold action procedures and sp_dbextend in the sybsystemprocs database.