IT37805: SELECT FOR TABLE CONTAINING BLOBS FAILS AFTER COMPRESSED

APAR status

• Closed as program error.

Error description

• In version 14.10.FC5 over a linux box creating a table like
  this:
  
  create table "informix".tablexml
    (
      tcoda smallint not null ,
      tcodb smallint not null ,
      tcodc char(1) not null ,
      tcodd integer not null ,
      tcode char(1) not null ,
      xml_codef text in blobdbs not null
    );
  
  create unique index "informix".ix_tablexml_01 on
  "informix".tablexml
      (tcodd,tcoda,tcodb,tcodc,tcode) using btree ;
  create index "informix".ix_tablexml_02 on "informix".tablexml
  (tcoda)
      using btree ;
  
  (blobdbs blobspace needs to be created in the instance)
  
  After loading the rows table needs to be compressed:
  execute function sysadmin:task('table
  compress','tablexml','stores_demo','informix')
  execute function sysadmin:task('table
  repack','tablexml','stores_demo','informix')
  execute function sysadmin:task('table
  shrink','tablexml','stores_demo','informix')
  
  Using a client aplication like CSDK ConnectTestDemo issue the
  following statement:
  
  select * from tablexml
  where tcodd = xxxxxx <- any value loaded
  and tcoda = x <- any value loaded
  
  The following error is raised (-604):
  ERROR [HY000][Informix][Informix ODBC Driver][Informix]Cannot
  read blob.
  
  An assertion failure shows both the SQL and ISAM error numbersÇ
  SQL  ISAM
  ERR  ERR
  -604 -172
  
  After uncompressing the table the select works just fine.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC16 and 14.10.xC7.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC16 or 14.10.xC7.          *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC16 and 14.10.xC7.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels