Will 9.5 auto-drop freed extents?
Will IDS 9.5 automatically drop freed table extents? If not, can this be added as a feature request (or where is the suggestion box for such requests). This is one of the few things Oracle does that is pretty cool. If Informix did it, we might not have to reorg as much. In my case, specifically we have finally started using SAP's archiving process(es). This has allowed us to archive 75GB+ of data out of our production database. For me to get this freespace back, I have to reorg the table (yes, this is from one table). If IDS automatically freed unused extents, other tables in this dbspace could continue to grow without me adding chunks, or without me doing a reorg to get that space back. Please advise as to where the "future release" suggestion box is.... Thanks, Norma Jean ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================
Hi Norma Jean. I don't know if this is one of those items scheduled for 9.5; however, the only way I know to get a "feature request" recorded is to open a case and have the engineer create a "feature request" in the same area as bugs are recorded. Supposedly, there are some engineers that review the items created in such a manner and, depending upon the time needed to implement, actually work on these things from time to time. Take care. Clifton "Sebastian, ...." <NormaJean.Sebastian@tellabs.com> wrote: Will IDS 9.5 automatically drop freed table extents? If not, can this be added as a feature request (or where is the suggestion box for such requests). This is one of the few things Oracle does that is pretty cool. If Informix did it, we might not have to reorg as much. In my case, specifically we have finally started using SAP's archiving process(es). This has allowed us to archive 75GB+ of data out of our production database. For me to get this freespace back, I have to reorg the table (yes, this is from one table). If IDS automatically freed unused extents, other tables in this dbspace could continue to grow without me adding chunks, or without me doing a reorg to get that space back. Please advise as to where the "future release" suggestion box is.... Thanks, Norma Jean ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================
Sebastian, .... said: > > Please advise as to where the "future release" suggestion box is.... Log a case with Tech Support. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html
Sebastian, Norma J. said: > > I do get great Informix support from SAP, but why would they care if I > asked for an Informix enhancement?..... They'd care because they're a great bunch of guys. :o> You asked what the suggestion box was and I told you...can't do more than that, I'm afraid! :o) > -----Original Message----- > From: Obnoxio The Clown [mailto:obnoxio@serendipita.com] > Sebastian, .... said: >> >> Please advise as to where the "future release" suggestion box is.... > > Log a case with Tech Support. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html