RC/Compare: failed to generate REORG tablespace for a Pending ALTER TABLESPACE
search cancel

RC/Compare: failed to generate REORG tablespace for a Pending ALTER TABLESPACE

book

Article ID: 245953

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS

Issue/Introduction

I use RC/Migrate and RC/Compare to convert classic partitioned tablespaces to UTS PBR.  I have successfully converted more than 1000 tablespaces so far.  There is one Db2 subsystem which appears to work differently, after Analysing the Compare strategy, it generated everything else (i.e. ALTER TABLESPACE and REBIND), it just refused to generate REORG statements.  I have checked Utility Model and it looks the same as in other Db2 subsystems.  How do I find out why reorg did not get generated?  

Environment

Release : 20.0

Component : RC/Compare for DB2 for z/OS

Resolution

The tablespace being converted from classic partitioned to UTS had an attribute of DEFINE NO, there were no underlying VSAM LDS datasets, so REORG is not required.  RCM didn't need to generate a REORG utility.