• 查看数据库状态：db2 connect to username
  • 查看所有数据库：db2 list database directory
  • 创建数据库：db2 create database dbname
  • 连接到数据库：db2 connect to dbname
  • 查看表结构：db2 describe table tablename
  • 查看表数据：db2 select * from tablename
  • 插入数据：db2 insert into tablename (column1, column2, ...) values (value1, value2, ...)
  • 更新数据：db2 update tablename set column1 = value1, column2 = value2, ... where condition
  • 删除数据：db2 delete from tablename where condition
  • 创建表：db2 create table tablename (column1 datatype, column2 datatype, ...)
  • 删除表：db2 drop table tablename