IC82288: RUNNING SELECT FROM SYSDRI MULITPLE TIMES WITH PDQPRIORITY SET L EADS TO NO ROWS FOUND SQL ERROR 100 HPL FAILPOINT 11431 AND 1100

APAR status

• Closed as program error.

Error description

• You have PDQPRIORITY set to 1 or higher. You have STMT_CACHE
  enabled. You run this select
  statement multiple times:
  
  select * from sysdri ( in sysmaster )
  
  Data is returned for the first several runs depending on the
  STMT_CACHE_HITS setting but subsequent runs
  return no rows. If you restart the database server then the
  behavior is reset.
  
  You run one or both of these multiple times:
  
  onpload job
  onpladm job
  
  The jobs run successfully for the first several runs but
  subsequent runs return errors like these:
  
  Error accessing table 'sysdri', SQL error 100, ISAM error 0
  
  Error occured at HPL failpoint: 11431
  
  Error occured at HPL failpoint: 11008
  

Local fix

• Restart the database server.
  Do not run any of these with PDQPRIORITY enabled:
  onpload
  onpladm
  select * from sysdri
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * PDQPRIORITY set to 1 or higher,  STMT_CACHE enabled or SPL   *
  * and  query uses bit vector it can give incorrect results     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PDQPRIORITY set to 1 or higher,  STMT_CACHE enabled or SPL   *
  * and  query uses bit vector it can give incorrect results due *
  * to that wrong filter processing.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC5                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC5
  

Temporary fix

Comments

• For download information, go to:
  http://www.ibm.com/support/fixcentral
  

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

• RB70 PSY

     UP