RE:

You don't need to reset the number. Logs have two numbers associated with them (as obtained from the output of the onstat -l command): - number, which is the physical number assigned when the log was created. So most likely your logs would have numbers from 1 to 200 (if you've dropped or moved logs in the past, then the range may be different, since the engine doesn't re-use these physical numbers). - uniqid, which is a number assigned as the log is written to. The logs are written to in round-robin fashion, so over its lifetime any given log could have more than one uniqid. Best regards, Edmund Nigel Gall Senior Information Systems Specialist Process Plant Services Limited Atlantic Avenue, Point Lisas Industrial Estate Point Lisas, Couva, Trinidad & Tobago, W.I. Tel: (868) 636 2906 x 274 Fax: (868) 679 3770 -----Original Message----- From: sampath [mailto:sampath@gulfins.com.kw] Sent: Monday, November 06, 2000 12:32 AM To: informix-list@iiug.org Subject: Hi, Could someone tell me how to reset the logical log number to 1. We have 200 logs and we are havig number 17000 now. Thanks Sam