Discover Informix - The data server with the most flexible cluster and replication technology on the market and the lowest TCO

mjamison's picture

Always close your cursors.

Submitted by mjamison on February 11, 2013 - 19:18
So I ran into an interesting issue last week. A customer couldn't alter a table. Non-Exclusive access. Sounds pretty normal right? I mean after all it's not like a DBA doesn't see this fairly often. 
The Normal routine is for a DBA to run the following:
  • Figure out the partnum for the table being altered, best way is to run the following SQL from the DB the table is in:
     select hex(partnum) from systables where tabname="" 
 
mjamison's picture

Always close your cursors.

Submitted by mjamison on February 11, 2013 - 19:18
So I ran into an interesting issue last week. A customer couldn't alter a table. Non-Exclusive access. Sounds pretty normal right? I mean after all it's not like a DBA doesn't see this fairly often. 
The Normal routine is for a DBA to run the following:
  • Figure out the partnum for the table being altered, best way is to run the following SQL from the DB the table is in:
     select hex(partnum) from systables where tabname="" 
 
mjamison's picture

Application Development and Chat with the Lab

Submitted by mjamison on February 11, 2013 - 17:31
Hi all, another PSA today. 
 
Still this one is pretty cool, because the lab will be talking about application development with Data Studio and Informix. Even if you don't use Data Studio, and even if you don't plan to, I highly recommend attending. The more interest a call like this generates, the more calls like this (i.e. Application Development) will occur.  
 
-Mark 
 
 

 
mjamison's picture

Application Development and Chat with the Lab

Submitted by mjamison on February 11, 2013 - 17:31
Hi all, another PSA today. 
 
Still this one is pretty cool, because the lab will be talking about application development with Data Studio and Informix. Even if you don't use Data Studio, and even if you don't plan to, I highly recommend attending. The more interest a call like this generates, the more calls like this (i.e. Application Development) will occur.  
 
-Mark 
 
 

 
mjamison's picture

Webcast of New Informix Version

Submitted by mjamison on February 11, 2013 - 16:31

 Hi All,

So the new version of Informix is fast approaching, and IBM has a webcast on that very topic. Below you will find a summary, and the link to sign up.
 

 
mjamison's picture

Webcast of New Informix Version

Submitted by mjamison on February 11, 2013 - 16:31

 Hi All,

So the new version of Informix is fast approaching, and IBM has a webcast on that very topic. Below you will find a summary, and the link to sign up.
 

 
fnunes's picture

Gartner MQ Data Warehouse DBSMs

Submitted by fnunes on February 7, 2013 - 23:59

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

English version:

 

CREATE SCHEMA statement

Submitted by bthompson on February 6, 2013 - 18:47

Recently at work we had an Informix consultant work with us for three months. Other than a small newspaper cutting entitled Disasters blamed on over-confidence, his other advice to me was be anal!

So it was with this simple dictum in mind that I approached the rebuild of some databases using dbschema.

 
aford's picture

Have You Heard? It's Simply Powerful.

Submitted by aford on February 5, 2013 - 22:52

Of course I'm talking about the March 5th, 2013 IBM Informix Webcast that will talk about the latest release, but if you're reading this on Planet IDS you've already heard about it from Fernando, Eric and Gary and you can stop reading right now.

If this is the first you've heard of this event, then read on...

 
fho's picture

Moving the Dot

Submitted by fho on February 4, 2013 - 22:45

What is the significance of a moving a dot on a graph? If it is Gartner’s Magic Quadrant for Data Warehouse Database Management Systems which it published on Jan 31, 2013, then it is rather significant.

 
Syndicate content