dch1287的专栏

[code="java"] shell> mysql --user=root mysql mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost IDENTIFIED BY 'something' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO monty...

查找 TCP/IP Service Name [code]db2 get dbm cfg | grep SVCENAME[/code] 得到输出 [code]TCP/IP Service name (SVCENAME) = db2_dch[/code] 在/etc/services文件中找对应的端口号 [code]grep db2...

【简介】 本文主要用于定位系统中导致锁等待或者死锁的原因. 【详细信息】 1. 首先要打开DBMS监控开关和快照开关： db2 update dbm cfg using DFT_MON_LOCK on DFT_MON_STMT on db2 update monitor switches using lock on buffpool on sort on uow on t...