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

Products

• Gen - Host Encyclopedia
• Gen

Issue/Introduction

When accessing the Gen panels the following DB2 error occurred:

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

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.