HPL V7.23 UC1

Hi, I am loading with HPL in express mode a table in a database with buffered logging. The table has 1 unique index on debitor defined as dbtnr decimal(10,0) not null constraint "informix".n101_4, The table is fragment by round robin in zv1, zv2, zv3 extent size 278 next size 27 lock mode page; create unique index "informix".dbtnrdbtidx on "informix".debitor (dbtnr) in zv4; The first load is OK. Now i am trying to load the same data aging just to see how HPL handles duplicate keys. What happens is very interesting: HPL reports: 16:36:39 Records Processed -> 320000 16:36:39 Records Processed -> 330000 SQL error -255 ISAM error 0 executing statement rollback workCannot set mode of indexes objects '"informix".dbtnrdbtidx, "informix".kdnrdbtidx' to enabled mode, SQL error -458, ISAM error 0 Reset mode of triggers "informix".trinsdebitor to original enabled mode Reset mode of triggers "informix".trupddebitor to original enabled mode Reset mode of triggers "informix".trdeldebitor to original enabled mode Cannot re-enable all objects, 0 violations detected, check for violations in violations table 'debitor_vio' and diagnostics table 'debitor_dia' Table 'debitor' will be read-only until level 0 archive Database Load Completed -- Processed 330784 Records Records Inserted-> 330784 Detected Errors--> 0 Engine Rejected--> 0 Mon Mar 15 16:41:20 1999 But I see no debitor_vio and no debitor_dia in my database. On the other hand I have a log transaction and a switch on logical buffers. INFORMIX-OnLine Version 7.23.UC1 -- On-Line -- Up 03:54:53 -- 135968 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 3 16 68047 4293 15.85 phybegin physize phypos phyused %used 10003f 50000 10504 11679 23.36 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 6 16 824941 19602 1612 42.1 12.2 address number flags uniqid begin size used %used 2355a9e4 1 U---C-L 7 10c38f 7250 2997 41.34 2355aa00 2 U-B---- 5 10dfe1 7250 7250 100.00 2355aa1c 3 U-B---- 6 10fc33 7250 7250 100.00 mora@zvm:~> onstat -l INFORMIX-OnLine Version 7.23.UC1 -- On-Line (LONGTX) -- Up 03:56:34 -- 135968 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 12 16 71508 4509 15.86 phybegin physize phypos phyused %used 10003f 50000 13956 3260 6.52 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 8 16 1114446 26600 2050 41.9 13.0 address number flags uniqid begin size used %used 2355a9e4 1 U-B---- 7 10c38f 7250 7250 100.00 2355aa00 2 U---C-L 8 10dfe1 7250 2745 37.86 2355aa1c 3 U-B---- 6 10fc33 7250 7250 100.00 The following is in my message log file: 16:19:11 Checkpoint Completed: duration was 0 seconds. 16:25:18 'mora' - New logging mode: BUFFERED 16:25:51 Checkpoint Completed: duration was 0 seconds. 16:26:01 Checkpoint Completed: duration was 0 seconds. 16:31:11 Checkpoint Completed: duration was 0 seconds. 16:35:21 Checkpoint Completed: duration was 0 seconds. 16:35:31 Checkpoint Completed: duration was 0 seconds. 16:36:30 Checkpoint Completed: duration was 3 seconds. 16:36:40 Checkpoint Completed: duration was 0 seconds. 16:40:04 Logical Log 7 Complete. 16:40:05 Process exited with return code 133: /bin/sh /bin/sh -c /opt/informix/etc/log_full.sh 2 23 "Logical Log 7 Complete." "Logical Log 7 Complete." 16:40:11 Checkpoint Completed: duration was 1 seconds. 16:40:11 Aborting Long Transaction: tx 0x27585b78 username: mora uid:1004 Why can`t I simply get the message from HPL that it can not enable the unique index because of dup keys? Thanks in advance Monika Rabold Bull GmbH Langen Tel: 06103/761-4225 email: mora@swh600.langen.bull.de