============================================================================= Readme File for IBM i Access for Windows Service Packs 5770-XE1 V7R1M0 Cumulative Service Pack Level ------------- SI39894 ------------- (c) Copyright IBM Corporation 2010. All rights reserved. ============================================================================= 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. This PTF is subject to the terms of the license agreement which accompanied, or was contained in, the Program for which you are obtaining the PTF. You are not authorized to install or use the PTF except as part of a Program for which you have a valid Proof of Entitlement. SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT, REGARDING THE PTF. The applicable license agreement may have been provided to you in printed form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR) CL command. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN IBM i 1.2 COMBINING THE SERVICE PACK WITH AN IBM i ACCESS FOR WINDOWS INSTALL IMAGE 2.0 RECOMMENDATIONS/RESTRICTIONS 2.1 IBM i SERVER FIXES 2.2 APPLICATION DEVELOPMENT FUNCTION WITHIN System i NAVIGATOR 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI39894 (June 2010) - SERVICE PACK LEVEL = SI37895 (April 2010) 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 --------------------------------------------------------------------- 1.0 INSTALLATION INSTRUCTIONS ------------------------------ 1.1 INSTALLING FROM AN IBM i -------------------------------------- The following method would be used if you have received the IBM i Access for Windows service pack through the IBM i PTF ordering process either as an individual PTF order or as part of an i5/OS PTF cumulative package. Once this service pack has been applied to an IBM i with the LODPTF and APYPTF IBM i commands, it can be installed on individual PC's with the "Check Service Level" shortcut in the IBM i Access for Windows Service folder. Check Service Level, controlled by the IBM i 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 command will update each of the IBM i Access for Windows install image directories: \QIBM\ProdData\Access\Windows\Image32 \QIBM\ProdData\Access\Windows\Image64a This means that a user can install (or upgrade) IBM i Access for Windows from one of these combined image directories and get the latest applied service level automatically in one integrated step - since the original installation images files have been replaced by updated versions via the service pack PTF. Any client that installs IBM i Access for Windows (or selected features) from one of these images will automatically receive this service pack level. In this scenario, the service pack cannot be uninstalled on the client PC because it is merged in with the base release. NOTE: The IBM i contains two IBM i Access for Windows install images. One for each processor architecture supported by IBM i Access for Windows: \QIBM\ProdData\Access\Windows\Image32 (for 32-bit (X86) based PCs) \QIBM\ProdData\Access\Windows\Image64a (for AMD64 based PCs) Running setup.exe from the IBM i Access for Windows install image directory that matches your PC's processor type will launch the install wizard for that specific architecture. Running cwblaunch.exe from the IBM i Access for Windows install image root directory (\QIBM\ProdData\Access\Windows) will determine your PC's processor architecture and will launch the install wizard from the appropriate image directory. RMVPTF will restore your IBM i install image to the prior service level (or the base release if there was no prior service pack applied). 1.2 COMBINING THE SERVICE PACK WITH AN IBM i ACCESS FOR WINDOWS INSTALL IMAGE -------------------------------------------------------------------------------- If you have an install image on a local or network drive that you want to update to the latest service pack, please see Downloads.txt at: ftp://public.dhe.ibm.com/as400/products/clientaccess/win32/v7r1m0/servicepack/si39894/ 2.0 RECOMMENDATIONS/RESTRICTIONS --------------------------------- 2.1 IBM i SERVER FIXES -------------------------- In addition to installing the IBM i Access for Windows Service Pack, all servers should stay current on the latest Cumulative PTF Package, HIPER Group PTF, and Database Group PTF. Refer to IBM eServer IBM i Technical Support. Recommended fixes are at: http://www-912.ibm.com/s_dir/slkbase.nsf/recommendedfixes 2.2 Application Development function within System i Navigator --------------------------------------------------------------- The Application Development folder within System i Navigator is added when the System i Navigator Network component is installed. Application Administration can be used to restrict the display of the Application Development folder to certain users or groups of users. 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 = SI39894 Build date = June 2010 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE43455: OSP-PAR-940XCOM CA400EXP-SI37895 FAILED TO INSTALL WITH CUSTOM ACTION ERROR MSG SI37895 failed to install with Customer action CWBInitialSetup and ISSSetupFilesCleanup not found in Binary table stream error msg, depending iSeries Access for Windows MRI langage installed At root for this issue is the improper generation of elements essential for national language support of the installation wizard. Note this is an issue with the setup language choice, not the product MRI language choice. The improperly generated elements prevent the SI37895 service pack installer from executing successfully. Several languages have been discovered to be affected by this issue. Installs performed with the English setup language for GA and SI37895 are not affected. Due to the complexity and implications of this problem, a fix is being provided in the next service pack delivery - follow on for SI37895 - for the IBM i Access for Windows 7.1 product. RESOLUTION: The indicated problem is the result of a third-party program defect for which the IBM i Access for Windows team will deliver a change which circumvents the problem and allows service pack installation to proceed normally. We have worked with our third-party support partners to ensure our solution is complete. CIRCUMVENTION: Customers who have already installed 7.1 GA should apply the service delivery which fixes this issue as soon as possible. Customers who have not yet installed 7.1 may avoid this issue entirely by waiting until the service level containing the fix is delivered, and applying it immediately and skipping SI37895. Those customers who want to install 7.1, who must have SI37895, and cannot wait for the next service delivery can execute the installer with the English setup language (with both GA and service pack installs) and will avoid the problem when SI37895 is installed. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. System i NAVIGATOR ----------------- No fixes. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE42664: CA400EXP-DTRANSFER-INCORROUT DATA TRANSFER FAILING WITH LONG FILE NAMES QUOTES ON FILE NAMES Data transfer failing with long file names quotes on file names RESOLUTION: Data Transfer will retrieve the short file name from the server before retrieving data from the IBM i. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- No fixes. OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE42054: AFP Viewer fails on Windows 7 The AFP Viewer shipped with IBM i Access for Windows fails to open when used to view a spooled file and is running on the Windows 7 operating system. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.7 including support for JDBC 4.0 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 6.0 Level 20100209 SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE42550: CA400EXP-OPCON-INCORROUT PARTITION ID >255 MAY FAULT Operations Console may terminate abruptly if a nearby system is discovered having a partition ID larger than 255. RESOLUTION: Operations Console can now handle partition IDs up to 4095. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. --------------------------------- Service Pack Level = SI37895 Build date = April 2010 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE42135: CA400EXP-CONNECTIONS-INCORROUT CWBCFG MAY FAIL FOR DOMAIN USERS The CWBCFG connection creation utility will not process all users under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList when one such is encountered with a missing registry entry, such as ProfileImagePath. RESOLUTION: As of 6.1 SP6, CWBCFG will skip any user for which it cannot load the registry hive and continue to process the rest of the users. CIRCUMVENTION: A valid ProfileImagePath can be added to each profile under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList, allowing CWBCFG to run successfully. APAR SE42176: CA400EXP-INSTALL Disable iNav Clustering function The Upgrade Planning Statements web site documents IBM's intent to make IBM i 6.1 the final available release of the Clusters GUI plug-in for System i Navigator. Details are provided at: http://www-947.ibm.com/systems/support/i/planning/upgrade/v6r1/planstmts.html This APAR is created to deliver changes to the IBM i Access for Windows client to disable the Clusters GUI plug-in for System i Navigator. RESOLUTION: As documented on the Upgrade Planning Statements web site, clustered environments will still be manageable via GUI and CL command interfaces with the PowerHA for i (5761-HAS) product. Upon installation of the IBM i Access for Windows Service Pack 1 delivery, the Clustering GUI functions will no longer be available within the System i Navigator. CIRCUMVENTION: As documented on the Upgrade Planning Statements web site, clustered environments will still be manageable via GUI and CL command interfaces with the PowerHA for i (5761-HAS) product. APAR SE35852: CA400EXP-INSTALL ADMIN IMAGE FAILS FROM NETWORK DRIVE Attempting to update an administrative image fails when the installation image is located on a network drive. The user is presented with the following message: "Could not update readmesp.txt. rc=3" The installation log file contains the following message: 'CopyFile' for 'source: "readmesp.txt", target: "readmesp.txt"' failed with return code '3' CIRCUMVENTION: Copy the administrative installation image as well as the service pack executable to a folder on your local PC, and perform the update process locally. Once the update process has been completed, you can copy the administrative image back to the distribution point in your network. APAR SE36316: CA400EXP-INSTALL ADMIN IMAGE FAILS WHEN USING NON-ENGLISH The problem occurs when the customer combines service pack SI32504 (for 6.1) with an administrative image and starts an installation from the combined image, and in the Choose Setup Language dialog selects a language other than English. The following message is displayed: "Fel 2229. Database: Could not load table 'LaunchCondition' in SQL query: SELECT 'Condition', 'Description' FROM 'LaunchCondition'" CIRCUMVENTION: The customer can start the installation and select English in the Choose Setup Language dialog. Although the installation wizard will be presented in English, the customer will be able to select any language as the product's primary language. APAR SE41142: CA400EXP-SECURITY-UNPRED ATTEMPTS TO CONNECT TO A MACHINE USING KERBEROS AUTHENTICATION FAILS. Attempts to connect to a machine using kerberos authentication fails, sometimes resulting in a CWBSY1012 or CWBSY1013 message. APAR SE42451: CA400EXP-LICMGMT-MSGCWB099 RC052 274D with mobility client On a laptop with a corporate mobility client installed, IBM iSeries Access connections fail with message CWB0999 RC9052 274D when trying to verify that the proper license exists. RESOLUTION: The problem is a bug in the mobility client software, and only occurs when IPv6 connections are attempted. This fix introduces a workaround by enabling the customer to disable IPv6 (on some communication flows) by setting the environment variable CWB_IPC_NOIPV6SOCK to 'Y'. This is best done by altering the PC's system variables and rebooting. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. System i NAVIGATOR ----------------- APAR SE40093: CA400EXP-OPNAV-OUTPUT-INCORROUT REORDER LIST OF OUTPUT QUEUES BY NAME; DISPLAYING OUTPUT QUEUE DISPLAYS WRONG QUEUE 1. Under My Connections, expand the system 2. Expand Work Management 3. Expand Output Queues 4. Click Output Queues 5. . Resort by Output Queue name 6. Right click on output queue and click Open. 7. A window then appears (note "correct" output queue name in top bar, but incorrect spooled files). RESOLUTION: System i Navigator V6R1M0 service pack 6 will contain this fix. The correct output queue will be opened(both correct output queue name and correct spooled files). DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE41961: CA400EXP-DTRANSFER - Excel addin doesn't support FDF with MS XML file type listed When using the Excel addin for Data Transfer to upload a MS Excel XML file with a previous created FDF with the file type specifies as 22. The upload to replace/append data file will fail with unsupported FDF file message (CWBTF0083). APAR SE42430: CA400EXP-DTRANSFER-INCORROUT BROWSE NOT RETURNING LIBRARIES When using cwbtfr.ini file option useDelimitedNames=0 to remove delimiters from output in Data Transfer function, the Browse button may not work correctly to return user library list. RESOLUTION: The option will allow a user to retrieve the library list. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR 34784558: CA400EXP-ODBC-UNPRED UNMATCHED ESCAPE ODBC crashes when a statement is prepared with two unmatched escape clauses. RESOLUTION: ODBC has been corrected to not crash when handling two unmatched escape clauses. APAR SE38018: CA400EXP-ODBC-INCORROUT ISERIES NAVIGATOR ENDS WHEN SECURITY EXIT PROGRAM REJECTS REQUEST. System secured by security exit programs, specifically for client DB access on the QZDAxxxxxx jobs. When performing a function in the iSeries Navigator Database container that the user is not authorized to do by the security exit program and is rejected, iSeries Navigator will just end. The Database container uses ODBC to perform most of its functions and ODBC will connect to the QZDAxxxxxx jobs. Example: User is not authorized to create procedures and if that user attempts to create a procedure in iSeries Navigator Database functions will cause iSeries Navigator to end. RESOLUTION: iSeries Navigator will no longer end when an exit program exists that rejects the user's request. APAR 34790650: CA400EXP-ODBC-INCORROUT CLOB fields in Result Sets The problem was incorrect logic for setting the length of LOB fields in an internal control block. APAR SE37242: CA400EXP-ODBC-MSGSQL0501 ENCOUNTERED WITH ODBC APPLICATION USING R610 SYSTEM I ACCESS ODBC DRIVER. ODBC application using the R610 System i Access ODBC driver encounters a msgSQL0501. Previous versions of the iSeries Access ODBC driver do not encounter this issue. The ODBC driver defaults to have 'Enable pre-fetch of data for queries' at R610 System i Access ODBC driver. Disabling the pre-fetch option allows the operation to work again. RESOLUTION: The SQL0501 message will no longer be seen and applications will work correctly. CIRCUMVENTION: To circumvent this problem, un-check the ' Enable pre-fetch of data for queries' checkbox under the performance tab on the for the corresponding data source, or set the PREFETCH connection string keyword = 0. APAR SE38597: CA400EXP-ODBC-INCORROUT ISERIES ACCESS ODBC API SQLSETDESCFIELD DOES NOT EXIT WHEN ODBC OLEDB WRAPPER USES A CLIENT-SIDE CURSOR SQLSetDescField API sometimes returns incorrect results when called repeatedly in the application. RESOLUTION: The iSeries Access ODBC driver will now correctly handle SQLSetDescField requests. APAR SE40400: CA400EXP-ODBC-INCORROUT ERROR MESSAGES RETURNED TO ODBC WITH INCORRECT CONVERSION OF NATIONAL LANGUAGES When using the iSeries Access for Linux ODBC driver on a client using a national language other than English, error message text is returned to the client ODBC layer with incorrect conversion. For example, the following might be seen in an SQL.log trace: [unixODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token . ung}ltig. G}ltige This is caused by the ODBC driver not increasing the message buffer length when converting from source to target code pages. RESOLUTION: Messages will now be returned properly to the client application. APAR SE41622: CA400EXP-ODBC-INCORROUT COMMA AS DECIMAL SEPARATOR When the option in the data source to use the comma as the decimal separator character, the output of decimal data is inconsistent depending on how the application retrieves the data. An application using the SQLGetData to return decimal data to a character variable, in other words, it is not binding the result columns to a variable, will get a period as the decimal separator regardless of the data source or Windows regional settings. RESOLUTION: Strings containing character representation of a packed or zoned decimal field will now contain the comma as a decimal separator provided the user has done the following : - set their decimal separator in their data source set to comma. - sets the DEBUG keyword to a value of x'20000', 131072, or some combination containing those numbers such that the 18th bit in the value ('100000000000000000'b) is set. OLE DB PROVIDER --------------- APAR SE41276: CA400EXP-OLEDB-MSGSQL0199 ON UPDATE OF RECORDSET IBM iSeries Access for Windows OLEDB provider will generate an incorrect update statement in cases where the update statement provided by the application has embedded carriage returns and line line feeds as the only delimiter between tokens. The invalid update statement will usually cause an SQL0199 error message because a token is out of place. An example which would fail would be an application using a select statement such as, "SELECT * FROM MYTABLE WHERE COL1=? AND COL2=?" There are no spaces after "MYTABLE" or before "WHERE" in this example, the only characters between those tokens are a carriage return and a line feed. The update statement that is generated to update the recordset returned by the statement above would be, "UPDATE MYCATALOG.MYSCHEMA.MYTABLE WHERE SET COL1=? WHERE COL1=? AND COL2=?" You can see that the name of the table, the carriage return, line feed and the next word have all been treated as one token by the OLEDB provider. This error started occurring in V5R4 after applying the service pack which corrected the problems fixed in APAR SE30788. Older versions of the product do not have this problem. To avoid this problem, an application simply has to have a space before or after the carriage return and line feed characters or remove the carriage return and line feed characters altogether. .NET DATA PROVIDER ------------------ APAR SE38978: CA400EXP-IDB2DATA Visual Studio TableAdapter fails to generate commands Visual Studio TableAdapter does not always generate Insert / Update / Delete statements when it should. APAR SE41598: CA400EXP-IDB2DATA-INCORROUT Implement Command.Cancel The iDB2Command.Cancel method is a no-op and does not actually cancel a long-running command. While this behavior is documented, adding support for the Cancel method would be very helpful. RESOLUTION: This PTF adds support for an implementation of iDB2Command.Cancel. Because a long-running command ties up the thread that executes the command, an application must call the Cancel method on a separate thread from the thread executing the long-running command. When a command is canceled, any active iDB2DataReader object associated with that command will no longer return data from a Read() request. APAR SE42378: CA400EXP-IDB2DATA RDONLY XA TRANSACTIONS CAUSE NEXT TO FAIL If an application using XA transactions prepares the transaction branch, and receives the XA_READONLY (transaction is read only, automatically committed) return code, the CWBDC component does not recognize the transaction has been completed. Any attempt to start another distributed transaction on the same connection will result in an error indicating a transaction is already in progress. This error message has been reported with the .NET provider: Message : An error occurred while processing a distributed transaction. MessageDetails : Distributed transaction is already started. APAR SE42659: CA400EXP-IDB2DATA-INCORROUT SYSTEM.ACCESSVIOLATIONEXCEPTION WHEN USING CHECKCONNECTIONONOPEN An application is using the CheckConnectionOnOpen .NET provider property to check for connection failures when a connection is removed from the pool. This is intermittently failing with: iDB2DCFunctionErrorException - Unexpected Exception. Type: System.AccessViolationException Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Details: Exception calling CwbDc.IsAlive from MPConnection.IsAlive. If the CheckConnectionOnOpen property is turned off, the exception does not occur. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.7 including support for JDBC 4.0 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 6.0 Level 20100209 No fixes. SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. --------------------------------- Service Pack Level = SI36916 (GA) Build date = January 2010 --------------------------------- 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 ------------------------------ You cannot remove a service pack that was installed by running setup.exe from an updated installation image. In order to remove a service pack that was installed in this fashion, you must first uninstall IBM i Access for Windows. Then, re-install it using an image that is at an older service level, such as the image available on the IBM i Access for Windows DVD. 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- If you experience problems while installing a service pack over slow communication lines, and if installing from a DVD or a faster connection is not possible, then the service pack could be installed in this manner: 1) A setting exists on the IBM i 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: Go to the "IBM i Access for Windows Properties" Select the "Service" tab Check the box "Copy install image to PC before installing" 2) Run Check Service Level (either from the IBM i Access for Windows Service folder shortcut or when Check Service Level runs at system boot on its defined schedule) No status information will be displayed while the files are being copied. To determine if the transfers are progressing, look in the 'CA400CKV' directory. This will be a sub directory below the %TEMP% directory. For example: C:\Users\\AppData\Local\Temp\CA400CKV You should see new files appear periodically. 3) Proceed through the install wizard to complete the install. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator 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.