DDL00281 in RC/Migartor analyze

Document ID : KB000008790
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

RC/Migrator - or Quick Migration - analyze ends with: 

DDL00281: Invalid INDEXBP.  The bufferpool name must be one of:     

          BP0, BP1, ..., BP49                                       

 MIGRATOR ANALYSIS COMPLETED, RETURN CODE =   8           

 

 

Environment:
DB2 for Z/OS
Cause:

If RCM cannot determine the DB2 version it will default to DB2 v8. 

 

It is the presence of DDL from an index with e.g. BUFFERPOOL BP8K0 that triggers the DDL00281 error, since BP8K0 was not valid in DB2 v8.

 

When creating the strategy online you must enter a target SSID. If it does not exist in the SETUPxx parmlib member you will be prompted for the target DB2 version. If omitted, RCM will use V10R1M0.

 

However, in batch JCL it is possible to edit or omit PARMFILE option TRGSSID  and TRGVERS.  The problem can happen if:

 - No target TRGSSID specified (only possible in Quick Migration)

or

- Target SSID does not exist in SETUPxx and no TRGVERS is specified in JCL PARMFILE

 

 

Resolution:

Make sure the JCL contains either a TRGSSID that is defined in SETUPxx or TRGVERS

Additional Information:

Analysis Screens / DB2 SSID Specifications