Sybase IQ 12.4.0 installation instructions Storage within the database as in use

Page 37

Leaked space recovery

New server startup parameters

•	Incremental backups are disabled After the database is opened in
	forced recovery mode, incremental backups are disabled. The next backup
	must be a full backup. Doing a full backup reenables incrementals.
•	Forced recovery affects all databases opened The forced recovery
	parameter applies to all opens of the database while the server is up.
	Therefore, after the database is opened, the DBA needs to bring the server
	back down, and then restart the server without the forced recovery flag, to
	be sure that subsequent opens run in regular mode. Repeated opens of the
	database with forced recovery on do not harm the database, but could be
	confusing to the DBA because each forced recovery open marks all the
	storage within the database as in use.

•Use the -gd switch during forced recovery. Sybase recommends that you start the IQ server with the -gd switch set to restrict access to the server to the DBA. Forced recovery operates in all modes, but restricted access gives the DBA greater control over inadvertent opens of the database.

Either through system failure or as a result of opening a database with forced recovery, a database’s allocation map may not reflect the true allocation of its usage. When this occurs, we say that it has “leaked” storage. Adaptive Server IQ 12.4.0 resolves this problem by adding the ability to recover leaked storage.

When leaked storage is being recovered, other transactions that alter the allocation map are shut out. Such operations include checkpoints, and commands that modify the database.

Two new server startup parameters, -iqfrecand -iqdroplks, and one additional run-time setting, dbcc_option, support the new forced recovery and leaked storage recovery feature.

The following table describes the new server startup parameters.

Parameter	Scope	Description
-iqfrec dbname	database	Marks the specified
		database as in use and
		restores database to its last
		known consistent state.

-iqdroplks dbname	database	Allows the sp_iqcheckdb
		stored procedure to recover
		leaked storage within the
		specified database.

37

Image 37

Contents Product summary Release Bulletin Adaptive Server IQ For Digital UnixRequired Operating System Patches Adaptive Server IQ Required Operating System PatchesAdaptive Server IQ Converting 12.0.x databases to RestrictionsRelease Bulletin for Digital Unix Following outer join format is supported Setting the Ldlibrarypath Environment Variable Installation InstructionsDocumentation for this version Special migration instructions Accessing Current Release Bulletin InformationObtaining query plans Go to support.sybase.comChanged functionality in Adaptive Server IQ Changed functionality in this versionImproved stored procedure output Adaptive Server IQ Adaptive Server IQ Stopasiq utility Known problemsData definition Temporary tables in proceduresAdaptive Server IQ Queries 1 ANY, SOME, and ALL subquery supportLarge in subqueries Adaptive Server IQ OperationsOutput to file in Dbisql Changing length of Dbisql column valuesDbspawn Error when starting a server User-defined variable issueUnsupported terminal types cause Dbisql error User-defined variable issue Adaptive Server IQDSE not installed on Windows client systems Problems with Add User-defined Data Type wizardAdd Service utility installed only with Server Components Notification message setting omitted from Index PropertiesProduct compatibilities Documentation updates and clarificationsStartup, shutdown, and connection Data Type column in Table Editor retains focusSpecifying server switches Additions to the startasiq or asiqsrv12 command-line optionsGn command-line option Gm command line optionUsing -v switch on 64-bit platforms Gm command line option Adaptive Server IQConfirming connections Using Odbc connectivity with UnixAdaptive Server IQ Confirming connections Using a .odbc.ini file Adaptive Server IQ Using a .odbc.ini fileStopasiq utility Adaptive Server IQ Addition to Stop Database statement Addition to Stop Database statementConfiguration files do not accept quotes Error in Dbstop exampleError in Dbstop example Adaptive Server IQ Disconnect details omittedAdaptive Server IQ Switch must be uppercase Switch must be uppercaseData definition DDL Change to Create Database statementColumn Limit Correction LowDisk functions as HighGroupJoint Virtual Table JVT definition IQ database file paths must be uniqueError in raw partition limit Error documenting IQ PathError on Create Dbspace Adaptive Server IQ Error documenting IQ PathAddition to Drop Database statement Size clause of Create DbspaceSize clause of Create Dbspace Adaptive Server IQ Recommended index types Changes to Using join indexesAdaptive Server IQ Recommended index types Id custid idlname Changes to Using join indexes Adaptive Server IQAdaptive Server IQ Changes to Using join indexes Data manipulation DML Error in Diskstriping defaultSupport for joins between stores or databases Adaptive Server IQ DefaultNew and changed general database options Adaptive Server IQ New and changed general database optionsInsertnumberrowsperrawiobuffer Adaptive Server IQ DescriptionDescription Adaptive Server IQ Corrections to Insert LocationCorrection to Char function String function Repeat is supportedNumber* function not supported Adaptive Server IQ String function Repeat is supported Using Isnull and Coalesce Backup and system administration Using Isnull and Coalesce Adaptive Server IQ New options for reserving spaceInsufficient disk space Change to error messageEffect of checkpoints Adaptive Server IQ Forced recovery and leaked space recoveryStorage within the database as in use Dbccoption option Spiqcheckdb Set dbccoption to 2, as a temporary option New Stored Procedure Columns Improved output in stored proceduresSpiqstatus now displays IQ Page Size Minpasswordlength optionTransaction Log utility Maintaining a transaction log or mirror Setting PrefetchBufferLimit option Error message for buffer cache settingsGrant Connect for existing user ID Dropping users may delete tables Documentation on Data Backup and RecoveryCleaning up after abnormal exit Changes to Backup statementMonitoring server activity Creating attribute tables for PowerBuilder Using PC client applicationsClient applications Help filesAdaptive Server IQ plug-in help reflects Multiplex support Technical SupportSybase Certifications on the Web Other sources of informationTechinfo.sybase.com