DB2 不常用SQL语句集合

DB2 不常用SQL语句集合

1. reanme table dwmd1.Hope_Fact to Hope_Fact_20100101
2. db2 catalog tcpip node DB2PODS remote hostname server 50020
    db2 catalog db ODS as ODSP at node DB2PODS
    db2 terminate
3. refresh table MQTSCH.SALES_PROD (MQT)
4. reorg table dwdm1.crm_hope_dimnsn
5. runstats on table dwdm1.crm_hope_dimnsn with distribution on key columns and indexes all
6. truncate table DWDM2.HOPE_STAT_ALL IMMEDIATE;
7. alter table DWDM1.HOPE_DIMNSN  activate not logged initially with empty table



=========华丽分割线================



posted @ 2016-06-14 11:22  yuerspring  阅读(133)  评论(0)  编辑  收藏  举报