Hi all,
After a full offline restore of my dev database which reported as
completed successfully, I have got the following messages in
db2diag.log.
Can anyone please help me understand these error messages and what is
the impact on my database?
2006-01-06-10.35.56.272155+240 I7308494A422 LEVEL: Warning
PID : 880842 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-207 APPID: *LOCAL.db2dwdev.060106063541
FUNCTION: DB2 UDB, database utilities, sqludPrintStartingMsg, probe:1
DATA #1 : String, 52 bytes
Starting a full database restore.
Agent PID: 880842
2006-01-06-10.35.56.272792+240 I7308917A450 LEVEL: Severe
PID : 880842 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-207 APPID: *LOCAL.db2dwdev.060106063541
FUNCTION: DB2 UDB, database utilities, sqluCompareDB, probe:45
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0780000022FB8E18 : 0000 09EB ....
2006-01-06-11.10.00.174301+240 I7309368A360 LEVEL: Warning
PID : 880842 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-207 APPID: *LOCAL.db2dwdev.060106063541
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:100
MESSAGE : Restore Complete.
2006-01-06-11.11.45.638754+240 E7309729A415 LEVEL: Error (OS)
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EEXIST (17) "File exists"
2006-01-06-11.11.45.645334+240 E7310145A417 LEVEL: Error (OS)
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EBADF (9) "Bad file number"
2006-01-06-11.11.46.445297+240 I7310563A508 LEVEL: Warning
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, PSM - SQL Procedure, psm_recover_all_procs, probe:10
MESSAGE : SQL procedure executables recovery has been initiated.
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEE990 : 4457 4445 5632 2020 DWDEV2
2006-01-06-11.11.46.455422+240 E7311072A417 LEVEL: Error (OS)
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EBADF (9) "Bad file number"
2006-01-06-11.11.46.464234+240 E7311490A417 LEVEL: Error (OS)
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EBADF (9) "Bad file number"
2006-01-06-11.11.46.988119+240 I7311908A497 LEVEL: Warning
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, PSM - SQL Procedure, psm_recover_all_procs, probe:900
MESSAGE : SQL procedure executables recovery ended. RC:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFEE980 : 0000 0000 ....
After a full offline restore of my dev database which reported as
completed successfully, I have got the following messages in
db2diag.log.
Can anyone please help me understand these error messages and what is
the impact on my database?
2006-01-06-10.35.56.272155+240 I7308494A422 LEVEL: Warning
PID : 880842 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-207 APPID: *LOCAL.db2dwdev.060106063541
FUNCTION: DB2 UDB, database utilities, sqludPrintStartingMsg, probe:1
DATA #1 : String, 52 bytes
Starting a full database restore.
Agent PID: 880842
2006-01-06-10.35.56.272792+240 I7308917A450 LEVEL: Severe
PID : 880842 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-207 APPID: *LOCAL.db2dwdev.060106063541
FUNCTION: DB2 UDB, database utilities, sqluCompareDB, probe:45
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0780000022FB8E18 : 0000 09EB ....
2006-01-06-11.10.00.174301+240 I7309368A360 LEVEL: Warning
PID : 880842 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-207 APPID: *LOCAL.db2dwdev.060106063541
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:100
MESSAGE : Restore Complete.
2006-01-06-11.11.45.638754+240 E7309729A415 LEVEL: Error (OS)
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EEXIST (17) "File exists"
2006-01-06-11.11.45.645334+240 E7310145A417 LEVEL: Error (OS)
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EBADF (9) "Bad file number"
2006-01-06-11.11.46.445297+240 I7310563A508 LEVEL: Warning
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, PSM - SQL Procedure, psm_recover_all_procs, probe:10
MESSAGE : SQL procedure executables recovery has been initiated.
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEE990 : 4457 4445 5632 2020 DWDEV2
2006-01-06-11.11.46.455422+240 E7311072A417 LEVEL: Error (OS)
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EBADF (9) "Bad file number"
2006-01-06-11.11.46.464234+240 E7311490A417 LEVEL: Error (OS)
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, oper system services, sqloexec2, probe:2
CALLED : OS, -, unspecified_system_function
OSERR : EBADF (9) "Bad file number"
2006-01-06-11.11.46.988119+240 I7311908A497 LEVEL: Warning
PID : 680008 TID : 1 PROC : db2agent
(DWDEV2) 0
INSTANCE: db2dwdev NODE : 000 DB : DWDEV2
APPHDL : 0-209 APPID: AC1269BB.B104.014646071131
FUNCTION: DB2 UDB, PSM - SQL Procedure, psm_recover_all_procs, probe:900
MESSAGE : SQL procedure executables recovery ended. RC:
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFEE980 : 0000 0000 ....