Hi,
I interrupted running a sql batch file containing several insert
statements.
The db server stops responding to any commands and just hangs.
The entries in the log file are as below, Any idea what could be
happening or any troubleshooting tips ?

------------------
2004-03-06-11.51.16.095814 Instance:db2inst1 Node:000
PID:1215(db2cart) TID:8192 Appid:none
data protection sqlpgart Probe:1818

An error was received from the user exit program.1800 0000
------------------

circular logging is in effect.Version 8.1 on linux.
Thanks,
Hype.

"hype" <hypehoopla@yahoo.com> wrote in message
news:71c621b6.0403060901.58492282@posting.google.c om...
> Hi,
> I interrupted running a sql batch file containing several insert
> statements.
> The db server stops responding to any commands and just hangs.
> The entries in the log file are as below, Any idea what could be
> happening or any troubleshooting tips ?
>
> ------------------
> 2004-03-06-11.51.16.095814 Instance:db2inst1 Node:000
> PID:1215(db2cart) TID:8192 Appid:none
> data protection sqlpgart Probe:1818
>
> An error was received from the user exit program.1800 0000
> ------------------
>
> circular logging is in effect.Version 8.1 on linux.
> Thanks,
> Hype.

If you have defined a user exit program for logging, circular logging is NOT
in effect.

Do a:
get db config for database-name

Theses parms must look like this for circular logging:
Log retain for recovery status = NO
User exit for logging status = NO

If there is a user exit program defined, and you want circular logging,
update the user exit parm.