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.
- 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
- 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.