LI73820: ERROR -901 REPORTED BY SQLRI_HSJNLOADTUPCOLREVER RUNNING COMPLEX QUERY

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• Error -901 is reported while running a complex query.
  
  
  The following message is reported in the db2diag.log:
  
  FUNCTION: DB2 UDB, runtime interpreter,
  sqlri_hsjnLoadTupColREVER, probe:30
  MESSAGE : SQL0901N The SQL statement failed because of a
  non-severe system error. Subsequent SQL statements can be
  processed. (Reason "".)
  DATA #1 : String, 17 bytes
  loadREVERSED:Full
  

Local fix

• none
  defect wsdbu00366354, module=engn_sqri
  fixed in Fixpak 7 for db2 v9.1
  

Problem summary

• Users Affected: ALL
  Problem Description:
  ERROR -901 REPORTED BY SQLRI_HSJNLOADTUPCOLREVER RUNNING COMPLEX
  QUERY
  Problem summary:
  Error -901 is reported while running a complex query.
  
  
  The following message is reported in the db2diag.log:
  
  FUNCTION: DB2 UDB, runtime interpreter,
  sqlri_hsjnLoadTupColREVER, probe:30
  MESSAGE : SQL0901N The SQL statement failed because of a
  non-severe system error. Subsequent SQL statements can be
  processed. (Reason "".)
  DATA #1 : String, 17 bytes
  loadREVERSED:Full
  

Problem conclusion

• Problem was first fixed in Version 9, Fixpak 7
  

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:

  LI74139

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSY

     UP

• R950 PSY

     UP