zOs/SQL/RTSI10

.CONNECT DP4G


 SET CURRENT SQLID = 'S100447';


    CREATE TABLE "SYSIBM".SYSINDEXSPACESTATS
        (UPDATESTATSTIME TIMESTAMP (6) WITHOUT TIME ZONE
                                                        NOT NULL
  WITH DEFAULT
        ,NLEVELS SMALLINT
  WITH DEFAULT NULL
        ,NPAGES INTEGER
  WITH DEFAULT NULL
        ,NLEAF INTEGER
  WITH DEFAULT NULL
        ,NACTIVE INTEGER
  WITH DEFAULT NULL
        ,SPACE INTEGER
  WITH DEFAULT NULL
        ,EXTENTS SMALLINT
  WITH DEFAULT NULL
        ,LOADRLASTTIME TIMESTAMP (6) WITHOUT TIME ZONE
  WITH DEFAULT NULL
        ,REBUILDLASTTIME 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
        ,REORGAPPENDINSERT INTEGER
  WITH DEFAULT NULL
        ,REORGPSEUDODELETES INTEGER
  WITH DEFAULT NULL
        ,REORGMASSDELETE INTEGER
  WITH DEFAULT NULL
        ,REORGLEAFNEAR INTEGER
  WITH DEFAULT NULL
        ,REORGLEAFFAR INTEGER
  WITH DEFAULT NULL
        ,REORGNUMLEVELS INTEGER
  WITH DEFAULT NULL
        ,STATSLASTTIME TIMESTAMP (6) WITHOUT TIME ZONE
  WITH DEFAULT NULL
        ,STATSINSERTS INTEGER
  WITH DEFAULT NULL
        ,STATSDELETES 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
        ,LASTUSED DATE
  WITH DEFAULT NULL
        ,IBMREQD CHARACTER(1) FOR MIXED DATA
                                                        NOT NULL
        ,DBID SMALLINT
                                                        NOT NULL
        ,"ISOBID" SMALLINT
                                                        NOT NULL
        ,"PSID" SMALLINT
                                                        NOT NULL
        ,"PARTITION" SMALLINT
                                                        NOT NULL
        ,INSTANCE SMALLINT
                                                        NOT NULL
  WITH DEFAULT 1
        ,TOTALENTRIES BIGINT
  WITH DEFAULT NULL
        ,DBNAME VARCHAR(24) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT
        ,"NAME" VARCHAR(128) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT
        ,CREATOR VARCHAR(128) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT
        ,INDEXSPACE VARCHAR(24) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT
        ,REORGINDEXACCESS BIGINT
  WITH DEFAULT NULL
        ,DRIVETYPE CHARACTER(3) FOR MIXED DATA
                                                        NOT NULL
  WITH DEFAULT 'HDD'
        ,STATS101 BIGINT
  WITH DEFAULT NULL
        ,CONSTRAINT DSNISS_INSTANCE CHECK
        (INSTANCE = 1 OR INSTANCE = 2
        )
        )
        IN DSNDB06.SYSRTSTS
   APPEND NO
   NOT VOLATILE CARDINALITY
   DATA CAPTURE NONE
   AUDIT NONE
   CCSID UNICODE;