无法turn off DB2 tranaction log
$ db2 "alter table XXX activate not logged initially"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0628N Multiple or conflicting keywords involving the "ACTIVATE NOT LOGGED
INITIALLY" clause are present. SQLSTATE=42613
这是为什么呢？
3同行回答
CREATE TABLE "YYY"."XXX" (
"OID" BIGINT NOT NULL ,
"CUSTOMER" INTEGER NOT NULL ,
"SERVICE" INTEGER NOT NULL ,
"KEYNAME" VARCHAR(254 OCTETS) NOT NULL ,
"VALUE" VARCHAR(512 OCTETS) ,
"CREATED" TIMESTAMP NOT NULL ,
"CREATED_BY" VARCHAR(32 OCTETS) NOT NULL ,
"LAST_MODIFIED" TIMESTAMP NOT NULL ,
"MODIFIED_BY" VARCHAR(32 OCTETS) NOT NULL ,
"ROW_CHANGE_TS" TIMESTAMP NOT NULL IMPLICITLY HIDDEN GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP )
IN "DAT_4K" INDEX IN "IDX_4K"
ORGANIZE BY ROW;
收起- 建表语句加上 NOT LOGGED INITIALLY
