zOs/SQL/LOGEXDDL
SET CURRENT SQLID='S100447';
alter TABLE OA1P.TQZ060Timeout
alter column "TYPE" set data type CHARacter(40) ;-- SBCS DATA;
commit;
x;
------------------------------------------------------------------------
-- Database=dA540769 Stogroup=GSMS
-- Table space=dA540769.A060A
------------------------------------------------------------------------
--
xrop TABLESPACE dA540769.A060A;
drop TABLESPACE dA540769.A063A;
drop TABLESPACE dA540769.A064A;
drop TABLESPACE dA540769.A065A;
commit;
CREATE TABLESPACE A060A
IN dA540769
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
--
------------------------------------------------------------------------
-- Table=A540769.TQZ060Timeout In dA540769.A060A
------------------------------------------------------------------------
--
CREATE TABLE A540769.TQZ060Timeout
(TIMESTAMP TIMESTAMP NOT NULL,
SSID CHAR(4) FOR SBCS DATA NOT NULL,
EVENT_TYPE CHAR(1) FOR SBCS DATA NOT NULL,
VICTIM_PLAN CHAR(10) FOR SBCS DATA NOT NULL,
VICTIM_CORR_ID CHAR(18) FOR SBCS DATA NOT NULL,
VICTIM_CONN_ID CHAR(18) FOR SBCS DATA NOT NULL,
HOLDER_PLAN CHAR(10) FOR SBCS DATA NOT NULL,
HOLDER_CORR_ID CHAR(18) FOR SBCS DATA NOT NULL,
HOLDER_CONN_ID CHAR(18) FOR SBCS DATA NOT NULL,
REASON_CODE CHAR(10) FOR SBCS DATA NOT NULL,
"TYPE" CHAR(25) FOR SBCS DATA NOT NULL,
NAME CHAR(80) FOR SBCS DATA NOT NULL,
rz char(3) FOR SBCS DATA NOT NULL with default '?',
dbSys char(4) FOR SBCS DATA NOT NULL with default '?',
loadDate date not null with default
)
IN dA540769.A060A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
COMMENT ON TABLE A540769.TQZ060Timeout
IS 'DB2 DEADLOCK & TIMEOUT AUSWERTUNG - IN DIESER TABELLE SIND SÄMTL
ICHE DEADLOCKS & TIMEOUTS SÄMTLICHER DB2 SUBSYSTEME AUS DEM RZ1 ZUSAMMEN
GEFASST.';
CREATE INDEX A540769.IQZ060A1 --- es gibt halt noch duplicates
ON A540769.TQZ060Timeout --- weil wir luw-id nicht mitnehmen ...
(rz, timestamp, dbSys, ssid, event_type, victim_corr_id
,holder_corr_id, name
)
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP GSMS
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED
;
--
------------------------------------------------------------------------
-- Database=dA540769 Stogroup=GSMS
-- Table space=dA540769.A063A
------------------------------------------------------------------------
--
CREATE TABLESPACE A063A
IN dA540769
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
--
------------------------------------------------------------------------
-- Table=A540769.tqz063UOW In dA540769.A063A
------------------------------------------------------------------------
--
CREATE TABLE A540769.tqz063UOW
(TIMESTAMP TIMESTAMP NOT NULL,
SSID CHAR(4) FOR SBCS DATA NOT NULL,
EVENT_TYPE CHAR(1) FOR SBCS DATA NOT NULL,
PLAN_NAME CHAR(10) FOR SBCS DATA NOT NULL,
CORRID_ID CHAR(18) FOR SBCS DATA NOT NULL,
CONN_ID CHAR(18) FOR SBCS DATA NOT NULL,
AUTHID CHAR(10) FOR SBCS DATA NOT NULL,
LOGREC CHAR(10) FOR SBCS DATA NOT NULL,
rz char(3) FOR SBCS DATA NOT NULL with default '?',
dbSys char(4) FOR SBCS DATA NOT NULL with default '?',
loadDate date not null with default
)
IN dA540769.A063A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
COMMENT ON TABLE A540769.tqz063UOW
IS 'DB2 UNCOMMITTED UOW AUSWERTUNG - IN DIESER TABELLE SIND SÄMTLICH
E UNCOMMITED UOWS SÄMTLICHER DB2 SUBSYSTEME AUS DEM RZ1 ZUSAMMENGEFASST.
';
CREATE INDEX A540769.IQZ063A1
ON A540769.TQZ063UOW
(rz, timestamp, dbSys, ssid, event_type, corrid_id, conn_id
,logrec
)
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP GSMS
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED ;
--
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A064A In Database dA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=dA540769 Stogroup=GSMS
-- Table space=dA540769.A064A
------------------------------------------------------------------------
--
CREATE TABLESPACE A064A
IN dA540769
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
--
------------------------------------------------------------------------
-- Table=A540769.tqz064LockEscal In dA540769.A064A
------------------------------------------------------------------------
--
CREATE TABLE A540769.tqz064LockEscal
(TIMESTAMP TIMESTAMP NOT NULL,
SSID CHAR(4) FOR SBCS DATA NOT NULL,
EVENT_TYPE CHAR(1) FOR SBCS DATA NOT NULL,
PLAN_NAME CHAR(10) FOR SBCS DATA NOT NULL,
PACKAGE_NAME CHAR(18) FOR SBCS DATA NOT NULL,
COLLECTION_ID CHAR(18) FOR SBCS DATA NOT NULL,
CORRID_ID CHAR(18) FOR SBCS DATA NOT NULL,
CONN_ID CHAR(18) FOR SBCS DATA NOT NULL,
RESOURCE CHAR(80) FOR SBCS DATA NOT NULL,
LOCK_STATE CHAR(1) FOR SBCS DATA NOT NULL,
STATEMENT CHAR(10) FOR SBCS DATA NOT NULL,
rz char(3) FOR SBCS DATA NOT NULL with default '?',
dbSys char(4) FOR SBCS DATA NOT NULL with default '?',
loadDate date not null with default
)
IN dA540769.A064A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
COMMENT ON TABLE A540769.tqz064LockEscal
IS 'DB2 LOCK ESCALATION AUSWERTUNG - IN DIESER TABELLE SIND SÄMTLICH
E LOCK ESCALATION SÄMTLICHER DB2 SUBSYSTEME AUS DEM RZ1 ZUSAMMENGEFASST.
';
CREATE INDEX A540769.IQZ064A1
ON A540769.TQZ064LockEscal
(rz, timestamp, dbSys, ssid, event_type, corrid_id, conn_id
,resource
)
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP GSMS
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED ;
--
--
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A065A In Database dA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=dA540769 Stogroup=GSMS
-- Table space=dA540769.A065A
------------------------------------------------------------------------
--
CREATE TABLESPACE A065A
IN dA540769
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
--
------------------------------------------------------------------------
-- Table=A540769.tqz065Abend In dA540769.A065A
------------------------------------------------------------------------
--
CREATE TABLE A540769.tqz065Abend
(TIMESTAMP TIMESTAMP NOT NULL,
SSID CHAR(4) FOR SBCS DATA NOT NULL,
EVENT_TYPE CHAR(1) FOR SBCS DATA NOT NULL,
CORRID_ID CHAR(18) FOR SBCS DATA NOT NULL,
JOBNAME CHAR(18) FOR SBCS DATA NOT NULL,
CONN_ID CHAR(18) FOR SBCS DATA NOT NULL,
AUTHID CHAR(10) FOR SBCS DATA NOT NULL,
ASID CHAR(10) FOR SBCS DATA NOT NULL,
TCB CHAR(20) FOR SBCS DATA NOT NULL,
rz char(3) FOR SBCS DATA NOT NULL with default '?',
dbSys char(4) FOR SBCS DATA NOT NULL with default '?',
loadDate date not null with default
)
IN dA540769.A065A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
COMMENT ON TABLE A540769.tqz065Abend
IS 'DB2 ABORMAL EOT AUSWERTUNG - IN DIESER TABELLE SIND SÄMTLICHE AB
NORMAL EOT SÄMTLICHER DB2 SUBSYSTEME AUS DEM RZ1 ZUSAMMENGEFASST.';
--
CREATE INDEX A540769.IQZ065A1
ON A540769.tqz065Abend
(rz, timestamp, dbSys, ssid, event_type, corrid_id, conn_id
,jobname
)
CLUSTER
DEFINE YES
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
DEFER NO
COPY NO
USING STOGROUP GSMS
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 0
PCTFREE 5
GBPCACHE CHANGED ;
COMMIT;