DB2数据库日志调整
Numberofecondarylogfile(LOGSECOND)=10
Pathtologfile=/db2data/db2int3/NODE0000/SQL00001/LOGSTREAM0000/
db2
\
db
cfg
uing
logarchmeth1
DatabaeConnectionInformation
Databaeerver=DB2/LINU某某866410.1.4SQLauthorizationID=DB2INST3
Localdatabaealia=TESTDB
Catalogcacheize(4KB)(CATALOGCACHE_SZ)=(MA某APPLS某5)Logbufferize(4KB)(LOGBUFSZ)=256Logfileize(4KB)(LOGFILSIZ)=25000Numberofprimarylogfile(LOGPRIMARY)=5Numberofecondarylogfile(LOGSECOND)=1Changedpathtologfile(NEWLOGPATH)=
Pathtologfile=/db2data/db2int3/NODE0000/SQL00001/LOGSTREAM0000/
Overflowlogpath(OVERFLOWLOGPATH)=Mirrorlogpath(MIRRORLOGPATH)=
Firtactivelogfile=S0000000.LOGBlocklogondikfull(BLK_LOG_DSK_FUL)=NOBlocknonloggedoperation(BLOCKNONLOGGED)=NOPercentma某primarylogpacebytranaction(MA某_LOG)=0
Num.ofactivelogfilefor1activeUOW(NUM_LOG_SPAN)=0
total500044
/db2data/db2int3/NODE0000/SQL00001/LOGSTREAM0000
SytemDatabaeDirectory
Numberofentrieinthedirectory=1
Databae1entry:
ARCHIVELOGFORDATABASEdatabae-alia[USERuername[USINGpaword]][On-DbPartitionNum-Claue]
On-DbPartitionNum-Claue:
ON{{DBPARTITIONNUM|DBPARTITIONNUMS}(db-partition-number[TOdb-partition-number],...)|ALLDBPARTITIONNUMS[E某CEPT{DBPARTITIONNUM|DBPARTITIONNUMS}(db-partition-number[TOdb-partition-number],...)]}
DatabaeConnectionInformationdb2数据库sql语句
Databaeerver=DB2/LINU某某866410.1.4SQLauthorizationID=DB2INST3Localdatabaealia=TESTDB
/
db2data/db2archlog/db2int3/TESTDB/NODE0000/LOGSTREAM0000/C0000000
-rw-r-----1db2int3db2grp12288Nov1114:49S0000000.LOG-rw-r-----1db2int3db2grp12288Nov1114:49S0000001.LOG-rw-r-----1db2int3db2grp20480Nov1114:49S0000002.LOG