IDS Forum

RE: Clear out temp space?

Posted By: John
Date: Monday, 13 November 2017, at 7:24 p.m.

In Response To: Clear out temp space? (DAVID GROVE)

=0ADavid:=0A=0AMy guess is you have active cursor against a query which doe=
s an order=0Aby of a large amount of data. Since sort files are NOT tables=
they will=0Anot show you much space is used or how many rows. The sort f=
ile will=0Anot be released until the query is closed. I am guessing server =
studio=0Ais looking at sysmaster partition statistics which will not reflec=
t how=0Amuch is used for sort files. In many case the sort file name will=
have=0Athe session or thread id embedded in side the name of the file.=0A=
=0AThe temp spaces are re-created each time the server boots. This was=0Aa=
dded in version 7.3 to make sure that the server cleaned up after=0Aitself.=
The reason why the temp spaces are recreated, is that it is=0Afaster to r=
e-create the temp space(s) than walk the temp space looking=0Afor space whi=
ch need to be cleaned up.=0A=0A=0AJohn=0A=0A-------- Original Message -----=
---=0ASubject: Clear out temp space? [40188]=0AFrom: "DAVID GROVE" <david.g=
rove@alaska.gov>=0ADate: Mon, November 13, 2017 2:35 pm=0ATo: ids@iiug.org=
=0A=0AInformix 12.10FC3 =0ASolaris 10 1/13 =0A=0AI had a user complaint, th=
is morning, about running out of temp space=0Awhen =0Aexecuting a query. =
=0A=0AI checked and noticed a few dozen system generated SORT tables, etc. =
The=0A=0Ainteresting thing was that Server Studio showed all of them as emp=
ty,=0Ayet they =0Astill consumed space. That is, about 5 GB of space had be=
en allocated,=0Abut the =0Aactual space occupied was listed as zero, in eve=
ry one of those bad=0Aboys. =0A=0AI wonder if there is some command that wi=
ll remove the detritus of=0Aunused, =0Asystem-generated temp tables. =0A=0A=
This was a test/development database server, so I could bounce it, and,=0Ao=
f =0Acourse, that immediately eliminated the problem. The user could then r=
un=0Ahis =0Aquery. No tables remain in the temp space after the query compl=
eted.=0A(All =0Acleaned up, as I would expect.) =0A=0ARegards, =0A=0ADG =0A=
=0A=0A*********************************************************************=
**********=0A=0A Forum Note: Use "Reply" to post a response in the discussi=
on forum.

Messages In This Thread

• Clear out temp space?
  DAVID GROVE -- Monday, 13 November 2017, at 5:35 p.m.
  • RE: Clear out temp space?
    John -- Monday, 13 November 2017, at 7:24 p.m.
    • Re: RE: Clear out temp space?
      DAVID GROVE -- Monday, 20 November 2017, at 2:26 p.m.
  • Re: Clear out temp space?
    Andreas Legner1 -- Tuesday, 14 November 2017, at 4:50 a.m.
    • Re: Clear out temp space?
      DAVID GROVE -- Monday, 20 November 2017, at 2:28 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.