ohasd failed to start: Inappropriate ioctl for device,ohasdinappropriate 今天同事在安裝GI的時候出現問題,讓我幫忙看一下。下面記錄如下:問題現象:在安裝gi的時候執行root.sh報如下錯誤;Finished running generic part of root.sh script.Now product-specific root actions will be performed.2014-11-18
GRANT 授權,grant授權sys(管理員)身份登入,建立使用者名稱zsta_newcreate user zsta_new identified by 密碼 default tablespace ZSTA_DATA_TBS temporary tablespace TEMP profile DEFAULT;給zsta_new使用者授權(允許建立預存程序等):grant connect to zsta_new;grant resource
On the development of a new generation of large data distributed relational database initiative,relationalOn the development of a new generation of large data distributed relational database initiative
類似group by的分組計數功能,groupby分組計數之前同事發過一個語句,實現的功能比較簡單,類似group by的分組計數功能,因為where條件有like,又無法用group by來實現。SELECT a.N0,b.N1,c.N2,d.N3,e.N4,f.N5,g.N6,h.N7,i.N8,j.N9 from (select count(*) N0 from tbl_loginfo_20141110 where keyrecord like '0%' or
DB2 “The transaction log for the database is full” 問題及解決辦法,db2transactionDB2在執行一個大的insert/update操作的時候報“The transaction log for the database is full.. ”錯誤,查了一下文檔是DB2的記錄檔滿了的緣故。首先運行下面命令來查看DB2的日誌配置資訊$ db2 get db cfg | grep LOG注意其中的下面配置項Log file size