zOs/SQL/FRANZDDN
--
SET CURRENT SQLID='S100447';
--
drop TABLESPACE dA540769.A242A;
commit;
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBAF (810) Extract time : 2006-10-26 10:47 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=N UF=N SP=N SQ=N --
-- Grants : SG=N DB=Y TS=Y TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Tablespace=A242A In Database DA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769 Stogroup=GSMS (for partition 1)
-- Tablespace=DA540769.A242A
------------------------------------------------------------------------
--
CREATE TABLESPACE A242A
IN DA540769
USING STOGROUP GSMS
PRIQTY 360000 SECQTY 72000
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
DSSIZE 16 G
NUMPARTS 65
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=A540769.TNZ242A1 In DA540769.A242A
------------------------------------------------------------------------
--
CREATE TABLE A540769.TNZ242A1
(NZ242001 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242002 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242003 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242004 CHAR(10) FOR SBCS DATA NOT NULL,
NZ242005 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242006 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242007 CHAR(10) FOR SBCS DATA NOT NULL,
NZ242008 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242009 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242010 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242011 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242012 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242013 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242014 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242015 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242016 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242017 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242018 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242019 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242020 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242021 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242022 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242023 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242024 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242025 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242026 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242027 CHAR(50) FOR SBCS DATA NOT NULL,
NZ242028 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242029 CHAR(10) FOR SBCS DATA NOT NULL,
NZ242030 CHAR(26) FOR SBCS DATA NOT NULL,
NZ242031 CHAR(20) FOR SBCS DATA NOT NULL,
NZ242032 CHAR(1) FOR SBCS DATA NOT NULL,
NZ242033 VARCHAR(3100) FOR SBCS DATA NOT NULL)
IN DA540769.A242A
PARTITION BY (NZ242001 ASC,
NZ242003 ASC,
NZ242004 ASC,
NZ242005 ASC,
NZ242006 ASC,
NZ242007 ASC,
NZ242008 ASC)
(PART 1 VALUES(X'0003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 2 VALUES(X'0007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 3 VALUES(X'000BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 4 VALUES(X'000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 5 VALUES(X'0013FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 6 VALUES(X'0017FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 7 VALUES(X'001BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 8 VALUES(X'001FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 9 VALUES(X'0023FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 10 VALUES(X'0027FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 11 VALUES(X'002BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 12 VALUES(X'002FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 13 VALUES(X'0033FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 14 VALUES(X'0037FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 15 VALUES(X'003BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 16 VALUES(X'003FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 17 VALUES(X'0043FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 18 VALUES(X'0047FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 19 VALUES(X'004BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 20 VALUES(X'004FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 21 VALUES(X'0053FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 22 VALUES(X'0057FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 23 VALUES(X'005BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 24 VALUES(X'005FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 25 VALUES(X'0063FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 26 VALUES(X'0067FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 27 VALUES(X'006BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 28 VALUES(X'006FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 29 VALUES(X'0073FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 30 VALUES(X'0077FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 31 VALUES(X'007BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 32 VALUES(X'007FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 33 VALUES(X'0083FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 34 VALUES(X'0087FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 35 VALUES(X'008BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 36 VALUES(X'008FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 37 VALUES(X'0093FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 38 VALUES(X'0097FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 39 VALUES(X'009BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 40 VALUES(X'009FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 41 VALUES(X'00A3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 42 VALUES(X'00A7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 43 VALUES(X'00ABFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 44 VALUES(X'00AFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 45 VALUES(X'00B3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 46 VALUES(X'00B7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 47 VALUES(X'00BBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 48 VALUES(X'00BFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 49 VALUES(X'00C3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 50 VALUES(X'00C7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 51 VALUES(X'00CBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 52 VALUES(X'00CFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 53 VALUES(X'00D3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 54 VALUES(X'00D7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 55 VALUES(X'00DBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 56 VALUES(X'00DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 57 VALUES(X'00E3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 58 VALUES(X'00E7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 59 VALUES(X'00EBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 60 VALUES(X'00EFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 61 VALUES(X'00F3FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 62 VALUES(X'00F7FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 63 VALUES(X'00FBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 64 VALUES(X'00FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),
PART 65 VALUES(X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'))
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE A540769.TNZ242A1 IS 'ZV Histo: HistoData';
--
COMMENT ON A540769.TNZ242A1
(NZ242033 IS 'SERIALISIERTE OBJEKTE BZW DER DATENTEIL',
NZ242032 IS 'SOLL/HABEN IDENTIFIKATION',
NZ242031 IS 'STRUKTURTYP DES OBJEKTS',
NZ242030 IS 'TIMESTAMP ERSTELLZEITPUNKT',
NZ242029 IS 'VERSION DES OBJEKTES BZW. SOFTWARESTAND DER STRUKTUR',
NZ242028 IS 'BESCHREIBUNG SUCHWERT 10',
NZ242027 IS 'SUCHWERT 10',
NZ242026 IS 'BESCHREIBUNG SUCHWERT 09',
NZ242025 IS 'SUCHWERT 09',
NZ242024 IS 'BESCHREIBUNG SUCHWERT 08',
NZ242023 IS 'SUCHWERT 08',
NZ242022 IS 'BESCHREIBUNG SUCHWERT 07',
NZ242021 IS 'SUCHWERT 07',
NZ242020 IS 'BESCHREIBUNG SUCHWERT 06',
NZ242019 IS 'SUCHWERT 06',
NZ242018 IS 'BESCHREIBUNG SUCHWERT 05',
NZ242017 IS 'SUCHWERT 05',
NZ242016 IS 'BESCHREIBUNG SUCHWERT 04',
NZ242015 IS 'SUCHWERT 04',
NZ242014 IS 'BESCHREIBUNG SUCHWERT 03',
NZ242013 IS 'SUCHWERT 03',
NZ242012 IS 'BESCHREIBUNG SUCHWERT 02',
NZ242011 IS 'SUCHWERT 02',
NZ242010 IS 'BESCHREIBUNG SUCHWERT 01',
NZ242009 IS 'SUCHWERT 01',
NZ242008 IS 'OBJEKTTYP',
NZ242007 IS 'GESCHAEFTSFALLTYP',
NZ242006 IS 'ID DES STATUSAUSLOESERS ODER BEARBEITUNGSMITTEL',
NZ242005 IS 'STATUSANGABE',
NZ242004 IS 'IDENTIFIKATIONSNUMMER',
NZ242003 IS 'REFERENZNUMMER DES SENDEOBJEKTES',
NZ242002 IS 'TECHNISCHER IDENTIFIKATIONSSCHLUESSEL UNIQUE',
NZ242001 IS 'TECHNISCHER SCHLUESSEL ZUM HISTO HEADERTEIL');
--
LABEL ON A540769.TNZ242A1
(NZ242033 IS 'Object',
NZ242032 IS 'SideType',
NZ242031 IS 'ObjDescType',
NZ242030 IS 'CreateDateTime',
NZ242029 IS 'ObjTypeVersion',
NZ242028 IS 'SearchType10',
NZ242027 IS 'SearchValue10',
NZ242026 IS 'SearchType09',
NZ242025 IS 'SearchValue09',
NZ242024 IS 'SearchType08',
NZ242023 IS 'SearchValue08',
NZ242022 IS 'SearchType07',
NZ242021 IS 'SearchValue07',
NZ242020 IS 'SearchType06',
NZ242019 IS 'SearchValue06',
NZ242018 IS 'SearchType05',
NZ242017 IS 'SearchValue05',
NZ242016 IS 'SearchType04',
NZ242015 IS 'SearchValue04',
NZ242014 IS 'SearchType03',
NZ242013 IS 'SearchValue03',
NZ242012 IS 'SearchType02',
NZ242011 IS 'SearchValue02',
NZ242010 IS 'SearchType01',
NZ242009 IS 'SearchValue01',
NZ242008 IS 'ObjType',
NZ242007 IS 'GfsType',
NZ242006 IS 'ProcesserId',
NZ242005 IS 'ProcessStatus',
NZ242004 IS 'IdentNumber',
NZ242003 IS 'RefId',
NZ242002 IS 'IdentUwi',
NZ242001 IS 'HeaderUwi');
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.INZ242A1 On A540769.TNZ242A1
------------------------------------------------------------------------
--
CREATE INDEX A540769.INZ242A1
ON A540769.TNZ242A1
(NZ242001 ASC,
NZ242003 ASC,
NZ242004 ASC,
NZ242005 ASC,
NZ242006 ASC,
NZ242007 ASC,
NZ242008 ASC)
PARTITIONED
USING STOGROUP GSMS
PRIQTY 180000 SECQTY 36000
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES;
--
------------------------------------------------------------------------
-- View=A540769.VNZ242A1V
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","GDB0283" ;
--
CREATE VIEW A540769.VNZ242A1V(HEADERUWI, IDENTUWI, REFID,
IDENTNUMBER, PROCESSSTATUS, PROCESSERID, GFSTYPE, OBJTYPE,
SEARCHVALUE01, SEARCHTYPE01, SEARCHVALUE02, SEARCHTYPE02,
SEARCHVALUE03, SEARCHTYPE03, SEARCHVALUE04, SEARCHTYPE04,
SEARCHVALUE05, SEARCHTYPE05, SEARCHVALUE06, SEARCHTYPE06,
SEARCHVALUE07, SEARCHTYPE07, SEARCHVALUE08, SEARCHTYPE08,
SEARCHVALUE09, SEARCHTYPE09, SEARCHVALUE10, SEARCHTYPE10,
OBJTYPEVERSION, CREATEDATETIME, OBJDESCTYPE, SIDETYPE, OBJECT)
AS
SELECT ALL A540769.TNZ242A1.NZ242001, A540769.TNZ242A1.NZ242002,
A540769.TNZ242A1.NZ242003, A540769.TNZ242A1.NZ242004,
A540769.TNZ242A1.NZ242005, A540769.TNZ242A1.NZ242006,
A540769.TNZ242A1.NZ242007, A540769.TNZ242A1.NZ242008,
A540769.TNZ242A1.NZ242009, A540769.TNZ242A1.NZ242010,
A540769.TNZ242A1.NZ242011, A540769.TNZ242A1.NZ242012,
A540769.TNZ242A1.NZ242013, A540769.TNZ242A1.NZ242014,
A540769.TNZ242A1.NZ242015, A540769.TNZ242A1.NZ242016,
A540769.TNZ242A1.NZ242017, A540769.TNZ242A1.NZ242018,
A540769.TNZ242A1.NZ242019, A540769.TNZ242A1.NZ242020,
A540769.TNZ242A1.NZ242021, A540769.TNZ242A1.NZ242022,
A540769.TNZ242A1.NZ242023, A540769.TNZ242A1.NZ242024,
A540769.TNZ242A1.NZ242025, A540769.TNZ242A1.NZ242026,
A540769.TNZ242A1.NZ242027, A540769.TNZ242A1.NZ242028,
A540769.TNZ242A1.NZ242029, A540769.TNZ242A1.NZ242030,
A540769.TNZ242A1.NZ242031, A540769.TNZ242A1.NZ242032,
A540769.TNZ242A1.NZ242033
FROM A540769.TNZ242A1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--