ÎêÆÛÎÃãôËçâú 8.1 Îê FixPak 6 ËðÆîȺæñعů̧ÅÅßÎÎûܨÐÂÄæЩ¡¢îùÇ¿ïåûôÎÃãôËçâúĶÎûÄ¡×ïæñع¡¤ ÆÛÅÆǵÉÖÈ´ IBM ÎûÍÔÈ´ûâæñع¡¤ÆÆÑÒËíðãÝÔüÕËðÆîûâÇÑãôÕóÈÔßÈËòÎû¡¢Ëä̯̿áá É¢ûâÎÎÎûÏñû¬¡¤ÆÛÕóÄãÎûæñعÄâÅýÑÄǶÈôܨÐÂÏñøý¡¢Åâ̧ÝóÓÝľÄâڵͷÈúæØúË¡¤ ÚÀÆ«ÅèîÀĸÓÔõÕ IBM ÅøÎêС¢ÍÐÝàç´åµÇâÎû IBM äÆÙ­ÅîÏÐËôÓÔõÕ¡¤ * Ó¼ÓÑîÀĸÓÔõÕÅøÎêС¢îùÝßݾÈíÍõ www.ibm.com/shop/publications/order Îû¡ÖIBM ÅøÎêÐÂÄãÅÀ (IBM Publications Center)¡×¡¤ * Ó¼ÓÑÞòÊÆÚÀåµÇâÎû IBM äÆÙ­ÅîÏС¢îùÝßݾÈíÍõ www.ibm.com/planetwide Îû ¡ÖIBM ÇÀÛþôúá¾×»ÇØòç (IBM Directory of Worldwide Contacts)¡×¡¤ Ó¼ÓÑÚ·Ó¡ÙÏÍÐÅûÕÕÄËÎû¡ÖDB2 ÆËÞÛïÚÙÇ (DB2 Marketing and Sales)¡×ÄãÓÔõÕ DB2 ÅøÎêС¢îùçÙÒ¥¡¨1-800-IBM-4YOU (426-4968)¡¤ åµÚÀã®ØÊæñعῠIBM Õë¡¢ÚÀÉ»ÚæûâÄè IBM Åȩ̀ë¥Ò³ïËåµÎûÅÉÈ¢ËôËðÆîÍÐÅ¡ØÊæñ ع¡¢ÈÔÄâÆÒè×ÚÀÓ×ØÄǶÈôÝÊǶ¡¤ Copyright International Business Machines Corporation 2002 - 2004. All rights reserved. Æøòç ùÃÍõÎêÆÛÎÃãôËçâú ùÃÍõÆÛÎêȹ ÆÛÎêȹä»ìÁÎûÅü×ä åµÐúÇ¡ä»Îû Unicode æñÕèÕ»ÕëÅÅßÎ̧Åìè×äùâûÊ© ܨÐÂÔºÆßñ¥á£ ÷®ÎêÒÞÕ©ÍÌ ßåÅî FixPaks (Linux ů UNIX) ¡ÖæñÕèÔ¿óÃÄãÅÀ¡×ǿЩÎûÈùΤðÂÅÅßÎÓî̱ ÄâÅÅßÎ Visual Warehouse 5.2 DB2 á£È¢¡ÖVW 5.2 ç¥Ä«×ÅÅÆÇóóò̯ DB2 UDB EEE (ã¯Óî AIX)¡× DB2 Universal Database ÜÉ 7 ÎêÈùΤðÂÇô̽ Çã DB2 UDB for OS/390 ÜÉ 6 Îêů DB2 UDB for z/OS ÜÉ 7 Îêĸ¡¢SQLJ ů SQL ëºÉ·á£È¢ÅÅßÎëæÓÑâäàõÄãÅÀ APAR ¡ÖÌÔÅïÄãÅÀ¡×ůÜÉ 7 ÎêÈùΤð ڷ DB2 UDB ÚöÙ¯¡ÖSQL ëºÉ·á£È¢¡×ÎûÌ¥Ô¶ÎêÆÛ üÈÊÕ Unicode ÈùΤðÂÈçÒ³ Classic Connect àÒÎÎËðÆî ܨÐÂÒÞÕ©ÍÌ IBM DB2 Development Add-In for Microsoft Visual Studio .NET WebSphere Application Server ÙÚÈç SQLJ á£È¢ÄãÎû SQL ÝóÓÝÈ¢ Microsoft Visual Studio Visual C++ 64 ÈíÄ÷É¢äÆË·ÜÓĸÍÔëæÓÑÎû Microsoft XP ÔºÆßá£È¢ Windows 64 ÈíÄ÷É¢äÆË·ÜÓĸÎû CLI ů ODBC Ì¿ÅÅßÎÎû LDAP ÆîÅÂê¦Å¯ÈùΤðÂØÙåô Windows XP É¢äÆË·ÜÓ î¾î£ÇóâõøüÉ±î£ (CCSID) 5039 ÎûßåÅî Unicode ÷ËßÐÏÐ Ùòî¾î£Çóâõ (CCSID) 5039 Îû Unicode ÷ËßÐÏÐßÐÈ© Microsoft ÷ËßÐÏÐ î¾î£ÇóâõøüÉ±î£ (CCSID) 954 ÎûßåÅî Unicode ÷ËßÐÏÐ Ùòî¾î£Çóâõ (CCSID) 954 Îû Unicode ÷ËßÐÏÐßÐÈ© Microsoft ÷ËßÐÏÐ ÄâÅÅßÎ MVS É¢äÆË·ÜÓ DB2 UDB for AIX 4.3.3¡£5.1 ůÅèĸÎêÆÛëæÓÑ AIX C++ ÜÉ 6 Îê Runtime Çô̽ Java ÇÁÆîóòÕùÕ» (Linux) ެǹůߦåô (Linux 390) ERwin 4.x ÄãâææñÕèðýÚÙð Åè Hummingbird Exceed Çô̽¡ÖâäàõÄãÅÀ¡×ÕëÚöÆîóôáþàëÓòØôï÷ ÇøæÒ¡£ÜÃ÷Ë¡£Åª×ÈůØÙåôæñع ÇøæÒæñع ÇøæÒ DB2 UDB (AIX) ÇøæÒ DB2 UDB (Linux) ÇøæÒ̧ÅìËéÑúÇóÐÎ (Linux) ËðÆî db2setup ÌÔÅïä»ìÁܨÐÂÎûÓî̱ Ķç¥ËäæØóÌôã Spatial Extender FixPak ÇãÔïÆî fixpak ÄæÑ¥ÝÙḠQuery Patroller æñÕèÅý Çã FixPak 3 ìÒȹÍÐÊÕä»ìÒȹÄãÇøæÒ Query Patroller DB2 Web ÄÖ̦ Ò³ÇøæÒßæâæÄâÑÒòÙâúÎûë£ËÆÇøæÒ DB2 æñعÄãÅÀ DB2 Universal Database ÜÉ 8 Îê HTML ÅÆǵÇøæÒÓî̱ (Windows) Ò³ÙÏÕ¥ë£ËÆÎêÆÛÎû DB2 UDB ÇøæÒ MDAC óòÕù ÜÃ÷Ëæñع ËðÆî DataJoiner ÍÐʽìÑÕëÎû DB2 Universal Database ÜÃ÷Ë Ùò DB2 ÜÉ 8 Îê Windows 32 ÈíÄ÷æñÕèÕ»ÜÃ÷ËÈÝ Windows 64 ÈíÄ÷ Ú·÷®ÎêÜÃ÷Ë XML Extender æñÕèÕ»ÜÃ÷Ë (HP-UX on IA64) ÄØÏ¡Óî̱¡£ÙÂ÷î¡¢Åèůí²ÈçæØÊîÅÉÎÎ Óî̱ ¡ÖâäàõÄãÅÀ¡×è× 64 ÈíÄ÷É¢äÆË·ÜÓÎûÓî̱ âäàõÄãÅÀ (Linux) Øæòã̦ȴ÷äÅ¿æÀÎûóÃÇôá£Ê© üé Java ڦȢƫÇã¡ÖâäàõÄãÅÀ¡×î¾úÁÍÔëæÎûæûÕÀÝÃÌù ÇÑÕëÙÚÈçůØæòã Java óÃÇôá£Ê©Îû¡ÖâäàõÄãÅÀ¡×Óî̱ Çã DB2 UDB for z/OS ÍÐ OS/390 ÈùΤðÂĸËðÆî LOB ÌùÈíð ÇãÝÙÚÙßæâæÞÞÉËÈ©ÅüàôÄ«ÕëÆÂÚõ (AIX) JDBC ûÄÙ¯á£È¢Óî̱ (HP-UX) ÜÉ 8 ÎêÄãÎû SNA ÅÅßÎÓî̱ ÄâÅÅßÎÐúÇ¡ÄÖ̦ÐÎòçæñÕèÕ» (Linux AMD64) ÄâÅÅßÎÐúÇ¡ÄÖ̦ÐÎòçæñÕèÕ» (AIX¡£Solaris É¢äÆô¿èºÅ¯ HP-UX) Workgroup Server Edition 64 ÈíÄ÷ÈùΤðÂèÒËóÓî̱ ÏæÇÑÊãÙÚÈç CLI Å¡Þ´æñÕèջĸÎû NUM_LOG_SPAN ØÙåôÙ¶í° ÇãÇéÔ¶ÔºÆßÔïǵô¿èºÄã dasdrop ÌÔÅïÎûÓî̱ ¡ÖæñÕèÔ¿óÃÄãÅÀ¡×ÄâïËÆîÍõöüüÕÄãÅÆ ë¿ê¦ÎìǵÎûÅÊÅÆÇØê¢ ¡ÖÛÒØææñÕè¡×÷ËßÐá£È¢ÎûÓî̱ ËðÆîÔ¿óÃÅîܡ׻ʽìÑůÇô̽ Client Connect Ô¿óÃËôäã ÚêÌùÊäçÒÄ¡ÑôÕëâæÙÚÈçÔ¿óÃݨܡá£Ê© ã¾Ä«Å¯ã¾ÅøÎû¡ÖæñÕèÔ¿óÃÄãÅÀ¡×Óî̱ ÇãÇøæÒ 8.1.2 ÎêÍÐÊÕä»ÎêÆÛÄæÑ¥ÇøæÒÔ¿óÃÚÕ̱æñÕèÕ» Cube Views î¯ËóóÜÆîá£È¢êØî¯ËóËôäãÄâÇÑ ¡Öç¥Ä«¡×ÌÏ¡Öã¾Ä«Îþúñ¡×Ó÷ÄâÅÅßÎ IXF óòÄãÎû DBCS ÇóÄ÷ ç¥Ä«É¢äÆÆÂÚõÕëá¿êØħÄâÆßíýÎû¡ÖÉ¢äÆÄãÅÀ¡×ÑÀÆüÜÊ GUI ÄÖ̦ÎûÞ²ÄÑàëÓòÝÃÌùÔ« îùÄâÓÑÅ¡Þ´¡ÖæñعÐÎòçÄãÅÀ¡×ÏÐÖª ØôÆî DYN_QUERY_MGMT ÕëÎû Query Patroller Óî̱ Ü¢Çã Query Patroller á¸ÎªÏÐÖªËðÆî DB2QPRT ê¾Æø ÄâÅÅßÎ ALTER WRAPPER SQL ÝóÓÝÈ¢ ØúÚªÑÀÆüÜÊÓî̱ Ë·ÜÓéñåÆá£È¢ Snapshot UDF Óî̱ ÄØÏ¡ÙÂ÷îůí²ÈçæØÊîÅÉÎÎ DB2 Universal Database Workgroup Server Edition Îû DB2 ÚæûâÔÏЬ Linux (x86¡£32 ÈíÄ÷) ĸëæÈ´ IBM Developer Kit for Java 1.3.1 öüüÕÄãÅÆë£ËÆô¿èº (AIX) öüüÕÄãÅÆë£ËÆô¿èº (Red Hat Linux) Merant Driver Manager ÄâÒÞÕ©ÍÌ (UNIX) ËðÆî Tivoli Storage Manager ÏñÇôÈùΤð (AIX¡£Solairs É¢äÆô¿èº) ެǹ Data Links ÈùΤðÂÆÂÚõ SQLFLAG(STD) Щåôî¾úÁðÂòÙâúòãë¨ SQL ڦȢî¾úÁÌÔÅïÎû DB2 UDB æûÕÀ (Windows) ØæÏæÇøæÒħÍÔÈ´ÅÆǵê¡ùË¡¢ÉÁЬÅÆǵä²ÞòÆ«×ääÄÆÂÚõ (AIX) ËðÆî Java 2 JRE1.4.0 ÍÔç²Ì¯ÎûÅÆǵä²ÞòÙÂ÷î Íõ DB2 GUI ÄÖ̦ÄãüÏÆü Indic ÇóÄ÷ zSeries ÈùΤðÂÄâÅÅßÎ GUI ÄÖ̦ (Linux) ã¾Ä«íºÆüë£ËÆóòÕùÕëÆÜܨÆí¡ÖæñعÐÎòçÄãÅÀ¡×ÅÊë¢óò ÝÙḠQuery Patroller æñÕèÅý ÇøÇÀô¿èº (Windows) XML Extender î¯Ëóá£È¢ÄØÊÕÇØ Çã XML Extender Ä㡢šæØÅýÉÖÏæÙÄÄ¡úèÍÌůÄ÷×ÃÇØê¢ÎûÄ÷ǵ ËðÆî DB2 Connect Õë¡¢SNA ů TCP/IP È´Èôոܬ ÅÆǵÊÕä» ê§Ü¡¡¨Õæ×äîþðì DB2_ENABLE_BUFPD àôòçüÈí°ÎûçßÝÃÔ« óÜÆîá£È¢âäàõ¡¨ÌËƵìÒȹÄõÓò (CLI) MapDateDescribe CLI/ODBC ØÙåôùÃõïÇó MapTimeDescribe CLI/ODBC ØÙåôùÃõïÇó MapTimestampDescribe CLI/ODBC ØÙåôùÃõïÇó ÌÔÅïÙ¶äù db2inidb - ØÄÌîÝÃÌùùµÑÐÎûæñÕèÕ»ÌÔÅï æñÕèÔ¿óÃÄãÅÀ Business Intelligence ÚôðÐÑÀðÒÎûÊÕä» ÝÃÌùÔ¿óÃÅÊë¢óòÎûÛÒØæÓî̱ CURSOR ç¥Ä«Îû¡ÖæñÕèÔ¿óÃÄãÅÀ¡×ÅÅßÎ GUI ÄÖ̦ ¡ÖÚÕ̱ÄãÅÀ¡×ÆÀÚâá£È¢ÅÅßΠعÕÉÙ¶äù 8.1.4 Îê¡ÖæñعÄãÅÀ¡×عÕÉÅä÷î ADM عÕÉÊÕä» ä»ìÁ SQL عÕÉ DBI عÕÉÊÕä» Query Patroller ÇãÙÚÈç¡ÖQuery Patroller ñ¥á£æñÕèܨÆíð¡×ÄæЩÐúÇ¡¡ÖæØúÁ¡×ÏÐÖª óôÑçñ¥á£Å¡ÎµÎû Query Patroller ÅÊë¢óò Ù¯èèÑçææùËɱÊÕä» Ú¥ÎíÑçææÈçÒ³ ܬڦùÃÝð¡Öñ¥á£æñÕèܨÆíðÂ¡× Ñº SQL ÝóÓÝÈ¢ùËÐÎÎûÓî̱ Ë·ÜÓéñåÆá£È¢ SYSMON_GROUP database æñÕèÕ»ê§Ü¡á£È¢ØÙåôÙ¶í°åôßÐ DB2_SNAPSHOT_NOAUTH àôòçüÈí° SQL Reference SQL Óî̱ XML Extender ÄØØæƪ XMLVARCHAR UDT ÄËÄÑÓî̱ ä»Îûô¿èºüÈí°¡¨DB2DXX_MIN_TMPFILE_SIZE ÏáòçA. DB2 UDB FixPak CD Æøòçá¸é¬ ÏáòçB. Ò¥ææ IBM B.1 ܨÐÂæñع ÏáòçC. ÎÃãôËçâú C.1 Ù¸íº ùÃÍõÎêÆÛÎÃãôËçâú ÄùÕ© ȺÎêÆÛÎÃãôËçâúÅýÉÖĶÇÄ DB2(R) ÜÉ 8 ÎêܨÐÂÎûÞ²ä»æñع¡¨ DB2 Universal Database(TM) Personal Edition DB2 Universal Database Workgroup Server Edition DB2 Universal Database Workgroup Server Unlimited Edition DB2 Universal Database Enterprise Server Edition DB2 Personal Developer's Edition DB2 Universal Developer's Edition DB2 Warehouse Manager DB2 Warehouse Manager Sourcing Agent for z/OS(TM) DB2 Data Links Manager DB2 Net Search Extender DB2 Spatial Extender DB2 Intelligent Miner(TM) Scoring DB2 Intelligent Miner Modeling DB2 Intelligent Miner Visualization DB2 Connect(TM) Application Server Edition DB2 Connect Enterprise Edition DB2 Connect Personal Edition DB2 Connect Unlimited EditionDB2 Query Patroller ÎêÆÛæñع Þ²ä»ÎûÅÆǵƫÇãÞ²ä»ÎêÎû¡ÖDB2 æñعÄãÅÀ¡×Äã̽ڵ (Ýàç´ößûªðÂÇô̽)¡¤ÈíÍõÆÛåç ÄæÑ¥Îû¡Ö̧Åìæñäã¡×Ä¡åçÄãßÈËòȴĶç¥Þ²ä»ÅÆǵÎû URL¡¤ ¡ÖDB2 æñعÄãÅÀ¡×ÅÆǵÄãÎûÔºÓÔíºØ´ÏÐÆüÈÜÚ· 8.1 ÎêÎû PDF æñعÅøÎêÄæÑ¥ÄØä» ìÁÍÐüÈÊÕÎûÅÆÇó¡¤ÐÍÎþîÀ (|) ÏÐÆü 8.1 ÎêÞ²ÏÏàõÈçÕëÍÔä»ìÁÎûæñع¡¤í°ÇóÑÀÆüÜÊ (ÅÒÇñ 1 ÍÐ 2) ÏÐÆüÑÒá¸Ê¢Ò³ÒÞÇÑí°ÇóÎû FixPak ÍÐìÒȹÍÔä»ìÁÎûæñع¡¤ËóÇñ¡¢1 ÑÀÅø FixPak 1 ÄãÍÔä»ìÁÍÐüÈÊÕÎûæñع¡¢2 ÑÀÅøØÜè× 8.1.2 ÎêÍÔüÈÊÕÎûæñع¡¤ ÆøòçæûÕÀ Windows ÐÎË·ÜÓËðÆîÅ°ÚûîÀ (\) ËôÙ´çÒÆøòçæûÕÀÄãÎûÆøò硤 UNIX ů Linux ÐÎ Ë·ÜÓЬËðÆîÆßÚûîÀ (/) É¢Ò³Ù´çÒÇóÄ÷¡¤åµæñعÑÒÆÍƺÖÖÈ´ÎûÕëÔ·¡¢¡ÖÎêÆÛÎÃãôËç âú¡×äÄò×ߧÝÕÔ¶èëËó¡¤àÓÈÔ¡¢åµæñعêØÆÍƺàÒùÃÕë¡¢ÚÀÆ«×äëæÓÑÅèÄâÇÑÍõüÏÆüÎû ÅÉÈ¢ËôòÓÄ«ÆøòçæûÕÀ¡¤ËóÇñ¡¢ÇñΪÚÀ̦ȴ Windows ÐÎË·ÜÓ¡¢Ð¬Çã¡ÖÎêÆÛÎÃãôËç âú¡×üÏÆüÆßÚûîÀ (/) Õë¡¢ÚÀÙòÆÒâüËðÆîÅ°ÚûîÀ (\) ËôòÓÄ«ÆøòçæûÕÀ¡¤Å°Äæ¡¢Çñ ΪÚÀ̦ȴ UNIX ÍÐ Linux ÐÎË·ÜÓ¡¢Ð¬Çã¡ÖÎêÆÛÎÃãôËçâú¡×üÏÆüÅ°ÚûîÀ (\) Õë¡¢ ÚÀÙòÆÒâüËðÆîÆßÚûîÀ (/) ËôòÓÄ«ÆøòçæûÕÀ¡¤ DB2 Information Integrator Ó¼ëæêØ DB2 Information Integrator ÒÞùÃÄæÄØÏ¡ÙÂ÷îÎûÒÞùÃæñع¡¢Å¯ DB2 Information Integrator ÎûÒÞùÃÊÀÝ´¡¢ÅýÑÄôúÇÙË·ÜÓ¡£Web Τ٭¡¢ÅèůÄãâææñÕè ê§Ü¡¡¢îùÙ¶ïå¡ÖDB2 Information Integrator ÎêÆÛÎÃãôËçâú¡×¡¢ê½ÉßÒ³¡¨ http://www.ibm.com/software/data/integration/db2ii/support.html ̧ÆÆæñäã Çã FixPak 1 ÎûÕëÔ·¡¢ Data Links Manager Administration Guide and Reference ÄØÊÕä»Ä§ (PDF ֪Ȣ¡¢ÕóæÀ SC27-1221-01)¡¢ËäÆ«Ú·ÝÕÔ¶ DB2 ÅÅßÎê½ ×»Ä¶ç¥¡¨http://www.ibm.com/software/data/db2/udb/winos2unix/support ÚÀÆ«Ú· IBM ÝÔüÕê½×»Ä¶ç¥ DB2 Life Sciences Data Connect ܨÐÂÎûÅÆǵ¡¢ê½Éß Ò³¡¨ http://www.ibm.com/software/data/db2/lifesciencesdataconnect/ ÇñΪÚÀã÷ÓÑóôáþ HTML ֪ȢÎû DB2 ÅÆǵ¡¢ÚÀÆ«ÅèڷĶÇÄê½ÉßîÀĸÇô̽¡ÖDB2 HTML æñعÄãÅÀ¡×¡¨http://publib.boulder.ibm.com/infocenter/db2help/¡¤ ƶÆÀ¡¢ÇñΪÚÀÆ«ÅèÙò¡ÖDB2 HTML æñعÄãÅÀ¡×ÇøæÒÇãÚÀÎûË·ÜÓĸ¡§ÚÀÆ«ÅèÚ·ÒÞÇÑê½ ×»Ä¶ç¥ DB2 HTML ÅÆǵ CD ÑÐçùóò¡¤ÊäÄ¡ÎêȹÝçäÄÊÕä» DB2 HTML ÅÆǵ¡¤Ó¼ëæÞ² ä»ÅÆǵ¡¢îùîÀĸÇô̽¡ÖDB2 HTML æñعÄãÅÀ¡×¡¢ÍÐÄ¶ç¥ DB2 HTML ÅÆǵ CD ÑÐçù óò¡¢àÓÑ¥ÇøæÒÇãÚÀÎûË·ÜÓĸ¡¤ÅÒØÄ¡ÖHTML æñعÄãÅÀ¡×¡¢PDF ÅÆǵç¤Å·ÊÕ仡¤ ùÃÍõ¡ÖDB2 âäàõÄãÅÀ¡×ů DB2 for z/OS ÎûæÛÜØæñعƫڷÅèĶê½Éß̽ڵ¡¨ http://www.ibm.com/software/data/db2/os390/spb/¡¤ Çñëæ DB2 Ë·ÇÄܨÐÂÎûÞ²ä»æñع¡¢îùÓÔïåÉ­â¶Îû DB2 Magazine¡¤îÀĸÎêÎû÷ãë¢Æ« ÅèÚ· http://www.db2mag.com ̽ڵ¡§ÓÑÊåÓÔïåÎûÑÀÆüľäÄÄüÉ©ÍõÝÕÔ¶ê½×»Ä¸¡¤ ùÃÍõÆÛÎêȹ ÆÛÎêȹä»ìÁÎûÅü×ä ÆÛåçßÈËòÆÛÎêȹ DB2 Universal Database ÍÔßÈËòÄæÅûÚ°Åü×äÎûöüàûèòÓÑ¡¤ åµÐúÇ¡ä»Îû Unicode æñÕèÕ»ÕëÅÅßÎ̧Åìè×äùâûÊ© åµÐúÇ¡ä»Îû Unicode æñÕèÕ»Õë¡¢DB2 UDB ÜÉ 8 Îê FixPak 6 ÅÅßÎí°Ô¶ä»Îûè×äù âûÊ©¡¨ UCA400_NO ÝÕÔ¶è×äùðÂäÄèÒÉ¢¡ÖUnicode è×äùé½ê«ÎÎ (UCA)¡×¡¢ÝÕÔ¶é½ê«ÎÎÑÒÅèÆß Ú¦Å§ö¡ÉÖÇâÝÃÒ³ ON Îû Unicode Standard 4.00 ÎêÒ³Ù×ö𡤠UCA400_LSK ÝÕÔ¶è×äùðÂľäÄèÒÉ¢ UCA 4.00 Îê¡¢ÈÔÅâäÄÅûÅèáúÙªÅèÚêÊ©ßÚҨDZɬÅÆ ÇóÄ÷¡¤ UCA400_LTH ÝÕÔ¶è×äùðÂľäÄèÒÉ¢ UCA 4.00 Îê¡¢ÈþÆÆäÄÕüðã¡ÖÅÞÐéÖ¹ÙÏÅÆÇǫ́¡×ȹ Ê©¡¢ËôÚêÊ©ÍÔÈ´Ö¹ÙÏÅÆÇóÄ÷¡¤ ÚÀÆ«ÅèÇã Unicode Technical Standard #10 (ÈíÍõ Unicode Consortium ê½×»¡¢ ê½ÉßÒ³ http://www.unicode.org) ÄãÊÆ̯ UCA ÎûæÛÜØæñÕ衤 åµËðÆî CREATE DATABASE ÌÔÅïËôÐúÇ¡ä»Îû Unicode æñÕèÕ»Õë¡¢ÚÀÜ¢ÇãÆ«Åèè× COLLATE USING Ù¶í°ÑÀÌù UCA400_NO¡£UCA400_LSK ÍÐ UCA400_LTH¡¤ åµËðÆî sqlecrea C API ËôÐúÇ¡ä»Îû Unicode æñÕèÕ»Õë¡¢ÚÀÜ¢ÇãÆ«ÅèÒ³ SQLEDBDESC æñÕèá¸é¬Îû SQLDBCSS úñÈíÑÀÌù SQL_CS_UCA400_NO¡£SQL_CS_UCA400 _LSK ÍÐ SQL_CS_UCA400_LTH¡¤ ܨÐÂÔºÆßñ¥á£ Ó¼ëæÝÕÔ¶ÔºÆßÔïǵÍÔݨܡÎû¡ÖÚæûâá£È¢Å¡ÎµÞÞÉË (APAR)¡×ÛÒÞÌ¡¢îùÝßݾĶÇÄê½ Ó÷¡¨ http://www.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/ve rsionfixpak.d2w/report ÷®ÎêÒÞÕ©ÍÌ ßåÅî FixPaks (Linux ů UNIX) Çã DB2 Universal Database ÜÉ 8 ÎêÄæЩ¡¢FixPak ã¯ÆîËôÊÕä»ÄØÇøæÒÇãÑÜÌÖÌù ÈíåôÄãÎû DB2 Universal Database æñÕèÅýÍÐóòÕùâõ¡¤èÒï³Ä¸Ëôë©¡¢ÝÕÏÐÆüÇøæÒ FixPak ÄØÙòÜ¢ÇôóòÕùßÐÈ© FixPak ÄùßÈËòÎûÊÕä»óòÕù¡¢ÇÞȺÇãÞÌÄ¡Ë·ÜÓĸÄâÆ«×ä È´ÇéÔ¶ DB2 FixPak ìÒȹ¡¤Ü¢Çã¡¢ DB2 UDB (ESE) Æ«ÅèÇôÇãÍõÒÞÇÑË·ÜÓÎûÇéÔ¶Ôº ÆßÔïǵìÒȹÄ㡤ȺÖÖÍÌÚ· 8.1.2 ÎêÎûÆßȢɢäÆô¿èºÄæÑ¥Þó̯̿ÅÅßΡ¢ÅâËðÆîĶÇÄ Ì¥ê¡ FixPak Ëôç®È©¡¨ Ä¡×ï FixPak * Äâã¯Æ«Ëò ESE ËðÆî¡¢õäÆ«ÅèËòÒÞùÃÆÍƺÎûÍÔÈ´ÅÅßÎÄæ DB2 V8.1 ܨ ÐÂËðÆî * Æ«ÅèÎþÚÙÇøæÒÇãÆøЩÇøæÒÎûܨÐÂĸ (ÈíÍõ AIX(R) ĸÎû /usr/opt/db2_08_01 ÆøòçÍÐ̧ÅìÆÍƺĸÎû /opt/IBM/db2/V8.1 Æø òç) ßåÅî FixPak * Æ«ÅèÇøæÒÈ©ÇÀä»Îû DB2 Universal Database ESE îïÆÛ * ÇøæÒÇãçßÇ¿ÌùåøÎûÈíåôÄã¡¢ÈÔÄâÑÒÄ¡×ï DB2 Universal Database ÇøæÒÍÔÆîÎûÈíåô â¡: 1. ÇñΪÇéÔ¶ FixPak ÇøæÒè×ÚÀÎûô¿èºËôë©ÄâÑÒÆÒÓÑÎû¡¢ÞóÄâëæÓÑÙÚÈçÆÆ¡¤ 2. Ú· IBM DB2 Universal Database Enterprise Server Edition (ESE) for Linux and UNIX(R) 8.1.2 ÎêâäÌî¡¢ÙòÔºÆßÔïǵÇøæÒÒ³ÇéÔ¶ÔºÆßÔïǵÕ롢ƫÇã ÆßȢɢäÆô¿èºÄãÄèÅèÅÅßΡ¤ Ó¼ÓÑÙòÇéÔ¶ FixPak èÒËóÊÕä»Ò³ÄâÇÑ FixPak ìÒȹ¡¢îùÙÚÈçĶÇÄ̧ÄãġԶɢäÆ¡¨ * ÙòïËåµÎûÄ¡×ï FixPak ÇøæÒÇãÄØÇøæÒÎû General Availability (GA) ܨÐÂÄæ ĸ¡¢àÓÑ¥Ú·Ü¢ÇôÎû GA æûÕÀÙÚÈç db2iupdt ËôÊÕä»èÒËó¡¤ * ÙòïËåµÎûßåÅî FixPak ÇøæÒÈÝÆÆÈÜÄ×ÎûÙÄÄ¡æûÕÀ¡¢àÓÑ¥Ú·ÝÕÔ¶æûÕÀÙÚÈç db2iupdt ËôÊÕä»èÒËó¡¤ Ó¼ëæÈ´ùÃÍõĶç¥ßåÅî FixPak ÎûâÐÄ¡Êãæñع¡¢îùÝßݾ IBM(R) ÅÅßÎê½×»¡¢ê½ÉßÑÒ http://www.ibm.com/software/data/db2/udb/winos2unix/support¡¤ ¡ÖæñÕèÔ¿óÃÄãÅÀ¡×ǿЩÎûÈùΤðÂÅÅßÎÓî̱ DB2 Universal Database (DB2 UDB) Enterprise Server Edition ÜÉ 8 Îê¡Öæñ ÕèÔ¿óÃÄãÅÀ¡×ÎûǿЩÈùΤðÂÅÅßÎȴĶÇÄÓî̱¡¨ ÄËÐÎÎìǵ (LOB) ÅÅßÎ * ÇñΪÚÀÇãÅÒ DB2 UDB Enterprise Server Edition ÜÉ 8 ÎêÊÕÈ®Îû ÈùΤðÂĸËðÆîÔ¿óÃÚÕ̱æñÕèÕ»¡¢ÚÀÙòàÒÎÎËðÆî LOB¡¤ÚÀÆÒâüÙòÔ¿óà ÚÕ̱æñÕèջŪ×ÈÈÝÆßíýìÒȹ¡¢ÍÐÚÀÆ«ÅèÙòÚÕ̱æñÕèÕ»ÜÃÈÝÇøæÒħ DB2 UDB Enterprise Server Edition ÜÉ 8 ÎêÔ¿óÃÈùΤðÂÎûË·ÜÓ¡¢ÅâÚ· æÚË·ÜÓÆÛê¦ËðÆîÔ¿óÃÚÕ̱æñÕèÕ»¡¤ * Ó¼ÓÑÇã¡ÖæñÕèÔ¿óÃÄãÅÀ¡×êØ DB2 UDB ÄæâæÜÃÙ¯ LOB¡¢ÚÀÆÒâüŪ×ÈÈÝ DB2 UDB Enterprise Server Edition ÜÉ 8 Îꡤ Ë·ÜÓê½æûÑÞé¬ (SNA) ÅÅßÎ ÇñΪËðÆî SNA ÝÙÚÙÈÝÔ¿óÃËôäãÌÏÆøíº¡¢ÚÀÆÒâüÙòØÙåôüÈÊÕÒ³ TCP/IP over SNA¡¢ÍÐËðÆî Windows NT(R) Ô¿óÃÅîܡ׻¡¤ ÅÅßÎ EXPORT êØ LOAD ÄüÆîá£È¢ åµÚÀŪ×ÈÔ¿óÃÅîܡ׻Õë¡¢ÚÀľÆÒâüŪ×ÈËôäãÆøíºæñÕèÕ»¡¢ÍÐÅè¡ÖSQL ò٠̽¡×ÌÏ¡ÖßÆÄ«¡×ÊãüõËôåôßÐÔ¿óÃá£Ê©ÄãÎû EXPORT êØ LOAD ÄüÆîá£È¢¡¤ ¡ÖSQL òÙ̽¡×ÌÏ¡ÖßÆÄ«¡×ÊãüõËðÆîÑ¥Óòæùáá SELECT ÌÏ INSERT ÝóÓÝÈ¢ Îû DELETE* ÝóÓÝÈ¢¡¤¡ÖSQL òÙ̽¡×ÌÏ¡ÖßÆÄ«¡×ÊãüõëæÓÑæñÕèÕ»ËôØ´ç¥ ÍÔȴǨÍø¡¤ÇÞȺ¡¢¡ÖSQL òÙ̽¡×ÌÏ¡ÖßÆÄ«¡×ÊãüõÎûÕæ×äÄâů EXPORT ÌÏ LOAD ÄüÆîá£È¢¡¤ ÄâÅÅßÎ Visual Warehouse 5.2 DB2 á£È¢¡ÖVW 5.2 ç¥Ä«×ÅÅÆÇóóò̯ DB2 UDB EEE (ã¯Óî AIX)¡× DB2 UDB ÜÉ 8 ÎêÄãÄâÅÅßÎ Visual Warehouse 5.2 DB2 EEE ç¥Ä«Êãüõ¡¤ Ó¼ÓÑÙòÈ´Ù´çÒÇóÄ÷ÎûóòÕùç¥Ä«ÜÉ 8 ÎêÎûÅ¡Þ´ÏÐÖª¡¢îùÙÚÈçĶÇÄÊãüõ¡¨ 1. ÇñΪÆøíºæñÕèÕ»ÍÐÏÐÖªÄâÇãÜÉ 8 ÎêìÒȹ¡¢îùÙòÆÆÜÃ÷Ë̯ DB2 UDB ÜÉ 8 Îꡤ ÜÃ÷ËæñÕèÕ»ÎûÅÉÎÎÄæÄ¡ÞóÑÒÚ·ÌÔÅïÈçËðÆî db2move ÌÔÅ 2. âäÚö Visual Warehouse 5.2 EEE ç¥Ä«ÊãüõÎû¡ÖÄùÕ©¡×áþ᧡¢òÙ̽ٶí°íºü¾¡¢ شĶ ÎþúñÙ´çÒÇóÄ÷¡£ÇóÈëÙ´çÒÇóÄ÷ůÄÑí°Ù´çÒÇóÄ÷Ù¶í°ÎûÔ«¡¤ 3. ÐúÇ¡ä»ç¥Ä«ÊãüõÎûä»á£Ê©ÍÐËðÆîÔÏÌîá£Ê©¡¤ÇñΪÚÀݽè¢ÐúÇ¡ä»á£Ê©¡¢îùÙòËôäã óòůÆøíºÏÐÖªä»ìÁ̯ä»á£Ê©Ä㡤ÇÑÕëÙòä»á£Ê©ä»ìÁ̯ïËåµÎûÔ¿óÃñ¢ÙïÏñû¬åú ÜÚ¡¤ 4. ÇãÚÀÓÑËðÆîÎûá£Ê©ÄãÐúÇ¡ DB2 ç¥Ä«Êãüõ¡¤ 5. ÙòËôäãůÆøíºÝÙÚÙ̯Êãüõ¡¤ 6. âäÚöç¥Ä«ÊãüõÎû¡ÖÄùÕ©¡×áþ᧡¢ËäòÙ̽ç¥Ä«í¼È¢úñÈíÄãÎû PARTITIONED¡¤áþëæ ÓÑÅè÷®ÊãüõÎûÎþúñÙ´çÒÇóÄ÷¡£ÇóÈëÙ´çÒÇóÄ÷ůÄÑí°Ù´çÒÇóÄ÷ÍÔËðÆîÎûÔ«¡¢ËôÊÕ ä»Îþúñ¡£ÇóÈëůÄÑí°öµúñÈí¡¤ 7. ѺġĶâÐâêÅèÚöÙ¯¡Öç¥Ä«¡×ê´üñ¡¤Çã¡ÖÉ¢äÆ¡×Ó÷ÓòÄã¡¢òÙ̽š޴ůç¥Ä«æñÕ衤 8. Çã¡ÖùËÐΡ×Ó÷ÓòÄã¡¢òÙ̽åôßÐÏÐÖªæñÕ衤 9. ÚÙÌ¿¡Öç¥Ä«¡×ê´üñÎûÞ·ïõçßÝÃÔ«¡¤ 10. ¡ÖèòÓÑ¡×Ó÷ÓòäÄüÏÆüÞ²ÜÜç¥Ä«ÌÔÅîïÑçÞ²ÜÜç¥Ä«ÌÔÅï¡¢ÇÂѺġĶÉùÈ©¡¤ 11. ùÃÝð¡ÖÄùÕ©¡×áþ᧡¤ DB2 Universal Database ÜÉ 7 ÎêÈùΤðÂÇô̽ Ó¼ÓÑÚ·ÜÉ 8 ÎêÎûÆîÅÂê¦ËôÇô̽Çã Linux¡£UNIX ÍÐ Windows(R) É¢äÆË·ÜÓĸÎû DB2 Universal Database ÜÉ 7 ÎêÈùΤð¡¢Ð¬ÆÒâüÇãÈùΤðÂĸÇøæÒÜÉ 7 ÎêÎû FixPak 8 (ÍÐÊÕä»ÎêÆÛ)¡¢ËäÙÚÈç db2updv7 ÌÔÅӼÓÑ̽ڵÇøæÒÜÉ 7 Îê FixPak ÎûÒÞùÃÑÀ Æü¡¢îùÙ¶ïåÜÉ 7 Îê FixPak Îû Readme ů¡ÖÎêÆÛÎÃãôËçâú¡×¡¤ ÚÀàÒÎÎÚ· DB2 Universal Database ÜÉ 8 ÎêÎûÆîÅÂê¦ËôÇô̽ DB2 Connect ÜÉ 7 ÎêÎûÈùΤ𡤠Çã DB2 UDB for OS/390 ÜÉ 6 Îêů DB2 UDB for z/OS ÜÉ 7 Îêĸ¡¢SQLJ ů SQL ëºÉ·á£È¢ÅÅßÎëæÓÑâäàõÄãÅÀ APAR Çã Windows ÍÐ UNIX É¢äÆË·ÜÓÄãËðÆî Application Development Client for DB2 Universal Database ÜÉ 8 ÎêÎû¡ÖâäàõÄãÅÀ¡×Õë¡¢ÆÒâüÇãÈùΤðÂĸÇøæÒĶÇÄ APAR ÅèÚöÆî SQLJ ů SQL¡ÖëºÉ·á£È¢¡×ÅÅßΡ¨ DB2 UDB for z/OS ÜÉ 7 Îê * PQ65125 - ßÈËò SQLJ ÅÅßÎÅèÐúåô Java SQLJ óÃÇôá£Ê© * PQ76858 - ßÈËò¡ÖSQL ëºÉ·á£È¢¡×ÅÅßÎ DB2 UDB for OS/390(R) ÜÉ 6 Îê * PQ76858 - ßÈËò¡ÖSQL ëºÉ·á£È¢¡×ÅÅßÎ ¡ÖÌÔÅïÄãÅÀ¡×ůÜÉ 7 ÎêÈùΤð ѺġĶêØ¡ÖæñÕèÕ»¡×ÝÙîÀúñÈíÒÞùÃÎû [...] (ÒÜÜ©ÜÊæÀ) ѺâÚÕë¡¢ÜÉ 8 Îê¡ÖÌÔÅï ÄãÅÀ¡×Æ«×ääÄܨÆíúÀÉËعÕÉůã°ÅøóòÕù¡¤ÝÕÔ¶ÈçÒ³êØÜÉ 8 ÎêÄÖ̦êØÜÉ 7 ÎêÈùΤ ðÂä®ØÙËðÆîÎûÓî̱ÒÞùá¤ÑºÄ¡Ä¶ [...] Æ«âäÚö¡ÖòÙ̽æñÕèÕ»¡×áþ᧡¤åµÚÀÕ­âäÅø Ü¢ÇãÝÕÔ¶áþá§ÄãÎûË·ÜÓůèÒËóÕë¡¢DB2 UDB ÞóäÄܨÆíÄùÝåٯɢËôöÊ̽˷ÜÓ¡£èÒËó ůæñÕèÕ»æñع¡¢ÅèÏíÜÃÄ«ðùÎíá¸é¬¡¤ÇñΪ DB2 UDB ÇãÝÕËèÄùÝåÒ¤Ù¯ßæâæàõÜ¢ÜÉ 7 ÎêÈùΤð¡¢ÆÆÞóäÄܨÆíúÀÉËůã°ÅøóòÕù¡¤ Ú· DB2 UDB ÚöÙ¯¡ÖSQL ëºÉ·á£È¢¡×ÎûÌ¥Ô¶ÎêÆÛ ÚÀÆ«ÅèÚ· DB2 Universal Database 8.1 ÎêÌËƵÜÉ 7 ÎêÌÏÜÉ 8 ÎêÎû¡ÖSQL ëºÉ· á£È¢¡×¡¤ÚÀÆ«ÅèÚ·¡ÖDB2 æñÕèÔ¿óÃÄãÅÀ¡×ÚöÙ¯ÜÉ 7 Îꡤ̧ÅìÄãÅÀÆ«ÚöÙ¯Þ²ä»ÜÉ 8 ÎꡤܨÐÂîÀĸë©ÍüÈ´¡ÖSQL ëºÉ·á£È¢¡×ÜÉ 7 ÎêÎû̧Åìæñع¡¤ üÈÊÕ Unicode ÈùΤðÂÈçÒ³ ÇãÜÉ 7 ÎêÄã¡¢Unicode ÈùΤðÂäÄÍÁÜ©óÜÆîá£È¢ÇãÝÙîÀÕëÍÔã®ØÊÎûè·Ê°Çóî£Ó÷¡¢Ëä ØõÝÃËðÆî UCS2 Unicode (Çóî£Ó÷ 1200)¡¤ÜÉ 8 Îê Unicode ÈùΤðÂÆøЩÎÃãôÆîÅ ê¦ÍÔã®ØÊÎûÇóî£Ó÷¡¤ Classic Connect àÒÎÎËðÆî Classic Connect ܨÐÂàÒÎÎËðÆö£àÓÚÀÆ«Íõ¡ÖæñÕèÔ¿óá×ÅÆǵÍÐ̧ÅìÇâÅÉÊÆ̯ Classic Connect ܨÐÂÎûÙ¶ÈÓæñÕè¡¢ÈþóÜæÚÍÁÜ©ÝÕËèÙ¶ÈÓæñÕè¡¢ÇÞÒ³ÆÆÔ¯ÄØÄâÇ ïËÆ ܨÐÂÒÞÕ©ÍÌ IBM DB2 Development Add-In for Microsoft Visual Studio .NET IBM DB2 Development Add-In for Microsoft Visual Studio .NET ÄâÅÅßÎĶÇÄ Ü¨ÐÂÎêÆÛ¡¨ * DB2 Universal Database for z/OS and OS/390 ÜÉ 8 Îê * DB2 Universal Database for iSeries 5.1 Îêů 5.2 Îê WebSphere Application Server ÙÚÈç SQLJ á£È¢ÄãÎû SQL ÝóÓÝÈ¢ ÇñΪÚÀÆßÇãËðÆîÎû WebSphere Application Server ÎêÆÛÈ®Íõ 5.0.1 ÎꡢЬÄâê§ ÚÀÇñÈôÈÜÓÔ SQLJ á£È¢¡¢ÝçÆÒâüÅèÙ¯èèÅÉÈ¢ÙÚÈç SQLJ á£È¢ÄãÎûÍÔÈ´ SQL ÝóÓÝ È¢¡¤ è×Íõ WebSphere Application Server 5.0.1 ůÊÕä»ÎêÆÛÈÔËÆ¡¢ÇñΪÚÀÈÜÓÔ SQLJ á£È¢¡¢Ð¬ SQL ÝóÓÝÈ¢äÄÅèòûèèÅÉÈ¢ÙÚÈ硤 Microsoft Visual Studio Visual C++ ö£àÓÇã¡ÖDB2 âäàõÄãÅÀ¡×îÀĸë©ÍüÄãÈ´ßÈ̯ƫÙò Microsoft Visual Studio Visual C++ ÜÉ 5.0 ÎêåµÉ¢ÐúåôÆÂÚõ¡¨ -1 òãë¨ÎûġԶƫÈçÎûæØÊîÅÉÕù¡¢ Microsoft Visual Studio Visual C++ ÜÉ 5.0 ÎêÄâÅÅßÎ SQL óÃÇôá£Ê©Îûâäàõ¡¤ àÓÈÔ¡¢Microsoft Visual Studio Visual C++ ÜÉ 6.0 ÎêЬȴÅÅßΡ¤Çñëæ̧ÅìÎû ØÙåôæñع¡¢Æ«ÅèÇã IBM DB2 óÜÆîá£È¢âäàõÅÃÅõ¡¨ÐúåôůÙÚÈçóÜÆîá£È¢ÄãÊÆ̯¡¤ 64 ÈíÄ÷É¢äÆË·ÜÓĸÍÔëæÓÑÎû Microsoft XP ÔºÆßá£È¢ Ó¼ DB2 Ë·ÇÄܨÐÂêØØÙåôÒ³ËðÆî NetBIOS Ý×ع̶ÌùÎû Microsoft XP É¢äÆË·ÜÓ (2600) ä®ØÙËðÆî¡¢ÚÀÆÒâüÇ× Microsoft ̽ڵʸÝÚÔºÆßá£È¢¡¤îùɳÆîÏ¡øüÕ» (Knowledge Base) ÅÆÝýæÀî£ Q317437 ËôÒ¥ææ Microsoft¡¤ Windows 64 ÈíÄ÷É¢äÆË·ÜÓĸÎû CLI ů ODBC Çã Windows 64 ÈíÄ÷É¢äÆË·ÜÓĸ¡¢ÄâÆ«ËðÆîÆñ ODBC ů DB2 CLI ÛÛÇÙÎûóÜÆîᣠȢ¡¤ Ì¿ÅÅßÎÎû LDAP ÆîÅÂê¦Å¯ÈùΤðÂØÙåô ĶÏÐãðôêÌ¿ÅÅßÎÎû LDAP ÆîÅÂê¦Å¯ÈùΤðÂØÙåô¡¨ ÏÐ 1. Ì¿ÅÅßÎÎûÆîÅÂê¦Å¯ÈùΤðÂØÙåô +-------------------+----------------+----------------+---------------+ | | IBM SecureWay | Microsoft | Netscape LDAP | | | Directory | Active | ÈùΤð | | | | Directory | | +-------------------+----------------+----------------+---------------+ | IBM LDAP ÆîÅÂê¦ | ÅÅßÎ | ÅÅßÎ | ÅÅßÎ | +-------------------+----------------+----------------+---------------+ | Microsoft | ÅÅßÎ | ÅÅßÎ | ÅÅßÎ | | LDAP/ADSI ÆîÅÂê¦ | | | | +-------------------+----------------+----------------+---------------+ IBM SecureWay Directory 3.1 ÎêÑÒ LDAP ÜÉ 3 ÎêÈùΤð¡¤ÆÆïËÆîÍõ Windows NT¡£Windows 2000¡£Windows 2003¡¢Åèů AIX É¢äÆË·ÜÓÌÏ¡ÖSolaris É¢äÆô¿ 躡ס¤Çã AIX ů iSeries (AS/400) ĸ¡¢SecureWay Directory ÑÒÅèÙ×öðÉ¢äÆË· ÜÓÄæÄ¡ÝåǹËôÅøÝÌ¡¢ÅâêØ OS/390 Security Server Ä¡ØÄÅøÝÌ¡¤ DB2 UDB ÅÅßÎ AIX¡£Solaris¡£Windows 98¡£Windows XP¡£Windows NT¡£Windows 2000 ů Windows 2003 ĸÎû IBM LDAP ÆîÅÂꦡ¤ DB2 UDB ÅÅßÎ Linux IA32 ů Linux/390 ĸÎû IBM LDAP 3.2.2 Îꡤ Microsoft Active Directory ÑÒ Windows 2000 Server É¢äÆË·ÜÓÄæÄ¡ÝåǹÎû LDAP ÜÉ 3 ÎêÈùΤ𡤠Microsoft LDAP ÆîÅÂê¦ÅýÉÖÇã Windows É¢äÆË·ÜÓÄ㡤 åµ DB2 UDB Çã Windows É¢äÆË·ÜÓĸÙÚÈçÕ롢ƫÅÅßÎËðÆî IBM LDAP ÆîÅÂê¦ÍÐ Microsoft LDAP ÆîÅÂê¦ËôÇô̽ IBM SecureWay Directory Server¡¤Ó¼ÓÑÍüíýÇâ òÙ̽ IBM LDAP ÆîÅÂꦡ¢îùËðÆî db2set ÌÔÅïÙò DB2LDAP_CLIENT_PROVIDER àôòç üÈí°ÝÃÌùÒ³Ô« IBM¡¤ Windows XP É¢äÆË·ÜÓ Æ·È´ Personal Edition ܨÐÂÅÅßÎ Windows XP Home Edition É¢äÆË·ÜÓ¡¤ ĶÇÄܨÐÂÅÅßÎ Windows XP Professional É¢äÆË·ÜÓ¡¨ * Personal Edition * Workgroup Server Edition * DB2 Connect Personal Edition * DB2 Connect Enterprise Edition â¡: Windows XP è×Íõ DB2 Connect Enterprise Edition ÎûÅÅßÎã¯ÓîâäàõÍÐ àÁæÜÆøÎû¡¤ÆßȢɢäÆô¿èºëæÓÑ Windows 2000 ÍÐ Windows Server 2003¡¤ î¾î£ÇóâõøüÉ±î£ (CCSID) 5039 ÎûßåÅî Unicode ÷ËßÐÏÐ Microsoft Japanese Windows Shift-JIS Çóî£Ó÷ÄØàôòçÒ³ IBM î¾î£ÇóâõøüÉ±î£ (CCSID) 943¡¤àÓÈÔ¡¢HP-UX ÆÍƺĸÎû Shift-JIS Çóî£Ó÷ÄØàôòçÒ³ CCSID 5039¡¤ CCSID 5039 ã¯ÉÖÈ´¡ÖÅÊÆÛÄÖäÆíºäí (JIS)¡×ÄãÎûÇóÄ÷¡¢ÊôȴǶÈôËòóÜÙ¸ÌùåøÎûÇó Ä÷¡¤ÚÀÆ«ÅèÇã HP-UX ĸËðÆî CCSID 5039 Îû DB2 UDB æñÕèÕ»¡¢ËôóÃÇô Shift-JIS ÇóÄ÷¡¢Èþ CCSID 5039 êØ CCSID 943 ÄæâæÙòàõÆíÇóî£Ó÷÷ËßС¤åµËðÆî Microsoft ODBC óÜÆîá£È¢Õë¡¢ÚÀÆ«×ääÄÇãÙò CCSID 5039 ÄãÎûæñÕè÷ËßÐÒ³ Unicode Õë¡¢ç² Ì¯íÑdzÎûÙÂ÷î¡¢ÇÞÒ³ IBM ÎûÇóî£Ó÷÷ËßÐÏÐêØ Microsoft ÎûÇóî£Ó÷÷ËßÐÏÐÄæâæÈ´ ոܬ¡¤ Ú· CCSID 5039 ÷ËßÐÒ³ Unicode Õ롢ĶÇÄÎûÇóÄ÷ÛÒÞÌÙòÝßÈ©ÄâÇÑÎûÇóî£öµ¡¢Ì½Êî ÍõËðÆîÎû÷ËßÐÏÐÈÔÌù (IBM ÍÐ Microsoft)¡¤è×ÍõÝÕËèÇóÄ÷ÈÔËÆ¡¢ IBM ÷ËßÐÏÐÜÊ ÇÙ¡ÖÅÊÆÛÄÖäÆíºäí¡×Standard JISX0208 ů JISX0221¡¤ ÏÐ 2. CCSID 5039 ÈÝ Unicode Çóî£öµ÷ËßÐ +-----------------------+----------------------+----------------------+ | Shift-JIS Çóî£öµ (Çó | IBM ÅäÓÑÇóî£öµ | Microsoft ÅäÓÑÇóî£öµ | | Ä÷ÇØê¢) | (Unicode ÇØê¢) | (Unicode ÇØê¢) | +-----------------------+----------------------+----------------------+ | X'815C' (EM ×¢ÊËæÀ) | U+2014 (EM ×¢ÊËæÀ) | U+2015 (ÅÕÆÍÇÄ) | +-----------------------+----------------------+----------------------+ | X'8160' (ÎÌÎí×¢ÊËæÀ) | U+301C (ÎÌÎí×¢ÊËæÀ) | U+FF5E (ÉùðììÏÐùÎû ~ | | | | ÇóÄ÷) | +-----------------------+----------------------+----------------------+ | X'8161' (÷äÐÍÎþîÀ) | U+2016 (÷äÐÍÎþîÀ) | U+2225 (ËäÈç) | +-----------------------+----------------------+----------------------+ | X'817C' (àµæÀ) | U+2212 (àµæÀ) | U+FF0D (ÉùðììÏÐùÎûÝÙ | | | | ÇóæÀ-àµæÀ) | +-----------------------+----------------------+----------------------+ ËóÇñ¡¢åµËðÆî IBM ÷ËßÐÏÐÕ롢̦ȴ CCSID 5039 Çóî£öµ X'815C' ÎûÇóÄ÷ EM ×¢ ÊËæÀäÄ÷ËßÐÒ³ Unicode Çóî£öµ U+2014¡¢ÈþÑÒÇãËðÆî Microsoft ÷ËßÐÏÐÕ롢ЬäÄ ÷ËßÐÒ³ U+2015¡¤ÝÕÆ«×ääÄè× Microsoft ODBC óÜÆîá£È¢Ü¨ÆííÑdzÎûÙÂ÷î¡¢ÇÞÒ³ÆÆ Ô¯äÄÙò U+2014 áþÒ³àÒÕæÎûÇóî£öµ¡¤Ò³Ä§õâÉ­ÝÕËèíÑdzÎûÙÂ÷î¡¢ØæħçßÝà IBM ÷Ë ßÐÏÐÄæÆÀ¡¢ DB2 UDB õääÄßÈËòÚ· CCSID 5039 ÈÝ Unicode ÎûßåÅî Microsoft ÷Ë ßÐÏС¤ÚÀëæÓÑÙòçßÝà IBM ÷ËßÐÏÐßÐÈ©ßåÅîÎû Microsoft ÷ËßÐÏС¤îùÎÃãô¡¢Ú· Unicode ÈÝ CCSID 5039 ÎûçßÝà IBM ÷ËßÐÏÐÜÊÇÙ Microsoft ÎêÆÛ¡¤ Ùòî¾î£Çóâõ (CCSID) 5039 Îû Unicode ÷ËßÐÏÐßÐÈ© Microsoft ÷ËßÐÏÐ Ú· CCSID 5039 ÷ËßÐÒ³ Unicode Õë¡¢ÞóäÄËðÆî DB2 UDB çßÝÃÇóî£Ó÷÷ËßÐÏС¤Çñ ΪÚÀã÷ÓÑËðÆîÄâÇÑÎêÆÛÎû÷ËßÐÏС¢Çñ Microsoft ÎêÆÛ¡¢Ð¬ÆÒâüÅèÅÃÙ¯ÅÉÈ¢åôßÐçß ÝÃ÷ËßÐÏÐ (.cnv) óòÕù¡¤ Ç¿Êî۾ǵ ÇãåôßÐ sqllib/conv ÆøòçÄãÎûÜ¢ÇôÇóî£Ó÷÷ËßÐÏÐóòÕùÄæЩ¡¢ÚÀóÜæÚެǹóòÕù¡¢Åè ËßÚÀã÷ÓÑüÈÇßÆÆ¡¤Çã UNIX ů Linux ĸ¡¢sqllib/conv Æøòçù¹á¸ÈÝ DB2 UDB Îû ÇøæÒæûÕÀ¡¤ Óî̱ Ó¼ÓÑüéÝÕê¡ÚÅÎÓÆíÕæ¡¢ÊäÄ¡Ô¶ÝÙÚÙÈÝÒÞÇÑæñÕèÕ»Îû DB2 UDB ÆîÅÂê¦ÆÒâüÄØüÈÊÕħ ÆÆÎû÷ËßÐÏС¤ÄâàÓ¡¢ÄâÇÑÎûÆîÅÂê¦Æ«×äËðÆîÄâÇÑÎûÇóî£öµËôóÃÇôÒÞÇÑÎûÇóÄ÷¡¤ á£Ê© Ó¼ÓÑåôßÐ DB2 UDB çßÝÃ÷ËßÐÏС¢ÅèÏíÚ· CCSID 5039 ÷ËßÐÒ³ Unicode¡¢îùò×ߧĶ ÇÄÊãüõ¡¨ 1. Ùò sqllib/conv/ms/5039ucs2.cnv îïêûÈÝ sqllib/conv/5039ucs2.cnv 2. Óìä»ÚöÙ¯ DB2 UDB¡¤ î¾î£ÇóâõøüÉ±î£ (CCSID) 954 ÎûßåÅî Unicode ÷ËßÐÏÐ ÅÊÅÆ EUC Çóî£Ó÷Îû IBM î¾î£ÇóâõøüÉ±î£ (CCSID) ÄØàôòçÒ³ CCSID 954¡¤ CCSID 954 ÑÒÅÊÅÆ UNIX ů Linux ÆÍƺڦÆîÎûî¾î£¡¤ËðÆî Microsoft ODBC óÜÆîá£È¢ÝÙ ÚÙÈÝ CCSID 954 Îû DB2 UDB æñÕèÕ»Õë¡¢ÚÀÆ«×äÇãÙòæñÕèÚ· CCSID 954 ÷ËßÐÒ³ Unicode Õëç²Ì¯íÑdzÎûÙÂ÷àõÆííÑdzÎûÙÂ÷îÑÒÇÞÒ³ IBM ÎûÇóî£Ó÷÷ËßÐÏÐêØ Microsoft ÎûÇóî£Ó÷÷ËßÐÏÐÄæâæȴոܬ¡¤ IBM ÷ËßÐÏÐÜÊÇÙ¡ÖÅÊÆÛÄÖäÆíºäí (JIS)¡×JISX0208¡£JISX0212 ů JISX0221 ÄãÑÀÌùÎûÇóÄ÷ÇØꢡ¤ Ú· CCSID 954 ÷ËßÐÒ³ Unicode Õ롢ĶÇÄÇóÄ÷ÙòÝßÈ©ÄâÇÑÎûÇóî£öµ¡¢Ì½ÊîÍõËðÆî IBM ÍÐ Microsoft ÷ËßÐÏÐÈÔÌù¡¤ ÏÐ 3. CCSID 954 ÈÝ Unicode Çóî£öµ÷ËßÐ +-----------------------+----------------------+----------------------+ | EUC-JP Çóî£öµ (ÇóÄ÷ÇØ | IBM ÅäÓÑÇóî£öµ | Microsoft ÅäÓÑÇóî£öµ | | ê¢) | (Unicode ÇØê¢) | (Unicode ÇØê¢) | +-----------------------+----------------------+----------------------+ | X'A1BD' (EM ×¢ÊËæÀ) | U+2014 (EM ×¢ÊËæÀ) | U+2015 (ÅÕÆÍÇÄ) | +-----------------------+----------------------+----------------------+ | X'A1C1' (ÎÌÎí×¢ÊËæÀ) | U+301C (ÎÌÎí×¢ÊËæÀ) | U+FF5E (ÉùðììÏÐùÎû ~ | | | | ÇóÄ÷) | +-----------------------+----------------------+----------------------+ | X'A1C2' (÷äÐÍÎþîÀ) | U+2016 (÷äÐÍÎþîÀ) | U+2225 (ËäÈç) | +-----------------------+----------------------+----------------------+ | X'A1DD' (àµæÀ) | U+2212 (àµæÀ) | U+FF0D (ÉùðììÏÐùÎûÝÙ | | | | ÇóæÀ-àµæÀ) | +-----------------------+----------------------+----------------------+ | X'8FA2C3' (Å¡ÇÄ) | U+00A6 (Å¡ÇÄ) | U+FFE4 (ÉùðììÏÐùÎûÅ¡ | | | | ÇÄ) | +-----------------------+----------------------+----------------------+ ËóÇñ¡¢åµËðÆî IBM ÷ËßÐÏÐÕ롢̦ȴ CCSID 954 Çóî£öµ X'A1BD' ÎûÇóÄ÷ EM ×¢ÊË æÀäÄ÷ËßÐÒ³ Unicode Çóî£öµ U+2014¡¢ÈþÑÒÇãËðÆî Microsoft ÷ËßÐÏÐÕ롢ЬäÄ÷Ë ßÐÒ³ U+2015¡¤ÇÞÒ³÷ËßÐè×ÑÐÎûÝÕԶոܬ¡¢ÍÔÅèÚÀÆ«×äÇã DB2 UDB Unicode æñÕè Õ»¡¢ÍÐÇã DB2 UDB 954 æñÕèÕ»Îûè·Ê°Îþúñ¡¢è×ÒÞÇÑÇóÄ÷̦ȴ̥ԶÄâÇÑÎûÇóî£öµ¡¤ ÝÕÆ«×ääÄè× Microsoft ODBC óÜÆîá£È¢Ü¨ÆííÑdzÎûÙÂ÷î¡¢ÇÞÒ³ÆÆÔ¯äÄÙò U+2014 áþÒ³àÒÕæÎûÇóî£öµ¡¤Ò³Ä§õâÉ­ÝÕËèíÑdzÎûÙÂ÷î¡¢ØæħçßÝà IBM ÷ËßÐÏÐÄæÆÀ¡¢ DB2 UDB õääÄßÈËòÚ· CCSID 954 ÈÝ Unicode ÎûßåÅî Microsoft ÷ËßÐÏС¤ÚÀëæÓÑÙòçß Ýà IBM ÷ËßÐÏÐßÐÈ©ßåÅîÎû Microsoft ÷ËßÐÏС¤îùÎÃãô¡¢Ú· Unicode ÈÝ CCSID 954 ÎûçßÝà IBM ÷ËßÐÏÐÜÊÇÙ Microsoft ÎêÆÛ¡¤ Ùòî¾î£Çóâõ (CCSID) 954 Îû Unicode ÷ËßÐÏÐßÐÈ© Microsoft ÷ËßÐÏÐ Ú· CCSID 954 ÷ËßÐÒ³ Unicode Õë¡¢ÞóäÄËðÆî DB2 UDB çßÝÃÇóî£Ó÷÷ËßÐÏС¤ÇñΪ ÚÀã÷ÓÑËðÆîÄâÇÑÎêÆÛÎû÷ËßÐÏС¢Çñ Microsoft ÎêÆÛ¡¢Ð¬ÆÒâüÅèÅÃÙ¯ÅÉÈ¢åôßÐçßÝà ÷ËßÐÏÐ (.cnv) óòÕù¡¤ Ç¿Êî۾ǵ ÇãåôßÐ sqllib/conv ÆøòçÄãÎûÜ¢ÇôÇóî£Ó÷÷ËßÐÏÐóòÕùÄæЩ¡¢ÚÀóÜæÚެǹóòÕù¡¢Åè ËßÚÀã÷ÓÑüÈÇßÆÆ¡¤Çã UNIX ů Linux ĸ¡¢sqllib/conv Æøòçù¹á¸ÈÝ DB2 UDB Îû ÇøæÒæûÕÀ¡¤ Óî̱ Ó¼ÓÑüéÝÕê¡ÚÅÎÓÆíÕæ¡¢ÊäÄ¡Ô¶ÝÙÚÙÈÝÒÞÇÑ CCSID 954 æñÕèÕ»Îû DB2 UDB ÆîÅÂê¦ ÆÒâüÄØüÈÊÕħÆÆÎû÷ËßÐÏС¤ÇñΪÚÀÎûÆîÅÂê¦ÑÒÅÊÅÆ Windows¡¢Ì§ ANSI Çóî£Ó÷ÑÒ Shift-JIS (CCSID 943)¡¢Ð¬ÚÀľÙòëæÓÑÊÄ CCSID 943 êØ Unicode ÄæâæÎû DB2 çßÝÃ÷ËßÐÏÐüÈÊÕÒ³ Microsoft ÎêÆÛ¡¤ÄâàÓ¡¢ÄâÇÑÎûÆîÅÂê¦Æ«×äËðÆîÄâÇÑÎûÇóî£öµ ËôóÃÇôÒÞÇÑÎûÇóÄ÷¡¤ á£Ê© Ó¼ÓÑåôßÐ DB2 UDB çßÝÃ÷ËßÐÏС¢ÅèÏíÚ· CCSID 954 ÷ËßÐÒ³ Unicode¡¢îùò×ߧĶ ÇÄÊãüõ¡¨ 1. Ùò sqllib/conv/ms/0954ucs2.cnv îïêûÈÝ sqllib/conv/0954ucs2.cnv 2. Óìä»ÚöÙ¯ DB2 UDB¡¤ Ó¼ÓÑåôßÐ DB2 UDB çßÝÃ÷ËßÐÏС¢ÅèÏíÇã CCSID 943 êØ Unicode ÄæâæâÐÈç÷ËßС¢ îùò×ߧĶÇÄÊãüõ¡¨ 1. Ùò sqllib/conv/ms/0943ucs2.cnv îïêûÈÝ sqllib/conv/0943ucs2.cnv 2. Ùò sqllib/conv/ms/ucs20943.cnv îïêûÈÝ sqllib/conv/ucs20943.cnv 3. Óìä»ÚöÙ¯ DB2 UDB¡¤ ÄâÅÅßÎ MVS É¢äÆË·ÜÓ ð±ê§ÅÆǵÄãäÄßÈ̯ MVS¡¢Èþ DB2 Universal Database ÄØÄâÇÂÅÅßÎ MVS(TM) É¢äÆ Ë·ÜÓ¡¤ MVS ÄØÝ· z/OS åôßС¤ DB2 UDB for AIX 4.3.3¡£5.1 ůÅèĸÎêÆÛëæÓÑ AIX C++ ÜÉ 6 Îê Runtime DB2 8.1.4 Îê (ůÅèĸÎêÆÛ) for AIX 4.3.3 Îê¡£5.1 ÎêůÅèĸÎêÆÛëæÓÑÇã AIX Ë·ÜÓĸÇøæÒ AIX C++ ÜÉ 6 Îê Runtime óòÕùÕ»¡¤Ú·Ä¶ÇÄê½×»Ä¶ç¥ 2003 È¡ 3 ÅÌÎû C++ Runtime PTF ÊÕ仡¨ http://www-1.ibm.com/support/docview.wss?rs=0&q=xlC.rte&uid=swg24004 427 &loc=en_US&cs=utf-8&cc=us&lang=en ÇãËðÆî DB2 8.1.4 ÎêÍÐÊÕä»ÎêÆÛÄæЩ¡¢îùò×ߧǿЩÇÄÅøÄæê½×»ÍÔßÈËòÎûÇøæÒÑÀ Æü¡¤ Çô̽ Java ÇÁÆîóòÕùÕ» (Linux) Ó¼ÓÑÙÚÈç Java óÃÇôá£Ê©ÍÐËðÆîϯÌùåøÎûÌªí°¡¢LinuxÙÚÈçÕëßæù¹á¸ðÂÆÒâü×äÙÜÇô ̽ÖÖÌùÎû Java ÇÁÆîóòÕùÕ»¡¢Åâ DB2 UDB ÆÒâü×äÙÜÇÑÕëç¥Ä«ÝÕËèóòÕùջů Java áðóéñ¢ð¡¤ÇÞÒ³âÐÈçÝÕÔ¶ç¥Ä«Îûá£È¢äÄÅè setuid ÙñÆîûâÙÚÈç¡¢ÍÔÅèÆÆÇã /usr/lib ÆøòçÄãÆ·äÄÞòÊÆÒÞËíóòÕùÕ»¡¤ â¡: ÆÛÅä÷îÑÀÅøÚÀëæÓÑù¹á¸ÎûÓìÓÑÇÁÆîóòÕùÕ»¡¤ÕüðãÚÀÆßÇãÐúåôůÙÚÈçÎûóÜÆîᣠȢ¡¢ÚÀÆ«×äëæÓÑù¹á¸ÈÝ̧ÅìÇÁÆîóòÕùÕ»¡¤ Çã /usr/lib ÆøòçÄãÐúÇ¡ÑÀÇ× Java ÇÁÆîóòÕùÕ»ÎûÜÊæÀù¹á¸¡¤ Ó¼Ò³ IBM Developer Kit 1.3¡¢ÚÀëæÓÑÑÀÇ× libjava.so¡£libjvm.so ů libhpi.so ÎûÜÊæÀù¹á¸¡¤ÚÀÆ«Ýàç´ root ËÎÅ¡ÙÚÈçĶÇÄÌÔÅïËôÐúÇ¡ÜÊæÀù¹á¸¡¨ cd /usr/lib ln -fs JAVAHOME/jre/bin/libjava.so . ln -fs JAVAHOME/jre/bin/classic/libjvm.so . ln -fs JAVAHOME/jre/bin/libhpi.so . ̧Äã JAVAHOME ÑÒ SDK ÎûÙ×öðÆøò硤ÇñΪ DB2 UDB ÊÆÄâ̯ÝÕËèóòÕùÕ»¡¢Ð¬ÇãÚÀ è©æÜÙÚÈç Java ڦȢÕëÞóäÄȭ̯ -4301 òã먡¢Åâê§Ü¡Ý×Ï¡ÅÊë¢ÄãľȴäÄÈ´ùÃÍõÊÆ Äâ̯óòÕùÕ»ÎûعÕÉ¡¤ â¡: ßåÅîÎûÅÉÎÎÞóÑÒÙò Java ÇÁÆîóòÕùÕ»ä»ìÁÈÝ /etc/ld.so.conf óò¡¢ÈÔÄâÑÒÇã /usr/lib ÆøòçÄãÐúÇ¡ù¹á¸¡¤ÇñΪÚÀÝÕíµØø¡¢Ð¬ÇãüÈÊÕ /etc/ld.so.conf óòÕùÄæÑ¥¡¢ÚÀÆÒâüÅè root ËÎÅ¡ÙÚÈç ldconfig ÌÔÅï¡¢ÉÁЬ¡¢ÆÆÙòàÒÕæ¡¢ ÇÞҳڦȢÎûÌËƵÙòàÒÎÎÉùÈ©¡¤ÝÕÔ¶ßåÅîÅÉÎÎÆ«×äÇãÖÖÌùÎûèÒËóÄãÄóàÓàÒ Õæ¡¢ÇÑÕëľäÄÝßȩڦȢàÒÎÎÉùÈ©¡¤ÇñΪßåÅîÅÉÎÎàÒÕæ¡¢îùѺäùǿЩÎûÑÀ Æü¡¢Çã /usr/lib ÆøòçÄãÐúÇ¡ù¹á¸¡¤ ެǹůߦåô (Linux 390) åµÚÀËðÆî Linux 390 É¢äÆË·ÜÓÕ롢ƫ×äàÒÎÎËðÆîÇéÔ¶éöÚ§æÒåôËôâÐÈçެǹůߦ åô¡¤ ERwin 4.x ÄãâææñÕèðýÚÙð ERwin ÄãâææñÕèàÒÎÎã¾Ä« Linux É¢äÆË·ÜÓ¡¤ ERwin 4.x ðýÚÙðÂÆ«Çã Windows 98 ů WinME ĸ̿ÅÅßΡ¢ÈþȴĶÇÄÓî̱¡¨ * db2erwinimport ÌÔÅïã¯×äÚ· DB2 ÌÔÅïÈçݨܡðÂÙÚÈ硤 * ÚÀÆÒâüÉùðìÌùåø -x êØ -t Ù¶í°Îû XML êØØÑ÷ÇóòÕùÇØꢡ¤ Åè Hummingbird Exceed Çô̽¡ÖâäàõÄãÅÀ¡×ÕëÚöÆîóôáþàëÓòØôï÷ Çã UNIX(R) ĸÅè Hummingbird Exceed Çô̽¡ÖâäàõÄãÅÀ¡×Õë¡¢ÆÒâüÇ¿ÚöÆî XTEST öÄÅò 2.2 Îê¡¢Äß×äÇã¡ÖâäàõÄãÅÀ¡×ÄùÍîÜÃóôáþàëÓòÎûíº÷îÇÄ¡¢ÅèÜÃٯůØôï÷óôáþ àëÓò¡¤ Ó¼ÓÑÚöÆî XTEST öÄÅò¡¨ 1. Ú·¡ÖâäÌî¡×Åü×äÏÐÄãòÙ̽á£È¢ -> Hummingbird Connectivity 7.0 -> â¾Åø -> XConfig¡¤ÝÕÕëäÄâäÚö XConfig áþ᧡¤ 2. òÙÆîâúÆø¡¨Ó¼ÚÀÎûØÙåôëæÓÑÙï¢îùòÓÄ« XConfig Ùï¤ 3. Ѻ̥ĶÝ×ع̶Ìùè·Æü¡¤ÝÕÕëäÄâäÚö¡ÖÝ×ع̶Ìù¡×áþ᧡¤ 4. òÙ̽ X ÒÞÜÊàÁæÜÒÞÕ©ÍÌÅ¥òÙÕú¡¤ 5. ÇãÝ×ع̶Ìùáþá§Ä㡢ѺġĶöÄÅò... ѺâÚ¡¤ÝÕÕëäÄâäÚö¡ÖÝ×ع̶ÌùöÄÅò¡×áþ ᧡¤ 6. Çã¡ÖÚöÆîöÄÅò¡×ÛÒÞÌÄã¡¢òÙ̽ XTEST(X11R6) Å¥òÙÕú¡¤ 7. ѺġĶíýÌù¡¤ ÇøæÒ¡£ÜÃ÷Ë¡£Åª×ÈůØÙåôæñع ÇøæÒæñع ÇøæÒ DB2 UDB (AIX) ÇñΪڷæûÕÀÄãÉÖȴϨÆõÎûÆøòçÙÚÈç db2setup á£È¢¡¢ÇøæÒÙòÆÂÚõÅâÅøܢĶÇÄòã먡¨ : not found ÙòÆ«ÇøæÒÎûÑÐçùóòåôÍõæûÕÀÄãÊôȴϨ֪ÎûÆøòçĶ¡¤ ÇøæÒ DB2 UDB (Linux) åµÚÀÇã Linux ĸÇøæÒ DB2 Universal Database 8.1 ÎêÕë¡¢Åè RPM Ò³Ù×öðÎûÇø æÒäÄè©æÜÇøæÒ IBM Java RPM (IBMJava2-SDK-1.3.1.-2.0.i386.rpm)¡¤ÇñΪÄØÈ´ ç¤ØíìÒȹÎû RPM (Çñ IBMJava2-SDK-1.4.0.-2.0.i386.rpm)¡¢Ð¬ÄâäÄÇøæÒЩġÎêÎû RPM¡¤ àÓÈÔ¡¢ÇãȺÚÅÎÓĶ¡¢ÇøæÒäÄüé JDK_PATH æñÕèÕ»ØÙåôÙ¶í°ÑÀÇ× Java 1.3 æûÕÀ /opt/IBMJava2-13/¡¤á¸Îª¡¢ÙòÊôȴǶÈô Java ÒÞËíÅü×ä (ÅýÑÄ¡ÖDB2 ÄÖ̦ÐÎòç¡× ÇøæÒ) ×äÙÜçªÉ¢¡¤ Ó¼ÓÑæØÊîȺÙÂ÷î¡¢îùÅèèÒËóðßȴϯÎûËÎǹÙÚÈçĶÇÄÌÔÅ db2 update dbm cfg using JDK_PATH /opt/IBMJava2-14 ÇñȺäÄÙò DB2 Universal Database ÑÀÇ×ÆßíýÎû IBM Developer Kit¡¤ ÇøæÒ̧ÅìËéÑúÇóÐÎ (Linux) IBM ßÈËòïËÆîÍõ Linux Îû̧ÅìÇóÐÎæñÕèÅý¡¢Ì§ÄãÉÖÈ´ËéÑúÇóÄ÷Îû̧Åì÷äÈíÄ÷ÜÚÇó âõ (DBCS) ÅÅßΡ¤ÑÜËèÎêÆÛÎû Linux Æ·ÇøæÒħüÏÆüÙÏÕ¥ÙñÆîÍÐÙ´ÙÑÙñÆîÇóÄ÷ÍÔëæ ÎûÆÒÓÑÇóÐΡ¢ÇÞȺÆÒâüÇøæÒÝÕËèÇóÐÎæñÕèÅý¡¤ ÇñΪÚÀÇãÙÚÈç db2setup ÌÔÅïÕëàõÜ¢ DB2 ÇøæÒê´üñÄõÓòĸòÜéÅħÇóÄ÷¡¢ÝÕÆ«×äÑÒ ÚÀÎû Linux Ë·ÜÓÌþÆÜÇøæÒÍÔÈ´ÆÒÓÑÎûÇóÐΡ¤Ó¼ÓÑüé db2setup ×äïËåµÇâÙ¶äùÇøæÒ CD ÄùÉÖÎûÇóÐΡ¢îùÙÚÈçĶÇÄÉ¢äÆ¡¨ 1. òÓīĶÇÄÌÔÅ export JAVA_FONTS=//db2//java/jre/lib/fonts ̧Äã ÑÒÇøæÒÑÐçùóòÎûÈíåô¡¢ ÑÒ̦ȴ Linux ÇóÓû ÎûÆøòçÇØꢡ¤ 2. Óìä»ÙÚÈç db2setup ÌÔÅ ÇøæÒÑ¥¡¢ÇñΪÚÀÇãËðÆî DB2 GUI ÄÖ̦ÕëàõܢȴòÜéÅÇóÄ÷ÎûÚÅÊ°¡¢îùÇøæÒ DB2 ܨ ÐÂòñÏáÎûÆÒÓÑÇóÐΡ¤Ä¶ÇÄ CD Îû fonts ÆøòçĸÝçÆ«ÅèÊÆ̯ÝÕËèÇóÐΡ¨ * IBM Developer Kit, Java Technology Edition, Version 1.3.1 for AIX operating systems on 64-bit systems * Java application development and Web administration tools supplement for DB2, Version 8.1¡¤ ÇãȺÆøòçÄ㡢ȴ̥ê¡ÇóüÕÆ«ËòËðÆTimes New Roman WorldType ů Monotype Sans Duospace WorldType¡¤ØÜè×ÊäÄ¡ê¡ÇóüÕ¡¢ÇÖÈ´Ä¡ê¡ÙÏÕ¥ÍÐÙ´ÙÑÙñÆîÇóÐΡ¤Ä¶ ÏÐÇÄÅø fonts ÆøòçÄãÅèóÌôã֪ȢÍÔßÈËòÎûĬê¡ÇóÐΡ¤ ÏÐ 4. ̧ÅìËéÑúÇóÐÎÎûóòÇØ +-----------------------+----------------------+----------------------+ | ÇóÐÎÇóüÕ | ÇóÐÎóòÇØ | ÙÏÕ¥/Ù´ÙÑ | +-----------------------+----------------------+----------------------+ | Times New Roman WT J | tnrwt_j.zip | ÅÊÆÛů̧ÅìÙÏÕ¥/Ù´ÙÑ | +-----------------------+----------------------+----------------------+ | Times New Roman WT K | tnrwt_k.zip | ö§ÙÏ | +-----------------------+----------------------+----------------------+ | Times New Roman WT SC | tnrwt_s.zip | ÄãÙÏ (öüüÕÄãÅÆ) | +-----------------------+----------------------+----------------------+ | Times New Roman WT TC | tnrwt_t.zip | ƺý¤ (ôíüÕÄãÅÆ) | +-----------------------+----------------------+----------------------+ | Monotype Sans | mtsansdj.zip | ÅÊÆÛů̧ÅìÙÏÕ¥/Ù´ÙÑ | | Duospace WT J | | | +-----------------------+----------------------+----------------------+ | Monotype Sans | mtsansdk.zip | ö§ÙÏ | | Duospace WT K | | | +-----------------------+----------------------+----------------------+ | Monotype Sans | mtsansds.zip | ÄãÙÏ (öüüÕÄãÅÆ) | | Duospace WT SC | | | +-----------------------+----------------------+----------------------+ | Monotype Sans | mtsansdt.zip | ƺý¤ (ôíüÕÄãÅÆ) | | Duospace WT TC | | | +-----------------------+----------------------+----------------------+ â¡: ÝÕËèÇóÐÎÄâäÄåôßÐË·ÜÓÇóÐΡ¤ÝÕËèÇóÐÎÆ«ÅèÄ¡ØÄËðÆîÍÐêØ DB2 Universal Database ä®ØÙËðÆÚÀÄâ×äè×ÝÕËèÇóÐÎÚ·ËçÄ¡×ïÍÐàÒÓî̱ÎûïÚÙÇÍÐÅ¡ØÊ¡¤ Ó¼ÓÑÇøæÒÇóÐΡ¨ 1. æØóÌôãÇóÐÎæñÕèÅý¡¤ 2. ÙòÇóÐÎæñÕèÅýîïêû̯ /opt/IBMJava2-131/jre/lib/fonts Æøò硤ÇñΪȺÆøòç ÄâÇôÇ㡢ЬÆÒâüÐúÇ¡ÆÆ¡¤ 3. òÓīĶÇÄÌÔÅ export JAVA_FONTS=/opt/IBMJava2-131/jre/lib/fonts ÚÀÈÝÅ·ÆÒâüØÜè×ÚÀÎûÙÏÕ¥ÍÐÙ´ÙÑÎûÊäÄ¡ê¡ÇóüÕÇøæÒÄ¡ê¡ÇóÐΡ¤ÇñΪÚÀÑÒÇãÄãÙÏ¡£ ö§ÙÏÍÐê×ý¤¡¢îùËðÆîÙÏÕ¥ÙñÆîÍÐÙ´ÙÑÙñÆîÎêÆÛ¡§ÉÁЬ¡¢îùËðÆîÇóÐÎÎûÅÊÅÆÎêÆÛ¡¤ ÇñΪ˷ÜÓÄãȴϨâæ¡¢îùĬê¡ÇóÐÎÇÀÝåÇøæÒ¡¤ ËðÆî db2setup ÌÔÅïä»ìÁܨÐÂÎûÓî̱ Ä¡ÆÙÇøæÒħ DB2 ܨС¢ÞóÆ«Åèä»ìÁ̧Åì DB2 ܨС¤ÇñΪËðÆî db2setup ÌÔÅïËô ä»ìÁܨС¢Ð¬ïËÆîĶÇÄÐúú¾Å¯Óî̱¡¤ Ðúú¾ ÄØÇøæÒÎûܨÐÂůÓÑä»ìÁÎûܨÐÂóÜæÚÈ´ÒÞÇÑÎûá£È¢î£ìÒȹ¡¤ËóÇñ¡¢ÄØåîÇøæÒ DB2 ESE Server ÜÉ 8 Îê FixPak 5¡¢ÅâÚÀã÷ÓÑä»ìÁ DB2 Information Integrator ܨС¤ ÇãȺÚÅÎÓĶ¡¢ DB2 Information Integrator ľóÜæÚÒ³ÜÉ 8 Îê FixPak 5 ìÒȹ¡¤ Óî̱ * ÇñΪ DB2 fixpak ìÒȹØíÍõÓÑä»ìÁÄæܨÐÂÎû fixpak ìÒȹ¡¢ÝÕê¡ÜÚÇÙÑÒÄøÝ Îû¡¤àÓÈÔ¡¢ÆñÍõÆßÓÑä»ìÁÄæܨÐÂÎû fixpak ìÒȹɥÍõ DB2 fixpak ìÒȹ¡¢ÇÞȺ ÇãÇøæÒ̧ÅìܨÐÂÄæÑ¥¡¢ÆÒâüÓìä»ÔïÆî DB2 fixpak ìÒȹ¡¤Ó¼ëæÓìä»ÔïÆî fixpak ÎûÑÀÆü¡¢îùÙ¶ïåïËåµÎû FixPak Readme¡¤ * ÇñΪ DB2 fixpak ìÒȹɥÍõÓÑä»ìÁÄæܨÐÂÎû fixpak ìÒȹ¡¢ÙòܨÆíÄ¡Ô¶òã먡¤ ÆßÓÑä»ìÁÄæܨÐÂÎû fixpak ìÒȹÄâ×äØíÍõ DB2 Îû fixpak ìÒȹ¡¤ÇãȺÚÅÎÓ Ä¶¡¢ÓûÇ¿ÚÀÆÒâüÙò DB2 Ū×ÈÈÝïËåµÎûìÒȹѥ¡¢Äß×äÇøæÒ̧ÅìܨС¤Ó¼ëæÑÀ Æü¡¢îùÙ¶ïåïËåµÎû FixPak Readme¡¤ ĶÏÐãðôê db2setup ÜÚÇÙ¡¨ ÏÐ 5. db2setup ÜÚÇÙ +----------+--------------+-------------------------------------------+ | DB2 | ̧ÅìܨР| ÑÒÉÁÄøÝÂÝÕÔ¶ÜÚÇÙ¡© | | fixpak | fixpak ìÒȹ | | | ìÒȹ | | | +----------+--------------+-------------------------------------------+ | ÜÉ 8 Îê | ÜÉ 8 Îê | ÑÒ¡¤ÝÕÑÒÐúú¾Îûٯɢ¡¤ | | FixPak 3 | FixPak 3 | | +----------+--------------+-------------------------------------------+ | ÜÉ 8 Îê | ÜÉ 8 Îê GA | ÑÒ¡¢ÈþÆÒâüÓìä»ÔïÆîÜÉ 8 Îê FixPak 3¡¤îùÝß | | FixPak 3 | | ݾ¡ÖDB2 ÅÅßΡ×ê½×»¡¢ Ù¶ïåïËåµÎû FixPak Re | | | | adme¡¢Åè̽ڵÓìä»ÔïÆî fixpak ÎûÑÀÆü¡¤ | +----------+--------------+-------------------------------------------+ | ÜÉ 8 Îê | ÜÉ 8 Îê | ÉÁ¡¤ÇãÇøæÒ̧ÅìܨÐÂÄæЩ¡¢DB2 ÆÒâüǿŪ×ÈÈÝ | | FixPak 3 | FixPak 5 | ç¤ØíÎûÔºÆßÔïǵìÒȹ (ÇãȺî¯ËóÄã¡¢ÜÉ 8 Îê | | | | FixPak 5)¡¤ îùÝßݾ¡ÖDB2 ÅÅßΡ×ê½×»¡¢Ù¶ïå | | | | ïËåµÎû FixPak Readme¡¢Åè̽ڵÇøæÒÆÒÓÑÜÉ 8 | | | | Îê FixPak ÎûÑÀÆü¡¤ | +----------+--------------+-------------------------------------------+ ¡ÖDB2 ÅÅßΡ×ê½×»Îûê½ÉßÑÒ http://www.ibm.com/software/data/db2/udb/winos2unix/support Ķç¥ËäæØóÌôã Spatial Extender FixPak Ú· DB2 V8 for Windows Fixpak 3 âäÌî¡¢IBM ßÈËòܨÐÂÙñúèÎû FixPak¡¢ÈÔÏæÄ¡ ×ïÎû FixPak¡¤ÝÕÔ¶üÈÊÕÆ·è× Windows ÆÍƺĸÎû DB2 ÜÉ 8 ÎêܨÐÂÈ´ìàûÀ¡¤ ÇñΪÄØÇãÒÞÇÑË·ÜÓĸÇøæÒħ DB2 ÜÉ 8 Îêů DB2 Spatial Extender for Windows¡¢Ð¬ÚÀÆÒâüÄ¶ç¥ DB2 FixPak ÑÐçùóòů Spatial Extender FixPak ÑÐçù óò¡¢ÈÔÅâÆÒâüÙòÊäÄ¡Ô¶ÑÐçùóòæØóÌôãÈÝÇÁÇÑÎûÆàÆøòçÄæĶ¡¤Ó¼ÓÑ GUI ÇøæÒůàÒôø ÈÜÙ¯ÇøæÒ×äÙÜâÐÈç¡¢ÆÒâüæØóÌôãÍÔÈ´ÑÐçùóò¡¤ Ó¼ëæÉùðì FixPak ÇøæÒÑÀÆü¡¢îùÙ¶ïå DB2 ÜÉ 8 Îê FixPak 6 Readme¡¤ ÇãÔïÆî fixpak ÄæÑ¥ÝÙḠQuery Patroller æñÕèÅý ÇñΪÄØÇøæÒ Query Patroller¡¢Ð¬ÇãÔïÆî fixpak ËäÙÚÈçÍÔÈ´Ñ¥åô fixpak ÇøæÒ É¢äÆÄæÑ¥¡¢îùÙÚÈçĶÇÄÊãüõ¡¨ 1. Åè̦ȴ DBADM ûâÓîÎûËðÆîϯËÎÅ¡ËôàôÄ«¡¤ 2. Å¢ßÐÈÝïËåµÎûÆøò硨 * INSTPATH/bnd (Linux ů UNIX) * INSTPATH\bnd (Windows) ̧Äã INSTPATH ÑÒ DB2 UDB èÒËóæûÕÀ¡¤ 3. ÙÚÈçĶÇÄÌÔÅ db2 connect to dbname db2 bind @qpserver.lst blocking all grant public Çã FixPak 3 ìÒȹÍÐÊÕä»ìÒȹÄãÇøæÒ Query Patroller Query Patroller ÑÒÄ¡ê¡Ñçææê§Ü¡Ë·ÜÓ¡¢ÆîËôÚÕ̱ DB2 UDB æñÕèÕ»ÎûÑçææÈëÑü¡¤ Çã DB2 UDB 8.1.2 ÎêÄã¡¢DB2 Query Patroller üÈȩħñÁÇ¡ÎûܨС¤ÆÆÄâÇÂÑÒ DB2 Warehouse Manager ÎûÄ÷ǵ¡¤ ÇñΪÄØÇøæÒ DB2 ÜÉ 8 Îê FixPak 3 ÍÐÊÕä»ÎêÆÛ¡¢ÅâÚÀÙòÇøæÒ DB2 Query Patroller Ù×ÆÛÍÐ GA ÎêÆÛ¡¢Ð¬ÚÀÆÒâüÓìä»ÔïÆî DB2 UDB FixPak 3 ÍÐÊÕä»Îê ÆÛ¡¤ÉÁЬ¡¢Query Patroller üÈÊÕÄâäÄÔïÆîÈÝÚÀÍÔÇãÎû DB2 UDB FixPak ìÒȹ¡¤ ÇñΪÚÀÆßÓÑÇøæÒ Query Patroller ÈùΤð¡¢Ð¬Ä¾âüÇãÓìä»ÔïÆî DB2 UDB FixPak ìÒȹÄæÑ¥¡¢ÊÕä» DB2 èÒËó¡¤ÇãÊÕä»èÒËóÄæÑ¥¡¢ÆÒâüÓìä»ÚöÙ¯ÆÆÔ¯¡¤ DB2 Web ÄÖ̦ Ó¼ÑÒËðÆîĶÇÄë£ËÆ¡¢ËÛëûÆñ¡ÖDB2 Web ÄÖ̦¡×ÍÔÅÅßÎÎûóÜÆîá£È¢ÈùΤðÂÞóÆÒâüÜÊÇÙ Servlet 2.3 ݽ֪¡¨ * ÅÊÅÆ * ö§ÅÆ * öüüÕÄãÅÆ * ôíüÕÄãÅÆ * ÏúÅÆ * ÎÌû¢ÅÆ Ò³ÇøæÒßæâæÄâÑÒòÙâúÎûë£ËÆÇøæÒ DB2 æñعÄãÅÀ ¡ÖDB2 ÇøæÒ¡×ê´üñØÜè× DB2 HTML ÅÆǵÇøæÒÎûë£ËÆÎêÆÛ¡¢ã¯ÓîÍõêØ DB2 ܨÐÂÄ¡ÇÑ ÇøæÒÎûë£ËÆ¡¤ÇÞȺ¡¢àÒÎÎËðÆî¡ÖDB2 ÇøæÒ¡×ê´üñÇøæÒĶÇÄë£ËÆÎû DB2 HTML ÅÆǵ¡¨ * æ¹áëÅÛÅÆ (㯠UNIX ȴȺÓî̱) * ÄåÞ§ÅÆ¡£ÏÅû¢ÅÆ¡£ÕáÐäÅÆ¡£å¯Ì¨ÅÆ (㯠Linux ȴȺÓî̱) * Ý£û¢ÅÆ¡£ÄÈÈÖ̧ÅÆ (㯠HP-UX¡£Solaris¡£Linux ȴȺÓî̱) * ÏßÍÖɤÅÆ (㯠UNIX ȴȺÓî̱) Ó¼ÓÑÇøæÒǿЩÇÄÅøÄæ̧ÄãÄ¡ê¡ë£ËÆÎû¡ÖDB2 æñعÄãÅÀ¡×¡¨ 1. Ùò DB2 HTML ÅÆǵ CD ßÆīǼé÷ñ¢¡¤ 2. îïêûĶÇÄÆøòç̯çÙ檡¨ * /cdrom/program files/IBM/SQLLIB/doc/htmlcd/language ̧Äã cdrom Ò³ÚÀæÒç¥ CD ÎûÇâÅÉ¡¢language Ò³ÚÀÍÔÓÑËðÆîÎûë£ËÆÇó¤ æñÕèÉèÓÑÍóÇãÔáæÓÝçÆ«Å衤ÚÀÇ©Æ«ÎþÚÙÚ· CD óôáþ DB2 HTML ÅÆǵ¡¤È´ùÃÇñÈôÎþ ÚÙÚ· CD óôáþ DB2 HTML ÅÆǵÎûÑÀÆü¡¢îùÙ¶ïåǶġ DB2 ÜÉ 8 ÎêÅÃÅõÏáòçÄãÎû ¡ÖÎþÚÙÚ· DB2 HTML ÅÆǵ CD îÀĸóôáþÊÀÝ´æñع¡×Åä÷ â¡: 1. Ó¼ÓÑóôáþÅÆǵ¡¢ÚÀÆÒâüËðÆî Microsoft Internet Explorer 5.0 ÍÐÊÕä»ÎêÆÛ¡¢ ÍÐËðÆî Netscape 6.1 ößûªðÂÍÐÊÕä»ÎêÆÛ¡¤ 2. ÇÑíµÇâ¡¢ÇñΪÚÀÚ·ÚÀÎûܨÐÂÚöÙ¯ÅÆǵÎûæã¡¢ÙòæüÈÝɢҳܨÐÂÇøæÒÄ¡ÝåǹËôÇøæÒ ÎûÅÆǵ¡¢ÈÔÏææüÈÝÚÀÅèÅÃÙ¯ÅÉÈ¢îïêûÎûÅÆǵ¡¤ DB2 Universal Database ÜÉ 8 Îê HTML ÅÆǵÇøæÒÓî̱ (Windows) Çã Windows ĸ¡¢îùŦÇãÄØÇøæÒ DB2 Universal Database ÜÉ 7 Îê (ÍÐÊÕÈ®ÎêÆÛ) ܨÐÂÎûÄÖÉ¢×»ÍÐÈùΤðÂÇøæÒ DB2 Universal Database ÜÉ 8 Îê HTML ÅÆǵ¡¤ÇøæÒ á£È¢äÄØþàÁ÷®ÎêÆÛËäÜÃØæ÷®Ü¨Ð¡¤ Ò³ÙÏÕ¥ë£ËÆÎêÆÛÎû DB2 UDB ÇøæÒ MDAC óòÕù ÇñΪÚÀÇãÇøæÒ DB2 8.1 ÎêÎûÙÏÕ¥ë£ËÆÎêÆÛÄæЩÊôÈ´ÇøæÒ Microsoft Data Access Components (MDAC) 2.7 ÎûÙÏÕ¥ë£ËÆÎêÆÛ¡¢Ð¬ DB2 Universal Database ËíçßÝà äÄÇøæÒÓÁÅÆÎêÎû MDAC óòÕù¡¤ÇñΪÚÀÎûÉ¢äÆË·ÜÓÄâÑÒÓÁÅÆÎê¡¢ÝÕäÄðÒÓ³¡ÖWindows ODBC æñÕèËôäãê§Ü¡ÔÞ¡×àëÓòÅøÜ¢ÆÜ÷©úÁÎûÄùÕ©¡¤Ó¼ÓÑÔºÆßȺÙÂ÷î¡¢îùÇøæÒËôÈÜ Microsoft ê½×»Îû "MDAC 2.7 RTM - Refresh" ÝÔüÕÜÚ¡¢ê½ÉßÒ³ http:// msdn.microsoft.com/data/downloads/updates/default.aspx¡¤òÙðåÚÀÓÑÇøæÒÎû ë£ËÆ¡£Ä¶ç¥ÆÒÓÑÎûÆ«ÙÚÈçóò¡¢àÓÑ¥ÙÚÈçÆÆ¡¤ÇñȺÙòäÄÇøæÒ÷©úÁÎû¡ÖODBC æñÕèËôäã ê§Ü¡ÔÞ¡×óòÕù¡¤ ÜÃ÷Ëæñع ËðÆî DataJoiner ÍÐʽìÑÕëÎû DB2 Universal Database ÜÃ÷Ë Ó¼ÓÑÜÃ÷ËÄ¡Ô¶ÚÀÙÚÈç DB2 Universal Database ʽìÑÄæ¡ÖöÊ̽á£È¢¡×ÍСÖÅ¿ÆîᣠȢ¡×Îû DataJoiner(R) èÒËóÍÐ DB2 Universal Database for Linux¡£UNIX ů Windows èÒËó¡¢ÚÀÆÒâüÇ¿äíÞ¬ÇïÓÑÜÃ÷ËʽìÑô¿èº¡¢Äß×äÜÃ÷Ë DB2 Universal Database ÍÐ DataJoiner èÒËó¡¤ÙÚÈçÆÒÓÑäíÞ¬ÄÖÉ¢ÎûæÛÜØÑÀÆü¡¢ÅýÉÖÇã DB2 DataPropagator(TM) ÜÉ 8 ÎêÎûÜÃ÷ËÅÆǵÄ㡤 DB2 DataPropagator ÜÉ 8 ÎêÎûÜà ÷ËÅÆǵƫÅèÇãĶÇÄê½ÉßÄãÊÆ̯¡¨http://www.ibm.com/software/data/dpropr/¡¤ Ùò DB2 ÜÉ 8 Îê Windows 32 ÈíÄ÷æñÕèÕ»ÜÃ÷ËÈÝ Windows 64 ÈíÄ÷ ÆÛÅä÷îÇÄÅøÙò 32 ÈíÄ÷çÙæªÄ¸Îû 32 ÈíÄ÷ DB2 ÜÉ 8 ÎêæñÕèÕ»ÜÃ÷ËÈÝ 64 ÈíÄ÷ Windows É¢äÆË·ÜÓĸ 64 ÈíÄ÷æñÕèÕ»ÎûÊãüõ¡¤ Ç¿Êî۾ǵ * 64 ÈíÄ÷ÎêÆÛÎû DB2 ÜÉ 8 ÎêÆÒâüÇøæÒÇã 64 ÈíÄ÷çÙæªÄ¸¡¤ * îùíýÌù 32 ÈíÄ÷ Windows Ë·ÜÓÑÒÙÚÈç DB2 ÜÉ 8 Îꡤ á£Ê© Ó¼ÓÑÜÃ÷ËÈÝ Windows 64 ÈíÄ÷ĸÎû DB2 ÜÉ 8 Îꡨ 1. Çã 32 ÈíÄ÷ Windows Ë·ÜÓĸެǹ DB2 ÜÉ 8 ÎêæñÕèÕ»¡¤ 2. Çã 64 ÈíÄ÷ Windows Ë·ÜÓĸߦåô DB2 ÜÉ 8 Îêެǹ (Êãüõ #1 ÄãÍÔÐúÇ¡)¡¤ â¡: ØæħÙò DB2 UDB Ú· 32 ÈíÄ÷Ë·ÜÓÜÃ÷ËÈÝ 64 ÈíÄ÷Ë·ÜÓÄæÆÀ¡¢Ä¶ÇÄÜÃ÷ËľÑÒÈ´ Æ«×äÎû¡¨ * Windows ÎêÆÛâæÎûÜÃ÷Ë * DB2 UDB ÎêÆÛâæÎûÜÃ÷Ë * ġȹÜÃ÷ËÍÔÈ´âúÆø * ÜÃ÷ËÇß 32 ÈíÄ÷ ĶÇÄ IBM Redbook ßÈËòÈ´æÛÜØæñع¡¨Scaling DB2 UDB on Windows Server 2003¡¤Èº Redbook ÈíÍõĶÇÄ URL¡¨ http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg247019.html Ú·÷®ÎêÜÃ÷Ë XML Extender ÇñΪÚÀËðÆîÎûÑÒ÷®Îê DB2 XML Extender¡¢Ð¬ÇãËðÆî̦ȴ XML ×äÄ°ÎûÜ¢ÇôæñÕèÕ» êØÊÕä»Îû XML Extender Îêȹä®ØÙÄæЩ¡¢ÚÀÆÒâüÜÃ÷ËÊäÄ¡Ô¶ØÜè× XML Extender ÚöÆîÎûæñÕèÕ»¡¤ÊäÄ¡ä»ÎûÔºÆßÔïǵÝçÅýÉÖÍÔȴǿЩÎûÔºÆßÔïǵÊÕ仡¤ Ó¼ÓÑÜÃ÷Ë̦ȴ XML ×äÄ°ÎûæñÕèջů̦ȴ XML ×äÄ°ÎûÎþúñ¡¢îùÉùȩĶÇÄÊãüõ¡¨ 1. Çã DB2 ÌÔÅïÈçÄãòÓÄ«¡¨ db2 connect to database_name db2 bind dxxinstall/bnd/@dxxMigv.lst db2 bind dxxinstall/bnd/@dxxbind.lst ̧Äã dxxinstall ÑÒÚÀÇøæÒ DB2 Universal Database ÎûÆøòçæûÕÀ¡¤ 2. Çã DB2 ÌÔÅïÈçÄãòÓÄ«¡¨ dxxMigv database_name æñÕèÕ»ÜÃ÷Ë (HP-UX on IA64) è×Íõ DB2 UDB for HP-UX on IA64 ÈÔËÆ¡¢8.x ÎêË·ÇÄÄâÅÅßÎæñÕèÕ»ÜÃ÷Ë¡¤ DB2 UDB for HP-UX on IA64 ĸÄâÅÅßÎÙòÜÉ 7 Îê DB2 ެǹÑÐçùóòߦåô̯ÜÉ 8 Îê èÒËó¡¤ ÄØÏ¡Óî̱¡£ÙÂ÷î¡¢Åèůí²ÈçæØÊîÅÉÎÎ ÅèĶҳ DB2(R) Universal Database 8.1 Îê FixPak 6 ÄãÆøЩÄØÏ¡ÎûÓî̱¡£ÙÂ÷î ůí²ÈçæØÊîÅÉÎΡ¤ÆÛåçÄãÎûæñعã¯ïËÆîÍõ DB2 Universal Database(TM) 8.1 Îê FixPak 6 ů̧ÅÅßÎܨС¤ÍÔÈ´Óî̱ÄâËÄÚµïËÆîÍõÆÛܨÐÂÎû̧ÅìÎêȹ¡¤ Óî̱ ¡ÖâäàõÄãÅÀ¡×è× 64 ÈíÄ÷É¢äÆË·ÜÓÎûÓî̱ ¡ÖâäàõÄãÅÀ¡×ÄâÅÅßÎ 64 ÈíÄ÷ÈùΤðÂÎû Java óÃÇôá£Ê©Øæò㡤 64 ÈíÄ÷ Windows É¢äÆË·ÜÓÆ«ÅÅßÎ SQL óÃÇôá£Ê©ÎûØæò㡤64 ÈíÄ÷ÈùΤðÂÄâÅÅßÎâäàõ OLE DB ÍÐ XML ¡ÖËðÆîϯÌùåøÎûÌªí°¡×¡¤ âäàõÄãÅÀ (Linux) ¡ÖâäàõÄãÅÀ¡×Äâ×äÆîËôè×ǶÈô Linux àõÈçÎê (32 ÈíÄ÷¡£64 ÈíÄ÷¡£Intel¡£ zSeries ÍÐ iSeries) ĸÙÚÈçÎû Java(TM) óÃÇôá£Ê©âÐÈçØæò㡤 Øæòã̦ȴ÷äÅ¿æÀÎûóÃÇôá£Ê© ¡ÖIBM DB2 Universal Database âäàõÄãÅÀ¡×ÄâÅÅßÎè×ÍõóÃÇôá£Ê©ÇØꢡ£ê¾ÆøÍÐÖÖ ÌùÇØê¢Ä㡢̦ȴ÷äÅ¿æÀ (") ÎûǶÈôóÃÇôá£Ê©âÐÈçØæò㡤 üé Java ڦȢƫÇã¡ÖâäàõÄãÅÀ¡×î¾úÁÍÔëæÎûæûÕÀÝÃÌù ØæÏæ¡ÖâäàõÄãÅÀ¡×Ï¡ç¬ÚÀÎûâäàõÄ©ÔÞÔïǵÎêÆÛÇøæÒÍõÈôݨ¡¢ÉÁЬ¡ÖâäàõÄãÅÀ¡×àÒ ÎÎî¾úÁ Java(TM) ڦȢ¡¤åµÜÉġȹÚöÙ¯¡ÖâäàõÄãÅÀ¡×Õë¡¢âäàõÄ©ÔÞÔïǵÎûçßÝÃÆø òçäÄìÑÄ« $HOME/IBM/DB2DC/DB2DC.settings óò¡¤ÚÀÆ«ÅèÙòÝÕËèÆøòçîïêûÈÝ $USER.settings óò¡¢ËäÅè Unicode î¾òÒðÂÔºÊÑÄæ¡¢ÍÐÚÀÆ«ÇãçßÝÃÈíåôÐúÇ¡âäàõ Ä©ÔÞÔïǵÆøòçÎûÜÊæÀù¹á¸¡¤ ÇÑÕëÙÚÈçůØæòã Java óÃÇôá£Ê©Îû¡ÖâäàõÄãÅÀ¡×Óî̱ ¡ÖDB2 Universal Database âäàõÄãÅÀ¡×ÄâÅÅßÎÇÑÕëÙÚÈçůØæòã Java óÃÇôá£Ê©¡¤ Çã¡ÖâäàõÄãÅÀ¡×Äã¡¢ÚÀÆ«ÅèÇÑÕëÙÚÈçÇéÔ¶ Java óÃÇôá£Ê©¡¢ÍÐØæòãÞÌÄ¡ Java óà Çôá£Ê©¡§ÚÀàÒÎÎÇãØæòãƶġԶ Java óÃÇôá£Ê©ÕëÙÚÈç Java óÃÇôá£Ê©¡¤ËíçßÝᢠKEEPFENCED æñÕèÕ»ê§Ü¡á£È¢ØÙåôùÃõïÇóäÄÝÃÒ³Øæòã SQL óÃÇôá£Ê©ÍÔëæÎû KEEPFENCED=YES¡¤åµùÃõïÇó KEEPFENCED ̦ȴçßÝÃÔ« YES Õ롢ڦȢá£Ê©äÄÏñѽɢ ÆîÄã¡¢ÈÔÅâÙòàõÆí JVM ÙÕîíÒó¡¤Java óÃÇôá£Ê©ÙòðÒÓ³ JVM ܬڦÎíÎÓ¡¢ÈÔÅâåµËð ÆîçßÝà KEEPFENCED=YES æñÕèÕ»ê§Ü¡á£È¢ØÙåôÝÃÌùÕë¡¢ÝÕËèóÃÇôá£Ê©ÙòÇãĶÇÄǶ Ä¡ÚÅÎÓÄãàõÆíÆÂÚõ¡¨ * Çã¡ÖâäàõÄãÅÀ¡×Ðúåô Java óÃÇôá£Ê©¡¢àÓÑ¥ØæòãÆÆ¡¤ * åµØÄÌî Java óÃÇôá£Ê©ÄóÇãÙÚÈçÕ롢ȴġԶËðÆîϯÆßÇãÙÚÈç Java óÃÇôá£Ê©¡¢ ƶġԶËðÆîϯЬÆßÇãØæòã Java óÃÇôá£Ê©¡¤ * åµØÄÌî Java óÃÇôá£Ê©ÆßÇãØæòãÕ롢ȴġԶËðÆîϯÆßÇãØæòã Java óÃÇôá£Ê©¡¢ ƶġԶËðÆîϯЬÆßÇãÙÚÈç Java óÃÇôá£Ê©¡¤ Ó¼ÓÑæØÊîÝÕÔ¶Óî̱¡¢îùÙÚÈçĶÇÄÌÔÅïÅèíýÌù KEEPFENCED æñÕèÕ»ê§Ü¡á£È¢ØÙåôùà õïÇóÝÃÒ³ KEEPFENCED=NO¡¨ db2 update dbm cfg using KEEPFENCED NO db2stop db2start åµ KEEPFENCED ÝÃÒ³ NO Õë¡¢db2fmp á£Ê©ÙòÇã Java óÃÇôá£Ê©ÌËƵÉùÈ©ÕëùÃÝð¡¢ ÈÔÅâ DB2 UDB ÙòÚöÙ¯ä»Îû db2fmp á£Ê©ËôݨܡĶġԶڦȢÌËƵ¡¤ÇñȺƫÅèíýÌùåµ ÚÀâäÌîØæòã Java óÃÇôá£Ê©Õë¡¢ÙòÊôȴǶÈôÜ¢ÇôÎû JVM ݨÍõØæòãí¼È¢¡¤ Ó¼ÓÑÐúåô SQL óÃÇôá£Ê©âÐÈçØæòã¡¢ÅèůӼÓÑØæòã SQL óÃÇôá£Ê©¡¢Ð¬ëæÓÑ KEEPFENCED=YES ÝÃÌù¡¤åµ KEEPFENCED=NO Õë¡¢ÚÀÄóÆ«ÅèÐúåôůÙÚÈç SQL óÃÇôᣠʩ¡¢ÈþÑÒÚÀàÒÎÎØæòãÆÆÔ¯¡¤ Çã DB2 UDB for z/OS ÍÐ OS/390 ÈùΤðÂĸËðÆî LOB ÌùÈíð ÇñΪÚÀÆÔê«ËðÆî LOB ÌùÈíð¡¢ËôÇô̽ DB2 UDB for z/OS ÍÐ OS/390 ÈùΤðÂĸ DB2 UDB ÏÐÖªÄãÎû DBCLOB Îþúñ¡¢îùÇãËÛËèÈùΤðÂÎûÊäġԶĸÙÚÈç com.ibm.db2.jcc.DB2LobTableCreator ÄüÆîá£È¢¡¢ÐúÇ¡ßÈ̽ LOB ÌùÈíðÂÍÔëæÎû ÏÐÖª¡¤ DB2LobTableCreator ë£ÎÎ >>-Java--java com.ibm.db2.jcc.DB2LobTableCreator----------------> >---url--jdbc:db2:-//server--+-------+--/database---------------> '-:port-' >---user--user-ID---password--password--+-------+-------------->< '--help-' DB2LobTableCreator òÙâúë©Íü -url ÑÀÌù DB2LobTableCreator ÙòÇãÔáÄ¡Ô¶æñÕèËôäãÄãÙÚÈ硤 -url Ô«ÎûüÈí°Ýåǹ ÑÒ¡¨ jdbc:db2: ÑÀÅøÝÙîÀÑÒÈÝ DB2 UDB Ë·ÇÄÄãÎûÈùΤ𡤠server æñÕèÕ»ÈùΤðÂÎûê½ÙÑÇØê¢ÍÐ IP ÈíÉß¡¤ port ÑÀÌùá¿æñÕèÕ»ÈùΤðÂÎû TCP/IP ÈùΤðÂÙÕæÀ¡¤ÝÕÑÒÄõÍõ 0 êØ 65535 Äæâæ Îûðìí°¡¤çßÝÃÔ«ÑÒ 446¡¤ database æñÕèÕ»ÈùΤðÂÎûÇØꢡ¤ database ÑÒÇøæÒßæâæÍÔÌùåøÎû DB2 ÈíåôÇØꢡ¤ÈºÔ«ÄãÎûÍÔÈ´ÇóÄ÷ÝçâüÑÒ ÄËìÑÇóüÕ¡¤ÚÀÆ«ÅèÇãÈùΤðÂĸÙÚÈçĶÇÄ SQL ÝóÓÝÈ¢¡¢ËôɲÌùÈíåôÇØꢡ¨ SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1; -user ÑÀÌù DB2LobTableCreator ÙòÇãÔáÄ¡Ô¶ËðÆîϯ ID ĶÙÚÈ硤ȺËðÆîϯÆÒâü̦ȴ Çã DSNATPDB æñÕèÕ»ÄãÐúÇ¡ÏÐÖªÎûûâÓ -password ÑÀÌùËðÆîϯ ID ÎûÙï¤ -help ÑÀÌù DB2LobTableCreator ÄüÆîá£È¢ë©ÍüÆÆÍÔÅÅßÎÎûÊäÄ¡Ô¶òÙâú¡¤ÇñΪǶÈô̧ ÆÆòÙâúêØ -help Ä¡ØÄÑÀÌù¡¢ÙòÍÁÜ©ÆÆÔ¯¡¤ ÇãÝÙÚÙßæâæÞÞÉËÈ©ÅüàôÄ«ÕëÆÂÚõ (AIX) ÇñΪ AIX ĸËðÆî OS ûüɱ¡¢Ð¬ DB2 UDB äÄÇãÝÙÚÙßæâæâûɳÉùÈ©ûüɱÕë¡¢è©æÜÇ× AIX ÞÞÉËÈ©ÅüàôÄ«¡¤ÇãÜÉ 8 Îê FixPak 5 ÄæЩ¡¢ÇñΪ DB2 UDB àÒÎÎÞÞÉËÈ©Åüàô Ä«¡¢É»ËðËðÆîϯÝ×ç´ûüɱ¡¢ÝÙîÀÄóäÄÆÂÚõ¡¤Ú·ÜÉ 8 Îê FixPak 5 âäÌƫթÝÂú« úýÝÙîÀ¡¢ÈþäÄÙòÆÂÚõØ´òçÇã db2diag.log óòÄ㡤 JDBC ûÄÙ¯á£È¢Óî̱ (HP-UX) ¡ÖIBM DB2 Ý×Æî JDBC ûÄÙ¯á£È¢¡×àÒÎÎÝÙÚÙËÛËèËðÆî HP çßÝÃÇóâõ roman8 ÍÔÐú Ç¡ÎûæñÕèÕ»¡¤ÍÔÈ´ SQLJ ÅèůËðÆîÝ×Æî JDBC ûÄÙ¯á£È¢Îû JDBC óÜÆîá£È¢¡¢ÝçÆÒ âüÝÙÚÙ̯Åȩ̀ÅìÇóâõÐúÇ¡ÎûæñÕèÕ»¡¤Ó¼ÚÀÎû LANG ÝÃÒ³ C ÍÐ roman8 ë£ËÆô¿èº¡¢ ЬÆÒâüÙòÆÆÊÑÈ©ÒÞè×óÜÎû ISO ë£ËÆô¿èº¡¤ËóÇñ¡¢Ó¼ÚÀÎû LANG ÝÃÒ³ de_ DE.roman8¡¢Ð¬ÆÒâüËðÆîĶÇÄÌÔÅïÙòÆÆÊÑÈ© de_DE.iso88591¡¨ export LANG=de_DE.iso88591 Ó¼ÓÑÙÚÈç DB2 SQLJ ÅèůËðÆî¡ÖÝ×Æî JDBC¡×ûÄÙ¯á£È¢Îû JDBC î¯Ëóá£È¢¡¢ÚÀÆ«Åè ɳÆîĶÇÄî¯ËóÄãÎûÌÔÅïËôÐúÇ¡ SAMPLE æñÕèÕ» (ËðÆîÓ¡È¢ÓÁÅÆÎû ISO ë£ËÆô¿èº)¡¨ export LANG=en_US.iso88591 db2 terminate db2sampl â¡: ÇñΪÄØÈ´ SAMPLE æñÕèÕ»¡¢Ð¬ÚÀÆÒâüÇãÙÚÈç db2sampl ÌÔÅïÄæЩ¡¢Ç¿ÚïÛ¹æÚ æñÕèÕ»¡¤ ÜÉ 8 ÎêÄãÎû SNA ÅÅßÎÓî̱ Çã DB2 Universal Database Enterprise Server Edition (ESE) ÜÉ 8 Îê (Windows ů UNIX É¢äÆË·ÜÓÎêÆÛ) ¡¢Åèů DB2 Connect Enterprise Edition (CEE) ÜÉ 8 Îê (Windows ů UNIX É¢äÆË·ÜÓÎêÆÛ) Äã¡¢ÄØèôïÚĶÇÄÅÅßΡ¨ * Äâ×äËðÆîÝàç´ SNA ÎûÇéÈíåôÊÕä» (Ì¥âêÑôíýÌù) Åü×䡤ëæÓÑÇéÈíåôÊÕä» (Ì¥ âêÑôíýÌù) ÎûóÜÆîá£È¢¡¢Ü¢ÇãÆÒâü ËðÆî TCP/IP ÝÙîÀ¡¤ÈÜЩÞýÔ¶ÎêȹâäÌî¡¢ ÄØåîÆ«ÅèÝàç´ TCP/IP¡¢ÙÚÈçÇéÈíåôÊÕä» (Ì¥âêÑôíýÌù)Åäñ¢ÍÐ iSeries(TM) æñÕèÕ»ÈùΤð¡¤ëæÓÑÇéÈíåôÊÕä» (Ì¥âêÑôíýÌù) ÅÅßÎÎûÅäñ¢ÍÐ iSeries óÜÆî á£È¢¡¢Æ«ÅèËðÆî DB2 Universal Database ESE ÜÉ 8 ÎêÎûÝÕÔ¶ TCP/IP ÇéÈí åôÊÕä» (Ì¥âêÑôíýÌù) ä»ÅÅßÎÅü×䡤 * DB2 Universal Database ESE ÍÐ DB2 CEE ÈùΤðÂÄØÄâÇÂÚÙÌ¿ËðÆî SNA ÎûÆî ÅÂê¦ÝÙîÀ¡¤Ú·ÜÉ 8 Îê FixPak 1 âäÌî¡¢DB2 Universal Database Õ©Ý 32 Èí Ä÷ÎêÆÛÎû AIX¡£¡ÖSolaris(TM) É¢äÆô¿èº¡×¡£HP-UX ů Windows óÜÆîá£È¢¡¢ ËðÆî SNA ËôÇô̽Åäñ¢ÍÐ iSeries æñÕèÕ»ÈùΤð¡¤ÈºÅÅßÎÕ©ÝÂóÜÆîá£È¢ËðÆî SNA Çô̽Åäñ¢ÍÐ iSeries æñÕèÕ»ÈùΤð¡¢Èþã¯×äËðÆîÞÌÄ¡âêÑôíýÌù¡¤ * DB2 Universal Database for z/OS(TM) Îû Sysplex ÅÅßÎÆ·×äËðÆî TCP/IP¡¤ Ó¼ËðÆî SNA ÝÙîÀ¡¢Ð¬ÄâßÈËò Sysplex ÅÅßΡ¤ * ËðÆî SNA ÝÙîÀ̯Åäñ¢æñÕèÕ»ÈùΤðÂÕë¡¢Äâ×äüÈÊÕÙï¤ * ÇãĶġÎêÎû DB2 Universal Database ů DB2 Connect Äã¡¢ÙòäÄּ̽ÍÔÈ´Îû SNA ÅÅßΡ¤ ÄâÅÅßÎÐúÇ¡ÄÖ̦ÐÎòçæñÕèÕ» (Linux AMD64) ÄâÅÅßÎÇã Linux (AMD64) ĸÎû 64 ÈíÄ÷ DB2 èÒËóĶÐúÇ¡ÄÖ̦ÐÎòçæñÕèÕ»¡¤îùÄâ ÓÑè©æÜËðÆîĶÇÄǶġÅÉÎΡ¢Çã 64 ÈíÄ÷èÒËóĶÐúÇ¡ÄÖ̦ÐÎò硨 * ÇøæÒ DB2 UDB * ËðÆî db2isetup ÌÔÅïÊÕä» 64 ÈíÄ÷èÒËó * ÇãÉùÈ©ÇøæÒÄæÑ¥àõÅø CREATE TOOLS CATALOG CLP ÌÔÅ Ú· 8.1.4 ÎêâäÌî¡¢ÅÅßÎÇã Linux (AMD64) ĸÎû 32 ÈíÄ÷èÒËóĶÐúÇ¡ÄÖ̦ÐÎòçæñ ÕèÕ»¡¤ ÄâÅÅßÎÐúÇ¡ÄÖ̦ÐÎòçæñÕèÕ» (AIX¡£Solaris É¢äÆô¿èºÅ¯ HP-UX) è×ÛÛÇÙÈ¢ 64 ÈíÄ÷ÆÍƺĸÎû 64 ÈíÄ÷èÒËóÇøæÒ DB2 UDB ßæâæ¡¢ÄâÅÅßÎÐúÇ¡ÄÖ̦ÐÎ ò硤ÛÛÇÙÈ¢ÆÍƺȴ¡¨ * AIX * Solaris É¢äÆô¿èº * HP-UX * ÅÅßÎ 32 ÈíÄ÷ů 64 ÈíÄ÷èÒËóÎû̧ÆÆÆÍƺ ÇñΪÚÀÓÑè× 64 ÈíÄ÷èÒËóÐúÇ¡ÄÖ̦ÐÎòç¡¢îùÇãÇøæÒ DB2 UDB ÄæÑ¥¡¢ËðÆî CREATE TOOLS CATALOG CLP ÌÔÅïÍСÖÚÕ̱ÄãÅÀ¡×¡¢Ýàç´¡ÖÌÔÅïÈçݨܡð¡×ËôÙÚÈçȺɢ äÆ¡¤ÈºÉ¢äÆëæÓÑÇøæÒ 64 ÈíÄ÷ IBM Developer Kit for Java¡¤ÇñëææÛÜØæñع¡¢îù Ù¶ïå DB2 Administration Guide Îû DB2 Administration Server ÝÕÄ¡å硤 Workgroup Server Edition 64 ÈíÄ÷ÈùΤðÂèÒËóÓî̱ DB2 UDB Workgroup Server Edition ů DB2 UDB Workgroup Server Unlimited Edition àÒûâÐúÇ¡ 64 ÈíÄ÷ÈùΤðÂèÒËó¡¤ÚÀÆ«ÅèɳÆîÝÕËèܨÐÂËôÐúÇ¡¡¨ * 32 ÈíÄ÷ÈùΤðÂèÒËó * 32 ÈíÄ÷ÍÐ 64 ÈíÄ÷ÆîÅÂê¦èÒËó¡¤ ÏæÇÑÊãÙÚÈç CLI àÒÎÎÏæÇÑÊãÙÚÈç CLI¡¤ Å¡Þ´æñÕèջĸÎû NUM_LOG_SPAN ØÙåôÙ¶í° NUM_LOG_SPAN ØÙåôÙ¶í°ÑÀÌùǨÍøÆ«Åèæúâ½ÎûÞ²ÄËÅÊë¢óòí°¡¤Æ·ÓÑǨÍøç°Å° NUM_LOG_SPAN ÝÃÌù¡¢ÞóäÄ Rollback¡¢Ëäڰ̱ÜÜÅÏÝßȩǨÍøùÃÝðæñÕèÕ»ÎûóÜÆîᣠȢ¡¤ àÓÈÔ¡¢ÇãÅ¡Þ´Ë·ÜÓÄ㡢ƷȴÇãóÜÆîá£È¢Îû̶îþæñÕèջš޴ٴÇÑÍõØþàÁòãë¨Îû db2loggr á£Ê©ÎûÅ¡Þ´Ù´Õë¡¢ db2loggr á£Ê©Äß×äڰ̱ÜÜÅÏóÜÆîá£È¢¡¤ËóÇñ¡¢ÚÀÎû Ë·ÜÓÄãȴĵԶæñÕèջš޴ٴ (0¡£1 ÌÏ 2)¡¢ËäÙòÍÔÈ´æñÕèջš޴ٴÎû NUM_LOG_SPAN Ù¶í°ÝÃÌùÒ³ 2¡¤óÜÆîá£È¢ÝÙÚÙÈÝæñÕèÕ»ÎûæñÕèջš޴ٴ 2¡¢ËäâäÌî ÏÛßæÙÚÈçÎûǨÍø¡¢ÝÕäÄæúâ½Ì¥Ô¶ÅèĸÎûÅÊë¢óò¡¤ÇñΪæñÕèջš޴ٴ 1 ĸÎû db2loggr á£Ê©Þ²Ç¿ØþàÁ̯Ⱥòã먡¢Ð¬ÄâäÄàõÆíǶÈôËçǵ¡¤àÓÈÔ¡¢ÇñΪæñÕèջš޴ Ù´ 2 ĸľàõÆíç°Ý½¡¢Ð¬ db2loggr á£Ê©ÞóäÄÎÃãô̯Ⱥòã먡¢ÈÔÙòǨÍø Rollback¡¢ ËäÚ·æñÕèջڰ̱ÜÜÅÏóÜÆîá£È¢¡¤ ÇãÇéÔ¶ÔºÆßÔïǵô¿èºÄã dasdrop ÌÔÅïÎûÓî̱ ßåÅî FixPak äÄÇøæÒ̧ÈÜÄ×Îû dasdrop ÌÔÅïÎêÆÛ¡¤Çã AIX Ë·ÜÓĸ¡¢ÆÆÑÒÇøæÒÇã /usr/opt/db2_08_FPn/ æûÕÀÄ㡤Çã̧Åì UNIX Ë·ÜÓĸ¡¢ÆÆÑÒÇøæÒÇã /opt/IBM/db2/V8.FPn/ æûÕÀÄ㡤ÇãÝÕÌ¥ê¡ÚÅÎÓĶ¡¢ n ÑÒ FixPak ÎûæÀ¤ ÇãÇéÔ¶ fixpak ô¿èºÄã¡¢ÍõǶÈôÕëÔ·¡¢ÚÀÝçÆ·×äÝÃÌùÄ¡Ô¶ DAS¡¤ÚÀÆ«Åèè× 8.1 Îê ܨÐÂÍÐè×ǶÈôÄ¡Ô¶ßåÅî FixPak ËôÐúÇ¡ DAS¡¤Ó¼ÓÑÚïÛ¹ØÜè×ܨÐÂÎû 8.1 ÎêÍÔÐúÇ¡ Îû DAS¡¢ÚÀÆ«ÅèËðÆîǶÈôÎêÆÛÎû dasdrop ËôÚïÛ¹ÆÆ¡¤àÓÈÔ¡¢Ó¼ÓÑÚïÛ¹ØÜè×ßåÅî FixPak ÍÔÐúÇ¡Îû DAS¡¢Ð¬ÆÒâüËðÆî dasdrop ÎûßåÅî FixPak ÎêÆÛ¡¤ ËóÇñ¡¢ÚÀÆ«ÅèÈÓìå AIX É¢äÆË·ÜÓĸÎûĶÇÄÎíÎÓ¡¨ * ÇøæÒ DB2 Universal Database 8.1 Îꡤ * ÇøæÒßåÅî FixPak 1¡¤ * ɳÆîĶÇÄÌÔÅï¡¢ËôÐúÇ¡ËðÆî 8.1 Îêá£È¢î£Îû DAS¡¨ /usr/opt/db2_08_01/instance/dascrt dasusr1 * ÚÀã÷ÓÑÚïÛ¹ DAS¡¤ ÚÀÆ«ÅèËðÆîĶÇÄ̧ÄãÄ¡âúÌÔÅïËôÚïÛ¹ÝÕÔ¶ DAS¡¨ /usr/opt/db2_08_01/instance/dasdrop /usr/opt/db2_08_FP1/instance/dasdrop ÝÕÌ¥ê¡ÌÔÅïÝç×äÆßíýçªÉ¢¡¤ ÈþÑÒ¡¢ÇãÝÕÔ¶î¯ËóÄ㡨 * ÇøæÒ DB2 Universal Database 8.1 Îꡤ * ÇøæÒßåÅî FixPak 1¡¤ * ɳÆîĶÇÄÌÔÅï¡¢ËôÐúÇ¡ËðÆîßåÅî FixPak 1 á£È¢î£Îû DAS¡¨ /usr/opt/db2_08_FP1/instance/dascrt dasusr1 * ÚÀã÷ÓÑÚï۹Ⱥ DAS¡¤ ÚÀÆÒâüËðÆîßåÅî FixPak 1 Îû dasdrop ÌÔÅ /usr/opt/db2_08_FP1/instance/dasdrop è©æÜËðÆî 8.1 ÎêÎû dasdrop ÌÔÅïäÄðÒÓ³àõÆíòã먡¤ ÝÕÄ¡Óî̱ã¯ïËÆîÍõ 8.1 ÎêܨС¢ÈÔÄâïËÆîÍõǶÈôÄ¡×ï FixPak¡¤ËóÇñ¡¨ * ÇøæÒ DB2 Universal Database 8.1 Îꡤ * ÚÀÆ«ÅèÅ¿ÆîÄ¡×ï FixPak 1¡¢ÆÆ×äÙÜÔºÆß 8.1 Îê dasdrop ÅÉÓòÎûÙÂ÷ * ÇøæÒßåÅî FixPak 1¡¤ * ɳÆîĶÇÄÌÔÅï¡¢ËôÐúÇ¡ËðÆîßåÅî FixPak 1 á£È¢î£Îû DAS¡¨ /usr/opt/db2_08_FP1/instance/dascrt dasusr1 * ÚÀã÷ÓÑÚï۹Ⱥ DAS¡¤ ÚÀÆ«ÅèËðÆîĶÇÄ̧ÄãÄ¡âúÌÔÅïËôÚïÛ¹ÝÕÔ¶ DAS¡¨ /usr/opt/db2_08_01/instance/dasdrop /usr/opt/db2_08_FP1/instance/dasdrop ÝÕÌ¥ê¡ÌÔÅïÝç×äÆßíýçªÉ¢¡¢ÇÞÒ³åµÚÀÔïÆîÄ¡×ï FixPak Õë¡¢ÈíÍõ /usr/opt/db2_08_01/ æûÕÀĸÎû dasdrop ÎêÆÛÞóÄØåîڵ̯ÊÕÆß¡¤ ¡ÖæñÕèÔ¿óÃÄãÅÀ¡×ÄâïËÆîÍõöüüÕÄãÅÆ ¡ÖæñÕèÔ¿óÃÄãÅÀ¡×ÊôÈ´öüüÕÄãÅÆÎꡤÇÞȺĶÇÄÒÞËíÎû DB2 Ä÷ǵľàÒÎÎÇãȺô¿èºÄã ËðÆ * DB2 Warehouse Manager¡¤ * ¡ÖæñعÐÎòçÄãÅÀ¡×êØ DB2 Warehouse Manager Îû¡Öê§Ü¡æñعÐÎòç¡×ê´üñÄ÷ǵ ÒÞËí¡¤ ë¿ê¦ÎìǵÎûÅÊÅÆÇØê¢ ÅèÅÊÅÆÇóÐÎÉÇÜ¢Äæë¿ê¦ËôäãÎûê¾Æø¡£ÏÐÖªÌÏÎþúñÇØê¢àÒÎÎÅýÉÖÑÜËèÇóÄ÷¡¤Unicode è×ÑÐոܬƫ×ääÄËðÇØê¢üÈȩϨÇóÄ÷¡¤ùÃÍõ̧Åìæñع¡¢îùÙ¶ïå http:// www.ingrid.org/java/i18n/encoding/ja-conv.html¡¤ ¡ÖÛÒØææñÕè¡×÷ËßÐá£È¢ÎûÓî̱ Ù¶í°Óî̱ ÞòÊÆůåôßÐÙ¶í° ÇñΪä»Îû¡ÖÛÒØææñÕè¡×÷ËßÐá£È¢Ý½Ð¬ÏÐÅýÉÖ¡ÖÞòÊÆůåôßС×ÎþúñÄæÄâÇÑ æñÕèùËÐΡ¢ÚÀÆÒâüÇã¡ÖÆøíºÏÐÖª¡×ÄùÕ©Ó÷ÌÏ¡ÖÎþúñè×ÑС×Ó÷üÈÊÕ¡ÖÆø íº¡×ÎþúñæñÕèùËÐÎÄæÑ¥¡¢ÇÂßÈŪ÷ËßÐá£È¢Ì¯àÁæÜí¼È¢¡¤ Ù´çÒÙ¶í° ÇñΪä»Îû¡ÖÛÒØææñÕè¡×ݽЬÏÐÅýÉÖ¡ÖÒÌÓî¡×ů¡ÖåôßС×ÎþúñÄæÄâÇÑæñÕè ùËÐΡ¢ÚÀÆÒâüÇã¡ÖÆøíºÏÐÖª¡×ÄùÕ©Ó÷ÌÏ¡ÖÎþúñè×ÑС×Ó÷üÈÊÕ¡ÖÆøíº¡×Îþ úñæñÕèùËÐÎÄæÑ¥¡¢ÇÂßÈŪ÷ËßÐá£È¢Ì¯àÁæÜí¼È¢¡¤ iSeries ÆÍƺÓî̱ Çã iSeries ÆÍƺ¡¢ä»Îû¡ÖÛÒØææñÕè¡×÷ËßÐá£È¢ÄâÙÚÈçòãë¨Ý¨Ü¡¡¤ÚÀã¯×äÇã iSeries ÆÍƺĸܨÆí¡ÖÇÀÝåÜÊÇÙ¡×ÜÊÇÙùËÐΡ¤ ËðÆîÔ¿óÃÅîܡ׻ʽìÑůÇô̽ Client Connect Ô¿óÃËôäã ËðÆîÔ¿óÃÅîܡ׻ÙÚÈçʽìÑ Ó¼Ëôäã¡£Æøíº¡£öÊ̽ÚÕ̱ÍÐÅ¿ÆîÚÕ̱ÈùΤð (æñÕèÕ») è×ÆîÅÂê¦Ë·ÜÓËôë©ÑÒë¿ ê¦¡¢ÚÀÆÒâüÇãÆîÅÂê¦ÌÏÔ¿óÃÅîܡ׻˷ÜÓËðÆîÒÞÇÑÇØꢡ£ËðÆîϯ ID ÌÏÙïî£Ëôî¾Æø æñÕèÕ»¡¤åµÚÀè×ÆîÅÂê¦êØÔ¿óÃÅîܡ׻˷ÜÓî¾ÆøËôäãÑ¥¡¢îùíýë¥Æ«ÝÙÚÙÈÝËôäã¡£Æø íº¡£öÊ̽êØÅ¿ÆîæñÕèÕ»¡¤ ÇñΪàÒÎÎÝÙÚÙÔ¿óÃËôäã¡£Ô¿óÃÆøíº¡£Ê½ìÑöÊ̽ÍÐʽìÑÅ¿ÆîæñÕèÕ»¡¢îùíýë¥ë¿ê¦Ë· ÜÓĸÎûô¿èºüÈí° DB2COMM ÝÃÒ³ TCP/IP¡¢ÅâÙÕæÀÜÊÇÙî¾ÆøÍõÆîÅÂê¦Ë·ÜÓÎûæñÕèÕ» Å¡Þ´Ù´ÎûÙÕæÀ¡¤ Ó¼ÓÑüÓøýë¿ê¦Ë·ÜÓĸÎûÙÕæÀ¡¢îùÇã DB2 Universal Database ÌÔÅïßÈÆüõïīĶÇÄ ÌÔÅ get dbm cfg | grep SVCENAME î¾ÆøæñÕèջš޴ٴÕë¡¢îùÑÀÌùÆîÅÂê¦Ë·ÜÓÎûÙÕæÀ¡¤ ËðÆîÔ¿óÃÅîܡ׻Çô̽ Client Connect Ô¿óÃËôäã åµÚÀËðÆîÔ¿óÃÅîܡ׻Çô̽ġԶËðÆî Client Connect ÌùåøÎûÔ¿óÃËôäãÕë¡¢ÆÒâüÇã ÆîÅÂê¦ÌÏÔ¿óÃÅîܡ׻˷ÜÓËðÆîÒÞÇÑÇØꢡ£ËðÆîϯ ID ÌÏÙïî£Åèî¾ÆøȺËôä㡤ӼÚÀ ËðÆîÔ¿óÃÅîܡ׻Îû ODBC ÎêÆÛ¡¢ÚÀľÆÒâüÇãÔ¿óÃÅîܡ׻ÌÏÆîÅÂê¦î¾ÆøȺËôäãÅèÉ¢Ò³ ODBC Ëôä㡤ÉÁЬ¡¢ëæÓÑÔ¿óÃÅîܡ׻Çô̽ԿóÃËôäãÎûٯɢÙòäÄÆÂÚõ¡¤ ÚêÌùÊäçÒÄ¡ÑôÕëâæÙÚÈçÔ¿óÃݨܡá£Ê© ÇãÚêÌùÊäçÒÄ¡ÑôÕëâæÙÚÈçÔ¿óÃݨܡá£Ê©Õë¡¢ÆÒâüɲÌùÓÑÙÚÈçݨܡá£Ê©ÄãÎûÍÔÈ´Æí ܨÊãüõÍÔëæÏÄâ¶ÎûÞ²ÏÛÕëâæ¡¢ËäïËåµÇâÚêÌù̧âæçÒ¡¤Ó¼Ý¨Ü¡á£Ê©â¾ÅøÚêÌùÎûâæçÒ Õëâ桢ЬÍÔÈ´æÚݨܡá£Ê©Ñ¥úýÚêÌùÎûâúÆøÙòÄâäÄÙÚÈ硢ľÄâäÄÓìä»ÚêÌùÕëâ桤 ã¾Ä«Å¯ã¾ÅøÎû¡ÖæñÕèÔ¿óÃÄãÅÀ¡×Óî̱ ÇñΪã¾ÅøħġԶ̦ȴÆÜù¹á¸ÄæÚÚÕÀÎûá£Ê©¡¢àÓÑ¥Åè .tag óò֪Ȣã¾Ä«Æ¶Ä¡Ô¶ÚÕ̱ æñÕèÕ»¡¢Ð¬ÆÜù¹á¸ÄæÚÚÕÀæñÕèÙòðÒÓ³òãë¨ DWC3142 ÎûàõÆí¡¨ was not found in the Data Warehouse Center control database. ÆÜù¹á¸ÄæÚÚÕÀ dirID ËäÆÜ÷ËßÐÅâÄóÙ¶äùÔÏÌîÎûÚÕ̱æñÕèÕ»Õë¡¢ÞóäÄüÏÆüȺòã먡¤ ÇãÇøæÒ 8.1.2 ÎêÍÐÊÕä»ÎêÆÛÄæÑ¥ÇøæÒÔ¿óÃÚÕ̱æñÕèÕ» ÇñΪÚÀÔïÆîÔºÆßÔïǵÍÐÇøæÒä»ÎêÎû DB2 UDB ÍСÖæñÕèÔ¿óÃÄãÅÀ¡×¡¢Ð¬ÆÒâüÜÃ÷ËÜ¢ ÇôÎûÚÕ̱æñÕèÕ»¡¢ÅèÊÕä»ÆÆÅýÉÖÎûÎìǵ¡¤ÈºÆÀ¡¢ÇãÇøæÒ 8.1.2 ÎêÍÐÊÕä»ÎêÆÛÄæ Ñ¥¡¢ÚÀÆÒâüÓìä»ØÄÌîÝÃÌùÔ¿óÃÚÕ̱æñÕèÕ»¡¤ Cube Views î¯ËóóÜÆîá£È¢êØî¯ËóËôäãÄâÇÑ DB2 Cube Views V8.1 Æ«ßÈËòÄ¡Ô¶ÇØÒ³ db2mdapiclient.exe Îûî¯ËóóÜÆîá£È¢¡¢ ÆîËôÆüî¯ Cube Views ÎûÄ¡ËèÓìÓÑÅü×䡤̧ÄãÅýÉÖħȺóÜÆîá£È¢ÎûÔÏÌîî£ db2mdapiclient.cpp¡¤Çã DB2 Cube Views V8.1 ÎûØÄÌîÎêÆÛÄã¡¢óÜÆîá£È¢ÑÒËðÆî ÔÏÌîî£ËôÐúåôÎû¡¤Ú· 8.1.4 ÎêâäÌî¡¢ÔÏÌîî£ËäÆÜüÈÊÕ¡¢ÈþÑÒʼԯÄØåîÔºÊÑħóÜÆî á£È¢¡¤ÔÏÌîî£ÄóàÓÈ´Õæ¡¢ÈþÑÒÄâÉùÇÀÜÊÇÙóÜÆîá£È¢¡¤ ¡Öç¥Ä«¡×ÌÏ¡Öã¾Ä«Îþúñ¡×Ó÷ÄâÅÅßÎ IXF óòÄãÎû DBCS ÇóÄ÷ Ó¼ËðÆî¡Öç¥Ä«¡×ê´üñÍСÖã¾Ä«¡×á­Ø´ÆÛÝÃÌùç¥Ä«ÍÐÚ·ÉÖÈ´ DBCS ÇóÄ÷Îû IXF òÓÄ« óòã¾Ä«¡¢Ð¬¡ÖÎþúñ¡×Ó÷ÄâäÄÆßíýÇâüÏÆüóòÕùÍÔÅýÉÖÎûÎþúñÇØꢡ¤ ç¥Ä«É¢äÆÆÂÚõÕëá¿êØħÄâÆßíýÎû¡ÖÉ¢äÆÄãÅÀ¡×ÑÀÆüÜÊ Ó¼ç¥Ä«ÆÂÚõ¡¢ÈþÆ·ã®ÇßúÀÉË¡¾ÄâÑÒòãë¨Ø¹ÕÉ¡¿¡¢Ð¬É¢äÆè·ÆüÄóäÄÏáÚ§êºÈãÅ¥æÀÅø Ü¢Çã¡ÖÉ¢äÆÄãÅÀ¡×¡¤îùíýÌùóôÑçÚÀèÒÑÌÎûǶÈôç¥Ä«ÑÒÉÁÈ©Åü¡¤ GUI ÄÖ̦ÎûÞ²ÄÑàëÓòÝÃÌùÔ« ҳħËð GUI ÄÖ̦Çñ¡ÖÚÕ̱ÄãÅÀ¡××äÙÜÆßÚ¦çªÉ¢¡¢ÚÀÆÒâüÈ´ÈÝÅ· 800 Óý 600 Îûò­ èÝæØεÐù¡¢ÅâËðÆîÈÝÅ· 32 ÈãÎû÷íÈãòÙÆîÙ´¡¤ îùÄâÓÑÅ¡Þ´¡ÖæñعÐÎòçÄãÅÀ¡×ÏÐÖª ¡ÖæñعÐÎòçê§Ü¡á£È¢¡×ËðÆîÎûÏÐÖªÆÒâüÄùÉÖÍõÞÌÄ¡ÎûæñÕèջš޴ٴÄ㡤ÚÀÆ«ÅèËð ÆîÇÖê¡ÅÉÎΡ¢ÙòÏÐÖªÍóÄ«ÞÌÄ¡Å¡Þ´Ù´¡¤Ä¶ÇÄá£Ê©ÑÒÆ«ÅèËðÆîÎûÅÉÎÎÄæÄ¡¡¤ 1. âäÚö¡ÖDB2 ÌÔÅïÈçݨܡð¡×ËäàõÅøĶÇÄÌÔÅ a. CREATE DATABASE PARTITION GROUP partition_group_name ON DBPARTITIONNUM partition_number b. CREATE REGULAR TABLESPACE tablespace_name IN DATABASE PARTITION GROUP partition_group_name MANAGED BY SYSTEM USING ('cname') ̧Äã partition_group_name ÇãÝÕÌ¥Ô¶ÌÔÅïÄãÑÒÒÞÇÑÎû¡¤ 2. ѺġĶ¡ÖâäÌî¡×->¡Öá£È¢âõ¡×->¡ÖIBM DB2¡×->¡ÖÝÃÌùÄÖ̦¡×->¡Öê§Ü¡æñعÐÎ òçê´üñ¡×¡¤ 3. Çã¡ÖòÙâú¡×Ó÷ÓòÎûÏÐ֪ϨâæúñÈíÄã¡¢ÑÀÌùÏÐ֪ϨâæÇØꢡ¤ ØôÆî DYN_QUERY_MGMT ÕëÎû Query Patroller Óî̱ ÇñΪØôÆîħæñÕèÕ»ØÙåôÙ¶í° DYN_QUERY_MGMT¡¢Query Patroller ÞóàÒÎÎÙÚÈçĶÇÄ Ù¯É¢¡¨ * úËÍóÎíèèÒ³ÏñÖçÎûÑçææ * åµÑçææÈíÍõЩßßÕë¡¢üéÙÚÈçÄãÎûÑçææÍÐÄØÚêÄ«ÈïÇÄÎûÑçææÇãÓ¬ßßÄãÙÚÈç åµ DYN_QUERY_MGMT ÝÃÒ³ DISABLE Õë¡¢ÇñΪÚÀè©æÜúËÍóÎíèèÒ³ÏñÖçÎûÑçææ¡¢ÍÐÑÒ ÙòЩßßÑçææüÈÊÕÒ³Ó¬ßßÑçæ桢ЬäÄüÏÆüòãë¨Ø¹ÕÉÅâÄâäÄüÈÊÕÑçææÎíè衤ÇñΪÚÀÚê ÌùÙÚÈçÄØÏñÖçÎûÑçææ¡¢ÈÔÇãÆÆÔ¯âäÌîÙÚÈçÕë¡¢DYN_QUERY_MGMT Ò³ØôÆîÎíè衢Ьòã ë¨Ø¹ÕÉäÄìÑÄ« qpdiag.log óò¡¢ÈÔÑçææÄóêÄѽҳÏñÖçÎíè衤 Ü¢Çã Query Patroller á¸ÎªÏÐÖªËðÆî DB2QPRT ê¾Æø Ú· FixPak 5 âäÌî¡¢ÍÔÈ´ä»Îûá¸ÎªÏÐÖªÝçäÄÅèê¾Æø DB2QPRT ËôÐúÇ¡¡¢ÈÔÄâÑÒßÈǨ ϯÎûê¾Æø¡¤ DB2QPRT ê¾ÆøĸÎû DROPIN ÙñÆîûâäÄÚæêØá¿ðçÉ¢ÔÞ¡¢ÈºÝ¨ÎûðçÉ¢ÔÞÝÃÌùóòÐúÇ¡Íõ FixPak 5 ÇøæÒÄæЩ¡¢ÅâðßȴĶÇḀ̈ϯÄæÄ¡¡¨ * ڧȴî¾òÒûâÓîÎû MONITORING ÙñÆîûâ * ڧȴî¾òÒûâÓîÎû HISTORICAL ANALYSIS ÙñÆîûâ åµ Query Patroller ÓûȹÇãÝÕÔ¶ê¾ÆøÄãÐúÇ¡á¸ÎªÏÐÖªÕë¡¢ÞóäÄÚæêØ DB2QPRT ê¾ ÆøĸÎû DROPIN ÙñÆîû⡤ ÇãÇøæÒ FixPak 5 ÄæÑ¥¡¢Ì¦È´ MONITORING ÙñÆîûâ (ڧȴî¾òÒûâÓî) ÍÐ HISTORICAL ANALYSIS ÙñÆîûâ (ڧȴî¾òÒûâÓî) ÎûðçÉ¢ÔÞ¡¢Ä¾äÄÇãÐúÇ¡ÍÐÊÕä»Ì§ ÝÃÌùóòÕ롢ݷÚæêØ DB2QPRT ê¾ÆøÎû DROPIN ÙñÆîû⡤ ÄâÅÅßÎ ALTER WRAPPER SQL ÝóÓÝÈ¢ ÚÀàÒÎÎüÈÊÕ Wrapper á£È¢¡¤ÄâÅÅßÎ ALTER WRAPPER ÝóÓÝÈ¢¡¤ ØúÚªÑÀÆüÜÊÓî̱ ÇñΪÑÀÆüÜÊâÐÄ«ùÃÝðÎíèè¡¢ØúÚªéñåÆá£È¢ÞóàÒÎÎÙÚÈç db2.db2_op_status ØúÚªÑÀ ÆüÜÊÎûٯɢ¡¤ËóÇñ¡¢åµÑÀÆüÜÊÆßÇãéñåÆÎûèÒËóÇÞÍüíýÎûØôÅÏÓÑÊåÍÐܬڦÜÜÅÏÈÔüÈ È©ÏæÉ¢ÆîÄãÕë¡¢ÞóÆ«×äÝßÈ©ÝÕê¡Îíè衤ÇñΪã÷ÓÑüéèÒËóÇãǶÈôܬڦÜÜÅÏÑ¥ÈÜÙ¯Óì ä»ÚöÙ¯¡¢Ð¬ÆÒâüØÙåôòãë¨éñåÆá£È¢ÅèüéèÒËóÏñѽҳØíÆ«ÆîÍÌ¡¤ Ë·ÜÓéñåÆá£È¢ Snapshot UDF Óî̱ ÕüðãÝÃÓÓ¡¢LIST DB DIRECTORY ÌÔÅïàõÅøÕë¡¢ÆøòçâúÆøùËÐÎÔ«üÏÆüÒ³ Indirect ÍÐ Home ÎûæñÕèջĸ¡¢Æ«ËðÆî Snapshot ËðÆîϯÌùåøÎûÌªí° (UDF)¡¤ÇñΪè×ë¿ê¦æñÕè Õ»ËðÆî UDF¡¢ÙòüÏÆüĶÇÄòãë¨Ø¹ÕÉ¡¨ SQL1427N An instance attachment does not exist. Snapshot UDF (Íõ V8.1 Å¿âÐ) àÒÎÎêØéñåÆá£È¢âäùÃÌÔÅïů API ÍÐéñåÆá£È¢ÓìÝà ÌÔÅïů API á¸ÇÙËðÆȺÓî̱ÅýÑÄ¡¨ * GET MONITOR SWITCHES * UPDATE MONITOR SWITCHES * RESET MONITOR àõÆíȺÓî̱ÎûÔÏÇÞÑÒȺùËÌÔÅïäÄÇã Snapshot UDF ɳÆî DATABASE CONNECT ÕëËðÆî INSTANCE ATTACH¡¤ ÄØÏ¡ÙÂ÷îůí²ÈçæØÊîÅÉÎÎ DB2 Universal Database Workgroup Server Edition Îû DB2 ÚæûâÔÏЬ ö£àÓ DB2 ÈùΤðÂʸÝÚÄ«ÏÜ ÝÕÆÛÅÃÅõů¡ÖÚæûâÄãÅÀ¡×ÎûîÀĸÄÖ̦ë©ÍüƶȴÑÀÆü¡¢ Èþè×Íõ DB2 Universal Database Workgroup Server Edition Ëôë©¡¢ê½ëãê½æûÚæ ûâÔÏЬàÒÕ桤ӼÚÀëæÓÑê½ëãê½æûËðÆîϯÎûÚæûâ¡¢ÚÀÆÒâüõÕâ¹ DB2 Universal Database Workgroup Server Unlimited Edition¡¤ Linux (x86¡£32 ÈíÄ÷) ĸëæÈ´ IBM Developer Kit for Java 1.3.1 DB2 UDB ëæÓÑ IBM Developer Kit for Java 1.3.1 Service Release 4¡¢Äß×äËð Æî¡ÖDB2 ÚÕ̱ÄãÅÀ¡×ÍÐÐúǡůÙÚÈç Java óÜÆîá£È¢¡¢ÅýÑÄóÃÇôá£Ê©Å¯ËðÆîϯÌùåø ÎûÌªí°¡¤ã¯ÅÅßÎ IBM Developer Kit for Java¡¤ åµÚÀÇøæÒÑÜÔ¶ëæÓÑ Java ÎûÄ÷ǵÕë¡¢ÞóäÄÇÑÕëÇøæÒ IBM Developer Kit for Java¡¤Äâç´¡¢ÇñΪÇøæÒá£È¢ØþàÁÅø IBM Developer Kit for Java 1.3.1 ÄØÇø æÒ¡¢ÞóÄâäÄÇÂȹÇøæÒ SDK¡¤IBM Developer Kit for Java 1.3.1 È´ÙñÆîÎûÇøæÒÆø òç¡¢ËäÄâäÄÊÑìÑǶÈô÷®ÎêÎû IBM Developer Kit for Java¡¤ Óî̱ ã¯ÇãËðÆîĶÇÄ̧ÄãÄ¡ê¡ DB2 UDB ÇøæÒÅÉÎΡ¢ÄßäÄè©æÜÇøæÒ IBM Developer Kit for Java¡¨ * GUI ÇøæÒá£È¢ (db2setup) * ÇßóÜóòÇøæÒ (db2setup -r response_file) á£Ê© Ó¼ÓÑÅèÅÃÙ¯ÅÉÈ¢ÇøæÒ IBM Developer Kit for Java¡¢îùÚ· /cdrom/db2/linux/Java-1.3.1 ÆøòçÙÚÈçĶÇÄÌÔÅ rpm -ivh IBMJava2-SDK-1.3.1-4.0.i386.rpm ȺÌÔÅïäÄÙò IBM Developer Kit for Java ÇøæÒ̯ /opt/IBMJava2-131 Æøò硤 Ó¼ÓÑüÓøý IBM Developer Kit for Java ÑÒÉÁÉùÈ©ÇøæÒ¡¢îùÇã UNIX(R) Shell ßÈ ÆüÄãÙÚÈçĶÇÄÌÔÅ /jre/bin/java -version ̧Äã ÅîÏÐ Java ÎûÇøæÒæûÕÀ¡¤ËóÇñ¡¢ÇøæÒÆøòçÎûæûÕÀÓ¼ÑÒ /opt/IBMJava2-131/¡¢Ð¬ÌÔÅïÒ³¡¨ /opt/IBMJava2-131/jre/bin/java -version ÚÀóÜæÚÚÙȭ̯ÇñĶÎûòÓÅø¡¨ java version "1.3.1" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1) Classic VM (build 1.3.1, J2RE 1.3.1 IBM build cxia32131-20030329 (JIT enabled: jitc)) IBM Developer Kit for Java ľƫÅèÚ· IBM developerWorks ê½×»Ä¶ç¥¡¢ê½ÉßÒ³ http://www.ibm.com/developerworks/java/jdk/index.html¡¤ öüüÕÄãÅÆë£ËÆô¿èº (AIX) AIX ÄØÇãĶÇÄÎêÆÛÄãüÈÊÕÝÙá¸Ì¯öüüÕÄãÅÆë£ËÆô¿èº Zh_CN ÎûÇóî£âõ¡¨ * AIX 5.1.0000.0011 ÎêÍÐÊÕä»ÎêÆÛ * AIX 5.1.0 Îê (êÄû¬ìÒȹ 2 ÍÐÊÕä»ÎêÆÛ) Çóî£âõÄØÚ· GBK (Çóî£Ó÷ 1386) üÈÊÕÒ³ GB18030 (Çóî£Ó÷ 5488 ÍÐ 1392)¡¤ÆñÍõ DB2 Universal Database for AIX Ýàç´ Unicode ÅÅßÎÆÛñ¢Îû GBK Çóî£âõ¡¢Åèů GB18030 Çóî£âõ¡¢ÇÞȺ DB2 Universal Database äÄÙò Zh_CN ë£ËÆô¿èºÎûÇóî£âõ çßÝÃÒ³ ISO 8859-1 (Çóî£Ó÷ 819)¡¢ËäÇãÑÜËèÉ¢äÆÄãľäÄÙòȺë£ËÆô¿èºÎûÙñúèÙ´ çßÝÃÒ³Ó¡ÙÏ (US)¡¤ ÓÑæØÊîÝÕâúÓî̱¡¢È´Ä¶ÇÄÌ¥Ô¶òÙð塨 * ÚÀÆ«ÅèÙòë£ËÆô¿èºÎûÇóî£âõÚ· GB18030 åôßÐÒ³ GBK¡¢ËäÙòÙñúèÙ´Ú·Ó¡ÙÏåôßÐ Ò³ÄãÙÏ (̧ÙñúèÙ´ ID Ò³ CN¡¢ÙñúèÙ´î£Ò³ 86)¡¤ * ÚÀÆ«ÅèËðÆîÄâÇÑÎûöüüÕÄãÅÆë£ËÆô¿èº¡¤ Ó¼ÚÀòÙðåËðÆîÜÉÄ¡Ô¶òÙâú¡¢îùàõÅøĶÇÄÌÔÅ db2set DB2CODEPAGE=1386 db2set DB2TERRITORY=86 db2 terminate db2stop db2start Ó¼ÚÀòÙðåËðÆîÜÉĨԶòÙâú¡¢îùÙòÚÀÎûë£ËÆô¿èºÚ· Zh_CN üÈÊÕÒ³ ZH_CN ÍÐ zh_CN¡¤ ZH_CN ë£ËÆô¿èºÎûÇóî£âõÒ³ Unicode (UTF-8)¡¢ÈÔ zh_CN ë£ËÆô¿èºÎûÇóî£âõÒ³ eucCN (Çóî£Ó÷ 1383)¡¤ öüüÕÄãÅÆë£ËÆô¿èº (Red Hat Linux) Red Hat ÜÉ 8 ÎêůÊÕä»ÎêÆÛ (ÅýÑÄ Red Hat Enterprise Linux [RHEL] 2.1 Îê ůÜÉ 3 Îê) ÄØÙòöüüÕÄãÅÆÎûçßÝÃÇóî£âõÚ· GBK (Çóî£Ó÷ 1386) üÈÊÕÒ³ GB18030 (Çóî£Ó÷ 5488 ÍÐ 1392)¡¤ ÆñÍõ DB2 Universal Database for Linux Ýàç´ Unicode ÅÅßÎÆÛñ¢Îû GBK Çóî£ âõ¡¢Åèů GB18030 Çóî£âõ¡¢ÇÞȺ DB2 Universal Database äÄÙòÆÆÎûÇóî£âõçßÝà ҳ ISO 8859-1 (Çóî£Ó÷ 819)¡¢ËäÇãÑÜËèÉ¢äÆÄãľÙòÆÆÎûÙñúèÙ´çßÝÃÒ³Ó¡ÙÏ (US)¡¤ ÓÑæØÊîÝÕâúÓî̱¡¢È´Ä¶ÇÄÌ¥Ô¶òÙð塨 * ÚÀÆ«ÅèÙò Red Hat çßÝÃÎûÇóî£âõÚ· GB18030 åôßÐÒ³ GBK¡¢ËäÙòÙñúèÙ´Ú·Ó¡ÙÏ åôßÐÒ³ÄãÙÏ (̧ÙñúèÙ´ ID Ò³ CN¡¢ÙñúèÙ´î£Ò³ 86)¡¤ * ÚÀÆ«ÅèËðÆîÄâÇÑÎûöüüÕÄãÅÆë£ËÆô¿èº¡¤ Ó¼ÚÀòÙðåËðÆîÜÉÄ¡Ô¶òÙâú¡¢îùàõÅøĶÇÄÌÔÅ db2set DB2CODEPAGE=1386 db2set DB2TERRITORY=86 db2 terminate db2stop db2start ÇñΪÚÀòÙðåËðÆîÜÉĨԶòÙâú¡¢îùàõÅøĶÇÄǶġԶÌÔÅ export LANG=zh_CN.gbk export LANG=zh_CN export LANG=zh_CN.utf8 ̧ÄãêØ zh_CN ÒÞùÃÎûÇóî£âõÑÒ eucCN ÍÐÇóî£Ó÷ 1383¡¢ÈÔêØ zh_CN.utf8 ÒÞùÃÎû Çóî£Ó÷ЬÑÒ 1208¡¤ Merant Driver Manager ÄâÒÞÕ©ÍÌ (UNIX) åµ Merant Driver Manager Çô̽ UNIX ĸÎû DB2 ODBC ûÄÙ¯á£È¢Õë¡¢UnicodeÅÅ ßÎäÄÈ´ÄâÒÞÕ©ÎûÚÅÎÓ¡¤ÝÕËèÄâÒÞÕ©ÎûÚÅÎÓäÄËð Merant Driver Manager É»ËðÇãóÜ Æîá£È¢ËäÆÜÓÑÊåËðÆî Unicode Õ롢ľËðÆî Unicode¡¤ÝÕÔ¶ÎíÎÓÆ«×ääÄðÒÓ³¡ÖæñÕè Ô¿óÃÄãÅÀ¡×¡£¡ÖæñعÐÎòçê§Ü¡á£È¢¡×ů MQSI ÝÕùËÎûÄ÷ǵàõÆíÙÂ÷î¡¢ÇÞÒ³ÆÆÔ¯ëæÓÑ Merant Driver Manager ËôÅÅßÎÏæ IBM æñÕèËôä㡤ÇãßÈËòÆãļÎûæØÊîÅÉÕùÄæЩ¡¢ ÚÀÆ«ÅèËðÆîÆÜÚöÆî Unicode ÅÅßÎÎûßåÅî DB2 ODBC ûÄÙ¯á£È¢óòÕùÕ»¡¤ ÆÜÚöÆî Unicode ÅÅßÎÎûßåÅî DB2 ODBC ûÄÙ¯á£È¢óòÕùÕ»¡¢òñÏáÍõ DB2 UDB for AIX¡£HP-UX ů¡ÖSolaris É¢äÆô¿èº¡×(8.1 Îê)¡¤Ó¼ÓÑËðÆîßåÅîóòÕùÕ»¡¢ÚÀÆÒâüÐú Ç¡ÆÆÎûÙ«ÆÛ¡¢ÇÑÕëá¿êØÙ«ÆÛ̧ÔÏÌî DB2 ODBC ûÄÙ¯á£È¢óòÕùÕ»ÎûÇØꢡ¤ â¡: ßåÅî (_36) óòÕùÕ»ÉÖÈ´ DB2 JDBC ûÄÙ¯á£È¢ëæÓÑÎû Unicode Åü×䡤ËðÆîÝÕ Ô¶óòÕùջƫüé JDBC óÜÆîá£È¢ (ÅýÑÄ WebSphere Application Server) ×ä ÙÜâûɳÇâËðÆî DB2 UDB¡¤ Ó¼ÓÑÇã AIX¡£HP-UX ÍСÖSolaris É¢äÆô¿èº¡×ĸŢßÐÈÝÏæ Unicode ODBC óòÕùÕ»¡¢ îùÙ¶ïåĶÇÄÑÀÆü¡¤ÇÞÒ³ÝÕÑÒÅÃÙ¯á£Ê©¡¢ÍÔÅèÊäȹÚÀÊÕä»Ü¨ÐÂÑ¥¡¢ÞóÆÒâüÅûÅèèÒÑÌ¡¢ ÅýÑÄÇãÔïÆîħѥúýÎû FixPak ÍÐÔºÆßìÒȹÄæÑ¥¡¢Ä¾ÆÒâüèÒÑÌ¡¤ á£Ê© AIX Ó¼ÓÑÇã AIX ĸÐúÇ¡ÆÒÓÑÎûóòÕùÕ»¡¢îù¡¨ 1. ÅèèÒËóðßȴϯÎûËÎǹ¡¢ËðÆî db2stop force ÌÔÅïËôùÃÝðÍÔÈ´æñÕèÕ» èÒËó¡¤ 2. ËðÆî DB2 ê§Ü¡ÈùΤð (DAS) èÒËó ID¡¢ËðÆî db2admin stop force ÌÔÅïËôùÃÝð DAS èÒËó¡¤ 3. ެǹ /usr/lpp/db2_81/lib ÆøòçÄãÎûÔÏÌî db2.o óòÕù¡¤ 4. ËðÆî root ûâÓîàõÅø slibclean ÌÔÅ 5. ÙòóòÕù db2_36.o îïêû̯ެǹóò db2.o¡¢íýÌùÍÔÈ´ûâůÝÂÆ«ûâêÄѽ Ä¡Ó³¡¤îùËðÆîĶÇÄÌÔÅ cp db2_36.o db2.o -r--r--r-- bin:bin for db2.o Ó¼ÓÑÅ¢ÇßÈÝÔÏÌîÎìǵ¡¢îùËðÆîެǹóòÅîßå db2_36.o óòÕù¡¢ÙÚÈçÒÞÇÑÎû á£Ê©¡¤ Solaris É¢äÆô¿èº Ó¼ÓÑÇã¡ÖSolaris É¢äÆô¿èº¡×ĸÐúÇ¡ÆÒÓÑÎûóòÕùÕ»¡¢îù¡¨ 1. ÅèèÒËóðßȴϯÎûËÎǹ¡¢ËðÆî db2stop force ÌÔÅïËôùÃÝðÍÔÈ´æñÕèÕ» èÒËó¡¤ 2. ËðÆî DB2 ê§Ü¡ÈùΤð (DAS) èÒËó ID¡¢ËðÆî db2admin stop force ÌÔÅïËôùÃÝð DAS èÒËó¡¤ 3. ެǹ /opt/IBMdb2/V8.1/lib ÆøòçÄãÎûÔÏÌî libdb2.so.1 óòÕù¡¤ 4. ÙòóòÕù libdb2_36.so.1 îïêû̯ެǹóò libdb2.so.1¡¢íýÌùÍÔÈ´ûâ ůÝÂÆ«ûâêÄѽġӳ¡¤îùËðÆîĶÇÄÌÔÅ cp libdb2_36.so.1 libdb2.so.1 -r-xr-xr-x bin:bin libdb2.so.1 5. Ò³ÊäÔ¶æñÕèÕ»èÒËóàõÅø db2iupdt ÌÔÅï¡¢ËäÒ³ DAS èÒ ËóàõÅø dasupdt ÌÔÅ Ó¼ÓÑÅ¢ÇßÈÝÔÏÌîÎìǵ¡¢îùËðÆîެǹóòÅîßå libdb2_36.so.1 óòÕù¡¢ÙÚÈç ÒÞÇÑÎûá£Ê©¡¤ HP-UX Ó¼ÓÑÇã HP-UX ĸÐúÇ¡ÆÒÓÑÎûóòÕùÕ»¡¢îù¡¨ 1. ËðÆî db2stop force ÌÔÅïùÃÝðÍÔÈ´æñÕèÕ»èÒËó¡¤ 2. ËðÆî db2admin stop force ÌÔÅïùÃÝð DB2 ê§Ü¡ÈùΤð (DAS) èÒ Ëó¡¤ 3. ެǹ /opt/IBMdb2/V8.1/lib ÆøòçÄãÎûÔÏÌî libdb2.sl óòÕù¡¤ 4. ÙòóòÕù libdb2_36.sl îïêû̯ެǹóò libdb2.sl¡¢íýÌùÍÔÈ´ûâůÝ ƫûâêÄѽġӳ¡¤ËðÆîĶÇÄÌÔÅïÅèíýÏñÄ¡Ó³ÍÌ¡¨ cp libdb2_36.sl libdb2.sl -r-xr-xr-x bin:bin for libdb2.sl 5. Ò³ÊäÔ¶æñÕèÕ»èÒËóàõÅø db2iupdt ÌÔÅï¡¢ËäÒ³ DAS èÒ ËóàõÅø dasupdt ÌÔÅ Ó¼ÓÑÅ¢ÇßÈÝÔÏÌîÎìǵ¡¢îùËðÆîެǹóòÅîßå libdb2_36.sl óòÕù¡¢ÙÚÈçÒÞ ÇÑÎûá£Ê©¡¤ ̧ÆÆ UNIX É¢äÆË·ÜÓ ÇñΪÇã̧ÆÆ UNIX É¢äÆË·ÜÓĸëæÓÑ DB2 UDB ů Merant Driver Manager ÅÉÓòÎû̶ɷ¡¢îùôúᾡÖIBM ÊÀÝ´ÅÅßΡס¤ ËðÆî Tivoli Storage Manager ÏñÇôÈùΤð (AIX¡£Solairs É¢äÆô¿èº) ެǹ Data Links ÈùΤðÂÆÂÚõ ÙÂ÷ÇãâÐÈç DB2 Data Links Manager 8.1 ÎêÎûÇøæÒÍÐÜÃ÷ËÉ¢äÆÕë¡¢àÒÎÎÙò Data Links File Manager (DLFM) ØÄÌîÎû Data Links ÈùΤðÂæñÕèެǹ̯ Tivoli(R) Storage Manager ÏñÇôÈùΤð¡¤ÇãàëÓòĸÍÐÇøæÒÎíèèÞÞÉËÄãäÄüÏÆüĶ ÇÄ̧ÄãÄ¡ÜÚòãë¨Ø¹ÕÉ¡¨ DLFM129I: Automatic backup of DLFM_DB database has been triggered. Please wait for the backup to complete. DLFM901E: A system error occurred. Return code = "-2062". The current command cannot be processed. Refer to the db2diag.log file for additional information. -- ÍÐ -- DLFM811E: The current DLFM database could not be backed up. SQL code = "-2062", Return code = "-2062" DLFM901E: A system error occurred. Return code = "-2062". The current command cannot be processed. Refer to the db2diag.log file for additional information. ÔÏÇÞ¡¨DB2 Data Links Manager ÇøæÒá£È¢àÒÎÎÝÃÌùËðÆî Tivoli Storage Manager É¢Ò³ Data Links ÈùΤðÂÎûÏñÇô (ެǹ) ÈùΤðÂÕëÍÔëæÎûüÈí°¡¤ ÓÑÝÀ¡¨ÇãËðÆî Tivoli Storage Manager É¢Ò³ÏñÇôÈùΤð¡¢ÅâÌþÆÜâÐÈç DB2 Data Links Manager 8.1 ÎêÎûÇøæÒÍÐÜÃ÷ËÉ¢äÆÎûÚÅÎÓĶ¡¢ÚÀÆ«ÅèËðÆîĶÇÄÅÉÎÎËôËßÅÏ ÈºÙÂ÷îàõÆí¡¤ÓûÇ¿¡¢îùŦڷÇøæÒá£È¢ËðÆî Tivoli Storage Manager ެǹòÙâú¡¤ àÓÑ¥¡¢ÅèÅÃÙ¯ÅÉÈ¢ËôØÙåô Data Links Manager Îûê§Ü¡ÔÞÝÃÌùóò¡¢ÅèÅýÑÄïËåµÎû Tivoli Storage Manager üÈí°¡¢ÇñĶÇÄÊãüõ 2 ÄãÍÔÆü¡¤ÉùÈ©ÝÕ̥ԶɢäÆÄæÑ¥¡¢ îùú«úýâÐÈçÇøæÒÍÐÜÃ÷ËÉ¢äÆ¡¤ í²ÈçæØÊîÅÉÎΡ¨ÑºäùÍÔÇÄÎûȹʩÙÚÈçĶÇÄÉ¢äÆ¡¤ 1. ËðÆîĶÇÄÌÔÅïËôެǹ DLFM æñÕèÕ»¡¨ db2 backup ̧Ä㡨 * ÑÒ DLFM æñÕèÕ»ÎûÇØꢡ¤ÇãçßÝÃÎíÎÓĶ¡¢æÚæñÕèÕ»ê¢Ò³ DLFM_ DB¡¤ * ÑÒÚÀòÙðåÎûެǹóÃÇôÈíåôÄæÆøòçæûÕÀ¡¤ 2. ÅèÅÃÙ¯ÅÉÈ¢ËôØÙåô Data Links Manager Îûê§Ü¡ÔÞÝÃÌùóò¡¢ÅèÅýÑÄïËåµÎû Tivoli Storage Manager üÈí°¡¤ÅÃÙ¯ØÙåôá£Ê©Å¯ÆÒÓÑÎûüÈí°ë©ÍüÍõĶÇÄÅÆǵ Åä÷îÄ㡨 * ËðÆî Tivoli Storage Manager É¢Ò³ÏñÇôÈùΤð (AIX) * ËðÆî Tivoli Storage Manager É¢Ò³ÏñÇôÈùΤð (Solaris É¢äÆô¿èº) ÚÀľƫÅèÇãîÀĸÎû¡ÖDB2 æñعÄãÅÀ¡×ÍÐ DB2 Data Links Manager Administration Guide and ReferenceÎû System Management Option ÝýåçÄù ÊÆ̯ÝÕËèÅä÷ * ÇñΪÚÀÑÒÙÚÈç DB2 Data Links Manager 8.1 ÎêÎûÇÀä»ÇøæÒ¡¢ÚÀÄØÉùÈ©ÍÔ È´Êãüõ¡¤ * Ó¼ÚÀÆßÓÑÜÃ÷ËÈÝ DB2 Data Links Manager 8.1 Îê¡¢îùÓìä»ÙÚÈç¡ÖÜÃ÷ËÄü Æîá£È¢¡×db2dlmmg¡¤ SQLFLAG(STD) Щåôî¾úÁðÂòÙâúòãë¨ ÇñΪÚöÆî SQLFLAG(STD) Щåôî¾úÁòÙâú¡¢Ð¬ÆÆäÄÝßȩĶÇÄòã먡¨ ÙÚÈç¡ÖЩåôî¾ úÁ¡×á£È¢ DSNHPC ÕëàõÆíܬڦÄãÅÏ C6 åµËðÆî¡ÖâäàõÄãÅÀ¡×ËôÐúÇ¡ SQL óÃÇôá£Ê©ÅèÇã DB2 for z/OS ÜÉ 8 ÎêĸÙÚÈç Õë¡¢îùØæƪ SQLFLAG (STD) Щåôî¾úÁòÙâú¡¤ SQL ڦȢî¾úÁÌÔÅïÎû DB2 UDB æûÕÀ (Windows) DB2_SQLROUTINE_COMPILE_COMMAND Ý×Ú¦ÄâëæÓÑÝÃÌù¡¤àÓÈÔ¡¢åµÚÀÇã Windows ĸ ÝÃÌùÆÆÕë¡¢ÇÞÒ³ %DB2PATH% üÈí°ÅýÉÖçßÝÃæûÕÀ "C:\Program Files\IBM\SQLLIB" ¡¢Èþ̧ÄãÎû "Program" êØ "Files" ÄæâæȴϨ֪¡¢ÍÔÅèÆ«×ääÄðÒÓ³ÙÂ÷ɻËðÙò ðìÔ¶ÌÔÅïÔ«ÅèÅ¿æÀÑÄÈî¡¢ÄóÆ«×äàõÆíÝÕÔ¶ÙÂ÷ í²ÈçæØÊîÅÉÎÎÑÒËðÆî %DB2PATH% Ô«Îûàû֪Ȣ¡¤ÇãçßÝÃÚÅÎÓÄã¡¢ÝÕÑÒ "C:\PROGRA~1 \IBM\SQLLIB"¡¤ÚÀÆ«ÅèÙò %DB2PATH% ÝÃÌùÒ³ DB2 UDB ÇøæÒæûÕÀÎûàû֪Ȣ¡¨ set db2path=C:\PROGRA~1\IBM\SQLLIB ËäÅèçßÝÃÔ«ÙÚÈç DB2_SQLROUTINE_COMPILE_COMMAND¡¨ db2set DB2_SQLROUTINE_COMPILE_COMMAND="cl -Ox -W2 -TC -D_X86_=1 -MD -I%DB2PATH%\include SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def /out:SQLROUTINE_FILENAME.dll %DB2PATH%\lib\db2api.lib" ÍÐϯ¡¢ÅèæûÕÀÔ«Îûàû֪Ȣ̽Åî %DB2PATH% ËôüÈÊÕÌÔÅïÔ«ÆÛËΡ¨ db2set DB2_SQLROUTINE_COMPILE_COMMAND="cl -Ox -W2 -TC -D_X86_=1 -MD -IC:\PROGRA~1\IBM\SQLLIB\include SQLROUTINE_FILENAME.c /link -dll -def:SQLROUTINE_FILENAME.def /out:SQLROUTINE_FILENAME.dll C:\PROGRA~1\IBM\SQLLIB\lib\db2api.lib" ÍÔËðÆîÎûèÒëãæûÕÀÆÒâüÑÒÇøæÒ DB2 UDB ÎûæûÕÀ¡¤ËóÇñ¡¢ÇñΪ DB2 UDB ÇøæÒÇã D: éöé÷ñ¢Ä¸ÎûÒÞÇÑæûÕÀ¡¢Ð¬ÝÃÌùÙòÑÒ "D:\PROGRA~1\IBM\SQLLIB"¡¤ ØæÏæÇøæÒħÍÔÈ´ÅÆǵê¡ùË¡¢ÉÁЬÅÆǵä²ÞòÆ«×ääÄÆÂÚõ (AIX) ÇñΪÚÀÆÜÇøæÒ DB2 HTML ÅÆǵ CD ĸÍÔÈ´ÎûÅÆǵê¡ùË¡¢Ð¬ä²Þò"ÍÔÈ´Åä÷î"Îûè©æÜ Æ«×ääÄÆÂÚõ¡¤È´Ä¡Ô¶ InvalidParameterException Æ«×ääÄÇãößûªðÂÎû Java ÅäÚÕ ÆºÄãÞÞÉË¡¢ÈÔÅâÚÀÙòÚÙÈ­Äâ̯ǶÈôä²Þòá¸Îª¡¤ Ó¼ÓÑæØÊîÅÆǵä²ÞòÙÂ÷î¡¢îùÙÚÈçĶÇÄ̧ÄãÄ¡âúÉ¢äÆ¡¨ * Çã¡Öä²Þò¡×áþá§ÄãÎûä²Þòî¯ÞØÛÒÞÌÕúÄùâÐÈçòÙ̽¡¢ÅèôãÄÑä²Þòî¯ÞØ¡¤ * ÇøæÒ DB2 HTML ÅÆǵ CD ÄãÎûÍÔÈ´ÅÆǵê¡ùË¡¤ ËðÆî Java 2 JRE1.4.0 ÍÔç²Ì¯ÎûÅÆǵä²ÞòÙÂ÷î ÇñΪÚÀÎûößûªðÂËðÆî Java 2 JRE V1.4.0¡¢ÈÔÚÀÎûÅÆǵÑÒÇøæÒÇãÉÖȴϨ֪ÎûæûÕÀÄã (ËóÇñ¡¢ C:\Program Files\SQLLIB\doc\) ¡¢Ð¬ÅÆǵä²Þò Applet Æ«×ääÄÆÂÚõ¡¢ ÇÑÕëÇãößûªðÂÎû Java ÅäÚÕƺÄãäÄßÈËò InvalidParameterException ÞÞÉË¡¢ÈþÊô È´ä²Þòá¸Îª¡¤ÝÕÔ¶ÙÂ÷îÇã JRE V1.4.1 ÄãÄØåîڵ̯ԺÆß¡¤ Ó¼ÓÑæØÊîÅÆǵä²ÞòÙÂ÷î¡¢îùÙÚÈçĶÇÄ̧ÄãÄ¡âúÉ¢äÆ¡¨ * ÙòößûªðÂÎû JRE ÎêÆÛŪ×È̯ 1.4.1¡¢Æ«ÇãÝÕÔ¶ê½ÉßÄãÊÆ̯¡¨ http://java.sun.com/j2se/1.4.1/download.html * ÙòößûªðÂÎû JRE ÎêÆÛÓñ×È̯ 1.3.x¡¢Æ«ÇãÝÕÔ¶ê½ÉßÄãÊÆ̯¡¨ http://www.ibm.com/software/data/db2/udb/ad/v8/java/ Íõ DB2 GUI ÄÖ̦ÄãüÏÆü Indic ÇóÄ÷ ËðÆî DB2 GUI ÄÖ̦ÕëÓ¼àÒÎÎüÏÆü Indic ÇóÄ÷¡¢ÚÀÎûË·ÜÓÆ«×äÊôÈ´ÇøæÒÆÒÓÑÎûÇó ÐΡ¤ DB2 Universal Database ÄØÅýæÒħĶÇÄ IBM TrueType ÌÏ OpenType ÅÒËóÈ¢ Indic ë£ËÆÇóÐÎËòÚÀËðÆÚÀÆ«ÅèÇãǶġĶÇÄ CD Îû font ÆøòçÄã¡¢ÊÆ̯ÝÕËèÇó ÐΡ¨ * IBM Developer Kit, Java Technology Edition, Version 1.3.1 for AIX operating systems on 64-bit systems * Java application development and Web administration tools supplement for DB2, Version 8.1 ÝÕËèÇóÐÎÆ·êØ DB2 UDB ä®ØÙËðÆÚÀàÒÎÎÚ·Ëçè×ÝÕËèÇóÐÎÄæÄ¡×ïÍÐàÒÓî̱ïÚÙÇÍÐ ØÙØÊÝÕËèÇóÐΡ¨ ÏÐ 6. êØ DB2 Universal Database Ä¡ØÄÐìæÒÎû Indic ÇóÐÎ +-----------------------+----------------------+----------------------+ | ÇóüÕ | ÜÏÜØ | ÇóÐÎóòÇØê¢ | +-----------------------+----------------------+----------------------+ | Devanagari MT for IBM | ïËÄã | devamt.ttf | +-----------------------+----------------------+----------------------+ | Devanagari MT for IBM | ÜÏüÕ | devamtb.ttf | +-----------------------+----------------------+----------------------+ | Tamil | ïËÄã | TamilMT.ttf | +-----------------------+----------------------+----------------------+ | Tamil | ÜÏüÕ | TamilMTB.ttf | +-----------------------+----------------------+----------------------+ | Telugu | ïËÄã | TeluguMT.ttf | +-----------------------+----------------------+----------------------+ | Telugu | ÜÏüÕ | TeleguMTB.ttf | +-----------------------+----------------------+----------------------+ ÚÀÆ«Íõ IBM Development Kit for Java ÅÆǵÎû Internationalization ÝÕÄ¡åçÄã ÊÆ̯ȴùÃÇñÈôÇøæÒÇóÐÎůԺÊÑ font.propertiesóòÎûæÛÜØë©Íü¡¤ ȺÆÀ¡¢Ä¶ÇÄ Microsoft ܨÐÂÇ©ßÈËòÆ«êØ DB2 GUI ÄÖ̦ä®ØÙËðÆîÎû Indic ÇóÐΡ¨ * Microsoft Windows 2000 É¢äÆË·ÜÓ * Microsoft Windows XP É¢äÆË·ÜÓ * Microsoft Publisher * Microsoft Office zSeries ÈùΤðÂÄâÅÅßÎ GUI ÄÖ̦ (Linux) Øæ¡ÖDB2 ÇøæÒ¡×ê´üñÄæÆÀ¡¢ÇãÙÚÈç Linux É¢äÆË·ÜÓÎû zSeries ÈùΤðÂĸ¡¢ GUI ÄÖ̦àÒÕ桤ȺÓî̱ÅýÉÖÝ×Ú¦Ú·¡ÖÇøæÒ¡×ÚöÙ¯á£È¢ (Çñ¡ÖʸÝÚðÒûª¡×) ÚöÙ¯ÎûǶÈô âúÆø¡¤ Ó¼ÓÑ GUI ÄÖ̦êØÝÕËèË·ÜÓä®ØÙËðÆî¡¢îùÇã̦ȴÄâÇÑË·ÜÓØÙåôÎûÆîÅÂê¦Ë·ÜÓÇøæÒê§ Ü¡ÄÖ̦¡¢àÓÑ¥ËðÆîÆÛÆîÅÂê¦ÝÙÚÙ zSeries ÈùΤ𡤠ã¾Ä«íºÆüë£ËÆóòÕùÕëÆÜܨÆí¡ÖæñعÐÎòçÄãÅÀ¡×ÅÊë¢óò ÇñΪÙòíºÆüë£ËÆóòÕùã¾Ä«¡ÖæñعÐÎòçÄãÅÀ¡×ÕëÆÜܨÆí¡ÖæñعÐÎòçÄãÅÀ¡×ÅÊë¢óò¡¢ îùÙÚÈçĶÇÄéêùÅÚêæØÊãüõ¡¨ Ú·ÌÔÅïÈçÙÚÈç db2icmimport Õ롨 * ÇñΪÆÜܨÆíòÓÅøóò (.xml¡£.out¡£.err¡£.log)¡¢Ð¬ÌÔÅïÈçÆ«×äÈ´òã 먡¤îùüÓøýЩÄìÔ¶Å¿í° (UserId¡£Password¡£Database¡£Catalog ů Tagfile) ÉáÆßíý¡¤òÓÄ« db2icmimport ÌÔÅïËôóôáþë£ÎΡ¤ÇñΪÝÕíµ àÒÎÎæØÊîÙÂ÷î¡¢îùËðÆî -g òÙâúÙòòÓÅøóÃÇô̯óòÕù¡¢ËôÔºÊÑ db2icmimport ÅèöÊ̽ db2javit ÌÔÅïÎûòÓÅø¡¤ËóÇñ¡¨ db2javit -j:com.ibm.db2.common.icm.tag.IcmImport -w: -i: -o:"-Xmx128m -Xms32m" -g:"d:\temp\myimport.trc" ... * ÇñΪÆÜܨÆíÅÊë¢óò¡¢Ð¬Ý×ڦȴġԶÔÈεòã먡¤îùÑçÒà .xml óòÕùů .out óòÕù¡¤ÇñΪƫÅèÎûæã¡¢îùÇãíºÆüë£ËÆóòÕùâäó¤ßÆÄ« ":COMMIT.CHKPID(DEBUG)" ÌÔÅȺÌÔÅïܨÆíØæòãÞÞÉËعÕÉ¡¢ËäóôÑç .xml ů .out óòÕùÑÒÉÁÈ´ÔÈεòã먡¤ * ÔÈεÄæÑ¥¡¢.log óòÕùóÜæÚäÄÅøÜ¢òã먡¤Ü¨ÆíØæòãÞÞÉËÄæÑ¥¡¢îùÑçÒà .log óòÕùů .out óòÕùÅè̽ڵæñع¡¤ * Ä¡ÌùÓÑóôÑç .err óòÕùÅèڵϡÑÒÉÁÈ´ÙÚÈçÕëßæòã먡¤ ËðÆîæñعÐÎòçÄãÅÀ GUI ã¾Ä«íºÆüë£ËÆóòÕùÕ롨 * ËðÆî GUI ÄõÓòã¾Ä«íºÆüë£ËÆóòÕùÕë¡¢ÄâäÄܨÆí .out ÍÐ .err óò Õù¡¤ * ÇñΪܨÆíħ .log ÍÐ .xml óòÕù¡¢îùè©æÜËðÆîÝÕËèóòÕùËôØæò㡤 * ÇñΪÆÜܨÆí .log ÍÐ .xml óò¡¢ÍÐÝÕÔ¶óòÕùÊôÈ´Æî¡¢îùÚ·ÌÔÅïÈçÙÚ Èçã¾Ä«á£Ê©Åè̽ڵæÛÜØæñع¡¤ ÝÙḠQuery Patroller æñÕèÅý ÇñΪÇãÔïÆî fixpak ÄæÑ¥ÆÜÝÙḠQuery Patroller æñÕèÅý¡¢Ð¬ÇãËðÆî¡ÖQuery Patroller ÄãÅÀ¡×ÍÐ Query Patroller ÌÔÅïÈçÕë¡¢ÊôÈ´ DBADM ûâÓîÍÐïËåµ Query Patroller ÙñÆîûâÎûËðÆîϯƫ×ääÄç²Ì¯Ä¶ÇÄòã먡¨ SQL0001N - ÆÜâûɳÉùÈ©ÝÙá¸ÍÐЩåôî¾úÁ¡¤ ÇñΪÚÀËðÆîÎûÑÒ¡ÖQuery Patroller ÄãÅÀ¡×¡¢SQL0001N òãë¨ÙòØ´ç¥Çã qpdiag.log óò¡¤ÇñΪÚÀËðÆîÎûÑÒ Query Patroller ÌÔÅïÈ硢Ь SQL0001N äÄã®Çß̯ÅäÚÕƺ ÈÜÙ¯ÝÙá¸á£È¢î£ÇôÇã¡¢ÅèØÄÌîÈÜÙ¯ÝÙḡ¤àÓÈÔ¡¢åµÝÙÚÙÄãËðÆîϯÊôÈ´ÙÚÈç Query Patroller æñÕèÅýÄãÍÔÈ´ÝóÓÝÈ¢ÍÔëæÎûÙñÆîûâÕë¡¢ÈÜÙ¯ÝÙá¸ÙòÆÂÚõ¡¤ÝÕÔ¶ÙÂ÷îÎû ÖêÎíÑÒ¡ÖQuery Patroller ÄãÅÀ¡×Äã×ÍÅ·æñÕèÉ衤 Ó¼ÓÑõâÉ­ÝÕÔ¶ÙÂ÷î¡¢ÇãÔïÆî fixpak ÄæÑ¥¡¢Ì¦È´ DBADM ûâÓîÍÐÆÒÓÑÙñÆîûâÎûËðÆî ϯóÜæÚÅèÅÃÙ¯ÅÉÈ¢ÝÙḠqpserver.lst æñÕèÅý¡¤ ÇøÇÀô¿èº (Windows) ÇñΪÚÀÇã Windows ĸËðÆî DB2 Universal Database гĴÄâÑÒ Windows Ë·ÜÓÎû ê§Ü¡ÔÞ¡¢ÚÀÆ«×ääÄç²Ì¯óòÕùÝÂÆ«ûâÎûÙÂ÷ÇñΪÚÀȭ̯ SQL1035N¡£SQL1652N ÍÐ SQL5005C òãë¨Ø¹ÕÉ¡¢Æ«×äÎûÔÏÇÞůí²ÈçæØÊîÅÉÎÎüÏÆüÇñĶ¡¨ ËðÆîϯÇã sqllib ÆøòçĸÊôÈ´ËÍÙÜÎûûâÓî ÙÂ÷î Çãè©æÜâäÚö DB2 CLP ÍÐÌÔÅïáþá§Õë¡¢ËðÆîϯȭ̯ SQL1035N ÍÐ SQL1652N òã먡¤ DB2 Universal Database á£È¢î£ (ÕøÅÀóòÕù)ÑÒÇøæÒ ÇãÄ¡Ô¶ìÑÄ«ÙñÆîûâ̯̿Óî̱ÎûÆøòçá¸é¬Äã¡¢ÈþÑÜËè DB2 Universal Database ÄÖ̦гëæÓÑìÑÄ«ÝÕÔ¶ DB2INSTPROF ÆøòçËäÇãÝÕÔ¶ÆøòçÄãÐúÇ¡ óòÕù¡¤ í²ÈçæØÊîÅÉÎÎ ÐúÇ¡Ä¡Ô¶ÚÀÆ«ÅèÚ·ÄãÚæêØËðÆîϯÈÝÅ·ÑÒ MODIFY ÝÂÆ«ûâÎûä»Æøòç¡¢ËäËð Æî db2set -g db2tempdirËôÑÀÇ×ÝÕÔ¶ä»Æøòç¡¢ÍÐϯÇã Windows Ë·ÜÓô¿ èºÄãÝÃÌù db2tempdir üÈí°¡¤ ËðÆîϯÊôÈ´ËÍÙÜÎûûâÓîËôìÑÄ« sqllib\ Æøò硢ɻËðÅìÔ¯úèÍõ SYSADM_GROUP Ä¾Ä¡íµ ÙÂ÷î Çãè©æÜÊÕä»æñÕèÕ»ê§Ü¡á£È¢ØÙåôóò (update dbm cfg) Õë¡¢ËðÆîϯ ȭ̯ SQL5005C Ë·ÜÓòã먡¤æÚËðÆîϯÊôÈ´ÆÒÓÑÎû NTFS ûâÓîËôìÑÄ« sqllib\instance_dir Æøò硢ɻËðÚÀÄØåîÙòÝÕÇØËðÆîϯÅûÄ« SYSADM_GROUP Ä¾Ä¡íµ¡¤ ÜÉÄ¡Ô¶í²ÈçæØÊîÅÉÎÎ ÚæêØæÚËðÆîϯ (ÇãóòÕùË·ÜÓìÒȹ) è× instance_dir ÆøòçÈÝÅ·ÑÒ MODIFY ÎûÝÂÆ«û⡤ ÜÉĨԶí²ÈçæØÊîÅÉÎÎ ÐúÇ¡Ä¡Ô¶ÚÀÆ«ÅèÚ·ÄãÚæêØËðÆîϯÈÝÅ·ÑÒ MODIFY ÝÂÆ«ûâÎûä»Æøò硤ËðÆî db2set db2instprofÌÔÅïËôÑÀÇ×ÝÕÔ¶ä»Æøò硤ÚÀÙòÆÒâüÓìÐúæÚèÒËó¡¢Åè ÏíÙòæñعóÃÇôÇã db2instprof ÍÔÑÀÌùÎûä»èÒËóÆøòç͵Ķ¡¢ÍÐϯÚÀÆÒâü Ùò÷®ÎûèÒËóÆøòçÜÃ̯ä»ÎûÆøòçÄ㡤 XML Extender î¯Ëóá£È¢ÄØÊÕÇØ Ýåǹ XML Extender î¯Ëóá£È¢Æ«×äêØ̧ÆÆÄØÇøæÒÎûá£È¢ÇÑÇØ¡¤ãôÆÀÇâÌËƵƶġԶêØ XML Extender î¯Ëóá£È¢ÇÑÇØÎûá£È¢Æ«×ääÄä´ø®ÚÀÎû XML óòÕù¡¤Ä¶ÓòÛÒÞÌüÏÆü÷®Îû XML Extender î¯Ëóá£È¢ÇØꢡ¢Åèůç¤ÄâäÄÝßÈ©îíÒóÎûä»åôßÐá£È¢ÇØꢡ¤íýÌùÚÀËð Æîä»Îûî¯Ëóá£È¢ÇØꢡ¢ÈÔÄâÑÒ÷®ÎûÇØꢡ¢ÅèËßÅÏä´ø®ÚÀÎû XML óòÕù¡¤ ÏÐ 7. åôßÐ XML Extender Îûî¯Ëóá£È¢ (Windows) +----------------------------------+----------------------------------+ | ÷®á£È¢ (ÄâËðÆî) | ä»á£È¢ (ËðÆî) | +----------------------------------+----------------------------------+ | insertx.exe | dxxisrt.exe | +----------------------------------+----------------------------------+ | retrieve.exe | dxxretr.exe | +----------------------------------+----------------------------------+ | retrieve2.exe | dxxretr2.exe | +----------------------------------+----------------------------------+ | retrievec.exe | dxxretrc.exe | +----------------------------------+----------------------------------+ | shred.exe | dxxshrd.exe | +----------------------------------+----------------------------------+ | tests2x.exe | dxxgenx.exe | +----------------------------------+----------------------------------+ | tests2xb.exe | dxxgenxb.exe | +----------------------------------+----------------------------------+ | tests2xc.exe | dxxgenxc.exe | +----------------------------------+----------------------------------+ ÏÐ 8. åôßÐ XML Extender Îûî¯Ëóá£È¢ (UNIX) +----------------------------------+----------------------------------+ | ÷®á£È¢ (ÄâËðÆî) | ä»á£È¢ (ËðÆî) | +----------------------------------+----------------------------------+ | insertx | dxxisrt | +----------------------------------+----------------------------------+ | retrieve | dxxretr | +----------------------------------+----------------------------------+ | retrieve2 | dxxretr2 | +----------------------------------+----------------------------------+ | retrievec | dxxretrc | +----------------------------------+----------------------------------+ | shred | dxxshrd | +----------------------------------+----------------------------------+ | tests2x | dxxgenx | +----------------------------------+----------------------------------+ | tests2xb | dxxgenxb | +----------------------------------+----------------------------------+ | tests2xc | dxxgenxc | +----------------------------------+----------------------------------+ ËðÆîä»î¯Ëóá£È¢êØî¯Ëó sqx óò ǿЩÇÄÅøÄæÆ«ÙÚÈçóòÎûÔÏÌîî£ (.sqx files) ÈíÍõÇøæÒÎû samples\db2xml\c Æø ò硤ËôäãóòÄóÅè÷®ÇØê¢íºÆü¡¤ÇñΪÚÀüÈÊÕÔÏÌî¢îùÙòä»î¾úÁÎûÆ«ÙÚÈçóò (̦ȴ ÷®ÇØê¢) îïêû̯ sqllib\bin Æøò硤Çã Windows ÆÍƺĸ¡¢ÚÀÆÒâüƶÆÀâÐÈçîïêû¡¢ Ùò̧ÊÕÇØҳĸÓÝä»ÇØꢡ¢ËäÙò̧îïêû̯ bin Æøò硤ÝÕÌ¥Ô¶îïÆÛäÄåôßÐ bin Æøòç ÄãÜ¢ÇôÎûóòÕù¡¤ËóÇñ¡¢î¾úÁä»Îê shred.exe ÄæÑ¥¡¢ÚÀÆÒâüîïêû̥ǹËäåôßÐ bin ÆøòçÄãÎûóòÕù¡¨Ä¡Ô¶íºÆüÒ³ shred.exe¡¢Æ¶Ä¡Ô¶Ð¬ÊÕÇØÒ³ dxxshrd.exe¡¤Çã UNIX ÆÍƺĸ¡¢ÚÀÆ·ëæÅèä»î¾úÁÎûÎêÆÛåôßÐ̦ȴ÷®ÇØê¢ÎûóòÕù¡¤ÇñΪÚÀÚ·ÝÕËèî¯ËóÄãÐú Ç¡ä»ÎûÆ«ÙÚÈçóò¡¢Ð¬ÆÒâüÙòä»óòÕùÚ· \SQLLIB\samples\db2xml\c\ Æøòçîïêû̯ \SQLLIB\bin\ Æøòç¡¢àÓÑ¥êûÉ¢÷ìÆÀÎûîïÆÛ¡¢ËäÕüðãǿЩÎûÏÐÖªËôÊÕÇØÆÆÔ¯¡¤ Çã XML Extender Ä㡢šæØÅýÉÖÏæÙÄÄ¡úèÍÌůÄ÷×ÃÇØê¢ÎûÄ÷ǵ Ü¢ÇãÚÀÆ«ÅèÅ¡æØÅýÉÖè×ÑÐ̯ÄâÇÑÎþúñ (ÈíÍõÒÞÇÑÍÐÄâÇÑÏÐÖªÄã) ÄæÏæÙÄÄ¡úèÍÌÍÐ ÏæÙÄÄ¡Ä÷×ÃÇØê¢ÎûÅÆǵ¡¢ÈÔÄâäÄȭ̯ DXXQ045E òã먡¤ÅèĶÑÒ̦ȴÏæÙÄÄ¡úèÍÌů ÏæÙÄÄ¡Ä÷×ÃÇØê¢Îû XML ÅÆǵî¯Ëó¡¨ ODBC --> DB2 --> DB2 Ë·ÇÄ¡¤ ÝÕÕëäÄâäÚö¡ÖÌùåøÔ¿óÃËôäã¡×á­Ø´ÆÛ¡¤ âäÚö¡ÖÌùåøÔ¿óÃÆøíº¡×á­Ø´ÆÛ ÄØüÈÊÕâäÚö¡ÖÌùåøÔ¿óÃÆøíº¡×á­Ø´ÆÛÎûá£Ê©¡¤ Ó¼ÓÑâäÚö¡ÖÌùåøÔ¿óÃÆøíº¡×á­Ø´ÆÛ¡¨ 1. Ú·¡ÖæñÕèÔ¿óÃÄãÅÀ¡×áþá§ÅèäìçñÆ­õïѺġĶԿóÃÆøíºæñÕèÉ衤 2. ѺġĶÌùåø --> ODBC --> DB2 --> DB2 Ë·ÇÄ¡¤ ÝÕÕëäÄâäÚö¡ÖÌùåøÔ¿óÃÆøíº¡×á­Ø´ÆÛ¡¤ ÝÃÌùÔ¿óÃÅÊë¢óòÎûÛÒØæÓî̱ ÅÊë¢óòäÄÏñÖçØ´òç¡¢Îþ̯ç®Ì¯ÑÀÌùÎûÓÓí°Óî̱¡¤çßÝÃÓÓí°Óî̱ÑÒ 1000 á­Ø´ò硤 Ý×Ú¦¡¢ÊäÄ¡âúÚÀÙÚÈçÎûÄÖÉ¢ÝçäÄÐúÇ¡ 12 ̯ 15 á­ÅÊë¢Ø´ò硤ÊÕ仡ÖÔ¿óÃÄùÕ©¡× Ó÷ÓòÎû¡ÖÈùΤð¡×íºü¾Ä¸ÎûåµØ´òçôêí°á«ÍõĶÇÄÕëÛÒØæØ´òçúñÈí¡¢ÙòÛÒØæÓî̱Ýà ҳÜÊÇÙÚÀëæÊåÎûí°Æø¡¤ CURSOR ç¥Ä«Îû¡ÖæñÕèÔ¿óÃÄãÅÀ¡×ÅÅßÎ DB2 UDB ç¥Ä«ÊãüõÜ¢ÇãÄøÝÂÙòäÍÜ©ÏÐÍÐÏÐ֪ɢҳÊãüõËôäã¡¢ÇÞȺܨÆíħ LOAD FROM CURSOR¡¤ ҳħè×ÑÐê´üñÄã CURSOR ç¥Ä«ÎûÎþúñ¡¢ÆÒâüòÙ̽ËíäùòÓÄ«óòÕùÄãÎûÎþúñÈíåôËôè× ÑÐÎþúñãÑâÚ¡¤ GUI ÄÖ̦ ¡ÖÚÕ̱ÄãÅÀ¡×ÆÀÚâá£È¢ÅÅßÎ ¡ÖÚÕ̱ÄãÅÀ¡×ÆøЩÅÅßÎÈÜÓÔæñÕèÉ衤ÈÜÓÔæñÕèÉèÆ«ÅýÑÄËðÆîϯòÙ̽ÎûË·ÜÓÍÐæñÕè Õ»Îìǵ¡¤ÖÖɱҳÑÜÔ¶ÈÜÓÔæñÕèÉèÐúÇ¡¡ÖÚÕ̱ÄãÅÀ¡×ÆÀÚâá£È¢ËäÄâÌ¿ÅÅßΡ¢ÈþÆ«Ò³ ÈÜÓÔæñÕèÉèÅýÉÖÎûÎìǵÐúÇ¡ÆÀÚâá£È¢¡¤È´ùáÖÚÕ̱ÄãÅÀ¡×ÆÀÚâá£È¢ÎûæÛÜØæñع¡¢ îùÙ¶ïå¡ÖÄõÜÕÚÕ̱ÄãÅÀÎûÆÀÚâá£È¢ÑÞ鬡×ÝÕÔ¶Åä÷ عÕÉÙ¶äù 8.1.4 Îê¡ÖæñعÄãÅÀ¡×عÕÉÅä÷î ¡ÖDB2 æñعÄãÅÀ¡×8.1.4 ÎêÄâÅýÉÖä»ÎûÅèůÄØÔºÊÑÎûعÕÉÅä÷ÚÀÆ«ÅèÇã IBM ê½ ×»Äã̽ڵä»ÎûÅèůÄØÔºÊÑÎûعÕÉÅä÷ http://publib.boulder.ibm.com/infocenter/db2help ADM عÕÉÊÕä» ADM5530E ÄØÄâÆßíýÇâÅ¡ùËÒ³òã먡¤ÆÆóÜæÚÅ¡ùËÒ³úÀÉËعÕÉ¡¤ÈºØ¹ÕÉÇã Windows ĸÎû¡ÖËçǵÅÊ뢡×ů UNIX ĸÎû¡ÖÝ×Ï¡ÅÊ뢡×Ä㡢شòçÒ³òã먡¤ÚÀóÜæÚÙò ADM5530E áþÒ³úÀÉËعÕÉ¡¤ ä»ìÁ SQL عÕÉ SQL20271W SQL20271W ÝóÓÝÈ¢Ä㡢ʩí°Èíåô "" ÇØê¢ "" Îû ÇØê¢Ý·èðöË¡¤ ë©Íü¡¨ ĸÓÝÝóÓÝÈ¢ÄãÈÝÅ·È´Ä¡Ô¶ÇØê¢Ý·èðöË¡¤ÜÉġԶݷèðöËÎûÇØê¢Æ«Æñ Ê©í°Èíåô "" ůÇØê¢ "" Ëôøüɱ¡¤ ÇñΪÚÀÙÚÈçÎûÑÒÄØÞ¬ÉôÄæÑçææÎûë©ÍüòÓÅø¡¢Ð¬Ê©í°ÈíåôêØÑçææÎûòÙ̽ÛÒ ÞÌÎþúñÒÞùᤠÇñΪÚÀÙÚÈçÎûÑÒ CALL ÝóÓÝÈ¢Îûë©ÍüòÓÅø¡¢Ð¬Ê©í°ÈíåôêØ CALL ÍÔæØε Äæá£Ê©Îû OUT ÍÐ INOUT Ù¶í°ÒÞùᤠÇñΪÚÀÙÚÈçÎûÑÒ CALL ÝóÓÝÈ¢Îûë©ÍüòÓÄ«¡¢Ð¬Ê©í°ÈíåôêØ CALL ÍÔæØε Äæá£Ê©Îû IN ÍÐ INOUT Ù¶í°ÒÞùᤠÎþúñÇØê¢ÍÐÙ¶í°ÇØê¢ç´ÏÛ¡¢ÍÐÑÒÇãÇóî£Ó÷÷ËßÐÄæÑ¥üÈÚµç´ÏÛ¡¤ ËðÆîϯÇßóÜ¡¨ è×ÍõÎþúñÇØê¢ÈÔËÆ¡¢ÇñΪÎþúñÎûíýÅ¢ÇØê¢ÑÒÈ´ãôåøÎû¡¢îùüÈÊÕÏÐÖª¡£äÍ Ü©ÏÐÍÐí´ê¢¡¢üéÎþúñÎûÇØê¢üÈàû¡¢ÍÐÑÒËðÆî̧Çóî£Ó÷ÄâäÄÝßÈ©ÎþúñÇØê¢ â¾ç´Æ«ÅÅßÎÄæÞ²ÄËÏÛÐùÎûÆîÅÂꦡ¤è×ÍõÙ¶í°ÇØê¢ÈÔËÆ¡¢ÇñΪٶí°ÎûíýÅ¢ ÇØê¢ÑÒÈ´ãôåøÎû¡¢îùüÈÊÕá£Ê©¡¢üéÙ¶í°ÎûÇØê¢üÈàû¡¢ÍÐÑÒËðÆî̧Çóî£Ó÷ ÄâäÄÝßÈ©Ù¶í°ÇØê¢â¾ç´Æ«ÅÅßÎÄæÞ²ÄËÏÛÐùÎûÆîÅÂꦡ¤ sqlcode¡¨+20271 sqlstate: 01665 ÎþúñÇØê¢ÍÐÙ¶í°ÇØê¢ïÎ̯èðöË¡¤ DBI عÕÉÊÕä» DBI1060E àÒÕæÎûæñÕèÅýÇØê¢ <"pkg-name"> ë©Íü¡¨ ÄØòÓÄ«ÄâÆßíýÎûÇØꢡ¤æñÕèÅýÄâÇôÇã¡¢ÍÐòÓīħÄâÆßíýÎûÇØꢡ¤ ËðÆîϯÇßóÜ¡¨ îùóôÑçġĶ¡¢ÑÀÌùÎûæñÕèÅýÎûÇØê¢ÑÒÉÁÇôÇãÍõÅ¡ß×È¢ÞèüÕĸ¡¤ÇñΪÇô Çã¡¢îùóôÑçÇØꢡ¢ÒàÒàÑÒÉÁÑ»ò㡤ÍÔÈ´æñÕèÅýÇØê¢óÜæÚÑÒÄÑìÑÇóüÕ¡¤ DBI1001I ÆîÎΡ¨ db2icrt [-a AuthType] [-p PortName] [-s InstType] [-w WordWidth] -u FencedID InstName ë©Íü¡¨ è× db2icrt ÌÔÅïòÓīħàÒÕæÎûÅ¿í°¡¤ÈºÌÔÅïÎûÈ´ÕæÅ¿í°Ò³¡¨ -h|-? üÏÆüÆîÎÎæñع¡¤ -d âäÚöØæòãí¼È¢¡¤ -a AuthType ÑÒèÒËóÎûûüɱùËÐÎ (SERVER¡£CLIENT ÍÐ SERVER_ENCRYPT)¡¤ -p PortName Ò³èÒËóÄãÍÔËðÆîÎûÜÃ÷ËÇØê¢ÍÐÜÃ÷ËæÀ¤ -s InstType ÑÒÓÑÐúÇ¡ÎûèÒËóùËÐÎ (wse¡£ese ÍÐ client)¡¤ -u FencedID ÑÒÙòÙÚÈççÒ÷â UDF ůçÒ÷âóÃÇôá£Ê©ÎûËð ÆîϯÇØꢡ¤ÇñΪƷÇøæÒ DB2 UDB ÆîÅÂꦡ¢Ð¬Äâëæ ÓÑÝÕÔ¶é¡íº¡¤ -w WordWidth ÑÒÓÑÐúÇ¡ÎûèÒËóìÏÐù (ÞÌÈíÑÒÈíÄ÷) (31¡£32 ÍÐ 64)¡¤ÚÀÆÒâüÇøæÒÆÒÞ¬Îû DB2 UDB ÎêÆÛ (31 ÈíÄ÷¡£32 ÈíÄ÷ÍÐ 64 ÈíÄ÷)¡¢Äß×äòÙ̽ïËåµÎû ìÏÐù¡¤çßÝÃìÏÐùÔ«ÑÒ DB2 UDB Ü¢ÈçÎêÆÛ¡£ÆÍƺů èÒËóùËÐÎÍÔÅÅßÎÎû޲ɥÈíÄ÷ìÏÐù¡¤ InstName ÑÒèÒËóÇØꢡ¤ ËðÆîϯÇßóÜ¡¨ Ó¼ëæÝÕÔ¶ÌÔÅïÎûæÛÜØæñع¡¢îùÙ¶ïåÇøæÒêØØÙåôæÐòÜÅÃÅõ¡¤ËðÆîÆßíýÎûòÙ âúêØÅ¿í°Óìä»òÓÄ«ÌÔÅ DBI1170E -w é¡íºÆ·ÚÙÌ¿ 31¡£32 ÍÐ 64 ɢҳƫ×äÎûòÓÄ«¡¤ ë©Íü¡¨ ËðÆî db2icrt ÍÐ db2iupdt ÌÔÅïÕë¡¢ÚÀÆ«ÅèÒ³òÙÆîé¡ íº -w ÑÀÌù 31¡£32ÍÐ 64 á«Ô«¡¤ÐúÇ¡ 64 ÈíÄ÷èÒËóÕë¡¢ÚÀÆ« ÅèÒ³ db2icrt ÑÀÌù -w 64¡¤Ùò 31 ÍÐ 32 ÈíÄ÷èÒËóÊÕä»Ò³ 64 ÈíÄ÷èÒËóÕë¡¢ÚÀľƫÅèÒ³ db2iupdt ÑÀÌù -w 64¡¤ ÉÁЬËäÄâ ëæÓÑ -w é¡æÀ¡¤ DB2 UDB Ü¢ÈçÎêÆÛ¡£ÆÍƺůèÒËóùËÐÎÆÒâüÅÅ ßÎÓÑÊÕä»ÎûÆÒÓÑÈíÄ÷ìÏÐù¡¤ ËðÆîϯÇßóÜ¡¨ Ó¼ëæÝÕÔ¶ÌÔÅïÎûæÛÜØæñع¡¢îùÙ¶ïåê§Ü¡ÅÃÅõ¡¨ÑÌÈçÅÃÅõ¡¤Ëð ÆîÆßíýÎûòÙâúêØÅ¿í°Óìä»òÓÄ«ÌÔÅ DBI1956E ÆîÎΡ¨ db2ilist [-w 31|32|64] [-p] [-a] [inst_name] ë©Íü¡¨ è× db2ilist ÌÔÅïòÓīħÄâÆßíýÎûÅ¿í°¡¤ÈºÌÔÅïÎûÈ´ÕæÅ¿í°Ò³¡¨ -h üÏÆüÆîÎÎæñع¡¤ -w 31|32|64 ÇÄÅø 31 ÍÐ 32 ÍÐ 64 ÈíÄ÷èÒËó¡¤-w òÙâúÆ«ä®ØÙ -p òÙâúËðÆî¡¢ËääÄÝ· -a òÙâúÍÔåôßС¤ -p ÇÄÅøèÒËóÙÚÈçÍÔÇãÎû DB2 UDB ÇøæÒæûÕÀ¡¤-p òÙâú Æ«ä®ØÙ -a òÙâúËðÆî¡¢ËääÄÝ· -a òÙâúÍÔåôßС¤ -a ã®ÇßÇÀÝåÒÞùÃÎûæñع¡¢ÅýÑÄèÒËóÒÞùÃÎû DB2 UDB ÇøæÒæûÕÀ¡¢Å¯Ì§ÈíÄ÷ìÏÐùæñع (32 ÍÐ 64)¡¤ â¡: ã®ÇßæñعÎûæñعӼҳ 32¡¢ÏÐÆü Linux (S/ 390¡£zSeries) ĸÎû DB2 ÑÒ 31 ÈíÄ÷ inst_name ã®ÇßÑÀÌùèÒËóÎûæñع¡¤ÇñΪÆÜÑÀÌùèÒËóÇØꢡ¢ db2ilist äÄã®ÇßÜ¢Èç DB2 UDB ÎêȹÍÔÈ´èÒËóÎûÒÞ ùÃæñع¡¤ ËðÆîϯÇßóÜ¡¨ îùÇÂòÓīġȹÌÔÅï¡¢ÇñĶÍÔÆü¡¨ db2ilist [-w 31|32|64] [-p] [-a] [inst_name] Query Patroller ÇãÙÚÈç¡ÖQuery Patroller ñ¥á£æñÕèܨÆíð¡×ÄæЩÐúÇ¡¡ÖæØúÁ¡×ÏÐÖª ÙÚÈç Query Patroller Îû¡Öñ¥á£æñÕèܨÆíð¡×Õë¡¢ÇñΪÊôÈ´¡ÖæØúÁ¡×ÏÐÖª¡¢Ü¨Æí ðÂÞóäÄÒ³ÚÀÐúÇ¡ÝÕËèÏÐÖª¡¤àÓÈÔ¡¢Ê¼Ô¯Ú°ÖÓÐúú¾ÚÀÇãÙÚÈç¡Öñ¥á£æñÕèܨÆíð¡×Äæ Щ¡¢Ç¿ÐúÇ¡¡ÖæØúÁ¡×ÏÐÖª¡¤åµÚÀÐúÇ¡¡ÖæØúÁ¡×ÏÐÖªÕë¡¢îùíýèÒÙòÆÆÔ¯ÐúÇ¡ÇãÒÞÇÑ Îûš޴ٴĸ¡¤ÅäÙ¯Ùò¡ÖæØúÁ¡×ÏÐÖªÐúÇ¡ÇãÒÞÇÑÎûš޴ٴĸ¡¢Æ«ìÁâСÖæØúÁ¡×ñ¢×ä ÎûÕæ×䡤ÝÕâúÊÑâÐÆ«ìÁÅû¡Öñ¥á£æñÕèܨÆíð¡×ÎûÕæ×䡤 óôÑçñ¥á£Å¡ÎµÎû Query Patroller ÅÊë¢óò ÇñΪ Query Activity over Time (ñ¥á£Å¡Îµ) ÞÞÉËÎû Explain Run ÎþúñüÏÆüÑç ææÎûÎíèèÒ³ Ran unsuccessfully¡¢ÞóÏÐÆüÌþÆÜØÜè×æÚÑçææܨÆíñ¥á£Å¡Îµ¡¤ÇÞȺ¡¢ ÑçææÙòÄâäÄÅøÜ¢ÇãǶÈôñ¥á£Å¡ÎµÞÞÉËÍÐè·Ê°Ä㡤ÇñÜÉ 8 ÎêÍÔÓÝ¡¢Ó¼ÓÑɲöËÑçææÆ ÚõÎûÔÏÇÞ¡¢îùóôÑç qpuser.log óòÕù¡¤ ØæħóôÑç qpuser.log óòÕùÄæÆÀ¡¢ÚÀľóÜæÚóôÑç qpdiag.log óòÕù¡¤ Ù¯èèÑçææùËɱÊÕä» ÑÜËèÑçææùËɱɢäÆÄâÇÂëæÓÑ Query Patroller ØôÅÏËäÓìä»ÚöÙ¯¡¢É»Æ«ÆíÕ桤 Çã͵ĶÎûÏÐÖªÄ㡢ɢÆîÄãÑçææÉ»ÑÒ̧ÎíèèÒ³¡ÖÙÚÈçÄã¡×ÍСÖÄØåôÍõÈïÇÄ¡×ÎûÑçæ桤 ÏÐ 9. ÑçææùËɱüÈÊÕÆíÕæÎû۾ǵ +----------------------------------+----------------------------------+ | üÈÊÕÎûÆÛï³ | üÈÊÕÆíÕæÎû۾ǵ | +----------------------------------+----------------------------------+ | ä»ìÁ¡£ØæƪÍÐÊÕä»ÑçææùËɱ¡¤ | ÇñΪÊôÈ´É¢ÆîÄãÑçææ¡¢üÈÊÕÙòÇ¡É»Æí | | | Õ桤 | +----------------------------------+----------------------------------+ | ÑçææùËɱÎûÊÕ仡¢ã¯ÅýÑÄÞ²ÄËÑçææí° | É»ËðÈ´É¢ÆîÄãÑçææ¡¢ËíàÓÇ¡É»ÆíÕ桤 | | ÆøÎûüÈÊÕ¡¤ | | +----------------------------------+----------------------------------+ | ÑçææùËɱÎûÊÕ仡¢ã¯ÅýÑÄÞ²ÄËÑçææÈ© | ÇñΪȴɢÆîÄãÑçæ桢ЬÇãàõÆíĶÇÄÚÅ | | ÆÛÎûüÈÊÕ¡¤ | ÎÓÕë¡¢ÊÕä»É»äÄÆíÕ桨 | | | * Query Patroller ØôÅÏËäÓìä»Úö | | | Ù¯¡¤ | | | * ÇÂľÊôÈ´É¢ÆîÄãÑçæ桤 | | | | | | â¡: åµè×Þ²ÄËÑçææÈ©ÆÛÈ´Ä¡Ô¶óêåôÎû | | | üÈÊÕÕë¡¢ ЬѥúýǶÈôê¡ùËÎûÑçææùË | | | ɱÊÕä»ÙòÄâäÄÆíÕæ¡¢Îþ̯ÜÊÇÙǿЩ̥ | | | Զ۾ǵÄæÄ¡¡¤ | +----------------------------------+----------------------------------+ | ä»ìÁÍÐØæƪÑçææùËɱ¡¤ | ÇñΪȴɢÆîÄãÑçæ桢ЬÇãàõÆíĶÇÄÚÅ | | | ÎÓÕë¡¢ä»ìÁÍÐØæƪɻäÄÆíÕ桨 | | | * Query Patroller ØôÅÏËäÓìä»Úö | | | Ù¯¡¤ | | | * ÇÂľÊôÈ´É¢ÆîÄãÑçæ桤 | +----------------------------------+----------------------------------+ Ú¥ÎíÑçææÈçÒ³ Ú¥ÎíÑçææàÒÎÎåôÍõÈïÇÄÄ㡤ÒÞÅ°Çâ¡¢ÇñΪڥÎíÑçææâ¾ÅøÆßÚ¦ÚÅÎÓĶÙòðÒÓ³ÆÆåôÍõ ÈïÇÄÎûõ§ÒÌÔ«Õë¡¢ÙòÇ¡É»ÙÚÈ硤 ܬڦùÃÝð¡Öñ¥á£æñÕèܨÆíðÂ¡× ÇñΪÚÀÙÚÈç¡Öñ¥á£æñÕè¡×ܨÆíðÂËäÅèܬڦÅÉÎÎùÃÝðÆÆ¡¢Ð¬ÇãĶȹè©æÜÙÚÈç¡Öñ¥á£ æñÕè¡×ܨÆíðÂÕë¡¢ÚÀÙòȭ̯ġԶòã먡¤Ü¬Ú¦ùÃÝðÎûî¯ËóÅýÑÄ¡¨ * DB2 UDB ÏæçßßæØôÅÏ * àõÅø db2stop force ÌÔÅï * àõÅø killdb2 ÌÔÅï 嵡Öñ¥á£æñÕè¡×ܨÆíðÂܬڦùÃÝðÕë¡¢ÚÀÆÒâüÇãè©æÜÓìä»ÙÚÈç¡Öñ¥á£æñÕè¡×ܨÆíð ÄæЩ¡¢àõÅøĶÇÄÌÔÅ qp -d database generate historical_data stop ̧Äã database øüɱÆßÇãè×ÔáÄ¡Ô¶æñÕèÕ»ÙÚÈçÌÔÅ Ѻ SQL ÝóÓÝÈ¢ùËÐÎÎûÓî̱ êØǿЩÎûÅÆǵÒÞÅ°¡¢Ì¦È´Ä¶ÇÄÝóÓÝÈ¢ÎûÑçææÆ«ÅèåôÍõÈïÇÄ¡¨ * ÅýÉÖòûèè SQL (̦ȴÅäüÈí°) ÎûÑçææ * ÅýÉÖËÎÅ¡Ô«Ìªí° (IDENTITY_VAL_LOCAL) ÍÐâûÊ©Ô«Ìªí° (Çñ NEXT VALUE FOR ÍÐ PREVIOUS VALUE FOR) ÎûÑçææ Ë·ÜÓéñåÆá£È¢ SYSMON_GROUP database æñÕèÕ»ê§Ü¡á£È¢ØÙåôÙ¶í°åôßÐ DB2_SNAPSHOT_NOAUTH àô òçüÈí° É¢Ò³ SYSMON æñÕèÕ»ê§Ü¡á£È¢ìÒȹåúÜÚÄ¡ÝåǹÎûËðÆîϯ̦ȴÇô̽æñÕèջ˷ÜÓéñåÆ á£È¢æñÕèÎûûâÓ SYSMON ûâÓîåúÜÚäÄåôßÐ DB2_SNAPSHOT_NOAUTH àôòçüÈí°¡¢Ýàç´ÝÕê¡ÅÉÎΡ¢üéÊô È´Ë·ÜÓê§Ü¡ÍÐË·ÜÓÚÕ̱ûâÓîÎûËðÆîϯ×äÙÜÇô̽æñÕèջ˷ÜÓéñåÆá£È¢¡¤Ë·ÜÓéñåÆᣠȢæñÕèÑÒËðÆî snapshot éñåÆá£È¢ API¡£CLP ÌÔÅïÍÐ SQL ÏÐ֪̪í°ËôÇô̽Îû¡¤ ÚÀÆ«ÅèËðÆî SYSMON_GROUP æñÕèÕ»ê§Ü¡á£È¢ØÙåôÙ¶í°ËôÝÃÌù SYSMON ûâÓîåúÜÚ¡¤ SQL Reference SQL Óî̱ 32 ÈíÄ÷ÎêÆÛîÂîíÈÁÄãÎûÞ²ÄË NPAGES ÄØöÄÅòÈÝ 1 048 576¡¤ XML Extender ÄØØæƪ XMLVARCHAR UDT ÄËÄÑÓî̱ Ü¢ÇãÚÀÆ«ÅèÇãÚöÆîæñÕèÕ»ÄæЩÌùåø XMLVARCHAR ËðÆîϯÌùåøÄæùËÐÎÎûÄËÄÑ¡¤Ç¿ Щ¡¢åµÚöÆîħæñÕèÕ»ÅâǿЩÌùåøÎû XMLVARCHAR ÇôÇãÕë¡¢XML Extender É»äÄÆ Úõ¡¤îùÙÚÈçĶÇÄÊãüõ¡¢ËôüÈÊÕÄØÚöÆîÄææñÕèÕ»Îû XMLVARCHAR UDT ÄËÄÑ¡¨ 1. ެǹ̦ȴ XML Extender ×äÄ°ÄææñÕèÕ»ÄãÎûÍÔÈ´æñÕ衤 2. ÚïÛ¹ÍÔÈ´ XML âõÇÙÏÐÖªÍÐ XML Îþúñê¦ÏÐÖª¡¤ 3. ɳÆî dxxadm disable_db ÌÔÅïËôØôÆîæñÕèÕ»¡¤ 4. ÐúÇ¡ XMLVARCHAR ËðÆîϯÌùåøÎûùËÐΡ¤ 5. ɳÆî dxxadm enable_db ÌÔÅïËôÚöÆîæñÕèÕ»¡¤ 6. ÓìÐúËäÓìä»ç¥Ä«ÏÐÖª¡¤ ä»Îûô¿èºüÈí°¡¨DB2DXX_MIN_TMPFILE_SIZE DB2 XML Extender Æ«ÅèÙòÄËÐÎÅÆǵåôÍõí²Çôóò¡¢ÅèõâÉ­ÇãݨܡßæâæËðÆîÅ´ÇéÎûØ´ ðÙüÕ¡¤Çã̦ȴÄËâØèÒüÕØ´ðÙüÕÎûË·ÜÓĸ¡¢ÚÀÆ«ÅèõâÉ­ÙòÅÆǵÜÃ̯í²Çôóò¡¢ËôàµÅ· òÓÄ«/òÓÅøÒ¤Ù¯Îûí°âØ¡¤ô¿èºüÈí° DB2DXX_MIN_TMPFILE_SIZE ÑÀÆü XML Extender ËðÆîØ´ðÙüÕîÂîíÙ´¡¢ÈÔÄâÑÒí²Çôóò¡¢ËôݨܡÅÒÑÀÌùÔ«õäÓÑÄÑÎûÅÆǵ¡¤ÝÕÔ¶üÈí°ã¯ ïËÆîÍõÈùΤð¡¢ÈÔÄâïËÆîÍõÆîÅÂꦡ¤ÇñΪȴÇéÔ¶èÒüÕåçöµÙ¶êØÇéåçöµÅ¡Þ´Ù´¡¢Ð¬ Æ«ÅèÇãÊäÄ¡Ô¶åçöµÄ¸ÅèÄâÇÑÅÉÈ¢ÝÃÌùüÈí°¡¢ê´íýÇâÅ°Ž¢¦þÊäÄ¡Ô¶åçöµÄ¸ÍÔÇøæÒÎûØ´ ðÙüÕí°âØ¡¤ÇñΪÆÜÝÃÌùô¿èºüÈí°¡¢ÄËÍõ 128KB ÎûÅÆǵÙòÇãݨܡßæâæÈÜÙ¯ÍóÄ«í²Çô óò¡¢ÄÑÍõ 128K ÎûÅÆǵЬÙòÇãØ´ðÙüÕÄãݨܡ¡¤ ÏáòçA. DB2 UDB FixPak CD Æøòçá¸é¬ Windows É¢äÆË·ÜÓ FixPak CD ĸÎûóòÕùÈíåôÇñĶ¡¨ ÏÐ 10. Windows óòÕù +------------------+--------------------------------------------------+ | óòÕù | Èíåô | +------------------+--------------------------------------------------+ | DB2 ܨÐÂóòÕù¡¨ | x:\db2 | +------------------+--------------------------------------------------+ | ÇøæÒÎÃãôËçâú¡¨ | x:\doc\\install.txt | +------------------+--------------------------------------------------+ | ÇøæÒÎÃãôËçâú (HT | x:\doc\\install.htm | | ML)¡¨ | | +------------------+--------------------------------------------------+ | Úæûâóò¡¨ | x:\db2\license | +------------------+--------------------------------------------------+ | ÎêÆÛÎÃãôËçâú¡¨ | x:\doc\\release.txt | +------------------+--------------------------------------------------+ | ÎêÆÛÎÃãôËçâú (HT | x:\doc\\db2ir\index.htm | | ML)¡¨ | | +------------------+--------------------------------------------------+ UNIX É¢äÆË·ÜÓ FixPak CD ĸÎûóòÕùÈíåôÇñĶ ÏÐ 11. UNIX óòÕù +------------------+--------------------------------------------------+ | óòÕù | Èíåô | +------------------+--------------------------------------------------+ | DB2 ܨÐÂóòÕù¡¨ | /cdrom/db2 | +------------------+--------------------------------------------------+ | ÇøæÒÎÃãôËçâú¡¨ | /cdrom/doc//install.txt | +------------------+--------------------------------------------------+ | ÇøæÒÎÃãôËçâú (HT | /cdrom/doc//install.htm | | ML)¡¨ | | +------------------+--------------------------------------------------+ | Úæûâóò¡¨ | /cdrom/db2/license | +------------------+--------------------------------------------------+ | ÎêÆÛÎÃãôËçâú¡¨ | /cdrom/doc//release.txt | +------------------+--------------------------------------------------+ | ÎêÆÛÎÃãôËçâú (HT | /cdrom/doc//db2ir/index.htm | | ML)¡¨ | | +------------------+--------------------------------------------------+ ̧Ä㡨 * x: ÑÒÑÀÚÀÎûǼé÷ñ¢ (Windows) * /cdrom ÑÒÑÀæÒç¥öµ (UNIX) * ÑÒÑÀë£ËÆÆøòç¡¢ÆñÄìÔ¶ÇóÄ÷ÎûÇóî£ÍÔÜÚÈ©¡¢ÝÕÔ¶Çóî£è×óÜÍõĶÇÄ ÛÒÞÌÄãÎû̧ÄãÄ¡Ô¶ë£ËÆ¡¨ ÏÐ 12. ÆøòçÇØê¢Å¯Ì§è×óÜë£ËÆ +----------------+----------------------------------------------------+ | Æøòç | ë£ËÆ | +----------------+----------------------------------------------------+ | ar_AA | ÏßÍÖɤÅÆ | +----------------+----------------------------------------------------+ | bg_BG | ÏñÅûɳËéÅÆ | +----------------+----------------------------------------------------+ | cs_CZ | ÚÚɬÅÆ | +----------------+----------------------------------------------------+ | da_DK | ÄåÞ§ÅÆ | +----------------+----------------------------------------------------+ | de_DE | ìáÅÆ | +----------------+----------------------------------------------------+ | el_GR | ʨøéÅÆ | +----------------+----------------------------------------------------+ | en_US | ÓÁÅÆ | +----------------+----------------------------------------------------+ | es_ES | ÈéÖÝÅÛÅÆ | +----------------+----------------------------------------------------+ | fi_FI | ÏÅû¢ÅÆ | +----------------+----------------------------------------------------+ | fr_FR | ÎÎÅÆ | +----------------+----------------------------------------------------+ | hr_HR | ɬøåÔìÈéËéÅÆ | +----------------+----------------------------------------------------+ | hu_HU | ÇÊÅÛɳÅÆ | +----------------+----------------------------------------------------+ | it_IT | åøÄËɳÅÆ | +----------------+----------------------------------------------------+ | iw_IL | ʨɤËôÅÆ | +----------------+----------------------------------------------------+ | ja_JP | ÅÊÅÆ | +----------------+----------------------------------------------------+ | ko_KR | ö§ÅÆ | +----------------+----------------------------------------------------+ | nl_NL | Ý£û¢ÅÆ | +----------------+----------------------------------------------------+ | no_NO | ÕáÐäÅÆ | +----------------+----------------------------------------------------+ | pl_PL | ÎÌû¢ÅÆ | +----------------+----------------------------------------------------+ | pt_BR | Å»Èéæ¹áëÅÛÅÆ | +----------------+----------------------------------------------------+ | pt_PT | æ¹áëÅÛÅÆ | +----------------+----------------------------------------------------+ | ro_RO | øåØëÆÇËéÅÆ | +----------------+----------------------------------------------------+ | ru_RU | ÏúÅÆ | +----------------+----------------------------------------------------+ | sk_SK | ßÚҨDZɬÅÆ | +----------------+----------------------------------------------------+ | sl_SI | ßÚÒ¨êÄÆÇËéÅÆ | +----------------+----------------------------------------------------+ | sv_SE | å¯Ì¨ÅÆ | +----------------+----------------------------------------------------+ | tr_TR | ÄÈÈÖ̧ÅÆ | +----------------+----------------------------------------------------+ | zh_CN | öüüÕÄãÅÆ | +----------------+----------------------------------------------------+ | zh_TW | ôíüÕÄãÅÆ | +----------------+----------------------------------------------------+ â¡: 1. ÆøòçÇØê¢Æ«×äÒ³ÄËìÑÍÐÄÑìÑÇóüÕ¡¢ÕüðãÚÀÎûÉ¢äÆË·ÜÓÈÔÌù¡¤ 2. ÄæЩÛÒÞÌÄãÎûÍÔÈ´ÆøòçÆ«×äÄâäÄÅøÜ¢ÇãÝÕÅÚ CD¡¢ÇÞÒ³ËäÏæÍÔÈ´ CD ĸÝçßÈ ËòÍÔÈ´ë£ËÆÆøò硤 ÏáòçB. Ò¥ææ IBM ÇãÓ¡ÙÏ¡¢îùí¡ÅèĶ̧ÄãÄ¡Ô¶çÙæãËôÝÙá¾ IBM¡¨ * 1-800-IBM-SERV (1-800-426-7378)¡¢ÐêÅÂÅÅßÎÄãÅÀ * 1-888-426-4343¡¢Ì½ÚµÆ«ÆîΤ٭òÙâúÎûæñع * 1-800-IBM-4YOU (426-4968)¡¢DB2 ÆËÞÛïÚÙÇ ÇãÅûÕÕÄË¡¢îùí¡ÅèĶ̧ÄãÄ¡Ô¶çÙæãËôÝÙá¾ IBM¡¨ * 1-800-IBM-SERV (1-800-426-7378)¡¢ÐêÅÂÅÅßÎÄãÅÀ * 1-800-465-9600¡¢Ì½ÚµÆ«ÆîΤ٭òÙâúÎûæñع * 1-800-IBM-4YOU (1-800-426-4968)¡¢DB2 ÆËÞÛïÚÙÇ Ó¼ÓÑÞòÊÆÚÀÍÔÇãÄæÙÏÕ¥ÍÐÇâÙ´Îû IBM òÖËçݨ¡¢îùÑçïåÈíÍõ http://www.ibm.com/planetwide ê½×»Îû¡ÖIBM ÇÀÛþôúá¾×»ÇØòç (Directory of Worldwide Contacts)¡× B.1 ܨÐÂæñع ÚÀÆ«Åè÷³ÆñçÙæãÍÐÝàç´ÇÀÛþæñØ¹ê½ (WWW) http://www.ibm.com/software/data/ db2/udb¡¢Ì½Úµ DB2 Universal Database ܨÐÂÎûÒÞùÃæñع¡¤ æÚê½×»ÅýÉÖħÊÀÝ´è·ÕóÕ»¡£ÓÔõÕÕóú¦¡£Ü¨ÐÂĶ祡£ä»êÌåúÜÚ¡£ÔºÆßóòÕù¡£ä»êÌů Web æñäãù¹á¸á«Þ²ä»æñع¡¤ ÇñΪÚÀÈîÇãÓ¡ÙÏåµÇâ¡¢îùí¡Ä¶ÇÄÄ¡ÜÚçÙæãæÀ¨ * 1-800-IBM-CALL (1-800-426-2255)¡¢ÓÔõÕܨÐÂÍÐ̽ڵġ×ïæñع¡¤ * 1-800-879-2755¡¢ÓÔõÕÅøÎêС¤ ùÃÍõÇñÈôôúá¾Ó¡ÙÏÅèÆÀÇâÙ´Îû IBM Îûæñع¡¢îùæüÈÝ www.ibm.com/planetwide IBM Worldwide Ó÷Óò¡¤ ÏáòçC. ÎÃãôËçâú Çã̧ÆÆÙÏÕ¥Äã¡¢IBM Æ«×äÄâäÄßÈËòÆÛÕóÄãÍÔßÈÎûÇÖâúܨС£Î¤Ù­ÍÐÅü×䡤ÓÑÏ¡ç¬ ÚÀÍÔÇãÙ´ÙÑÑÒÉÁÆ«Æî̯ÝÕËèܨÐÂêØΤ٭Õë¡¢îùÇ×åµÇâÎû IBM Τ٭ÅîÏÐÑçæ桤ÆÛÕó ÇãßÈů IBM ܨС£á£È¢ÍÐΤ٭Õë¡¢ÄâÏÐÆüÍÐä¼ÆüÆ·×äËðÆî IBM ÎûܨС£á£È¢ÍРΤ٭¡¤Æ·ÓÑÆÜÏëÆç IBM ÎûßáìäØÂܨû⡢ǶÈôÅü×äÒÞåµÎûܨС£á£È¢ÍÐΤ٭ÝçÆ«Åè ̽Åî IBM ÎûܨС£á£È¢ÍÐΤ٭¡¤Äâç´¡¢Ì§ÆÆÏæ IBM ܨС£á£È¢ÍÐΤ٭ÇãçªÉ¢Ä¸ Îûâ£ì¤êØüÓøý¡¢Ì§ÝÊǶúèÍõËðÆîϯ¡¤ ÇãÝÕÆÛÕóÍÐÅÆǵÄãÆ«×äÅýÉÖáá IBM ÍÔðßÈ´ÄæÙñɳÍÐÙñɳÆóîùÕù¡¤ÆÛÕóËðÆîϯËäÄâ ËêȴЩÓÝÙñɳÄæǶÈôÚæû⡤ ÚÀÆ«ÅèÆîÕóÓòÅÉÈ¢ËôÑçææÚæûâ¡¢Ëô̪îùÙì̯¡¨ IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. Ó¼ÓÑÑçææÈ´ùÃĨÈíÄ÷ÜÚ (DBCS) æñعÎûÚæûâËçÌû¡¢îùôúá¾ÚÀÙÏÕ¥ÍÐÇâÙ´Îû IBM ßá ìäØÂܨÝåÏÜ¡¢ÍÐϯÆîÕóÓòÅÉÈ¢Ùì̯¡¨ IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106, Japan ĶÇÄÑôæ¯Ó¼êØæÚÙÏÍÐÇâÙ´ÄæÎÎÑ£Û¾à¡Íêú½¡¢É»áþÒ³ÄâïËÆ IBM ã¯ÅèÜ¢ÎíßÈËòÆÛ Õó¡¢ÈÔÄâßÈËòǶÈôÍüÆüÍÐó¼ÆüÄæÏñøý (ÅýÑÄÈþÄâÓîÍõÆ«ÙÇÍÌÍÐÜÊÇÙÖÖÌùÕæÆîÎûÏñ øý)¡¤Ó¼È´ËèÇâÙ´ÇãÑÜËèǨÍøĸËäÄâÄøÝÂÚêØæĸÓÝÏñøý¡¢Ð¬æÚÚêØæàÒÕ桤 ÆÛÕóÄãÆ«×ääÄÈ´ÊÀݴĸÍÐÚêÎêÇÍ̭ĸÎûÝÅ먡¤ÇÞȺ¡¢IBM äÄÌùßæÔºÓÔ¡§ËäÙòÔºÓÔ Ñ¥ÎûÄùÕ©×ÊÄ«ä»ÎêÄ㡤ÇÑÕë¡¢IBM ÚµòñÕëÊÑâÐËä (ÍÐ) üÈÙ¯ÆÛÕóÄãÍÔßÈůÎûܨÐÂů (ÍÐ) á£È¢¡¤ ÆÛÕóè×ÍõÏæ IBM ê½×»ÎûßÎÅ¿Æ·ÑÒҳħÅÉÏíÈÔßÈËò¡¢ËäÄâè×ÝÕËèê½×»É¢Ç¶Èôë¥Æ«¡¤ æÚËèê½×»Ä¸ÎûÄùÕ©ËäÏæÆÛ IBM ܨÐÂÄùÕ©ÎûÄ¡Ýåǹ¡¢ÆîÅÂËðÆîæÚê½×»ÕëóÜÈÜÈçÍÕðê Óøòò¡¤ åµÚÀßÈËòæñعῠIBM Õë¡¢ÚÀÉ»ÚæûâÄè IBM Åȩ̀ë¥Ò³ïËåµÎûÅÉÈ¢ËôËðÆîÍÐÅ¡ØÊæñ ع¡¢ÈÔÄâÆÒè×ÚÀÓ×ØÄǶÈôÝÊǶ¡¤ ÆÛá£È¢Äæô½ÚæûâϯӼʨ۬̽ڵÒÞùÃæñÕè¡¢ÅèÏíËðÆîĶÇÄæñعϯƫҥææ IBM¡¤Ì§Ä¶ ÇÄæñعÑÀÎûÑÒ¡¨ (1) ñÁÇ¡ÐúÇ¡Îûá£È¢êØ̧ÆÆá£È¢ (ÅýÑÄȺá£È¢) ÄæâæǨßÐæñعÎû ÅÉÈ¢ (2) ÒÞÄëËðÆîÄØǨßÐÄææñعÅÉÎΡ¤Ó¼È´Ç¶ÈôÙÂ÷îîùôúᾡ¨ IBM Canada Limited Office of the Lab Director 8200 Warden Avenue Markham, Ontario L6G 1C7 CANADA ĸÓÝæñÕèÎû̽ڵȴ̧ÖÖÖ±ÓÑǵ¡¢ÇãÑÜËèÚÅÎÓĶÆÒâüÅéâ¶ÅÉÚµËðÆ ÆÛÕóÍÔßÀÓÝÎûǶÈôá£È¢Å¯Ì§ÍÔÈ´Æ«ÆîÎûÚæûâááÉ¢ÑÒÆñ IBM ÍÔßÈËò¡¢Ëä̯̿¡ÖIBM ÐêÅÂÇÙÒü¡×¡£¡ÖIBM ÙÏëãá£È¢ÚæûâÇÙÒü¡×ÍÐ÷äÅÉÄæâæǶÈôÇÑá«ÇÙÒüÛ¾à¡Äæݽ¤ ȺâæÍÔÉÖÄæǶÈôÕæ×äæñÕè¡¢ÒÕÑÒÚµÈÜÚÕ̱Îûô¿èºÄæĶ¡§ÇÞȺÄâÇÑÉ¢äÆô¿èºÄæĶÍÔ ÚµÎûá¸Îª¡¢Æ«×ääÄÈ´ÐþÄËÎûոܬ¡¤ÝåǹàÁâØÆ«×äÑÒÇãâäàõÄãÎûË·ÜÓĸÙÚÈç¡¢ÇÞȺ ÄâÏñøýÆ«ÅèÚ·Ä¡×ïÎûË·ÜÓô½Ó³ÒÞÇÑÎûá¸Îª¡¤ÒÉÈÝÈ´ÝåǹÎûàÁâØ¡¢ÑÒɳÆîßÆæÐÎÎÈÔ ÚµÎûÈõÓÓÔ«¡¢Ì§èÒëãá¸ÎªÆ«×ääÄÈ´ÍÔÄâÇÑ¡¤ÆÛÕóÎûËðÆîϯóÜÕüðã̧ÖÖÈ´Îûô¿èº¡¢ üÓøýÅøïËÆîÎûæñÕ衤 ÆÛÕóÍÔßÈůÄæÏæ IBM ܨÐÂæñع¡¢ÏûÆñܨÐÂÎûËòóÜÙ¸¡¢ÍÐ̧ÅøÎêÎûôøÍüÍÐ̧ÆÆÄüâä ê§ç¬Ì½Úµ¡¤IBM ËäÆÜàÁæÜç´ÝÕËèܨС¢Ä¾àÒÎÎíýë¥ÝÕËèÏæ IBM ܨÐÂÎûÙÚÈçÕæ×ä¡£ ÒÞÕ©ÍÌ¡£ÍÐǶÈôè×ܨÐÂÎû̧ÆÆÅäÚ¯ÑÒÉÁÉùÇÀàÒ먡¤ÇñΪÚÀè×Ïæ IBM ܨÐÂÎûÍÌ×äÈ´ ǶÈôÎûéêÙ¡¢îùÝÝÇ×æÚܨÐÂÎûËòóÜÙ¸Ñçæ桤 È´ùà IBM ÆÜËôÙ¯Ç×ÎûǶÈôÝóÓÝ¡¢ã¯ÅîÏÐ IBM ÎûÆøíºÈÔÄØ¡¢ËäÆ«×äÍõÆÜËçÇ¿ôøÍü ÎûÚÅÎÓĶȴÍÔüÈÙ¯ÍÐèôÇß¡¤ ÆÛÕóÄãÉÖÈ´ÅÊÚ¦Ù¸äÆÒ¤Ù¯ÍÔÆîÎûæñÕèůÞÞÉËî¯Ëó¡¤Ò³Ä§ßÈËòÉùðìÎûë©Íü¡¢ÝÕËèî¯ ËóÅýÑÄԶĩ¡£ÄüƳ¡£ìÞàÖÌÏܨÐÂÎûÇØꢡ¤ÝÕËèÇØê¢ÇÀúèáð鬡¢Ó¼êØǶÈôÄüƳÎûÇØ ê¢ÌÏÈîÉßçØÇÑ¡¢×ÅúèÆÉÇÙ¡¤ ááÉ¢ûâÚæû⡨ ÆÛÕóÅýÉÖÔÏÌîë£ËÆÎûî¯ËóóÜÆîá£È¢¡¢ÆîÅèë©ÍüÇÖê¡É¢äÆÆÍƺĸÎûá£È¢ÝÃÓÓÊÀÝ´¡¤ ÚÀÆ«ÅèÙ×ÍõÒæàõ¡£ËðÆî¡£ïÚÙÇÍÐß×É©ÜÊÇÙÉ¢äÆÆÍƺ (ÆîÍõÙÚÈçÍÔìþìÑÎûî¯Ëóá£È¢) ÄæóÜÆîá£È¢ÝÃÓÓÄõÓòÎûóÜÆîá£È¢á«ÆøÎû¡¢ÅèǶÈôÊ°È¢îïêû¡£ÔºÊÑůß×É©ÝÕËèî¯Ëó á£È¢¡¢ÈÔàÒëæÅéâ¶á¿ IBM¡¤ÈþÝÕËèî¯ËóÒÕÆÜåîç´ÉùðìÎûàÁæÜ¡¤ÇÞȺ¡¢IBM ÄâäÄÏñ øýÍÐä¼ÆüÝÕËèá£È¢ÎûøØÌùÍÌ¡£Î¤Ù­×äÄ°ÍÐÅü×䡤 ÝÕËèî¯Ëóá£È¢ÍÐÑÒǶÈôÓÏÆíááÉ¢ÎûÊäġǹÑÂËÊÍÐǶÈôÝåǹ¡¢ÝçÆÒâü̦ȴĶÇÄÎûáá É¢ûâôøÍü¡¨ (C) (your company name) (year). Portions of this code are derived from IBM Corp. Sample Programs. (C) Copyright IBM Corp. _enter the year or years_. All rights reserved. C.1 Ù¸íº Ä¶ÇÄÝ´ë£ÑÒ IBM ÄüƳÇãÓ¡ÙÏů (ÍÐ) ̧ÆÆÙÏÕ¥ÎûÙ¸íº¡¢ÅâÈÝÅ·ÄØÝ·ÆîÍõ DB2 UDB ÅÆǵè·ÕóÕ»Îû̧ÄãġǹÅÆǵÄ㡤 ACF/VTAM iSeries AISPO LAN Distance AIX MVS AIXwindows MVS/ESA AnyNet MVS/XA APPN Net.Data AS/400 NetView BookManager OS/390 C Set++ OS/400 C/370 PowerPC CICS pSeries Database 2 QBIC DataHub QMF DataJoiner RACF DataPropagator RISC System/6000 DataRefresher RS/6000 DB2 S/370 DB2 Connect SP DB2 Extenders SQL/400 DB2 OLAP Server SQL/DS DB2 Information Integrator System/370 DB2 Query Patroller System/390 DB2 Universal Database SystemView Distributed Relational Tivoli Database Architecture VisualAge DRDA VM/ESA eServer VSE/ESA Extended Services VTAM FFST WebExplorer First Failure Support Technology WebSphere IBM WIN-OS/2z/OS IMS zSeries IMS/ESA ĶÇÄÝ´ë£ÑÒ̧ÆÆÄüƳÎûÙ¸íºÍÐâ¡ÅõÙ¸íº¡¢ÅâÈÝÅ·ÄØÝ·ÆîÍõ DB2 UDB ÅÆǵè·ÕóÕ»Îû ̧ÄãġǹÅÆǵÄ㡨 Microsoft¡£Windows¡£Windows NT Åèů Windows Ù¸íºÑÒ Microsoft Corporation ÇãÓ¡ÙÏů (ÍÐ) ̧ÆÆÙÏÕ¥ÎûÙ¸íº¡¤ Intel ů Pentium Ù¸íºÑÒ Intel Corporation ÇãÓ¡ÙÏů (ÍÐ) ̧ÆÆÙÏÕ¥ÎûÙ¸íº¡¤ Java ÅèůÍÔÈ´êØ Java È´ùÃÎûÙ¸íºÑÒ Sun Microsystems, Inc. ÇãÓ¡ÙÏů (ÍÐ) ̧ÆÆÙÏÕ¥ÎûÙ¸íº¡¤ UNIX ÑÒ The Open Group ÇãÓ¡ÙÏů̧ÆÆÙÏÕ¥Îûâ¡ÅõÙ¸íº¡¤ ̧ÆÆÄüƳ¡£Ü¨ÐÂÍÐΤ٭ÇØê¢Æ«×äÑÒ̧ÆÆÄüƳÎûÙ¸íºÍÐΤ٭íºë¢¡¤