Re: archecker - non-existing table - part III
Hi,
after another checking:
NOT ONLY table t_sez pac is error reported, the other reported
tables are temporary, too.
It looks archecker does not correctly recognizes temporary tables
and reports their missing pages as error.
Can anybody confirm this ?
Michal Hajek
>
> this I wrote a few day ago:
>
> >archecker -V
> >Program Name: archecker
> >Version: 4.5
> >Released: 09/21/99 00:12
> >Compiled: 09/21/99 00:16 on HP-UX B.10.20 U
> >
> >a piece from log:
> >STATUS: Checking uh:t_sez_pac
> >ERROR: Page 0x00613692 not found in bitmaps
> >ERROR: Table uh:t_sez_pac partnum 0x0020188A missing physical page 0x00613692
> >
> >Checking table t_sez_pac appears 276 times in log.
> >End of log:
> >TIME: [10/27/2000 09:28:06] Checking Completed
> >STATUS: Tables/Fragments validated: 1912
> >STATUS: Tables with missing data: 276
> >STATUS: Total missing pages: 12554
> >Archive Validation Failed.
> >
> >There is not (and never was, AFAIK) table t_sez_pac in any our
> >DBs.
> >
> >Is it archecker bug, or IDS problem ? We run oncheck -pT, oncheck
> >-cwI every month, no problem reported.
>
> Meanwhile I found the table t_sez_pac is really a table in DB,
> it is temporary table created by some application(s ?).
> OK, archecker is not wrong in identifying the table, but what
> am I to do ? Is archive OK ? Has archecker a bug ? Does it mean
> that the application(s) do not handle temp tables correctly ?
>
--
--------------------------------------------------------------
Michal Hajek mailto:hajek@nspuh.cz
Sprava NIS http://www.nspuh.cz
NsP Uherske Hradiste phone : voice +420 0632 529 204
Purkynova 365 fax +420 0632 551 014
686 68 Uherske Hradiste Czech Republic ICQ UIN: 14290832
--------------------------------------------------------------