zOs/TX/WK968DDL
set current sqlid = 'S100447';
drop tablespace $db.a968a;
commit;
$@[
if $phase >= 1 then $@=[
CREATE TABLESPACE A968A
IN $db
USING STOGROUP GSMS
PRIQTY 12 SECQTY 7200
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
segsize 64
BUFFERPOOL $-[if($phase<=2, BP||$phase, if($phase=3, BP8K0,BP32K))$]
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255
;
CREATE TABLE $creator.TWK968A1
(WK968CHA CHAR(10) NOT NULL
)
IN $db.A968A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
;
COMMIT;
$]
$]