Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Unanswered: Temp Dbspaces : error 571 unless free space


    We observe the following : we have 5 temp dbspaces of which tmpdbs1-2-3 are 660 Mb large, and tmpdbs4-5 are 2 Gb large.
    We keep on getting informix error 567 (no free space for sort), although there is plenty of free space in the tmpdbs's 1,3,4,5 and only tmpdbs2 is full.

    My questions.

    1) Would it be so that the error 567 is triggered as soon as one tmpdbs is full ?
    2) does this have to do with not equally filling the dbspaces because of the size difference ?
    3) how can I find out which session/user/? is responsible for the tables that fill up the temp dbspace ?
    4) is it possible that temporary tables are not removed because of abnormal transaction ends ?

    PS: the onconfig file is OK

    best regards,

  2. #2
    Join Date
    Aug 2003
    Hi Erwin,

    I think that is convenient that you remove dbspace temp 1,2,3 and recreate one more size.


Posting Permissions

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