IZ21592: THE APPLICATION TERMINATES WITH SQL30020N. DB2DIAG.LOG ON SERVER REPORTS "INVALID REQUEST FOR TRANSACTION STATE"

APAR status

• Closed as program error.

Error description

• The application terminates with the error, SQL30020N.  This APAR
  addresses a server side problem.  There may be applicable client
  side fix from APAR IZ02325.
  
  The server side db2diag.log reports the following:
  ====
  2007-04-09-11.13.26.385140-240 I19393C476         LEVEL: Error
  PID     : 101340               TID  : 1           PROC :
  db2agent (DKNA) 0
  INSTANCE: pajfraud             NODE : 000         DB   : DKNA
  APPHDL  : 0-851                APPID: GA656F4A.O7F0.051049181555
  FUNCTION: DB2 UDB, DRDA Application Server, sqljs_ddm_rdbrllbck,
  probe:100
  MESSAGE : Invalid Request for Transaction State
  DATA #1 : Hexdump, 4 bytes
  0x20023910 : 0000 0003                                  ....
  ====
  
  The client side db2diag.log reports the HDDA PROTOCOL ERRROR as
  following:
  ====
  2007-04-09-11.13.26.381000-240 I1434298H374       LEVEL: Error
  PID     : 11944                TID  : 10560       PROC :
  dllhost.exe
  INSTANCE: DB2                  NODE : 000
  APPID   : G0112233.1234.051049181555
  FUNCTION: DB2 UDB, DRDA Application Requester,
  sqljrReportServerErrReply, probe:20
  RETCODE : ZRC=0x80370086=-2143879034=SQLJR_PRTCLERR "HDDA
  PROTOCOL ERROR"
  
  2007-04-09-11.13.26.381000-240 I1434674H662       LEVEL: Error
  PID     : 11944                TID  : 10560       PROC :
  dllhost.exe
  INSTANCE: DB2                  NODE : 000
  APPID   : G0112233.1234.051049181555
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
   sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -30020   sqlerrml:
  17
   sqlerrmc: 0x1245"("0200")"
   sqlerrp : sqljrerm
   sqlerrd : (1) 0x80370086      (2) 0x00000086      (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:
  The application terminates with the error, SQL30020N. This APAR
  addresses a server side problem. There may be applicable client
  side fix from APAR IZ02331.
  
  The server side db2diag.log reports the following:
  ====
  2007-04-09-11.13.26.385140-240 I19393C476 LEVEL: Error
  PID : 101340 TID : 1 PROC :
  db2agent (DKNA) 0
  INSTANCE: pajfraud NODE : 000 DB : DKNA
  APPHDL : 0-851 APPID: GA656F4A.O7F0.051049181555
  FUNCTION: DB2 UDB, DRDA Application Server, sqljs_ddm_rdbrllbck,
  probe:100
  MESSAGE : Invalid Request for Transaction State
  DATA #1 : Hexdump, 4 bytes
  0x20023910 : 0000 0003 ....
  ====
  
  The client side db2diag.log reports the HDDA PROTOCOL ERRROR as
  following:
  ====
  2007-04-09-11.13.26.381000-240 I1434298H374 LEVEL: Error
  PID : 11944 TID : 10560 PROC :
  dllhost.exe
  INSTANCE: DB2 NODE : 000
  APPID : G0112233.1234.051049181555
  FUNCTION: DB2 UDB, DRDA Application Requester,
  sqljrReportServerErrReply, probe:20
  RETCODE : ZRC=0x80370086=-2143879034=SQLJR_PRTCLERR "HDDA
  PROTOCOL ERROR"
  
  2007-04-09-11.13.26.381000-240 I1434674H662 LEVEL: Error
  PID : 11944 TID : 10560 PROC :
  dllhost.exe
  INSTANCE: DB2 NODE : 000
  APPID : G0112233.1234.051049181555
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml:
  17
  sqlerrmc: 0x1245"("0200")"
  sqlerrp : sqljrerm
  sqlerrd : (1) 0x80370086 (2) 0x00000086 (3)
  0x00000000
  (4) 0x00000000 (5) 0x00000000 (6)
  0x00000000
  sqlwarn : (1) (2) (3) (4) (5) (6)
  (7) (8) (9) (10) (11)
  sqlstate:
  ====
  
  PROBLEM SUMMARY:
  As above.
  

Problem conclusion

• Problem was first fixed in Version 8 FixPak 18
  

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:

  IZ21679

Fix information

• Fixed component name

  DB2 UDB WSUE AI

• Fixed component ID

  5765F4300

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP