zOs/SQL/DB2UT
set current sqlid = 'S100447';
-- DROP TABLESPACE DB2MAPUT.TINUSE;
COMMIT;
CREATE TABLESPACE TINUSE
IN DB2MAPUT
USING STOGROUP GSMS
PRIQTY 12 SECQTY 48
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS NO
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
CREATE TABLE S100447.TINUSE
(NAME VARCHAR(128) NOT NULL,
CREATOR VARCHAR(128) NOT NULL,
TIMESTAMP TIMESTAMP NOT NULL
)
IN DB2MAPUT.TINUSE
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
COMMIT;