Archive - Jan 2011

Date

January 14th

OpenAdmin Tool on YouTube

I thought it was fun to see OAT out on YouTube.  The following link will show you several video’s on how to use OAT and some of the Informix Server new features.

www.youtube.com/OpenAdminToolChannel

 

January 13th

The work compress, repack does is not lost when interrupted

The work compress, repack does is not lost when interrupted.  Let’s take the following
example, compressing a 1 million row table and compress 800,000 rows and then
interrupt the operation.  You will NOT have to redo the 800,000 rows when
you restart the compression operation, but rather only compress the remaining
200,000 rows.  Any new rows added to table before you restart will already be
compressed when the are inserted.

 

January 9th

fnunes's picture

Stored procedure PDQ / PDQ dos procedimentos

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English version:

A few years ago I needed to check if I had some stored procedures created with PDQ. Maybe some readers don't know, but if you have SET PDQPRIORITY n in your session before creating a procedure it will run with that PDQ. And that can cause abnormal resource consumption. In most cases you'll want your procedures created without PDQ.

 

January 4th

jroy's picture

Happy new year!

2010 has been a great year with the release of Informix 11.70 and 2011 is lining up to be a busy year with plenty of activities and execution on the plans of v.next.
I also hope that in 2011 we'll see even more participation from the Informix community to continue to make Informix and the solutions around it better and more exciting.

 

jroy's picture

Happy new year!

2010 has been a great year with the release of Informix 11.70 and 2011 is lining up to be a busy year with plenty of activities and execution on the plans of v.next.
I also hope that in 2011 we'll see even more participation from the Informix community to continue to make Informix and the solutions around it better and more exciting.