db2 常用sql(后续不断更新......)

1、查看数据库是否处在恢复状态

db2 list utilities show detail      

2、用空文件快速清表

load from 123456.ixf of del replace into dhzx_ods.LOAN_TRANSACTION_DETAIL nonrecoverable 

3、启用归档日志`

db2 update db cfg for dhcczx using LOGRETAIN ON