IBM DB2 Universal Database* for Windows 95** »P Windows NT** ª©¥» 6.1 PTF No: WR21302 VRMF: 06.01.0000.0060 +-- ³Æµù: ----------------------------------------------------------------+ | | ­Y­n§ó®e©ö¦a¾\Ū³o­ÓÀɮסA½Ð±N±zªº¦r«¬³]©w¬°³æ¶Z¦r«¬¡C | | ¦pªG±zªºÁ{®É­×¥¿µ{¦¡¬O 2002/04/01 ¤§«á±q IBM ¤ä´©©Ò¨ú±oªº¡A | ±z¥²¶·»P IBM ¤ä´©³sµ¸¦Ó¤£­n¦w¸Ë¦¹­×¥¿µ{¦¡ (FixPak)¡A¨Ã­n¨D | §ó·sª©ªºÁ{®É­×¥¿µ{¦¡¡C¦p¦1 ¹³B²z¬O°²³]±zªº¨t²Îª¬ºA¬O¤@­Pªº | ¥BÁ{®É­×¥¿µ{¦¡³£»ô¥þ¡C | | ¾ã­Ó¤å¥ó X: ªí¥Ü FixPak CD ©Ò¦bªº¥úºÐ¾÷¦Ó C:\SQLLIB ªí¥Ü DB2 | ²£«~¦w¸Ëªº¥Ø¿ý¡C | +-------------------------------------------------------------------------+ ¦¹ README ÀÉ®×¥]§t¤U¦C²£«~»P¤¸¥óªº¸ê°T¡G NT/95 ¯S©w¸ê°T -------------- DB2 Connect Personal Edition, V6.1 DB2 Connect Enterprise Edition, V6.1 DB2 Universal Database Enterprise Edition, V6.1 DB2 Universal Database Workgroup Edition, V6.1 DB2 Universal Database Personal Edition, V6.1 DB2 Universal Database Extended Enterprise Edition, V6.1 DB2 Software Developer's Kit, V6.1 DB2 Datalinks Manager, V6.1 DB2 Administration Client, V6.1 DB2 Run-Time Client, V6.1 --------------------------------------------------------------------------- 1. FixPak ¤º®e 2. ¦w¸Ëª`·N¨Æ¶µ 2.1 ¥²³Æ±ø¥ó 2.1.1 APAR IX73249 ¥²³Æ±ø¥ó 2.2 ¦w¸Ë¤§«e 2.3 ¦w¸Ë»¡©ú 2.4 µL¤H¦¡¦w¸Ë»¡©ú 2.5 ¦w¸Ë¤§«á 2.5.1 §ó·s®×¨Ò 2.5.2 ­«·s³sµ²ÀÉ®× 2.5.2.1 ­«·s³sµ²«D DRDA DB2 ¸ê®Æ®w 2.5.2.2 ­«·s³sµ² DRDA ¸ê®Æ®w 2.5.2.3 ­«·s³sµ²¯S©w¸ê®Æ¥] 3. Âø¶µ 3.1 ²£«~»PªA°È§Þ³NÀÉ®×®w 3.2 «È¤á¤ä´©¤¤¤ß 3.3 ­×¥¿ªA°È 3.4 MIN_DEC_DIV_3 Database Configuration Parameter ¬ÛÃö¸ê°T½Ð°Ñ¾\¤U¦CÀɮסG C:\SQLLIB\RELEASE.TXT X:\APARLIST.TXT =========================================================================== 2. ¦w¸Ëª`·N¨Æ¶µ 2.1 ¥²³Æ±ø¥ó ±zªº¨t²Î¥²¶·¤w¦w¸Ë DB2 UDB for NT/95 ª©¥» 6.1 ¥H¤Wªº²£«~¤~¥i¦w¸Ë¦¹ FixPak¡C ­Y­n½T©w¥Ø«e¦w¸Ëªº DB2 ²£«~¤§ª©¥»»P¼h¦¸¡A½Ð©ó MS-DOS ¼Ò¦¡¤U¿é¤J regedit ¡AµM«áÀˬdµn°O½X¤Uªº¼Æ­È HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\\Current Version¡C ¼Æ­È¦p¤U¡G ª©¥» "6" ª©¦¸ "1" ­×­q "0" ªA°È¼h¦¸ "WR21163" 2.1.1 APAR IX73249 ¥²³Æ±ø¥ó DB2 LIST DCS APPLICATIONS SHOW DETAIL ªº¿ù»~¿é¥X DB2 for MVS APAR PQ11645 ¥²¶·»P DB2 Connect APAR IX73249 ³sµ²¤Þ¥Î¡A¤~¯à¦b LIST DCS APPLICATIONS »P DB2 MVS DSP THD «ü¥O¤W´£¨Ñ¦³·N¸qªº¬Û¤¬Ãö«Y²Å°O¡C 2.2 ¦w¸Ë¤§«e ¤Þ¥Î¦¹ FixPak ¤§«e±z¥²¶·°±¤î¥þ³¡¸ê®Æ®w¬¡°Ê¡C°±¤î¥þ³¡À³¥Îµ{¦¡ ¨Ãµo¥X«ü¥O¡G db2stop db2admin stop 2.3 ¦w¸Ë»¡©ú ­Y­n±Ò°Ê FixPak¡A½Ð°õ¦æ X:\SETUP.EXE¡C 2.4 µL¤H¦¡¦w¸Ë»¡©ú ÀH FixPak °e¥Xªº SETUP.EXE ¥i°õ¦æ¡uµL¤H¦¡¦w¸Ë¡v¿ï¶µ¡C ¦¹¯S©Êªº»yªk¼g¦b§Ö³t¤Jªù®ÑÄy¤¤¡CFixPak ¤º§t¤@¦^À³ÀÉ ½d¨Ò (DB2FIXPK.RSP)¡G 2.5 ¦w¸Ë¤§«á ¥Ñ©ó·sªº³sµ²ÀÉ®× (.bnd) ¤wÀH FixPak °e¥X¡A¦w¸Ë FixPak ¤§«á¡A ¤½¥Îµ{¦¡¥²¶·­«·s»P©Ò¦³¸ê®Æ®w³sµ²¡C »Ý­n¸Ó¨BÆJ¤~¯à¨Ï FixPak ²£¥Í®Ä¯à¡C­«·s³sµ²ªºµ{§Ç¦p¤U¡A ¨C­Ó¸ê®Æ®w¥u»Ý­n°õ¦æ¤@¦¸¡C 2.5.1 ­«·s³sµ²«D DRDA DB2 ¸ê®Æ®w ¤Þ¥Î­×¥¿µ{¦¡«á±z¥²¶·°õ¦æ¤U¦C°Ê§@¡G db2 terminate db2 CONNECT TO db2 BIND C:\SQLLIB\BND\@db2ubind.lst GRANT PUBLIC db2 BIND C:\SQLLIB\BND\@db2cli.lst GRANT PUBLIC db2 terminate ªí¥Ü¤½¥Îµ{¦¡­n³sµ²ªº¸ê®Æ®w¦WºÙ¡CÀˬd DB2PATH Àô¹ÒÅÜ¼Æ ¥H½T©w¥¿½Tªº¸ô®|¡C DB2UBIND.LST »P DB2CLI.LST ¥]§t DB2 ¤@¯ë ¥²­nªº³sµ²ÀɮצC¥Ü¡C ¦pªG ¬O DB2 v1.x ¸ê®Æ®w¡A½Ð¤£­n³sµ² db2cli.lst¡C¬Û¤Ï¦a, ½Ð¨Ï¥Î db2cliv1.lst ©Î¦U§O¨Ï¥Î¯S©wªº³sµ² db2clics.bnd¡Bdb2cliur.bnd¡B db2clirr.bnd ¤Î db2cliv1.bnd¡C 2.5.2 ­«·s³sµ² DRDA ¸ê®Æ®w ¦pªG±z¨Ï¥Î DB2 Connect ¨Ó¦s¨ú¥D¹q¸£¸ê®Æ®w¡A±z¤]»Ý­n³sµ²·sªº³sµ²ÀɮסC ¦p¤W©Ò­z³s±µ¦Ü¥D¹q¸£¸ê®Æ®w¡AµM«á³sµ²¤U¦C¤½¥Îµ{¦¡¡G ¥D¹q¸£ «ü¥O ===== =================================================================== MVS BIND C:\SQLLIB\BND\@ddcsmvs.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC VM BIND C:\SQLLIB\BND\@ddcsvm.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC VSE BIND C:\SQLLIB\BND\@ddcsvse.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC OS400 BIND C:\SQLLIB\BND\@ddcs400.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC 2.5.3 ­«·s³sµ²¯S©wªº¸ê®Æ¥] ¦pªG±z¥u­n³sµ²¯S©wªº .bnd Àɨì¸ê®Æ®w¡A½Ð¹ï¨C¤@­Ó¸ê®Æ®wµo¥X¤U¦C «ü¥O ( ªí¥Ü³sµ²ÀɮצWºÙ¦Ó ªí¥Ü¸ê®Æ®w¦WºÙ)¡C db2 terminate db2 CONNECT TO db2 BIND C:\SQLLIB\BND\ BLOCKING ALL GRANT PUBLIC db2 terminate 2.5.4 DataJoiner §Û¼gºÞ²z¤u¨ã DataJoiner §Û¼gºÞ²z (DJRA) ¤u¨ã (djra.exe) ¦w¸Ë¦b SQLLIB\DJRA ¥Ø¿ý¡C 2.6 ¸Ñ°£¦w¸Ëª`·N¨Æ¶µ ¦b Windows NT ¨t²Î¤W§ó·s©Î¸Ñ°£ DB2 ²£«~ªº¦w¸Ë®É¡A±z¥²¶·¦Û¦æ Ãö³¬¾÷¾¹¤W©Ò¦³ªº DB2 ªA°È»Pµ{§Ç¡C ¦pªG¨t²Î PATH Àô¹ÒÅܼƪº¥Ø¿ý¤¤¦³ psapi.dll ÀɮסA«h¨t²Î·|¦Û°Ê Ãö³¬¾÷¾¹¤W©Ò¦³ªºªA°È»Pµ{§Ç¡C ¦pªG¨t²Î¤¤µL psapi.dll ÀɮסA§ó·s©Î¸Ñ°£¦w¸Ë¤§«e¥²¶·¦Û¦æÃö³¬ ©Ò¦³ªº DB2 ªA°È¡C 3. Âø¶µ 3.1 ²£«~»PªA°È§Þ³NÀÉ®×®w §¹¾ã¦Ó¥B³Ì·sªº DB2 ¸ê°T¡A¥]§t¥» Readme ¥Xª©«á¤~µo§Gªº¸ê°T¡A ½Ð¨Ï¥Î WWW ¤Wªº²£«~»PªA°È§Þ³NÀÉ®×®w¡G http://www.software.ibm.com/data/db2/library 3.2 «È¤á¤ä´©¤¤¤ß ­Y­n»P¼ô±x¸Ó²£«~ªº IBM ·~°È¥Nªí¹ï½Í¡A½Ð¼·¹q¸Ü 1-800-992-4777¡C «È¤á¤ä´©¤¤¤ß¤]´£¨Ñ¹q¤l¦¡ªº°ÝÃD»P¸Ñµª (Q&A) ½×¾Â¡C¥i³z¹L CompuServe¡BIBMLink »P Usenet Newsgroup ¦s¨ú³o¨Ç½×¾Â¡C (1) CompuServe - ­Y­n¦s¨ú CompuServe ªº½×¾Â¡A½Ð°õ¦æ GO IBMDB2¡C - ¦pªG±zµLªk¦s¨ú CompuServe, ¬ü¥[¦a°Ï½Ð¼· 1-800-848-8199¡C (2) Usenet Newsgroup: comp.databases.ibm-db2 - Internet Newsgroup ¬O¤@­Ó¥Î¨Ó°Q½× DB2 ¨t¦C²£«~°ÝÃDªº ¤@¯ë©Ê½×¾Â¡C (3) (IBMLink) Talklink OS/2 BBS - ­Y­n¦s¨ú IBMLink ¤Wªº½×¾Â¡A½Ð¨ì OS2BBS °Ï¬q¡C - ¦pªG±zµLªk¦s¨ú IBMLink¡A¬ü¥[¦a°Ï½Ð¼· 1-800-547-1283¡C 3.3 ­×¥¿ªA°È ¤U¸ü¹q¤l­×¥¿ªA°È¡A¤èªk¦³¨âºØ¡G (1) FTP ¨ì°Î¦W¦øªA¾¹ ftp.software.ibm.com (¤§«eºÙ¬° ps.boulder.ibm.com) ¦ì©ó 198.17.57.66¡C¨ì ps/products/db2/fixes/%L/%P/ %L ªí¥Ü¾A·íªº»y¨¥Àô¹Ò (¨Ò¦p english-us¡Bspanish¡Bgerman µ¥µ¥¡C)¡A¦Ó %P ªí¥Ü²£«~¦WºÙ/ª©¥» (¨Ò¦p db22v5¡Adb2aixv5 µ¥¡C). (2) ¨Ï¥Î WWW ÂsÄý¾¹¨Ó³s±µ¦Ü DB2 ªA°È»P¤ä´©ºô­¶¡G http://www.software.ibm.com/data/db2/db2tech/index.html (3) ¦b CompuServe¡A°õ¦æ GO IBMDB2¡CµM«á¨ì¾A·íªºÀÉ®×®w´M§ä FixPak¡C (4) ¦b IBM PCC BBS (¬ü°ê), ½Ð¼· (919) 517-0001 (Raleigh, NC) µM«á±q¥D¥\¯àªí¿é¤J "db2" ¨Ó´M§ä FixPaks¡C ¦pªG±zµLªk¦s¨ú¥H¤W¥ô¤@¦ì¸m, ½Ð¼·¹q¸Ü 1-800-992-4777 ¥H¯Á¨ú³o¨Ç FixPaks¡A±N·|¥H¶l¥ó¤è¦¡°eµ¹±z¡C ¬ü¥[¥H¥~ªº°ê®a¡A½Ð»P·í¦a DB2 «È¤áªA°È¤¤¤ß³sµ¸¥H¨ú±o¨ó§U¡C 3.4 MIN_DEC_DIV_3 Database Configuration Parameter The addition of the MIN_DEC_DIV_3 database configuration parameter is provided as a quick way to enable a change to computation of the scale for decimal division in SQL. It is possible that this may not continue as this exact same database configuration parameter in the future. Default=NO. Values: YES, NO. This db cfg parameter changes the resulting scale of a decimal arithmetic operation involving division. If the value is NO, the scale is calculated as 31-p+s-s' (see SQL Reference, Chapter 3, "Decimal Arithmetic in SQL"). If set to YES, the scale is calculated as MAX(3, 31-p+s-s'). This causes the result of decimal division to always have a scale of at least 3 (precision is always 31). Attention: Changing this db cfg parameter may cause changes to applications for existing databases. This can occur when the resulting scale for decimal division would be impacted by changing this db cfg parameter. Here are some possible scenarios that may impact applications. A view that was defined in an environment with one setting could fail with SQLCODE -344 when referenced after the db cfg parameter was changed to the other setting if the resulting scale of one of the view columns is changed. The message SQL0344N refers to recursive common table expressions, however, if the object name (first token) is a view, then you will need to drop the view and create it again to avoid the error. A static package will not change behaviour until the package is rebound, either implicitly or explicitly. For example, after changing from NO to YES, the additional scale digits may not be included in the results until rebind occurs. For any static packages that may experience this change, an explicit rebind command can be used to force a rebind. A check contraint involving a decimal division may restrict some values that were previously accepted by the check constraint. Such rows now violate the constraint but will not be detected until the one of the columns involved in the check constraint row is updated or SET INTEGRITY with IMMEDIATE CHECKED is processed. To force checking of such a constraint, ALTER TABLE to DROP the check constraint and then ALTER TABLE to ADD the constraint again. If any of these scenarios are possible on a database server with existing databases, the implications of changing the MIN_DEC_DIV_3 setting should be carefully considered. Also Note: there are no new message text for this parameter in the v6 or v71 timeframe. This implies the following two limitations: 1) The command "GET DB CFG FOR " will not display the MIN_DEC_DIV_3 setting. The best way to determine the current setting is to observe the side-effect of a decimal division result. For example, if the following db2 statement: VALUES (DEC(1,31,0)/DEC(1,31,5)) Returns sqlcode sql0419n, then the database does not have MIN_DEC_DIV_3 support or it is set to OFF. But if the statement returns "1.000", then MIN_DEC_DIV_3 is ON. 2) The command "? UPDATE DB CFG" displays a list of "config-keywords". MIN_DEC_DIV_3 does not appear in the list. --------------------------------------------------------------------------- * IBM Corporation ªº°Ó¼Ð©Îµù¥U°Ó¼Ð¡C ** ¬O¨ä¥L¬ÛÃö¾Ö¦³ªÌªº°Ó¼Ð©Îµù¥U°Ó¼Ð¡C --------------------------------------------------------------------------- *************************************************************************** ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 2001. ** ALL RIGHTS RESERVED. ** ***************************************************************************