请教有关日志问题
为什么日志文件数量不断增加?现已超过90,原已设置LOGRETAIN=OFF,USEREXIT= OFF数据库参数配置如下:
Database Configuration for Database db
Database configuration release level = 0x0800
Database release level = 0x0800
Database territory = cn
Database code page = 1386
Database code set = GBK
Database country code = 86
Directory object name (DIR_OBJ_NAME) =
Discovery support for this database (DISCOVER_DB) = ENABLE
Degree of parallelism (DFT_DEGREE) = 1
Default query optimization class (DFT_QUERYOPT) = 5
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20
Backup pending = NO
Database is consistent = NO
Rollforward pending = NO
Restore pending = NO
Multi-page file allocation enabled = NO
Log retain for recovery status = NO
User exit for logging status = NO
Datalink Access Token Expiry Interval (sec) (DL_EXPINT) = 60
Datalink Number of Copies (DL_NUM_COPIES) = 1
Datalink Number of Backups (DL_NUM_BACKUP) = 1
Datalink Time after Drop (days) (DL_TIME_DROP) = 1
Database heap (4KB) (DBHEAP) = 1200
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 64
Log buffer size (4KB) (LOGBUFSZ) = 8
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
Buffer pool size (4KB) (BUFFPAGE) = 2000
Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
Number of extended storage segments (NUM_ESTORE_SEGS) = 0
Max storage for lock list (4KB) (LOCKLIST) = 100
Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 128
Sort list heap (4KB) (SORTHEAP) = 256
SQL statement heap (4KB) (STMTHEAP) = 2048
Default application heap (4KB) (APPLHEAPSZ) = 256
Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8)
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Percent. of lock lists per application (MAXLOCKS) = 10
Lock timeout (sec) (LOCKTIMEOUT) = -1
Changed pages threshold (CHNGPGS_THRESH) = 60
Number of asynchronous page cleaners (NUM_IOCLEANERS) = 1
Number of I/O servers (NUM_IOSERVERS) = 3
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (4KB) (DFT_PREFETCH_SZ) = 32
Default number of containers = 1
Default tablespace extentsize (4KB) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = 60
Average number of active applications (AVG_APPLS) = 1
Max DB files open per application (MAXFILOP) = 64
Log file size (4KB) (LOGFILSIZ) = 3000
Number of primary log files (LOGPRIMARY) = 3
Number of secondary log files (LOGSECOND) = 2
Changed path to log files (NEWLOGPATH) =
Path to log files = /home/NODE/
Next active log file =
First active log file =
Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF
Auto restart enabled (AUTORESTART) = ON
Index re-creation time (INDEXREC) = SYSTEM (RESTART)
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Recovery history retention (days) (REC_HIS_RETENTN) = 366
ADSM management class (ADSM_MGMTCLASS) =
ADSM node name (ADSM_NODENAME) =
ADSM owner (ADSM_OWNER) =
ADSM password (ADSM_PASSWORD) = Those are active/inactive transaction logs; You should try to archive them to somewhere.
回复 #2 winstonzhou 的帖子
请问如何archive them 以前的归档日志文件.移走就是. 晕！LOGRETAIN=OFF,USEREXIT= OFF，那么用的是循环日志，哪有什么归档问题啊？
页:
[1]