1> EXEC sp_dboption EEP, 'trunc log on chkpt', true
Database option 'trunc log on chkpt' turned ON for database 'EEP'.
Running CHECKPOINT on database 'EEP' for option 'trunc log on chkpt' to take effect.
(return status = 0)
1> EXEC sp_dboption EEP, 'allow incremental dumps', true
Database option 'allow incremental dumps' turned ON for database 'EEP'.
Running CHECKPOINT on database 'EEP' for option 'allow incremental dumps' to take effect.
(return status = 0)
1> EXEC sp_dboption EEP, 'deallocate first text page', true
Database option 'deallocate first text page' turned ON for database 'EEP'.
Running CHECKPOINT on database 'EEP' for option 'deallocate first text page' to take effect.
(return status = 0)
1> EXEC sp_dboption EEP, 'full logging for all', true
Database option 'full logging for all' turned ON for database 'EEP'.
Running CHECKPOINT on database 'EEP' for option 'full logging for all' to take effect.
(return status = 0)
1> use EEP
Msg 930, Level 14, State 1:
Server 'EEP', Line 1:
Database 'EEP' cannot be opened because either an earlier system termination left LOAD DATABASE incomplete or the database is created
with 'for load' option. Load the database or contact a user with System Administrator (SA) role.
1> EXEC sp_changedbowner sapsa
Msg 17361, Level 16, State 1:
Server 'EEP', Procedure 'sp_changedbowner', Line 124:
Can't change the owner of the master, model, tempdb or sybsystemprocs database.
(return status = 1)

ERROR      2014-02-03 22:40:02.943 [CInstallerCallBackImpl.cpp:229]
CJS-00030  Assertion failed: Unable to load database EEP. Refer to trace file sapinst_dev.log for further information.

TRACE      2014-02-03 22:40:02.954 [JSExtension.hpp:140]
           JSExceptionHandler::setJSException()
Member function 'Installer.abortInstallation()' has thrown ESAPinstException. Converting to JavaScript exception EJS::Exception.

1> sp_helpdb EEQ
2> go
 name             db_size
         owner                dbid
         created
         durability
         lobcomplvl
         inrowlen
         status
 EEQ                 97332.0 MB
         sapsa                   4
         Jan 25, 2014
         full
                100
             2000
         ddl in tran, allow nulls by default, abort tran on log full, allow wide
          dol rows, deferred table allocation, page compression, allow increment
         al dumps, deallocate first text page,full logging for all

(1 row affected)
 device_fragments               size          usage
         created                   free kbytes
 ------------------------------ ------------- --------------------
         ------------------------- ----------------
 EEQ_data_001                      51200.0 MB data only
         Jan 25 2014  3:46PM               29648256
 EEQ_log_001                       10240.0 MB log only
         Jan 25 2014  3:46PM       not applicable
 EEQ_data_001                       5120.0 MB data only
         Jan 28 2014 12:13AM                  43168
 EEQ_data_001                       5120.0 MB data only
         Feb  1 2014  5:51AM                 849392
 EEQ_data_001                       5120.0 MB data only
         Feb  1 2014 11:56AM                1188128
 EEQ_data_001                       5120.0 MB data only
         Feb  1 2014  1:16PM                1634032
 EEQ_data_001                       5120.0 MB data only
         Feb  1 2014  2:27PM                1035936
 EEQ_data_001                       5120.0 MB data only
         Feb  1 2014  3:30PM                2014368
 EEQ_data_001                       5120.0 MB data only
         Feb  1 2014  4:32PM                 926880
 EEQ_data_001                          4.0 MB data only
         Feb  2 2014  6:33PM                      0
 master                               24.0 MB data only
         Feb  3 2014  4:07AM                   1792
 master                               24.0 MB data only
         Feb  3 2014 10:00AM                    128

 log only free kbytes = 10444496

(return status = 0)

Resolution

    The Shrinking Databases feature became available with ASE 15.7/ SP100 and higher,
    Shrinking Databases  is supported via a set of new parameters of the ‘alter database… off’ command:

   alter database database_name
   . . .
   off database_device {=size | [from page_number] [to page_number]}
   [, database_device…]
   [with timeout='time']

    Details about this featuer are in the product documentation:
    Adaptive Server Enterprise 15.7 SP100 > New Features Guide Adaptive Server Enterprise 15.7 SP100 > Shrinking Databases
     http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00641.1570100/doc/html/mas1343943986393.html