============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R2M0 Cumulative Service Pack Level ------------- SI10914 ------------- (c) Copyright IBM Corporation 2002. All rights reserved. ======================================================================== Co-requisite PTF SI10908 is automatically included with any shipment or web download of SI10914. SI10908 exists only for packaging reasons. All service pack level references will be to SI10914. NOTICE: ------- Application of this PTF may disable or render ineffective programs that use system memory addresses not generated by the IBM translator, including programs that circumvent control technology designed to limit interactive capacity to purchased levels. This PTF may be a prerequisite for future PTFs. By applying this PTF you authorize and agree to the foregoing. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN iSeries SYSTEM 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE 2.0 RESTRICTIONS 2.1 iSeries NAVIGATOR 2.2 iSeries OPERATIONS CONSOLE 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI10914 (February 2004) 4.0 INSTALL/UNINSTALL CONSIDERATIONS 4.1 REMOVING THE SERVICE PACK 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? 4.3 SERVICE PACK CONTROL 5.0 DATA TRANSFER CONSIDERATIONS 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 --------------------------------------------------------------------- 1.0 INSTALLATION INSTRUCTIONS ------------------------------ 1.1 INSTALLING FROM AN iSeries SYSTEM -------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack through the iSeries PTF ordering process either as an individual PTF order or as part of an OS/400 PTF cumulative package. Once this service pack has been applied to an iSeries system with the LODPTF and APYPTF iSeries commands, it can be installed on individual PC's with the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Check Service Level, controlled by the iSeries Access for Windows Properties Service tab, will detect that the Service source directory has been updated, and will present the user with the option to install the service pack at startup time as well. The APYPTF will update the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) on the iSeries. Any client that installs iSeries Access for Windows (or selected components) from this image will automatically receive this service pack level (no extra steps or reboots). In this scenario, the service pack cannot be uninstalled on the client PC because it is merged in with the base release. Running setupsp.bat from the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) will launch the service pack install wizard. View setupsp.bat via Notepad or Wordpad to see instructions on how to invoke setupsp.bat to record or run a silent service pack install. RMVPTF will restore your iSeries install image to the prior service level (or the base release if there was no prior service pack applied). 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE --------------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack as a set of install image files. Install the service pack by running the "SETUP.EXE" program from your PC. This program is part of the install image files shipped with a service pack. If you change the iSeries Access for Windows Properties Service tab Source Directory to the directory containing these install image files, you can also use the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Before running this program, copy the service pack install image files to a local drive on your PC or to any accessible network drive. Once the install setup program has completed, you can then remove the install image files from that drive. 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE ------------------------------------------------------------------------------------- The following method could be used if you downloaded the service pack image from the iSeries Access for Windows web page location: http://www-1.ibm.com/servers/eserver/iseries/clientaccess/casp.htm The iSeries Access for Windows service pack PTFs are combined with the original iSeries Access for Windows installation image in QIBM\ProdData\Access\Windows\Install\Image NOTE: this directory is a symbolic link to QIBM\ProdData\CA400\Express\Install\Image There is one physical directory - either of these paths will access the directory. This means that a user can install (or upgrade) iSeries Access for Windows from this combined image directory and get the latest applied service level automatically in one integrated step - since the original installation image files have been replaced by updated versions via the service pack PTF. Selectively installing components from this combined image directory will also automatically get the latest applied service level for that component. If you tailor the Client Access Express install image to another directory (for instance, on another server), using the Create Tailored Installation Image (cwbinimg.bat) tool, you can use the PTFFORM.EXE download in the FTP directory to duplicate the function of applying the iSeries PTF by following these steps: 1. Download PTFFORM.EXE (from the tailored/ FTP directory) to a temporary directory. 2. Run PTFFORM.EXE to expand the service pack files and copy them into an iSeries Access for Windows installation image directory, replacing any existing files. 3. Delete PTFFORM.EXE after it has completed its processing. Now you have combined this service pack level with the iSeries Access for Windows installation image, so that users can install iSeries Access for Windows plus this service pack in one integrated step. Note that this procedure also works if the installation image has already been combined with a prior service pack level. This procedure will replace the prior service level in the combined image with this new level. Alternatively, if you have a full copy of the original iSeries Access for Windows install image in a directory, you can combine PTFFORM.EXE with this full image, using the same 3-step procedure detailed above. Then you can run Create Tailored Installation Image (cwbinimg.bat) from this full image directory, to create tailored image directories that will automatically have the service pack merged in. 2.0 RESTRICTIONS ----------------- 2.1 iSeries NAVIGATOR ---------------------- 1) Due to technology incompatibilities, occasionally a window can be displayed behind other windows when running the iSeries Navigator. If the iSeries Navigator looks like it has stopped working, it is possible that the window you are waiting for is being displayed behind another window on your desktop. Press the Alt key and then the Tab key to see a list of all the windows on your system and select window behind the iSeries Navigator window, or another window on your desktop. 2.2 iSeries OPERATIONS CONSOLE -------------------------------- 1) It is recommended that you restrict LAN topologies for LCS attachment to a single, physical ring/hub/switch fabric. In the event that the LCS is used in a larger network topology, broadcast (DHCP) packet filtering is always recommended. 2) The maximum number of concurrent active sessions via the PCOM 5250 emulator is 26. 3) If an automatic session re-connect to an OS/400 image on an iSeries or iSeries server on iSeries Operations Console start-up fails, simply use the manual re-connect process by right-clicking the connection profile that failed to re-connect and selecting 'Connect'. 2.3 Management Central -------------------------------- The problem identified regarding a Management Central File Monitor not triggering when "System logs" is the option selected for "Files to monitor" on the General property page has been resolved. IMPORTANT NOTE: You must also install V5R2 HOST PTF SI08454 in order to fix this problem. 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS -------------------------------------------------------- This a list of APAR fixes included in this service pack. Each service pack is cumulative; the current service pack includes all the fixes from the prior service pack levels. The APAR abstracts are listed by installable component within a service pack level. --------------------------------- Service Pack Level = SI10914 Build date = February 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE12606: CA400EXP-2-MSGCWBCF0005-F/CWBBACK CWBBACK FAILS WHEN DBCS INVOLVED When the Japanese version of iSeries Access for Windows is installed, running CWBBACK on Windows NT 4.0, Windows 2000, or Windows XP fails and displays the following message: CWBCF0005 - Backup of iSeries Access configuration has failed. even when logged on as an administrator of the PC. If the environment name, in this case the Japanese equivalent of "User Connection", is changed to the English text "My Connections", (or probably any other string not containing double-byte characters), the problem no longer occurs. It is unknown whether this problem occurs only when double-byte characters exist in an environment name. The problem occurs because of the inconsistent behavior of a Microsoft API, and may not occur on all systems, or even on the same system at different times. This PTF works around the inconsistent behavior of the Microsoft API, and thus fixes the reported problem. Because the exact behavior of this API in all scenarios is unknown, no circumvention is guaranteed to permanently work around the problem. CIRCUMVENTION: If the environment name, and possibly all other configured names (such as system names), are changed so they contain only single-byte characters, the problem might no longer be experienced. APAR SE13599: CA400EXP - Add 64 bit support to XDA Windows client The XDA Windows client interface into the iSeries DB2/400 database does not support Windows 64-bit applications. 64-bit support has been added to the XDA Windows client to support Windows 64-bit applications accessing the iSeries DB2/400 database. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- IMPORTANT NOTE for Management Central: You must also install V5R2 HOST PTF SI08454 in order to fix the problem identified regarding a Management Central File Monitor not triggering when "System logs" is the option selected for "Files to monitor" on the General property page. APAR SE11922: CA400EXP-OPNAV-OUTPUT-INCORROUT TOP OF PDF FILE IS CUT OFF W Customer has an AFPDS SPLF with the following attributes PAGESIZE(66 132) DEVTYPE(*AFPDS) FNTCHRSET(CZ6200 T1V10037 8) PAGRTT (90). The top of the PDF file is cut off when the PDF file is generated through operations navigator. PDF file is not cut off when sent through infoprint server without using operations navigator. Copied spooled file now maintains all attributes of original spooled file. APAR SE12158: CA400EXP-OPNAV-INCORROUT CPD0082 IS RECEIVED BY CHANGING THE SCHEDULE DATE OF A J MSGCPD0082 is received by changing the schedule date of a job within a jobqueue. So expand workmanagement -> jobqueues ->active jobqueues ->open jobqueue where a job is in -> right click on this job and change the schedule date with format DMY -> MSGCPD0082 is reported. User profile Parameters: - LOCALE = *SYSVAL - SETJOBATR = *NONE - CCSID = *SYSVAL - STRSEQ = *SYSVAL System Values: - QLOCALE = /QSYS.LIB/EN_US.LOCALE - QSETOBJATR = *NONE - QCCSID = 65535 - QTIMSEP = 1 (:) - QDATFMT = DMY - QDATSEP = 1 (/) This problem was caused by the date not being set in the correct format when the job's date format is DMY. A change is made to put the date in DMY order when changing these values through job properties. APAR SE12240: CA400EXP-OPNAV-UNPRED UNABLE TO SCHEDULE CHANGE TO VIRTUAL Unable to schedule change to virtual number of processors - processor pool units will work, but virtual number of processors will not change. Scheduling changes to virtual processor values will be fixed. APAR SE12353: CA400EXP-OPNAV-NETWORK-INCORROUT QoS data corruption Data corruption can occur to QoS polices if a V5R2 client configures V5R3 QoS server. APAR SE12354: CA400EXP-OPNAV-NETWORK UCW support new version 5 QTOCcit.fil The QTOCcit.fil is updated to version 5 with new keywords. The Universal Connection Wizard of iNav client PC needs to add the support for the new changes. The KeyWordRecord.java class in util/api has been changed to have the parser updates. APAR SE12355: CA400EXP-OPNAV-NETWORK VPN needs to use Tunnel Mode Universal Connection Wizard needs to use Tunnel mode when configuring VPN in a v5r2m0 or later system. Universal Connection Wizard has been changed to use tunnel mode when configuring VPN. The following host PTFs are required to enable the Universal Connection to use NAT Traversal: SI09611 MF30153 APAR SE12356: CA400EXP-OPNAV-NETWORK-INCORROUT Wrong policy priority value written when connected to V5R1 system Quality of Service ( QoS ) When connected to a V5R1 system, the V5R2 GUI writes a 0 for the policyRulePriority tag for IntServ polices. The index should start at 1 for V5R1 systems APAR SE12438: CA400EXP-OPNAV-OUTPUT-INCORROUT CWBUN_GETPUBLICLISTOBJECT AP cwbUN_GetPublicListObject API fails to return the correct spool file ID when used in the iSeries Navigator 'Work Management' node. The API works correctly in the 'Basic Operations' node. APAR SE12610: Client Access iSeries Navigator System status appears greyed out When using iSeries Navigator (V5R2 or later), the System Status option is disabled (greyed out). It never becomes enabled. The option appears in the following places: 1.) System task pad 2.) System context menu 3.) Work Management task pad 4.) Work Management context menu 5.) Can be optionally added to the "My Tasks" task pad I've tried refreshing the display. I've tried navigating into Work Management to force a refresh. Nothing appears to work. The System Status menu option/icon is greyed out because we do not have a valid signon to the iSeries system. This option is not valid in early releases and we need a valid signon to determine what release iSeries we are connecting to. The code has been changed to force a signon, in all cases except when "System Status" appears in the "My Tasks" task pad. In this instance, after signing onto the system in question, the 'Refresh' button will enable the function. CIRCUMVENTION: This circumvention will only work in some instances. Expand the System tree. Expand the work management tree. Click on 'Active jobs'. This will force everything to be refreshed and the System Status menu item / task pad item will become active in some instances. APAR SE12783: CA400EXP-OPNAV-MSG88 ERROR WHEN TRYING TO CHANGE PARITY A Dutch customer has 15 disk units attached to a PCI-X raid controller and wants to have all 15 units in one parity set. On selecting the capacity option in iSeries Navigator for the parity optimization level, he gets - "Unexpected error occured, error 88." Traces showed that "Capaciteit" was being passed instead of "Capacity". This PTF fixes the reported problem. It is only a problem for translated versions. APAR SE13297: CA400EXP-OPNAV-NETWORK Incorrect subsystem forced in PPP initiator profiles When creating a PPP dial profile, the subsystem is always created with QSYSWRK. The correct subsystem for v5r1+ iSeries is QUSRWRK. The first time when creating the ppp profile, the GUI would show the subsystem is defaulted QUSRWRK on screen. But when clicked on OK to create, it would create it with QSYSWRK. While the incorrect subsystem was set, the profile does still function. This PTF fixes the reported problem. Saving of a PPP dial profile no longer overrides the subsystem setting incorrectly with QSYSWRK on V5R1+ iSeries. The PPP dial profiles are now properly set to the QUSRWRK subsystem. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE11455: CA400EXP-DTRANSFER-DBCS CHARACTERS IN PC BIFF8 FILENAME MAKES SHEETNAME INCORRECT User download a file from iSeries. BIFF8(MS Excel 8) is set for file type. If PC file name is specified as DBCS name, the sheet name of the Excel file become garbage. DBCS on Excel file name is correct. Only DBCS on the sheet name is become garbage. It is not readable. APAR SE12420: CA400EXP-DTRANSFER UPLOAD REQUEST LARGER THAN 4K RESULTS IN CWBTF0013 When a request size exceeds 4K (e.g. when a file with several fields is used), a CWBTF0013 error may occur. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE12467: CA400EXP-DTRANSFER DATE PROPERTIES NOT APPLIED USING EXCEL WIZARD When using the Excel Wizard to upload data with Date types, the changes made to the Date Format in Properties dialog, are not applied to the transfer. ODBC ---- APAR SE12051: CA400EXP-ODBC INTERNAL DRIVER ERROR WHEN USING COM+ Application uses R520 iSeries Access for Windows ODBC driver connected to OS400 R520 in a Microsoft COM-plus distributed transaction. The first attempt to enlist a new odbc connection in a distributed transaction may fail with internal driver error. The error occurs when a new odbc connection happens to be assigned the same handle as an earlier connection. The error is on the following API: SQLSetConnectAttr SQL_ATTR_ENLIST_IN_DTC=1207 A detail trace of the error will show: odbcmts.xaMapper.CreateRm Exit rc=30027. The error does not occur with R510 iAW. APAR SE12232: CA400EXP-ODBC-UNPRED MEMORY LEAK IN CLIENT ACCESS ODBC DRIVE The Client Access ODBC driver (cwbodbc.dll) does not deallocate memory after applications call the SQLGetInfoW function for SQL_DRIVER_VERSION. This affects Client Access versions 510 and 520. APAR SE12311: CA400EXP-ODBC-INCORROUT PROBLEMS WITH SYNONYM TYPE IN SQLTAB There are a couple of problems surrounding the use of the table type 'SYNONYM' on the SQLTables function with the iSeries Access ODBC driver. The first problem only occurs if an application calls the SQLTables function listing only a table type of 'SYNONYM' and there are no results to be returned. If the application binds result columns and tries to fetch the results, the ODBC driver returns and error, 'Invalid cursor state'. Instead it should return an error message MSGSQL0100, 'No results found' error. Additionally, if an application requests a table type of 'SYNONYM' and there are results, the iSeries Access ODBC driver returns tables of type 'TABLE' and 'ALIAS' instead of 'SYNONYM'. As a result of the same problem, if a table type of 'TABLE' or 'ALIAS' are specified, both ALIAS and TABLE types are returned. APAR SE13115: CA400EXP-ODBC-INCORROUT - FETCH PROBLEMS WITH PARTIAL BLOCKS When the ODBC client retrieves data from the server, there are some conditions where a full block of rows can not be retrieved. If that condition occurs, the ODBC driver is incorrectly returning partial rowsets back to the application. APAR SE13347: CA400EXP-ODBC-UNPRED SQLCOLATTRIBUTES SQL_COLUMN_SEARCHABLE After a successful SQLTables call that has an empty result set, an attempt to call SQLColAttributes SQL_COLUMN_SEARCHABLE returns a 30030 error as the return code. Trying to get the error information returns no data. There is no message returned to the application or logged. A Detail trace is required to pinpoint the driver problem. OLE DB PROVIDER --------------- APAR SE11849: CA400EXP-OLEDB-MSGCWB0111 ERROR OPENING ADO RECORDSET An application using the IBMDA400 OLEDB provider via ADO is reporting an error, "Method open for Object Recordset failed, -21740467259 (8000 4005)" Tracing revealed that the OLEDB provider was encountering a CWB0111 - invalid buffer length, error while processing the column headings. APAR SE11854: CA400EXP - OLEDB - INSERTING DBCS CHARS INTO UNICODE COLUMN CA/Express client connects to iSeries DB2/400 via IBMDA/400 (OLEDB). The table columns are Unicode (graphic w/CCSID 13488). When the user inserts DBCS characters into the last position in a column, the characters are replaced with garbage characters. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR SE11237: CA400EXP-TERMEMUL DISPLAYING SUBFILES CONTAINING FIELDS DEFI Displaying subfiles containing fields defined as DSPATR(HI) and DSPATR(BL) causes PC5250 flickering problems. This occurs with PC5250 included in version 520 of CAExpress, but we noticed the same problem with PC5250 5.0 standalone version. No matter about version/release of OS/400. The problem does not ocur with different emulators (Powerterm has been tested) and with local workstations. It looks like PCOMM (XE1 version and standalone) is somewhat failing to correctly refresh the screen for blinking fields causing the subsequent no-blinking field to randomly flash/flicker. APAR SE11341: CA400EXP-PRINTEMUL-INCORROUT PC5250 PRINTER EMULATION The PC5250 printer session prints compressing the 10 CPI requested by spool file even if not needed basing on the spool file characteristics and form size loaded and configured on printer driver. Here some more details: - HPT is not used - Drawer 1 Orientation is PORTRAIT - BestFit Option is checked - COR is NOT checked - Automatic orientation is NOT checked - Tractor feed and US Fanfold form size is choosen When the spool file printed has attributes CPI=10, LPI=10, Width=90, Length=72 and PAGRTT=0 the printout obtained on a PC printer Epson DFX-5000 is slightly compressed both horizontally and vertically even if margins are zeroed. Joblogs are printing correctly without horizontal compression. APAR SE11890: OSP-PAR ISERIES ACCESS FOR WINDOWS COPY AND PASTE WITH PC525 When using copy and paste with PC5250 and the clipbook, the same data is pasted in repeatedly even when new data is copied. APAR SE11914: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION BY NEWLINE KEY W When EDTCDE and EDTMSK are specified to a field, newline key works incorrectly. If the cursor is in the field using EDTMSK, newline key doesn't work to move the cursor to the next line. It moved to the next FIELD as like a TAB key. This problem occurs on the SP(SI09809) environment, but doesn't occur on the previous SP(SI08894) environment. APAR SE12161: CA400EXP-TERMEMUL-INCORROUT IBM3270-1250 FONTS ARE NOT Some PC5250 IBM3270-1250 fonts are not correctly displayed when using a screen resolution 1024x768 pixels APAR SE12522: CA400EXP-MIGRATION-INCORROUT MIGRATING A WS FILE FOR PC5250 Migrating a WS file from a previous version of PC5250 to one that is compatible with V5R2 of XE1, loses the Hot Spot settings for the session. APAR SE12599: CA400EXP KERBEROS SETTING WILL NOT SAVE Kerberos setting will not save when selected for a PC5250 session / prompting APAR SE12600: CA400EXP-PC5250 SESSION HANG WITH HYPER THREADING CPU. The user uses multiple 5250 sessions. When one session is closed with 'x' button, all other sessions hang. This problem occurs on a PC which supports Hyper threading CPU. When this problem occurs, the user has to end all PCSxxxxx processes to recover. APAR SE12767: OSP-PAR INCORRECT OUTPUT LABELS PRINT 2 LINES PER LABEL INST PC5250 printer session prints labels incorrectly. Instead of printing 4 lines per label, it prints 2 lines at the bottom of the label. Then it prints the remaining 2 lines at the bottom of the next label. APAR SE12821: CA400EXP-TERMEMUL-UNPRED PC5250 SESSION DROPPING WHEN USING iSeries Access for Windows PC5250 Emulation is turning on 5250 Parameters Present bit when not necessary causing the OS/400 Telnet server to flag invalid data stream VLOG 0701 0051 and close the client connection. APAR SE13430: CA400EXP - TERMEMUL - Add support for LotusScript Extension PCOMM supports a LotusScript Extension to their HACL interface. iSeries Access for Windows does not ship this interface. This support has now been added. APAR SE13431: TERMEMUL Signed Numeric won't paste to protected fields Currently if you copy and paste numeric fields they will paste into unprotected and protected fields. But if you copy and paste signed numeric fields, they will not paste into protected fields. This fix is enabled when the existing option, "Force Leading +/-", is ON. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE12381: CA400EXP-OPCON-UNPRED Direct connect fails with Windows NT Attempting to connect a direct cable config on Windows NT may appear to hang, and may later fail with a 10054 error code. Direct connections on Windows NT again work with this change. CIRCUMVENTION: End Operations Console. Locate and edit the file opcon.pbk in the Aoc subdirectory off the iSeries Access for Windows install directory. Change every occurrence of IpHeaderCompression=1 to IpHeaderCompression=0. Save the file. Run Operations Console again. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI09809 Build date = October 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE10680: CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION V5R2 CLI APAR SE10769: CA400EXP-APIS-INCORROUT SAP400 WITH WINDOWS APPLICATION SERV APAR SE10863: CA400EXP-TERMEMUL-INCORROUT CREATE 5250 ICON FAILS CWBCFG is run to set the PC5250 files path to each users' My Documents directory, as follows: cwbcfg /pc5250path *MYDOCUMENTS After this, restricted users cannot perform PC5250-related tasks that require changing or creating PC5250 files. For example, creating an icon for or saving a new session, creating a macro, and changing the keyboard map settings all may fail. This PTF fixes the reported problem. However, there are possible side-effects the user should be aware of. If cwbcfg.exe was used with "/pc5250path *MYDOCUMENTS" before applying this fix, the following are true: 1) All users' PC5250 paths were set to the My Documents of the user who last ran cwbcfg.exe with this option. 2) Any user who changed his PC5250 path using the PC5250 tab of iSeries Access for Windows Properties replaced the incorrect path with the correct one. 3) Users with enough authority -- for example, users in the Administrators group -- will see no failure since they have write access to the other user's My Documents. 4) Users without such authority will fail as described. 5) After this fix is applied, running cwbcfg.exe specifying "/pc5250path *MYDOCUMENTS" will change each users' PC5250 path to that user's correct My Documents location. Because of (3) and (5) above, some users may, after this fix is applied and cwbcfg.exe is run, no longer have access to their saved PC5250 connections, macros, etc. To have access to these things, an administrator of the PC must manually copy PC5250-related files from the old PC5250 path to the new one. This has always been true when a user's PC5250 path has been changed. APAR SE11169: CA400EXP-OPNAV-FILESYS-INCORROUT IFS NETSERVER SHARE LISTING APAR SE11183: CA400EXP-INSTALL-UNPRED SELECTIVE PLUGIN COMPLETION PERCENTAGE APAR SE11205: CA400EXP-SERVICE-INCORROUT AppAdmin Autostart service job APAR SE11653: OSP - XDA performance enhancements APAR SE11654: OSP - ODP cleanup for XDA Windows Client APAR SE11769: OSP - CA comm layer and tracing in XDA Windows client The XDA Windows client contains minimal support features. The Client Access Detail Trace and Client Access communications layer have been added to the XDA Windows Client. The sndbufsz.reg file will be obsolete and have no effect beginning with the installation of this fix and later fixes. The cwbcopwr tool can be used to set the send and receive buffer sizes. When using this fix to connect to the iSeries, the iSeries being connected to must have PTF SI10128 applied if connecting to a v5r2 server, or PTF SI10160 applied if connecting to a v5r1 server. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE10286: CA400EXP-OPNAV UNABLE TO DELETE SQL MONITOR BY INAV APAR SE10324: TCPIP CANNOT MAKE CHANGES TO DNS CONFIG USING OPSNAV APAR SE10394: OSP-PAR ACCESSING MGTC GRAPH History DATA LOCKS OPERATIONS NAVIGATOR APAR SE10515: CA400EXP-OPNAV-INCORROUT CONFIGURING A SWEDISH LPAR SYSTEM APAR SE10617: OSP-DB ERRORS WHEN USING ISERIES NAVIGATOR APAR SE11065: CA400EXP-OPNAV-OUTPUT Printer Output ERROR non-English workstations APAR SE11159: CA400EXP-OPNAV-OUTPUT PASTING SPOOLED FILES TO DESKTOP FAILS APAR SE11223: CA400EXP-OPNAV-OUTPUT-PERFM CONVERT TO PDF OPTION IN OPS NAV APAR SE11504: CA400EXP-OPNAV-OUTPUT-INCORROUT INCORRECT DISPLAY OF ISERIES APAR SE11590: OSP-DB FILE CREATED WITH SRTSEQ TABLE SHOWS INCORRECT SRTSEQ APAR SE11599: CA400EXP-OPNAV-DBASE-INCORROUT RUN & EXPLAIN DOES NOT Run & Explain does not accurately display the "Total Execution Time" for a query. This PTF fixes the reported problem. Note that it may now take longer to see the Visual Explain diagram when performing Run & Explain in the Run SQL Scripts window, because with this change the diagram is not built until all rows of the query have been fetched. This change will only be in effect when the graph detail setting is FULL, and the query is not for update. APAR SE11645: CA400EXP-OPNAV-NETWORK-INCORROUT Error on domain "A" record APAR SE11646: CA400EXP-OPNAV-NETWORK-INCORROUT Keep RBL if add SMTP filter APAR SE11647: CA400EXP-OPNAV-NETWORK-INCORROUT Allow apostrophe in SMTP filter APAR SE11648: CA400EXP-OPNAV-NETWORK-INCORROUT BOOTP Relay Configuration APAR SE11649: CA400EXP-OPNAV-NETWORK-INCORROUT UCW not set dial attempts The Universal Connection is incorrectly setting the Number of Dial Attempts, Delay between Dial Attempts, and Line Inactivity Timeout when creating the connection profiles. The Universal Connection will be changed to set the Number of Dial Attempts to 3, Delay between Dial Attempts to 15, and Line Inactivity Timeout to 10 minutes. APAR SE11650: CA400EXP-OPNAV-NETWORK-INCORROUT Writing DNS config failure APAR SE11651: FTP Properties Config Fails TCP9503 APAR SE11669: INCORROUT Journaling dialog box shows different for IASPs under the Integrated File System APAR SE11714: CA400EXP-OPNAV-FILESYS-INCORROUT LARGE FILES SHOW INCORRECT APAR SE11743: CA400EXP-OPNAV-INCORROUT WHEN USING A MOUSE WHEEL WITHIN APP. ADMIN. APAR SE11892: CA400EXP-OPNAV-AUTHLIST-INCORROUT CANNOT ADD AN AUTL TO A APAR SE11901: CA400EXP-OPNAV-FILESYS-INCORROUT - Changing AUTL on a NetServer share in v5r2 OpNav to v5r2 OS400 fails DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE10644: CA400EXP-DTRANSFER CSV FILE WITH DBCS CAN BE TRANSFERED TO Data Transfer To iSeries (AS/400) may not report data conversion warnings if DBCS data is transferred to a SBCS only column. This is typically the case if the data in the file contains a mix of DBCS and SBCS data. As a result, no warning is displayed and DBCS data transferred to the SBCS column is normally corrupt. After installing this fix a translation error will produce a warning message. The warning message will contain an OK button to allow the user to continue the transfer and a Cancel button to cancel the transfer. APAR SE10934: CA400EXP-DTRANSFER-PERFM SLOW TAB DELIMITED TRANSFER APAR SE11009: CA400EXP-DTRANSFER-INCORROUT CANNOT DELETE THE WHERE CLAUSE APAR SE11667: CA400EXP-DTRANSFER ADDED RXFERPCB TO DATA TRANSFER RXFERPCB is a new utility for facilitating remote data transfers. A new tool, RXFERPCB.EXE has been added to iSeries Access for Windows Data Transfer. This new tool was added to aid in remote data transfers via Incoming Remote Command and RUNRMTCMD from the iSeries. RXFERPCB is much like RTOPCB and RFROMPCB except that it allows you to specify a user ID and password on the command line. This helps to alleviate remote signon problems that are typical when trying to do remote transfers with RTOPCB and RFROMPCB. To run RXFERPCB, specify the transfer request profile name, userID, and password. An example invocation of RXFERPCB and its parameter descriptions are as follows: RXFERPCB request userID password request - Fully qualified file name of any Client Access upload or download request of type .DTF, .DTT, .TTO, or .TFR. userID - A valid iSeries user profile for the system specified in the request. password - A valid password for the specified user profile. RXFERPCB C:\TRANSFERS\MYREQUEST.DTF myuserid mypassword RXFERPCB can be found in the directory where you installed iSeries Access for Windows. NOTE: RXFERPCB specific messages and help text will display as English only. However, most error and warning messages will display using the correct language. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE11659: CA400EXP-DTRANSFER EXCEL ADD-IN LIMITED TO 16K ROWS ON XP ODBC ---- APAR SE10773: CA400EXP-ODBC SQL SERVER 2000 LINKED SERVERS RETURN PARTIAL APAR SE10781: CA400EXP-ODBC-UNPRED EXTENDED DYNAMIC WARNINGS ON CATALOG The V5R2M0 iSeries Access ODBC driver retrieves catalog (metadata) information differently than previous incarnations of the Client Access ODBC driver did. This difference can cause catalog requests to receive a return code of 1 meaning success with additional information, rather than a return code of 0 which simply means success. Some applications may be coded in such a way that they treat this as a failure rather than success. Specific examples of applications behaving in this incorrect manner include Microsoft Query and Microsoft Word. While this really is a coding defect in the application, it is one that the application would not have previously encountered using older versions of Client Access. The problems may be circumvented by disabling extended dynamic support in the ODBC data source on the Packages tab. APAR SE11349: CA400EXP-ODBC-INCORROUT PRECISION NOT CORRECT FOR FLOATING APAR SE11453: CA400EXP-ODBC-INCORROUT COLUMN NAMES FOR RESULT SETS NOT OLE DB PROVIDER --------------- APAR SE11652: CA400EXP-DBACCESS-OLEDB APPLICATION FAILS WITH SQL0904 RC7 An application uses iSeries Access for Windows OLE DB (IBMDA400) to access DB2 UDB for iSeries data. The application creates and destroys a very large number of ADO command objects. The same SQL Statement is run multiple times with different values. After approximately 40,000 command objects the application fails with the error message SQL0904 RESOURCE LIMIT EXCEEDED, RESOURCE LIMIT TYPE 7 EXCEEDED. OLEDB will now reuse statement names. Note that applications that run large quantities of unique SQL Statements (different SQL statements after converting literals to parameters) will still hit the SQL0904 error when the maximum number of prepared statements is reached. This is a restriction of DB2 UDB for iSeries. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR SE10503: CA400EXP-PRINTEMUL-INCORROUT WORD CLAMPING WITHIN PAGE WIDTH APAR SE10544: CA400EXP-TERMEMUL-INCORROUT PCSCM GETS AN APPLICATION ERROR APAR SE10659: CA400EXP-PC5250 PCSFONT WAS FILTERED FROM WIN2K/XP OS. APAR SE10660: CA400EXP-PC5250 JAPANESE KATAKANA APPEARED INCORRECTLY IF APAR SE10707: CA400EXP-TERMEMUL-LOOP RPG APPLICATION IS CAUSING PCSWS.EXE APAR SE10729: CA400EXP-TERMEMUL-INCORROUT PCSWS.EXE FAULTS STARTING AND ST APAR SE10742: CA400EXP-TERMEMUL-INCORROUT EHLLAPI MNEMONIC RESET FAILS TO APAR SE10864: OSP DISPLAYING A SUBFILE, IT IS BLANK. APAR SE10879: CA400EXP PCSWS APPLICATION ERROR WHEN USING SEQUENCE KEY TO APAR SE11161: OSP-PAR COPY AND PASTE WITH ISERIES ACCESS FOR WINDOWS PC525 APAR SE11324: OSP-PAR COPY AND PASTE WITH ISERIES ACCESS FOR WINDOWS PC525 APAR SE11656: CA400EXP-PRINTEMUL-INCORROUT Problem with IBM5577.PDT APAR SE11657: CA400EXP-TERMEMUL-INCORROUT Horizontal Scroll bar when Font Size is changed is not working APAR SE11658: CA400EXP-TERMEMUL-INCORROUT Connect and Config options are disabled if the Host code page is changed and autoconnect is disabled PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE11182: CA400EXP-OPCON-UNPRED Direct connect fault with Win2k SP4 PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI08894 Build date = June 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE09627 OSP-PAR USING CHECK VERSION TO COPY INSTALL CODE TO PC BEFORE INSTALLING APAR = SE09912 CA400EXP-OPNAV-DBASE-INCORROUT AFTER SP INSTALL INSERT APAR = SE10014 OSP-PAR FUNCTIONS GRAYED-OUT OR FAIL EVEN WHEN ADMIN APAR = SE10564 CA400EXP-INCORROUT Cannot use Windows logon on 64-bit PC OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR = SE09708 CA400EXP-INRMTCMD-INCORROUT CMDS FAIL AFTER UPGRADING WINDOWS A PC used for running Incoming Remote Command (IRC) requests is upgraded from Windows 9x/Me to Windows NT/2000/XP. Some commands sent using RUNRMTCMD to this PC now fail, when they had worked before the Windows upgrade. Incoming Remote Command (IRC) now recognizes a new option: /loadprof This option tells IRC that whenever a command will be run in the context of a user ID sent with the command, the user profile should be loaded first. If it is successfully loaded, the command will have access to user-specific configuration information it might need to succeed. This information includes the HKEY_CURRENT_USER part of the registry and user-specific environment variables. The /loadprof option may be used in either of two ways. The first is to enter it as a Start Parameter when you start the iSeries Access for Windows Remote Command service. If you do that, the option will be applied to all commands run by IRC. The second method is to enter it as part of the command string, before the actual command. This method is useful if you want the option applied only to some commands but not others. For example, to tell IRC to load the user profile and then run the command 'myprog.exe' you would specify as the command the string '/loadprof myprog.exe'. If /loadprof is specified, but IRC has no user context to run the command in, the user profile will not be loaded. For example, when /runassystem ("run as system") is also used, the command is run in the context of whatever account the iSeries Access for Windows Remote Command service is configured to run under, not the context of the user ID sent with the command. Another example is when /nosecok ("Allow generic security") is also used, and *NONE is sent as the user ID. In both of these cases, no user profile can be loaded. There are several considerations to keep in mind when the /loadprof option is used. Firstly, use of this option does not guarantee that the user profile will be loaded successfully before your command is run. If IRC fails to load the user profile, it will run the command anyway, and the command may not have access to the user-specific configuration information. If this occurs, a message will be logged to the History Log indicating that the user profile was not loaded successfully. Secondly, omitting /loadprof does not guarantee that the user profile is not loaded when your command runs. User profiles are system-wide things, and some other process may have already loaded the user profile. If the user is signed-on to the PC on which the command is run, their profile might already be loaded and available to the command. APAR = SE10619 CA400EXP-INRMTCMD MSG1313 IRC DAEMON SERVICE DOES NOT START iSeries Navigator ----------------- APAR = SE06054 CA400EXP-OPNAV-NETWORK-INCORROUT Updating SMTP filters APAR = SE08141 OSP-DB-F/QZDACMDP-MSGPWS0010-T/QZDACMDP OPERATIONS NAVIGATOR APAR = SE09027 CA400EXP-OPNAV-NETWORK-INCORROUT RouteD config loses data APAR = SE09604 CA400EXP-OPNAV-INCORROUT ERROR CWBUNPLA DIALOG APPEARED APAR = SE09614 CA400EXP-OPNAV-MESSAGES-MSGSQL7959 CA400EXP USING OPSNAV APAR = SE09628 CA400EXP-2-INCORROUT UCW DOES NOT RECOGNIZE D/T2742 APAR = SE09640 CA400EXP-OPNAV-NETWORK-INCORROUT iNav hangs changing SMTP APAR = SE09684 CA400EXP-OPNAV-DBASE-MSGCPF0001 USING ISERIES NAVIGATOR TO D APAR = SE09706 CA400EXP-OPNAV-OUTPUT-MSGCPD0083 Error Moving Printer Output APAR = SE09727 CA400EXP-OPNAV-INCORROUT ADMINISTRATION SYSTEM TAB WITHIN APAR = SE09743 CA400EXP-OPNAV-DBASE-INCORROUT RUN SQL SCRIPTS HANGS WINDOWS APAR = SE09747 CA400EXP-OPNAV-OUTPUT-INCORROUT INTERNET SETUP WIZARD ON FRENCH APAR = SE09826 CA400EXP-OPNAV-DBASE-INCORROUT ADDITIONAL FILES DISPLAYED IN APAR = SE09851 CA400EXP-OPNAV-DBASE-MSGSQL0100 CANNOT UPDATE A TABLE THROUG APAR = SE09915 CA400EXP-OPNAV-NETWORK-MSGTCP2652 ENABLE PROXY ARP ON VIRTUA APAR = SE10078 OSP-IMPORT OF OVERLAY FAIL USING AFP MANAGER APAR = SE10161 CA400EXP-OPNAV-OUTPUT Error copying multiple spooled files APAR = SE10222 OSP FAILURE TO ACCESS THE PM400 TREND ANALYSIS DATA ON THE W APAR = SE10229 CA400EXP-OPNAV-OUTPUT-INCORROUT OUTPUT QUEUE DELETE ERROR APAR = SE10562 CA400EXP-OPNAV-NETWORK-INCORROUT Subsystem name discarded APAR = SE10565 CA400EXP-OPNAV-NETWORK-INCORROUT Can't add SMTP RR address APAR = SE10566 CA400EXP-OPNAV-NETWORK-UNPRED Improve diagnostics DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE09811 CA400EXP-DTRANSFER-INCORROUT WRONG MBR DISPLAYED IN BROWSE DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE09057 CA400EXP-ODBC SQLFETCHSCROLL DOESN'T RETURN CORRECT NUMBER O APAR = SE09116 CA400EXP-ODBC-INCORROUT DATA RETURNED FOR CLOB FIELDS APAR = SE09139 CA400EXP-ODBC-MSGERROR IN ROW ODBC APPLICATION FAILS WHEN ZE APAR = SE09168 CA400EXP-ODBC-MSG7357 (1CBD) OLE DB PROVIDER 'MSDASQL' APAR = SE09180 CA400EXP-ODBC-MSGSQL0666 R520 PERFORMANCE PROBLEM W/ APAR = SE09306 CA400EXP-ODBC-INCORROUT INCORRECT OUTPUT WITH EXTENDED FETCH APAR = SE09746 CA400EXP-ODBC SQLSTATE 22018 ERROR IN ASSIGNMENT APAR = SE09933 CA400EXP-ODBC-INCORROUT STACK OVERFLOW WHEN RETRIEVING CATAL APAR = SE10041 CA400EXP-ODBC-INCORROUT FILE DSN CONFIGURED TO USE WINDOWS U APAR = SE10057 CA400EXP-ODBC-MSGCWB0111 VERSION 2.0 APPLICATIONS AND UNICODE APAR = SE10374 CA400EXP-ODBC-UNPRED ORS DATA IS NOT RELEASED BECAUSE RETURN APAR = SE10563 ODBC XA support ODBC allows the MTS interface for distributed transactions in a Windows environment. However, in certain environments, like Linux, that is not an option. An interface is needed for Linux so that XA APIs can be called to perform distributed transactions. API changes: SQLSetConnectAttr now supports a 2140, 2141, and 2142 option. SQLGetConnectAttr now supports a 2140, 2141, 2142, 2143 option. Attribute: 2140 Description: An unsigned integer value that specfies the amount of time (in seconds) that an XA transaction will wait until it times out. A value of 0 indicates to wait indefinitely for the transaction to finish. Setting this overrides any value that was set for the XATIMEOUT connection string keyword. The default value for this attribute is 0. Setting this value at the present time will have no effect. Atribute: 2141 Description: An unsigned integer value that specfies the maximum amount of time (in seconds) that an XA transaction will wait on a lock request before timing out. A value of 0 indicates to use the default system settings. Setting this overrides any value that was set for the XALOCKTIMEOUT connection string keyword. The default value for this attribute is 0. Setting this value at the present time will have no effect. Attribute: 2142 Description: An integer value that specifies the RMID to use for XA transaction work. This can be set at anytime. The RMID that is set must be unique for the process. If this value is set to 0 it indicates that any current XA transaction work has been completed for this connection. The default value for this attribute is 0. Attribute: 2143 Description: A character string that identifies the iSeries Access driver to call into for XA calls. This string is only valid if the 2142 connection attribute has been set. This string is set after the connection is established. The default value for this attribute is an empty-string. SQLDriverConnect now supports the XATXNTIMEOUT and XALOCKTIMEOUT connection string keywords. See Attribute 2140 and 2141 for a description of what these attributes set. - xa_open is only called by the application for recovery purposes. When connecting through the ODBC API SQLConnect or SQLDriverConnect the xa_open is done automatically if the RMID was set via the 2142 connection attribute. - The connection attribute SQL_ATTR_AUTOCOMMIT must be set as SQL_AUTOCOMMIT_ON. - If an application wishes to start an XA transaction and then do some non-XA transaction work, one must set the RMID to 0 to indicate to the driver that the XA work is completed. - To do XA recovery an application calls xa_open with a string of "SYSTEM=mySystem;UID=myUserID;PWD="myPassword";DATABASE=myDatabase;" where mySystem is your system name, myUserID is your user ID on that system, and myPassword is that user ID's password. Note the string must be specified exactly as above or as "SYSTEM=mySystem;". Those two strings are the only two strings that will work. Below is the basic scenario on how an application calls into the driver to do a distributed transaction: 1. Application calls SQLSetConnectAttr and specifies the 2142 option indicating the RMID to use 2. Application calls SQLConnect / SQLDriverConnect (the driver does an xa_open) Optional: Application calls SQLGetConnectAttr to get the DLL name needed to make the xa_open call for recovery 3. Application calls ODBC APIs like normal and calls XA APIs to coordinate the transaction by calling into the iSeries Access DLL that supports the xa_switch. 4. Application calls SQLDisconnect (the driver does an xa_close) OLE DB PROVIDER --------------- APAR = SE09140 CA400EXP-OLEDB-INCORROUT AD400SEEKLASTEQ PARTIAL SEEK FAILS AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI08536. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE08385 CA400EXP-PC5250 IME_AUTO_START_N FUNCTION INCORROUT APAR = SE08553 CA400EXP-TERMEMUL-MSGPCSWS044 PCSWS044 PREVENTS PC FROM This issue affects laptops- the laptop cannot enter sleep mode without the user responding to this message- PCSWS044. Would like a way to turn it off. A keyword setting has been provided to control this behavior. The keyword should be added to the pcswin.ini file. PromptBeforeSleep=Y This is the default setting. When the keyword is set to Y, PC5250 will will prompt the user about whether to go into power saving mode if the session is connected. If the session is not connected, permission for Windows to go into power saving mode will be granted without prompting. PromptBeforeSleep=N When the keyword is set to N, permission for Windows to go into power saving mode will always be granted without prompting. APAR = SE08696 CA400EXP-TERMEMUL-INCORROUT PCSWS.EXE FAULTS STOPPING A SESSION APAR = SE08902 CA400EXP-TERMEMUL-INCORROUT UNABLE TO TYPE KATAKANA "WO" APAR = SE08973 PC5250 CAN'T TYPE N-TILDE IN ALPHABETIC FIELD IN DSPF, WHICH APAR = SE08975 CA400EXP-TERMEMUL-PERFM RUNNING MACROS IN MORE THAN 1 PC5250 APAR = SE09006 CA400EXP-TERMEMUL-PERFM PC5250 DISPLAY SESSION HANGS & LOOSE APAR = SE09016 CA400EXP-TERMEMUL-INCORROUT KEYBOARD MAPPING PROBLEM WITH GREEK APAR = SE09349 CA400EXP-PRINTEMUL-INCORROUT PC5250 PRINTER CAUSES FONT APAR = SE09502 CA400EXP-PRINTEMUL-INCORROUT AFTER APPLYING SI06631 THE FONT APAR = SE09761 CA400EXP-PRINTEMUL-INCORROUT PC5250 UNICODE CHARACTERS ARE APAR = SE09776 CA400EXP PC5250 INPUT INHIBIT DISPLAY SESSION APAR = SE10023 CA400EXP-PRINTEMUL DBCS COMPUTER OUTPUT REDUCTION PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE09791 CA400EXP-OPCON-UNPRED CWBOPCON.EXE ERRORS AFTER APPLY OF APAR = SE10250 OpConsole - CA400EXP-OPCON-UNPRED REMOTE CONTROL PANEL VIA CABLE WILL NO APAR = SE10315 CA400EXP-OPCON-INCORROUT SELECTING THE AUTO CONNECTION OPTION --------------------------------- Service Pack Level = SI07675 Build date = February 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE08411 CA400EXP-INSTALL-UNPRED INSTALL OF AFP/SCS PRINT DRIVERS ON WIN XP SP1 Installing the AFP or SCS Printer Drivers drivers included with V5R2 of iSeries Access for Windows, or V5R1 of Client Access Express, on a PC with Windows XP and XP Service Pack 1, generates a Windows Logo Testing warning/error during installation. With Windows XP SP1, Microsoft enforced the Driver Signing warn and block options, where previously, install programs could bypass these settings. Users can avoid this problem by not selecting the AFP and SCS Printer Driver components for installation. These components are in a Typical Install, so the user should select a Custom Install, and de-select the AFP and SCS Printer Driver components, if those components are not needed. If the user needs AFP and SCS Printer Driver components, then answer the Microsoft Driver Signing Option warning box with the Continue option to continue with the install. In addition, the user can specify to Ignore Driver Signing via the Windows Control Panel, System applet, Hardware tab, Driver Signing button. After the install, the setting can be restored to its previous value by the user. APAR = SE09143 CA400EXP-AFPVIEWER-INCORROUT CWBNP1019 RESOURCE AFP OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR = SE08698 CA400EXP-INRMTCMD-UNPRED USE WINDOWS LOGON DOES NOT WORK WITH IRC iSeries NAVIGATOR ----------------- APAR = SE08264 OSP-F/QCARULE-MSGCPD0039-T/QSQCALL APAR = SE08543 CA400EXP-OPNAV-DBASE-UNPRED SAVED DATABASE MAP CANNOT NOT BE APAR = SE08599 CA400EXP-OPNAV-MSGCWBUN0148 CWBUN0148 MESSAGE IS RECIEVED WH APAR = SE08724 CA400EXP-OPNAV-DBASE DETAILED SQL PERFORMANCE MONITOR FAILS APAR = SE08845 CA400EXP-OPNAV-PERFM OPS NAV APPEARS TO HANG OR IS SLOW TO APAR = SE09107 CA400EXP-OPNAV-FILESYS-MSGCPFA0A9 Permissions problem DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE08489 CA400EXP-ODBC ADO ERRORS 2147217887 AND 2147467259 IN CA APAR = SE08671 CA400EXP-ODBC-INCORROUT SQLGETINFO CATALOG_USAGE VALUE RETUR APAR = SE08715 CA400EXP-ODBC-INCORROUT ODBC RETURNS INCORRECT DATE, TIME, A APAR = SE08723 CA400EXP-ODBC CLOB FIELDS AND NULL VALUES APAR = SE08942 CA400EXP-ODBC-MSGSQL0551 MSGSQL0551 QSYS/QADBKFLD ODBC APP APAR = SE09104 CA400EXP-ODBC-PERFM PERFORMANCE PROBLEM WITH V5R2 ODBC OLE DB PROVIDER --------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI05645. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE08554 CA400EXP-PRINTEMUL-INCORROUT OUTPUT CHANGED ON R520 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE08827 CA400EXP-OPCON-UNPRED OPERATIONS CONSOLE SETUP HANGS AT MODE APAR = SE09008 CA400EXP-OPCON-INCORROUT HOST FILE ON THE PC IS NOT UPDATED --------------------------------- Service Pack Level = SI06631 Build date = November 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE07361 CA400EXP-DTRANSFER-INCORROUT TRANSFERRING TO CCSID 13488 APAR = SE07669 OSP-PAR CLIENT ACCESS LICENSE NOT ALWAYS RELEASING AFTER SET APAR = SE07950 CA400EXP-TERMEMUL-MSGCWBLM0011 CWBLM0011 ERROR WITH CLIENT APAR = SE08029 CA400EXP-DTRANSFER-WAIT CWBLMSRV.EXE INHERITING THE FILE APAR = SE08320 CA400EXP-CONNECTIONS-INCORROUT cwbcfg configs not changed; add /ipaddr modes When cwbcfg is run, even when /r is specified, not all existing user profiles are updated with the specified configuration information.  Users created after cwbcfg is run do get the configuration information, as desired. Also, the only IP Address setting possible using cwbcfg is to specify the IP Address explicitly, which implicitly sets the IP Address Lookup Frequency to Never. The other lookup frequencies cannot be set. The /ipaddr parameter now can be used with any of the following: n.n.n.n If the actual IP address is specified in the format n.n.n.n, it will be set, and will never be looked-up. *ALWAYS The IP address will be looked-up every time a connection is attempted. *HOURLY The IP address will be looked-up only if an hour has passed since the last lookup. *DAILY The IP address will be looked-up only if a day has passed since the last lookup. *WEEKLY The IP address will be looked-up only if a week has passed since the last lookup. *STARTUP The IP address will be looked-up only if Windows has been shutdown and re-started since the last lookup. For example, the following command will not only set the default user ID of system MySys to Frank, it will also set the IP Address Lookup Frequency so the address is looked-up only if at least a day has passed since the last lookup. Because /r is used, it will modify even existing MySys configurations. cwbcfg /host MySys /ipaddr *DAILY /uid Frank /r APAR = SE08343 CA400EXP-2-LOOP ByteStream type 1 directories with large number of entries will hang iNav IFS OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE06986 OSP-AFP-PRT UNABLE TO USE IMPORT OVERLAY FUNCTION OF AFP MAN APAR = SE07200 TCPIP-SMTP OP NAV FAILURE ATTEMPTING TO CHANGE/DISPLAY SMTP APAR = SE07618 OSP-MSGCPD0104-PAR-CA400EXP-OPNAV CANNOT ENROLL TO DOMAIN APAR = SE07701 CA400EXP-OPNAV-INCORROUT ISERIES NAVIGATOR GETS AN INVALID P APAR = SE07991 OSP-DB VISUAL EXPLAIN HANGS WITHOUT DISPLAYING RESULTS APAR = SE08031 CA400EXP-OPNAV-NETWORK-INCORROUT UNIVERSAL CONNECTION WIZARD APAR = SE08075 CA400EXP-OPNAV-DBASE-MSGSQL0615 VISULAEXPLAIN GOT SQL EXCEPT APAR = SE08101 CA400EXP-OPNAV-DBASE-INCORROUT OPERATIONS NAVIGATOR "RUN SQL APAR = SE08145 CA400EXP-OPNAV-DBASE-INCORROUT SQL SCRIPT SAVE AS SHOWS AN APAR = SE08162 CA400EXP-ODBC FAILURE. ERROR "DESCRIPTOR INDEX NOT VALID" IS APAR = SE08220 OSP-DB CA400EXP-OPNAV SQL EXCEPTION DURING CREATE LIBRARY APAR = SE08329 CA400EXP-OPNAV-INCORROUT Numeric at start domain name APAR = SE08346 CA400EXP-OPNAV-NETWORK-UNPRED Add new 2793 modem for UCW APAR = SE08403 CA400EXP-OPNAV-INCORROUT RESOURCEBUNDLEERROR RECEIVED IN OPN DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE07804 CA400EXP-DTRANSFER NATIVE SQL STATEMENT FAILS ON WINDOWS 98 DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE07497 CA400EXP-ODBC-INCORROUT STORED PROCEDURE EXPECTED TO RETURN APAR = SE07922 CA400EXP-ODBC-INCORROUT UNABLE TO LINK TO SPECIFIC LIBRARY APAR = SE07999 CA400EXP-ODBC-INCORROUT MS EXCEL 2000 GIVES ERROR IN ASSIGNM APAR = SE08021 CA400EXP-ODBC-INCORROUT MS ACCESS 2000 LINK EXTERNAL TABLE APAR = SE08207 CA400EXP-ODBC-INCORROUT - ODBC Driver uses too much memory OLE DB PROVIDER --------------- APAR = SE08268 CA400EXP-OLEDB-INCORROUT SEEK FUNCTION USED WITH IBMDA400 OL AFP WORKBENCH VIEWER -------------------- APAR = SE08202 CA400EXP-AFPVIEWER ERROR OCCURS USING *VIEW FROM AFPU TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI05645. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE06873 OSP-PAR PCSWS IPF IN MODULE UNKNOWN WHEN STARTING RUNNING VB APAR = SE07574 CA400EXP-TERMEMUL-INCORROUT BACKSPACE IN A WORD WRAPPABLE FI APAR = SE07671 CA400EXP-TERMEMUL-INCORROUT UNABLE TO USE SYSREQ ON PC5250 APAR = SE07743 CA400EXP-TERMEMUL-INCORROUT PC5250 HANGS WHEN USING SYSREQ APAR = SE07771 CA400EXP-PRINTEMUL-MSGPCSWS.EXE ERROR INTEGER DIVISION BY 0 APAR = SE07847 CA400EXP-TERMEMUL-INCORROUT NO ALARM ON ICF CLIENTS WHEN APAR = SE08022 CA400EXP-TERMEMUL-INCORROUT CURSOR DOES NOT POSITION PROPERL APAR = SE08139 CA400EXP-PRINTEMUL-MSGPCSWS PAGE FAULT WINDOWS 2K DESKJET APAR = SE08188 CA400EXP-PC5250 FILE TRANSFER FAILS WITH 'APPLICATION ERROR' APAR = SE08283 OSP-PAR V5R2M0 C2260 5722XE1 WITH PTF SI05853 ON MS WINDOWS APAR = SE08322 CA400EXP INCORECT FONTS FOR VIETNAMESE CAPS 5250 DISP EMU APAR = SE08323 CA400EXP-PRINTEMUL-UNPRED PC5250 IS RESTORING DEFAULT PAGE PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. --------------------------------- Service Pack Level = SI05853 Build date = September 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE06839 CA400EXP-OLEDB-MSGCWBDB0052 OLEDB APP CANNOT FIND CONVERSION TBL APAR = SE07116 OSP-PAR CWBCO1004 MESSAGE RETURNED FOR LOCAL PORT LOOKUP OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE05818 OSP-DB DATABASE NAVIGATOR 'ADD TO MAP' FUNCTION FAILS IF APAR = SE06093 OSP-AFP-PRT IMPORT OF OVERLAY ONLY WORKS FOR ENGLISH CA APAR = SE06804 CA400EXP-OPNAV-SECPOL-UNPRED ADD BUTTON DOES NOT SHOW UP APAR = SE06921 CA400EXP-BOOTP OPERATIONS NAVIGATOR LIMITS RANGE OF MAC ADDR APAR = SE07405 OSP PROBLEM WITH LOADING OF USER LIST WHEN WORKING WITH THE DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE06350 CA400EXP-DTRANSFER-INCORROUT ASCII TEXT WITH ZERO PAD DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE06149 CA400EXP-ODBC-INCORROUT INVALID LENGTH REPORTED ON CATALOG APAR = SE06414 CA400EXP-ODBC-MSGSQL0181 AND MSGCPF5035 RC18 ON ODBC TIMESTA APAR = SE06447 CA400EXP-ODBC-INCORROUT - ODBC FAILS TO RETURN FULL STORED PROCEDURE RESULT SET APAR = SE06802 CA400EXP-ODBC-INCORROUT RIGHT TRUNCATION ON CHAR DATA APAR = SE07095 CA400EXP-ODBC-INCORROUT PROBLEM IS RELATED TO EMBEDDED NULLS APAR = SE07172 CA400EXP-ODBC-INCORROUT NULL OUTPUT PARAMETERS RETURNING APAR = SE07583 CA400EXP-ODBC-INCORROUT - SQLProcedureColumns results incorrect OLE DB PROVIDER --------------- APAR = SE06106 CA400EXP-OLEDB-INCORROUT SINGLE PRECISION DEC INCORRECTLY INSERTED APAR = SE06588 CA400EXP-OLEDB-UNPRED EXECUTING A PREPARED CALL STATEMENT APAR = SE07584 CA400EXP-OLEDB-INCORROUT Better support for LOB bindings and SQL Server AFP WORKBENCH VIEWER -------------------- APAR = SE07260 CA400EXP-OPNAV Viewer Process Fails to end when error occurs TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR = SE03962 CA400EXP-DBCS PRINTED AS GARBAGE BY PRINTER SESSION APAR = SE04192 CA400EXP-SECURITY-MSG656 UNABLE TO CONNECT PC5250 WHEN PASSW APAR = SE05180 CA400EXP-TERMEMUL PCSCM.EXE-APPLICATION ERROR. THE INSTRUCTI APAR = SE06164 CA400EXP-TERMEMUL-MSGMCH0601 CSRINPONLY SPECIFIED IN DSPF APAR = SE06296 OSP-PAR PC5250 PROCESSING OF FIELD WITH WORD WRAP AFTER SI02 PC5250 processing of a field with continuous input and word wrap ( CNTFLD WRDWRAP ) has changed. Previously, PC5250 sent data to the OS/400 telnet server with blanks padded at the end of the line when a word was wrapped. SC41-5715 specifies that the blank padding will be removed. Once this change was made, some customers have had application problems. Some programs depend on this feature for processing of the field. A new keyword has been added to specify the wordwrap behavior as follows. This should be added to the workstation profile (.ws file). [LT52] WordWrapRemoveNulls = Y or N (default value is N) Value of Y: The nulls within wordwrap entry fields are removed from the data sent to the server. Value of N: The nulls within wordwrap entry fields are padded with blanks (instead of removing them) and then sent to server. APAR = SE06586 CA400EXP-TERMEMUL-LOOP WHEN USING IWMP2000 TO SCAN DOCUMENTS APAR = SE06719 CA400EXP-PC5250-INCORROUT VIETNAMESE 5250 DISPLAY EMULN APAR = SE06869 CA400EXP-TERMEMUL-INCORROUT SESSION HANGS ON EXIT IF CHANGES APAR = SE06871 CA400EXP-TERMEMUL-INCORROUT UNABLE TO SPECIFY A SECURE WEBSI PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE04218 CA400EXP-TERMEMUL-INCORROUT CLIENT ACCESS EXPRESS V5R1M0 EZ-SETUP -------- Non-APAR fixes. --------------------------------- Service Pack Level = SI04684 Build date = June 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE03830 CA400WINOPT IBMDA400 PARAMETER BIDI TRANSFORM IGNORED APAR = SE03863 CA400WINOPT - ARABIC TRANSLATION LAM-ALEF CHARACTER NOT GET APAR = SE05333 OSP-INCORROUT UNABLE TO USE DBCS SPECIFIC CHARACTER ON MS AC APAR = SE06009 CA400EXP-OLEDB-INCORROUT IBMDA400 MIXES DATA IN BIDI APAR = SE06195 INCORROUT UNABLE TO USE THREE THAI CHARACTERS WITH MS ACCESS OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE06470 OSP-PAR CLIENT ACCESS V450 OPERATIONS NAVIGATOR FATAL EXCEPT DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE04511 CA400EXP-DTRANSFER-UNPRED UPLOADING BIFF8 FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE06297 CA400EXP-ODBC-PERFM PARAMETER MARKER DESCRIPTION APAR = SE06298 CA400EXP-ODBC-INCORROUT - Miscellaneous ODBC problems APAR = SE06344 CA400EXP-ODBC-INCORROUT - Tool to update DSN information The CursorSensitivity keyword was added late in the V5R2 release. Consequently, it does not show up on the ODBC DSN Setup GUI. To better handle situations like this in the future a tool is needed to make it easier to update DSN information for new keywords. The current method for handling new keywords is to manually go edit the registry for User or System DSNs or the file for file DSNs. Also, another change in V5R2 was to have two ODBC driver names. ODBC DSNs created using the new driver name of "iSeries Access ODBC Driver" will not work with older versions of Client Access. To handle this compatibility issue, the tool being created should also provide a way to change the driver name to the old name of "Client Access ODBC Driver (32-bit)". The tool that is created is called cwbODBCreg.exe and is installed when ODBC is installed as part of Client Access. The tool resides in the \Program Files\IBM\Client Access directory. The syntax for running the tool can be found by running cwbODBCreg from a DOS command prompt without any parameters. APAR = SE06546 CA400EXP-ODBC-MSGCWB0111 CHARACTER DATA RIGHT TRUNCATION WIT OLE DB PROVIDER --------------- APAR = SE06083 CA400EXP-OLEDB-INCORROUT NUMBER OF ROWS AFFECTED IS INCORRECT APAR = SE06468 CA400EXP-OLEDB-UNPRED Adjust block factor to 1 for LOBs APAR = SE06469 CA400EXP-OLEDB-INCORROUT IBMDA400 RETURNS EMPTY RESULT SET F AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. EZ-SETUP -------- Non-APAR fixes. 4.0 INSTALL/UNINSTALL CONSIDERATIONS ------------------------------------- The following sections describe additional support and known problems that you may notice while using the Install/Uninstall function. 4.1 REMOVING THE SERVICE PACK ------------------------------ To remove this service pack from your PC: 1. Click the Windows Start button, click on Settings, and then click on Control Panel. 2. Double-click on the Add/Remove Programs icon. 3. Click on the Install/Uninstall tab, click on IBM iSeries Access for Windows SI10914 item, and then click on the Add/Remove button. 4. Follow the instructions on the screen. 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- InstallShield is the tool used to provide the install support for iSeries Access for Windows. The same tool is used for installing service packs. Setup.exe has a 2 minute timeout to initialize to the first wizard panel, which could expire when installing service packs over very slow communication lines. The suggested way of installing the service pack in this case is: 1) A setting has been added to the iSeries Access for Windows Properties Service tab that will copy the service pack image to the PC's temporary directory, install the service pack, then remove the copied files. To use this support you will need to specify this setting ("Copy install image to PC before installing"). STATUS: No status information is displayed while the files are copied. To determine if the transfers are progressing, look in the 'CA400CKV' temporary directory (beneath the PC temporary directory, for example C:\Documents and Settings\username\Local Settings\Temp). You should see new files appear periodically. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator can set the Install Service Pack policy restriction, or can use the SP.TXT file. If the administrator places a file named SP.TXT (with a 'N' in the first position of the first line) in the service pack installation image directory, the service pack will not be installed. 5.0 DATA TRANSFER CONSIDERATIONS --------------------------------- The following sections describe additional support or known problems that you may notice while using the Data Transfer function. 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 ----------------------------------------------------------- WHY DOES MY DATA LOOK LIKE GARBAGE WHEN I PERFORMED A DOWNLOAD? By default, the Data Transfer function will not convert data between EBCDIC and ASCII if the data is tagged with a CCSID of 65535. In older versions of the Win 95/NT Client Access product, the 65535 conversion was controlled by the CWBTFR.INI file. This process has been changed, and the conversion is now controlled by the Data Transfer user interface. Once the setting has been made in the user interface, it is then stored in the transfer request. This is only true for .TTO and .TFR files. .RTO and .DT files are still controlled by the CWBTFR.INI file. The conversion setting for .RTO and .DT files can be modified in the Data Transfer user interface, but the setting will not be saved. The setting to control the conversion is found in the File, Properties information. WARNING: This feature is designed as a workaround for people that can not change the CCSID of their files. In order for this translation to work properly, you must be confident the data in the file matches the CCSID of your user profile. The design of the iSeries is that data with a 65535 CCSID are not to be converted. This feature will attempt to do a conversion of the data from the job CCSID to the PC CCSID. This conversion may not work if the data in the file does not match the user profile/job CCSID. The correct solution to this problem is to appropriately tag the data with the correct CCSID. One way of doing this is by using CHGPF. For more information on the 65535 CCSID, please reference the iSeries National Language Support Manual.