Recovering from an upgrade during an online database command  Modifying dbccdb schema for large identifiers

Release Bulletin Adaptive Server® Enterprise Version 15.0 for Sun Solaris

The configuration parameter allow backward scan does not work

[CR #401543] The configuration parameter allow backward scan does not work in Adaptive Server version 15.0.

Workaround: If you are encountering increased deadlocks due to backward scans, break problematic descending scans into two steps. First, select the required rows into a temporary table in ascending order. Then, select from the temporary table in descending order.





Copyright © 2005. Sybase Inc. All rights reserved. Modifying dbccdb schema for large identifiers

View this release bulletin as PDF