Need ideas
Not a technical problem thread: Art Kagel asked the list for topic suggestions for presentations at the 2011 IIUG Conference. Peter Logan proposed a detailed walkthrough of every ONCONFIG parameter — what each does, its performance impact, how to tell if it needs changing, and sensible ranges — which several others endorsed, some asking that OAT-based tuning be covered too (Fernando Nunes noted OAT changes are equivalent to onmode -wm/-wf). Frank suggested large-table/fragmentation management. Art agreed to prepare an ONCONFIG talk, subject to conference committee acceptance.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Fellow Informixers: I'm looking for new ideas for a presentation or two to prepare for the 2011 IIUG Conference in mid May. I can update some older ones that I haven't given in a while, and there are always new faces at the conferences that haven't seen them at all, but I enjoy putting new ones together. The only problem is, I've run out of ideas. Anyone have a wish list of presentations they would like to see at the IIUG Conference that they haven't seen before or ones that haven't been presented in a few years that you'd like to see refreshed? While mostly this is for me personally, however, even if you don't think your idea is one that I'd be interested in pursuing, post it anyway (or send it to me directly of you are shy or lurking), I'll pass the list on to other presenters and to some IBMers to see if anyone else is interested in putting something together. No guarantees, even if I put a presentation deck together there's no knowing if the CPC will find room for me to present it, but if the idea is popular, well.... Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016e6509dd872dc060491d4cd93
Hey Art ... I'd like to see a presentation that goes into detail on each of the onconfig parameters ... explaining what they do, the impact that they might have on performance, ways to check to see if they need modified, etc. I know the onconfig file now tries to explain what each of them do, but it would be nice to have real world examples of how changing them might impact the server. Also, it'd be nice to know ideal ranges for them. Not sure if all of that would fit into one presentation or not ... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 10/04/2010 09:45 PM Subject: Need ideas [21540] Sent by: ids-bounces@iiug.org Fellow Informixers: I'm looking for new ideas for a presentation or two to prepare for the 2011 IIUG Conference in mid May. I can update some older ones that I haven't given in a while, and there are always new faces at the conferences that haven't seen them at all, but I enjoy putting new ones together. The only problem is, I've run out of ideas. Anyone have a wish list of presentations they would like to see at the IIUG Conference that they haven't seen before or ones that haven't been presented in a few years that you'd like to see refreshed? While mostly this is for me personally, however, even if you don't think your idea is one that I'd be interested in pursuing, post it anyway (or send it to me directly of you are shy or lurking), I'll pass the list on to other presenters and to some IBMers to see if anyone else is interested in putting something together. No guarantees, even if I put a presentation deck together there's no knowing if the CPC will find room for me to present it, but if the idea is popular, well.... Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016e6509dd872dc060491d4cd93 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
I vote for this one. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 11x64 & IDS 11.50.FC6 Dont document the problem, fix it. Atli Björgvin Oddsson ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Peter_Logan@spartanstores.com [Peter_Logan@spartanstores.com] Sent: Wednesday, October 06, 2010 1:35 PM To: ids@iiug.org Subject: Re: Need ideas [21582] Hey Art ... I'd like to see a presentation that goes into detail on each of the onconfig parameters ... explaining what they do, the impact that they might have on performance, ways to check to see if they need modified, etc. I know the onconfig file now tries to explain what each of them do, but it would be nice to have real world examples of how changing them might impact the server. Also, it'd be nice to know ideal ranges for them. Not sure if all of that would fit into one presentation or not ... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 10/04/2010 09:45 PM Subject: Need ideas [21540] Sent by: ids-bounces@iiug.org Fellow Informixers: I'm looking for new ideas for a presentation or two to prepare for the 2011 IIUG Conference in mid May. I can update some older ones that I haven't given in a while, and there are always new faces at the conferences that haven't seen them at all, but I enjoy putting new ones together. The only problem is, I've run out of ideas. Anyone have a wish list of presentations they would like to see at the IIUG Conference that they haven't seen before or ones that haven't been presented in a few years that you'd like to see refreshed? While mostly this is for me personally, however, even if you don't think your idea is one that I'd be interested in pursuing, post it anyway (or send it to me directly of you are shy or lurking), I'll pass the list on to other presenters and to some IBMers to see if anyone else is interested in putting something together. No guarantees, even if I put a presentation deck together there's no knowing if the CPC will find room for me to present it, but if the idea is popular, well.... Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016e6509dd872dc060491d4cd93 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Ooh. I did one like that way back in 1999 at the NY Users Group and presented it again in 2001 or 2002 at a WAIUG meeting. That one morphed into my Internals presentation which has a different focus now. I LIKE IT! Thanks. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 6, 2010 at 1:35 PM, Peter_Logan@spartanstores.com < Peter_Logan@spartanstores.com> wrote: > Hey Art ... > > I'd like to see a presentation that goes into detail on each of the > onconfig parameters ... explaining what they do, the impact that they > might have on performance, ways to check to see if they need modified, > etc. I know the onconfig file now tries to explain what each of them do, > but it would be nice to have real world examples of how changing them > might impact the server. Also, it'd be nice to know ideal ranges for > them. Not sure if all of that would fit into one presentation or not ... > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > From: > "Art Kagel" <art.kagel@gmail.com> > To: > ids@iiug.org > Date: > 10/04/2010 09:45 PM > Subject: > Need ideas [21540] > Sent by: > ids-bounces@iiug.org > > Fellow Informixers: > > I'm looking for new ideas for a presentation or two to prepare for the > 2011 > IIUG Conference in mid May. I can update some older ones that I haven't > given in a while, and there are always new faces at the conferences that > haven't seen them at all, but I enjoy putting new ones together. The only > problem is, I've run out of ideas. > > Anyone have a wish list of presentations they would like to see at the > IIUG > Conference that they haven't seen before or ones that haven't been > presented > in a few years that you'd like to see refreshed? While mostly this is for > me personally, however, even if you don't think your idea is one that I'd > be > interested in pursuing, post it anyway (or send it to me directly of you > are > shy or lurking), I'll pass the list on to other presenters and to some > IBMers to see if anyone else is interested in putting something together. > > No guarantees, even if I put a presentation deck together there's no > knowing > if the CPC will find room for me to present it, but if the idea is > popular, > well.... > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > --0016e6509dd872dc060491d4cd93 > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00163630ee9deaca6b0491f67af7
The parameters are a good idea, along with using them with OAT, would be good also. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Peter_Logan@spartanstores.com Sent: Wednesday, October 06, 2010 1:36 PM To: ids@iiug.org Subject: Re: Need ideas [21582] Hey Art ... I'd like to see a presentation that goes into detail on each of the onconfig parameters ... explaining what they do, the impact that they might have on performance, ways to check to see if they need modified, etc. I know the onconfig file now tries to explain what each of them do, but it would be nice to have real world examples of how changing them might impact the server. Also, it'd be nice to know ideal ranges for them. Not sure if all of that would fit into one presentation or not ... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 10/04/2010 09:45 PM Subject: Need ideas [21540] Sent by: ids-bounces@iiug.org Fellow Informixers: I'm looking for new ideas for a presentation or two to prepare for the 2011 IIUG Conference in mid May. I can update some older ones that I haven't given in a while, and there are always new faces at the conferences that haven't seen them at all, but I enjoy putting new ones together. The only problem is, I've run out of ideas. Anyone have a wish list of presentations they would like to see at the IIUG Conference that they haven't seen before or ones that haven't been presented in a few years that you'd like to see refreshed? While mostly this is for me personally, however, even if you don't think your idea is one that I'd be interested in pursuing, post it anyway (or send it to me directly of you are shy or lurking), I'll pass the list on to other presenters and to some IBMers to see if anyone else is interested in putting something together. No guarantees, even if I put a presentation deck together there's no knowing if the CPC will find room for me to present it, but if the idea is popular, well.... Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016e6509dd872dc060491d4cd93 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
Looks like a winner. Look for: Everything They Never Told You About Your ONCONFIG File <http://www.iiug.org/conf/speakers/viewpres.php?a=33>; at the IIUG Conference in May if the CPC likes it as much as you guys do. See you there! Kansas is the place to be in May. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 6, 2010 at 1:41 PM, Wyza, Jonathon <wyzaj@bethelcollege.edu>wrote: > I vote for this one. > > Jonathon Wyza > CX & CBORD System Administrator > CX Programmer/Analyst > Administrative Computing > Bethel College > (574)-257-3381 > AIM: Iamwyza > jonathon.wyza@bethelcollege.edu > ============================== > SLES 11x64 & IDS 11.50.FC6 > > Dont document the problem, fix it. > Atli Björgvin Oddsson > > ________________________________________ > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of > Peter_Logan@spartanstores.com [Peter_Logan@spartanstores.com] > Sent: Wednesday, October 06, 2010 1:35 PM > To: ids@iiug.org > Subject: Re: Need ideas [21582] > > Hey Art ... > > I'd like to see a presentation that goes into detail on each of the > onconfig parameters ... explaining what they do, the impact that they > might have on performance, ways to check to see if they need modified, > etc. I know the onconfig file now tries to explain what each of them do, > but it would be nice to have real world examples of how changing them > might impact the server. Also, it'd be nice to know ideal ranges for > them. Not sure if all of that would fit into one presentation or not ... > > Peter > > Peter Logan > Senior Database Administrator > Phone: 616/878-8309 > > From: > "Art Kagel" <art.kagel@gmail.com> > To: > ids@iiug.org > Date: > 10/04/2010 09:45 PM > Subject: > Need ideas [21540] > Sent by: > ids-bounces@iiug.org > > Fellow Informixers: > > I'm looking for new ideas for a presentation or two to prepare for the > 2011 > IIUG Conference in mid May. I can update some older ones that I haven't > given in a while, and there are always new faces at the conferences that > haven't seen them at all, but I enjoy putting new ones together. The only > problem is, I've run out of ideas. > > Anyone have a wish list of presentations they would like to see at the > IIUG > Conference that they haven't seen before or ones that haven't been > presented > in a few years that you'd like to see refreshed? While mostly this is for > me personally, however, even if you don't think your idea is one that I'd > be > interested in pursuing, post it anyway (or send it to me directly of you > are > shy or lurking), I'll pass the list on to other presenters and to some > IBMers to see if anyone else is interested in putting something together. > > No guarantees, even if I put a presentation deck together there's no > knowing > if the CPC will find room for me to present it, but if the idea is > popular, > well.... > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > --0016e6509dd872dc060491d4cd93 > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e64f51b4216d9a0491f6ae06
I like the onconf file parameters idea and since I'm just starting to us OAT; any good, bad and ugly of using or not using OAT to change them. John Adamski Network Specialist Graceland University -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox, Ernest Sent: Wednesday, October 06, 2010 1:05 PM To: ids@iiug.org Subject: RE: Need ideas [21585] The parameters are a good idea, along with using them with OAT, would be good also. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Peter_Logan@spartanstores.com Sent: Wednesday, October 06, 2010 1:36 PM To: ids@iiug.org Subject: Re: Need ideas [21582] Hey Art ... I'd like to see a presentation that goes into detail on each of the onconfig parameters ... explaining what they do, the impact that they might have on performance, ways to check to see if they need modified, etc. I know the onconfig file now tries to explain what each of them do, but it would be nice to have real world examples of how changing them might impact the server. Also, it'd be nice to know ideal ranges for them. Not sure if all of that would fit into one presentation or not ... Peter Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Date: 10/04/2010 09:45 PM Subject: Need ideas [21540] Sent by: ids-bounces@iiug.org Fellow Informixers: I'm looking for new ideas for a presentation or two to prepare for the 2011 IIUG Conference in mid May. I can update some older ones that I haven't given in a while, and there are always new faces at the conferences that haven't seen them at all, but I enjoy putting new ones together. The only problem is, I've run out of ideas. Anyone have a wish list of presentations they would like to see at the IIUG Conference that they haven't seen before or ones that haven't been presented in a few years that you'd like to see refreshed? While mostly this is for me personally, however, even if you don't think your idea is one that I'd be interested in pursuing, post it anyway (or send it to me directly of you are shy or lurking), I'll pass the list on to other presenters and to some IBMers to see if anyone else is interested in putting something together. No guarantees, even if I put a presentation deck together there's no knowing if the CPC will find room for me to present it, but if the idea is popular, well.... Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --0016e6509dd872dc060491d4cd93 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
On Wed, Oct 6, 2010 at 8:09 PM, John Adamski <adamski@graceland.edu> wrote:
> I like the onconf file parameters idea and since I'm just starting to us
> OAT;
> any good, bad and ugly of using or not using OAT to change them.
>
>
Can you explain this better? Are you referring to the fact that OAT may give
you suggestions about the parameters, or simply the ability to change them
(the ones which are dynamically changeable) using OAT?
If you just mean using OAT to change them, it's exactly the same as changing
them using "onmode -wm/wf" or changing the values directly in $ONCONFIG.
Thanks!
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--000325574d668d64310491fc03ad
Any one interested in large table management skills? Want to keep data fast and online forever? Moving older data to historical tables is not preferred; Table fragmentation may still give you some headaches: detach/attach, fragmentation key for both data and index,data skew, re-fragment..... Table Siblings? how to design and use ?...... Others? Frank On Mon, Oct 4, 2010 at 9:44 PM, Art Kagel <art.kagel@gmail.com> wrote: > Fellow Informixers: > > I'm looking for new ideas for a presentation or two to prepare for the 2011 > IIUG Conference in mid May. I can update some older ones that I haven't > given in a while, and there are always new faces at the conferences that > haven't seen them at all, but I enjoy putting new ones together. The only > problem is, I've run out of ideas. > > Anyone have a wish list of presentations they would like to see at the IIUG > Conference that they haven't seen before or ones that haven't been > presented > in a few years that you'd like to see refreshed? While mostly this is for > me personally, however, even if you don't think your idea is one that I'd > be > interested in pursuing, post it anyway (or send it to me directly of you > are > shy or lurking), I'll pass the list on to other presenters and to some > IBMers to see if anyone else is interested in putting something together. > > No guarantees, even if I put a presentation deck together there's no > knowing > if the CPC will find room for me to present it, but if the idea is popular, > well.... > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > --0016e6509dd872dc060491d4cd93 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f79632c43fe20492093692
Interesting idea. Maybe "Planning Maintenance for 24x7x365 Service" That sounds like one that an IBMer should tackle! Maybe Spokey Wheeler or Mark Jamison will take up the challenge sounds like it's a subject that would be near to their hearts. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 7, 2010 at 12:16 PM, FRANK <yunyaoqu@gmail.com> wrote: > Any one interested in large table management skills? Want to keep data fast > and online forever? > > Moving older data to historical tables is not preferred; > > Table fragmentation may still give you some headaches: detach/attach, > fragmentation key for both data and index,data skew, re-fragment..... > > Table Siblings? how to design and use ?...... > > Others? > > Frank > > On Mon, Oct 4, 2010 at 9:44 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > Fellow Informixers: > > > > I'm looking for new ideas for a presentation or two to prepare for the > 2011 > > IIUG Conference in mid May. I can update some older ones that I haven't > > given in a while, and there are always new faces at the conferences that > > haven't seen them at all, but I enjoy putting new ones together. The only > > problem is, I've run out of ideas. > > > > Anyone have a wish list of presentations they would like to see at the > IIUG > > Conference that they haven't seen before or ones that haven't been > > presented > > in a few years that you'd like to see refreshed? While mostly this is for > > me personally, however, even if you don't think your idea is one that I'd > > be > > interested in pursuing, post it anyway (or send it to me directly of you > > are > > shy or lurking), I'll pass the list on to other presenters and to some > > IBMers to see if anyone else is interested in putting something together. > > > > No guarantees, even if I put a presentation deck together there's no > > knowing > > if the CPC will find room for me to present it, but if the idea is > popular, > > well.... > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.com) > > IIUG Board of Directors (art@iiug.org) > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and > > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other > > organization with which I am associated either explicitly, implicitly, or > > by > > inference. Neither do those opinions reflect those of other individuals > > affiliated with any entity with which I am affiliated nor those of the > > entities themselves. > > > > --0016e6509dd872dc060491d4cd93 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001485f79632c43fe20492093692 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016361e8066d8daf6049209a9a7
I think this would be good .... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "FRANK" <yunyaoqu@gmail.com> To: ids@iiug.org Date: 10/07/2010 12:16 PM Subject: Re: Need ideas [21595] Sent by: ids-bounces@iiug.org Any one interested in large table management skills? Want to keep data fast and online forever? Moving older data to historical tables is not preferred; Table fragmentation may still give you some headaches: detach/attach, fragmentation key for both data and index,data skew, re-fragment..... Table Siblings? how to design and use ?...... Others? Frank On Mon, Oct 4, 2010 at 9:44 PM, Art Kagel <art.kagel@gmail.com> wrote: > Fellow Informixers: > > I'm looking for new ideas for a presentation or two to prepare for the 2011 > IIUG Conference in mid May. I can update some older ones that I haven't > given in a while, and there are always new faces at the conferences that > haven't seen them at all, but I enjoy putting new ones together. The only > problem is, I've run out of ideas. > > Anyone have a wish list of presentations they would like to see at the IIUG > Conference that they haven't seen before or ones that haven't been > presented > in a few years that you'd like to see refreshed? While mostly this is for > me personally, however, even if you don't think your idea is one that I'd > be > interested in pursuing, post it anyway (or send it to me directly of you > are > shy or lurking), I'll pass the list on to other presenters and to some > IBMers to see if anyone else is interested in putting something together. > > No guarantees, even if I put a presentation deck together there's no > knowing > if the CPC will find room for me to present it, but if the idea is popular, > well.... > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > --0016e6509dd872dc060491d4cd93 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001485f79632c43fe20492093692 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Especially dealing with maintaining larger tables and indexes. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 7, 2010 at 1:12 PM, Mark Jamison <mjamison@us.ibm.com> wrote: > Absolutely. > > I know that I've been thinking about talking to some of the new features > even in 11.50, not to mention the upcoming Panther release, that allow you > to do more maintenance with less less performance loss and less downtime. > > May have to blog about it. I know my blog is application Developers but > tools which give Developer's apps more uptime need to be discussed. > > -Mark > > *Mark Jamison* > SWG Client Support - Information Management Software > Accelerated Value Specialist > Phone: 1-479-657-7103 Internal: 465-7103 > mjamison@us.ibm.com <http://www.ibm.com/software/data/informix/support/>; > > > [image: Inactive hide details for Art Kagel ---10/07/2010 11:48:32 > AM---Interesting idea. Maybe "Planning Maintenance for 24x7x365 Serv]Art > Kagel ---10/07/2010 11:48:32 AM---Interesting idea. Maybe "Planning > Maintenance for 24x7x365 Service" That sounds like one that an IBMer should > tackle! Maybe > > > From: > Art Kagel <art.kagel@gmail.com> > To: > ids@iiug.org > Date: > 10/07/2010 11:48 AM > Subject: > Re: Need ideas [21595] > ------------------------------ > > > > Interesting idea. Maybe "Planning Maintenance for 24x7x365 Service" That > sounds like one that an IBMer should tackle! Maybe Spokey Wheeler or Mark > Jamison will take up the challenge sounds like it's a subject that would be > near to their hearts. > > Art > > Art S. Kagel > Advanced DataTools (*www.advancedatatools.com*<http://www.advancedatatools.com/>; > ) > IIUG Board of Directors (*art@iiug.org* <art@iiug.org>) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, implicitly, > or by inference. Neither do those opinions reflect those of other > individuals affiliated with any entity with which I am affiliated nor those > of the entities themselves. > > > > On Thu, Oct 7, 2010 at 12:16 PM, FRANK <*yunyaoqu@gmail.com*<yunyaoqu@gmail.com>> > wrote: > > Any one interested in large table management skills? Want to keep data > fast > and online forever? > > Moving older data to historical tables is not preferred; > > Table fragmentation may still give you some headaches: detach/attach, > fragmentation key for both data and index,data skew, re-fragment..... > > Table Siblings? how to design and use ?...... > > Others? > > Frank > > On Mon, Oct 4, 2010 at 9:44 PM, Art Kagel <*art.kagel@gmail.com*<art.kagel@gmail.com>> > wrote: > > > Fellow Informixers: > > > > I'm looking for new ideas for a presentation or two to prepare for > the 2011 > > IIUG Conference in mid May. I can update some older ones that I > haven't > > given in a while, and there are always new faces at the conferences > that > > haven't seen them at all, but I enjoy putting new ones together. The > only > > problem is, I've run out of ideas. > > > > Anyone have a wish list of presentations they would like to see at > the IIUG > > Conference that they haven't seen before or ones that haven't been > > presented > > in a few years that you'd like to see refreshed? While mostly this is > for > > me personally, however, even if you don't think your idea is one that > I'd > > be > > interested in pursuing, post it anyway (or send it to me directly of > you > > are > > shy or lurking), I'll pass the list on to other presenters and to > some > > IBMers to see if anyone else is interested in putting something > together. > > > > No guarantees, even if I put a presentation deck together there's no > > knowing > > if the CPC will find room for me to present it, but if the idea is > popular, > > well.... > > > > Art > > > > Art S. Kagel > > Advanced DataTools (*www.advancedatatools.com*<http://www.advancedatatools.com/>; > ) > > IIUG Board of Directors (*art@iiug.org* <art@iiug.org>) > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > and > > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other > > organization with which I am associated either explicitly, > implicitly, or > > by > > inference. Neither do those opinions reflect those of other > individuals > > affiliated with any entity with which I am affiliated nor those of > the > > entities themselves. > > > > --0016e6509dd872dc060491d4cd93 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001485f79632c43fe20492093692 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --00163613a328b8ac2c04920a3e43
Sounds like you know what you want to say. Go online and put a proposal in for a presentation. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 7, 2010 at 2:05 PM, Mark Jamison <mjamison@us.ibm.com> wrote: > Absolutely. Because with small tables you can usually get away with a > tried and true war dial method. With Large tables, that method is almost > always a guaranteed form or frustration. > > > > *Mark Jamison* > SWG Client Support - Information Management Software > Accelerated Value Specialist > Phone: 1-479-657-7103 Internal: 465-7103 > mjamison@us.ibm.com <http://www.ibm.com/software/data/informix/support/>; > > > [image: Inactive hide details for Art Kagel ---10/07/2010 12:34:35 > PM---Especially dealing with maintaining larger tables and indexes.]Art > Kagel ---10/07/2010 12:34:35 PM---Especially dealing with maintaining larger > tables and indexes. > > > From: > Art Kagel <art.kagel@gmail.com> > To: > Mark Jamison/Bentonville/IBM@IBMUS > Cc: > ids@iiug.org > Date: > 10/07/2010 12:34 PM > Subject: > Re: Need ideas [21595] > ------------------------------ > > > > Especially dealing with maintaining larger tables and indexes. > > Art > > Art S. Kagel > Advanced DataTools (*www.advancedatatools.com*<http://www.advancedatatools.com/>; > ) > IIUG Board of Directors (*art@iiug.org* <art@iiug.org>) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, implicitly, > or by inference. Neither do those opinions reflect those of other > individuals affiliated with any entity with which I am affiliated nor those > of the entities themselves. > > > > On Thu, Oct 7, 2010 at 1:12 PM, Mark Jamison <*mjamison@us.ibm.com*<mjamison@us.ibm.com>> > wrote: > > Absolutely. > > I know that I've been thinking about talking to some of the new > features even in 11.50, not to mention the upcoming Panther release, that > allow you to do more maintenance with less less performance loss and less > downtime. > > May have to blog about it. I know my blog is application Developers but > tools which give Developer's apps more uptime need to be discussed. > > -Mark > > > *Mark Jamison* > SWG Client Support - Information Management Software > Accelerated Value Specialist > Phone: 1-479-657-7103 Internal: 465-7103* > **mjamison@us.ibm.com* <mjamison@us.ibm.com><http://www.ibm.com/software/data/informix/support/>; > > > > > [image: Inactive hide details for Art Kagel ---10/07/2010 11:48:32 > AM---Interesting idea. Maybe "Planning Maintenance for 24x7x365 Serv]Art > Kagel ---10/07/2010 11:48:32 AM---Interesting idea. Maybe "Planning > Maintenance for 24x7x365 Service" That sounds like one that an IBMer should > tackle! Maybe > > From: > Art Kagel <*art.kagel@gmail.com* <art.kagel@gmail.com>> > To:* > **ids@iiug.org* <ids@iiug.org> > Date: > 10/07/2010 11:48 AM > Subject: > Re: Need ideas [21595] > ------------------------------ > > > > > Interesting idea. Maybe "Planning Maintenance for 24x7x365 Service" > That sounds like one that an IBMer should tackle! Maybe Spokey Wheeler or > Mark Jamison will take up the challenge sounds like it's a subject that > would be near to their hearts. > > Art > > Art S. Kagel > Advanced DataTools (*www.advancedatatools.com*<http://www.advancedatatools.com/>; > ) > IIUG Board of Directors (*art@iiug.org* <art@iiug.org>) > > Disclaimer: Please keep in mind that my own opinions are my own > opinions and do not reflect on my employer, Advanced DataTools, the IIUG, > nor any other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > > > On Thu, Oct 7, 2010 at 12:16 PM, FRANK <*yunyaoqu@gmail.com*<yunyaoqu@gmail.com>> > wrote: > Any one interested in large table management skills? Want to keep > data fast > and online forever? > > Moving older data to historical tables is not preferred; > > Table fragmentation may still give you some headaches: > detach/attach, > fragmentation key for both data and index,data skew, > re-fragment..... > > Table Siblings? how to design and use ?...... > > Others? > > Frank > > On Mon, Oct 4, 2010 at 9:44 PM, Art Kagel <*art.kagel@gmail.com*<art.kagel@gmail.com>> > wrote: > > > Fellow Informixers: > > > > I'm looking for new ideas for a presentation or two to prepare > for the 2011 > > IIUG Conference in mid May. I can update some older ones that I > haven't > > given in a while, and there are always new faces at the > conferences that > > haven't seen them at all, but I enjoy putting new ones > together. The only > > problem is, I've run out of ideas. > > > > Anyone have a wish list of presentations they would like to see > at the IIUG > > Conference that they haven't seen before or ones that haven't > been > > presented > > in a few years that you'd like to see refreshed? While mostly > this is for > > me personally, however, even if you don't think your idea is > one that I'd > > be > > interested in pursuing, post it anyway (or send it to me > directly of you > > are > > shy or lurking), I'll pass the list on to other presenters and > to some > > IBMers to see if anyone else is interested in putting something > together. > > > > No guarantees, even if I put a presentation deck together > there's no > > knowing > > if the CPC will find room for me to present it, but if the idea > is popular, > > well.... > > > > Art > > > > Art S. Kagel > > Advanced DataTools (*www.advancedatatools.com*<http://www.advancedatatools.com/>; > ) > > IIUG Board of Directors (*art@iiug.org* <art@iiug.org>) > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > and > > do not reflect on my employer, Advanced DataTools, the IIUG, > nor any other > > organization with which I am associated either explicitly, > implicitly, or > > by > > inference. Neither do those opinions reflect those of other > individuals > > affiliated with any entity with which I am affiliated nor those > of the > > entities themselves. > > > > --0016e6509dd872dc060491d4cd93 > > > > > > > > > >
Fernando,
As I said I'm new to OAT and do not know all the ins and outs of it. I think
OAT will give suggested values for some of the parameters, is it a good idea
to take these Yes/No? I'm not sure if all parameters are in OAT, I thought
only the dynamic ones where, but I could be wrong as I haven't really checked.
Since IBM seems to be pushing the use of OAT I wanted to know from an 'expert'
when to use OAT, when to do it the old fashion way of manual editing the
onconf file. Are the suggested values a good value to use, will using OAT and
manual editing mess you up, should you do one or the other.
It boils down to, OAT is a new tool I don't have time to learn, and was hoping
for some warning on the land mines in using it.
John
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Fernando
Nunes
Sent: Wednesday, October 06, 2010 7:32 PM
To: ids@iiug.org
Subject: Re: Need ideas [21591]
On Wed, Oct 6, 2010 at 8:09 PM, John Adamski <adamski@graceland.edu> wrote:
> I like the onconf file parameters idea and since I'm just starting to
> us OAT; any good, bad and ugly of using or not using OAT to change
> them.
>
>
Can you explain this better? Are you referring to the fact that OAT may give
you suggestions about the parameters, or simply the ability to change them
(the ones which are dynamically changeable) using OAT?
If you just mean using OAT to change them, it's exactly the same as changing
them using "onmode -wm/wf" or changing the values directly in $ONCONFIG.
Thanks!
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--000325574d668d64310491fc03ad
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
On Fri, Oct 8, 2010 at 4:24 PM, John Adamski <adamski@graceland.edu> wrote:
> Fernando,
>
> As I said I'm new to OAT and do not know all the ins and outs of it. I
> think
> OAT will give suggested values for some of the parameters, is it a good
> idea
> to take these Yes/No? I'm not sure if all parameters are in OAT, I thought
> only the dynamic ones where, but I could be wrong as I haven't really
> checked.
>
OAT shows you ALL the ONCONFIG parameters (even the ones you haven't set,
and the ones that are not documented (!) ) and you can see a brief
explanation about them.
It allows you to change the ones that are dynamically changeable and you can
choose to change it in memory only or both in memory and in the file).
Not that there are some parameters that you can really change dynamically
BTSCANNER (using onmode) but OAT tells you they're not changeable (because
you can't change them with onmode -wm/-wf)
As with any suggested value (let it be OAT, the manual, an "expert" on the
net etc.) I will always take that with a grain of salt. I like to understand
the rationale behind the suggestion.
So, if you don't think differently you could use the suggestions. It doesn't
mean it will be the best choice for your environment.
> Since IBM seems to be pushing the use of OAT I wanted to know from an
> 'expert'
> when to use OAT, when to do it the old fashion way of manual editing the
> onconf file. Are the suggested values a good value to use, will using OAT
> and
> manual editing mess you up, should you do one or the other.
>
The way you change the parameters is irrelevant (either manually and
restart, or onmode -wm/-wf, or OAT, or SQL ADMIN API....). What really
matters is the change itself.
>
> It boils down to, OAT is a new tool I don't have time to learn, and was
> hoping
> for some warning on the land mines in using it.
>
I begun to look at OAT without to much trust... I should be honest about
this.... With time I changed my position radically. Today I love OAT. There
are other opinions from very respectable people here, so I think I should
take a few moments to make some considerations:
1- As anything, specially a relatively new tool, OAT is not perfect.
2- People tend to mix three components: DbScheduler, SQL Admin API, and OAT
(and maybe sysadmin). The truth is that these are all connected, but are
very different things:
- dbscheduler tries to work on the autonomics side of Informix. It's
something that other RDBMS have, something that the market wants and I
believe it's a good idea
- SQL Admin API was a necessary thing to allow remote tools to interact with
the engine in a "natural" (SQL) way. Many people don't like the fact that
IBM is using this to implement a lot of new functionality but I don't see
this as a big problem and I believe I can see the advantages (one of which I
won't talk to anyone outside IBM, specially because I may be wrong :) )
- OAT is a tool that we needed forever. Like we needed ISA, but the looks
and lack of SQL Admin API killed it (did I mention that OAT looks good?)
3- If you don't like the "autonomics" stuff you can stop the tasks or even
the scheduler and still use OAT and SQL Admin API
4- OAT is extensible. And I'm not just echoing IBM marketing.... I did
create two plugins for it. Easy, quick and powerful. It's a shame we could
not (yet) create a real community of OAT developers. I understand that
Informix "DBAs" (the quotes come from the fact that I rarely see one, only
sysadmins who manage a database) have more things to do, but it's still a
shame...
5- IBM have demonstrated over the two last years, that OAT is here to stay.
Every new engine functionality is mapped into OAT options.
6- OAT makes life easier for newbies... And we want to welcome them in the
Informix community
7- Me too used to be (I still am) an onstat/onmode addict. But it doesn't
necessarily mean I can't accept new/better ways to do some things.
Why did I wrote all this? Because I love OAT :)
It's incredible simple to install.... Do it and take a look in your free or
less busy time. Explore it using one of your test engines. I believe you'll
begin to like it. And please take note of what you don't like and post it
into the oat mailing list. It can be improved by us (the community).
Regards.
P.S.: I'm striving to have some free time so that I can post some tasks for
monitoring many components in our engines... At this moment I have tasks to
monitor extents, memory usage, condition waiting (locks, buffers, mutexes,
logical log buffers and even too many "active" sessions), space, backups....
All being used successfully in customer site.
Regards.
> John
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Fernando
> Nunes
> Sent: Wednesday, October 06, 2010 7:32 PM
> To: ids@iiug.org
> Subject: Re: Need ideas [21591]
>
> On Wed, Oct 6, 2010 at 8:09 PM, John Adamski <adamski@graceland.edu>
> wrote:
>
> > I like the onconf file parameters idea and since I'm just starting to
> > us OAT; any good, bad and ugly of using or not using OAT to change
> > them.
> >
> >
> Can you explain this better? Are you referring to the fact that OAT may
> give
> you suggestions about the parameters, or simply the ability to change them
> (the ones which are dynamically changeable) using OAT?
>
> If you just mean using OAT to change them, it's exactly the same as
> changing
> them using "onmode -wm/wf" or changing the values directly in $ONCONFIG.
>
> Thanks!
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
> --000325574d668d64310491fc03ad
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--001636417525ae7e1404921dc297