As I wrote last week, we have a problem with a DB2 V8 on Linux. Here is
what is in db2diag.log during online backup:
Starting a full database backup.
2004-04-01-02.33.54.760164 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
TailPage 0 does not match pagelsn 0023CEBF0FFB and firstlsn 0023CEBF8000
PID:1293 TID:1024 Node:000 Title: SQLP_DBCB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
PID:1293 TID:1024 Node:000 Title: SQLP_LFPB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
2004-04-01-02.33.55.588325 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.636770 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:1350
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.638569 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgasn2 Probe:1880
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.690121 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
TailPage 0 does not match pagelsn 0023CEBF0FFB and firstlsn 0023CEBF8000
PID:1293 TID:1024 Node:000 Title: SQLP_DBCB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
PID:1293 TID:1024 Node:000 Title: SQLP_LFPB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
2004-04-01-02.33.55.698624 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.700536 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:1350
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.701645 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgasn2 Probe:1520
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.750096 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
TailPage 0 does not match pagelsn 0023CEBF0FFB and firstlsn 0023CEBF8000
PID:1293 TID:1024 Node:000 Title: SQLP_DBCB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
PID:1293 TID:1024 Node:000 Title: SQLP_LFPB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
2004-04-01-02.33.55.784768 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.786897 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:1350
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.788458 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgasn2 Probe:1520
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.830150 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
TailPage 0 does not match pagelsn 0023CEBF0FFB and firstlsn 0023CEBF8000
PID:1293 TID:1024 Node:000 Title: SQLP_DBCB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
PID:1293 TID:1024 Node:000 Title: SQLP_LFPB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
2004-04-01-02.33.55.838766 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.840357 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:1350
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.841499 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgasn2 Probe:1520
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.890125 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
TailPage 0 does not match pagelsn 0023CEBF0FFB and firstlsn 0023CEBF8000
PID:1293 TID:1024 Node:000 Title: SQLP_DBCB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
PID:1293 TID:1024 Node:000 Title: SQLP_LFPB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
2004-04-01-02.33.55.898940 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.900623 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:1350
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.901914 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgasn2 Probe:1520
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.950091 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
TailPage 0 does not match pagelsn 0023CEBF0FFB and firstlsn 0023CEBF8000
PID:1293 TID:1024 Node:000 Title: SQLP_DBCB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
PID:1293 TID:1024 Node:000 Title: SQLP_LFPB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
2004-04-01-02.33.55.960600 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.963114 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:1350
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.55.965105 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgasn2 Probe:1520
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.56.022268 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
TailPage 0 does not match pagelsn 0023CEBF0FFB and firstlsn 0023CEBF8000
PID:1293 TID:1024 Node:000 Title: SQLP_DBCB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
PID:1293 TID:1024 Node:000 Title: SQLP_LFPB
Dump File:/home/lzgneu/sqllib/db2dump/12931024.000
2004-04-01-02.33.56.045394 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:909
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.56.065177 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgwlp Probe:1350
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.56.075595 Instance:lzgneu Node:000
PID:1293(db2loggw (TELEMATX)) TID:1024 Appid:none
data protection sqlpgasn2 Probe:1520
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000D
2004-04-01-02.33.56.162526 Instance:lzgneu Node:000
PID:6302(db2agent (idle)) TID:1024 Appid:*LOCAL.lzgneu.075DF1003202
database utilities sqlubcka Probe:130 Database:TELEMATX
Backup Complete.
Now we have an online backup, but _no_ log files since the timestamp of
this backup. The database was completely inoperable, and restoring the
online backup did not succeed because of missing log files.
What does this "TailPage" error mean? It is the first time I see this
error. Is it a hardware problem with the disk? Or what could be the
reason?
Please help!
Regards,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: +49-7245-9287-21, Fax: +49-7245-9287-30