Re: bcheck in a Unix cron job produces error

In article <3t1ot2$gb1@miso.wwa.com> john@miso.wwa.com "pinoy_ako" writes: > Hello, > We have SE v5.12 and ISQL/I4GL v4.12. I have set up a cron job > in Unix to do a bcheck on all the files in the > $DBPATH/[database-name].dbs directory at 3:00 AM Monday to Friday. > The result is mailed to me. My problem is that the output includes the > following line: > > ERROR: bad data record > > My questions are: > > 1. Does anyone know what causes this? Yes it's a corruption. > But what > I taught them to do now is to use kill -5 (not 9!) on the > sqlexec process. Not on the parent of the 'sqlexec' process? Are you sure it rolls back properly doing this? > 2. Does anyone know how to fix this 'ERROR' besides typing > bcheck -s [some-table-name] in the DBPATH directory? I think you mean 'bcheck -y'. Try this twice (second time to see if table is REALLY mended). If that doesn't work, create the schema with 'dbschema', unload, drop, recreate, reload & reindex the table. If the table is of any size, turn off transaction logging first by updating 'tabtype' for the 'syslog' row in 'systables' to 'z' (a value Informix doesn't understand). -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================