physical and logical logging

《physical and logical logging》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Module10PhysicalandLogicalLoggingPhysicalandLogicalLogging03-200310-1©2001,2003InternationalBusinessMachinesCorporationObjectivesAttheendofthismodule,youwillbeableto:®Movethephysicallogtoanewdbspace®Add,drop,andmodifylogicallogs®Changetheloggingmodeofa

2、database®Definealongtransaction®Listanddescribeconfigurationparametersrelatedtophysicalandlogicallogging®Monitorthephysicalandlogicallogs10-210-2PhysicalandLogicalLoggingLogInitializationDefaultparametersettingsinonconfig.std:PHYSFILE2000#Physicallogfi

3、lesize(Kbytes)PHYSDBSrootdbs#Location(dbspace)ofphysicallogLOGFILES6#NumberoflogicallogfilesLOGSIZE1500#Logicallogsize(Kbytes)LOGSMAX6#Maximumnumberoflogicallogfiles10-3Bydefault,whentheserverisinitialized,thephysicallogandlogicallogfilesarelocatedinth

4、erootdbspace.Theycanbemovedtoanotherdbspaceafterthefirstinitializationoftheserver.Atinitialization,youcanconfigurethefollowingphysicalandlogicalloggingparameters:PHYSFILEOnlyonephysicallogiscreatedondisk.Theminimumphysicallogsizeis200kilobytes.Thephysi

5、callogsizemustbeamultipleofthepagesize.PHYSDBSThedbspacewherethephysicallogiscreated.LOGFILESThenumberoflogicallogfilescreatedwhentheserverisinitialized.Theminimumnumberoflogicallogfilesthatyoucanconfigureforaserveris3andthemaximumisLOGSMAX.Thisparamet

6、ercannotbechangedaftertheserverisinitialized.LOGSIZETheminimumlogicallogfilesizeis200kilobytesandthemaximumiscalculatedasfollows:(ROOTSIZE-PHYSFILE-512-(63*((pagesize)/1024)))/LOGFILESThelogicallogsizemustbeamultipleofthepagesize.Thisparametercannotbec

7、hangedaftertheserverisinitialized.LOGSMAXThemaximumnumberoflogicallogfilesthatcanbeallocatedontheserver.TheminimumisLOGFILESandthemaximumis32,767.PhysicalandLogicalLogging10-3ChangingthePhysicalLogChangethesizeandlocationofthephysicallogusingonparams.F

8、orexample:onparams-p-dlogspace-s10000PhysicalPhysicalloglogdbspace1dbspace210-4Theonparamsutilitycanbeusedtochangethedbspacelocationand/orsizeofthephysicallog.Aboveisanexampleofacommandtochangethesizeandlocationofthephysicallog.Theargum