恢复db2uncatlog_DB2异机恢复

[db2inst1@app ~]$ db2

"get db cfg for cmsdb"

Database

Configuration for Database cmsdb

Database configuration

release level                    =

0x0b00

Database release level                                  = 0x0b00

Database territory                                      = CN

Database code page                                      = 1386

Database code set                                       = GBK

Database country/region

code                            = 86

Database collating

sequence                             =

UNIQUE

Alternate collating

sequence              (ALT_COLLATE) =

Database page size                                      = 4096

Dynamic SQL Query

management           (DYN_QUERY_MGMT) =

DISABLE

Discovery support for this

database       (DISCOVER_DB) = ENABLE

Restrict access                                         = NO

Default query optimization

class         (DFT_QUERYOPT) = 5

Degree of parallelism                      (DFT_DEGREE) = 1

Continue upon arithmetic

exceptions   (DFT_SQLMATHWARN) = NO

Default refresh age                   (DFT_REFRESH_AGE) = 0

Default maintained table

types for opt (DFT_MTTB_TYPES) = SYSTEM

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                      = YES

Log retain for recovery

status                          =

RECOVERY

User exit for logging

status                            = YES

Self tuning memory                    (SELF_TUNING_MEM) = ON

Size of database shared

memory (4KB)  (DATABASE_MEMORY) =

COMPUTED

Database memory

threshold               (DB_MEM_THRESH)

= 10

Max storage for lock list

(4KB)              (LOCKLIST) =

AUTOMATIC

Percent. of lock lists per

application       (MAXLOCKS) = AUTOMATIC

Package cache size

(4KB)                   (PCKCACHESZ) =

AUTOMATIC

Sort heap thres for shared

sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC

Sort list heap (4KB)                         (SORTHEAP) =

AUTOMATIC

Database heap (4KB)                            (DBHEAP) = 2456

Catalog cache size

(4KB)              (CATALOGCACHE_SZ) =

260

Log buffer size (4KB)                        (LOGBUFSZ) = 98

Utilities heap size

(4KB)                (UTIL_HEAP_SZ) =

25906

Buffer pool size

(pages)                     (BUFFPAGE)

= 1000

Max size of appl. group mem

set (4KB) (APPGROUP_MEM_SZ) = 30000

Percent of mem for appl.

group heap   (GROUPHEAP_RATIO) = 70

Max appl. control heap size

(4KB)     (APP_CTL_HEAP_SZ) = 128

SQL statement heap

(4KB)                     (STMTHEAP) =

8192

Default application heap

(4KB)             (APPLHEAPSZ) = 4096

Statistics heap size

(4KB)               (STAT_HEAP_SZ) =

4384

Interval for checking

deadlock (ms)         (DLCHKTIME) =

10000

Lock timeout (sec)                        (LOCKTIMEOUT) = -1

Changed pages

threshold

(CHNGPGS_THRESH) = 80

Number of asynchronous page

cleaners   (NUM_IOCLEANERS) = AUTOMATIC

Number of I/O servers                   (NUM_IOSERVERS) = AUTOMATIC

Index sort flag                             (INDEXSORT) =

YES

Sequential detect flag                      (SEQDETECT) = YES

Default prefetch size

(pages)         (DFT_PREFETCH_SZ) =

AUTOMATIC

Track modified pages                         (TRACKMOD) = ON

Default number of

containers                            =

1

Default tablespace

extentsize (pages)   (DFT_EXTENT_SZ) =

32

Max number of active

applications            (MAXAPPLS) =

AUTOMATIC

Average number of active

applications       (AVG_APPLS) =

AUTOMATIC

Max DB files open per

application            (MAXFILOP) = 64

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/SQL00001/SQLOGDIR/

Overflow log path                     (OVERFLOWLOGPATH) =

Mirror log path                         (MIRRORLOGPATH) =

First active log file                                   =

S0004469.LOG

Block log on disk full                (BLK_LOG_DSK_FUL) = NO

Percent max primary log space

by transaction  (MAX_LOG) = 0

Num. of active log files

for 1 active UOW(NUM_LOG_SPAN) = 0

Group commit count                          (MINCOMMIT) = 1

Percent log file reclaimed

before soft chckpt (SOFTMAX) = 520

Log retain for recovery

enabled             (LOGRETAIN) = RECOVERY

User exit for logging

enabled                (USEREXIT) = ON

HADR database role                                      =

STANDARD

HADR local host name                  (HADR_LOCAL_HOST) =

HADR local service

name                (HADR_LOCAL_SVC) =

HADR remote host name                (HADR_REMOTE_HOST) =

HADR remote service

name              (HADR_REMOTE_SVC) =

HADR instance name of

remote server  (HADR_REMOTE_INST) =

HADR timeout value                       (HADR_TIMEOUT) = 120

HADR log write

synchronization mode

(HADR_SYNCMODE) = NEARSYNC

First log archive

method                 (LOGARCHMETH1) =

USEREXIT

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

Vendor options                              (VENDOROPT) =

Auto restart enabled                      (AUTORESTART) = ON

Index re-creation time and

redo index build  (INDEXREC) = SYSTEM

(RESTART)

Log pages during index

build            (LOGINDEXBUILD) = OFF

Default number of loadrec

sessions    (DFT_LOADREC_SES) = 1

Number of database backups

to retain   (NUM_DB_BACKUPS) = 12

Recovery history retention

(days)     (REC_HIS_RETENTN) = 366

TSM management class                    (TSM_MGMTCLASS) =

TSM node name                            (TSM_NODENAME) =

TSM owner

(TSM_OWNER) =

TSM password                             (TSM_PASSWORD) =

Automatic maintenance                      (AUTO_MAINT) = ON

Automatic database

backup            (AUTO_DB_BACKUP) =

OFF

Automatic table

maintenance          (AUTO_TBL_MAINT) =

ON

Automatic runstats                  (AUTO_RUNSTATS) = ON

Automatic statistics

profiling    (AUTO_STATS_PROF) = OFF

Automatic profile

updates         (AUTO_PROF_UPD) = OFF

Automatic

reorganization

(AUTO_REORG) = OFF