WITH NO LOG question
Posted in 1993
Hi, We have run into difficulties when running ACE reports using the WITH NO LOG command. The reports in question pull together data which is contained in a large number of financial tables, and we are obliged to use temporary tables a great deal. We have found that for reports containing more than 10 temporary tables, the WITH NO LOG command does not function correctly. TEMP tables 11, 12, 13 etc. are logged, and have to be physically dropped (they also clear when ISQL is exited). Has anyone else encountered this problem? What is happening is that our DBSPACE drops drastically each time one of these reports is run, and performance deteriorates. We are running ISQL 4.10.UD2 ________________________________________________________________________________ John O'Sullivan EMAIL : osullivj@sandoz.ueci.com AISE Dept. PHONE : 021 378601 extn. 2617 SANDOZ RINGASKIDDY LTD. FAX : 021 378658 Republic Of Ireland ________________________________________________________________________________