DB2/2 OS/2 v2.1 APAR List ========================= This is a list of all the APAR fixes that have gone into DB2 for OS/2 v2.1 since the GA of DB2 for OS/2 v2.10. FixPak 8120: APAR # Defect Abstract ------- ------ ---------------------------------------------------- JR08753 38048 Message DIA3875C erroneously written to db2diag.log when a IX59365 38813 Use a more generous fudge factor for locks in sqlmonsz() JR08778 39172 SQLDBS from a REXX app returns SQL2010 during backup JR08835 40521 DB2/2 APP which is also NETBIOS app does not work under 2.1 IX55831 40624 Memory not being freed when an sql statement being compiled JR08817 40673 provide concurrent access for threaded apps IX55842 40678 Improve usability for instance migration IX56582 41731 db2 use of popen causes problems on AIX V4 JR08830 41830 Prepping and compiling w/ MicroFocus Cobol to remote db traps. IX56747 41917 Incorrect error msg when implicitly connects with long db name. IX56720 41918 Incorrect error msg when sqledrpd & sqlemgdb use long db name. IX56811 42079 DB2 V2.1 IMPORT incorrect summary statistics JR08924 42210 Optimization level 5 takes too long JR08925 42239 LOAD REPLACE gets SQL0901N reason -2551 jr08929 42284 SQL902C rc=57 using DARI ix56905 42348 DDCS Gateway looping 100% cpu with a certain select stmt jr08932 42364 SQL30082 rc=0 maped to sql1403 for NON v2.11 CAE clients 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 ix57283 42909 Long field data corrupted when multiple processes write/read to 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 ix56928 43006 Update bsu API test driver JR08961 43090 CID install leads to auth falures JR08962 43095 SQLBIND returns SQL0035N when NUL: specified as a message file. IX57511 43172 Restore database A into database B does not work as designed JR08966 43268 CLI0109E INSERTING more than 5 grahic char to graphic (10) col JR08967 43273 db2dd returns SQL2008 during restore if userexit is enabled JR08817 43285 Phase 1 of threaded apps JR08968 43297 DB2START not checking for DDCS/2 v2.3 single user license. JR08969 43319 SQL0930 on REXX SQL FETCH JR09094 43327 Accessing reorgCB after freeing the memory in sqlbReorgCleanup jr08970 43329 Optional SQL +803 from ODBC JR08976 43408 Using APPC from WIN/OS2 --> sql902 rc62 JR08977 43409 SYS3175 trap - DB2RDS.DLL -function sqlv_sbcs_build_like_subpat IX57721 43570 Wrong timestamp/date/time returned in DB2/6000 V2.1.1 JR08988 43660 SYNONYMS not display with MS Query JR09212 43705 Restore fails if backup to diskette reuses a diskette jr08974 43753 CLI Administrator does not show option 8192 IX57794 43889 Getting DSNT500I and DSNT233I instead of -4390 JR09055 44025 db2usrxt on db backup returns 0 or 28(not 4,8,12etc as in docs) JR09051 44143 PCDR client traps in DB2ASP0 with DDCS 8085 JR09032 44190 migration from v1 to v2.11 introduces PD corruption JR08817 44346 ensure that prep/bind/import/export are still serialized JR09197 44391 OS/2: AIX help file is not shipped JR09112 44393 LICENSEKEY response file keyword rejected during CID install. JR09057 44457 CLI143E from SQLSETCOLATTRIBUTES for > 255 VARCHAR for DB2/MVS JR09060 44476 Load of IXF file brings DB2/6000 instance down. IX58034 44480 Rollforward recovery fails. jr09061 44490 GPF in db2cliw.dll at 0015:2624 or 0005:2b7a in SQLDisconnect JR09049 44493 Opened for a Common Code fix of defect 39164 JR09065 44644 SYS3175 during SQLPREP in sqlno_idx_fully_qualified JR09066 44662 XA support on NT requires CDECL linkage JR09068 44761 S1010 Using SQL_NODESCRIBE AND re-execute SELECT stmt to MVS IX58173 44762 LOAD may corrupt database JR08871 44816 CAE/WIN 2.1 generates a wrong qry for SQLTables for AS400 3.1+ JR09073 44874 Performance problem with DB2 CAE ODBC JR09083 44921 SQL1325 from executing array insert against DB2/MVS JR09079 45000 CLI0150E Driver not capable dureing SQLExtented_Fetch JR09080 45002 S1001 or SQL0804 or GPF in DB2CLI.DLL during array insert JR08817 45021 fix compile errors on NT JR09086 45122 SYS3175 on PREP after RUNSTATS with FOR DETAILED INDEXES ALL IX58594 45372 Add support for RS (SQL_TXN_REPEATABLE_READ) if connected IX58591 45378 More than 1 space between EXEC and SQL causes a problem. SAP 45567 Add support for DB2RA chaining of the CLOSE and OPEN requests. JR09095 45615 CLI app gets SQL30081N appc error 25 doing array insert JR09101 45639 SQL query returing inaccurate results JR09269 45654 SNI: rollf hang on stop w overflow log path + user exits BAAN 45707 Add support for stmt level rollback on lock timeouts (for BAAN) JR09105 45769 CID install does not read DB2NBRECVNCBS parameters properly jr09109 45810 Trap in db2sys.dll with DARI app. KEEPDARI=YES/fenced on OS/2 JR09111 45825 SQL2160 on list after restore history file IX58846 45863 Query with long fields that are sorted results in seg violation JR09121 45984 Double clicks white space crashes JR09163 46050 SQLAllocEnv blows up if DB2INSTANCE is set to a junk value. cariplo 46117 NT: Support force application for APPC inbound connections JR08999 46124 SQLGOPTS and SQLGOPTS_FREE incorrectly exported IX50934 46129 Problem in help GB DB2 IX59040 46136 Import of IXF file (data from MVS) causes SQL3011C error. jr09131 46140 OPTIMIZE FOR N ROW..OptimizeForNRow keyword causes bad SQL JR09136 46198 Fix up the conversion between SQL_C_BINARY and SQL_CHAR which Ix59070 46215 Memory leak when MAX_IDLEAGENTS >0 and short quick connections. JR09140 46248 SQLGetData returns the same data as in the previous row if JR09143 46260 SQL0902 during sorting in the temp table space JR09142 46297 MS ACCESS gets -502 during attach to db2/mvs with async on ix59168 46367 Memory leak in DB2CLIW.DLL JR08835 46403 shared adpater number is wrong in db2diag.log JR09147 46418 SQL0083N or 'invalid memory access' trap during fetch in DB2/NT JR08835 46446 DOS build fails compiling sqlccnbc.C IX56584 46448 sql0804 is returned when updating a table on DB2/MVS JR09154 46546 db2evmon traps on OS/2 IX59360 46549 distinct in select causes overflow, bad plan IX59360 46549 distinct in select causes overflow, bad plan IX59362 46581 DB2ICRT fails if the -u parameter is an NIS userid JR09161 46658 Bad translation of DBCS data which include x'0f0e' JR09168 46666 Return double the precision for the display size of graphic JR09111 46684 Problems restoring a history file to a new database SAP 46693 Make the db2os2_acog files the same as db26000_v211. SAP 46695 The SQL_ATTR_CLOSEOPEN statement attribute is ignored when the JR08835 46699 trap while bring down apps JR09165 46725 CLI0125E Function sequence error. SQlSTATE=S1010 {SQLFetch} JR09166 46747 Sqlcolumns call return no rows when issued against table alias JR09170 46806 Binding traps in DB2SYS.DLL jr09173 46855 Schemalist in ODBC Settings limited to 256 items JR09179 46923 RUNSTATS puts nulls in high2key, low2key, causing trap JR09184 47005 The SQLBindParameter strips the first two chars of sql_Varchar JR09199 47416 sql30020 rc124C when binding with DYNAMICRULES option JR09197 47444 Win95-SCO: 'Read logs from' truncate path jr09202 47514 ODBC Statement corrupted, invalid date returned jr09211 47556 -311 on a fetch of a varchar column JR09205 47583 SYS3175 in DB2CLI.DLL (multi-threaded app connect) IX60047 47605 sql0902 on set constraints of a table ALIAS IX60237 47814 sqlf_fix_new_fields does not need cfg file open in update mode IX60216 47822 SQL0181N String representation of a datetime value is invalid JR09229 48055 SQLPrimaryKeys() returns too many rows JR09226 48061 Using GRAPHIC data types with ODBC. IX60435 48073 CICS 1PC Optimisation causes SPM to log a protocol violation JR09233 48171 IBM CLIDRIVER CLI0002W data truncated SQLSTATE 1004. JR09250 48236 New features of db2cli trace JR09242 48280 SQLPREP /F=USA from 1.2 client does not create USA format pack JR09184 48506 Clean up 47005 processing. Do not change the SQL data type base JR09256 48740 DSMAPIPW.EXE is hard coded for AIX Clients. SAP 48846 SAP: Optimizer doesn't choose index ORing plans JR09236 48883 Precompiler can't handle a period in column 72 of Cobol program IX56747 49093 If an attempt is made to execute SQL statements without a datab JR09263 49114 SQL1224 on SELECT. Trap in sqlrinl1(). JR09243 49202 DARI process sys3175 in DB2ENG.DLL using double output DA IX61042 49284 Index problem after loading table. JR09250 49316 Trap: DB2W.DLL exit list handler invokes unloaded DB2CLIW.DLL JR09273 49528 SQL0973N afte exec thousand of SELECT stamement from client IX61475 49743 Error in performance fix to latch code JR09080 49780 Zero Length char parms converted to length 1 and a blank JR09080 49907 Fix side effects of 49780 JR09297 50062 GPF in DB2W.DLL if SQLDISCONNECT without environment or connect IX61694 50530 Make sure LFH is consistent for an off-line backup. FixPak 8090: APAR # Defect Abstract ------- ------ -------------------------------------------------------------- IX55458 39807 BACKUP WITHOUT PROMPTING fails when one device fills up 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 IX56905 42348 DDCS Gateway looping 100% cpu with a certain select statement IX56928 42275 Activating db will causes exclusive connection to work improper IX57031 42454 SQL1035N from connect after activate/backup IX57283 42909 Long field data corrupted when multiple processes write/read 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 logging to remote database using ddcs or appc returns sql30082n JR08891 41385 LOAD traps on OS/2 in sqlu_getfree JR08892 41851 sql1002 from call to sqlecatd in down-level binary application 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 JR08906 41802 OS/2 applications using sqlestrd get -1246 when issuing first S 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. JR08917 42016 DB2NAME gets truncated when it is saved to DB2CLI.INI 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 JR08932 42634 SQL30082 rc=0 mapped to SQL1403 for NON v2.1.1 CAE clients JR08940 42523 SYS3175 in sqle_database_commit at CONNECT RESET FixPak 8085: APAR # Defect Abstract ------- ------ -------------------------------------------------------------- IX55033 38655 CICS/6000 terminates upon a SQL0998 from DB2/6000 v1.2 IX55380 39492 Updating COLDIST values causes agent to crash IX55831 40624 Memory not being freed when an sql statement being compiled IX55835 40627 Database restore trapped in sqlpcenv JR08789 39388 CID install CPUSPEED=-1 does not set cpu speed JR08799 39574 Fix fenced UDF problem on OS/2 JR08798 39661 sql0955 when sortheap not available in memory 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 JR08825 40234 Use local not GMT for current timestamp JR08829 40410 sql1042 at restart time because of missing secondary log files JR08830 40420 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 JR08935 41052 remote import can result in trapping or hanging dari PJ08845 40625 ODBC driver (CAE/WIN v2.1) does not work with AS/400 v3.05 FixPak 8080: APAR # Defect Abstract ------- ------ -------------------------------------------------------------- IC10798 32501 Retrofit defect 32493 on version 2 IC11152 34343 Executing DB2/2 v1.x DARI from v2.1 clients gets SQL1131N IC11648 36663 Enabling escape clause by changing \ to = IX51424 32391 Import from del to float using lang=Fr_FR truncates at dec IX51424 34243 Windows client SVP - import table with IX51424 37511 fix perf degradation to db2/2 v210 from fix for db2/6000 IX51900 31493 need 'more unique' way of getting IPC key for shared mem. IX52691 33242 ICLUI 4733:db2dd tree list of packages overlaps if > 5000 pk IX53070 33749 get snapshot for locks when in-doubt transactions kills db IX53151 34001 Failure in loading a table w/constraints leaves table in IX53151 34963 Fix sqluigsi to not include server header files IX53157 34015 SQL2048 during an online tablespace backup IX53377 33008 TRAP or SQL2310 when runstat to a db restored fron v1 backup. IX53473 34521 Load problem IX53501 34590 Index built incorrectly IX53563 32408 If cont. not accesible during connect, tsp put in restore_pend IX53770 35299 Abnormal termination when KEEPDARI=NO causes engine to crash IX53936 33992 Failure in DELETE phase during load/insert 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 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 i 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. IX55039 38677 Large load with index(es) hangs JR08065 37169 V1 client compatibility support for OS/2 JR08595 33341 SQL0984C on importing with REPLACE_CREATE option JR08603 31803 DB2 terminate fails JR08603 33773 CAE/2 2,1 gets DB21016E JR08605 33956 Binary compatibility between v2 client/server using sqlestat. JR08605 36108 Instance attach & db2 connect not both allowed in NetB type 1 JR08620 34479 Problem Description JR08622 32410 double click on Packages never returns JR08623 34593 Binding gets sql30073 rc=2113 JR08626 36248 Security: client needs to reprompt. JR08629 34731 RESTORE gives SQL2542N multiple dbalias.* dirs exist JR08632 35018 SQLAINTP overwrites memory causing trap JR08633 35022 SLSTATE 7002 on a select from MS Excel with 1.2 and 2.1 DB2 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 JR08647 37281 increase default agent stack size to 64 JR08648 33315 CLP bp and fp does not handle a second interrupt JR08649 35386 SQL01331N after migations from DDCS/2 2.2 to 2.3 JR08650 35454 Remove 8-user count restriction for Standalone/Single-User JR08653 34331 ODBC performance improvements for Peoplesoft software JR08655 34573 SQLSetParam causes a GPF in the parameter is greater than JR08657 35582 history file does not fully qualify the backup files JR08661 35605 SQL0104 with REXX program to get database manager config. JR08671 36007 SQLSetCursorName should not return error when cursor length>18 JR08672 31772 Restore V1 behaviour for UPM logon scenarios 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 gives SQL3015N JR08696 36652 Multiple connection from MS Access JR08698 36706 Client receives -1109 on calling remote REXX DARI in DB2/2 v2.1 JR08705 34815 log info in sqlofica at a lower level & check level first JR08708 38040 S1104 from SQLSETPARAM WITH VARCHAR 255 ACCESSING HOST D JR08713 37366 codepage conversion table for 037 -> 367 JR08720 37583 DB2/NT connect performance improvement JR08720 38771 more cariplo security work JR08721 37239 DB2 v2.1 OS/2 lowercase tablename 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 dec JR08732 37926 V1 restore API sqludres fails under V2.1 8049+ JR08732 38956 warning message missing for restore JR08732 39346 sqludres behaves improperly if restore aborted JR08739 38236 db2/2 v210 install migrates all accessable volume db JR08740 38253 db2resdb fails with SQL2501 when userexit is used JR08743 38310 missing functionality in DB2CMD.EXE JR08745 38358 Gettin -332 when binding from cae/dos 1.2 thru ddcs JR08746 38361 rollforward fail due to opening wrong log file JR08755 38712 Cursor already open message when trying to open cursor JR08758 38703 Restore database 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 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 *********************************************************************** ** ** ** (c) COPYRIGHT INTERNATIONAL BUSINESS MACHINES CORPORATION 1996. ** ** ALL RIGHTS RESERVED. ** ** ** ***********************************************************************