Sybase IQ 12.4.0 installation instructions Maintaining a transaction log or mirror

Page 43

When you use the RESTORE statement to move and/or rename a database, you can rename all of the files except the transaction log. Transactions continue to be written to the old log file name, in the location where the Catalog Store file (the .db file) is located after the database is restored.

When you rename or move all other files in the database, it is preferable to do the same for the log file. To move or rename the log file, you use the Transaction Log utility (DBLOG). You should run this utility:

•After using RESTORE with a new database name

•After using RESTORE with the RENAME option

Note The database server must not be running on that database when the transaction log filename is changed. If you try to use this utility on a running database, you get an error message.

You can access the Transaction Log utility from the system command line, using the DBLOG command-line utility.

The DBLOG command-line utility
Syntax	dblog [switches] database-file
Switches	Switch		Description
Switches


	-mmirror-name		Set transaction log mirror name.

	-tlog-name		Set the transaction log name

Description	The DBLOG command line utility allows you to display or change the name
	of the transaction log or transaction log mirror associated with a database. You
	can also stop a database from maintaining a transaction log or mirror, or start
	maintaining a transaction log or mirror.
Transaction log utility options
	Set the name of the transaction log mirror file (-m )	This option sets a

filename for a new transaction log mirror. If the database is not currently using a transaction log mirror, it starts using one. If the database is already using a transaction log mirror, it changes to using the new file as its transaction log mirror. Most Adaptive Server IQ databases do not use a transaction log mirror, so this switch is rarely used.

43

Image 43

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 Go to support.sybase.com Accessing Current Release Bulletin InformationSpecial migration instructions Obtaining query plansChanged functionality in Adaptive Server IQ Changed functionality in this versionImproved stored procedure output Adaptive Server IQ Adaptive Server IQ Stopasiq utility Known problems1 ANY, SOME, and ALL subquery support Temporary tables in proceduresData definition Adaptive Server IQ QueriesChanging length of Dbisql column values Adaptive Server IQ OperationsLarge in subqueries Output to file in DbisqlUser-defined variable issue Adaptive Server IQ User-defined variable issueDbspawn Error when starting a server Unsupported terminal types cause Dbisql errorNotification message setting omitted from Index Properties Problems with Add User-defined Data Type wizardDSE not installed on Windows client systems Add Service utility installed only with Server ComponentsData Type column in Table Editor retains focus Documentation updates and clarificationsProduct compatibilities Startup, shutdown, and connectionSpecifying server switches Additions to the startasiq or asiqsrv12 command-line optionsGm command line option Adaptive Server IQ Gm command line optionGn command-line option Using -v switch on 64-bit platformsConfirming 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 statementDisconnect details omitted Error in Dbstop exampleConfiguration files do not accept quotes Error in Dbstop example Adaptive Server IQChange to Create Database statement Switch must be uppercaseAdaptive Server IQ Switch must be uppercase Data definition DDLIQ database file paths must be unique LowDisk functions as HighGroupColumn Limit Correction Joint Virtual Table JVT definitionAdaptive Server IQ Error documenting IQ Path Error documenting IQ PathError in raw partition limit Error on Create DbspaceAddition 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 LocationAdaptive Server IQ String function Repeat is supported String function Repeat is supportedCorrection to Char function Number* function not supportedNew options for reserving space Backup and system administrationUsing Isnull and Coalesce Using Isnull and Coalesce Adaptive Server IQInsufficient 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 Help files Using PC client applicationsCreating attribute tables for PowerBuilder Client applicationsAdaptive Server IQ plug-in help reflects Multiplex support Technical SupportSybase Certifications on the Web Other sources of informationTechinfo.sybase.com