在設計資料庫的schema時，若針對Primary Key有設定Generated Identity屬性，在load資料時，會出現無法匯入的訊息，此時可以在LOAD command中加上 modified by identityoverride 選項，如此一來，就會把 source table的identity column的值直接覆蓋到target table的identity column。範例指令如下
db2 load from load.del of del modified by identityoverride
replace into table1
進階資訊(其它Import/Export/Load會用到的modifier，以及Import/Export/Load對這些modifier的支援)
http://www.ibm.com/developerworks/data/library/techarticle/dm-0405melnyk/index.html
執行db2指令時，系統回報這個錯誤 Error in the db2nodes.cfg file at line number "1". Reason code "10"，經過google搜尋後，發現是因為該系統是由其它系統image複製過來，因此sqllib/db2nodes.cfg的hostname設定與目前機器的hostname不符。以下紀錄解決方法
db2nodes.cfg記錄了每個DB2 partition的資訊，其內容格式如下
nodenum hostname logical port netname resourcesetname
其中nodenum, hostname及logical port為必要的三個欄位。依據(http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/start/r0006351.htm)的說明，nodenum為介於 0 及 999 之間的專用號碼，可識別分割資料庫系統中的資料庫分割區伺服器；hostname為資料庫伺服器所在的Hostname；logical port為資料分割伺服器的邏輯埠號。以下為不同的配置範例
0 ServerA 0
1 ServerA 1
2 ServerA 2
3 ServerA 3
0 ServerA 0
1 ServerB 0
4 ServerA 0
6 ServerA 1
8 ServerA 2
9 ServerB 0
0 ServerA 0 switch1
1 ServerB 0 switch2
2 ServerB 1 switch2
設定完成後，執行db2stop/db2start即可。詳細說明可看(http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/start/r0006351.htm)
#For Windows
DB2 windows版本的db2nodes.cfg在 DB2 v8及v9.1，是放在Program Files\IBM\SQLLIB\DB2\db2nodes.cfg中；而在9.5及以上，是放在Documents and Settings\All Users\Application Data\IBM\DB2\<DB2COPY>\DB2\db2nodes.cfg中。手冊建議不要直接修改檔案內容，可透過下列指令達到修改hostname目的
上述指令可以修改 node的 hostName，其中，在沒有partition的環境下，nodeNumber為0。
詳細db2nchg指令用法在此。另外，可以用db2nlist最出目前資料庫有那些nodes
本文介紹如何透過操作Data Architect的Model，來延伸其Model的屬性以及功能
出處：http://www.ibm.com/developerworks/data/library/techarticle/dm-0807liu/index.html
Wei Liu (liuw@us.ibm.com), Software Engineer, IBM
Summary: IBM® InfoSphere® Data Architect (IDA) (formerly Rational® Data Architect) is gaining momentum as a comprehensive tool that helps organizations promote a thorough understanding of their enterprise information architecture. As more people use IDA, there's an increasing need for some customers to extend IDA to meet their unique data modeling and integration requirements. This two-part series shows you how to extend IDA's models, properties view, model reports and validation rules. In Part 1, learn how to programmatically traverse and modify IDA models and how to add and display custom properties. [IDA Version 7.5 has adapted Data Tools Project (DTP) to replace Web Tools Project (WTP). Because IDA uses the SQL model defined in DTP as the basis of its metamodels, the section Programmatically traverse and modify RDA logical data model and physical data model, as well as the sample code provided with the article, were updated.--Ed.]
View more content in this series
Tags for this article: data_access, infosphere_data_architect, integrating_products,integration
本篇介紹如何使用Rational Data Architect來檢視、註解現有之data source，並且建立Mapping model來比較這些data source的差異，並且使用工具，自動產生可套用到WebSphere Information Integerator的程式
引用來源: http://www.ibm.com/developerworks/library/ar-rdaint/#resources
A five-step process for success
Davor Gornik (dgornik@us.ibm.com), Product Manager, IBM
Summary: No doubt about it -- information integration is challenging. Many business decisions must be documented and many transformations must be performed. IBM Rational® Data Architect can document your decisions and automate part of this process. Read this article to explore a tool-supported process for federation design in just five steps.
