![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
db2
土豆大人
这个作者很懒,什么都没留下…
展开
-
DB2执行计划 db2 explan
explain1.如果第一次执行,请先(在dbinst用户下) connect to dbname,执行db2 -tvf $HOME/sqllib/misc/EXPLAIN.DDL建立执行计划表2.db2 set current explain mode explain(在数据库所在用户下)设置成解释模式,并不真正执行下面将发出的sql命令3.执行你想要分析的sql语句......db2 "SELECT DISTINCT RTRIM(MARKET_CODE),RTRIM(CURRENCY_T转载 2020-12-07 18:56:18 · 4695 阅读 · 0 评论 -
operating system permissions. SQLSTATE=08001
今天给一个安装了db2的虚拟机加了内存,结果启动后就连不上,报如下错误SQL1639N The database server was unable to perform authentication becausesecurity-related database manager files on the server do not have the requiredoperati...原创 2019-05-21 11:30:03 · 448 阅读 · 0 评论