physical and logical logging英文.pdf

Module 10 Physical and Logical Logging Physical and Logical Logging 03-2003 10-1 © 2001, 2003 International Business Machines Corporation Objectives At the end of this module, you will be able to: Move the physical log to a new dbspace Add, drop, and modify logical logs Change the logging mode of a database Define a long transaction List and describe configuration parameters related to physical and logical logging Monitor the physical and logical logs 10-2 10-2 Physical and Logical Logging Log Initialization Default parameter settings in onconfig.std: PHYSFILE 2000 # Physical log file size (Kbytes) PHYSDBS rootdbs # Location (dbspace) of physical log LOGFILES 6 # Number of logical log files LOGSIZE 1500 # Logical log size (Kbytes) LOGSMAX 6 # Maximum number of logical log files 10-3 By default, when the server is initialized, the physical log and logical log files are located in the root dbspace. They can be moved to another dbspace after the first initialization of the server. At initialization, you can configure the following physical and logical logging parameters: PHYSFILE Only one physical log is created on disk. The minimum physical log size is 200 kilobytes. The physical log size must be a multiple of the page size. PHYSDBS The dbspace where the physical log is created. LOGFILES The number of logical log files created when the server is initialized.