I have a non production Database. I'm develop actually an application who will run with a Informix Database. The last week I imported a very big amount of records to the Database and now the logical log files are full. I get the following messages:
Logical Log Files are Full -- Backup is Needed.
I don't want to make a Backup because this is not a production database. Instead of that, I want just to clean all logical log files. How can I do that?
set your LTAPEDEV to /dev/null and perform ontape -a
in the future, if you are going to load a lot of data, either turn off logging, and you will not have a problem or use dbload to load the tables (it has a commit option) and run ontape -c for the continuous backup of logical logs
I did the changes on LTAPEDEV and ran ontape -a. The Database is always on Status "Fast Recovery". Till now ontape backuped just the Logical Log 1, I have have till the Logical Log 326. The Fast Recovery is on the Log 323. Should I wait? How can I fast as possible get again the Online Status?