zOs/SQL/TVV

  CREATE VIEW S100447.VRTSREOIXException AS
      SELECT PRIO, db, ts, ix,
          PARTVON, PARTBIS, GUVON, GUBIS,
          reorg, pageSplits, extents, reorgdays,
          inserts, deletes, pseudoDel,
          inserttimestamp, remark,
          CASE WHEN POSSTR(DB,  '*') > 0
               THEN POSSTR(DB,  '*') - 1 ELSE 8 END DBLEN,
          CASE WHEN POSSTR(TS,  '*') > 0
               THEN POSSTR(TS,  '*') - 1 ELSE 8 END TSLEN,
          CASE WHEN POSSTR(IX,  '*') > 0
               THEN POSSTR(IX,  '*') - 1 ELSE 20 END IXLEN,
          char(RIGHT('0' || STRIP(CHAR(PRIO)), 2)
              || strip(DB) || case when POSSTR(DB, '*') > 0
                                   then '' else '=' end
              || strip(ts) || case when POSSTR(ts, '*') > 0
                                   then '' else '=' end
              || strip(ix) || case when POSSTR(ix, '*') > 0
                                   then '' else '=' end
              || right('0000' || strip(char(partVon)), 4)
              || '.' || translate('34679A', char(GUVON, ISO),
                                                   '123456789A')
              , 52) KEY
      FROM S100447.TRTSREOIXException ;
    commit;
  COMMENT ON table S100447.VRTSREOIXException
    IS 'diese Tabelle enthaelt die Default-Schwellwerte und die Indexe m
it speziellen Schwellwerten für RTS-Reorgs.'
;
  LABEL ON S100447.VRTSREOIXException
    ( PRIO                is 'Prioritaet: tiefste=0=Default' ,
      DB                  is 'Datenbank Name'                ,
      TS                  is 'TableSpace Name'               ,
      IX                  is 'Index Name'                    ,
      PARTVON             is 'Partition von'                 ,
      PARTBIS             is 'Partition bis'                 ,
      GUVON               is 'Gueltig von'                   ,
      GUBIS               is 'Gueltig bis'                   ,
      REORG               is 'ALWAYS,NEVER,THRESHOLD'        ,
      PAGESPLITS          is 'Schwellwert ReorgLeafFar %'    ,
      EXTENTS             is 'SchwWe Extents pro TS/Part'    ,
      REORGDAYS           is 'Schwellwert Anzahl Tage'       ,
      INSERTS             is 'Schwellwert inserts %'         ,
      DELETES             is 'Schwellwert deletes %'         ,
      PseudoDel           is 'Schwellwert PseudoDeletes %'   ,
      INSERTTIMESTAMP     is 'Erstellungs Zeitpunkt'         ,
      REMARK              is 'Begründung (Freitext)'         ,
      DBLEN               is 'Laenge Datenbank Name'         ,
      TSLEN               is 'Laenge Datenbank Name'         ,
      IXLEN               is 'Laenge Index Name'             ,
      KEY                 is 'eindeutiger Schluessel'
    ) ;