RE: Temp Table/dbspace problem
George(gpolicello@intrsoft.com) wrote :, So I guess my question is does Informix create temporary tables in the application's DBSpace beyond those that we explicitly create? - Online uses a parameter called DBSPACETEMP which allows you to specify the dbspace in which Online creates Temp tables and sort files. This is set in the $INFORMIXDIR/etc/onconfig setup file. If no parameter is set then sort files got to /tmp and temp tables in root dataspace If so, how can we view them (using TBMonitor or anything)? Even more important, how do we flush them to recover our dataspace? - Temp tables terminate on the termination of the application or the application closes the database in which the table was created and open a database in a different server Hope that helps Munaf g086mnf@bomplant3.appl.ge.com Some notes from the onconfig file on DBSPACETEMP : # DBSPACETEMP: # OnLine equivalent of DBTEMP for SE. This is the list of dbspaces # that the OnLine SQL Engine will use to create temp tables etc. # If specified it must be a colon separated list of dbspaces that exist # when the OnLine system is brought online. If not specified, or if # all dbspaces specified are invalid, various ad hoc queries will create # temporary files in /tmp instead. ---------- From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu] Sent: Tuesday, January 14, 1997 3:14 AM To: informix-list Subject: Temp Table/dbspace problem I am having a problem with an Informix application. The DBSpace that the application uses gets filled seemingly when large queries are performed. After the error occurs we have examined the DBSpace via TBMonitor and it is full. However when we add the sizes of all the tables reported to exist in that DBSpace only about half the space is accounted for. Within our application, any temporary table we create is created using 'CREATE TEMP TABLE' and 'WITH NO LOG'. Our understanding is that these tables would be created in the DBRoot's DBSpace. This space does not fill up. So I guess my question is does Informix create temporary tables in the application's DBSpace beyond those that we explicitly create? If so, how can we view them (using TBMonitor or anything)? Even more important, how do we flush them to recover our dataspace? Please reply to gpolicello@intrsoft.com Thanks! - George The following binary file has been uuencoded to ensure successful transmission. Use UUDECODE to extract. begin 600 WINMAIL.DAT M>)\\^(C,+`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<` M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V`!``"`````0`!``$$ M@`$`'P```%)%.B!496UP(%1A8FQE+V1B<W!A8V4@<')O8FQE;0"A"@$%@`,` M#@```,T'`0`.`!``)@`Q``(`3`$!((`#``X```#-!P$`#@`0``@`'P`"`!P! M`0F``0`?````1#`X,C)!,4,V140P,3%"04,T,#!!,#(T0T1$,3!%`+@&`020 M!@`X`@```@````P````#```P!`````L`#PX``````@'_#P$```!%```````` M``!@E&1@0;@!"``K*XHI``!F%@``9``:`"T`&````!0`)T=E;W)G92<`9W!O M;&EC96QL;T!I;G1R<V]F="YC;VT`````'@`",`$````%````4TU44``````> M``,P`0```!@```!G<&]L:6-E;&QO0&EN=')S;V9T+F-O;0`#`!4,`@````,` M_@\\&````'@`!,`$````)````)T=E;W)G92<``````@$+,`$````=````4TU4 M4#I'4$],24-%3$Q/0$E.5%)33T94+D-/30`````#```Y``````L`0#H!```` M`@'V#P$````$````````!`L````#```P!0````L`#PX``````@'_#P$```!. M``````````!@E&1@0;@!"``K*XHI``!F%@``9``:`#(`'````!0`:6YF;W)M M:7@M;&ES=`!I;F9O<FUI>"UL:7-T0')M>2YE;6]R>2YE9'4````>``(P`0`` M``4```!33510`````!X``S`!````'````&EN9F]R;6EX+6QI<W1`<FUY+F5M M;W)Y+F5D=0`#`!4,`0````,`_@\\&````'@`!,`$````.````:6YF;W)M:7@M M;&ES=`````(!"S`!````(0```%--5%`Z24Y&3U)-25@M3$E35$!235DN14U/ M4EDN1415``````,``#D``````@'V#P$````$````````!5AB`0.0!@#X!P`` M$`````L`(P```````P`F``$````+`"D```````,`-@``````0``Y`*`5B%$+ M`KP!'@!P``$````?````4D4Z(%1E;7`@5&%B;&4O9&)S<&%C92!P<F]B;&5M M```"`7$``0```!8````!O`(+468J@M`*;AP1T+K$`*`DS=$.```#``80K:&L M.0,`!Q!R!P``'@`($`$```!E````1T5/4D=%*$=03TQ)0T5,3$]`24Y44E-/ M1E1#3TTI5U)/5$4Z+%-/24=515-335E154535$E/3DE31$]%4TE.1D]234E8 M0U)%051%5$5-4$]205)95$%"3$5324Y42$5!4%!,20`````"`0D0`0```*D& M``"E!@``CPT``$Q:1G6FQ;_R_P`*`0\\"%0*H!>L"@P!0`O()`@!C:`K`<V5T M,C<&``;#`H,R`\\4"`'!R0G$1XG-T96T"@S.W`N0'$P*#-!+,%,5]"H"+",\\) MV3L7GS(U-0*`!PJ!#;$+8&YG,3`SPQ10"P-L:3,V#?`+55<440OR$U!O$]!C M!4!'4F4%L&=E&[UC`$`@)B@;OQS$9W`&\\&EC5&5L%S!`"X!T$:!O-0&`+@6@ M;1V/'I`I(.)W'+(@.BP*AQ[O'.)P4V\\@22`@"E`$$6U(>2!Q);%T:0(@()$$ M`"!D;P>126X"$"!R;6EX(`4`96%W(R$3T2!`<@K`)A`!D6PG!Y$+@"@P:&4* MA6%P+PM0('`H`":!)P0@1$*&4PJP((`@8F5Y`B#Z9"EQ;Q&P*7$H`"+@(S#$ M97@J0FET;"80)]08/R`@"H\\=W"T@3YIN&V!N'7`!D2!U$;#I!"!A("Y!80>` M$]`%P`\\J<""@"8`J\\E!!0T505$5-4"+@:"!P:-LJ$""A=P0@*Z!U*#`E8'QS M<`60!I`HP2F0)N!B_S10*T(I43,4,"0M\\"?4!"!^5"A1*-8`<"O0(2``("#V M9@,0!Y`N-Q`S("DQ!"`#$;$I12`D24Y&3P!234E81$E2+SD1P&,O`B`%H"=0 M:6<=.5)U-U`X<CC`268@_FXE8#%(.34I@0.@."@@(.<<P"WP-"$O=#=!-^(H M0M<HV0-@/O%D*`!A-3,N&WL;;QY%22/O',0\\@"$@+/H@+`!W0N\\>D"/?'+4J M<+LUH2,P=@B0!^`I@6T>H,<PT`N`.Y!40DT"("TPMP6Q!;$`<'DI@$H1*2WA M_$5V/@$$8!>@)K`H8@&0_P(P1=,N%2;P+)(:<##0,U#_29,T(1>@!:!+\\$K1 M"'!!*+X_+A\\O+C<J,:$GD&XH`O\\FD3324T8F@B$P-,,J*4KBO55.8Q<P,.(T MTT%!8D%@_S5Y5!,H\\B+@06`GQ2O0-^)^;S1@`Z`Q(%@J6S$&D&;O!)`)\\`5` M$;!R3U%0=5!USDA:X2Q$*9!L<`0@4'4<3753D#R`4'5G,#AT-FTG4$`&X"A@ M&H%T]#,N*B(N'6`A8ET\\)5#_!X`\\D3;B`U(TPSLG.')3TG4R6CI0=2,R2F88 M,"!,Y392928P:78'0%R251'O*P`RPR=A!@!%.,@TTD*0]Q/`50(U%7-F)RQ3 M--)H!?A344Q+T!J@-E(#\\""@WS#"-!(GV2C6.N$N9B<\\<?\\T5`B0*]`M,"7P M,-`%0"N`]S$1%Q(^$64Q0EIB:PXL1+\\LT&L19B<S$#X!;.ES$[/%)K)B`V!U M9VAI`3`S_SC`/&1<L7%&1=`%L0:09B>_,?%T&'$X"L`U<FBQ:7F!OVBP!1`( M8#$!*]`L`&,F(O\\(@00@;D,GU&P(*%<^A"E1/S]C"X`3P7U0<&9"-C$X@C`" MT6DM,30T#?"G#-""\\PM9,38<ERV%%Z\\C?80E##`<ID8#83J&'J\\<IC"#"X`G M9"UK`BTSH,$P8');4TU49U")W^4$D$`G@'DN$^`%L(S!^&1U786_ALT&8`(P MA_^MB0M4);%!,'E%T$H`<`YU***"\\$70,3DY-]@@,SJ"\\!2P38V/ALU\\5&^/ MSXD/BA>3OXZ>=;QB:ASAE=^0W#<R5"CR_B\\U%ARA*0%B'4(_1\\\\E@/LQ<$7@ M84E`2B$Q(9X4;C'_*8`WT2<X*BEX83C@(S`K!M]LEBF_`Z`PTQU@=&.1;E'_ M,B$1L!/@2A$M477C"V`=4?=]MWP"-&!R)V()@#C`4'5^00&`,;$TT@20`V!* MT6/^8PAP?B$C,*'!++(Q<#!1_RO2I.A)0#$@2E@WXG'1!`#Y4'5F=2"@>&%> M$"R@3U+?=>,LH7U0K=0`D'H'D541_WJ264<$(!>@3**MPB5@=0/_*4%0=2Q3 M*P9X`280`:`(8/]>D0=`520U-3$!K(`(8`(P[S(A)V%P9E!U5Z+A*5%/DO\\J M*4702R$H/BR2)]4FP5HF@TGS4'4G0U)%03+``S<0,M)404),12=!-],G5TE4 M2`>P3Z`@3$]')WAA3T^A_U^0!($3P#?A2A)JDVRT$;#KM48H]'<(8&PKT')1 M6B;_.:4K``@`',`JV*23.3(K,_\\F\\WC"I])0=3O@N2TE7R9O_R=_*(^E[RJO M*[\\LSRW2<0+_1<10=4C?2>]*_TP/31].+_=//U!(4'50S:!8<K0!+5$_-"$@ M/R%$73PXX`!P:W/^(5!U,``=)%T\\X5^?'PMDO15B,A*P'*90=1;!`.7@```` M`P`0$``````#`!$0`````$``!S#@6>X5!P*\\`4``"##@6>X5!P*\\`1X`/0`! 1````!0```%)%.B``````$9T` ` end