|End of Support Dates|
Highlights: Electing the 2015 IIUG board of directors
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.
February was, as it always is in the northern hemisphere, cold. Jerusalem even had 10 inches of snow. I hope the weather will be warming up soon.
It will definitely warm up for the IIUG. We will be electing the new IIUG board in March and we will have IIUG2015 in April. The elections are your chance to influence the direction of the IIUG by standing for elections or by voting. The 2015 board will be presented at IIUG2015 in San Diego.
Don't miss our event. It is the largest Informix gathering in the world. There are many outstanding sessions, leading Informix developers and support engineers, friends, colleagues, parties and more. San Diego is a great location. I know I have said it many times. As a matter of fact, I repeat myself every year hoping to convince those who never came and those who did but are not planning to attend this year.
See you in San Diego.
Electing the 2015 IIUG Board of Directors
Elections for IIUG Board of Directors
Each year the membership of the International Informix Users Group elects its Board of Directors. Anyone who became an IIUG member at least a month prior to the election is eligible to vote via online ballot at http://www.iiug.org. This year the new Board of Directors will be installed on May 1, 2015.
The election is a democratic process whereby the candidates who get the most votes and confirm their interest to serve in a timely manner after being contacted with the results will be confirmed as elected. To avoid potential conflicts of interest, votes are automatically tallied and manually validated by the members of the IIUG Nominating Committee who are not standing for election.
The IIUG Board of Directors election is overseen by a Nominating Committee that supervises both the nomination process and the election. The members of Nominating Committee are appointed by the current Board of Directors.
2015 Election Timeline
Notes to the above
The CandidatesCandidates for the IIUG Board of Directors are selected by the IIUG Nominating Committee who try to find nominees that represent a wide geographical membership as well as a mix of product utilization, and who can meet the many and varied challenges and functions of the Board.
Candidate Selection Process
IIUG members who are interested in running for a seat on the IIUG Board of Directors should submit the completed Nominee Questionnaire below to firstname.lastname@example.org prior to the close of the announced deadline for nominations. The resulting nominees are announced prior to the election and candidate statements are posted on the IIUG Website and on the ballot as well.
All currently elected board members are REQUIRED to attend at least two board meetings that could be held anywhere in the world and the annual IIUG2015 Conference. Failure to do so will result in removal from the board. Expenses will be covered as part of being a member of the IIUG Board. Also a one hour conference call is held each month (during business hours). All Board members are expected to be part of this call. Failure to do so, could also result in removal from the IIUG Board. Interested candidates for IIUG Board should clear this with their employer prior to submitting their name as a candidate.
IIUG Board Members Duties
Serving on the IIUG Board of Directors is a minimum one-year commitment. It requires travel to meetings, monthly conference calls, and regular e-mail communication with other Board members as described above. The Board meets formally for two to four days up to three times a year, whenever possible during weekends.
In addition to representing and serving Informix users worldwide, Board members are expected to think strategically about the future of the Informix community and their relationship with IBM. Fringe benefits of serving on the IIUG Board include expenses-paid attendance to the IIUG Informix User Conference and all other required meetings, direct contact with IBM executives, early access to product and service news, visibility and leadership development.
To learn more about what it is like to be a member of the IIUG Board of Directors, please see Being an IIUG Board Member. A personal view, by Neil Truby.
Hurry! Regular Registration extended to March 2nd
There is less than 1 week left before the Late Registration price increase for IIUG2015 takes effect. You have until midnight (EST) Monday, March 2, 2015 to register for IIUG2015 in San Diego.
Register now to receive the Standard Registration rate and apply your $100 IIUG Membership Discount for a total cost of $1050 USD. This year we will also be celebrating the 20th Birthday of the IIUG. Join us for IIUG2015, the Seventh Annual IIUG event.
Remember, your IIUG2015 registration guarantees you entrance to the April 30th tutorials at NO ADDITIONAL CHARGE for all paid attendees. We will also offer the ever popular hands-on labs. This is a great opportunity to extend your training budget.
We are still finalizing our hands-on labs and tutorial topics. Here is a list of potential topics for this year:
...And much, much more
Speakers are continuing to submit their presentations for IIUG2015. As these sessions are submitted we will continue to add them to the conference website. The speakers at IIUG2015 are the best the Informix community has to offer. New speakers and familiar faces are eager to share their knowledge and expertise while presenting interesting and relevant topics that can be used to reinforce your professional skills.
We are finalizing out keynotes for this year and are pleased to announce Jeff Jonas as one of our keynote speakers. Jeff's work has received wide media attention from the Wall Street Journal, The Washington Post, Fortune Magazine, MSNBC and National Public Radio. A highly sought after speaker, Jeff travels the globe discussing innovation, national security, and privacy with government leaders, industry executives, and leading global think tanks. He is on the boards of the US Geospatial Intelligence Foundation (USGIF) and the Electronic Privacy Information Center (EPIC), a Senior Associate at the Center for Strategic and International Studies (CSIS), and a Distinguished Engineer of Information Systems (adjunct) at Singapore Management University (SMU).
Use our Justification Document if you are still having problems convincing your boss this is a valuable way to spend your training budget.
We look forward to seeing you!
Apr 26 — April 30, 2015
Marriott Mission Valley, San Diego CA
No Leap day, just a Leap Second
Our 2015 calendar year has no leap day in February, but we will have a Leap Second addition on June 30th 2015, at 23:59:60. This will provide a correction to keep the International atomic clock aligned with the earth's rotation. A leap second announcement can be a challenge for computing at the Operating System level, especially when the system is tied to the atomic clock (UTC timing) interval. Understandably, a DBA could become very worried about the impact when a one second adjustment is not handled well.
For Informix products, a leap second has occurred 10 times between 1990 and 2015, and the product quietly keeps doing what it needs to do. Informix datetime seconds can span the range of 0 to 61 seconds in the datetime format. As long as the client-side application does not limit the number of seconds solely to the range of 0 to 59, the server side datetime seconds value will be able to handle up to 2 leap seconds. The environment variable GL_DATETIME provides additional formatting options.
- David Jay
IBM Internet of Things Architecture and Capabilities The IIUG 2015 Promo video
Video is live right here: http://youtu.be/uelOj90z8EI
Just in case you are not aware, some time ago IBM created a public website to collect the requests for new features directly from users. The RFE (Requests For Enhancements) website is included in developerWorks. You can access it here.
Once you logged in with your usual IBM ID, choose "Information Management" in the Brand dropdown box and "Informix Servers" or "Client Products" in the Products dropdown box.
The interesting thing is that any request, including your request, if you place one, are submitted to be voted on. This means the RFEs that receive more votes have a greater chance to be considered by the architecture and development teams for further consideration. In other words, this IS the opportunity to provide enhancement ideas even if you are not the biggest IBM customer on the planet Earth.
Some RFEs will be of great interest, others will not seem useful to you. This is why your opinion is important. Do not hesitate to vote and place comments!
The idea of the RFE corner is to provide a digest on new Informix RFEs and make those RFEs more visible and accessible for the community, so that you can vote for them in a faster and easier way. By participating actively in this website, IBM will have solid and useful elements from the customer base to introduce new functionality to Informix product.
Also in the area of IBM website, a new functionality has been released: MyNotifications. You will want to register this webpage in order to receive the notifications of your choice (new product defects, new patch release, new versions etc..., on the frequency of your choice (daily, weekly). I have registered and will definitely keep registered, due to the value of the information delivered.
New RFEs for February 2015
We have a large about approaching 1 Tb in data only which has an expression-based fragmentation storage schema.
When we created the table FRAGMENT BY INTERVAL was not available but the table has an expression-based schema compatible with interval partitioning.
One major problem we have is that the expression-based schema is by date and the last partition ends on Sept 30th 2015.
We are looking at options for this table. If it were created again today doubtlessly we would look at interval-based fragmentation.
We would like to request a mechanism whereby suitable expression-based fragmentation can be converted to interval-based. This would ideally include the indices on the table but if, not we could take an extended outage to rebuild them.
Using spatial functions is limited to the database in which it is defined. If you have to combine a spatial function with spatial data in 2 different databases you first need to convert 1 datatype to varchar. This is slowing down the performance.
When you migrate a database from the production environment to test or development, you have to drop the database on test/development, before you can import the production database. This because you can.t rename a database with spatial information.
If it's possible to rename this database, you can fist execute the import in a different database, if the import is ok, rename the old database and put the newly imported database in place.
Currently if we try to add an existing chunk to the dbspace it does not give any error that chunk is already in use. The server crashes if a chunk is re-used and the only way is to restore it back from backup.
Our team uses product informix for our project.
Red Brick Ver6.30.xC15
The customer enhancement request function addition to output error message indicating the cause of SELECT statements that use large IN lists caused the Red Brick 10410 and 10410 error occurred. The customer can't judge the cause of this error. It error mean is connection error message below.
** FATAL ** (10410) Could not receive from the server. OS error: No error (0).
The PMR#27774,999,760 happened to the customer add a function to output the following messages.
For example error message:
This issue summary Red Brick error message ** FATAL ** (10410), could not receive from the server when running query with large IN LIST.
The following fixed case to be the origin of this error.
IBM Informix home page Informix blogs and wikis
Blogs and Wikis that have been updated during the last month
More Blogs and Wikis
Forums, groups, videos, and magazines
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.
For comments, please send an email to email@example.com.