db2小用

db2真是不好用(8.0.?)

難道升級版會好一些？無語

1>update超級慢....(這點還不如Access,175萬記錄)

2>execute immediate 不支持基本的export 和output(貌似也沒有在Oracle裡面測試過這個功能)

打升級補丁後可以

3>周邊工具少,安裝繁瑣.

4> inner join 的update不支持

5>connect to db  不需要密碼,多個庫公用一個密碼..

為什麼做事情不可以變通一些呢？又是規矩作祟，呵呵。

----------------------------------錯誤總結:---------------------------------------------------------------------------------

jdbc遠程連接失敗...

連接代碼

public static void main(String[] args) throws ClassNotFoundException, SQLException {
  // TODO Auto-generated method stub
  Class.forName("com.ibm.db2.jcc.DB2Driver");

  // connect
  Connection db2Conn =DriverManager.getConnection(
  "jdbc:db2://***.***.***.***:50001/dbname",
  "instname",
  "passwd");
 
  Statement st = db2Conn.createStatement();
  String queryStr ="SELECT a.id FROM tabletest a order BY a.ID";
  ResultSet resultSet = st.executeQuery(queryStr);
  while (resultSet.next())
  {
        string id = resultSet.getString( "ID" );
        System.out.println( id );
  }
  resultSet.close();
  st.close();
  db2Conn.close();  
 }

---------------------------------------search 結果---------------------------------------------------------------

Try this. This works if passWord is expired by OS.
connect to sample user db2inst1 using xxxx new xxxxx confirm xxxxxx

db2 grant connect, createtab, bindadd on database to user celiacy

This is known problem when using DB2 8.2 and AIX5.3
(don''t know if already fixed in newer fix packs)
If you use this db2set setting and restart the instance the problem is
"solved":
db2set DB2_NUM_CKPW_DAEMONS=0

---------------------------------------------more---------------------------------------------------------------------------------