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

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
  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:
  

Problem conclusion

• Problem was first fixed on version 9.5 Fix Pack 4
  

Temporary fix

Comments

APAR Information

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

  IZ37723

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

Fix information

• Fixed component name

  DB2 UDB ESE HP-

• Fixed component ID

  5765F4103

Applicable component levels

• R950 PSY

     UP