16
%s: unknown option: %.*s
lct_admin is a function used to manage the last-chance threshold (LCT) on the log segment of a database. Error 7406 occurs when an invalid option is passed to lct_admin.
Use one of the valid options listed below, which are all strings and require quotation marks.
lct_admin ("reserve", <number_of_log_pages>) – returns the number of pages required to do a successful dump transaction given the number of pages in a log segment. If the provided number of log pages is 0 (zero), the lct_admin() function returns the last-chance threshold value set for the current database.
lct_admin ("lastchance", <database_ID>) – creates a last-chance threshold for a database with log on a separate device. This can be used to create a last-chance threshold for databases that were upgraded from a pre-version 10.0 server.
You should not have to use the lastchance option
of lct_admin.
lct_admin ("logfull", <database_ID>) – determines if the last-chance threshold has been reached in a specified database. The procedure will return “0” if last-chance has not been reached, and “1” if it has.
lct_admin ("unsuspend", <database_ID>) – this command is no longer supported. To abort the tasks sleeping on a log-suspend state, consider using lct_admin(abort).
In addition to the lct_admin options
listed above, the following lct_admin options
also exist, bur are not fully documented in the current version
of this guide. Contact Sybase Technical Support for more information.
lct_admin(abort)
lct_admin(chkfreespace)
lct_admin(logsegment_freepages)
lct_admin(num_logpages)
lct_admin(reserved_for_rollbacks)
lct_admin(status_in_cache)
Refer to the Reference Manual: Building Blocks in the section “String functions” for a description of valid lct_admin options for your version.
All versions
