Hello all,

I am unloading some tables on a nightly basis (via cron) from Informix
running on an HP-UX box. The script is static. Occasionally there will be
an error during the unload.

Example:

Error in line 7
Near character position 5
Error in line 101
Near character position 21

or

Error in line 78
Near character position 24

It is not consistantly dying in the same spot, and if I run it manually
afterward it runs fine. Most evenings these errors do not occur, weird.

Anyway, I suspect that another process may have a record locked. Is there a
way to report on this from the unload script?


Thanks,

Marc

Why locking a row;
maybe you can set isolation to dirty read; before executing the unload,

or maybe set lock mode to wait???? or.... lock the table ??

catch stuff from dbaccess:

(dbaccess <yourdb> yoursqlfile 2>&1 ) > somelogfile
may give you more info.


Superboer.




Marc Baker schreef:

> Hello all,
>
> I am unloading some tables on a nightly basis (via cron) from Informix
> running on an HP-UX box. The script is static. Occasionally there will be
> an error during the unload.
>
> Example:
>
> Error in line 7
> Near character position 5
> Error in line 101
> Near character position 21
>
> or
>
> Error in line 78
> Near character position 24
>
> It is not consistantly dying in the same spot, and if I run it manually
> afterward it runs fine. Most evenings these errors do not occur, weird.
>
> Anyway, I suspect that another process may have a record locked. Is there a
> way to report on this from the unload script?
>
>
> Thanks,
>
> Marc