Workstream App/Informix 24x7 support
Phil Stout sought users of the Workstream application on Informix for 24x7 architecture advice, and asked whether a 2.3 million row, four-column index could be rebuilt in under 35 minutes without fragmentation. John Carlson and Jack Parker asked about version, hardware, index type, column types and row size. Vivek Chaudhary used round robin fragmentation, building indexes in maintenance mode with PDQPRIORITY, under an hour for 12 million rows.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I'm looking for a DBA or Application developer who is supporting the Workstream application by Applied Materials on Informix DB. My customer wants to be a true 24x7 application, but I can't get architecture information showing this is possible. I'd also like to know if anyone can rebuild a 2.3 million row index on 4 columns in less than 35 minutes without fragmentation. I need architecture (hardware to accomplish this response time)
I can't speak for Workstream . . . .but as to your other issues. What Informix version? What hardware? The time for the index build sounds reasonable. Are these indices attached or detached? -----Original Message----- From: PHIL STOUT [mailto:phil.stout@eds.com] Sent: Wednesday, June 04, 2003 3:34 PM To: ids@iiug.org Subject: Workstream App/Informix 24x7 support [1281] I'm looking for a DBA or Application developer who is supporting the Workstream application by Applied Materials on Informix DB. My customer wants to be a true 24x7 application, but I can't get architecture information showing this is possible. I'd also like to know if anyone can rebuild a 2.3 million row index on 4 columns in less than 35 minutes without fragmentation. I need architecture (hardware to accomplish this response time) "CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel Retail. This email message and all attachments may contain legally privileged and confidential information intended solely for the use of the addressee. If you are not the intended recipient, you should immediately stop reading this message and delete it from the system. Any unauthorized reading, distribution, copying, or other use of this message or its attachments is strictly prohibited. All personal messages express solely the sender's views and not those of WHSmith USA Travel Retail. This message may not be copied or distributed without this disclaimer."
2.3 million on 4 columns in 35 minutes? What are the column types in question, and what is the rowsize of the table? cheers j. ----- Original Message ----- From: "PHIL STOUT" <phil.stout@eds.com> To: <ids@iiug.org> Sent: Wednesday, June 04, 2003 3:33 PM Subject: Workstream App/Informix 24x7 support [1281] > I'm looking for a DBA or Application developer who is supporting the Workstream application by Applied Materials on Informix DB. My customer wants to be a true 24x7 application, but I can't get architecture information showing this is possible. I'd also like to know if anyone can rebuild a 2.3 million row index on 4 columns in less than 35 minutes without fragmentation. I need architecture (hardware to accomplish this response time) > >
I use workstream and I am sure either you're talking about wiplth or entenh. I use round robin fragmentation and indexes are only created when system is in maintenance mode so that you can use PDQPRIORITY and all that goes alongwith that. I am not sure if we can do it in 35 mins but with 12 mil. rows, I could create indexes in under an hour. BTW, its record-size is 1.7kb. Vivek > -----Original Message----- > From: phil.stout [mailto:phil.stout@eds.com] > Sent: Wednesday, June 04, 2003 12:34 PM > To: ids; forum.subscriber > Cc: phil.stout > Subject: Workstream App/Informix 24x7 support [1281] > > > I'm looking for a DBA or Application developer who is > supporting the Workstream application by Applied Materials on > Informix DB. My customer wants to be a true 24x7 application, > but I can't get architecture information showing this is > possible. I'd also like to know if anyone can rebuild a 2.3 > million row index on 4 columns in less than 35 minutes > without fragmentation. I need architecture (hardware to > accomplish this response time) > >