tag:blogger.com,1999:blog-58312654645750775022024-02-07T21:16:48.847-08:00Information XBlog destinado a promover a cultura de bancos de dados, com foco em IBM Informix, e a brand de Information Management e seus produtos.Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.comBlogger30125tag:blogger.com,1999:blog-5831265464575077502.post-55910768833496710682015-03-01T08:45:00.003-08:002015-03-01T08:49:28.060-08:00Informix Quick Reference CardsPessoal.<br />
Seguem os links para os Informix Quick Reference Cards, como são conhecidos:<br />
<br />
Configuration Parameters in the onconfig.std File<br />
IBM®Informix®Version 12.10.xC4:<br />
<a href="http://publibfp.dhe.ibm.com/epubs/pdf/i1320991.pdf">http://publibfp.dhe.ibm.com/epubs/pdf/i1320991.pdf</a><br />
<br />
onstat Utility Commands Sorted by<br />
Functional Category<br />
IBM®Informix®Version 12.10.xC4:<br />
<a href="http://publibfp.dhe.ibm.com/epubs/pdf/i1321001.pdf">http://publibfp.dhe.ibm.com/epubs/pdf/i1321001.pdf</a><br />
<br />
SQL Administration API<br />IBM®Informix®Version 12.10.xC4:<br />
<a href="http://publibfp.dhe.ibm.com/epubs/pdf/i1335011.pdf">http://publibfp.dhe.ibm.com/epubs/pdf/i1335011.pdf</a><br />
<br />
Enterprise Replication<br />
IBM®Informix®Version 12.10:<br />
<a href="http://publibfp.dhe.ibm.com/epubs/pdf/i1335020.pdf">http://publibfp.dhe.ibm.com/epubs/pdf/i1335020.pdf</a><br />
<br />
Informix JSON quick reference for IBM Informix Version 12.10.XC4:<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg27041825">http://www-01.ibm.com/support/docview.wss?uid=swg27041825</a><br />
<br />
Enjoy!<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-79268706734760625062013-12-27T04:14:00.001-08:002013-12-27T04:14:12.499-08:00Novo Technote de ER finalmente publicado!!!!Pessoal,<br />
levou um tempinho pra conseguir concluir, mas com a ajuda de outros colegas da IBM US<br />
finalmente saiu: <a href="http://www-01.ibm.com/support/docview.wss?uid=swg21572991">http://www-01.ibm.com/support/docview.wss?uid=swg21572991</a><br />
<br />
<h1 class="ibm-small">
How to identify a user flooding Enterprise Replication (ER) send/receive queues with transactions</h1>
<h2>
Technote (troubleshooting)</h2>
<br />
<h2>
This document applies only to the following language version(s):</h2>
<div class="wordwrap">
English </div>
<h2>
Problem(Abstract)</h2>
<div class="wordwrap">
This document can be used to identify a user flooding Enterprise Replication (ER) send/receive queues with transactions </div>
<h2>
Symptom</h2>
<div class="ibm-domino-rtf">
<div class="wordwrap">
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. </div>
</div>
<br class="ibm-dblue-delete" />
<h2>
Cause</h2>
<div class="ibm-domino-rtf">
<div class="wordwrap">
A user triggered a huge transaction causing several logical logs to be filled and ER sync to hang.</div>
</div>
<h2>
Diagnosing the problem</h2>
<div class="ibm-domino-rtf">
<div class="wordwrap">
1. Look at 'onstat -g rqm sendq' </div>
<div class="wordwrap">
<br /> 2. Check the progress table and look for the 'group id' with the largest bytes queued;<br /> <br /> 3. The 'group id' is really the 'replicate id'; <br /> <br /> 4. Look for the replicate id from 'onstat -g cat' to find the table used in that replicate;<br /> <br /> 5. With the table partnum information, now you can use one of the following options to find the session id or userthread: <br /> - onlog <br /> - onstat -g opn <br /> - sqltrace history<br /> <br /> <br /> Looking 'onstat -g rcv full" from one of the target servers also lists replicated id's and bytes received.</div>
</div>
<br />
<h2>
Resolving the problem</h2>
<div class="ibm-domino-rtf">
<div class="wordwrap">
After finding the user/session id, cancell the userthread/session causing the flood.</div>
</div>
Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-66326793134363357592013-12-27T04:11:00.002-08:002013-12-27T04:11:23.036-08:00*** NOVO Exame de Certificação da versão 12.10 do Informixhttp://www-03.ibm.com/certify/tests/obj619.shtmlFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-27818143614072364532013-12-27T03:56:00.004-08:002013-12-27T03:56:59.740-08:00INFORMIX 12.1 - SIMPLY POWERFULPESSOAL,<br />
Um pouco atrasado mas ae vai:<br />
<br />
<span style="font-size: small;"><span style="font-family: sans-serif;">L</span></span><span style="font-family: sans-serif; font-size: small;">ançada a <b>nova versão do
IBM Informix V12.1</b>, e com ela vieram diversas inovações e pequenas
mudanças no que diz respeito a licenciamento. Segue:</span>
<br />
<br /><img height="95" src="https://mail.google.com/mail/ca/u/0/?ui=2&ik=7e0f59a34c&view=att&th=14333e8d6e8283c8&attid=0.2&disp=emb&zw&atsh=1" width="400" />
<br /><span style="font-family: sans-serif; font-size: small;">IBM® Informix® V12.10:</span>
<br />
<br />
<ul>
<li><span style="font-family: sans-serif; font-size: small;">Solves the Big Data challenge of sensor
data, such as RFIDs, smart meters, and builting sensors</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">Enhances performance for both online
transaction processing (OLTP) and analytic workloads</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">Provides easy-to-use interface to smart
devices when on the go</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">Makes it much easier to move applications
from other database systems</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">Reduces cost and risk for private cloud
and distributed enterprise deployments via enhancements to Flexible Grid
technology</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">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
</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">Is easier to embed in applications and
devices</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">Makes deployment simpler</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">Delivers enhanced warehouse management
infrastructure for increased manageability and performance</span>
</li>
<li><span style="font-family: sans-serif; font-size: small;">Contains integration and simplification
of management and administration</span></li>
</ul>
<br /><span style="font-family: sans-serif; font-size: small;">Para alinhamento com outros produtos
de IM, foram renomeadas algumas versões:</span>
<span style="font-family: Courier New; font-size: small;"><b>Informix V11.70
Informix V12.10</b><br />
<br />
Informix Developer Informix Developer<br />
Informix Innovator-C Informix Innovator-C<br />
Informix Express® Informix Express<br />
<br />
Informix Growth Informix
Workgroup<br />
Informix Growth Warehouse Informix Advanced Workgroup<br />
Informix Ultimate Informix Enterprise<br />
Informix Ultimate Hypervisor Informix Enterprise Hypervisor<br />
Informix Ultimate Warehouse Informix Advanced Enterprise</span><span style="font-family: sans-serif; font-size: small;"><br />
</span>
<br /><span style="font-family: sans-serif; font-size: small;"><b>Página do Produto</b></span>
<br /><a href="http://www-01.ibm.com/software/data/informix/index.html" target="_blank"><span style="font-family: sans-serif; font-size: x-small;">http://www-01.ibm.com/<wbr></wbr>software/data/informix/index.<wbr></wbr>html</span></a>
<br />
<br /><span style="font-family: sans-serif; font-size: small;"><b>Carta de Anúncio 26/03/2013</b></span>
<br /><a href="http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?infotype=an&subtype=ca&appname=gpateam&supplier=897&letternum=ENUS213-156#h2-ordinfx" target="_blank"><span style="font-family: sans-serif; font-size: x-small;">http://www-01.ibm.com/common/<wbr></wbr>ssi/cgi-bin/ssialias?infotype=<wbr></wbr>an&subtype=ca&appname=gpateam&<wbr></wbr>supplier=897&letternum=<wbr></wbr>ENUS213-156#h2-ordinfx</span></a>
<br />
<br />
<br />
FFO<br />
Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-74986512525079328822013-02-09T03:22:00.004-08:002015-03-01T16:11:49.128-08:00Chegou a hora ! Vamos VOTAR !Pessoal.<br />
O Board do IIUG está sendo composto novamente para 2013.<br />
<br />
'don't forget to vote!'<br />
<br />
<h3>
IIUG - Election time IIUG Board of Directors 2013</h3>
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.<br />
For additional info, visit: <a href="http://www.iiug.org/about/election.php" target="_blank">http://www.iiug.org/about/election.php</a>.<br />
If you would like to nominate yourself or a colleague, please contact the IIUG Nominating Committee by writing to <a href="mailto:board-election@iiug.org">board-election@iiug.org</a>.<br />
James Edmiston<br />
Former IIUG Board Member<br />
IIUG Elections Commissioner 2013<br />
<a href="mailto:board-election@iiug.org">board-election@iiug.org</a><br />
<br />
<div style="border-top: #000 1px solid;">
<br /><div style="font-size: 10px;">
<br /></div>
<div style="font-size: 10px;">
<br /></div>
<div style="font-size: 10px;">
<br /></div>
<div style="font-size: 10px;">
<br /></div>
Boa sorte e abraços.<br />
FFO</div>
Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-6177879480065965182013-01-29T11:23:00.000-08:002013-01-29T11:25:44.634-08:00### NEW Informix v12 IBM WEBCAST ###Pessoal.<br />
A versão 12.10 do Informix (code name Centaurus) será oficialmente lançada no dia 5 de Março de 2013.<br />
<br />
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,<br />
e principalmente sobre esta nova versão.<br />
<br />
<br />
Para registrar-se no evento acesse o link abaixo:<br />
<br />
The New IBM Informix: It's Simply Powerful <br />
<a href="http://event.on24.com/r.htm?e=571631&s=1&k=6740A7076E0FE9C59EBFDC80C8487D34&partnerref=IBM02">http://event.on24.com/r.htm?e=571631&s=1&k=6740A7076E0FE9C59EBFDC80C8487D34&partnerref=IBM02</a><br />
<br />
<br />
Até!<br />
Fernando Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-75275008109235543842012-10-25T03:50:00.001-07:002012-10-25T04:01:10.491-07:00Fix 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:<br />
<br />
- TITLE: <b>Fix list for Informix 11.70.xC6</b><br />
- URL: <a href="http://www.ibm.com/support/docview.wss?uid=swg27036092&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/docview.wss?uid=swg27036092&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
<br />
- 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.<br />
<br />
Dando uma olhada no Release Notes, percebi na sessão de New Features, que mesmo a IBM<br />
afirmando que só lançaria novas funcionalidades na 12.x, temos algumas poucas novidades:<br />
<a href="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">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</a><br />
<br />
<ul id="vcc_sp_ul_317" tabindex="531">
<li id="vcc_sp_li_318" tabindex="532">Administration
<ul id="vcc_sp_ul_319" tabindex="533">
<li id="vcc_sp_li_320" tabindex="534"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_536" id="vcc_sp_a_321" tabindex="535">Enhancements to the OpenAdmin Tool (OAT) for Informix</a></li>
<li id="vcc_sp_li_322" tabindex="536"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_537" id="vcc_sp_a_323" tabindex="537">Support for the same XID for transactions
on different databases</a></li>
<li id="vcc_sp_li_324" tabindex="538"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_542" id="vcc_sp_a_325" tabindex="539">Coordinating transactions within a high-availability
cluster</a></li>
<li id="vcc_sp_li_326" tabindex="540"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_543" id="vcc_sp_a_327" tabindex="541">Easier failover configuration for Connection
Managers in a high-availability cluster</a></li>
</ul>
</li>
<li id="vcc_sp_li_328" tabindex="542">Application development
<ul id="vcc_sp_ul_329" tabindex="543">
<li id="vcc_sp_li_330" tabindex="544"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_540" id="vcc_sp_a_331" tabindex="545">Enhanced support for OUT and INOUT parameters
in SPL routines </a></li>
<li id="vcc_sp_li_332" tabindex="546"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_538" id="vcc_sp_a_333" tabindex="547">Additional functions for spatial data </a></li>
<li id="vcc_sp_li_334" tabindex="548"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_539" id="vcc_sp_a_335" tabindex="549">Return the default values of columns </a></li>
<li id="vcc_sp_li_336" tabindex="550"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1ids_rel_552" id="vcc_sp_a_337" tabindex="551">SPL routines for application compatibility</a></li>
</ul>
</li>
<li id="vcc_sp_li_338" tabindex="552">Time Series data
<ul id="vcc_sp_ul_339" tabindex="553">
<li id="vcc_sp_li_340" tabindex="554"><a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.relnotes.doc/notes/ifx_1170xc6/ids_unix_relnotes_11.70.html#dqx1dt2mg60" id="vcc_sp_a_341" tabindex="555">Load time series data faster through a
virtual table</a></li>
</ul>
</li>
</ul>
<br />
[ ]'s<br />
@FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-26572654454073293142012-10-17T07:06:00.000-07:002012-10-17T07:06:57.203-07:00*** Artigo sobre o IWA na Datamag ***Foi publicado na IBM Data Management deste mês um artigo sobre o IWA (Informix Warehouse Accelerator).<br />
<br />
IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing: <br />
<br />
<a href="http://ibmdatamag.com/2012/08/supercharging-the-data-warehouse-while-keeping-costs-down/">http://ibmdatamag.com/2012/08/supercharging-the-data-warehouse-while-keeping-costs-down/</a><br />
<br />
Tem também um artigo sobre os testes de performance do IWA:<br />
<a href="http://public.dhe.ibm.com/software/data/sw-library/informix/whitepapers/Intel-IWA-performance.pdf" target="_blank">http://public.dhe.ibm.com/software/data/sw-library/informix/whitepapers/Intel-IWA-performance.pdf</a><br />
<br />
Boa leitura!<br />
Fernando Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-13113308281568618192012-10-17T05:51:00.002-07:002012-10-17T05:51:46.816-07:00*** NOVO - System Administration Certification (exam 919) for Informix 11.70 preparation seriesPessoal,<br />depois das partes 3, 4 e 5, mais dois artigos preparatórios para o exame 919 da certificação de System
Administrator para Informix 11.70 foram publicados:<br />
<br />
System Administration Certification exam 919 for Informix 11.70 prep, Part 2: Informix space management<br /><a href="http://www.ibm.com/developerworks/data/tutorials/db2-cert9192/index.html">http://www.ibm.com/developerworks/data/tutorials/db2-cert9192/index.html</a><br /><br />System Administration Certification exam 919 for Informix 11.70 prep, Part 8: Security<br /><a href="http://www.ibm.com/developerworks/data/tutorials/db2-cert9198/index.html">http://www.ibm.com/developerworks/data/tutorials/db2-cert9198/index.html</a><br />
<br />
Abraços e boa sorte!<br />
FFO
Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-56326463072423368842012-10-16T12:50:00.002-07:002012-10-16T12:53:16.932-07:00@@@ Informix Chat with the LabsRecebi o convite para participar do Chat with the Labs agora neste mês de Outubro:<br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">-----------------------------------------------------------<br />- TITLE: Helping Us Help You: Informix Chat with the Labs, October 2012<br />- URL: <a href="http://www.ibm.com/support/docview.wss?uid=swg21614254&myns=swgimgmt&mynp=OCSSHPYE&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/docview.wss?uid=swg21614254&myns=swgimgmt&mynp=OCSSHPYE&mynp=OCSSGU8G&mync=E</a><br />- ABSTRACT: Come join Informix Support professionals discussing and demostrating ways you can help technical support diagnose and debug problems using 'Must Gather' or "Collecting data' documents, or product features.<br />-----------------------------------------------------------</span><br />
<br />
<br />
O evento é dia 30/10 e a participação livre, basta cadastrar-se.<br />
<br />
Apresentado por:<br />
<b>Jerry Keesee - Director, IBM Informix Database Development (IBM)</b><br />
<b>Sanjit Chakraborty -Support Engineer (IBM)</b><br />
<b>Ronald Privett - Support Engineer (IBM) </b><br />
<br />
[ ]'s<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-37456435256266196872012-10-08T12:52:00.002-07:002012-10-08T12:53:40.780-07:00*** NOVO Redbook de DB2 HADR ***A IBM acaba de publicar (em draft ainda) um novo Redbook de DB2 para o sistema de cluster e contingencia, baseado originalmente no código do HDR do Informix.<br />
<br />
Segue:<br />
<br />
<span style="font-family: "Courier New",Courier,monospace;">High Availability and Disaster Recovery Options </span><br />
<span style="font-family: "Courier New",Courier,monospace;">for DB2 Linux, UNIX, and Windows<br /> </span><br />
<span style="font-family: "Courier New",Courier,monospace;">Revised: October 1, 2012<br />More details are available at </span><br />
<a href="http://www.redbooks.ibm.com/redpieces/abstracts/sg247363.html?Open">http://www.redbooks.ibm.com/redpieces/abstracts/sg247363.html?Open</a><br />
<br />
Divirtam-se!<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-38946343853500995772012-10-04T06:24:00.002-07:002012-10-04T06:24:34.341-07:00Technote de Archecker ::: CRITICAL ERROR: Unable to initialize resourcesDepois de algum tempo alocado no cliente, finalmente consegui terminar e pedir aprovação e publicação deste Technote. Ainda faltam 8...rs!<br />
<br />
Escrevi o artigo baseado no atendimento a um cliente, em Agosto passado (2012).<br />
Depois de muito pesquisar nas bases de conhecimento IBM, cheguei à conclusão de que ainda estamos bem carentes de material do Archecker. Neste caso o cliente não conseguia restaurar e então validar uma imagem de backup.<br />
<br />
Não sei se o link já está disponivel na internet, então ae vai o conteúdo:<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg21609172">http://www-01.ibm.com/support/docview.wss?uid=swg21609172</a><br />
<h2>
Technote (troubleshooting)</h2>
<br /> <h2>
Problem(Abstract)</h2>
When using Archecker to validate an IBM® Informix® archive backup
image, the following error message: "Unable to initialize resources" is
raised. This article describes the common causes and solutions for this
error. <br />
<h2>
Symptom</h2>
<div class="ibm-domino-rtf">
Starting the archive backup validation process leads to the following output:
<br />
<tt>$ archecker -tvs</tt><br /> <tt>IBM Informix Dynamic Server Version 11.50.FC9</tt><br /> <tt>Program Name: archecker</tt><br /> <tt>Version: 8.0</tt><br /> <tt>Released: 2011-07-25 22:02:01</tt><br /> <tt>CSDK: IBM Informix CSDK Version 3.50</tt><br /> <tt>ESQL: IBM Informix-ESQL Version 3.50.FC4</tt><br /> <tt>Compiled: 07/25/11 22:02 on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006</tt><br /> <br /> <tt>AC_STORAGE /arc_ifmx</tt><br /> <tt>AC_MSGPATH /tmp/ac_msg.log</tt><br /> <tt>AC_VERBOSE on</tt><br /> <tt>AC_TAPEDEV /informix/bkpdata/</tt><br /> <tt>AC_TAPEBLOCK 32 KB</tt><br /> <tt>AC_LTAPEDEV /informix/bkplogs/</tt><br /> <tt>AC_LTAPEBLOCK 32 KB</tt><br /> <tt>AC_TIMEOUT 300</tt><br /> <tt>AC_SESSION</tt><br /> <tt>CRITICAL ERROR: Unable to initialize resources.</tt></div>
<h2>
Cause</h2>
<div class="ibm-domino-rtf">
The path <tt>/arc_ifmx</tt> set in the <tt>AC_STORAGE</tt> <b>ac_config </b>file has no proper permissions set so user Informix can read/write Archecker temporary files.</div>
<h2>
Diagnosing the problem</h2>
<div class="ibm-domino-rtf">
The <tt>ac_msg.log</tt> file provides more details about the cause of the problem. Most of the times the following error can be found:
<br />
<br /> <tt>ERROR: Error(2) Unable to create directory /arc_ifmx/SAVE</tt><br /> <br /> <tt>ERROR: Unable to initialize the save page section.</tt><br /> <tt>CRITICAL ERROR: Unable to initialize resources.</tt><br /> <br /> <br /> <tt>STATUS: archecker completed Setup pid = 17911 exit code: 3</tt><br /> <br /> Depending on the kind of syntax error, the following message may also be found in the ac_msg.log:<br /> <br /> <tt>ERROR: Error(13) Invalid filename /tmp/SAVE/TP.0_1</tt><br /> <br /> <tt>ERROR: Failed to save page(0_1) in /tmp/SAVE/TP.0_1</tt><br /> <tt>ERROR: Unable to init for restart feature.</tt><br /> <tt>ERROR: Unable to initialize the restartable restore</tt><br /> <tt>ERROR: Device type not set properly</tt><br /> <tt>ERROR: No device driver selected.</tt><br /> <tt>STATUS: Scan FAILED</tt><br /> <tt>ERROR: Archive Physical Validation Failed.</tt><br /> <br /> The <tt>AC_STORAGE</tt> ac_config variable path do not have proper permissions:<br /> <br /> <tt>drwxr-xr-x 2 root root 4096 Aug 24 08:18 arc_ifmx</tt><br /> <br />
Or even, when trying to use archecker '-d' flag to clean old temporary
directories CHUNK_BM, INFO and SAVE with wrong permissions:<br /> <br /> <tt>dr--r----- 2 root informix 4096 Aug 17 14:44 CHUNK_BM</tt><br /> <tt>dr--r----- 2 root informix 4096 Aug 24 08:11 INFO</tt><br /> <tt>dr--r----- 2 root informix 20480 Aug 24 08:11 SAVE</tt></div>
<br /> <h2>
Resolving the problem</h2>
<div class="ibm-domino-rtf">
Fix the AC_STORAGE path permissions properly.
<br />
<br />
STEPS
<br />
<br />
1. Add Read/Write/Execution permissions to others in the AC_STORAGE destination path directory:<br /> <br /> <tt>$ chmod o+rwx arc_ifmx</tt><br /> <br />
or<br /> <br /> <tt>$ chmod 777 arc_ifmx</tt><br /> <br />
2. Permissions should look like this:<br /> <br /> <tt>$ ls -ltr</tt><br /> <tt>drw-rw-rwx 5 root root 4096 Sep 26 08:03 arc_ifmx</tt></div>
<br />
Críticas são bem-vindas.<br />
Abraços pessoal.<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com3tag:blogger.com,1999:blog-5831265464575077502.post-19097056334216443422012-07-05T09:24:00.000-07:002012-07-05T09:24:05.491-07:00Novo Technote de HPL finalmente publicado!!!!Pessoal,<br />
a versao final do technote que estava escrevendo sobre processos de migracao utilizando o HPL como ferramenta de carga e descarga (http://the-information-x.blogspot.com.br/2012/04/novo-artigo-technotedevworks-sobre.html), ficou pronta, foi aprovada e publicada, veja no link abaixo:<br />
<a href="http://www.ibm.com/support/docview.wss?uid=swg21587169">http://www.ibm.com/support/docview.wss?uid=swg21587169</a><br />
<br />
<h1 class="smalltitle" style="padding-bottom: 0pt;">
Setting up High-Performance Loader (HPL) in the Informix command line.</h1>
<h2>
Technote (FAQ)</h2>
<br /> <h2>
Question</h2>
How do I set up the High-Performance Loader (HPL) Informix utility? <br />
<h2>
Cause</h2>
<div class="ibm-domino-rtf">
Informix
DBAs and System Administrators usually find HPL a little bit tricky,
due to its own shared memory management engine and specific command line
instructions to handle the load and unload jobs control.
<br />
This document gathers a compilation of useful links and ease-of-use instructions to quickly set HPL ready to run.</div>
<br /> <h2>
Answer</h2>
Eventually,
some may find the GUI option the best path, but this document intends
to prepare the reader to set HPL in just a few steps, thru the command
line interface.
<br />
<br />
1. First of all, you should choose a table to create the HPL job (and the onpload database):<br /> <br />
$ onpladm create job j_items -d "items.unl" -D stores -t items <br /> <br />
Successfully created Job j_items<br /> <br />
<ul>where:
<ul class="ibm-bullet-list ibm-no-links">
<li>j_items -> job name for the table
</li>
<li>items.unl -> flat file to receive the unloaded table rows
</li>
<li>stores -> database name
</li>
<li>items -> table name</li>
</ul>
<br />
As soon as the first job is created, the onpload database is created too, if is doens't exist already.<br />
If it does exist, you should rename it so it won't cause any trouble.</ul>
<br />
2. To execute the j_items job as an unload job, just issue the command below, using the -fu flag:<br /> <br /> $ onpload -j j_items -fu -l items.log -i 100000 -R $PWD/a <ul><br /> where:
<ul class="ibm-bullet-list ibm-no-links">
<li>$PWD -> environment variable created to store the current directory value
</li>
<li>j_items -> job name for the table
</li>
<li>items.log -> error log file name</li>
</ul>
</ul>
<br /> 3. To use the same job as a load job, just issue the command below, changing the -fu flag by the -fl flag:<br /> <br /> $ onpload -j j_items -fl -l items.log -i 100000 -R $PWD/a <br />
<br /> 4. Obviously, no one would use HPL facility to unload/load a
single table. The sections bellow show some SQL queries to generate the
onpload commands for each table. You can use the DBAccess utility to
execute these commands.<br /> <br />
Don't forget to change the <dbname> variable for your database name, i.e.: stores_demo.<br /> <ul class="ibm-bullet-list ibm-no-links">
<li>This query, generates the CREATE JOB command thru the onpladm facility for all tables in the database, in Express Mode:</li>
</ul>
<ul>select tabname from systables where tabid > 99 and tabtype = "T" into temp a;<br />
output to hpl_create_job.sh without headings<br />
select "onpladm create job job_"||trim(tabname)||" -d
'/tmp/"||trim(tabname)||".unl' -D <dbname> -t "||trim(tabname)
from a </ul>
<ul class="ibm-bullet-list ibm-no-links">
<li>This query, generates the CREATE JOB command thru the onpladm facility for all tables in the database, in Deluxe Mode:</li>
</ul>
<ul>select tabname from systables where tabid > 99 and tabtype = "T" into temp a;<br />
output to hpl_create_job_delux.sh without headings<br />
select "onpladm create job job_"||trim(tabname)||" -d
'/tmp/"||trim(tabname)||".unl' -D <dbname> -t "||trim(tabname)||"
-fc" from a </ul>
<ul class="ibm-bullet-list ibm-no-links">
<li>This query, generates the job load command thru the onpload facility for all tables in the database:</li>
</ul>
<ul class="ibm-bullet-list ibm-no-links">select tabname from systables where tabid > 99 and tabtype = "T" into temp a;<br />
output to hpl_load_job.sh without headings<br />
select "onpload -j job_"||trim(tabname)||" -fl ","-l /tmp/"||trim(tabname)||".log -i 100000 -R /tmp/"||trim(tabname) from a<br />
<li>This query, generates the job unload command thru the onpload facility for all tables in the database:<br /> <br />
select tabname from systables where tabid > 99 and tabtype = "T" into temp a;<br />
output to hpl_unload_job.sh without headings<br />
select "onpload -j job_"||trim(tabname)||" -fu ","-l
/tmp/"||trim(tabname)||".log -i 100000 -R /tmp/"||trim(tabname) from
a <br /> </li>
</ul>
<br />
For all the tables that has BLOB columns only Deluxe Mode can be used.<br /> <br />
5. When all the shell scripts are done, you can clean them up,
avoiding line feeds and weird characters which may cause a failure at
execution time.<br /> <br />
Follows attached, two scripts that might be used as cleaning tools:<br /> <ul>a. Use this tool to remove line feeds, name it <b>join.sh</b>:</ul>
<ul><ul>:join <br /> /\\$/{N <br /> s/\\\n/ / <br /> b join <br /> } </ul>
<br />
b. Use this tool to remove blank lines, name it <b>del_blank.sh</b>:<br /><ul>sed '/^$/d' $1 </ul>
<ul>Here's an example on its use:<br /><br /> cat hpl_load_job.sh | sed -f join.sh > zz <br /> sh del_blank.sh zz > zzz <br /> mv zzz hpl_create_job.sh </ul>
</ul>
<br />
And the final hpl_create_job.sh script is clean.<br /> <br />
4. One important notice that should be taken care of is the following HPL environment variables:<br /> <ul class="ibm-bullet-list ibm-no-links">
<li>PLOAD_SHMAT:<br /> <a href="http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.hpl.doc/hpl011066502.htm">http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.hpl.doc/hpl011066502.htm</a><br />
When you set the PLOAD_SHMAT environment variable, the pload converter <br />
calculates the address using a global attached segment list that is <br />
maintained across pload virtual processors. The pload converter attaches<br />
at the next available address after the highest address on the list, <br />
ensuring that the converter always attaches to an unused shared memory <br />
segment.<br /> <br />
Error messages like this can be seen in the online.log file when PLOAD_SHMAT is not set:<br />
15:29:46 PLOAD aborting: cpu VP 15 could not attach shared memory at
the required address. Set the environment variable PLOAD_SHMAT to 1 and
try again. <br /> </li>
<li>IFX_XFER_SHMBASE<br /> <a href="http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_255.htm">http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_255.htm</a><br />
After the database server allocates shared memory, the database server <br />
might allocate multiple contiguous OS shared memory segments. The client<br />
utility that connects to shared memory must attach all those OS segments<br />
contiguously also. The utility might have some other shared objects (for<br />
example, the xbsa library in onbar) loaded at the address where the <br />
server has shared memory segment attached. To workaround this situation,<br />
you can specify a different base address in the environment variable <br />
IFX_XFER_SHMBASE for the utility to attach the shared memory segments.<br /> <br />
The following error message can be seen in the online.log file:<br /> 15:29:46 shmat: [22]: operating system error <br /> 15:29:46 Client could not attach server shared memory segment, use IFX_XFER_SHMBASE. </li>
</ul>
<ul class="ibm-bullet-list ibm-no-links">
<li>PLOAD_SHMBASE<br /> <a href="http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_297.htm">http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_297.htm</a> <br />
Lets you specify the shared-memory address at which the High-Performance Loader (HPL) onpload processes will attach.</li>
</ul>
<ul class="ibm-bullet-list ibm-no-links">
<li>DBONPLOAD<br /> <a href="http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_220.htm">http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_220.htm</a><br />
Lets you specify the name of the database that the onpload utility of
the High-Performance Loader (HPL) will use. If DBONPLOAD is set, onpload
uses the specified name as the name of the database; otherwise, the
default name of the database is onpload.</li>
</ul>
<ul class="ibm-bullet-list ibm-no-links">
<li>PLCONFIG<br /> <a href="http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_295.htm">http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_295.htm</a><br />
Lets you specify the name of the configuration file that the
High-Performance Loader (HPL) should use. This file must be located in
the $INFORMIXDIR/etc directory. If the PLCONFIG environment variable is
not set, then $INFORMIXDIR/etc/plconfig.std is the default configuration
file.<br /> </li>
<li>PLOAD_LO_PATH<br /> <a href="http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_296.htm">http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqlr.doc/ids_sqr_296.htm</a><br />
Lets you specify the pathname for smart-large-object handles (which
identify the location of smart large objects such as BLOB and CLOB data
types). If not set, the /tmp pathname will be used.</li>
</ul>
Criticas e sugestoes sao aceitas (e rating positivo tambem...rs!!)<br />
Espero que gostem.<br />
<br />
Abracos,<br />
Fernando [FFO]Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-16378100972950423912012-05-18T09:45:00.003-07:002012-05-18T09:45:57.611-07:00ATENÇÃO!!! Informix 11.10 End-Of-Suport on September 30,2012 !!!Pessoal,<br />
atenção para a data de encerramento do suporte IBM para a versão 11.10 do Informix:<br />
<a href="http://www-01.ibm.com/support/docview.wss?uid=swg21593581&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www-01.ibm.com/support/docview.wss?uid=swg21593581&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
<h2>
Abstract</h2>
Informix 11.10 enters End of Support status starting September 30, 2012 <br />
<h2>
Content</h2>
<br />
<a href="http://www.blogger.com/blogger.g?blogID=5831265464575077502" name="TOP">
The end of support date for Informix 11.10 products is rapidly approaching. Effective <b>September 30, 2012</b>, IBM will withdraw support from the Informix 11.10 product releases. </a><br />
<br />
<br />
E o link para o upgrade para a última versão disponível: 11.70<br />
<br />
<a href="http://www-01.ibm.com/software/data/informix/upgrade/">http://www-01.ibm.com/software/data/informix/upgrade/</a><br />
<br />
<br />
Abraços,<br />
FernandoFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-15170858622520429702012-05-02T06:47:00.001-07:002012-05-02T06:48:18.067-07:00NEW! Best practices and technical papers to help customers learn about and use DB2 V10 featuresPessoal,<br />
a equipe da IBM do Canadá nos enviou uma série de novos documentos para compartilhar com os clientes sobre as features do DB2 10:<br />
<br />
Best practices: Storage optimization with deep compression (Authors: Thomas Fanghaenel and Bill Minor)<br />
<a href="http://www.ibm.com/developerworks/data/bestpractices/deepcompression/index.html">http://www.ibm.com/developerworks/data/bestpractices/deepcompression/index.html</a><br />
<br />
Best practices: A practical guide to implementing row and column access control (Author: Walid Rjaibi)<br />
<a href="http://www.ibm.com/developerworks/data/bestpractices/rcac/index.html">http://www.ibm.com/developerworks/data/bestpractices/rcac/index.html</a><br />
<br />
Best Practices: Temporal data management with DB2 (Author: Matthias Nicola)<br />
<a href="http://www.ibm.com/developerworks/data/bestpractices/temporal/index.html">http://www.ibm.com/developerworks/data/bestpractices/temporal/index.html</a><br />
<br />
DB2 V10.1 Multi-temperature data management recommendations (Authors: Jim Seeger, Karen McCulloch, Naresh Chainani, Kiran Chinta, Aruna De Silva, Vincent Kulandai Samy, and Tom Hart)<br />
<a href="http://www.ibm.com/developerworks/data/library/long/dm-1205multitemp/index.html">http://www.ibm.com/developerworks/data/library/long/dm-1205multitemp/index.html</a><br />
<br />
DB2 V10.1 Query performance enhancements (Author: David Sky)<br />
<a href="http://www.ibm.com/developerworks/data/library/long/dm-1205db210performance/index.html">http://www.ibm.com/developerworks/data/library/long/dm-1205db210performance/index.html</a><br />
<br />
Boa leitura!<br />
FFO<br />
<br />Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-56358651619900849932012-04-09T10:13:00.001-07:002012-04-09T10:16:05.221-07:00IBM vende familia U2 (UniVerse & UniData) para a Rocket Software Inc.Pessoal,<br />
a noticia parece desatualizada, mas acreditem: muitos clientes ainda me perguntam sobre a familia U2.<br />
Sendo assim, estou postando apenas para constar: <i>U2 foi vendido para a Rocket em 1 de Outubro de 2009.</i><br />
<br />
Ao tentar suporte pelo Support Central Site ou acessar a homepage do U2 na www-01, você já é direcionado para o site da Rocket e uma mensagem alerta:<br />
<br />
Notice: <b>You are now leaving the IBM Web site, and connecting to the Rocket Software, Inc. site. Rocket acquired the IBM UniVerse and UniData (U2) product line on October 1, 2009. All future information regarding the U2 products will be available from Rocket. Please refer to the Rocket website <a href="http://www.rocketsoftware.com/u2/">www.rocketsoftware.com/u2/</a>.</b><br />
<br />
Para quem não sabe o U2 (uma alusão aos nomes dos dois produtos: <b>U</b>niVerse e <b>U</b>niData) foi o resultado da fusão em 1997 entre a VMark (dona do UniVerse) e a UniData que resultou na então Ardent Software, uma compania com tecnologia focada no emergente mercado de ferramentas ETL. Em 2000, a Ardent foi adquirida pela Informix, e o U2 passou a fazer parte da divisão de banco de dados da empresa. Mais tarde, em Abril de 2001, com a compra da divisão de banco de dados da Informix pela IBM, uma nova empresa surgia com os produtos restantes da fusão de 1997: a Ascential Software, que em Abril de 2005 finalmente seria comprada pela IBM para incorporar a familia InfoSphere.<br />
<br />
Noticias na mídia:<br />
IBM to Sell U2 Database Business to Rocket Software<br />
<a href="http://www.itjungle.com/tfh/tfh092109-story03.html">http://www.itjungle.com/tfh/tfh092109-story03.html</a><br />
<br />
IBM Sells U2 to Rocket Software<br />
<a href="http://www.dbta.com/Articles/Editorial/News-Flashes/IBM-Sells-U2-to-Rocket-Software-56290.aspx">http://www.dbta.com/Articles/Editorial/News-Flashes/IBM-Sells-U2-to-Rocket-Software-56290.aspx</a><br />
<br />
Rocket Software acquires U2<br />
<a href="http://www.u2uk.com/41.html">http://www.u2uk.com/41.html</a><br />
<br />
IBM Sells U2 Product to Rocket Software<br />
<a href="http://www.superinfoinc.com/rocket-buys-u2-productline">http://www.superinfoinc.com/rocket-buys-u2-productline</a><br />
<br />
Oracle Taps HyperRoll, IBM Sells U2 Databases<br />
<a href="http://www.informationweek.com/news/software/info_management/228901203">http://www.informationweek.com/news/software/info_management/228901203</a><br />
<br />
Rocket U2<br />
<a href="http://en.wikipedia.org/wiki/Rocket_U2">http://en.wikipedia.org/wiki/Rocket_U2</a><br />
<br />
Fernando.Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com2tag:blogger.com,1999:blog-5831265464575077502.post-61065516961082302302012-04-09T05:51:00.001-07:002012-04-09T06:11:15.314-07:00Novas features do DB2 10Pessoal, <br />
eis algumas das principais características do novo DB2 10, possívelmente sobre as quais falaremos nos futuros posts do blog:<br />
<br />
* Adaptive Compression - os recursos e algoritmos de compactação já entregues nas versões 9.1, 9.5 e 9.7 foram aprimorados e onde antes tinhamos compressão de tabelas em torno de 7x agora a versão 10 promete a compressão na casa de 10x para suas maiores tabelas;<br />
* Time Travel Query - recurso que mantêm versões históricas das linhas da tabela para que você possa consultar de qualquer tempo no passado. Com as chamadas "tabelas temporais" você pode até consultar dados que só serão válidos no futuro. Um grande aumento na produtividade para clientes que necessitam de versões de dados sem ter que construir toda uma lógica através de scripts em suas próprias aplicações e batch jobs;<br />
* Recursos de segurança - controle de acesso e suporte multiusuário a nível de linha e coluna, simplifica o acesso aos dados e mascara dados reais de produção de usuários que não devem acessar valores das colunas;<br />
* Novas features focadas em performance de bases warehouse - novos tipos de join, novos tipos de acessos a índices, paralelismo melhorado, e muito mais. Melhor desempenho em jobs de carga em bases warehouse;<br />
* Multi Temperature data management - criação de storage groups e migração de dados com base em políticas de negócios para gerenciar de forma mais eficaz os custos de armazenamento e expectativas de desempenho de seus usuários finais;<br />
* Gerenciamento de carga aprimorada, não só para gerenciar as cargas de trabalho com base em quem está acessando os dados, mas também que tipo de dados estão sendo acessados. Dados mais acessados podem ter maior prioridade e uma fatia maior de recursos de sistema, se necessário;<br />
* Alta velocidade de carga contínua de dados é um fator crítico de sucesso para bases warehouse e o DB2 10 oferece mais recursos nesta área;<br />
<br />
Video que mostra o depoimento de um dos maiores clientes da IBM: ouça o que a Coca-Cola Bottling tem a dizer sobre o dinheiro que já economizou e os ganhos de desempenho que eles tiveram mudando para o DB2.<br />
<br />
<a href="http://www.youtube.com/watch?feature=player_embedded&v=qma5TMpxtCY">http://www.youtube.com/watch?feature=player_embedded&v=qma5TMpxtCY</a><br />
<br />
Fonte: <a href="http://www.ibm.com/developerworks/data/library/techarticle/dm-1204whatsnewdb210/index.html?ca=drs-">http://www.ibm.com/developerworks/data/library/techarticle/dm-1204whatsnewdb210/index.html?ca=drs-</a><br />
<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-70964803499776157932012-04-04T09:16:00.003-07:002012-04-04T09:24:19.312-07:00*** LANÇAMENTO MUNDIAL DB2 10Pessoal,<br />
a IBM lançou finalmente a versão oficial do DB2 10. Veja a cobertura (em inglês) na IBM Data Management Magazine:<br />
<br />
<div style="color: #505050; font-family: Arial; font-size: 12px; line-height: 150%;"><img alt="" border="0" height="99" src="http://gallery.mailchimp.com/1aae6e1fed3bcadba6aa8297b/images/DB210badge.jpg" style="border-width: 0px; display: inline; height: 99px; line-height: 100%; margin: 0px; max-width: 160px; outline-style: none; padding: 0px; text-decoration: none; width: 160px;" width="160" /></div><br />
<a href="http://ibmdatamag.com/2012/04/hyper-speed-and-time-travel-are-db2-realities/">http://ibmdatamag.com/2012/04/hyper-speed-and-time-travel-are-db2-realities/</a><br />
<br />
Vou postar (assim que tiver tempo) novidades sobre a versão nova.<br />
[ ]'s<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-77857525260151697072012-04-02T09:45:00.003-07:002012-04-04T09:28:42.904-07:00Novo artigo (Technote/DevWorks) sobre migrações usando HPL.Pessoal,<br />
conforme havia prometido, material técnico sobre HPL, e que esta em revisão para virar um Technote, ou<br />
se tudo der certo um artigo na DeveloperWorks Area. Esse material é um apanhado de experiências pessoais minhas em migrações de clientes. Agradeço o apoio nas informações enviadas pelo Carlos Eduardo Boccio e Dirceu Tirado, ambos especialistas Informix da Porto Seguro.<br />
<br />
O material é rico em detalhes, e focado em ambientes grandes, que se beneficiam do poder de processamento do HPL.<br />
<br />
<h1 class="smalltitle" style="padding-bottom: 0pt;">Easely setting up High-Performance Loader (aka HPL) in the command line.</h1><br />
<h2>Technote (FAQ)</h2><br />
<h2>Question</h2>How to set the High-Performance Loader utility. <br />
<h2>Cause</h2><div class="ibm-domino-rtf">Users (Informix DBAs and System Administrators) usually intend to find HPL a little bit tricky, due to its own shared memory management engine and specific command line instructions to handle the load and unload jobs control. <br />
This document gathers a compilation of useful links and ease-of-use instructions to quickly set HPL ready to run.</div><br />
<h2>Answer</h2>Eventually, some may find the GUI option the best path, but this document intends to prepare the reader to set HPL in just a few steps, thru the command line interface. <br />
<br />
1. First of all, you should choose a table to create the HPL job (and the onpload database):<br />
<br />
$ onpladm create job j_items -d "items.unl" -D stores -t items <br />
<br />
Successfully created Job j_items<br />
<br />
<ul>where: <ul class="ibm-bullet-list ibm-no-links"><li>j_items -> job name for the table </li>
<li>items.unl -> flat file to receive the unloaded table rows </li>
<li>stores -> database name </li>
<li>items -> table name</li>
</ul>As soon as the first job is created, the onpload database is created too, if it doesn't exist already. If it does exist, you should rename it so it won't cause any trouble.</ul><br />
2. To execute the j_items job as an unload job, just issue the command below, using the -fu flag:<br />
<br />
$ onpload -j j_items -fu -l items.log -i 100000 -R $PWD/a <br />
<ul>where: <ul class="ibm-bullet-list ibm-no-links"><li>$PWD -> environment variable created to store the current directory value </li>
<li>j_items -> job name for the table </li>
<li>items.log -> error log file name</li>
</ul></ul><br />
3. To use the same job as a load job, just issue the command below, changing the -fu flag by the -fl flag:<br />
<br />
$ onpload -j j_items -fl -l items.log -i 100000 -R $PWD/a <br />
<br />
Obviously, no one would use HPL facility to unload/load a single table. The sections bellow show some SQL queries to generate the onpload commands for each table. You can use the DBAccess utility to execute these commands.<br />
<br />
Don't forget to change the <dbname> variable for your database name, i.e.: stores_demo.<br />
<ul class="ibm-bullet-list ibm-no-links"><li>This query, generates the CREATE JOB command thru the onpladm facility for all tables in the database, in Express Mode:</li>
</ul><ul>select tabname from systables where tabid > 99 and tabtype = "T" into temp a; output to hpl_create_job.sh without headings select "onpladm create job job_"||trim(tabname)||" -d '/tmp/"||trim(tabname)||".unl' -D <dbname> -t "||trim(tabname) from a </ul><ul class="ibm-bullet-list ibm-no-links"><li>This query, generates the CREATE JOB command thru the onpladm facility for all tables in the database, in Deluxe Mode:</li>
</ul><ul>select tabname from systables where tabid > 99 and tabtype = "T" into temp a; output to hpl_create_job_delux.sh without headings select "onpladm create job job_"||trim(tabname)||" -d '/tmp/"||trim(tabname)||".unl' -D <dbname> -t "||trim(tabname)||" -fc" from a </ul><ul class="ibm-bullet-list ibm-no-links"><li>This query, generates the job load command thru the onpload facility for all tables in the database:</li>
</ul><ul class="ibm-bullet-list ibm-no-links">select tabname from systables where tabid > 99 and tabtype = "T" into temp a; output to hpl_load_job.sh without headings select "onpload -j job_"||trim(tabname)||" -fl ","-l /tmp/"||trim(tabname)||".log -i 100000 -R /tmp/"||trim(tabname) from a
<li>This query, generates the job unload command thru the onpload facility for all tables in the database:<br />
<br />
select tabname from systables where tabid > 99 and tabtype = "T" into temp a;<br />
output to hpl_unload_job.sh without headings<br />
select "onpload -j job_"||trim(tabname)||" -fu ","-l /tmp/"||trim(tabname)||".log -i 100000 -R /tmp/"||trim(tabname) from a <br />
</li>
</ul><br />
For all the tables that has BLOB columns only Deluxe Mode can be used.<br />
<br />
When all the shell scripts are done, you can clean them up, avoiding line feeds and weird characters which may cause a failure at execution time.<br />
<br />
Follows attached, two scripts that might be used as cleaning tools:<br />
<br />
a. Use this tool to remove line feeds, name it <b>join.sh</b>:<br />
<br />
:join <br />
/\\$/{N <br />
s/\\\n/ / <br />
b join <br />
} <br />
<br />
b. Use this tool to remove blank lines, name it <b>del_blank.sh</b>:<br />
<br />
sed '/^$/d' $1 <br />
<br />
Here's an example on its use:<br />
<br />
cat hpl_load_job.sh | sed -f join.sh > zz <br />
sh del_blank.sh zz > zzz <br />
mv zzz hpl_create_job.sh <br />
<br />
And the final hpl_create_job.sh script is clean.<br />
<br />
<h2>Related information</h2><a href="http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/0307carlson/0307carlson.html">John Carlson's document on HPL usage</a><br />
<a href="http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.hpl.doc/hpl04.htm?resultof=%22%48%50%4c%22%20%22%68%70%6c%22%20">Environment variables needed for HPL proper execution</a><br />
<a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.hpl.doc/sii-15manage-29036.htm">HPL tuning tips</a><br />
<a href="http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.hpl.doc/sii-xbcfgf-16844.htm#sii-xbcfgf-16844">Appendix B link. High-Performance Loader configuration </a><br />
<br />
<br />
Vou corrigindo o conteúdo antes da publicação oficial.<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com2tag:blogger.com,1999:blog-5831265464575077502.post-21345781477148496862012-04-02T09:38:00.000-07:002012-04-02T09:38:46.116-07:00IBM Cloud Computing Social Media Residency, TI-2003-R01Pessoal,<br />
nova residencia em Raleigh/Carolina do Norte, para Smart Cloud Computing:<br />
<a href="http://publib-b.boulder.ibm.com/residents.nsf/IntNumber/TI-2003-R01?OpenDocument">http://publib-b.boulder.ibm.com/residents.nsf/IntNumber/TI-2003-R01?OpenDocument</a><br />
<br />
[ ]'s<br />
FernandoFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-26700275410554589282012-04-01T20:09:00.003-07:002012-04-02T09:14:05.028-07:00História e Curiosidades - Informix no Computer History Museum ***NOVOEsta postagem contêm uma coletânea de documentos e reportagens sobre a antiga Informix, registradas pelo Computer History Museum. O material foi preparado por Luanne Johnson.<br />
<br />
<a href="http://corphist.computerhistory.org/corphist/view.php?s=select&cid=27">http://corphist.computerhistory.org/corphist/view.php?s=select&cid=27</a><br />
<br />
Alguns documentos são históricos como a carta de Roger Sippl solicitando à equipe de documentação para corrigir o Informix Handbook, doada por ele mesmo ao museu e datada dos primordios do ano 2000.<br />
<br />
Para quem interessar ainda, segue a entrevista de Roger dada à própria Luanne Johnson entre 13 de Dezembro de 2005 e 12 de Janeiro de 2006 em Mountain View, California. Na entrevista Roger responde perguntas sobre sua saida da Cromenco onde liderou o projeto do CRIS (Cromemco Relational Information System) posteriormente evoluindo para o Marathon (genesis do Informix) e o licenciamento do produto já em sua nova e pequena empresa, a Relational Database Systems ou simplesmente RDS Inc.<br />
<br />
<a href="https://docs.google.com/open?id=0B_96a59kSxy9MG1jamp1eEZTNGFjUlYxUnFMZnVydw">https://docs.google.com/open?id=0B_96a59kSxy9MG1jamp1eEZTNGFjUlYxUnFMZnVydw</a><br />
<br />
Vou adicionar depois este post ao link de <i>História e Curiosidades</i>.<br />
Bom divertimento!<br />
<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-55745831506235482122012-03-29T14:52:00.001-07:002012-03-29T14:53:29.266-07:00Vaga *** Software Support Engineer ***Pessoal,<br />
para quem tiver interesse há uma vaga aberta no GOM (Global Opportunity Marketplace) para Engenheiro de Suporte a Software na IBM.<br />
<br />
<a href="https://jobs3.netmedia1.com/cp/job_summary.jsp?job_id=SWG-0458614">https://jobs3.netmedia1.com/cp/job_summary.jsp?job_id=SWG-0458614</a><br />
<br />
Abraços e boa sorte!<br />
FernandoFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-38555295475403589072012-03-29T10:23:00.002-07:002012-03-29T10:28:24.872-07:00Information On Demand @ CALL FOR SPEAKERS !!!Opa, agora sim!<br />
<br />
Estão abertas as inscrições para quem deseja apresentar uma sessão técnica no IOD 2012.<br />
<br />
As inscrições vão até 13 de Abril, por isso quem tiver interesse tem apenas 2 semanas para enviar a proposta. Basta clicar no convite abaixo, em <b style="color: #6aa84f;"><i>submit proposals</i></b><span style="color: black;">.</span><br />
<br />
Os tópicos em aberto sao:<br />
* Information Management<br />
* Business Analytics<br />
* Enterprise Content Management<br />
* Business Leadership<br />
<br />
<br />
<div align="center"><span style="color: teal; font-family: Verdana; font-size: medium;"><b>Call for Speakers is now Open!</b></span> <br />
<span style="color: teal; font-family: Verdana; font-size: x-small;"><b><i>(**for four weeks only - ends April 13**)</i></b></span> <br />
<br />
<table><tbody>
<tr valign="top"> <td><a href="https://mail.google.com/mail/?ui=2&ik=7e0f59a34c&view=att&th=1365eb72fb95eed8&attid=0.2&disp=emb&zw&atsh=1" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://mail.google.com/mail/?ui=2&ik=7e0f59a34c&view=att&th=1365eb72fb95eed8&attid=0.2&disp=emb&zw&atsh=1" style="cursor: move;" /></a><img src="https://mail.google.com/mail/?ui=2&ik=7e0f59a34c&view=att&th=1365eb72fb95eed8&attid=0.1&disp=emb&zw&atsh=1" /> </td><td><br />
<br />
<br />
<br />
<span style="font-family: Verdana; font-size: x-small;"><br />
</span> </td><td><div align="right"></div></td></tr>
</tbody></table></div><table><tbody>
<tr valign="top"> <td colspan="2"><span style="font-family: Verdana; font-size: x-small;">Don't miss this opportunity to submit your team's proposal and your clients' to speak on our most exciting agenda yet.</span> <br />
<br />
<span style="color: teal; font-family: Verdana; font-size: x-small;"><b>Help your Customers and Business Partners take Center Stage</b></span> <br />
<span style="font-family: Verdana; font-size: x-small;">Encourage your clients to share their knowledge and real-world experience with their peers in a compelling and insightful agenda that addresses both technical and industry-related topics. Share the details on the website, talk to them about speaking and work with them to submit their proposals by the deadline. All proposals are due Friday, April 13 at 5:59 P.M. Eastern time. </span> <br />
<br />
<span style="color: teal; font-family: Verdana; font-size: x-small;"><b>Prepare your team, your customers and your Business Partners to</b></span><span style="color: navy; font-family: Verdana; font-size: x-small;"><b> </b></span><a href="http://www.ibm.com/software/data/2012-conference/call-for-speakers.html" target="_blank"><span style="color: #00a000; font-family: Verdana; font-size: x-small;"><b><u>submit proposals</u></b></span></a><span style="color: #00a000; font-family: Verdana; font-size: x-small;"><b><u> </u></b></span><span style="color: teal; font-family: Verdana; font-size: x-small;"><b>today!</b></span> <br />
<div align="right"><br />
<span style="font-family: Verdana; font-size: x-small;"><b><i>Conference Registration opens May 1.</i></b></span> </div></td></tr>
<tr valign="top"> <td colspan="2"><br />
</td></tr>
</tbody></table><br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-16601472253983616622012-03-28T11:45:00.000-07:002012-03-28T11:45:25.423-07:00Informix Servers: Downloads and driversPessoal, novas atualizações de PID's Informix no Fixcentral:<br />
<br />
- TITLE: Informix_Ultimate_11.50.FC9W2_HPUX_Itanium_64_iFix<br />
- URL: <a href="http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_HPUX_Itanium_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_HPUX_Itanium_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
- ABSTRACT: PID 2 of Fix pack 9 for Informix Ultimate Edition v11.50 for HPUX running on Itanium-based 64-bit hardware. See machine and release notes for hardware and software requirements.<br />
<br />
- TITLE: Informix_Ultimate_11.50.FC9W2_AIX_pSeries_64_iFix<br />
- URL: <a href="http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_AIX_pSeries_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_AIX_pSeries_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
- ABSTRACT: PID 2 of Fixpack 9 for Informix Ultimate Edition v11.50 for AIX running on Power-based 64-bit hardware. See machine and release notes for hardware and software requirements.<br />
<br />
- TITLE: Informix_Ultimate_11.50.FC9W2_LIN_pSeries_64_iFix<br />
- URL: <a href="http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_LIN_pSeries_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_LIN_pSeries_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
- ABSTRACT: PID 2 of Fix pack 9 for Informix Ultimate Edition v11.50 for Linux running on Power-based 64-bit hardware. See machine and release notes for hardware and software requirements.<br />
<br />
- TITLE: Informix_Ultimate_11.50.FC9W2_SOL_x64_iFix<br />
- URL: <a href="http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_SOL_x64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_SOL_x64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
- ABSTRACT: PID 2 of Informix Ultimate Edition v11.50 for Solaris running on x86_64-based 64-bit hardware. See machine and release notes for hardware and software requirements.<br />
<br />
- TITLE: Informix_Ultimate_11.50.FC9W2_HPUX_PA-RISC_64_iFix<br />
- URL: <a href="http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_HPUX_PA-RISC_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_HPUX_PA-RISC_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
- ABSTRACT: PID 2 of Fix pack 9 for Informix Ultimate Edition v11.50 for HPUX running on PA-RISC-based 64-bit hardware. See machine and release notes for hardware and software requirements.<br />
<br />
- TITLE: Informix_Ultimate_11.50.FC9W2_SOL_SPARC_64_iFix<br />
- URL: <a href="http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_SOL_SPARC_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_SOL_SPARC_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
- ABSTRACT: PID 2 of Fix pack 9 for Informix Ultimate Edition v11.50 for Solaris running on SPARC-based 64-bit hardware. See machine and release notes for hardware and software requirements.<br />
<br />
- TITLE: Informix_Ultimate_11.50.FC9W2_LIN_zSeries_64_iFix<br />
- URL: <a href="http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_LIN_zSeries_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_LIN_zSeries_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
- ABSTRACT: PID 2 of Fix pack 9 for Informix Ultimate Edition v11.50 for Linux running on zSeries-based 64-bit hardware. See machine and release notes for hardware and software requirements.<br />
<br />
- TITLE: Informix_Ultimate_11.50.FC9W2_LIN-x86_64_iFix<br />
- URL: <a href="http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_LIN-x86_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E">http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FInformix&fixids=Informix_Ultimate_11.50.FC9W2_LIN-x86_64_iFix&source=myna&myns=swgimgmt&mynp=OCSSGU8G&mync=E</a><br />
- ABSTRACT: PID 2 of Fix pack 9 for Informix Ultimate Edition v11.50 for Linux running on x86_64-based 64-bit hardware. See machine and release notes for hardware and software requirements.<br />
<br />
Basta ter o '<i>entitlement</i>' para poder baixar as atualizações.<br />
Abraços,<br />
FFOFernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0tag:blogger.com,1999:blog-5831265464575077502.post-34058796680889698552012-03-28T06:40:00.002-07:002012-10-16T12:31:08.194-07:00*** NOVO *** System Administration for Informix version 11.70 (Exam 919) Preparation SeriesMais um tópico sobre a série de tutoriais preparatórios para a prova 919:<br />
<br />
<div class="dw-content-head">
<h1>
<span style="font-size: large;">System Administration Certification exam 919 for Informix 11.70 prep, Part 5: Informix backup and restore</span></h1>
<i>Archiving Informix databases</i><br />
<br />
<i><a href="http://www.ibm.com/developerworks/data/tutorials/db2-cert9195/index.html">http://www.ibm.com/developerworks/data/tutorials/db2-cert9195/index.html</a> </i><br />
<i><br />
</i><br />
Para quem ainda não possui a certificação da versão 11.70, recomendo a leitura.<br />
Abraços,<br />
FFO</div>
Fernando F Oliveira [FFO]http://www.blogger.com/profile/16550171059135037940noreply@blogger.com0