zOs/SQL/GBGRMICI

with u as
(
  select 'old' on, rz, dbSys, dbName, ts, indexSpace,partition,instance
      , loadTs
      , updateStatsTime origStatsTime
      , timestamp('1010-10-10-10.10.10') updateStatsTime
      , INDEXTYPE
      , COMPRESS
      , IXPARTS
      , IXPGSZ
      , PIECESIZE
      , PIECEGB
      , LIMGB
      , TBCREATOR
      , TBNAME
      , TSTY
      , TSPARTS
      , TSCLONE
      , TSINST
      , TSDSSIZE
      , TSDSGB
      , TSLIMGB
      , TSLIMPART
      , TSPGSZ
      , NLEVELS
      , NPAGES
      , NLEAF
      , NACTIVE
      , SPACE
      , EXTENTS
      , LOADRLASTTIME
      , REBUILDLASTTIME
      , REORGLASTTIME
      , REORGINSERTS
      , REORGDELETES
      , REORGAPPENDINSERT
      , REORGPSEUDODELETES
      , REORGMASSDELETE
      , REORGLEAFNEAR
      , REORGLEAFFAR
      , REORGNUMLEVELS
      , STATSLASTTIME
      , STATSINSERTS
      , STATSDELETES
      , STATSMASSDELETE
      , COPYLASTTIME
      , COPYUPDATEDPAGES
      , COPYCHANGES
      , COPYUPDATELRSN
      , COPYUPDATETIME
      , LASTUSED
      , IBMREQD
      , DBID
      , ISOBID
      , PSID
      , TOTALENTRIES
      , NAME
      , CREATOR
      , REORGINDEXACCESS
      , DRIVETYPE
      , STATS101
    from oa1p.tqz007gbgrIxStats
    where rz ='RR2' and  dbSys = 'DBOF' and dbName = 'NI03A1P'
           and ts = 'A200A03'   and partition = 38
  union all select 'new' on
      , rz, dbSys, dbName, ts, indexSpace,partition,instance
      , loadTs
      , origStatsTime
      , updateStatsTime
      , INDEXTYPE
      , COMPRESS
      , IXPARTS
      , IXPGSZ
      , PIECESIZE
      , PIECEGB
      , LIMGB
      , TBCREATOR
      , TBNAME
      , TSTY
      , TSPARTS
      , TSCLONE
      , TSINST
      , TSDSSIZE
      , TSDSGB
      , TSLIMGB
      , TSLIMPART
      , TSPGSZ
      , NLEVELS
      , NPAGES
      , NLEAF
      , NACTIVE
      , SPACE
      , EXTENTS
      , LOADRLASTTIME
      , REBUILDLASTTIME
      , REORGLASTTIME
      , REORGINSERTS
      , REORGDELETES
      , REORGAPPENDINSERT
      , REORGPSEUDODELETES
      , REORGMASSDELETE
      , REORGLEAFNEAR
      , REORGLEAFFAR
      , REORGNUMLEVELS
      , STATSLASTTIME
      , STATSINSERTS
      , STATSDELETES
      , STATSMASSDELETE
      , COPYLASTTIME
      , COPYUPDATEDPAGES
      , COPYCHANGES
      , COPYUPDATELRSN
      , COPYUPDATETIME
      , LASTUSED
      , IBMREQD
      , DBID
      , ISOBID
      , PSID
      , TOTALENTRIES
      , NAME
      , CREATOR
      , REORGINDEXACCESS
      , DRIVETYPE
      , STATS101
    from oa1p.tqz667gbgrIxStats
    where rz ='RR2' and  dbSys = 'DBOF' and dbName = 'NI03A1P'
           and ts = 'A200A03'   and partition = 38
)
select * from u
   order by rz, dbSys, dbName, ts,indexSpace, partition, instance
       , loadTs desc, on