recreate explain table的时候抛出错误http://www.cndba.cn/hbhe0316/article/108013http://www.cndba.cn/hbhe0316/article/108013http://www.cndba.cn/hbhe0316/article/108013

CREATE TABLE EXPLAIN_STATEMENT ( EXPLAIN_REQUESTER VARCHAR(128 OCTETS) NOT NULL, EXPLAIN_TIME      TIMESTAMP    NOT NULL, SOURCE_NAME       VARCHAR(128 OCTETS) NOT NULL, SOURCE_SCHEMA     VARCHAR(128 OCTETS) NOT NULL, SOURCE_VERSION    VARCHAR(64 OCTETS)  NOT NULL, EXPLAIN_LEVEL     CHAR(1 OCTETS)      NOT NULL, STMTNO            INTEGER      NOT NULL, SECTNO            INTEGER      NOT NULL, QUERYNO           INTEGER      NOT NULL, QUERYTAG          CHAR(20 OCTETS)     NOT NULL, STATEMENT_TYPE    CHAR(2 OCTETS)      NOT NULL, UPDATABLE         CHAR(1 OCTETS)      NOT NULL, DELETABLE         CHAR(1 OCTETS)      NOT NULL, TOTAL_COST        DOUBLE       NOT NULL, STATEMENT_TEXT    CLOB(2M OCTETS)     NOT NULL NOT LOGGED, SNAPSHOT          BLOB(10M)    NOT LOGGED, QUERY_DEGREE      INTEGER      NOT NULL, PRIMARY KEY (EXPLAIN_REQUESTER, EXPLAIN_TIME, SOURCE_NAME, SOURCE_SCHEMA, SOURCE_VERSION, EXPLAIN_LEVEL, STMTNO, SECTNO), FOREIGN KEY (EXPLAIN_REQUESTER, EXPLAIN_TIME, SOURCE_NAME, SOURCE_SCHEMA, SOURCE_VERSION) REFERENCES EXPLAIN_INSTANCE ON DELETE CASCADE) ORGANIZE BY ROW
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL20054N  The operation was not performed because the table is in an invalid
state for the operation. Table name: "lob options prohibited with
blocknonlogged enabled". Reason code: "".  SQLSTATE=55019

原因为DB2 HADR模式开启了blocknonlogged=yeshttp://www.cndba.cn/hbhe0316/article/108013

需要调用存储过程创建这些系统表http://www.cndba.cn/hbhe0316/article/108013http://www.cndba.cn/hbhe0316/article/108013http://www.cndba.cn/hbhe0316/article/108013http://www.cndba.cn/hbhe0316/article/108013

db2 connect to dbname
db2 "CALL SYSPROC.SYSINSTALLOBJECTS('EXPLAIN','C',NULL,CURRENT SCHEMA)"

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2