RE: New shared memory segments,while performing a backup with
Posted in 1997
Dave,
Thanks for setting me straight. I just checked an ontape backup we have
running and sure enough the damn thing is only using ONE dbspace even
though I have 5 temp dbspaces defined in the onconfig file.
I've never checked this before but I wonder if Onarchive or Onbar have this
feature? I guess I need to monitor our next Onarchive backup.
Doug
}One other issue that I have run into is that the docs are WRONG. The
engine will
}only use 1 (one) temp dbspace during the archive with ontape. It appears
to pick the
}temp space with the most room, but when that fills, the archive crashes.
If you have
}a data dbspace that has more space, consider setting the DBSPACETEMP variable
}at the O/S just prior to running the ontape session.
}
}-d
}
}
}-----Original Message-----
}From: Doug Bowman [SMTP:dougb@etcscan.com]
}Sent: Wednesday, August 27, 1997 5:48 PM
}To: informix-list@rmy.emory.edu
}Subject: Re: New shared memory segments,while performing a backup with
ontape. Why?
}
}
}I'm on 7.2x but I think this applies to 7.1x also. The ISAM error: no
}free disk space is probably due to DBSPACETEMP being filled up.
}Ontape creates temp tables for each dbspace that it is backing up. If
}you have heavy system activity during the backup you will most likely
}blow out your temp dbspaces, if they are too small.
}
}See the ontape chapter in the "Archive & Backup Guide" for a more
}detailed explaination.
}
}Doug B
}
}On Wed, 27 Aug 1997 20:31:47 +0200, Fernando Collalti
}<fernando.collalti@orbit.net> wrote:
}
}>Hello,
}>
}>In the last days, while performing an "ontape" backup,
}>the engine allocated new shared memory segments.
}>
}>During normal operational activity, the primary shared memory
}>segment is used on an average of 50-60%, so I think that for
}>now the segment is big enough.
}>
}>I would like to know which disk space, physical disk or dbspacetemps,
}>the error is refering to(ISAM error: no free disk space)
}>
}<< snip >>
}
}begin 600 WINMAIL.DAT
}M>)\\^(A,4`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
}M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$
}MD 8`: ,```(````0`````P``, ,````+``\\.``````(!_P\\!````00``````
}M``"!*Q^DOJ,0&9UN`-T!#U0"`````&1O=6=B0&5T8W-C86XN8V]M`%--5% `
}M9&]U9V) 971C<V-A;BYC;VT`````'@`", $````%````4TU44 `````>``,P
}M`0```!(```!D;W5G8D!E=&-S8V%N+F-O;0````,`%0P!`````P#^#P8````>
}M``$P`0```!0````G9&]U9V) 971C<V-A;BYC;VTG``(!"S !````%P```%--
}M5% Z1$]51T) 151#4T-!3BY#3TT```,``#D`````"P! .@$````>`/9?`0``
}M`!(```!D;W5G8D!E=&-S8V%N+F-O;0````(!]U\\!````00````````"!*Q^D
}MOJ,0&9UN`-T!#U0"`````&1O=6=B0&5T8W-C86XN8V]M`%--5% `9&]U9V)
}M971C<V-A;BYC;VT``````P#]7P$````#`/]?``````(!]@\\!````! ``````
}M``,0`````P``, 0````+``\\.`0````(!_P\\!````50````````"!*Q^DOJ,0
}M&9UN`-T!#U0"```!`&EN9F]R;6EX+6QI<W1 <FUY+F5M;W)Y+F5D=0!33510
}M`&EN9F]R;6EX+6QI<W1 <FUY+F5M;W)Y+F5D=0`````>``(P`0````4```!3
}M3510`````!X``S !````' ```&EN9F]R;6EX+6QI<W1 <FUY+F5M;W)Y+F5D
}M=0`#`!4,`0````,`_@\\&````'@`!, $````<````:6YF;W)M:7@M;&ES=$!R
}M;7DN96UO<GDN961U``(!"S !````(0```%--5% Z24Y&3U)-25@M3$E35$!2
}M35DN14U/4EDN1415``````,``#D`````"P! .@`````>`/9?`0```!P```!I
}M;F9O<FUI>"UL:7-T0')M>2YE;6]R>2YE9'4``@'W7P$```!5`````````($K
}M'Z2^HQ 9G6X`W0$/5 (```$`:6YF;W)M:7@M;&ES=$!R;7DN96UO<GDN961U
}M`%--5% `:6YF;W)M:7@M;&ES=$!R;7DN96UO<GDN961U``````,`_5\\!````
}M`P#_7P`````"`?8/`0````0````````$:KX!!( !`$L```!213H@3F5W('-H
}M87)E9"!M96UO<GD@<V5G;65N=',L=VAI;&4@<&5R9F]R;6EN9R!A(&)A8VMU
}M<"!W:71H(&]N=&%P92X@5VAY/P#N&@$%@ ,`#@```,T'" `<``T`& `1``0`
}M,@$!(( #``X```#-!P@`' `-`!0`$ `$`"T!`0F `0`A````0S!!-4$X.49%
}M,3%&1#$Q,4$R.$0P,#8P,#@P1#9%,T(`)@<!`Y &`)0(```A````"P`"``$`
}M```+`",```````,`)@``````"P`I```````#`"X```````,`-@``````0 `Y
}M`# &MEOPL[P!'@!P``$```!+````4D4Z($YE=R!S:&%R960@;65M;W)Y('-E
}M9VUE;G1S+'=H:6QE('!E<F9O<FUI;F<@82!B86-K=7 @=VET:"!O;G1A<&4N
}M(%=H>3\\```(!<0`!````%@````&\\L_!;<Y^HI<(?X1'1HHT`8 @-;CL``!X`
}M'@P!````!0```%--5% `````'@`?# $````8````9&]T=&] =&AE;6]N97ES
}M=&]R92YC;VT``P`&$+DB;9T#``<0W@0``!X`"! !````90```$].14]42$52
}M25-354542$%424A!5D5254Y)3E1/25-42$%45$A%1$]#4T%215=23TY'5$A%
}M14Y'24Y%5TE,3$].3%E54T4Q*$].12E414U01$)34$%#14154DE.1U1(14%2
}M0T@``````@$)$ $```!#!0``/P4``#8(``!,6D9U8R3R(0,`"@!R8W!G,3(U
}M%C(`^ M@;@X0,#,SG0'W( *D`^,"`&-H"L#@<V5T," '$P*#`%"A$'9P<G$R
}M$79]"H#9",@@.PEO#C U`H *@6QU8P!0"P-C$A(+Q"" 3VYE(&]T: 205B $
}M`0I0(!>@805 2<H@$0!V%W!R=0.@"X <=&\\7X1A$%Z$@9&\\.8P0@"L 7<%=2
}M3TYH1RX@&U!4&C$)\\&?W"X 7< /P; E0"K$*@ (@$&QY('41," Q(!(H`B!E
}M*1A 96UPZ1I08G,*L&,:00AQ#R#W&A,*P!#P:1CA`_ 7H!> T0(P87!E&T%)
}M!4 @8*\\@<!$1&$ 9@' -X&L:$K\\<=!WC'E0?XQHB!&!S!4!#`V #<"P@8G4%
}M0'?7%[ #H!A39AQ!<R10'RHI!0!A<Q>P<R"29B#N>0A@&+,<=&$:4!AP*#'_
}M'D484Q$`!" $8!K!'E,D4%\\%H "!!($BP!% =![F1 !"4U!!0T541?!-4"!V
}M"L ', )@)\\;I&@1/+P7P:AT@!4 2P/YI!;$9<1D1`P`>]2 T*O&S!! N@&XN
}M''0<="T+,8<PR#"H"S!L:3,V`4!?%I !0!+ %Y %D'02!#'H-B M-*)/!1 ;
}MX0= XP70,#%A9V4THS"F,[0',X$+$S.V:2TQ-#3C`4 S`#$X, % #- X0ZAB
}M($8#83H,@V(18$9$"& ?`$)O=P."6V!33510.AI@.H!B5D 10!J 8P!P+@6@
}M;;Y=,*4Y< 9@`C YUU<)@-478',H4'DD4$$Z@"XB!#(W)% Q.3DW(( U.C0X
}M(%!-/*<<5&\\YUPN `A!R;6DL>"TS`"/@0$&@>2X?'? %L$)A'K \\J'5B:N,S
}MX3G74F4Z![,FL!JQ[F0CL$*#*O%G!X ","60[R2P`Q 7<"!P<D&#'O$H,#)B
}M`-!K=1X0'^M7:'QY/S9/-UHS! NV,+E)!"=M("$@-RXR>/\\D8QB@%Z +@"'2
}M&:$@\\3,`-P>1&7%-$#%-0 = <V]#&T$;@DE304T;L'+E`V!R1,!N;QQT`U )
}MX/\\:4 0`(= >5!FA,Z%'P )@GQT`'K 8,1F *\\IB91[B_R5216%(`#"5%U O
}MTP4`(2#_'> 9L1WR`9$LX 0@08$;L/\\`T" 0**L?\\!F21\\(>XE4A7R<"''0G
}M5ABP(2!V1>%Y_R/@'? :H#/P'Z ?\\%,"'M>?1\\4G4APR([0S`&ME'/#_''0"
}M8#K %X D@2=1+J$=^7\\ED0:0&A(=`!JR&7 9@'/_`, <4#";!F 8,B^7$/$%
}M,+<7PB3B%W B!Q ?A"8ZH.E'U$=U*K$B5U,H,"FRGQQT`0`!D$:Q17!E> M3
}M_QAP,&XZ9#"J%U ]\\B10/R#'/J(_5 '0.C,Q/\\ _D-0K, '0,"101@21`'!]
}M&F @"% <4 = *S <=#RN9FT5/%%MM$ %L&(?\\/(N%V!T/AP@,[(YT#"Y;#Y(
}M7I )`"QQ%7$527]DE M@(^$^82611I\\#D2+_(#1F8$?$<=8:(AO%8A$:<']6
}M445P%V!%#T85,)5R1D3O'L10X$&@-5%O1O%H@S51_UO6):0N80# 1=)X.G$5
}M1@7_&9(=(7AP3.$#D1C1)I UT*,7@"<P-3 M,S E)%#_3Y!-F24B!;!Q%5#@
}M!^ :(M]^N6_ 'P`)\\#IQ:'F-&*"Z=PA@;'AP7F(A8FN"XN]SX5?"4<<D4'!)
}M$ W1-5'_4;,%L1XU'>(ED'8J4((9DN<)<&Z!'N-O*% L)4!1?'(I<>L\\/"+
}M`P`>$#X7<D4<=!.!`)!0``,`$! ``````P`1$ (````#`( 0_____T `!S"P
}MR!+,[[.\\`4 `"#"PR!+,[[.\\`0L``( (( 8``````, ```````!&``````.%
}M`````````P`"@ @@!@``````P ```````$8`````$(4````````#``6 "" &
}M``````# ````````1@````!2A0``MPT``!X`)8 (( 8``````, ```````!&
}M`````%2%```!````! ```#@N, `#`": "" &``````# ````````1@`````!
}MA0````````L`+X (( 8``````, ```````!&``````Z%`````````P`P@ @@
}M!@``````P ```````$8`````$84````````#`#* "" &``````# ````````
}M1@`````8A0```````!X`08 (( 8``````, ```````!&`````#:%```!````
}M`0`````````>`$* "" &``````# ````````1@`````WA0```0````$`````
}M````'@!#@ @@!@``````P ```````$8`````.(4```$````!`````````!X`
}</0`!````!0```%)%.B ``````P`--/TW``!$084`
}`
}end
}
}