|End of Support Dates|
IIUG Insider (Issue #50)
|13:30||Welcome & Introduction|
|13:50||Update on IBM's Roadmap for Red Brick Development|
Coffee and discussion break
|16:30||Optimizing RedBrick Performance and System Tuning|
|18:30||Dinner, sponsored by IBM|
|09:15||Red Brick Loader Performance|
Coffee and discussion break
|11:30||Query Performance monitor|
|13:30||Best Practices - SQL / OLAP|
Best Practices - Vista (creating aggregate tables and query)
Coffee and discussion break
For more information, contact: Gill Dawson, e-mail: Gill_Dawson@uk.ibm.com.
IBM Informix Business Partners: Enroll Now for a Free Training Workshop in Waltham, MA - Using WebSphere With Your IBM Database.
Are you designing and developing applications running in WebSphere Application Server and have Informix Dynamic Server or DB2 Universal Database on UNIX(r) or Windows(r) as your database engine? Do you want an introduction to all aspects of integrating WebSphere with Informix or DB2 Universal Database? If so, this 3-day workshop will provide you with the information you need.
There is no charge to attend this workshop; but time is running fast, so enroll now for Aug 24 - 26 at https://www.developer.ibm.com/en_US/spc/events/ws_ibmdb.html!
Querix is organizing a 4GL Training and Workshop, based on Hydra 4.1 and the upcoming V5 P-Code Release on September 27th, in Munich, Germany. A wonderful occasion to visit the city!
For more details on Querix' planning, visit: http://www.querix.com/news/index.php?id=84.
Hydra 4.1 with support for 18 platforms & all Informix RDBMS (4.1-9.4) available for download on the 30th August
The new Release for Hydra 4.1 with support for 18 platforms and all Informix RDBMS systems (from 4.1 to the latest 9.4) is available for download http://www.querix.com/download from 30th August. IIUG members can download a free 2-user License including 3 months technical support.
Led by a team of Informix experts, Awoma provides a suite of development and database manipulation tools perfectly suited for IBM-Informix users. Awoma tools will enable users to adopt current IBM technology, such as WebSphere, DB2 or J2EE, while leveraging existing assets.
Awoma tools include ThinStructure, DevWorkshop, SysTools and DB Studio.
DB Studio 2.2.0 has just been released. It is the ultimate database manipulation tool. Integrated smoothly into Awoma's graphical IDE (based on Eclipse), DB Studio provides the following:
- Connect to any database via a wizard menu, in less than 10 seconds.
- All the drivers are included.
- All major databases are supported (Informix OnLine 5, IDS 7.x, IDS 9.x, IBM DB2 and others).
- Intuitive Graphical interface.
- Connect to as many databases as you want. Concurrently. Any supported type.
- View structure of database elements, such as the database structure, tables, view, system tables, columns, indexes, primary and foreign keys, constraints...
- Query your database through an easy and efficient SQL editor.
- Create batches of SQL statements.
- Add, delete or modify your data efficiently.
- Export you SQL results to text, CSV, HTML, or even unload to Informix format.
DB Studio is available as a stand-alone product, or as plug-in of IBM WebSphere Studio, Awoma DevWorkshop 2.2.0, Awoma ThinStructure 2.2.0 and Eclipse 2.1.x.
For more information, visit http://www.awoma.com.
IBM Announces Informix XPS V8.5 - Demonstrating Continued Informix Commitment!
IBM announced the release of IBM Informix Extended Parallel Server (XPS), V8.5 on July 27, 2004. This new software release will be available for electronic delivery on August 10, 2004 and media and documentation will available from August 27, 2004.
XPS V8.50 is designed for the largest, most demanding, and most complex data warehouse applications. By including comprehensive data warehousing features and using a sophisticated shared-nothing underlying architecture, XPS achieves industry-leading performance and flexibility. This enables you to make more profitable decisions from complex, query-intensive, analytical applications.
The following major new functionality is included in XPS V8.50.
New application development features
- ISTAR/Distributed Query Coordinator
- MERGE (UPSERT)
New DBA features
- Table-level Point in Time Restore
- Scrubbed Tables
- Immutable Session Variables
- Current and Client Time zone
- ONSTAT Query Start Time
- Mixed Restore
New ease of use features
- DBAccess History
- Roles Improvements
New performance features
- Improved Fragmentation Elimination on Datetime Columns
- Improved Optimization for Groupby with Expressions Using Implicit PDQ
- Indexes on Non-logging Tables
- OR Predicates Performance Improvement
- OnBAR Thread Safe Library Support
- Read-only Dbspaces
Please contact your IBM Sales Representative to acquire the latest XPS V8.50. If you need further information regarding XPS V8.50 or IBM's Business Intelligence / Data warehousing Strategy, please contact:
XPS Development Manager - James Troisi at a href="mailto:email@example.com">firstname.lastname@example.org XPS Product Manager - Omkar Nimbalkar at email@example.com
New IBM Informix Extended Parallel Server and updated IBM Data Management Business Intelligence Gold Bundle offer Informix customers greater value and flexibility
IBM Informix Extended Parallel Server (XPS) V8.50 is designed for the largest, most demanding, and most complex data warehouse applications. By including comprehensive data warehousing features and using a sophisticated shared-nothing underlying architecture, XPS achieves industry-leading performance and flexibility. This enables you to make more profitable decisions from complex, query-intensive, analytical applications.
IBM Informix Standard Engine (SE) and OnLine Extended Edition Passport Advantage trade up part numbers to IBM Informix Dynamic Server Workgroup Edition V9.x (IDS WG) and IBM Informix C-ISAM for Linux on eServer zSeries now available.
Customers upgrading to IDS WG have the ability to leverage their investment through integrated, cost effective and competitively-based offerings with other IBM Software Group products, leverage 4GL skills in a modern application development environment by using EGL and IBM WebSphere Studio going forward, and more.
IBM also announced additional Linux on zSeries platform support for C-ISAM (5724-C41) in order to take advantage of using C-ISAM with applications running in that environment. No new part numbers are needed. C-ISAM for Linux on zSeries is included on the current C-ISAM CD.
Partner Campaigns are also available such as:
One Point Solutions, a U.S. Informix-specialized partner, offering service packages to supplement your company's efforts to migrate your database to IDS V9 from Informix SE, OnLine or IDS V7. Access: http://choices.onepointsol.com.
EMEA co-marketing partner offers are also available, contact Nicole Pelletier, EMEA SWG Sales Manager, DM SMB Channel at firstname.lastname@example.org for more information.
Access the following for the entire announcement letter: http://www.ibm.com/common/ssi/OIX.wss
Access the following for additional Informix Product information: http://www.ibm.com/software/data/informix
Real-world experiences of IDS 9.40 - Configuring Page Cleaning, by Andrew Watson of Ardenta Limited, UK:
Page cleaning is the process of updating index keys following changes to the underlying data to which the index refers to ensure the index remains an efficient representation of the actual data. When a row is deleted to improve the user response time the index item has its delete flag set to act as a marker that it needs to be cleaned.
Prior to IDS 9.40 a single threaded process called the Btcleaner handled page cleaning. A number of issues with the method used by this process led to the development of the more flexible and configurable Btscanner as its replacement. This enables the administrator to dynamically set the Btscanner's priority, the number of threads and the way in which it identifies the pages to be cleaned.
Through testing and experience on client sites migrated to IDS 9.40 the default setting of one, low priority Btscanner thread does not always appear to be optimal. This has proved to have a significant impact on key resource intensive processes and maintenance tasks such as data purging. Therefore during and after critical periods the resources allocated to the Btscanner are adjusted.
More detail on the differences between the Btcleaner and Btscanner; examples of settings and administration commands to configure and monitor the Btscanner can be found at: http://www.informix.co.uk/btscanner.htm.
The EGL momentum is growing. IIUG is looking for volunteers to animate the new forums, the download section on EGL, the FAQ, a web site...
Are you interested in doing so? Do not hesitate to contact the e-news team at email@example.com.
IIUG is proud to announce that it is hosting the first electronic forum on EGL. To join, simply go to the membership area, login, click on the on "Subscribe to E-Mail lists", choose the lists you wish to subscribe to and click "Subscribe".
EGL Development Forum (firstname.lastname@example.org)
This forum is entirely dedicated to EGL (Enterprise Generation Language) and development using EGL.
Once you are subscribed, send e-mails to email@example.com.
|Q:||How can EGL be used to produce a portlet?|
|A:||When you create a portal project you can specify that you want to use EGL. Specifically, when you create a portlet project you need to just add EGL support on the "Add Features" panel of the new project Wizard.|
Answers are coming from IBM. IIUG should not be liable for inaccuracy.
You have an EGL question? Send a mail to firstname.lastname@example.org, subject EGL.
In response to your input, we have created a new page on the IIUG web site containing all the links we used to include. Please find it at: http://www.iiug.org/quicklinks.html
Please visit the IBM Redbooks web site at http://www.redbooks.ibm.com/mail for more details and up-to-the-minute technical information.
The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. IIUG's membership database now exceeds 18,000 entries and enjoys the support and commitment of IBM's Data Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.
IIUG Board of Directors|
Jean Georges Perrin|
|For comments, please send an email to email@example.com.|