Database Management Post Install INSMAIN ssid0000 Compare job fails with -647 on the index

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Running the Database Management for Db2 for z/OS Post Install job Compare ssid0000 job it fails with:                                                                             
                                                                            
    ALTER INDEX PTI.PTGL700_RESTART_X1                                      
           BUFFERPOOL BP2;                                                  
 DSNT408I SQLCODE = -647, ERROR:  BUFFERPOOL BP2 FOR IMPLICIT OR            
          EXPLICIT TABLESPACE OR INDEXSPACE dbname.PTGL700R HAS NOT       
          BEEN ACTIVATED                                                    
 DSNT418I SQLSTATE   = 57003 SQLSTATE RETURN CODE                           
 DSNT415I SQLERRP    = DSNXIC01 SQL PROCEDURE DETECTING ERROR               
 DSNT416I SQLERRD    = 40  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION        
 DSNT416I SQLERRD    = X'00000028'  X'00000000'  X'00000000'                
          X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC              
          INFORMATION                                                       
 BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED.

Resolution

The actual reason for the initial failure was due to the SQL -647, The Bufferpool BP2 was invalid on the Index. To correct this edit the hlq.CDBAPARM
SETUPxx member in user and change the bufferpool from BP2 to BP9 (the correct bufferpool).  The Post Install Compare and Create JCL was regenerated
and both jobs ran to completion.