Re: hanging while loading rows???

Jon Drukman wrote: > > In article <31E9D1CF.1E00@west.co.za>, Mark D Stock <marks@west.co.za> wrote: > > You don't say which engine you are running, but if it is OnLine then > > are the logical logs full? How large is 'slightly large'? > > i'm running online. slightly large is < 2K > > if the logical logs are full > a) how do i tell and > b) how do i empty them? Up to version 7.10.UC1 you can use 'onstat -l' to list the logs and their usage. If you are using version 5.xx or older, then use 'tbstat -l'. From version 7.10.UD1 you have to look in the sysmaster database at a table called syslogs (I think). The log usage is not updated for onstat anymore, but syslogs has the actual usage. To back them up, check your tape device in onmonitor (tbmonitor). Then use 'ontape -a' to backup all full logs, or 'tbtape -a' for version 5.xx and older. If you use a tape device of '/dev/null' the logs will 'disappear', so I suspect you have a device defined. Up to version 7.1x.xx you can still use the 'tb' commands which are just links to the 'on' commands. Hope this helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+