Save 
Join IIUG
 for   
 

Informix News
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter


Insider

IIUG Insider (Issue #152)
February 2013

Other Issues

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.

Contents:

 

Editorial Back to top

Friends,

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

Gary Ben-Israel
IIUG Insider Editor


Highlights Back to top

Revealing Centaurus

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 board-election@iiug.org.

James Edmiston
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

Articles

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

New in DeveloperWorks
28-Feb-2013
Learn you how to connect and use Informix as a data source or a data target with InfoSphere Streams. It covers the use of both the Informix-specific protocol and the more general IBM Common Driver protocol that is used by several IBM database products. After reading this article, a reader will be able to use Informix in a Streams environment

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.

Registration

Informix Flexible Grid Bootcamp

Save your spot for the upcoming Free Informix Flexible Grid Bootcampafter the IIUG Conference.

Registration


Informix resources Back to top

IBM Informix home page

http://www.informix.com or directly at: http://www-01.ibm.com/software/data/informix/

Informix blogs and wikis

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

More Blogs and Wikis

 
Forums, Groups, Videos, and Magazines  

Useful links Back to top

http://www.iiug.org/quicklinks.html


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
IBM Corp.
Editors:  Gary Ben-Israel
Rhonda Hackenburg

For comments, please send an email to gary@iiug.org.