db2inst1@gsidc-ywxt-lin03 C0000000]$ db2 get db cfg for GS_CLOUD |grep -i log
Log retain for recovery status = RECOVERY
User exit for logging status = YES
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
Log buffer size (4KB) (LOGBUFSZ) = 256
Log file size (4KB) (LOGFILSIZ) = 1024
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 4
Changed path to log files (NEWLOGPATH) =
Path to log files = /home/db2inst1/db2inst1/NODE0000/db2inst1/NODE0000/SQL00002/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0000004.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = OFF
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
First log archive method (LOGARCHMETH1) = DISK:/db2data/log_bin/
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Log pages during index build (LOGINDEXBUILD) = OFF
[db2inst1@gsidc-ywxt-lin03 C0000000]$ ls
S0000000.LOG S0000001.LOG S0000002.LOG S0000003.LOG
使用命令:db2 archive log for db GS_CLOUD 手动归档4个日志
[db2inst1@gsidc-ywxt-lin03 C0000000]$ ll -h
总计 48K
-rw-r----- 1 db2inst1 db2grp1 12K 10-29 22:05 S0000000.LOG
-rw-r----- 1 db2inst1 db2grp1 12K 10-30 15:39 S0000001.LOG
-rw-r----- 1 db2inst1 db2grp1 12K 10-30 16:42 S0000002.LOG
-rw-r----- 1 db2inst1 db2grp1 12K 10-30 16:42 S0000003.LOG
各位大侠给看看问题出在哪里
收起