-
Ajo Robert authored
COMMITTING ONGOING TRANSACTION Analysis -------- TABLESPACE DDL operations do not implicitly commit active transaction leaving them alive after DDL completion. CF_AUTO_COMMIT_TRANS flag enables implicit commit of active transaction at the beginning of new SQL command execution. All tablespace DDL operations in SQL engine are mapped to SQLCOM_ALTER_TABLESPACE command. CF_AUTO_COMMIT_TRANS flag is not set for SQLCOM_ALTER_TABLESPACE causing the issue. Fix: --- CF_AUTO_COMMIT_TRANS flag is set for SQLCOM_ALTER_TABLESPACE command.
Ajo Robert authoredCOMMITTING ONGOING TRANSACTION Analysis -------- TABLESPACE DDL operations do not implicitly commit active transaction leaving them alive after DDL completion. CF_AUTO_COMMIT_TRANS flag enables implicit commit of active transaction at the beginning of new SQL command execution. All tablespace DDL operations in SQL engine are mapped to SQLCOM_ALTER_TABLESPACE command. CF_AUTO_COMMIT_TRANS flag is not set for SQLCOM_ALTER_TABLESPACE causing the issue. Fix: --- CF_AUTO_COMMIT_TRANS flag is set for SQLCOM_ALTER_TABLESPACE command.
Loading