This is a discussion on Re: Down chunks within the Informix forums, part of the Database Server Software category; --> --0-547792315-1085067879=:53489 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit If you're an Informix DBA you can't possibly continue with no worries! Malcolm ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| --0-547792315-1085067879=:53489 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit If you're an Informix DBA you can't possibly continue with no worries! Malcolm Neil Truby <neil.truby@ardenta.com> wrote: Once the underlying problem is corrected, you can use the onspaces utility to mark them back as online. At that time onspaces does a sanity check and if all is OK, you continue as before with no worries. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Andy Kent" wrote in message news:ac5fb36.0405200536.10ceeac9@posting.google.co m... > Client is suffering from chunks being marked down due to incorrect > ownership and permissions on some of the chunks. Some meathead must > have gone in and changed them. Will they be able to get the data back > once this has been corrected? Any clues how? > > (It didn't work when I tried it on a temp dbspace, even after an IDS > restart - I ended up dropping and re-creating the dbspace). > > They're on 7.31.UC5. > > Andy Kent --0-547792315-1085067879=:53489 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit <DIV>If you're an Informix DBA you can't possibly continue with no worries! </DIV> <DIV> </DIV> <DIV>Malcolm<BR><BR><B><I>Neil Truby <neil.truby@ardenta.com></I></B> wrote:</DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Once the underlying problem is corrected, you can use the onspaces utility<BR>to mark them back as online. At that time onspaces does a sanity check and<BR>if all is OK, you continue as before with no worries.<BR><BR>-- <BR>Neil Truby t:01932 724027<BR>Director m:07798 811708<BR>Ardenta Limited e:neil.truby@ardenta.com<BR><BR>"Andy Kent" <ANDYKENT.BRISTOL1095@VIRGIN.NET>wrote in message<BR>news:ac5fb36.0405200536.10ceeac9@postin g.google.com...<BR>> Client is suffering from chunks being marked down due to incorrect<BR>> ownership and permissions on some of the chunks. Some meathead must<BR>> have gone in and changed them. Will they be able to get the data back<BR>> once this has been corrected? Any clues how?<BR>><BR>> (It didn't work when I tried it on a temp dbspace, even after an IDS<BR>> restart - I ended up dropping and re-creating the dbspace).<BR>><BR>> They're on 7.31.UC5.<BR>><BR>> Andy Kent<BR><BR></BLOCKQUOTE> --0-547792315-1085067879=:53489-- sending to informix-list |
| |||
| malcolm weallans wrote: > > --0-547792315-1085067879=:53489 > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > If you're an Informix DBA you can't possibly continue with no worries! Why on earth not, it's by far the easiest DB to look after and if setup correctly it's very rare that it causes you any problems > > Malcolm > > Neil Truby <neil.truby@ardenta.com> wrote: > Once the underlying problem is corrected, you can use the onspaces utility > to mark them back as online. At that time onspaces does a sanity check and > if all is OK, you continue as before with no worries. > > -- > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.truby@ardenta.com > > "Andy Kent" wrote in message > news:ac5fb36.0405200536.10ceeac9@posting.google.co m... > > Client is suffering from chunks being marked down due to incorrect > > ownership and permissions on some of the chunks. Some meathead must > > have gone in and changed them. Will they be able to get the data back > > once this has been corrected? Any clues how? > > > > (It didn't work when I tried it on a temp dbspace, even after an IDS > > restart - I ended up dropping and re-creating the dbspace). > > > > They're on 7.31.UC5. > > > > Andy Kent > > --0-547792315-1085067879=:53489 > Content-Type: text/html; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > <DIV>If you're an Informix DBA you can't possibly continue with no worries! </DIV> > <DIV> </DIV> > <DIV>Malcolm<BR><BR><B><I>Neil Truby <neil.truby@ardenta.com></I></B> wrote:</DIV> > <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Once the underlying problem is corrected, you can use the onspaces utility<BR>to mark them back as online. At that time onspaces does a sanity check and<BR>if all is OK, you continue as before with no worries.<BR><BR>-- <BR>Neil Truby t:01932 724027<BR>Director m:07798 811708<BR>Ardenta Limited e:neil.truby@ardenta.com<BR><BR>"Andy Kent" <ANDYKENT.BRISTOL1095@VIRGIN.NET>wrote in message<BR>news:ac5fb36.0405200536.10ceeac9@postin g.google.com...<BR>> Client is suffering from chunks being marked down due to incorrect<BR>> ownership and permissions on some of the chunks. Some meathead must<BR>> have gone in and changed them. Will they be able to get the data back<BR>> once this has been corrected? Any clues how?<BR>><BR>> (It didn't work when I tried it on a temp dbspace, even after an IDS<BR>> restart - I ended up dropping and re-creating the > dbspace).<BR>><BR>> They're on 7.31.UC5.<BR>><BR>> Andy Kent<BR><BR></BLOCKQUOTE> > --0-547792315-1085067879=:53489-- > sending to informix-list -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com # |
| |||
| "Paul Watson" <paul@oninit.com> wrote in message news:40ACEE93.8B912FE3@oninit.com... > malcolm weallans wrote: > > > > If you're an Informix DBA you can't possibly continue with no worries! > > Why on earth not, it's by far the easiest DB to look after and if setup > correctly it's very rare that it causes you any problems .... and it's made you both multi-millionaires. |
| ||||
| Neil Truby wrote: > > "Paul Watson" <paul@oninit.com> wrote in message > news:40ACEE93.8B912FE3@oninit.com... > > malcolm weallans wrote: > > > > > > > If you're an Informix DBA you can't possibly continue with no worries! > > > > Why on earth not, it's by far the easiest DB to look after and if setup > > correctly it's very rare that it causes you any problems > > ... and it's made you both multi-millionaires. Only in Italy -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com # |