Informix Quick Reference Cards

Pessoal.
Seguem os links para os Informix Quick Reference Cards, como são conhecidos:

Configuration Parameters in the onconfig.std File
IBM®Informix®Version 12.10.xC4:
http://publibfp.dhe.ibm.com/epubs/pdf/i1320991.pdf

onstat Utility Commands Sorted by
Functional Category
IBM®Informix®Version 12.10.xC4:
http://publibfp.dhe.ibm.com/epubs/pdf/i1321001.pdf

SQL Administration API
IBM®Informix®Version 12.10.xC4:
http://publibfp.dhe.ibm.com/epubs/pdf/i1335011.pdf

Enterprise Replication
IBM®Informix®Version 12.10:
http://publibfp.dhe.ibm.com/epubs/pdf/i1335020.pdf

Informix JSON quick reference for IBM Informix Version 12.10.XC4:
http://www-01.ibm.com/support/docview.wss?uid=swg27041825

Enjoy!
FFO

Read More

Novo Technote de ER finalmente publicado!!!!

Pessoal,
levou um tempinho pra conseguir concluir, mas com a ajuda de outros colegas da IBM US
finalmente saiu: http://www-01.ibm.com/support/docview.wss?uid=swg21572991

How to identify a user flooding Enterprise Replication (ER) send/receive queues with transactions

Technote (troubleshooting)

This document applies only to the following language version(s):

English

Problem(Abstract)

This document can be used to identify a user flooding Enterprise Replication (ER) send/receive queues with transactions

Symptom

Several occasions when ER/CDR queues become 'flooded' with transactions, it is critical to identify the user(s) triggering Data Manipulation Language (DML) SQL statements which consume a lot of logical log area that can cause the DDR Block situation and hang the Informix instance.

Cause

A user triggered a huge transaction causing several logical logs to be filled and ER sync to hang.

Diagnosing the problem

1. Look at 'onstat -g rqm sendq'

2. Check the progress table and look for the 'group id' with the largest bytes queued;

3. The 'group id' is really the 'replicate id';

4. Look for the replicate id from 'onstat -g cat' to find the table used in that replicate;

5. With the table partnum information, now you can use one of the following options to find the session id or userthread:
- onlog
- onstat -g opn
- sqltrace history


Looking 'onstat -g rcv full" from one of the target servers also lists replicated id's and bytes received.

Resolving the problem

After finding the user/session id, cancell the userthread/session causing the flood.

Read More

*** NOVO Exame de Certificação da versão 12.10 do Informix

http://www-03.ibm.com/certify/tests/obj619.shtml

Read More

INFORMIX 12.1 - SIMPLY POWERFUL

PESSOAL,
Um pouco atrasado mas ae vai:

Lançada a nova versão do IBM Informix V12.1, e com ela vieram diversas inovações e pequenas mudanças no que diz respeito a licenciamento. Segue:


IBM® Informix® V12.10:

• Solves the Big Data challenge of sensor data, such as RFIDs, smart meters, and builting sensors
• Enhances performance for both online transaction processing (OLTP) and analytic workloads
• Provides easy-to-use interface to smart devices when on the go
• Makes it much easier to move applications from other database systems
• Reduces cost and risk for private cloud and distributed enterprise deployments via enhancements to Flexible Grid technology
• Provides new SQL compatibility with other leading database systems making it much easier to port applications to Informix and take advantage of the power and cost savings of Informix
• Is easier to embed in applications and devices
• Makes deployment simpler
• Delivers enhanced warehouse management infrastructure for increased manageability and performance
• Contains integration and simplification of management and administration

Para alinhamento com outros produtos de IM, foram renomeadas algumas versões: Informix V11.70               Informix V12.10

Informix Developer            Informix Developer
Informix Innovator-C          Informix Innovator-C
Informix Express®             Informix Express

Informix Growth               Informix Workgroup
Informix Growth Warehouse     Informix Advanced Workgroup
Informix Ultimate             Informix Enterprise
Informix Ultimate Hypervisor  Informix Enterprise Hypervisor
Informix Ultimate Warehouse   Informix Advanced Enterprise

Página do Produto
http://www-01.ibm.com/software/data/informix/index.html

Carta de Anúncio 26/03/2013
http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?infotype=an&subtype=ca&appname=gpateam&supplier=897&letternum=ENUS213-156#h2-ordinfx


FFO

Read More

Chegou a hora ! Vamos VOTAR !

Pessoal.
O Board do IIUG está sendo composto novamente para 2013.

'don't forget to vote!'

IIUG - Election time IIUG Board of Directors 2013

The 2011 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 February 18, 2013 through March 4, 2013 and the election will take place shortly thereafter.
For additional info, visit: http://www.iiug.org/about/election.php.
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
board-election@iiug.org

Boa sorte e abraços.
FFO

Read More

### NEW Informix v12 IBM WEBCAST ###

Pessoal.
A versão 12.10 do Informix (code name Centaurus) será oficialmente lançada no dia 5 de Março de 2013.

Teremos um Webcast com Jerry Keesee, Diretor do Time de Desenvolvimento do produto e John Milller III, Arquiteto Lider do Projeto Centaurus, falando do futuro do Informix,
e principalmente sobre esta nova versão.


Para registrar-se no evento acesse o link abaixo:

The New IBM Informix: It's Simply Powerful
http://event.on24.com/r.htm?e=571631&s=1&k=6740A7076E0FE9C59EBFDC80C8487D34&partnerref=IBM02


Até!
Fernando

Read More

Fix list for Informix 11.70.xC6 *** LIBERADO!

Neste mês de Outubro, foi liberada a versão 11.70.xC6 do Informix. Eis o fix list:

- TITLE: Fix list for Informix 11.70.xC6
- URL: http://www.ibm.com/support/docview.wss?uid=swg27036092&myns=swgimgmt&mynp=OCSSGU8G&mync=E

- ABSTRACT: Informix provides periodic fixes for release 11.70.  The following list is the most recent report of fixes for customer-reported defects in Version 11.70.xC6.  This report combines both Windows- and UNIX-specific defect fixes.

Dando uma olhada no Release Notes, percebi na sessão de New Features, que mesmo a IBM
afirmando que só lançaria novas funcionalidades na 12.x, temos algumas poucas novidades:
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_535

• Administration
  • Enhancements to the OpenAdmin Tool (OAT) for Informix
  • Support for the same XID for transactions on different databases
  • Coordinating transactions within a high-availability cluster
  • Easier failover configuration for Connection Managers in a high-availability cluster
• Application development
  • Enhanced support for OUT and INOUT parameters in SPL routines
  • Additional functions for spatial data
  • Return the default values of columns
  • SPL routines for application compatibility
• Time Series data
  • Load time series data faster through a virtual table

[ ]'s
@FFO

Read More