=================================================================== Apars integrated into development levels from NLV2 to v212 ====================================================================== Defect APAR # Abstract ------ ------- ---------------------------------------------------- 38048 JR08753 Message DIA3875C erroneously written to db2diag.log when a Common Code 38813 IX59365 Use a more generous fudge factor for locks in sqlmonsz() Common Code 39172 JR08778 SQLDBS from a REXX app returns SQL2010 during backup OS/2 40238 JR08824 Some Generic API's do not thunk correctly : Windows 95,NT 40521 JR08835 DB2/2 APP which is also NETBIOS app does not work under 2.1 OS/2 40521 JR08835 DB2/2 APP which is also NETBIOS app does not work under 2.1 Common Code 40624 IX55831 Memory not being freed when an sql statement being compiled Common Code 40673 JR08817 provide concurrent access for threaded apps Common Code 40673 JR08817 provide concurrent access for threaded apps OS/2 40678 IX55842 Improve usability for instance migration Common Code 41478 JR08890 loging to remote database using ddcs or appc returns sql30082n Windows 95,NT 41731 IX56582 db2 use of popen causes problems on AIX V4 Common Code 41830 JR08830 Prepping and compiling w/ MicroFocus Cobol to remote db traps. Common Code 41917 IX56747 Incorrect error msg when implicitly connects with long db name. Common Code 41918 IX56720 Incorrect error msg when sqledrpd & sqlemgdb use long db name. Common Code 42079 IX56811 DB2 V2.1 IMPORT incorrect summary statistics Common Code 42210 JR08924 Optimization level 5 takes too long Common Code 42239 JR08925 LOAD REPLACE gets SQL0901N reason -2551 Common Code 42284 jr08929 SQL902C rc=57 using DARI Common Code 42348 ix56905 DDCS Gateway looping 100% cpu with a certain select stmt Common Code 42364 jr08932 SQL30082 rc=0 maped to sql1403 for NON v2.11 CAE clients Common Code 42523 jr08940 SYS3175 in sqle_database_commit at CONNECT RESET Common Code 42572 JR08942 Tablespace backup traps in sqledosd Common Code 42706 jr08946 Abnormal disc. instead of normal disc. up to host dsnl500i Common Code 42909 ix57283 Long field data corrupted when multiple processes write/read to Common Code 42930 JR08953 Export host data HANG with DDCS/2 Common Code 42965 JR08955 SQL2538N RESTOREing from diskette Common Code 43000 JR08958 SYS3184 in DB2ENG.DLL during GET SNAPSHOT FOR LOCK Common Code 43006 ix56928 Update bsu API test driver Common Code 43090 JR08961 CID install leads to auth falures Common Code 43095 JR08962 SQLBIND returns SQL0035N when NUL: specified as a message file. Common Code 43172 IX57511 Restore database A into database B does not work as designed Common Code 43268 JR08966 CLI0109E INSERTING more than 5 grahic char to graphic (10) col Common Code 43273 JR08967 db2dd returns SQL2008 during restore if userexit is enabled Common Code 43285 JR08817 Phase 1 of threaded apps Common Code 43297 JR08968 DB2START not checking for DDCS/2 v2.3 single user license. Common Code 43319 JR08969 SQL0930 on REXX SQL FETCH Common Code 43327 JR09094 Accessing reorgCB after freeing the memory in sqlbReorgCleanup Common Code 43329 jr08970 Optional SQL +803 from ODBC Common Code 43408 JR08976 Using APPC from WIN/OS2 --> sql902 rc62 Common Code 43408 JR08976 Using APPC from WIN/OS2 --> sql902 rc62 Macintosh 43408 JR08976 Using APPC from WIN/OS2 --> sql902 rc62 Windows 95,NT 43409 JR08977 SYS3175 trap - DB2RDS.DLL -function sqlv_sbcs_build_like_subpat Common Code 43570 IX57721 Wrong timestamp/date/time returned in DB2/6000 V2.1.1 Common Code 43660 JR08988 SYNONYMS not display with MS Query Common Code 43705 JR09212 Restore fails if backup to diskette reuses a diskette Common Code 43753 jr08974 CLI Administrator does not show option 8192 Windows 95,NT 43753 jr08974 CLI Administrator does not show option 8192 Windows 3.1 43753 jr08974 CLI Administrator does not show option 8192 Common Code 43889 IX57794 Getting DSNT500I and DSNT233I instead of -4390 Common Code 43948 JR08998 Include sample response file in build Windows 95,NT 44025 JR09055 db2usrxt on db backup returns 0 or 28(not 4,8,12etc as in docs) OS/2 44143 JR09051 PCDR client traps in DB2ASP0 with DDCS 8085 Common Code 44190 JR09032 migration from v1 to v2.11 introduces PD corruption Common Code 44297 jr09048 client setup does not cleanup odbc.ini Windows 3.1 44346 JR08817 ensure that prep/bind/import/export are still serialized Common Code 44391 JR09197 OS/2: AIX help file is not shipped OS/2 44393 JR09112 LICENSEKEY response file keyword rejected during CID install. OS/2 44457 JR09057 CLI143E from SQLSETCOLATTRIBUTES for > 255 VARCHAR for DB2/MVS Common Code 44476 JR09060 Load of IXF file brings DB2/6000 instance down. Common Code 44480 IX58034 Rollforward recovery fails. Common Code 44490 jr09061 GPF in db2cliw.dll at 0015:2624 or 0005:2b7a in SQLDisconnect Common Code 44493 JR09049 Opened for a Common Code fix of defect 39164 Common Code 44644 JR09065 SYS3175 during SQLPREP in sqlno_idx_fully_qualified Common Code 44662 JR09066 XA support on NT requires CDECL linkage Common Code 44761 JR09068 S1010 Using SQL_NODESCRIBE AND re-execute SELECT stmt to MVS Common Code 44762 IX58173 LOAD may corrupt database Common Code 44816 JR08871 CAE/WIN 2.1 generates a wrong qry for SQLTables for AS400 3.1+ Common Code 44874 JR09073 Performance problem with DB2 CAE ODBC Common Code 44921 JR09083 SQL1325 from executing array insert against DB2/MVS Common Code 45000 JR09079 CLI0150E Driver not capable dureing SQLExtented_Fetch Common Code 45002 JR09080 S1001 or SQL0804 or GPF in DB2CLI.DLL during array insert Common Code 45021 JR08817 fix compile errors on NT Common Code 45122 JR09086 SYS3175 on PREP after RUNSTATS with FOR DETAILED INDEXES ALL Common Code 45372 IX58594 Add support for RS (SQL_TXN_REPEATABLE_READ) if connected Common Code 45378 IX58591 More than 1 space between EXEC and SQL causes a problem. Common Code 45567 SAP Add support for DB2RA chaining of the CLOSE and OPEN requests. Common Code 45615 JR09095 CLI app gets SQL30081N appc error 25 doing array insert Common Code 45639 JR09101 SQL query returing inaccurate results Common Code 45654 JR09269 SNI: rollf hang on stop w overflow log path + user exits Common Code 45707 BAAN Add support for stmt level rollback on lock timeouts (for BAAN) Common Code 45769 JR09105 CID install does not read DB2NBRECVNCBS parameters properly OS/2 45769 JR09105 CID install does not read DB2NBRECVNCBS parameters properly Windows 3.1 45810 jr09109 Trap in db2sys.dll with DARI app. KEEPDARI=YES/fenced on OS/2 Common Code 45825 JR09111 SQL2160 on list after restore history file Common Code 45863 IX58846 Query with long fields that are sorted results in seg violation Common Code 45984 JR09121 Double clicks white space crashes Common Code 46050 JR09163 SQLAllocEnv blows up if DB2INSTANCE is set to a junk value. Common Code 46117 cariplo NT: Support force application for APPC inbound connections Common Code 46117 cariplo NT: Support force application for APPC inbound connections Windows 95,NT 46124 JR08999 SQLGOPTS and SQLGOPTS_FREE incorrectly exported Windows 95,NT 46124 JR08999 SQLGOPTS and SQLGOPTS_FREE incorrectly exported Common Code 46129 IX50934 Problem in help GB DB2 Common Code 46136 IX59040 Import of IXF file (data from MVS) causes SQL3011C error. Common Code 46140 jr09131 OPTIMIZE FOR N ROW..OptimizeForNRow keyword causes bad SQL Common Code 46198 JR09136 Fix up the conversion between SQL_C_BINARY and SQL_CHAR which Common Code 46200 JR09135 db2tclnt.exe broken in 2.1.1. Windows 95,NT 46212 JR09137 MS dll fails when installing from CDROM with real mode drivers Windows 95,NT 46215 Ix59070 Memory leak when MAX_IDLEAGENTS >0 and short quick connections. Common Code 46248 JR09140 SQLGetData returns the same data as in the previous row if Common Code 46260 JR09143 SQL0902 during sorting in the temp table space Common Code 46297 JR09142 MS ACCESS gets -502 during attach to db2/mvs with async on Common Code 46367 ix59168 Memory leak in DB2CLIW.DLL Common Code 46385 IX59168 Memory leaks in DB2W.dll Windows 3.1 46403 JR08835 shared adpater number is wrong in db2diag.log Common Code 46418 JR09147 SQL0083N or 'invalid memory access' trap during fetch in DB2/NT Common Code 46445 JR08835 break common link for sqlccnbe.h Windows 95,NT 46446 JR08835 DOS build fails compiling sqlccnbc.C Common Code 46448 IX56584 sql0804 is returned when updating a table on DB2/MVS Common Code 46546 JR09154 db2evmon traps on OS/2 Common Code 46549 IX59360 distinct in select causes overflow, bad plan Common Code 46549 IX59360 distinct in select causes overflow, bad plan OS/2 46549 IX59360 distinct in select causes overflow, bad plan Windows 95,NT 46549 IX59360 distinct in select causes overflow, bad plan Macintosh 46581 IX59362 DB2ICRT fails if the -u parameter is an NIS userid Common Code 46595 IX59168 Fix memory leak in Window 3.1 client. Windows 3.1 46618 ix59168 Memory leak in DB2CLIW.DLL on DOS/Windows Windows 3.1 46658 JR09161 Bad translation of DBCS data which include x'0f0e' Common Code 46666 JR09168 Return double the precision for the display size of graphic Common Code 46684 JR09111 Problems restoring a history file to a new database Common Code 46693 SAP Make the db2os2_acog files the same as db26000_v211. Common Code 46695 SAP The SQL_ATTR_CLOSEOPEN statement attribute is ignored when the Common Code 46699 JR08835 trap while bring down apps OS/2 46725 JR09165 CLI0125E Function sequence error. SQlSTATE=S1010 {SQLFetch} Common Code 46747 JR09166 Sqlcolumns call return no rows when issued against table alias Common Code 46806 JR09170 Binding traps in DB2SYS.DLL Common Code 46855 jr09173 Schemalist in ODBC Settings limited to 256 items Windows 3.1 46855 jr09173 Schemalist in ODBC Settings limited to 256 items Common Code 46923 JR09179 RUNSTATS puts nulls in high2key, low2key, causing trap Common Code 47005 JR09184 The SQLBindParameter strips the first two chars of sql_Varchar Common Code 47323 JR09197 DBAT AIX help file should be shipped on Windows clients Windows 95,NT 47416 JR09199 sql30020 rc124C when binding with DYNAMICRULES option Common Code 47444 JR09197 Win95-SCO: 'Read logs from' truncate path Common Code 47514 jr09202 ODBC Statement corrupted, invalid date returned Common Code 47556 jr09211 -311 on a fetch of a varchar column Common Code 47583 JR09205 SYS3175 in DB2CLI.DLL (multi-threaded app connect) Common Code 47605 IX60047 sql0902 on set constraints of a table ALIAS Common Code 47814 IX60237 sqlf_fix_new_fields does not need cfg file open in update mode Common Code 47822 IX60216 SQL0181N String representation of a datetime value is invalid Common Code 48055 JR09229 SQLPrimaryKeys() returns too many rows Common Code 48061 JR09226 Using GRAPHIC data types with ODBC. Common Code 48073 IX60435 CICS 1PC Optimisation causes SPM to log a protocol violation Common Code 48171 JR09233 IBM CLIDRIVER CLI0002W data truncated SQLSTATE 1004. Common Code 48236 JR09250 New features of db2cli trace Common Code 48272 jr09240 Sever crash when multi result set dari is run more then once Windows 95,NT 48280 JR09242 SQLPREP /F=USA from 1.2 client does not create USA format pack Common Code 48358 apar:SA Arabic Country Codes Windows 3.1 48506 JR09184 Clean up 47005 processing. Do not change the SQL data type base Common Code 48740 JR09256 DSMAPIPW.EXE is hard coded for AIX Clients. Common Code 48846 SAP SAP: Optimizer doesn't choose index ORing plans Common Code 48861 JR09316 Refresh changes to install Windows 95,NT 48883 JR09236 Precompiler can't handle a period in column 72 of Cobol program Common Code 49093 IX56747 If an attempt is made to execute SQL statements without a datab Common Code 49114 JR09263 SQL1224 on SELECT. Trap in sqlrinl1(). Common Code 49202 JR09243 DARI process sys3175 in DB2ENG.DLL using double output DA Common Code 49284 IX61042 Index problem after loading table. Common Code 49316 JR09250 Trap: DB2W.DLL exit list handler invokes unloaded DB2CLIW.DLL Common Code 49365 SA53610 Arabic Country Codes Support Windows 3.1 49528 JR09273 SQL0973N afte exec thousand of SELECT stamement from client Common Code 49743 IX61475 Error in performance fix to latch code Common Code 49780 JR09080 Zero Length char parms converted to length 1 and a blank Common Code 49872 JR09291 SQLTABLE ODBC call uses table scan on DB2/MVS and is slow Macintosh 49907 JR09080 Fix side effects of 49780 Common Code 50062 JR09297 GPF in DB2W.DLL if SQLDISCONNECT without environment or connect Common Code 50530 IX61694 Make sure LFH is consistent for an off-line backup.