Installing automatic database expansion procedures

Install the automatic expansion process using the installdbextend script, which loads rows into master.dbo.sysattributes describing 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 the directory $SYBASE/$SYBASE_ASE/scripts. If you are running Windows NT, the location is %SYBASE%/%SYABASE_ASE%/scripts

  2. Run installdbextend by entering:

    isql -Usa -P -Sserver_name <$SYBASE/$SYBASE_ASE/scripts/installdbextend
    

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