Pervasive 2000i data recovery question

My application uses an ODBC connection to insert data into a 2000i SP4
database table acquired from external industrial equipment. A totalizer
register in one field device exceeded 32767 for a column defined as a real
value and the inserts began to fail with a column data range exceeded type
error. This occurred over a weekend and the plant personal did not catch
the error for 2 days. After poking around a bit, I found a series of log
files in the pvsw\bin\mkde\log folder. Browsing these files with a text
editor shows several entries for the table but the data is represented in
binary and therefore is not readable. We desperately need to view certain
table column values from the missing days for governmental reporting
purposes. I understand that the logs are associated with the Transaction
Durability feature, but if a column data type value is exceeded, restarting
the database engine would not allow the records to be rolled into the table.

My questions are:

1. Would an SQL insert failure, due to an exceeded column value, result in
the data being written to the mentioned logs?

2. If the data is in the logs, is there any browser utility that can
display the log contents in readable format?

3. If the logs cannot be viewed, can anyone provide a layout of these logs
so I could access them programmatically?

4. If there is no way to access the logs external from Pervasive, can I
alter the table column from a real data type to a long integer and force a
Pervasive recovery?

My environment is:
WinXP, SP1
2000i SP4 Workgroup license.

Thanks to anyone that can assist us with the recovery of this critical data.

Kelly W. Zini
Control Products Unlimited, Inc.


.

Relevant Pages

  • Re: Dynamic Firewall/IDS System
    ... some thoughts about event handling software. ... > is almost impossible to handle manually just reading logs. ... > This is how we fill our database. ... this is logging, way like acid does with snort logs. ...
    (FreeBSD-Security)
  • Re: Exchange - Huge (x10) mismatch between size of priv1.edb and actual size of mailboxes in mai
    ... about 40 transaction logs. ... I think client actions that read from the database are ... mailboxes and the system is not that old. ...
    (microsoft.public.windows.server.sbs)
  • Re: Error in Exchange
    ... Will you provide me some linkes to get more info about the role these logs ... play in .edb file or with database and how information is saved into .edb ... > backup on Sept 8. ... > transaction logs are saved in that backup. ...
    (microsoft.public.exchange.admin)
  • Re: Exchange - Huge (x10) mismatch between size of priv1.edb and actual size of mailboxes in mai
    ... no new logs for the last 5 hours. ... about 40 transaction logs. ... I think client actions that read from the database ... mailboxes and the system is not that old. ...
    (microsoft.public.windows.server.sbs)
  • Re: Minimizing backup induced downtime
    ... With that magical RMAN thing, how will you be able to recover ... take a backup of an Oracle database without the need for having ... I am running the databases in archive log mode and I know what it is. ... that the logs aren't backed up. ...
    (comp.databases.oracle.server)