Highlights: Revealing Centaurus
Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.
- Conference corner
- Informix news
- Developer corner
- Support corner
- Informix corner
- Informix resources
- Useful links
- Closing and credits
|Editorial||Back to top|
I have 3 requests.
Stay tuned for the Centarus release.
Vote for the IIUG board on the upcoming elections.
Register to the IIUG conference.
Looking forward to meeting you at the IIUG conference in San Diego
IIUG Insider Editor
|Highlights||Back to top|
In the March edition I hope to write about a different Centarus which is the code name for Informix 12. But as I am under NDA all I can say for now is expect a great release loaded with new features. Until Informix 12 is officially announced enjoy the following text from Wikipedia about the Centaurus mankind has been admiring since the beginning of history.
Centaurus contains several very bright stars because of its position in the Milky Way; in addition, its alpha and beta stars are used to find the constellation Crux. The constellation has 281 stars above magnitude 6.5, meaning that they are visible to the unaided eye, the most of any constellation. Alpha Centauri, one of the closest stars to the Sun, has a high proper motion; it will be a mere half-degree from Beta Centauri in approximately 4000 years.
Alpha Centauri is a triple star system that contains Proxima Centauri, the nearest star to the Sun. Traditionally called Rigil Kentaurus or Toliman, meaning “foot of the centaur”, the system has an overall magnitude of -0.28 and is 4.4 light-years from Earth. The primary and secondary are both yellow-hued stars; the primary, is of magnitude -0.01 and the secondary is of magnitude 1.35. Proxima, the tertiary star, is a red dwarf of magnitude 11.0; it is almost 2 degrees away from the primary and secondary and has a period of approximately one million years. Also a flare star, Proxima has minutes-long outbursts where it brightens by over a magnitude. The primary and secondary have a period of 80 years and will be closest to each other as seen from Earth in 2037 and 2038.
In addition to Alpha Centauri (the 3rd brightest star in the sky), a second first magnitude star, Beta Centauri, is part of Centaurus. Also called Hadar and Agena, Beta Centauri is a double star; the primary is a blue-hued giant star of magnitude 0.6, 525 light-years from Earth. The secondary is of magnitude 4.0 and has a very small separation. A bright binary star in Centaurus is Gamma Centauri, which appears to the naked eye at magnitude 2.2. The primary and secondary are both blue-white hued stars of magnitude 2.9; their period is 85 years.
Centaurus also has many dimmer double stars and binary stars. 3 Centauri is a double star with a blue-white hued primary of magnitude 4.6 and a secondary of magnitude 6.1. The primary is 298 light-years from Earth.
Centaurus is home to many variable stars. R Centauri is a Mira variable star with a minimum magnitude of 11.8 and a maximum magnitude of 5.3; it is 2100 light-years from Earth and has a period of 18 months. V810 Centauri is a semiregular variable.
BPM 37093 is a white dwarf star whose carbon atoms are thought to have formed a crystalline structure. Since diamond also consists of carbon arranged in a crystalline lattice (though of a different configuration), scientists have nicknamed this star “Lucy” after the Beatles song “Lucy in the Sky with Diamonds.”
IIUG – Election time IIUG Board of Directors 2013
The 2012 IIUG Board of Directors is a diverse group of users, partners and IBM employees from all over the world. The current IIUG Board will complete its term soon. In preparation for the upcoming election of the 2013 IIUG Board, a Nominating Committee has been established chaired by former Board Member James Edmiston.
The committee is currently seeking candidates to run for the 2013 IIUG Board of Directors. If you have a passionate interest in Informix products, and the drive, vision, and commitment to lead and represent the world’s most influential community of Informix users, please give your potential nomination serious thought.
Nominations will be accepted until March 4, 2013 and the election will take place shortly thereafter.
For additional info, visit the Annual IIUG Board of Directors Election Information page.
If you would like to nominate yourself or a colleague, please contact the IIUG Nominating Committee by writing to firstname.lastname@example.org.
Former IIUG Board Member
IIUG Elections Commissioner 2013
|Conference corner||Back to top|
Learn about Informix Centaururs
Even at $1099 this year’s conference is still the best technical conference bargain on the planet. Those of you who are IIUG members (and that membership is FREE) will save an additional $100 from the above registration rate, but that IIUG Member Discount DISAPPEARS on April 1! Whenever it is that you get off your duff and sign up, you will set yourself up to attend the biggest meeting of the minds in the IBM Informix world. Don’t wait, Register now!
The sessions lined up include deep dive views of “Centaurus,” the still secret (oops, not anymore) “VNext” release of Informix. Several of us on the planning committee have been part of the Early Release program for the new version, and its new features bring Informix major steps forward in popular areas including nearly automatic provisioning and configuration, continuous availability and improved extensibility. Other new topics being covered for the release include the use of Recursive SQL and query transformation in the new release, as well as new indexing techniques being made available.
One major change from previous conferences is that the tutorials, being held on Thursday April 25, are included at NO EXTRA COST for all paid attendees. The tutorials will focus on configuration and performance tuning, but will NOT limit themselves to the latest versions but will also cover older versions of Informix, including those no longer supported by IBM (We all know, and many of us still use, Versions 7, 9 and 10)! The list of tutorials will be posted to the Conference website very soon! Don’t forget to select your tutorials when they become available to reserve your space.
We now have the list of sessions (more to come as we get speaker confirmations) and speakers available for viewing on this year’s Conference website. This impressive list of topics is intended to increase or reaffirm your Informix knowledge and skills. We have several new speakers to the conference as well as many of your favorite speakers from past conferences. All have been gracious enough to share their knowledge with the Informix community.
Don’t forget to check out the sponsors for this year’s conference. When you attend the Conference please visit our sponsors and let them share information on their products and services with you. They may have something you have been looking for!
The Conference Planning Committee is looking forward to seeing some old friends and making new friends this year. Hope we see you there!
April 21-25, 2013
Marriott Mission Valley
San Diego, California, USA
IIUG Conference Planning Committee
|Informix News||Back to top|
Trusted employees commit more compliance violations than anyone else. Government and industry groups have responded by enacting fraud management regulations designed to protect public and shareholder interests. But your business generates enormous volumes of network traffic every day. Tracking and sifting through all user activity for abuse, misuse, and error can feel like an impossible task. Fortunately, technology exists to help you overcome these challenges
Continuous monitoring is the key to knowing exactly who did what and when – then being able to put that information into context. Take 3 bold steps and start to monitor and manage risk within your legacy mainframe applications, web applications, and across the enterprise. These three steps, deliver the intelligence you need to take informed action for auditing, compliance, and general risk management purposes.
Please download the complimentary White Paper for more information.
|Developer corner||Back to top|
For more information go to DeveloperWorks – Informix.
|Support corner||Back to top|
How to find the application that’s running a particular SQL?
It is not uncommon that an inefficient SQL statement causes overall performance problems. In that scenario, first you need to identify the problematic SQL, next find out the user and application that executing the SQL. Here is a glimpse to address the second part of the problem.
There are different possible ways to find out the user and application running a particular SQL. The ‘onstat -g ses <sessionid>’ command is the simple way figure out the application that running a SQL. Do you notice anything new in the following ‘onstat -g ses <session id>’ output?
First you are creating a procedure under ‘sysadmin’ database named ‘delete_apb_documents_proc()’ that removes all files as ‘apb_document*’ from /tmp directory which were accessed more than 60 minutes ago.
IBM Informix Dynamic Server Version 11.70.FC5 -- On-Line -- Up 16:41:52 -- 1048576 Kbytes session effective #RSAM total used dynamic id user user tty pid hostname threads memory memory explain 34 informix - 1 19387 garion 1 278528 217656 off Program : /usr2/support/products/11.70.FC5/bin/dbaccess tid name rstcb flags curstk status 176 sqlexec 145629268 B--PX-- 13103 yield bufwait- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 34 V 145b99040 274432 60064 376 27 34*O0 V 145b0d040 4096 808 1 1 name free used name free used overhead 0 6576 scb 0 144 opentable 0 13880 filetable 0 4312 ru 0 600 log 0 16536 sqscb info scb sqscb optofc pdqpriority optcompind directives 142e211c0 145b53028 0 0 0 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 34 INSERT stores NL Not Wait 0 0 9.24 Off Current statement name : inscur Current SQL statement (997) : insert into customer values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
You are right. There is a new ‘Program’ section in above onstat output. Now, you can use the ‘onstat -g ses <session id>’ command to display the full path of the client program that used in a session. Use the client program information to monitor or control the application access to the database. One thing you should know that the program information is sent by the client itself, and name of the program totally depends on the client.
– Sanjit Chakraborty
|Informix corner||Back to top|
Informix Warehouse Accelerator Bootcamp
Plan now to attend this exciting event.
Would your business benefit from “speed of thought” analysis of warehouse data and/or operational data? If so, you cannot afford to miss this one day, no-cost event to learn about IBM Informix Warehouse Accelerator (IWA): IBM’s patent-pending software technology that exponentially accelerates even the most complex queries. IWA loads data completely into system memory in a compressed form, using a special columnar scheme developed by IBM Research. As queries come in, the Informix database passes them to the Informix Warehouse Accelerator which can scan billions of rows of data in seconds to return immediate results.
Attendees will get hands-on experience with the Informix Warehouse Accelerator technology to create and use in-memory data marts that dramatically and exponentially reduce the amount of time required to execute data warehouse or analytical queries. Business and technical use cases will be presented to show how customers around the world are already using this technology with dramatic business benefits. Attendees will also learn all about the newest capabilities of IWA available with the Informix 12.1 “Centaurus” release!
This session is offered free of charge. Complimentary refreshments, including continental breakfast and lunch will be provided. Participants are responsible for their own business travel expenses.
Informix Flexible Grid Bootcamp
Save your spot for the upcoming Free Informix Flexible Grid Bootcampafter the IIUG Conference.
|Informix resources||Back to top|
http://www.informix.com or directly at: http://www-01.ibm.com/software/data/informix/
I am trying something new on this section. I will first mention the blogs and wikis that have been updated during the last month. Blogs and wikis that have not been updated for over 6 months will be removed.
Blogs and Wikis that have been updated during the last month
- Blogs, Videos, News and more *** Up to date feeds from many blogs ***
- IDS Experts
- Fernando Nunes
- Jacques Roy
- Informix documentation team
- Andrew Ford
- Gary Proctor
- Louis T. Cherian
- Mark Jamison
More Blogs and Wikis
- Jerry Keesee
- John Miller
- A Latin blog maintained by support
- Art Kagel’s
- Informix Support
- Keshava Murthy
- Eric Vercelletto (English)
- Eric Vercelletto (French)
- Roger Powell
- Informix Interoperability with Other Products
Forums, Groups, Videos, and Magazines
- The IIUG forums
- Informix Marketing channel on YouTube
- IBM DATABASE MAGAZINE
- The Informix Zone
- There is now an Informix group on LinkedIn. The group is called “Informix Supporter”, so anyone loving Informix can join, from current IBM employees, former Informix employees, to users. It will also be a good occasion to get in touch with others or long-time-no-seen friends. If you fancy showing the Informix logo on your profile, join. Join here.
|Useful links||Back to top|
|Closing and credits||Back to top|
The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG’s membership database now exceeds 25,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.
|Sources:||IIUG Board of Directors
For comments, please send an email to email@example.com.