Transaction logs generated by the data-load optimizations and parallel index updates are incompatible with versions of Adaptive Server earlier than 15.7 SP110. Database and transaction log dumps that are generated with data-load optimizations and parallel index updates cannot be recovered by earlier versions.
To downgrade an entire Adaptive Server installation to an earlier version, use sp_downgrade, which truncates the active portion of the transaction log, thus permitting recovery of the databases by the earlier version.
See the Adaptive Server Enterprise 15.7 ESD #2 Reference Manual: Procedures.
To load a database containing transactional activity from the optimized data load, use sp_downgrade_esd to first downgrade it to the target Adaptive Server support package version. This process clears transactional activity from the log, which then allows an earlier version of Adaptive Server to load and recover a dump of this database.
See the Adaptive Server Enterprise 15.7 SP100 Installation Guide.
You cannot downgrade database dumps that contain log activity from the optimized data load and parallel index updates. Use the output from load...with headeronly to see if a particular dump contains such activity. To load such dumps into an earlier Adaptive Server version that does not support these new optimizations (for example, Adaptive Server 15.7 SP100), you must first reload the dump into an Adaptive Server version that supports this feature. Then use sp_downgrade_esd to downgrade the database to the appropriate version. Re-create the dump from the downgraded database in a form that is compatible with the earlier Adaptive Server version.
With some restrictions, database and transaction log dumps from a later version of Adaptive Server can be loaded and recovered in earlier versions. However, once a dump is generated, it may be compatible with only a few of the earlier versions of Adaptive Server, depending on the features used in the database, or the objects that are contained in the dumps.
Prior to generating the dumps, you can use the db_attr system function to identify the features that are currently active in the database, and the information that will be included in dumps.