摘要： 备份数据库：离线备份1、连接至数据库： db2 connect to test user db2admin using db2admin2、显示数据库应用状态db2 list applications3、停止数据库应用db2 force applications all4、备份数据库db2 backup db test to d:\backup备份路径必须存在5、查看备份历史记录db2 list history backup all for test在线备份1、设置userexit、logretain参数的状态为ondb2 update db cfg for test using userex 阅读全文

摘要： 生成列：CREATE TABLE t1 (c1 INT, c2 DOUBLE, c3 DOUBLE GENERATED ALWAYS AS (c1 + c2) c4 GENERATED ALWAYS AS (CASE WHEN c1 > c2 THEN 1 ELSE NULL END))定义标识列：CREATE TABLE table (col1 INT, col2 DOUBLE, col3 INT NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 100, INCREMENT BY 5) )not logged initially特性:如 阅读全文