LI74272: LOAD IS NOT HANDLING THE SQLP_LCON GRACEFULLY, INSTEAD THE LOAD FAILS WITH A 902 AND SEVERS THE DB CONNECTION

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Load is not handling the SQLP_LCON gracefully, instead the Load
  fails with a 902 and severs the db connection
  
  
  [hotel18 - 4:12pm]:~/sqllib/db2dump# db2 load from ~/blah.del of
  del replace into t6
  SQL0902C  A system error (reason code = "121") occurred.
  Subsequent SQL
  statements cannot be processed.  SQLSTATE=58005
  

Local fix

Problem summary

• Load is not handling the SQLP_LCON gracefully, instead the Load
  fails with a 902 and severs the db connection
  
  [hotel18 - 4:12pm]:~/sqllib/db2dump# db2 load from ~/blah.del of
  del replace into t6
  SQL0902C  A system error (reason code = "121") occurred.
  Subsequent SQL
  statements cannot be processed.  SQLSTATE=58005
  

Problem conclusion

• Problem was first fixed in Version 9.5 Fix Pack 5
  

Temporary fix

Comments

APAR Information

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

  LI74271

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

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R950 PSY

     UP