IZ37723: SQLCODE +464 SHOWS AS ERROR IN DB2DIAG.LOG INSTEAD OF WARNING

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

• SQL0464W Procedure "<procedure-name>" returned
  "<generated-nbr-results>" query result sets, which
            exceeds the defined limit "<max-nbr-results>".
  
  
  In some cirscumstances warning +464 can show as Level Error in
  the db2diag.log:
  
  2008-09-09-22.37.35.291923+120 I438980A866 LEVEL: Error
  PID : 21155 TID : 1 PROC : db2agent (DER)
  0
  INSTANCE: db2der NODE : 000 DB : DER
  APPHDL : 0-2070 APPID: *LOCAL.db2der.080909120644
  AUTHID : SAPDER
  FUNCTION: DB2 UDB, runtime interpreter, sqlriInvokeInvoker,
  probe:145
  DATA #1 : String, 64 bytes
  sqlriInvokeInvoker ignored because of prior condition, probe 145
  DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA sqlcabc: 136 sqlcode: 464 sqlerrml: 5
  sqlerrmc: 1 0
  sqlerrp : SQLCSMCB
  sqlerrd : (1) 0x893E0019 (2) 0x00000019 (3) 0x00000000
  (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
  sqlwarn : (1) (2) (3) (4) (5) (6)
  (7) (8) (9) (10) (11)
  sqlstate:
  

Local fix

Problem summary

• USERS AFFECTED: ALL
  PROBLEM DESCRIPTION:SQLCODE +464 SHOWS AS ERROR IN DB2DIAG.LOG
  INSTEAD OF WARNING
  PROBLEM SUMMARY:
  ERROR DESCRIPTION:
  SQL0464W Procedure "<procedure-name>" returned
            "<generated-nbr-results>" query result sets, which
            exceeds the defined limit "<max-nbr-results>".
  
  
  In some cirscumstances warning +464 can show as Level Error in
  the db2diag.log:
  
  2008-09-09-22.37.35.291923+120 I438980A866 LEVEL: Error
  PID : 21155 TID : 1 PROC : db2agent (DER)
  0
  INSTANCE: db2der NODE : 000 DB : DER
  APPHDL : 0-2070 APPID: *LOCAL.db2der.080909120644
  AUTHID : SAPDER
  FUNCTION: DB2 UDB, runtime interpreter, sqlriInvokeInvoker,
  probe:145
  DATA #1 : String, 64 bytes
  sqlriInvokeInvoker ignored because of prior condition, probe 145
  DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA sqlcabc: 136 sqlcode: 464 sqlerrml: 5
  sqlerrmc: 1 0
  sqlerrp : SQLCSMCB
  sqlerrd : (1) 0x893E0019 (2) 0x00000019 (3) 0x00000000
  (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
  sqlwarn : (1) (2) (3) (4) (5) (6)
  (7) (8) (9) (10) (11)
  sqlstate:
  
  LOCAL FIX:
  NONE
  

Problem conclusion

• Problem was first fixed in Version 9.1 Fix Pack 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:

  IZ37724

Fix information

• Fixed component name

  DB2 UDB ESE HP-

• Fixed component ID

  5765F4103

Applicable component levels

• R910 PSY

     UP