Gen 8.6 construction gets SQLCODE=-812, A BLANK COLLECTION-ID WAS FOUND

Products

• Gen - Host Encyclopedia
• Gen

Issue/Introduction

After applying Response Systems Access Gen (TSO) license, Gen 8.6 Construction panels get the following DB2 error:

PROCEDURE WHERE ERROR OCCURRED: GETREL
...
DSNT408I SQLCODE=-812, ERROR:  THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE
         A BLANK COLLECTION-ID WAS FOUND IN THE CURRENT
         PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED PACKAGE
         NAME FOR PROGRAM GETID... USING PLAN XXXXXXXX
DSNT418I SQLSTATE   = 22508 SQLSTATE RETURN CODE

Environment

Access Gen (TSO)
Gen Host Encyclopedia (HE)

Resolution

To get the Gen Host Encyclopedia DB2 back in sync run CEJOB07A to bind all the Gen DB2 packages and then CEJOB07B to bind the Gen DB2 plans.