Apply Source Database Attributes to the Target Database

You can apply source database attributes to the target database.

You can now use load database with listonly=create_sql to make sure that the SQL code that is generated to create the target database into which dumps are loaded uses the same options and attributes as that of the source database that was originally dumped.

Specifically, use load database with listonly=create_sql to generate the SQL statements to initialize disks and create the database of an appropriate size into which the dump can be loaded.

To ensure that a database is restored exactly, both the target database and source database require the same attributes. Attributes are assigned to the source database through either sp_dboption, or the create database or alter database command. In versions earlier than SAP ASE 15.7 SP100, the attribute information was not stored within a database dump; this has changed as of SP100, with load database with listonly=create_sql storing the attributes in the database dump.

Any database attributes that had been applied to the source database using the create database or alter database commands are now included in the create database or alter database SQL that is generated with load database with listonly=create_sql. In addition, any options that had been applied to the source database using the sp_dboption stored procedure are now included in the output of listonly=create_sql by way of an equivalent call to sp_dboption to apply the same attributes to the target database.

The create database/alter database attributes included by listonly=create_sql are:
Note: If you use the listonly=create_sql option to create a database without specifying load_sql, SAP ASE creates the database without the for load option. On the other hand, if you specify listonly=(create_sql, load_sql), the create database and alter database commands are generated with the for load clause on the assumption that the commands generated by the load_sql option will be used to load the database.
The sp_dboption attributes included by listonly=create_sql are: