zOs/SQL/DDLCHSTD

                                                                17. 6.16
  ty cat               ap std       remark

tablespace ts
  ts n   name             %
  ts p   nTables          1
  ts p   type             PBR       = UTS partitioned by Range
                          PBG       = UTS partitioned by Growth
  ts p   partitions       <= 200    for PBR
  ts p   maxParts         10        for PBG
  ts o   bufferpool       bp2,pb32k
  ts pq  ccsid            ebcdic
  ts o * close            yes
  ts oq  dsSize           16GB      for PBR, but use only 4GB of it
                           4GB      for PBG (will be used completely)
  ts o * erase            no
  ts oq* lockmax          system
  ts oq* locksize         any
  ts o * logged           yes
  ts o * maxrows          255
  ts pq  memberCluster x  yes
       *                  no
  ts o   segsize          64
  ts p * clone            N

tablePart tp
  tp o   compress         yes
  tp o   stoGroup      x  GSMS1/2/3/4
                          GSMS
  tp o * priQty           -1
  tp o * secQty           -1
  tp oq* freepage         0
  tp oq* pctfree       x  0
                          5
  tp o * gbpCache         changed

table t
  t  n   creator       x  BUA
  t  n                    OA1P,OA1P99  .
  t  n   name          x  'XB' || substr(tsName, 2,6)
  t  n                    T || substr(db,1,2) || substr(ts,2,4) %
  t  p ts  implicit       no
  t  p   append        x  yes
     p *                  no
  t  p * audit            none
  t  o   datacapture      changes
  t  o   restrictDrop     yes
  t  p   volatile      x  yes
                          no
  t  p   clusterIndex     obligatory if there are indexes
  t  p   partitioning     table based
  t  p   primKeyConst     obligatory if there are unique indexes
  t  p   tableStatus      ok

column c
  c  p   type             disallowed: xml, lob, tst with zone, decFloat...
  c  p   hidden           disallowd

index i
  i  n   creator          = tbCreator
  i  n   name             I || substr(tb, 2, 6) %
  i  p   type             disallowed: on expression
  i  p * padded           no
  i  a   partitioned      for PBR (if possible and performant)
  i  p * piecesize        4GB (in not partitioned)

indexPart ip              specify on index level not on part level
  ip o * close            yes
  ip o * compress         no
  ip o * copy             no
  ip o * erase            no
  ip o   stoGroup      x  GSMS1/2/3/4
                          GSMS
  ip o * priQty           -1
  ip o * secQty           -1
  ip oq* freepage         0
  ip oq* pctfree          10
  ip o * gbpCache         changed

view
  v  n   name             V || substr(db, 1, 2) || substr(ts, 2, 3) %
  v  n   creator       x  BUA
                          OA1P,OA1P99