SAP Mix

64bit IDS and TMPdbs ?

Posted By: Randy Barbati
Date: Friday, 13 May 2005, at 2:57 p.m.

Does anyone know of problems, differences, bugs or patches with 64bit
Informix and in regards to tmpdbs management ?

We are seeing odd behaviors, one such listed below but that differs in
characteristics from say a insert into temp table.
I just cut and pasted my rough notes below, not "techy" but may offer an
idea of what the trouble is.
We started seeing more out of disk space" errors and sluggish performance
after going to 7.31FD6x4 64bit (from 7.31UC6x9 32 bit).
Also now on Solaris 9 64bit.

I appreciate any info !
Thank you !
Randy

oh and 2 notes:

this is a great resource !:
http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.p
erf.doc/perf137.htm


And trivia on tmpdbspace - if you didnt know....
"select * from tablename into temp" - will use ROOTDBS for temp space
where
"select * from tablename into temp WITH NO LOG" - will use tmpdbs


-----------------------------------

> Here's the skinny:
>
> Prd has 6GB of tmpdbs in 2 DBspaces
> Ews has 2GB in 1 Dbspace
> Dev has 1.5GB in 3 Dspaces
>
> I have a query that joins 4 customer master tables:
>
> in PRD it fails after some 40 minutes (!!!) with "out of free space"
> (tmpdbs)
> in EWS it fails in 1 minute - same error
> in Dev and the old balance it runs fine - 5-7 minutes
>
>
> In PRD I see the tmpdbs usage like this:
>
> takes a 75MB bite out of tmpdbs
> takes about the same from tmpdbs2 - chunk 1
> runs a few minutes then takes ALL of the 2GB from tmpdbs2 - chunk 2 (down
> to 0 free)
> runs quite a while longer then nibbles 100MB pieces from tmpdbs2 - chunk 1
> keeps taking 100MB bites from that DBspace/chunk until it hits zero - then
> the query fails (after a LONG time)
> afterwards all of the tmp DBspace is recovered including the small bite
> from tmpdbs (1)
> However it never uses the remainng (almost) 2GB from that original
> DBspace, but it does recognize it's there as it takes a small bite from it
> at first.
>
> the query fails with no free space but there is still all of tmpdbs
> left...
>
> seems buggy to me ... will inquire on Sapmix, maybe an OSS note is in
> order as well.
>
> just noting while tests are fresh.
>
> thanks,
> Randy
>
>
>
>

Messages In This Thread

• 64bit IDS and TMPdbs ?
  Randy Barbati -- Friday, 13 May 2005, at 2:57 p.m.
  • RE: 64bit IDS and TMPdbs ?
    Randy Barbati -- Friday, 13 May 2005, at 3:17 p.m.
    • RE: 64bit IDS and TMPdbs ?
      Robert Seifert -- Tuesday, 17 May 2005, at 7:12 a.m.
      • RE: 64bit IDS and TMPdbs ?
        Sebastian, Norma J. -- Tuesday, 17 May 2005, at 9:15 a.m.
        • RE: 64bit IDS and TMPdbs ?
          Randy Barbati -- Tuesday, 17 May 2005, at 1:51 p.m.

SAP Mix is maintained by Administrator with WebBBS 5.12.