随笔分类 -  db2

摘要:1、查看当前容器的分布,并确定如何调整 db2look -d sample -l -cor -dp -o dd.sql 2、给表空间添加容器 db2 "alter tablespace tbname add (FILE '/data/db2inst1/NODE000/TEST/TEST_01' 1G 阅读全文
posted @ 2016-10-31 14:47 hufangrui 阅读(4903) 评论(1) 推荐(0)
摘要:一、导入导出 ixf: db2 export to /tmp/xxx.csv of ixf lobs to . xml to . modified by codepage=1208 "select * from sysibm.dual" db2 import from tablename of ix 阅读全文
posted @ 2016-10-31 14:40 hufangrui 阅读(1354) 评论(0) 推荐(0)
摘要:1、将常用命令,设置为别名,方便记忆 alias listapp='db2 list applications' alias listappx='db2 list applications show detail' alias listtran='db2 list INDOUBT TRANSACTI 阅读全文
posted @ 2016-10-27 09:48 hufangrui 阅读(562) 评论(0) 推荐(0)