每天一条DB2命令-036
每天一条DB2命令-036
#检查数据库的表状态(输出结果为0正常)
db2 "select substr(tabschema,1,10) as tabschema,substr(tabname,1,30) as tabname,available from sysibmadm.admintabinfo where available!='Y'"
自然语言处理爱好者,欢迎交流。QQ: 7214218
每天一条DB2命令-036
#检查数据库的表状态(输出结果为0正常)
db2 "select substr(tabschema,1,10) as tabschema,substr(tabname,1,30) as tabname,available from sysibmadm.admintabinfo where available!='Y'"