Functions

shrinkdb_status

shrinkdb_status adds these values for the query parameter:

current_object_id – Object ID of the table being shrunk
current_page – number of the page most recently, or currently, being moved
buffer_read_wait – amount of time, in microseconds, spent waiting for buffers to be read
buffer_write_wait – amount of time, in microseconds, spent waiting for buffers to be written
pages_read – number of pages read by the shrink operation
pages_written – number of pages written by the shrink operation
index_sort_count – number of times the shrink operation sorted duplicated indexes

loginfo

loginfo adds parameters to support managing transaction log space.

See loginfo

db_attr

db_attr has been expanded to include the list_dump_fs attribute.

You may not be able to load a database or transaction dumps that are generated in a later version of Adaptive Server into an earlier version. The features that are in use in a database, and objects that are created using newer features, are captured in database and transaction dumps. Before generating such dumps, use the list_dump_fs attribute to identify the features to be included in future dumps.

The following example shows the various features that are in use for the pubs2 database, and the target Adaptive Server version, which can safely load such dumps. The last line in bold indicates that the optimized data load with parallel index updates was executed in this database, and is contained in the transaction log.

1> select db_attr('pubs2', 'list_dump_fs')
2> go

Features found active in the database that will be recorded in a subsequent dump header:

ID= 3: 15.7.0.007: Database has compressed tables at version 1
ID= 4: 15.7.0.000: Database has system catalog changes made in 15.7 GA
ID= 7: 15.7.0.020: Database has system catalog changes made in 15.7 ESD#02
ID=11: 15.7.0.100: Database has the Sysdams catalog
ID=13: 15.7.0.100: Database has indexes sorted using RID value comparison
ID=14: 15.7.0.110: Log has transactions generating parallel index operations

Future dumps of pubs2 will be loadable only in the target server version indicated. To load the dumps of such a database in a target Adaptive Server version that is earlier than the version listed, downgrade the database to remove the footprint of newer features.