Re: Cannot delete records on SE5

MRSW wrote: > > I have a SE5 table with about 600,000 rows of records to delete. It will > only allow me to delete about 500-700 rows at a time. Any more rows the > db will complain (121) cannot write log record. I check the free mem and > the dfspace, both looks okay. Any suggestions? > > Justin SE can run out of locks quickly. Try LOCK TABLE. Another idea: if you are in a big transaction are you running out of open file handles? Try smaller transaction or reconfiguring the kernel with more open files per process. Peter -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.