Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    18

    Unanswered: How to clean Logical log files

    Hello,

    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?

    Best Regards

    Alfredo

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    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
    Last edited by artemka; 10-25-04 at 10:45.

  3. #3
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    18

    Fast Recovery

    Hello,

    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?

    Best Regards

    Alfredo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •