Oninit cdi / Archive
Talk to an expert →

Re: Defrag large fragmented table in 7.32

Posted in 2006

Topics: High Availability & Replication, Installation, Setup & Upgrades

david@smooth1.co.uk — — source: Usenet: comp.databases.informix

Coming in v.Next. I seem to remember seeming something about online upgrades whilst HDR is in use for v.Next but I can't find the slide again on IBM's website...

↪ replying to david@smooth1.co.uk
david@smooth1.co.uk — — source: Usenet: comp.databases.informix

Aha. found it on the IIUG site... http://www.iiug.org/resources/webcasts/replay/06apr05.ppt IDS vNext (end of the year-ish) - Smooth Upgrade of HDR - Online table re-org - Dynamic Reconfiguration - Auto Update Stats - Auto Disk Mgmt - RAS - Autonomics I wonder what dynamic reconfiguration is (onconfig changes on the fly? how far with this go?) Auto Update Stats (woo hoo!). What additional RAS stuff will be added? And just what Autonomics?

↪ replying to david@smooth1.co.uk
John Carlson — — source: Usenet: comp.databases.informix

On 9 Feb 2006 18:27:33 -0800, david@smooth1.co.uk wrote: > >Aha. found it on the IIUG site... > >http://www.iiug.org/resources/webcasts/replay/06apr05.ppt > >IDS vNext (end of the year-ish) >- Smooth Upgrade of HDR >- Online table re-org Cool . .. couldn't remember if this was just talked about in theory or in fact . . . >- Dynamic Reconfiguration Converts Oracle / UDB / Sybase to IDS??? 8-) >- Auto Update Stats I'm curious how much of a performance hit this would be? JWC

↪ replying to david@smooth1.co.uk
Obnoxio The Clown — — source: Usenet: comp.databases.informix

david@smooth1.co.uk said: > > > Coming in v.Next. What is? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com

↪ replying to david@smooth1.co.uk
Curtis Crowson — — source: Usenet: comp.databases.informix

d..@smooth1.co.uk said >And just what Autonomics? Googling I got: n. science of the performance by machines of mental processes such as reading and translation. And further down I got this link: http://www.computerworld.com/networkingtopics/networking/management/story/0,10801,100912,00.html And when I combined the term Informix with it I got: a bunch of junk threads My guess is it is self tuning self reorganizing features. If marketing is involved it could be as simple as rolling back the incomplete transactions when the database is brought online. ;-)

Related threads

Glossary