Library /sys$common/syshlp/SQL$HELP72.HLB  —  Errors  SQL_ERRORS, THRNOTALL
  Threshold buffers is not a valid option for Async Prefetch

  Explanation:  The THRESHOLD option is only valid with DETECTED
  ASYNC PREFETCH and not with ASYNC PREFETCH.

  User Action:  If you want the ASYNC PREFETCH feature, remove the
  THRESHOLD syntax.  If you want the DETECTED ASYNC PREFETCH
  feature, you must specify the DETECTED keyword and include the
  THRESHOLD syntax.
Close Help