zOs/SQL/RTST10

.CONNECT DP4G


 SET CURRENT SQLID = 'S100447';


    CREATE TABLE "SYSIBM".SYSTABLESPACESTATS
        (UPDATESTATSTIME TIMESTAMP (6) WITHOUT TIME ZONE
                                                        NOT NULL
  WITH DEFAULT
        ,NACTIVE INTEGER
  WITH DEFAULT NULL
        ,NPAGES INTEGER
  WITH DEFAULT NULL
        ,EXTENTS SMALLINT
  WITH DEFAULT NULL
        ,LOADRLASTTIME TIMESTAMP (6) WITHOUT TIME ZONE
  WITH DEFAULT NULL
        ,REORGLASTTIME TIMESTAMP (6) WITHOUT TIME ZONE
  WITH DEFAULT NULL
        ,REORGINSERTS INTEGER
  WITH DEFAULT NULL
        ,REORGDELETES INTEGER
  WITH DEFAULT NULL
        ,REORGUPDATES INTEGER
  WITH DEFAULT NULL
        ,REORGUNCLUSTINS INTEGER
  WITH DEFAULT NULL
        ,REORGDISORGLOB INTEGER
  WITH DEFAULT NULL
        ,REORGMASSDELETE INTEGER
  WITH DEFAULT NULL
        ,REORGNEARINDREF INTEGER
  WITH DEFAULT NULL
        ,REORGFARINDREF INTEGER
  WITH DEFAULT NULL
        ,STATSLASTTIME TIMESTAMP (6) WITHOUT TIME ZONE
  WITH DEFAULT NULL
        ,STATSINSERTS INTEGER
  WITH DEFAULT NULL
        ,STATSDELETES INTEGER
  WITH DEFAULT NULL
        ,STATSUPDATES INTEGER
  WITH DEFAULT NULL
        ,STATSMASSDELETE INTEGER
  WITH DEFAULT NULL
        ,COPYLASTTIME TIMESTAMP (6) WITHOUT TIME ZONE
  WITH DEFAULT NULL
        ,COPYUPDATEDPAGES INTEGER
  WITH DEFAULT NULL
        ,COPYCHANGES INTEGER
  WITH DEFAULT NULL
        ,COPYUPDATELRSN CHARACTER(6) FOR BIT DATA
  WITH DEFAULT NULL
        ,COPYUPDATETIME TIMESTAMP (6) WITHOUT TIME ZONE
  WITH DEFAULT NULL
        ,IBMREQD CHARACTER(1) FOR MIXED DATA
                                                        NOT NULL
        ,DBID SMALLINT
                                                        NOT NULL
        ,"PSID" SMALLINT
                                                        NOT NULL
        ,"PARTITION" SMALLINT
                                                        NOT NULL
        ,INSTANCE SMALLINT
                                                        NOT NULL
  WITH DEFAULT 1
        ,SPACE BIGINT
  WITH DEFAULT NULL
        ,TOTALROWS BIGINT
  WITH DEFAULT NULL
        ,DATASIZE BIGINT
  WITH DEFAULT NULL
        ,UNCOMPRESSEDDATASIZE BIGINT
  WITH DEFAULT NULL
        ,DBNAME VARCHAR(24) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT
        ,"NAME" VARCHAR(24) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT
        ,REORGCLUSTERSENS BIGINT
  WITH DEFAULT NULL
        ,REORGSCANACCESS BIGINT
  WITH DEFAULT NULL
        ,REORGHASHACCESS BIGINT
  WITH DEFAULT NULL
        ,HASHLASTUSED DATE
  WITH DEFAULT NULL
        ,DRIVETYPE CHARACTER(3) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT 'HDD'
        ,LPFACILITY CHARACTER(1) FOR MIXED DATA
  WITH DEFAULT NULL
        ,STATS01 BIGINT
  WITH DEFAULT NULL
        ,CONSTRAINT DSNTSS_INSTANCE CHECK
        (INSTANCE = 1 OR INSTANCE = 2
        )
        )
        IN DSNDB06.SYSRTSTS
   APPEND NO
   NOT VOLATILE CARDINALITY
   DATA CAPTURE NONE
   AUDIT NONE
   CCSID UNICODE;