db2 基础操作

---清空cls
----查看数据版本
select * from sysibm.sysversions
---重启数据
Restart db  twcs177
---激活数据库 
Activate db twcs177
---停止数据库
Deactivate db twcs177
---数据库链接名
db2 catalog tcpip mode mynode remote 10.2.2.177 server 62000
---链接数据库
connect to twcs177  user tsisusr  using  tsisusr


---导入csv数据
import from D:\DB2\tg_debtcash_detail.csv of del insert into tg_debtcash_detail
import from D:\TG_DEBT_TRADE.del of del insert into TG_DEBT_TRADE;
---导入del数据
export to D:\TD_ENUMVALUE.del  of del select * from TD_ENUMVALUE where  S_TYpecode ='TW0086'
---查询表10条数据
select * from tg_debtissue_detail where 1=1 fetch first 10 rows only with ur
----查看表空间
List tablespaces show  detail;
----查看表空间使用情况
select * from sysibm.systablespaces
---查看表所属表空间
select TABNAME,tbspace from syscat.tables where TABNAME='TA_LOCALCASH_INFO';
---查看表空间的表
select TABNAME from syscat.tables where tBSPACE='USERSPACE1';
select * from sysibm.systablespaces
CREATE TABLESPACE TS_LMC_DAT 32K IM DATABASE PARTITION GROUP IBMDEFAULT TGROUP PAGESIZ 32K
using(file'D:\DB2\NODE0000\LMCDB\TS_LMC_DAT32K_01' 8192--256M) EXTENTSIZE16 PREFETCHSIZE 16 BUFFERPOOL BP32K
---创建表时指定表空间
create table_xxx(col1.....) in  USERSPACE1
---查看表索引
describe indexes for table TA_TRL_GO_COMEBILL show detail
---查看表字段状况
select * from sysibm.syscolumns where TBNAME='TA_LOCALCASH_INFO';
---查看表结构
describe table  TA_LOCALCASH_INFO
---清除一个大表、
alter TA_LOCALCASH_INFO activate not logged initally with empty table  or 
import from null_file of del into TA_LOCALCASH_INFO
---重命名数据表
rename old_table_name to new_table_name
---查看BUFFER情况
select * from sysibm.sysbufferpools
---修改缓冲池大小
alter bufferpool ibmdefaultbp size 10240