Change Physical-Log Parameters

Home | Previous Page | Next Page Administrative Utilities > The onparams Utility >

Change Physical-Log Parameters

Change Physical-Log Parameters:
 
        .-----------------------.
        V             (1)       |
|-- -p----+- -s--size---------+-+--+-----+----------------------|
          |              (1)  |    '- -y-'
          '- -d--dbspace------'

Notes:

Only one occurrence of this item allowed

Element	Purpose	Key Considerations
-p	Changes the location or size of the physical-log	Additional Information: You can use onparams -p with -s, -d, or both. The database server must be quiescent.
-d dbspace	Changes the location of the physical-log to the specified dbspace	Additional Information: The space allocated for the physical log must be contiguous. References: Syntax must conform to the Identifier segment; see the IBM Informix Guide to SQL: Syntax.
-s size	Changes the size (in kilobytes) of the physical log	Restrictions: This value must be an unsigned integer greater than or equal to 200 kilobytes. Warning: If you move the log to a dbspace without adequate contiguous space or increase the log size beyond the available contiguous space, a fatal shared-memory error occurs when you attempt to restart the database server with the new value.
-y	Causes the database server to automatically respond yes to all prompts	None.