软件开发日志 db2 9.7

log日志求解

2014-08-06-10.21.39.016117+480 I16383669E1637 LEVEL: EventPID : 21400 TID : 140390758266656PROC : db2startINSTANCE: db2inst1&...显示全部

2014-08-06-10.21.39.016117+480 I16383669E1637    LEVEL: Event
PID    : 21400             TID  : 140390758266656PROC : db2start
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x00007FFF193A4260 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x00007FFF193A4270 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x00007FFF193A4280 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0x00007FFF193A4290 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A42A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A42B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A42C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A42D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A42E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A42F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A4300 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A4310 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A4320 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A4330 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A4340 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00007FFF193A4350 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2014-08-06-10.21.39.270444+480 E16385307E329    LEVEL: Error (OS)
PID    : 21405             TID  : 139939815089952PROC : db2star2
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:100
CALLED  : OS, -, shmget                         OSERR: EEXIST (17)

2014-08-06-10.21.39.303949+480 E16385637E329    LEVEL: Error (OS)
PID    : 21405             TID  : 139939815089952PROC : db2star2
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:100
CALLED  : OS, -, shmget                         OSERR: EEXIST (17)

2014-08-06-10.21.39.382219+480 E16385967E383    LEVEL: Info
PID    : 21195             TID  : 140042244712192PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
EDUID : 25                EDUNAME: db2logmgr (HOSPOTDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S0000009.LOG.

2014-08-06-10.21.39.615741+480 E16386351E568    LEVEL: Error
PID    : 21195             TID  : 140042244712192PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
EDUID : 25                EDUNAME: db2logmgr (HOSPOTDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgUserexitLogAdminMsg, probe:1140
MESSAGE : ADM1832E  DB2 was unable to find the user exit program when archiving
      log file "S0000009.LOG" from
      "/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/" for database
      "HOSPOTDB".  The error code was "24".

2014-08-06-10.21.39.623899+480 E16386920E465    LEVEL: Warning
PID    : 21195             TID  : 140042244712192PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
EDUID : 25                EDUNAME: db2logmgr (HOSPOTDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150
MESSAGE : ADM1848W  Failed to archive log file "S0000009.LOG" to "USEREXIT"
      from "/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/".

2014-08-06-10.21.39.628489+480 E16387386E466    LEVEL: Error
PID    : 21195             TID  : 140042244712192PROC : db2sysc 0
INSTANCE: db2inst1          NODE : 000
EDUID : 25                EDUNAME: db2logmgr (HOSPOTDB) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3155
DATA #1 :
Failed to archive log file S0000009.LOG to USEREXIT from /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ return code 24.收起

关注1

参与11

查看其它 9 个回答justcode的回答

justcode软件开发工程师活点

回复 5# wonder_191

   Log retain for recovery status                         = NO
User exit for logging status                         = YES
Catalog cache size (4KB)             (CATALOGCACHE_SZ) = 300
Log buffer size (4KB)                      (LOGBUFSZ) = 256
Log file size (4KB)                      (LOGFILSIZ) = 4024
Number of primary log files             (LOGPRIMARY) = 23
Number of secondary log files             (LOGSECOND) = 14
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                                  = S0000074.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) = OFF
User exit for logging enabled             (USEREXIT) = ON
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
Log pages during index build          (LOGINDEXBUILD) = OFF

软件开发 · 2014-08-12

log日志求解

查看其它 9 个回答justcode的回答

回答者

justcode 最近回答过的问题

回答状态