Re: Help with logical logs . PLEASE!!!!!

Some activity is logged even if you do not have transaction logging turned on for a database. This includes any dat definition laguage(DDL) constructs such as create table, create index, etc. In version 7 I know you can direct temp table activity to a dbspace that will allow you to side step the logging of DDL for temp tables (see DBSPACETEMP). I can't recall if this option was available in version 4. Also remember that the logical logs for the online instance are shared between all databases. So if you have other databasdes on the system=20 that are logging they could also be adding information to the log. There is a cryptic utility called tblog that will show you the contents of the logical log (if you have some time). Hope this helps, Bill BS INTERSERVICE wrote: >=20 > Hello: > I=B4m working with an old version of on-line V.4.10 (yes 4.10 , i think= is a special > release of Siemens-Nixdorf) and my d.b is not transactional . > I have a program that work with temp tables ( create , insert , update = ) and have some > reports ( to printer and to file ) and when i run it my logical logs ge= t full at least 4 > of then (250 page size each). > I don=B4t understand why it get full with no transactions. >=20 > Thanks just for reading this . >=20 > Please could you send an answer by e-mail too : > willypo@svalero.es