PI29722: QUERY WITH FETCH FIRST ROWS CONDITION FAIL WHEN EXECUTED IN SUCCESSION

APAR status

• Closed as program error.

Error description

• When running a query which contains  FETCH FIRST ROWS condition
  in back-to-back, it may fail with the following error:
  
  [State: ZZZZZ][Code: -5105]: The statement failed because a Big
  SQL component encountered an error. Component receiving the
  error: "BigSQL IO". Component returning the error: "UNKNOWN".
  Log entry identifier: "[BSL-nn-xxxxxxx]".. SQLCODE=-5105,
  SQLSTATE=ZZZZZ, DRIVER=3.68.61
  
  SQL5105N  The statement failed because a Big SQL component
  encountered an error. Component receiving the error: "BigSQL
  IO". Component returning the error: "UNKNOWN".
  

Local fix

Problem summary

• See Error Description
  

Problem conclusion

• This problem is fixed in Version 3.0.0.2 Sprint2 and later fix
  packs
  

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:

Fix information

• Fixed component name

  INFO BIGINSIGHT

• Fixed component ID

  5725C0900

Applicable component levels

• R300 PSY

     UP