Can you paste the output of following commands:
1) db2 get db cfg for <your database name>
2) db2level
Regards,
Divakar
"Ntsakane
Matsebatlela "
<db2udbdba-ezmlms To
hield-x5288926.x1 "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
.com> cc
27/02/2007 17:52 Subject
Backup failure
NB: This email and its contents are subject to our email legal notice
which can be viewed at http://www.sars.gov.za/Email_Disclaimer.pdf
----
Im new on DB2 and TSM guys are complaining that back ups are failing and
when I check the diag.log file I find the following
2007-02-26-19.35.41.752692+120 I176670360A358 LEVEL: Error
PID : 19090 TID : 549829921888PROC : db2lfr (BWP) 0
INSTANCE: db2bwp NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgolf, probe:220
RETCODE : ZRC=0x870F0011=-2029060079=SQLO_PATH "an invalid path"
DIA8514C An invalid file path, "", was specified.
2007-02-26-19.35.41.896439+120 I176670719A519 LEVEL: Error
PID : 19090 TID : 549829921888PROC : db2lfr (BWP) 0
INSTANCE: db2bwp NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgolf, probe:220
MESSAGE : Filename :
DATA #1 : Hexdump, 42 bytes
0x000001FFFFFFB628 : 2F64 6232 2F42 5750 2F6C 6F67 5F61 7263
/db2/BWP/log_arc
0x000001FFFFFFB638 : 6869 7665 2F4E 4F44 4530 3030 302F 5330
hive/NODE0000/S0
0x000001FFFFFFB648 : 3030 3337 3235 2E4C 4F47
003725.LOG
2007-02-26-19.35.41.927603+120 I176671239A297 LEVEL: Error
PID : 19090 TID : 549829921888PROC : db2lfr (BWP) 0
INSTANCE: db2bwp NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgole, probe:1710
MESSAGE : Error -2029060079 opening database log extent 3725:
.
.
.
2007-02-26-19.35.42.641579+120 E176672361A490 LEVEL: Error
PID : 15810 TID : 549829921888PROC : db2bm.15790.0 0
INSTANCE: db2bwp NODE : 000 DB : BWP
APPHDL : 0-1118 APPID: *LOCAL.db2bwp.070226161638
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:1917
MESSAGE : ADM8010E Backup was unable to copy requested log file
"S0003725.LOG"
for inclusion in the backup image. The backup has been
aborted.
2007-02-26-19.35.42.642215+120 I176672852A384 LEVEL: Error
PID : 15810 TID : 549829921888PROC : db2bm.15790.0 0
INSTANCE: db2bwp NODE : 000 DB : BWP
APPHDL : 0-1118 APPID: *LOCAL.db2bwp.070226161638
MESSAGE : Current extent:
DATA #1 : Hexdump, 4 bytes
0x000001FFFFFFBFB8 : 0000 0E8D ....
2007-02-26-19.35.42.648158+120 I176673237A451 LEVEL: Severe
PID : 15810 TID : 549829921888PROC : db2bm.15790.0 0
INSTANCE: db2bwp NODE : 000 DB : BWP
APPHDL : 0-1118 APPID: *LOCAL.db2bwp.070226161638
FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent, probe:1979
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x00000080046B3AF0 : FFFF F684 ....
2007-02-26-19.35.55.868268+120 E176675772A364 LEVEL: Warning
PID : 19081 TID : 549829921888PROC : db2logmgr (BWP)
0
INSTANCE: db2bwp NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgCleanFailArchPath, probe:4920
DATA #1 : <preformatted>
Unable to find log file 3726 for LOGARCHMETH1. Assume log was archived
and continue.
Can you please help
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page