Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message in db2diag.log after restore of database.

Status
Not open for further replies.

jip102

Programmer
May 1, 2006
12
KR
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 ....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top