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 Adaptive Server version 12.5.1 or later, you must install this script separately as part of your upgrade process.

StepsInstalling automatic database expansion

  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.