Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Question Unanswered: informix database filling up rapidly

    Hi Gurus,

    I am facing a strange problem with informix database growth patterns.
    We are using Version 9.21.UC7XO for our application database.

    Normally application tables grow at rate of 1% per day. But recently we
    hit with 80% growth in database within a week time. Comparing the application data tables size dump taken at start and end of this period showed normal growth only.

    Suspecting some temporary tables eating up db space and causing rapid growth. Find some tables in our application database created with name like:

    _temptable
    3116_2401
    3130_2414

    These are occupying considerable space in dbspace.
    Please help me in understanding what these tables are and how they will be created and their impact.

    Thanks,
    Kamesh

  2. #2
    Join Date
    Nov 2005
    Location
    Belgium
    Posts
    3
    Hi Kamesh,

    "These are occupying considerable space in dbspace"
    Which dbspace temp, data, root ?

    It seems like internal table or index link on constraints for the two 3116_2401 & 3130_2414.

    For the _temptable i have no real idea but i search .

    Bye
    Hubert

  3. #3
    Join Date
    Aug 2004
    Posts
    5
    Hi

    Check if you DBSPACETEMP is set in your env.

    If not then create temp dbspace & set DBSPACETEMP to these values.

Posting Permissions

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