DB2 - L

  • 1.  DSNTIAUL bind fails on accelerator table

    Posted Sep 24, 2021 10:25 AM
    I am trying to bind DSNTIAUL and I get the following:
    DB2X.DSNTIB12.DSNTIAUL.(2021-09-24-14.17.30.467102)
    FAILED, BECAUSE THE DB2 SYSACCEL TABLES OR INDEXES
    ARE NOT DEFINED CORRECTLY.
    DSNT233I -DX11 UNSUCCESSFUL BIND FOR
    PACKAGE =
    DB2X.DSNTIB12.DSNTIAUL.(2021-09-24-14.17.30.467102)

    what does this have to do with the accelerator tables?
    thanks
    Bill

    ------------------------------
    williamgiannelliMe
    ------------------------------


  • 2.  RE: DSNTIAUL bind fails on accelerator table

    Posted Sep 24, 2021 08:47 PM
    Yes we got this during recent Migration of latest maintenance.

    Even with us having Z-parm ACCEL~ = NO, there must be a check on whether to use ACCELERATOR SERVICES,  exposed by Bind process,

    We just re-created ACCEL Database using new version in Job  DSNTIJAS, as we had no underlying data Drop/Recreate DB was good enough.

    HTH, 
    Steve