INSMAIN Install ssid0000 Compare job fails with -647 on the index.

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

Running the Install job Compare DSN0000 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 DBTDBS01.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.                

Environment

Release : 20.0

Component : DB2 Common Components

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 setupxx and change the bufferpool from BP2 to BP9 (the correct bufferpool), and regenerated the Compare and Create and both jobs ran to completion.