存储过程的语句一般都存在syscat.statements中。可以通过package name 和sectno 找到对应的SQL语句， db2pd -d <dbname> -static会显示包的信息和详细的每个section的引用情况。一般的，每执行一次，numref会增加一次。比如某个package 有3个section，call sp之前num...(more)

One of my system does not have basical diagnostic utilities installed  such as mpstat,sar, iostat. Here is what I had done:  # yum install sysstatLoaded plugins: fastestmirrorRepository base is listed more than once in the configurationRepo...(more)

最近回了客戶的問題: 在framework中第1次publish package時, 會設定function set 也就是你的package要包含哪些vendor的function 預設是全部包含, 都在右邊窗格 不過有可能會看錯, 以為要選到左邊窗格, 而無法使用正確vendor的db function 或者是有新增不同vendor的datab...(more)

CATALOG DB ON MVS ############# db2 catalog tcpip node stf1q remote stfmvs1q.pok.ibm.com server 5010 ostype os390db2 catalog dcs database adw as USIBMVRDP2Hdb2 catalog database adw at node stf1q authentication server_encryptdb2 connect to adw user co...(more)