DB2* for Windows** 95 & Windows NT** Version 2.1.1 APAR List ============================================================ FixPak 8096 (05/31/96): APAR # Defect Abstract ------- ------ --------------------------------------------------------------- IC11648 36663 Enabling escape clause by changing to = IX52691 33242 ICLUI 4733: db2dd tree list of packages overlaps if > 5000 pkgs IX53501 34590 Index built incorrectly IX54000 35971 The first dynamic SQL to a second database corrupts the package IX54047 36118 Getting SQL30073 RC 2121 when BINDING SPUFI from DB2/MVS IX54140 36090 The -r option of the CLP in db2/6000 v2 is very slow. IX54144 35814 DRDA Stored Procedure Call receive -303 unexpectedly IX54179 36204 Wrong DARI library unloaded when maximum exceeded IX54235 36193 bind with grant does not commit IX54242 36388 DB2/2 does not handle DRDA chaining correctly IX54351 36741 LOADing of IXF file results in SQL0406N IX54566 37139 RUNSTATS not invoked when REORGCHK UPDATE STATISTICS issued IX54699 37306 Connect to shared memory fails during connect IX54719 37038 Long fields corrupted IX54873 37984 multiple SBCS connects to DBCS database causes abend IX54916 38099 -902 on reorg with index. packed descriptor corrupt IX55033 38655 CICS/6000 terminates upon a SQL0998 from DB2/6000 v1.2 IX55039 38677 Large load with index(es) hangs IX55380 39492 Updating COLDIST values causes agent to crash IX55458 39807 BACKUP WITHOUT PROMPTING fails when one device fills up IX55831 40624 Memory not being freed when an sql statement being compiled IX55835 40627 Database restore trapped in sqlpcenv IX55842 40678 Improve usability for instance migration IX56212 41038 multiple connect deadlock because we need to revoke auth IX56308 41300 DB2/6000 AS ABENDS when executes SELECT with a lot of columns IX56408 41486 SQL2054N restoring V1 backup to V2 instance IX56523 41659 Select statement causes signal #11 in sqlisr2 IX56584 41767 SQL0804 is return when updating a table on DB2/MVS IX56633 41468 Missing +F sqlgmf and -ldb2gmf from db2mkrts.args file. IX56664 41477 create db, TEMPSPACE was created as SMS while specified DMS IX56811 42079 DB2 V2.1 IMPORT incorrect summary statistics IX56905 42348 DDCS Gateway looping 100% cpu with a certain select stmt IX56928 42275 Activating db will causes exclusive connection to work improper IX56928 43006 Update bsu API test driver IX57031 42454 SQL1035N from connect after activate/backup IX57283 42909 Long field data corrupted when multiple processes write/read to JR08605 33956 Binary compatibility between v2 client/server using sqlestat. JR08605 37169 V1 client compatibility support for OS/2 JR08626 34939 Problem Description JR08637 35943 DB2W does not capture PREP output with -z flag JR08644 35239 db2/2 2.1 backup to diskette fails JR08647 35191 Fix Unable to grow stack problem JR08649 35386 SQL01331N after migations from DDCS/2 2.2 to 2.3 JR08650 35454 Remove 8-user count restriction for Standalone/Single-User JR08657 35582 History file does not fully qualify the backup files. JR08661 35605 SQL104 with REXX program to get database manager configuration JR08671 36007 SQLSetCursorName should not return error when cursor length>18 JR08672 35591 Addition to defect 31772 JR08674 36174 trap in db2resdb using db backed up with quiesce option JR08675 36182 trap in db2dd if db2cli.ini contains longdatacompat=1 JR08678 36254 Cannot install db2/2 v2.1 in a directory with an extension JR08679 36094 cannot add tables names to schema JR08681 36365 System monitor returns incorrect time JR08683 36366 SYSADM_GROUP parameter gives access to wrong groups JR08684 36436 Dynamic SQL application gets -51 at runtime JR08689 36580 backup to sytos through user exit traps JR08690 36584 SQL0181N: CAE 2.1(OS/2,Win) inserting date in USA(DnLvl Server) JR08694 36612 EXPORT when export utility not bound to db give SQL3015N RC= JR08696 36652 Multiple connection from MS Access JR08698 36706 Client receives -1109 on calling remote REXX DARI in DB2/2 V2.1 JR08708 38040 S1104 from SQLSETPARAM WITH VARCHAR 255 ACCESSING HOST DB JR08713 37366 Codepage Conversion Table for 037 -> 367 JR08720 37583 DB2/NT Connect performance improvement. JR08721 37239 DB2V2.1 OS/2 lowercase table name problem JR08725 37784 Full sqlca not returned from DARI when sqlcode = 0 JR08729 37851 Gupta app gets -302 when using fix char input host var JR08731 37891 -302 returned after migration of COBOL apps with decimal data JR08743 38310 Missing functionality in DB2CMD.EXE JR08744 38315 Silent Install for DB2/NT JR08745 38358 Getting -332 when binding from cae/dos 1.2 thru ddcs/2 2.3 JR08746 38361 Rollforward fail due to opening wrong log file JR08755 38712 Cursor already open message when trying to open cursor JR08758 38703 Restore db via user exit hangs JR08763 38109 The count of rows loaded is mismatching on an asc restart JR08764 38949 The local date format for the Australian country code is wrong JR08779 38969 db2resdb fails with SQL2503 during the migration of a view JR08781 39091 Connect to DB2/2 V1 server does not return proper SQLCODE JR08787 39358 warnings not passed to odbc app. SQL0000 state 01502 JR08795 39478 User exit restore fails due to memory overwrite JR08797 37422 changes to db2evmon.SQC - reduce trace size JR08798 39661 sql0955 when sortheap not available in memory JR08799 39574 Fix fenced UDF problem on OS/2 JR08808 39912 Migrate V1 db lost dbauth entries granted by SYSIBM JR08810 39960 Make SQL_MAX_ROWS<=0 return all rows in SQLSetStmtOption JR08813 40017 GPF in DB2CLIW.DLL in Windows Client JR08824 40238 Some Generic API's do not thunk correctly : JR08825 40234 Use local not GMT for current timestamp JR08829 40410 sql1042 at restart time because of missing secondary log files JR08830 41830 Prepping and compiling w/ MicroFocus Cobol to remote db traps. JR08840 40569 Unable to restore 2.1.0 backup to 2.1.1 instance JR08841 40520 Release table locks for READ ONLY cursor stability cursors JR08843 40536 -551 on create db by user with SYSCTRL JR08855 40832 If CLOB is max size of declared column, SQL0804 is returned. JR08856 40841 Load trap when statistics and error in filetype-mod parameter JR08858 40854 Memory leak in application heap for static DDL statements JR08861 40921 Using ODBC customer gets GPF in DB2CLIW.DLL JR08866 41023 DDCS returns +100 for 2nd fetch when 1st fetch return neg code JR08871 41093 CAE/WIN 2.1 generates a wrong qry for SQLTables for AS400 3.1+ JR08880 41285 DB2/2 2.1.1 looking for APPC.DLL when Dos DB Req. tries to conn JR08890 41478 loging to remote database using ddcs or appc returns sql30082n JR08891 41385 LOAD traps on OS/2 in sqlu_getfree JR08893 40986 db2uexit indicator parameter should be 2 JR08895 41577 Engine crashes when using INTEGER on char column > 50 JR08898 41482 Add additional error checking and error mapping to sqlefrce_api JR08901 41741 optimization level 5 can choose bad access plan JR08904 41777 The rexx api sqluimpr does not set the host varible OUTPUT INTO JR08904 42395 fix code for the import API JR08912 41933 the rexx api sqluhops returns SQL2032 JR08915 41976 SQL0804N INSERTING BLOB from ODBC app JR08916 41981 Behaviour of sqlurllf API not correct in DB2/2. JR08919 42072 SQLUB_PARM_CHECK action for sqlubkup API 'breaks' DB2. JR08924 42210 Optimization level 5 takes too long JR08925 42239 LOAD REPLACE gets SQL0901N reason -2551 JR08929 42284 SQL902C rc=57 using DARI JR08932 42364 SQL30082 rc=0 maped to sql1403 for NON v2.11 CAE clients JR08935 41052 remote import can result in trapping or hanging dari JR08940 42523 SYS3175 in sqle_database_commit at CONNECT RESET JR08942 42572 Tablespace backup traps in sqledosd JR08946 42706 Abnormal disc. instead of normal disc. up to host dsnl500i JR08953 42930 Export host data HANG with DDCS/2 JR08955 42965 SQL2538N RESTOREing from diskette JR08958 43000 SYS3184 in DB2ENG.DLL during GET SNAPSHOT FOR LOCK JR08966 43268 CLI0109E INSERTING more than 5 grahic char to graphic (10) col JR08977 43409 SYS3175 trap - DB2RDS.DLL -function sqlv_sbcs_build_like_subpat PJ08845 40625 ODBC driver (CAE/WIN v2.1) does not work with AS/400 v3.05 PMR0947 41845 support needed for country code 038 PMR8X35 38691 Unexpected -420 when converting character to decimal ------------------------------------------------------------------------------ * are trademarks or registered trademarks of IBM Corporation. ** are trademarks or registered trademarks of their respective owners. ------------------------------------------------------------------------------