============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R4M0 Cumulative Service Pack Level ------------- SI32972 ------------- (c) Copyright IBM Corporation 2008. All rights reserved. ======================================================================== SI32972 can be installed on any PC/server that is at V5R4 service level SI20465 or newer. See iSeries Access for Windows Properties in the IBM iSeries Access for Windows folder to determine current service level. Previous service pack readmesp.txt files can be downloaded from the following website: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32 Select the directory for the release, then the "servicepack" directory, then the service pack PTF number. In each such directory will be the readmesp.txt file. Since the full problem description text for each APAR is not carried forward into the next service pack's readmesp.txt file, you may want to download such files to read details about these earlier fixes. Windows Vista Support --------------------- Starting with service pack level SI25949 iSeries Access for Windows supports running on Windows Vista. There are a few issues you should be aware of when installing on a PC with Windows Vista: First, using Check Service Level or Install Service Pack from a service level prior to SI25949 to install this service pack (SI32972) is not supported on Windows Vista. Please see section 1.0 INSTALLATION INSTRUCTIONS for details about other methods of installation for the service pack, either by running setup.exe or setupsp.bat. Another issue concerns how the Check Service Level function works once this service pack has been installed on a Windows Vista PC. Check Service Level determines whether there is a more recent version or service pack of iSeries Access for Windows available at a configured location, than is currently on your PC. Due to a Microsoft restriction new in Windows Vista, programs that run at logon time may not use administrator authority, and may not launch other programs that do. Because Check Service Level launches applications that require administrator authority (such as Service Pack install), it may not run at logon time. Settings in iSeries Access for Windows Properties that control how often Check Service Level runs at logon time will be ignored on Windows Vista. To run Check Service Level manually, click Start, All Programs, then iSeries Access for Windows, then Service, then Check Service Level. Another issue has to do with the Welcome Wizard. If you run the setup.exe program to install the entire product along with the service pack, you will have the opportunity at the end of the installation to choose whether you want the Welcome Wizard to be launched at the next logon or not. Because the Welcome Wizard uses the Microsoft WinHelp engine to display its contents, if you are installing on a Windows Vista PC, the Welcome Wizard will not work unless you have downloaded the WinHelp engine from Microsoft's website and installed it on the PC. If you have not done this, when you next logon, you will receive a message from Windows Vista stating that you cannot get help from the program because it uses the WinHelp engine, which is no longer shipped with Windows Vista. This can be a nuisance, especially when the Welcome Wizard is automatically launched at every logon. Therefore, you may, at install time, elect not to have the Welcome Wizard run at logon time, by unchecking the appropriate checkbox. The logon-time run of the Welcome Wizard can be re-enabled from the "Other" tab of iSeries Access for Windows Properties, once the WinHelp engine has been installed on the PC, if you wish. If you already chose to run the Welcome Wizard at logon, you can disable this via the "Other" tab as well. A third issue is related to installing from the applied iSeries PTF. Once the PTF is applied, you can install this service pack or complete merged image from the network share called QIBM on your iSeries system. Accessing this share uses the LAN Manager component of Windows, and NetServer support on the iSeries server. In Windows Vista, Microsoft has changed the default negotiation method for such connections, so that, at this time, accessing shares on the iSeries system will fail. One way to work around this problem is to change a policy setting on the PC. This action requires administrator authority, and can be performed as follows: 1) Click Start, click All Programs, click Accessories, click Run; then type "secpol.msc" (without the quotes) in the Open text box, and click OK. 2) If a User Account Control dialog box appears. verify that the details shown match the request you initiated (you are starting the Microsoft Management Console), and if so, click Continue. 3) From the Local Security Settings console tree, expand Local Policies, then click Security Options. 4) In the right pane, scroll down to the setting called "Network security: LAN Manager authentication level Properties" and double-click it. 5) Note the current value. The default value at the time of this writing is "Send NTLMv2 response only" If the value is not as follows, change it to be: "Send LM & NTLM - use NTLMv2 session security if negotiated" then click OK, and exit the Local Security Settings console. You should now be able to access network shares on the iSeries system. The last issue has to do with installing from a network share. Testing has shown that, in some cases, installing iSeries Access for Windows on a Windows Vista PC from a network share, fails. In such cases, copying the files from the network share to the PC's local hard disk, then re-starting the installation from the local hard disk, completes successfully. The cause of this failure is being investigated. There are other issues, known problems, and details regarding how iSeries Access for Windows works on Windows Vista, that IBM highly recommends that you read about. See information associated with APAR SE27507, and read Information APAR SI14239, so you are prepared to run iSeries Access for Windows on Windows Vista. 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 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 RECOMMENDATIONS/RESTRICTIONS 2.1 iSeries SERVER FIXES 2.2 APPLICATION DEVELOPMENT FUNCTION WITHIN iSeries NAVIGATOR 2.3 iSeries NAVIGATOR DATABASES COMPONENT 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 Service Release 8 (SR8) 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI32972 (December, 2008) 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 via a download from IBM's FTP site. 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-03.ibm.com/servers/eserver/iseries/access/casp.html 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 tailored the iSeries Access for Windows 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 directory on your PC or server. 2. Run PTFFORM.EXE to automatically expand the service pack image files to a temporary directory. 3. You will then be prompted via a wizard panel to select the iSeries Access for Windows install image directory to update to the new service level. 4. The components that are contained in the target install image will be automatically updated to the new service level from the files in the temporary directory, and then the temporary directory will be removed. 5. After completion, you can delete the downloaded PTFFORM.exe file, as it is no longer needed. 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 5-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 RECOMMENDATIONS/RESTRICTIONS --------------------------------- 2.1 iSeries SERVER FIXES -------------------------- In addition to installing the iSeries 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 iSeries Technical Support: Recommended fixes at http://www-912.ibm.com/s_dir/slkbase.nsf/recommendedfixes 2.2 Application Development function within iSeries Navigator --------------------------------------------------------------- The Application Development folder within iSeries Navigator is added when the iSeries 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. 2.3 iSeries NAVIGATOR DATABASES COMPONENT ------------------------------------------ The 'Import Data' and 'Export Data' wizards in iSeries Navigator use the CPYFRMIMPF and CPYTOIMPF CL commands, respectively. The commands may function check with an MCH3402 message when executed by iSeries Navigator. The first time the wizards execute the command it will succeed, but later attempts may fail if the database host server job is reused for a later use of the wizard. The commands may fail with a CPF4248 message with reason code 3 for an ASCII or Unicode CCSID. This is an error in writing data to the error record file (ERRRCDFILE parameter on the CPYFRMIMPF command) if the data file is ASCII or Unicode. Lastly, a problem with system names that contain double quote characters has been identified. Apply the latest PTFs for CPYFRMIMPF and CPYTOIMPF on the server if you plan to use the 'Import Data' and 'Export Data' wizards. PTFs SI20896 and SI17385 for product 5722SS1 V5R3M0 are required. PTFs SI21418 and SI21459 for product 5722SS1 V5R4M0 are recommended. In V5R4M0, SQL Assist has been changed so that 'smart statement selection' can be used to pre-prime the SQL statement at the cursor position into the SQL Assist dialog. In V5R3M0 and earlier, the user had to manually select the SQL statement that SQL Assist would use. The new design is similar to using 'smart statement selection' to execute an SQL statement. However, when 'smart statement selection' is enabled, the user will be unable to position the cursor at an arbitrary place in the script and start with a default SQL statement in SQL Assist. The SQL statement nearest the cursor position will be shown in the SQL Assist dialog. If the user wishes to use SQL Assist to insert a new statement into the script, disable 'smart statement selection' with the 'Options/Smart Statement Selection' menu item. SQL Assist will appear with a default statement, or with the text that was explicitly selected as it would in V5R3M0. APAR SE22766 documents the following scenario that will be addressed in a future release: Run SQL Scripts now reports the return code from a stored procedure for the CALL statement. The return code is specified by an optional RETURN statement in an SQL stored procedure, or by a high level language construct in an external stored procedure. If the user runs a CALL statement to call a stored procedure A that returns a return code, Run SQL Scripts will report the return code. However, if the user runs another CALL to a stored procedure B which does not execute the RETURN statement, Run SQL Scripts will report the previous return code from A as the return code for the latter stored procedure B. The following document conditions that will be fixed in a future release: APAR SE25353: CA400EXP-OPNAV-DBASE-MSGSQL0443 ANALYSIS QUERIES FETCHING The 'Analysis Queries' dialog from 'Analyze...' option for a SQL Performance Monitor or SQL Plan Cache Snapshot may stop displaying results after working with a specific SQL Performance monitor or SQL Plan Cache Snapshot after displaying several reports. This symptom may happen with any detailed report or SQL Plan Cache Snapshot, such as the resulting list from 'Analysis Queries' option on 'Analyze...' for SQL Performance Monitor or SQL Plan Cache Snapshot. Everything in the report may work fine for a while before the user may see the MSGSQL0443 error message and a resulting blank list. Right-click on a SQL Performance Monitor or SQL Plan Cache Snapshot, select 'Analyze...' option on the context menu. It will bring up the Analyze dialog. Select 'Analysis Queries' option from 'Actions' menu. From the resulting list, stepping through the rows, one at time and clicking 'View Results' from 'Actions' menu causes the behavior. You may see the MSGSQL0443 error message, and then if you scroll up or down, the list becomes empty. APAR SE25354: CA400EXP-OPNAV-DBASE OVERSIZED ICON ON VISUAL EXPLAIN Visual Explain shows oversized icons. This may happen if you resize the Visual Explain window as it is being drawn and the 'Graph Detail' option is set to FULL. The following document conditions that are permanent restrictions, however, circumventions do exist: APAR SE25179: CA400EXP-OPNAV-DBASE-MSGMCH0602 VISUAL EXPLAIN Visual Explain fails with 'Boundary alignment of pointer or template not valid' error message. You may see this error when you use iSeries Navigator for V5R4 against a v5r3 or v5r4 system and try to run Visual Explain. This may happen if the QIWS.QQQDBVE2 stored procedure has been created incorrectly. CIRCUMVENTION: Recreate the QIWS.QQQDBVE2 stored procedure using the following steps: 1) In STRSQL, Run SQL Scripts in iSeries Navigator, or any SQL interface, execute the following statement: DROP SPECIFIC PROCEDURE QIWS.QQQDBVE2 2) From iSeries Navigator, go to Databases > DatabaseName > Schemas > QIWS > Procedures and then Delete the QQQDBVE2 procedure. If the QIWS is not listed on schemas, you can add it through 'Select Schemas to Display' option of the context menu of the Schemas folder. 3) iSeries Navigator is responsible for creating this procedure. The next time Visual Explain is used it will recreate the QQQDBVE2 procedure. APAR SE25238: CA400EXP-OPNAV-DBASE-MSGSQL0332 NEW SQL PLAN CACHE SNAPSHOT iSeries Navigator cannot create a SQL Plan Cache Snapshot. A message dialog may display the MSGSQL0332 and a MSGCPD4381 may be displayed in the Job log. If the control files that iSeries Navigator uses to retrieve the list of monitors have different CCSID's, the query will only work if the conversion between both CCSID's are supported. CIRCUMVENTION: The control files QAUGDBPMD and QAUGDBPMD2 are used to get the list of SQL Performance Monitors and SQL Plan Cache Snapshots. The control files may exist in QUSRSYS library if working with the SYSBAS ASP and may be in the QRCYnnnnn library if connecting to an IASP as well. Alter either one or the other control file's columns that are CCSID based so they have the same CCSID in those columns as the other control file. Another work-around is to delete one of the control files, sign-on to iSeries Navigator using a userid with a compatible CCSID and this will recreate the control file using the user's CCSID. 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 Service Release 8 (SR8) ------------------------------------------------------------------ PTF 5722XE1 V5R4M0 SI29819 contains Java Runtime Environment (JRE) 1.4.2 Service Release 8 (SR8) which will replace version 1.4.2 SR2, which was on the original iSeries Access for Windows V5R4M0 media. The following APAR is fixed with JRE 1.4.2 SR8: APAR SE29861: CA400EXP-DATEBASE-INCORROUT JAPANESE WINDOWS VISTA, RUN SQL Run SQL scripts fail to open when using Japanese Windows Vista with error message "cwbunnav.exe is stopped". If SI29819 is applied to the iSeries, and a service pack install is run from that iSeries image, the service pack install will upgrade the JRE level, if needed. Subsequent service packs will not reinstall the JRE if the latest level already exists on the PC. A new install, reinstall, or upgrade from an install image with SI29819 applied, will install the new JRE 1.4.2 SR8. A JRE 1.4.2 SR8 install package will also be provided on the IBM FTP site in a subdirectory off of the service pack FTP directory, for those users that prefer to get their service packs from the IBM FTP site. 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 = SI32972 Build date = December, 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE34758: CA400EXP-NLS-INCORROUT CONVERSION FROM UNICODE TO BIDI If bidirectional text support is enabled when converting from Unicode to bidirectional text the output text may be followed by unexpected characters. For instance, when the "Enable bidirectional script transformations" checkbox is selected inside the "iSeries Access for Windows properties" panel, a problem may present in Data Transfer when downloading data to an Excel spreadsheet. A field with a value of 5070020 will have an extra zero appended to the end resulting in an incorrect value of 50700200. RESOLUTION: The conversion returns the buffer without unexpected characters at the end. APAR SE34759: CA400EXP-NLS-INCORROUT CONVERSION FROM UTF8 TO UNICODE Incorrect conversion when converting data from UTF8 to Unicode. When the target buffer is not large enough to store the converted data, an exception may occur instead returning a buffer overflow. For instance, the problem may occur in System i Navigator when viewing contents of a table with a Large Object field. RESOLUTION: The conversion returns a buffer overflow when the target buffer is not large enough to store the converted data. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE35298: CA400EXP-OPNAV-DBASE-INCORROUT CONDENSED INDEX ADVICE LIST After an advised index is created from the Condensed Index Advice list, a message box is displayed with the following question: "The index has been created successfully. Would you like to remove the advised index entry?". If the response is Yes, an exception "An unknown error has occurred" is displayed. The message box with the question should not be displayed when creating an advised index from the Condensed Index Advice list. APAR SE35303: CA400EXP STATISTICS DATA DISPLAYS 1ST PARTITION MEMBER INFO The Statistics Data window is not displaying complete information when it is displayed for a partitioned table from within the Visual Explain window. This window only displays data for the first (*FIRST) partition of the table. ADDITIONAL KEYWORDS: OPNAV-DBASE-INCORROUT APAR SE35308: CA400EXP-OPNAV-DBASE INDEXES LIST INSTEAD MQTs LIST FROM VE When working with a table from within the Visual Explain window, after selecting the table, if the user selects the Show Materialized Query Tables option from the Actions menu, the Indexes list is displayed instead of the related Materialized Query Tables list. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Use the table's context menu instead. APAR SE33859: CA400EXP-OPNAV SOME LINKS AT HELP TOPICS SEARCH WINDOW FAIL Some links in the Help Topics search window fail with "The topic does not exist. Contact your application vendor for an updated Help file (129) message. RESOLUTION: This problem will be fixed next release, because it involves MRI APAR SE33892: CA400EXP-OPNAV-NETWORK KERBEROS WIZARD CALLED FROM EIM HANGS Additional Keywords: INCORROUT A problem was reported into the Network Authentication Service configuration wizard when the next steps are followed: 1.- Configuring iSeries Netserver and selecting Passwords/Network authentication option as the authentication method. 2.-Press the Verify configuration button, the EIM Configuration wizard should be displayed. 2.-The screen changes to EIM Configuration wizard - Select Join an existing domain. 3.-Configure Network Authentication Service. Select yes, 4.-Would you like to configure network authentication at this time? Click next and it hangs. The screen never changes and a restart of the iSeries Navigator is required to recover. APAR SE34466: CA400EXP-OPNAV CWBUNNAV.EXE FAILS WITH SECUR32.DLL FAULTING There are three different scenarios for the same problem: 1. When iSeries Navigator is started, an error message may be displayed stating that the Fault Module Name is Secur32.dll. This error has been reported running with iSeries Access and Windows Vista Enterprise Edition with SP1. 2. Start iSeries Navigator, from Environment tasks, select Install plug-ins. Type the source system from where to install the plug-ins. Once the Setup is started and the Signon to iSeries Netserver is displayed, click Cancel. The cwbunnav.exe error described on scenario 1 may be displayed. 3. Operations Console may not start on Windows Vista SP1. APAR SE34893: CA400EXP-OPNAV DOWNLOAD CA FAILS WITH 540 CLIENT AND 610 OS When using a v5r4m0 iSeries Navigator, and connecting to a v6r1 i5/OS system, the Download Certificate Authority does not work. APAR SE35273: CA400EXP-OPNAV ISERIES NAVIGATOR HANGS SEARCHING ALL FIXES Open iSeries Navigator, go to your system, then Configuration and Service, then Fixes Inventory, then All Fixes. If you use the CTL-F search or the Edit/Find... search, the operation will hang and go to "Not responding" RESOLUTION: This PTF describes the circumvention for this problem CIRCUMVENTION: Scroll down all the list, and then do the Search APAR SE35728: CA400EXP-OPNAV-OTHER-INCORROUT Selective prompt not working Prompting a command ignores ?? and ?* selective prompt options RESOLUTION: This PTF enables ?? and ?* selective command prompting DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE35138: CA400EXP-DTRANSFER CREATION OF STD FDF BY DEFAULT IS NEEDED The Data Transfer From application creates, by default, Enhanced FDF files and this is an inconvenience for customers who need Standard FDF files, as they have to manually specify the desired format every time a transfer request is created. A new CWBTFR.INI switch to customize the default FDF format is needed. RESOLUTION: This PTF fixes the reported problem. A new switch has been created to let users specify the FDF format to use. See the example below. [Client Access Data Transfer] ;UseStandardFDF makes the Data Transfer From GUI create, by ;default, standard FDF files, instead of Enhanced FDFs. UseStandardFDF= 1 APAR SE35769: CA400EXP-DTRANSFER IASP OF JOB DESCRIPTION IS NOT HONORED In the V5R4 version of iSeries Access for Windows, a new capability was added to allow the users to set the independent auxiliary storage pool (IASP) that will be used for data transfer. Prior to this client version, users were limited to the IASP that was defined in the job description specified in the user profile. As a result of adding this property, the data transfer client no longer honors the initial ASP group setting in the job description. The IASP must be set in the connection property, and it always defaults to *SYSBAS. It has been requested that the data transfer client continues to offer the option to use the IASP defined in the job description specified in a user profile. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE34570: CA400EXP-DTRANSFER ADD-IN FAILS TO UPLOAD DATE OR TIME CELLS The Excel Add-in fails to scan and upload date or time data to an iSeries and a variety of wrong behaviors may appear, from error messages such as CWBDB0036 and SQL0180 while the data is being uploaded, to date or time columns being scanned as NUMERIC data. This happens when the cells in which the data resides use a not-supported date or time format. RESOLUTION: This PTF fixes the reported problem. The list of supported Time and Date formats has been updated so now it is as follows: Time formats Date formats h:mm AM/PM m/d/yy h:mm:ss AM/PM d-mmm-yy h:mm d-mmm h:mm:ss mmm-yy [h]:mm:ss m/d/yy h:mm mm:ss.0 yyyy-mm-dd mm:ss mm/dd/yy hh.mm.ss 3/14/2001 [$-409]h:mm:ss AM/PM Wednesday, March 14, 2001 hh:mm:ss 3/14 1:01:01 AM 3/14/01 13:30 03/14/01 1:30 PM 14-Mar 13:30:55 14-Mar-01 1:30:55 PM 14-Mar-01 30:55.2 Mar-01 37:30:55 March-01 March 14, 2001 3/14/01 1:30 PM 3/14/01 13:30 M M-01 13/14/2001 14-Mar-2001 ODBC ---- APAR SE34540: CA400EXP-ODBC-UNPRED SQLSETCONNECTATTR CURRENTCATALOG FAILS Customer is using the mail merge function of Microsoft Word, and it is failing when attempting to set the SQL_ATTR_CURRENT_CATALOG of the connection with the SQLSetConnectAttrW API. They first call SQLTables to retrieve the catalog name, which is "ELECTRONIC". Then, they call SetConnectAttr The problem here is that they are passing in an indicator length in BYTES, not in CHARACTERS. Microsoft in this case is passing in a name that is only 10 characters long. It is failing because they specified the length of the buffer in bytes instead of characters. APAR SE35097: CA400EXP-ODBC-INCORROUT SQLGETDATA CAUSES FAULT ODBC application using SQLGetData to fetch a row until the end of the result set faults and ends without message. When the end of the data is reached the ODBC driver should return SQL_NO_DATA but instead appears to be returning a null which causes a fault. APAR SE35508: CA400EXP-ODBC-INCORROUT ACCESS VIOLATION IN CWBODBC.DLL A Windows application is using the iSeries Access for Windows ODBC driver to prepare and execute an SQL statement. The statement is over 600,000 characters long and contains some characters that do not have EBCDIC equivalents. When the conversion is done from unicode to EBCDIC, the untranslatable characters are converted to the standard code point for characters that do not exist in a character set. But the ODBC driver is incorrectly sending a statement to the host server with over 1,800,000 spaces appended to the end of the statement. That makes the statement over the 2 megabyte limitation for SQL statements. When the error is returned to the PC, the ODBC driver fails with a protection fault. OLE DB PROVIDER --------------- APAR SE34359: CA400EXP-OLEDB-INCORROUT SQL UPDATE STATEMENT FAILS USING IBMDASQL OLE DB PROVIDER. Executing a Microsoft SSIS package to conditionally update a table on an iSeries using the IBMDASQL OLE DB provider fails. Messages from Microsoft Visual Studio executing the package are; Error: 0xC0202009 at Syncronize Data To DB2, Update_Command [204]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E00. Error: 0xC0047022 at Syncronize Data To DB2, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Update_Command" (204) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: 0xC0047021 at Syncronize Data To DB2, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited. IBMDA400.trc file shows the next error message: CCommand::Execute() - invalid accessor handle .NET DATA PROVIDER ------------------ APAR SE34938: CA400EXP-IDB2DATA-F/QSQRUN1-T/QSQRUN1-MSGSQL0519 THE IBM.DATA.DB2.ISERIES .NET PROVIDER IS NOT CLOSING AN SQL CURSOR The IBM.Data.DB2.iSeries .Net provider is not closing an SQL cursor when an exception occurs in the .Net application. The next time a statement is Prepared/Described with the same cursor name, an SQL0519 message is returned by DB2 for iSeries. The .Net provider will be updated to flow the CloseCursor. APAR SE35276: CA400EXP-IDB2DATA-INCORROUT .NET EXCEPTION 'SYSTEM.INDEXOUTOFRANGEEXCEPTION' WHEN DATA CONTAINS A NULL An application using the iSeries Access for Windows .NET provider to access data on the iSeries encounters an exception when getting data. The application is using the DataAdapter.Fill method to get data from the iSeries but the data has an embedded null. This results in an exception in the application, 'System.IndexOutOfRangeException'. If the same is done using the iSeries Access OLEDB IBMDASQL provider no exception is encountered. RESOLUTION: The problem happens because the null character causes a translation error. This is the expected behavior. Because some customers would like to avoid this problem and instead receive a substitution character instead of the exception, a new property is added to the .NET provider that can be used to get the desired behavior. This new property should be set in the ConnectionString of the iDB2Connection object. Property: bool AllowUnsupportedChar Description: Gets a value which indicates whether unsupported characters will be allowed during translation, or whether their presence will cause an exception to be thrown during translation of data coming from the host. Default value: false (cause an exception) Example of how to get the new behavior: iDB2Connection cn = new iDB2Connection("DataSource=mysystem; AllowUnsupportedChar=true;"); APAR SE35399: CA400EXP-IDB2DATA-INCORROUT MEMORY LEAK WHEN CLOB DATA IS RETRIEVED The iSeries Access .Net managed data provider is being used to retrieve records that contain Character Large OBjects (CLOBs). Every time that a data set is retrieved and disposed of, the memory allocated to the application increases. Process Explorer was used to show that the memory is not being allocated by the .Net CLR, it seems to be in the .Net provider itself. Deeper analysis showed that the problem was actually in a lower level component and that this same failure could affect the OLEDB provider. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.3 (2008-08-29) and the equivalent of 5722JC1 PTF: SI32766 No fixes. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20081104 APAR SE34002: CA400EXP-TERMEMUL-INCORROUT IN USER-DEFINED SCREENS, THE "PC" DDS KEYWORD IS IGNORED WHEN THE DISPLAY REFRESHES. In a user defined screen, the "PC" keyword is ignored in the case of screen refresh and error handling. APAR SE34044: CA400EXP-TERMEMUL-UNPRED FOLLOWING INSTALLATION OF SI29771 FOR V5R4 OF 5722XE1, USERS RECEIVE PCSWS041 Following installation of SI29771 for V5R4 of 5722XE1, users receive PCSWS041. A removal of the SP resolves the issue. APAR SE34106: OSP-PAR-940XMISC AFTER SI30707 INSTALLATION V5R3 5722XE1, PCSWS041 RECEIVED ATTEMPTING TO RUN MACRO ON WINDOWS 2003 SERVER Following installation of SI30707 V5R3 5722XE1, users receive error message PCSWS041 "The system has insufficent resource or the script is not properly installed" when attempting to run a macro on Windows 2003 Server APAR SE34184: CA400EXP-TERMEMUL-UNPRED PCSWS.EXE FAILS WITH PCSWLIB.DLL FAULTING ON PC5250 LAUNCH When opening PC5250 sessions, PCSWS.EXE fails with pcswlib.dll faulting. APAR SE34231: CA400EXP-PRINTEMUL VIETNAMESE SUPPORT FOR PC5250 PRINTER EMULATION Support for Vietnamese characters is needed for PC5250 printer emulation support. It should be able to recognize input code page 1130, and it also needs to print combination characters while keeping columnar data lined up, similar to what has been done for Thai printing. APAR SE34629: CA400EXP-TERMEMUL-UNPRED PASTE INTO AN PC5250 SESSION WILL LET THE SESSION DIE WITHOUT A MESSAGE Client is using PC5250 session in a CITRIX or TSE / RemoteDesktop environment. Using the COPY / PASTE function in a PC5250 session will let the session die, this behavior will occur more often if the client is using the "SoundsOn=Y" parameter in the WS file. APAR SE35063: CA400EXP-TERMEMUL-THREADS-INCORROUT INSTALLING SI29771 CAUSES THE URL/HOTSPOTS TO FAIL TO LAUNCH THE WEBBROWSER IN PC5250. Windows 2003 Server, installing SI29771 causes the URL/Hotspots to fail to launch the web browser in PC5250. APAR SE35381: CA400EXP-TERMEMUL-THREADS-UNPRED INCORRECT CUSOR POSITION IN PC5250 AFTER INSTALLING SI31388. The cursor appears to move when user on a different PC performs actions on thier 5250 session. and/or cusor doesn't behaive as it should. 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. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI31388 Build date = July, 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE33006: CA400EXP-SERVICE-INCORROUT CWBSVGET DOESN'T WORK ON VISTA Cwbsvget.exe doesn't work on vista and Windows Server 2008 operating systems. APAR SE33905: CA400EXP-INCORROUT PC5250 CONFIGURATION FILES NOT FOUND Using iSeries Access for Windows V5R4 on a Windows Vista PC, the PC5250 emulator may fail finding specific application configuration files. For example, when printing a spooled file with a PC5250 printer emulation session, the printout is compressed and sometimes with blanks in between. This same spool file is printed correctly on Windows XP. RESOLUTION: With the added support of Windows Vista the default PC5250 file paths were changed as Microsoft suggested. That is why under Windows Vista may fail to find the PC5250 configuration files. After applying this fix, the files will be copied at boot time only if the configuration files exist on the old PC5250 paths. CIRCUMVENTION: Manually copy all the files located in the old common PC5250 files path: (iSeries Access for Windows install path)\emulator\private To the new common PC5250 files path: %ProgramData%\IBM\Client Access\Emulator\private Also copy all the files (if any) from the old per-user PC5250 files path: (My Documents folder)\IBM\Client Access\Emulator\private To the new per-user PC5250 files path: %APPDATA%\IBM\Client Access\Emulator\private These paths are PC5250 files path examples of an English Windows Vista PC, these paths are customizable and can also change depending the language or the Operating System. For more details about the PC5250 paths, see APAR II14380. APAR SE33999: CA400EXP-DTRANSFER-INCORROUT PACKED TO CHARACTER CONVERSION A problem was discovered with the iSeries Access data transfer Excel Add-In. Intermittently a packed decimal value will be converted incorrectly. It was found that a single digit number may be converted to a value 10 times that of the original value. For example, the original value is 3 but the value in the spreadsheet would be 30. Further analysis revealed this to be a problem in the code that converts packed decimal data to character data. This problem could therefore affect not only Data Transfer but also the OLE DB and .Net components. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE33562: CA400EXP-OPNAV-DBASE-INCORROUT UPDATE NOT SAVED INTO SERVER When the user updates a row through the Edit Contents dialog, the data may not be saved on the server and an error message may be displayed. This is possible if the user repeatedly updates the same row and commits the change without moving between rows and using the File -> Save menu option and if the column being updated is a numeric type. On the first update attempt the dialog shows the new value but the server does not reflect the change. Consecutive attempts will show an error message stating that the row the user attempted to change no longer exists in the table. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Move to another row to submit the change to the server. Then the user should use the File -> Save menu option to commit the transaction. APAR SE33564: CA400EXP-OPNAV-DBASE CREATING NEW SOURCE FUNCTION WITH UDT When trying to create a new sourced function, it may fail with an MSGSQL0683. This happens if the source function has user-defined type parameters and at least one of them is a type of character data. The New Sourced Function window displays the user-defined type with the CCSID value which will cause the error message to be displayed when the user tries to create the function. ADDITIONAL KEYWORDS: MSGSQL0683 RESOLUTION: The CCSID clause will not be filled in as the default if the parameter type is a user-defined type. CIRCUMVENTION: Clear all CCSID fields for those parameters whose the data type is a user-defined type. APAR SE33578: CA400EXP-OPNAV HANDLE NULL POINTER EXCEPTION IN PLAN CACHE When working with SQL Plan Cache Snapshots, there are some actions where an error message may display due to a null pointer exception not being handled. Such actions are: 1) Selecting the "Show Statements" option for an SQL Plan Cache Snapshot which its data file is empty. This will display an empty list and a null pointer exception in the trace. An "An unknown error has occurred." error dialog may be displayed before the Show Statements dialog displays. 2) Selecting the "SQL Statements with the Same Statement Text" option for a statement within a drill-down analysis report. The message, "An unknown error has occurred.", may display if the Join Field column value is missing for the record. A null pointer exception is logged in the trace. ADDITIONAL KEYWORDS: DBASE-INCORROUT APAR SE33581: CA400EXP-OPNAV INDEX ADVISED NOT GENERATED CORRECTLY FROM VE Trying to display the create index dialog for an advised index through the Visual Explain (VE) window may have problems. In Visual Explain, the user can display the list of advised indexes of the query being explained. The list may contain binary radix index and encoded vector index (EVI) index types. To create an advised index the user checks the checkbox for the one they want and then presses the Create button to display the create index dialog. The following problems may occur when the user tries to create advised indexes: 1) Displaying the create index dialog for the first time on an advised index other than the first one in the list, will display the correct index. But the next time the user presses the Create button, they will get the create index dialog for the first index in the list. 2) If the list has an EVI index and a binary radix advised, the create index dialog for the EVI may not display. ADDITIONAL KEYWORDS: DBASE-INCORROUT APAR SE34116: CA400EXP-OPNAV-DBASE-MSGSQL0440 DOING A VISUAL EXPLAIN When trying to do Visual Explain it may fail with a MSGSQL0440 error message. This is possible if the system the client is connected to is i5/OS V6R1 or later and if the iSeries Navigator version is V5R4 or prior. RESOLUTION: This PTF fixes the reported problems. CIRCUMVENTION: Delete the QQQDBVE2 stored procedure in the QIWS library. Then use Visual Explain from a V5R4 version of iSeries Navigator. It will generate the stored procedure with the correct parameters. APAR SE33583: CA400EXP-OPNAV NESTED BRACKETED COMMENTS IN RUN SQL SCRIPTS When using the Run SQL Scripts (RSS) window to execute a script, it may fail if it has nested comments. This is possible if each pair of bracketed comments do not have spaces between them and other bracketed comments. Example: /*/* some comment */*/ ADDITIONAL KEYWORDS: DBASE-INCORROUT RESOLUTION: This PTF fixes the reported problems. CIRCUMVENTION: Put at least one space between each set of 2 character comments ("/*" or "*/") so the comment looks like: /* /* some comment */ */ Then execute the query. APAR SE33586: CA400EXP ADD SERVER MODE CONNECTING JOB TO JOB SQL DETAILS The Current SQL for a Job and SQL Details for a Job dialogs will be extended to display the 'Server mode connecting job:' within the current job SQL information. This will be added to a V5R4 and V6R1 clients of iSeries Navigator and iSeries Navigator respectively when connected to a V5R4 version of i5/OS or greater. This is the definition of the new Server mode connecting job value. It will be the qualified job name of the job which established the SQL Server Mode connection. If the job name of the current job is not QSQSRVR, then blanks will be displayed for the Server mode connecting job if the client is a V5R4. In V6R1 the value will not be displayed if it is not filled in. If the job name is QSQSRVR, then the qualified job name of the connecting job will be displayed. This job name will be of the form 'xxxxxxxxxx/yyyyyyyyyy/zzzzzz', where x = job name, y = user name and z = job number. ADDITIONAL KEYWORDS: OPNAV-DBASE RESOLUTION: The Current SQL for a Job and SQL Details for a Job dialogs have been extended. But this extended functionality is available only if the following PTFs are installed on the system: PTF '5722SS1 V5R4M0 SI31631' PTF '5722SS1 V5R4M0 SI31632' PTF '5722SS1 V5R4M0 SI31633' PTF '5761SS1 V6R1M0 SI31640' PTF '5761SS1 V6R1M0 SI31641' PTF '5761SS1 V6R1M0 SI31644' APAR SE34117: CA400EXP ADD SERVER MODE CONNECTED THREAD TO JOB SQL DETAILS The Current SQL for a Job and SQL Details for a Job dialogs will be extended to display the 'Server mode connected thread:' within the current job SQL information. This will be added to a V5R4 and V6R1 clients of iSeries Navigator and iSeries Navigator respectively when connected to a V5R4 version of i5/OS or greater. The 'Server mode connected thread' corresponds to the application thread identifier which last used this SQL server mode connection. When using a V5R4 iSeries Navigator client, if the job name of the current job is not QSQSRVR, then blanks will be displayed for the Server mode connected thread. When a V6R1 iSeries Navigator client is used, the Server mode connected thread information will only appear if it contains non-blanks. The Server mode connected thread could refer to an application thread identifier which no longer exists. ADDITIONAL KEYWORDS: OPNAV-DBASE RESOLUTION: The Current SQL for a Job and SQL Details for a Job dialogs have been extended. But this extended functionality is available only if the following PTFs are installed on the system: PTF '5722SS1 V5R4M0 SI31830' PTF '5761SS1 V6R1M0 SI31850' APAR SE34118: CA400EXP-OPNAV CHANGE KRB5.CONF FILE AND KERBEROS BATCH FILE Additional Keywords:OTHER-INCORROUT Problems reported: Problem 1 : The newer ktpass.exe windows command used on Win2003 server doesn't default to DES-only encryption like the Win2K version of ktpass.exe command does. That is, service principals must have the "Use DES encryption for this account", option set, otherwise a RC4-HMAC encrypted service ticket is generated, which i5/OS will not be able to handle. The 'NASConfig_.bat' batch file created using the NAS wizard should add the '+DesOnly' flag on the calls to ktpass.exe for the Win2003 portion of the batch file. Problem 2 : The -ptype 'KRB5_NT_PRINCIPAL' option should be included on the Win2003 ktpass.exe calls, otherwise a warning message will be generated. Problem 3 : The trigraphs characters used on the krb5.conf kerberos configuration file should be optional, due to problems reported with some kerberos clients implementations. APAR SE34119: CA400EXP-OPNAV-USRGRP-THREADS-INCORROUT CUSTOMIZE VIEW, INCLUDE, BROWSE, DISPLAY ALL USERS, ONLY SHOWS A SUBSET OF When the customer uses the option Under Navigator, > Printer Output, Customize View, include, browse ? the display All Users, the display only shows a small subset of users. RESOLUTION: A change will be made to the code that displays a list of users so that all users will be shown. The change is the same change that was made in V6R1, that is, to call Java Toolbox support to provide the list. APAR SE29734: CA400EXP-OPNAV-INCORROUT USER NETWORKS OPTION FAILS When going into the properties of a user profile using iSeries Navigator and adding a second Network, Navigator shuts down. This may also be experienced when the user profile has associated two or more networks to its definition. RESOLUTION: The code has been modified to display the network servers associated with each user profile. CIRCUMVENTION: To display the networks associated to a user profile, you may use DSPSVRAUTE command on a 5250 session. APAR SE30970: CA400EXP-OPNAV CWBUNNAV.EXE IS ACTIVE AFTER CLOSE NETSERVER SHORTCUT When closing the window for a netserver desktop shortcut, error cwbunnav.exe occurs: the process is not released in window process. APAR SE32155: CA400EXP-OPNAV-INCORROUT EMPTY PANELS WITH HIGH RESOLUTION Some dialogs in iSeries Navigator are not displayed correctly. They do not show any information, instead they are empty, blank panels, with the normal blue title bar. The dialogs with this problems are usually Properties dialogs. This problem has been found using Windows XP pro SP2 with V5R4 iSeries Access for Windows and the Intel 82845G Graphics Controller, the Intel 82865G Graphics Controller or TFT WideScreen monitors with the display resolution set to 1680x1050. APAR SE32165: CA400EXP-OPNAV ERRORS WHEN APPLICATION ADMINISTRATION IS NOT INSTALLED The following Application Administration errors may occur: 1) A Runtime error with program CWBUNPLP is received when trying to perform any function with iSeries Access for Windows. Message: Runtime Error! Program: n:\Windows\System32\cwbunplp.exe n= location of installed application 2) From the Administration System tab in the iSeries Access for Windows Properties window, when user tries to run "Scan Settings Now" and a message error is to be displayed, user will get the following exception: An exception occurred while trying to run "shell32.dll,Control_RunDLL "C:\WINDOWS\System32\ca400cpl.cpl"," RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Use the selective setup to add the iSeries Navigator - Application Administration component. APAR SE32025: CA400EXP-OPNAV ADVANCED JOB SCHEDULER CONTAINER IS EMPTY When initially opening the Advanced Job Scheduler plugin, there are no options listed. iSeries Navigator has to be closed and re-opened, then the plug-in options are displayed. APAR SE32235: CA400EXP-OPNAV-INCORROUT BAD INVENTORY EXPORT STORAGE VALUE Management Central Export Inventory feature writes incorrect value for available storage and storage used. Problem may be observable when values being handled are close and above 2.1 TB. RESOLUTION: Code has been modified to handle storage reports correctly. APAR SE32527: CA400EXP-OPNAV-DBASE-MSGSQL0551 EDIT CONTENTS OF A TABLE When trying to edit a table using the 'Edit Contents' menu option of the table's context menu, a MSGSQL0551 error message may appear. The error states that the user is not authorized to the object QADBIFLD in QSYS type *FILE. This happens if the user trying to do the action does not have enough authority to the QADBIFLD object. APAR SE32734: CA400EXP-OPNAV ISERIES NAVIGATOR PERFORMANCE ADVISOR STOPS When the firewall rules are configured to deny access to the iSeries host, and the iSeries Navigator Advisor is used to check the network items of the host, the iSeries Navigator Advisor - Performance window may stop at 0%. At this point the Status of the Performance window is Analyzing network: Response Time. APAR SE32748: CA400EXP-OPNAV-INCORROUT SELECTING PERMISSIONS FOR AN OBJECT Additional Keywords: -DBASE Working with database objects a connection error was displayed. Currently Secure Socket Layer is enabled and the not secure ports are blocked by a firewall. APAR SE32841: CA400EXP-OPNAV CWBUNNAV.EXE FAILS REORDERING SPOOLED FILES Using a 2.99 GHz processor, under iSeries Navigator, expand Basic Operations / Printers, and selecting a printer, and then moving a spooled file down the list can cause a cwbunnav.exe error. It does not happen every time. You can circumvent by creating a shortcut to the printer view and working with the spooled files in the shortcut. RESOLUTION: This APAR documents the reported problem and provides a circunvention CIRCUMVENTION: Create a shortcut for the printer and work with the spooled files in the shortcut window. APAR SE33434: CA400EXP-OPNAV-DBASE-INCORROUT PARTITIONED TABLE DEFINITION The definition dialog for a table may not appear for partitioned tables. When selecting the "Definition" context menu option for a partitioned table, the Definition dialog may not display and no error is signaled to the user. This happens with partitioned tables that have many partitions. APAR SE32073: CA400EXP-OPNAV SCRIPT NOT SAVED WITH CLOSE GROUP ACTION Using the 'Close group' action to close the windows of iSeries Navigator may result in not saving a script being modified in Run SQL Scripts window. If the closing action is requested and the user has modified a script in the Run SQL Scripts window, but not yet saved it, the iSeries Navigator closing process should be stopped to ask the user if they want to save the changes. Instead, the application closes and the changes to the script(s) are lost. ADDITIONAL KEYWORDS: DBASE RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Do not use the 'Close Group' option. Instead use the close action from the main window of the iSeries Navigator to close all windows. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE31895: CA400EXP-DTRANSFER FILE TYPE CHANGED AFTER MSGCWBTF0002 An iSeries Access for Windows data transfer request is created to transfer a file to the PC. The output type is set to file and the file name is the name and location of a file that already exist. In the transfer details, the file type is set to any file type and the option to 'Create new file' is selected. When the transfer runs, an error CWBTF0002 will result, prompting the user to select OK to overwrite the existing PC file or press Cancel to stop the transfer request. If the OK is pressed on the message CWBTF0002, the transference succeeds and the file is overwritten correctly but, if the Cancel button is pressed and a different file name is provided, the file is created but no data is transfered. APAR SE31984: CA400EXP-DTRANSFER-LOOP RXFERPCB GOES INTO AN ENDLESS LOOP When RXFERPCB uploads an Excel Spreadsheet (.BIFF file), it should not try to upload multiple worksheets. Currently, it tries to do so and, when the second worksheet contains empty records, the upload algorithm goes into an endless loop, transferring blank records until the job is manually ended or the iSeries table has reached it's maximum size. APAR SE32445: CA400EXP-DTRANSFER-MSGCWBDB0052 INCORRECT ROW NUMBER Data transfer is reporting an error CWBDB0052 in V5R3 or V5R4, or CWBTF0105 starting in V6R1, due to data in a file that cannot be converted from the host CCSID to the PC code page. The error displays the column and row numbers of the result set with the error, however, the indicated row number is wrong. APAR SE32745: CA400EXP-DTRANSFER CUSTOMIZED DEFAULT DATE FORMAT IS NEEDED The Data Transfer application does not allow a user to specify a customized default date format but it selects the date format based on the PC's Windows regional settings. This behavior represents a problem for customers that do not want to use the automatically selected date format, especially for those who create many transfer requests, as they have to go to the Format Settings panel and change the date format manually every time a new transfer request is created. APAR SE33249: CA400EXP-DTRANSFER-INCORROUT IASP PARAMETER IS IGNORED The Data Transfer application ignores the IASP/Database value stored in transfer requests; the default value (*SYSBAS) is used instead. APAR SE33421: CA400EXP-DTRANSFER UPLOADING XML FILES CAUSES VARIOUS ERRORS Several problems with the iSeries Access for Windows Data Transfer to iSeries GUI are addressed in this APAR, all of them related to the "MS XML Excel spreadsheet" file type: 1) The XML scanner in the iSeries Access for Windows Create iSeries Database file GUI fails to recognize XML spreadsheets that contain more than one worksheet correctly. As a result, incorrect table layouts are generated which make Data Transfer fail to parse the spreadsheets and cause the following error message to be displayed: CWBTF0100 Microsoft XML Parser encountered an error at line x, column x, with return code - 2147467259. Message text, if available, is Unspecified error'. 2) An access violation may occur when the XML scanner in the iSeries Access for Windows Create iSeries Database file GUI scans a large XML file. 3) An endless loop can occur when extra columns are added to an XML file after it has been used to create a table on the iSeries and an FDF file has already been created based on the original layout. The expected behavior in this situation is to display a warning message stating that extra data will not be sent. Appropriate data should be transferred. 4.- A hang may occur in the middle of an upload operation of an XML file, specially with big files. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE33886: CA400EXP-DTRANSFER CWBTF0073 ON UPLOAD WITH EXCEL ADD-IN The Excel Add-in displays the error message CWBTF0073 (Data type mismatch) when an attempt is made to upload data to an existing table that contains fields of type DATE or TIME; this problem only happens when there are empty cells on the spreadsheet that correspond to the fields of type DATE or TIME and the FDF is created through the options "Replace member" or "Append to existing member". APAR SE31662: CA400EXP-DTRANSFER ADD-IN FAILS WITH TIME FORMATTED CELLS There is a problem when transferring data from a Microsoft Excel spreadsheet using the iSeries Access data transfer Excel Add-in. When there are cells that are formatted as a Time value, the scanning tool defines these as numeric columns instead of Time. The only time format that seems to work correctly is a custom time format. Since there is no way to change the type from numeric to Time in the database creation wizard, the wizard cannot be used to create a proper table to put this data in. APAR SE32745: CA400EXP-DTRANSFER CUSTOMIZED DEFAULT DATE FORMAT IS NEEDED The Data Transfer application does not allow to specify a customized default date format but it selects the date format based on the PC's Windows regional settings. This behavior represents a problem for customers that do not want to use the automatically selected date format, especially for those who create many transfer requests, as they have to go to the Format Settings panel and change the date format manually every time a new transfer request is created. APAR SE33037: CA400EXP-DTRANSFER ADD-IN DOES NOT SUPPORT EXCEL 2007 LIMITS iSeries Access Data Transfer Add-In supports Excel 2003 limits (65535 rows by 256 columns), not being able to handle Excel 2007 limits (1,048,576 rows by 16,384 columns). APAR SE33119: CA400EXP-DTRANSFER-INCORROUT FDF DEFAULT PATH IS NOT DEFINED When using the Data Transfer Excel Add-in to upload data and no path is specified, the FDF file is created in C:\Documents and Settings\UserID\My Documents directory. The correct default behaviour, if no directory path is specified, is for the FDF file to be created in the C:\Documents and Settings\UserID\My Documents\IBM\Client Access directory. APAR SE33249 (PTR SE33249): CA400EXP-DTRANSFER-INCORROUT IASP PARAMETER IS IGNORED The Data Transfer application ignores the IASP/Database value stored in transfer requests; the default value (*SYSBAS) is used instead. ODBC ---- APAR SE33580: CA400EXP-DATABASE-MSGSQL0401 using translate hex connection property SQL0401 message error occurs when using extended dynamic support under a connection with a different Hex Parser Option than the one used when the SQL package was originally created. For example, if an SQL package created with Hex Parser Option set to 0 (Default) is used under a connection with Hex Parser Option set to 1, SQL0401 message occurs. RESOLUTION: This PTF fixes the reported problem CIRCUMVENTION: - Don't use extended dynamic support - For ODBC and JDBC, the user can create one package with the option set to Default in one library (eg, HEXPKGLIB), and then set the option ON and create the package to a different library (eg, BINPKGLIB). - For OLE DB the connection string/property "SQL Library Package Name" must be used to specify the Package location library JDBC Additional information about "translate hex" can be found in JDBC driver connection properties http://publib.boulder.ibm.com/infocenter/iseries/v5r4/ index.jsp?topic=/rzaha/conprop.htm ODBC Additional information about HEXPARSEROPT can be found in Connection string keywords - Translation properties http://publib.boulder.ibm.com/infocenter/iseries/v5r4/ index.jsp?topic=/rzaik/rzaikconnstrkeywordstranprop.htm OLE DB Additional information about "SQL Library Package Name" and "Hex Parser Option" can be found in the programmer's toolkit. Programmer's toolkit---->Database ---->ADO/OLE DB ---->"iSeries Access for Windows OLE DB Technical Reference - SQL"----> Help Topics---->Contents tab---->System i OLEDB provider functions----> Special Properties APAR SE32285: OSP-INCORROUT MSGSQL0104 LINUX ODBC DRIVER wrong length stmt Linux PHP script using iSeries Access for Linux ODBC driver encounters an msgSQL0104 when the SQL statement contains a character outside the invariant character set (a-z, 0-9). Languages other than English commonly use characters outside the invariant set, i.e. accented letters, and are more likley to encounter this issue. APAR SE33393: CA400EXP-ODBC-INCORROUT GARBAGE DATA APPENDED TO DATA RETURNED FOR RESULT SET. Unicode configured PHP script run under Microsoft Windows using the iSeries Access for Windows ODBC driver returns DB2 data from the iSeries but the displayed output appears to have appended garbage data to the result set. The iSeries Access for Windows ODBC driver was configured with the CCSID keyword to force the client code page to be used to 1208 UTF-8. Detail trace or CWBCOTRC will reveal there is a CWB0111 truncation warning message but doesn't account for the extra data appended to the result set. OLE DB PROVIDER --------------- APAR SE31868: CA400EXP-OLEDB-INCORROUT ADSCHEMACOLUMNS FOR OPENSCHEMA METHOD RETURNS NO RESULTS WHEN USING CLIENT SIDE CURSOR. Microsoft ADO OpenSchema method using adSchemaColumns as the QueryType returns empty results instead of a list of columns when using iSeries Access for Windows OLE DB provider. This issue only occurs when using a client side cursor, adUseClient. Using a server side cursor, adUseServer, returns the correct results. APAR SE32880: CA400EXP-OLEDB-INCORROUT QUERY OPTIONS LIBRARY NOT SET FROM SQL SERVER The iSeries Access for Windows OLE DB provider is not setting the query options library (the library whose QAQQINI file will be used) when the provider string is set to "QUERY OPTIONS FILE LIBRARY=MYLIB" in SQL Server. If a trace is also set on through the provider string, the query options library gets set properly though. For example the following provider string will work as it should, "QUERY OPTIONS FILE LIBRARY=MYLIB;TRACE=7" APAR SE33171: CA400EXP-OLEDB-F/QZDASQL-T/QZDASQL-MSGPWS0005 ERROR OCCURS ON DELETE OR UPDATE IN SQL SERVER LINKED SERVER. MSGPWS0005 f/QZDASQL t/QZDASQL "Error occurred in the i5/OS database server code" is generated on a new linked server connection from SQL Server to the i5 database. The error occurs trying to run an UPDATE or DELETE statement using iSeries Access for Windows V5R4M0 with Service Pack SI25949 or SI29771 installed. No other errors are generated to the JOBLOG. TRCCNN shows QSQDELET followed by the error: 3807 - SQLCA SQLCAID: SQLCA SQLCABC: 136 SQLCODE: 0 SQLERRML: 32 SQLERRMC: ..PPBACPPGUY..PRKTESTF ........ SQLERRP: QSQDELET SQLERRD: {0,0,11,0,0,-134613515} SQLWARN: {W, , , ,W, , , , , , } SQLSTATE: 01504 A zz trace indicate that data is deleted from a table, and then an attempt is made to perform a fetch on a cursor that isn't open. .NET DATA PROVIDER ------------------ APAR SE32989: CA400EXP-IDB2DATA Using CommandBuilder with a closed connection fails With the iSeries Access for Windows V5R4M0 .Net provider, using the CommandBuilder to perform updates on a table with a primary key causes the error: "The iDB2DataAdapter's SelectCommand did not return any column information." ...even though a comm trace shows that the iSeries host did indeed return the information about the lone unique key on the table. The problem is caused due to the iDB2DataAdapter being attached to a previously closed connection. RESOLUTION: This ptf fixes the reported problem. CIRCUMVENTION: Open the connection before using the CommandBuilder. APAR SE33517: CA400EXP-IDB2DATA-INCORROUT EXCEPTION WITH EMPTY STRING PARAMETERS A program using the IBM DB2 for i5/OS .Net provider encounters an exception when a string parameter is assigned an empty string as a value. The exception code is 0xC000000D and is reported in module MSVCR80.DLL or equivalent runtime library. The problem can be recreated using the following C# code: static void Main(string[] args) { String strParm = ""; iDB2Connection cnn = new iDB2Connection("DataSource=MYSYSTEM"); cnn.Open(); iDB2Command cmd = cnn.CreateCommand(); cmd.CommandText = "call MyLib.MyProc(@myCharParm)"; cmd.DeriveParameters(); cmd.Parameters["@myCharParm"].Value = strParm; iDB2DataReader dr = cmd.ExecuteReader(); } APAR SE32401: CA400EXP-IDB2DATA-INCORROUT CONNECTION TIMEOUT NOT WORKING The .Net data provider supports a connection timeout property that specifies the amount of time that the provider will wait for a connection to complete before it returns a connection timeout back to the application. The provider only seems to set the timeout value for the connection that is made to the database host server. In many cases, there are other connections that the core communications functions are in control of, which must be made before this database server connection is attempted. The .Net timeout value should apply to all of the connections that are made. As part of the investigation into this problem, an important discovery was made that bears mentioning here. If the system is configured (in iSeries Navigator's connection properties) to look up the address of the system, then a DNS name resolution will be performed for the connections and that sort of connection does not use sockets so the timeout cannot be applied to the DNS address lookup. If that fails, the length of that timeout is beyond the control of an application. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE32359: CA400EXP-AFPVIEWER OpNav View spooled file fails on Vista Right click a spooled file from iSeries Navigator and attempt to open it. This action fails when attempted on Windows Vista. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.2 (2008-04-30) and the equivalent of 5722JC1 PTF: SI31547 No fixes. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20080618 APAR SE34115: CA400EXP-TERMEMUL-INCORROUT CORRUPTED PRINTER DIALOG STRINGS The PC5250 New Printer Dialog screen shows some corrupted Arabic characters. APAR SE29418: CA400EXP-TERMEMUL-WAIT MACROS CREATED IN AN EARLIER RELEASE RUN SLOWER AFTER VERSION UPGRADE TO V5R4M0 Macros that were created at V5R3 of iSeries Access for Windows run significantly slower after upgrade to V5R4. Each step of the macro appears to wait for a response from the iSeries before the next step is processed. APAR SE29943: CA400EXP 5250 SESSION HANG WHEN THE MIXED DATA WAS PASTED. When the data with which the SBCS blank is contained between DBCS is pasted to G type field (Graphic field), the session loses a response. This problem occurs only in the DBCS environment. Ex, 'A B' (A and B is DBCS. It is a SBCS blank between them.) If the data containing SBCS and DBCS is pasted into G field, a session will be hung. APAR SE31152: CA400EXP-TERMEMUL-INCORROUT PC5250 DOES NOT SUPPORT GREEK ALPHABETIC CHARACTERS IN AN ALPHABETIC ONLY FIELD. iSeries Access for Windows PC5250 display emulation flags a status bar message 'Field requires alphabetic characters' when Greek alphabetic characters are typed into an alphabetic only input field. The PC5250 session is correctly setup for a Greek environment. APAR SE31610: CA400EXP-PRINTEMUL PRINTER EMULATION ENDS ABNORMALLY WITH PDT CONTAINING START_JOB WITH MORE THAN 255 BYTES A pdt table is created from custom source. The source contains a START_JOB tag with more than 255 bytes of data. When put in use, the printer emulation session ends abnormally. APAR SE32283: CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE AT G TYPE FIELD PCOMM APAR IC55304 Incorrout Copy and Paste function on host codepage 1399/1390 session. When user tries to copy G type fields for Input/Output type, copied string is invalid. The problem issues G type fields has all blanks. The results is different between host codepage 930/939 and 1390/1399. It will not DBCS blanks. Already reported under PCOMM APAR IC55304. APAR SE32400: CA400EXP-TERMEMUL-INCORROUT PC5250 KEYBOARD ERROR WILL NOT RESET PC5250 keyboard error will not Reset. APAR SE32408 (PTR SE32408): OSP-PAR-940XCOM CURSOR POSITIONED INCORRECTLY AFTER UPGRADE TO R540 ACCESS FOR WINDOWS After upgrading to R540 Si27741 in Access for Windows, the cursor is positioned incorrectly to the first input field in screen, instead of the last field prior to entering detailed screen. APAR SE32924: CA400EXP-TERMEMUL-UNPRED PCSWS.EXE FAILS DURING PLAYING MACRO ON 5250 SESSION WITH VISTA. CODE PAGES 1399 OR 1390. PCSWS.EXE fails during playing macro. It issues when 5250 display session has host codepage 1399/1390 . Steps to recreate: . 1. Configure 5250 session with host codepage 1399 2. Start recording macro 3. Record signon operation or something_____________________} 4. Stop recording . 5. Try to play macro APAR SE33046: CA400EXP-TERMEMUL-INCORROUT PASTING DBCS/SBCS MIXED DATA TO O-TYPE FIELD INCORROUT In case that FieldWrap is set to 'N' on a PC5250 terminal session, only DBCS data is pasted when DBCS/SBCS mixed data is pasted to an O-type field. This happens after a fix for SE29943 is applied. APAR SE33077: CA400EXP-TERMEMUL-INCORROUT * AT THE END OF A URL IS IGNORED When using hotspots the customer uses an * at the end of a url. This is getting stripped off. APAR SE33291 (PTR SE33291): CA400EXP-TERMEMUL-MSGPCSERR100 PC5250 ABENDS WITH PCSERR100 ERROR PC5250 abends with PCSERR100 error when used in conjunction with screen scraping software. APAR SE33455: CA400EXP-TERMEMUL-INCORROUT DUP KEY BEHAVES DIFFERENTLY ON WINDOWS XP THAN IT DOES WITH WINDOWS 2000. With the keyboards mapped identically, the DUP key behaves differently on Windows XP than it does with Windows 2000. The DUP key seems to be blank when used to Type J field (DBCS-Only data) by WIndowsXP. It does not occur in Windows2000. APAR SE33459: CA400EXP-PRINTEMUL INCORRECT OUTPUT WITH ESC_P.PDT A spooled file has these attributes: 51 lines per page 6 lines per inch for a length of 8.5 inches. A printer session is created that uses the esc_p.pdt table. The printer does not eject the proper distance. Instead, it appears to send down a command to use a 8 inch page length. APAR SE33610: CA400EXP-PRINTEMUL PRINTER EMULATION FAILURE WITH NO PDT AND SI30707 Customer upgraded their service pack from SI10817 to SI30707. After this their printer emulation sessions started failing with Pcsws.exe application error: AppName:pcsws.exe AppVer:5070.60.8024.546 Modname:pcspd.dll ModVer:5070.60.8024.546 Offset:000458bb If they enable pdt support on the session, the failure will not occur. APAR SE33691: CA400EXP-TERMEMUL-INCORROUT PC5250 EMULATOR SCREEN HANGS When a large number of embedded 5250 datastream frames are received in one TCP/IP packet it can hang the emulator. APAR SE33740: CA400EXP-TERMEMUL-UNPRED KONICA MINOLTA PRINTER SUPPORT Add PDT support for Konica Minolta PCL XL printers for Japanese users. SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE33913: CA400EXP-SSL-UNPRED SETTING TLS CIPHER ENV VAR FAILS When selecting a customer preferred TLS cipher in PC5250, the cipher that is actually used is not the one selected. RESOLUTION: This PTF fixes the reported problem. The environment variable CWBCO_TLS_CIPHER_SPECS has been added to override the TLS ciphers used by the Client Access connections. 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. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI29771 Build date = January, 2008 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE29369 : CA400EXP-NLS-INCORROUT PRE-FORMATTED TEXT BIDI TRANSFORMS Bidirectional scripts transformations can fail when transforming specifically formatted text such as XML or HTML data, and cause incorrect output. RESOLUTION: Via the iSeries Properties one can enable bidirectional script transformations. When this box is checked, all data in any BIDI Coded Character Set ID (CCSID) will be right-to-left transformed for proper viewing. Sometimes data in a BIDI CCSID is already properly formatted, and applying the right-to-left transformation breaks this. An example would be a database record with one field containing names, which should be right-to-left transformed, and another field containing XML or HTML data, which should not be transformed. Now we provide a way to enable/disable BIDI transformations per CCSID value via a registry key. This registry key overrides the "Enable Bidirectional script transformations" checkbox. This allows BIDI transformations to be enabled or disabled for specific CCSIDs while continuing to transform all other BIDI CCSIDs as usual. If the "BIDI Transform Override" is set in the registry with the specific CCSID and BidiTransform = 0, then data in that CCSID will not be transformed. But If the "BIDI Transform Override" is set in the registry with the specific CCSID and BidiTransform = 1, then data in that CCSID will now be transformed. The override will be only used when CCSID conversions are done and when the "BIDI Transform Override" registry key has been set. To set the registry key follow these steps: 1. Create a file named BIDI_Transform_Override.reg 2. Copy the next 4 lines (including the blank line) into the new file: Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\IBM\Client Access Express\CurrentVersion\NLS] "BIDI Transform Override"="62235,0" 3. Remove the "62235,0" text and replace it with the right values: The format is: "CCSID,0|1[,CCSID,0|1[, ...]] " where: CCSID = the BIDI CCSID value (for example, 62235) 0 for no transform and 1for transform 4. Save the changes 5. Double click the BIDI_Transform_Override.reg file to enable the override in the registry. 6. Restart applications for this to take effect. Note that this registry key is in the user-specific part of the registry, so it will affect only the current user. Each user who wants to use the BIDI Transform override must create this registry value while logged on to Windows. CIRCUMVENTION: Re-tag the data as non-bidi in the database. APAR SE29543 : CA400EXP-NLS INCORROUT CONVERSION FROM CCSID 935 TO UNICODE Some DBCS characters of CCSID 935 Simplified Chinese can not be converted correctly to Unicode. Example of character that was unable to convert: 0xB9F9 RESOLUTION: When using the cwbnltbl tool to download the .tbl files that support the conversion from 935 to Unicode we use a hardcode range of characters and this range was increased to support new characters that were recently added on the host. To support the conversion of these Chinese characters to Unicode, you will need to download the .tbl files from the host. The .tbl files that need to be updated are: - 03a734b0.tbl // 935 -> 13488 - 34b003a7.tbl // 935 -> 13488 The tables are normally stored in the following path on the client: %ALLUSERSPROFILE%\Documents\IBM\Client Access but may also exist elsewhere. If they are not there, search your PC to find them. When you find them, open a command prompt to their location. If you do not find them, search for other files whose names are similar and have a .tbl extension, and open a command prompt there. If these two tables already exist, rename them from the command prompt as follows: ren 03a734b0.tbl 03a734b0.tbl.bak ren 34b003a7.tbl 34b003a7.tbl.bak Download new versions of these 2 tables by typing the following at the command prompt: cwbnltbl 935 13488 cwbnltbl 13488 935 Verify that the two new tables were created on the client. dir 03a734b0.tbl dir 34b003a7.tbl Restart all applications using iSeries Access to have the new tables take effect. APAR SE29861 : CA400EXP-DATEBASE-INCORROUT JAPANESE WINDOWS VISTA, RUN SQL SCRIPTS WINDOW FAILS TO OPEN. Run SQL scripts fail to open when using Japanese Windows Vista with error message "cwbunnav.exe is stopped". RESOLUTION: A problem was found in the version of the Java Runtime Environment (JRE 1.4.2) that is shipped with iSeries Navigator. An update of the JRE to 1.4.2 SR8 is being provided to solve this problem. If this PTF is applied to the iSeries, and a service pack install is run from that iSeries image, the service pack install will upgrade the JRE level, if needed. Subsequent service packs will not reinstall the JRE if the latest level already exists on the PC. A new install, reinstall, or upgrade from an install image with this PTF applied, will install the new JRE 1.4.2 SR8. APAR SE29893 : OSP-OTHER-UNPRED ISERIES NAVIGATOR DOES NOT DROP THE 'Q' WHEN THE REST OF THE PASSWORD IS ALPHA NUMERIC. iSeries Navigator only drops the 'Q' when the rest of the password is all numeric characters. But green screen drops the 'Q' when only the first character of the password is numeric. It doesn't matter if the rest of the password is alpha or numeric. APAR SE30681 : CA400EXP-NLS-INCORROUT CONVERSION FROM CCSID 5035 TO 932 Incorrect mapping occurred when converting from CCSID 5035 to CCSID 932. RESOLUTION: The correct CCSID mapping has been restored. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE30805 : CA400EXP-INRMTCMD-INCORROUT EXECUTING GRAPHICAL APPLICATIONS Sometimes when using the Incoming Remote Commands function and interact with the desktop option is enabled, it fails with a "ghost window" that is, only the window frame is displayed. iSeries NAVIGATOR ----------------- APAR SE29333 : CA400EXP-OPNAV GRAPH HISTORY SHOWS SPIKES FOR DISK METRIC Graph History shows several spikes when try to display data for Disk Pool Metrics. RESOLUTION: The code has been changed to avoid spikes on graph history. APAR SE29404 : CA400EXP-OPNAV-DBASE INCREASE LIMIT TO DISPLAY LOCKED ROWS iSeries Navigator has a function where you can display the locked rows of a table or member of a table by selecting the Locked Rows menu option on a table object. The number of locked rows displayed is limited to 319 rows. This is different from the DSPRCDLCK CL command, which can display unlimited number of locked rows of a table or member. RESOLUTION: The limit on the number of rows that iSeries Navigator can display will be raised to 10,000 rows. APAR SE31183 : CA400EXP PROPERTIES ACTION NOT SHOWN FOR SYSBASE AND IASP Using iSeries Navigator, in the Databases folder, the Properties action is not shown for Sysbase or Independent Auxiliary Storage Pool (IASP) databases when connected to an V5R4 or later versions of i5/OS. This option should be available from the database's context menu. It is displayed when connected against a V5R3 version of i5/OS. APAR SE29686 : CA400EXP-OPNAV-DBASE EDIT OF A TABLE WITH LOBS NOT SUPPORTED Using iSeries Navigator to edit the contents of a table with a large object (LOB) column may end with an exception. This exception is possible if the user selects the 'Edit Contents' option from the table's context menu and the table has at least one Large Object (LOB) data-type column with 227,606,512 or more bytes in length. The dialog will not display and iSeries Navigator ends with an error message. RESOLUTION: The 'Edit Contents' actions is not supported on tables that have at least one LOB column. An information message will appear stating this restriction. APAR SE29687 : CA400EXP-OPNAV-DBASE-MSGCWBNL0107 EDIT TABLE CONTENTS When trying to edit the contents of a table, iSeries Navigator may show several MSGCWBNL0107 error messages before the dialog is displayed. This may happen with database monitor data files or any table that has X'00's (nulls) as data. Each column in each row that exists in the table that has X'00's will display an error dialog and therefore the user will need to click the OK button for each dialog. RESOLUTION: When the table has at least one character field with X'00's, only one error message dialog will be displayed and the Edit Contents dialog will not be displayed. CIRCUMVENTION: 1) Edit the ODBC Data Source corresponding to the system the error is occuring on. It should be a QDSN_xxxx entry, where the xxxx is the system name configured in iSeries Navigator. On the Conversions tab, press the Advanced button and check the 'Allow unsupported character' check box. Then edit the table. ODBC will return embedded nulls in the column data and not display error messages. 2) Use the View Contents option to see the contents for read-only. APAR SE31274 : CA400EXP-OPNAV CHANGE KRB5.CONF FILE AND KERBEROS BATCH FILE Problems reported: Problem 1 : The newer ktpass.exe windows command used on Win2003 server doesn't default to DES-only encryption like the Win2K version of ktpass.exe command does. That is, service principals better have the "Use DES encryption for this account", option set, otherwise a RC4-HMAC encrypted service ticket is generated, which i5/OS will not be able to handle. The 'NASConfig_.bat' batch file created using the NAS wizard should add the '+DesOnly' flag on the calls to ktpass.exe for the Win2003 portion of the batch file. Problem 2 : The -ptype 'KRB5_NT_PRINCIPAL' option should be included on the Win2003 ktpass.exe calls, otherwise a warning message will be generated. Problem 3 : The trigraphs characters used on the krb5.conf kerberos configuration file should be optional, due to problems reported with some kerberos clients implementations. APAR SE31184 : CA400EXP-OPNAV-INCORROUT CLUSTER GUI SUPPORT FOR i5OS V6R1 iSeries Navigator Cluster component incompatibility problems with V6R1 systems. APAR SE31185 : CA400EXP Eclipse Help is not displayed on Windows Vista Help is not displayed on Windows Vista 32 bits and Windows Vista 64 bits. APAR SE31186 : CA400EXP-MESSAGES-MSGCPF9802 in System Operator messages In iSeries Navigator, when accessing the View System Operator messages task, if the User does not have *READ authority to the QSYSOPR user profile, and via the Include criteria is subsetting the list of possible message types such that the list will have 0 messages in the list, this will result in a CPF9802. RESOLUTION: In the case where we know the message queue and library are for QSYSOPR, we will not do the authority check as it is not needed, and will simply pass in the QSYS/QSYSOPR message queue and library name. This will avoid the CPF9802. CIRCUMVENTION: 1) Grant the caller *READ authority to the QSYSOPR user profile 2) Avoid via selections in the Include criteria for Message type, creating a list that has the potential for 0 elements (such as only selecting the checkbox for "Inquiry messages that need a reply"). APAR SE31187 : CA400EXP-OPNAV-INCORROUT Empty dropdown lists for Country/Region and Language fields For certain DBCS countries, the drop downs lists for Country/Region and Languages are empty. These fields are found on the Job Properties International page as well as on the System Value International Language/Characters properties page. APAR SE31188 : CA400EXP-OPNAV-DBASE-INCORROUT LOCKED ROWS LIST EMPTY When using iSeries Navigator, and the user selects the 'Locked Rows' option of the tables's context menu, the Locked Rows dialog does not display rows, no matter if there really are locked rows for the selected table. This is possible for a Table or a Materialized Query Table (MQT). APAR SE31189 : CA400EXP CONTROL DOES NOT RETURN AFTER ADVISOR THROUGH VE Using iSeries Navigator, control may not return back to the iSeries Navigator application after navigating through Visual Explain (VE) and Advisor. This may happen when connected to a V5R3M0 i5/OS system and doing the following: 1. Go to the SQL Performance Monitor folder 2. In the right panel, select a monitor. Select the 'Show Statements...' menu option for the selected monitor 3. Select a statement and press the Run Visual Explain button 4. Once the Visual Explain window is displayed, choose the Advisor option in the Actions menu 5. Check at least one of the Index Advised and press the Create button 6. Close all windows displayed so the only remaining window is the main window for iSeries Navigator 7. Now the control does not return back and the user is not allowed to work with the iSeries Navigator. RESOLUTION: The control will now be returned to the iSeries Navigator application, and the Show Statements dialog will be displayed as a modeless dialog. APAR SE31190 : CA400EXP-OPNAV-DBASE VISUAL EXPLAIN PREFERENCES LOST When using the Visual Explain window, the window preferences, including the window size, are not saved. Before closing the window, if the user changes some attributes such as window size, graphic detail, attributes detail, show messages, and arrow labels, the application does not remember the preferences of these values the next time the Visual Explain window is displayed. APAR SE31191 : CA400EXP-OPNAV-DBASE DISTINCT VALUES CREATING ADVISED INDEX When trying to create an index from the index advisor dialog in Visual Explain, the New Index dialog may display '0' as the default value for the 'Number of distinct values' field. However, for those advised indexes whose type is binary radix, the dialog should display 'Not specified' as default value for the 'Number of distinct values' field. APAR SE31192 : CA400EXP-OPNAV DESCRIPTOR INDEX NOT VALID IN ANALIZE REPORT When analyzing an SQL Performance Monitor or an SQL Plan Cache Snapshot, the user may see an error message if they select the 'Work with SQL Statement and Variables' menu action on a row in any of the drill-down reports. After doing the action, the SQL Statement with replacement variables should be displayed but an error message 'Descriptor index not valid' is displayed instead. This behavior only happens with clients that are connected to a system with a version greater than V5R4 of i5/OS. APAR SE31193 : CA400EXP-OPNAV-DBASE-INCORROUT SYMMETRIC MULTIPROCESSING In iSeries Navigator, Databases folder, there are some controls that should only be displayed if the DB2 Symmetric Multiprocessing option is installed on the server to which the client is connected. However, the client is checking for the wrong product option which may result in those controls being shown or hidden incorrectly. APAR SE29300 : CA400EXP-OPNAV-OUTPUT EXPORT HAS DUPLICATED PAGES When exporting large spooled files using the iSeries Navigator Export funtion, duplicate pages may be seen in the resulting ascii text file. Locate a large spooled file, right click on it, and select Export... The resulting PC file will have some pages repeated in the output. APAR SE29597 : CA400EXP-OPNAV-INCORROUT CLUSTER ADMIN DOMAIN MRE LIST ERROR Unexpected error when you try to open the list of a single MRE type. RECREATION Prerequisites: -Existent Cluster. -Existent Cluster Administrative Domain. -There are no MREs enrolled for that Cluster Administrative Domain. -Management Central Server is started from the server you want to connect from. Steps: 1. Open iSeries Navigator. 2. Select Management Central. 3. Login to Management Central Server. 4. Expand Management Central. 5. Select Clusters. 6. Expand your cluster. 7. Provide credentials as requested. 8. Expand Peer Resources. 9. Expand your cluster administrative domain. 10. Expand any MRE type category. Result: You will get "Unexpected Error" error message, plus additional information. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Before expanding the list enroll at least one MRE in the Cluster Administrative Domain. APAR SE29905 : CA400EXP-OPNAV-PRINTERS-INCORROUT UNABLE TO SORT PRINTER OUTPUT Click on the Basic operations plus sign, Printers plus sign, click on a printer, right click on a printer, go to Customize this view. You will find Sort grayed out. This is not grayed out on previous releases. APAR SE29980 : CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION PLUG-INS SETTING IS NOT WORKING AS DESIGNED Under Central Settings for App Admin in iNav when you restrict users from installing plugins this does not work during install. Users get prompted to install plugins and even if they are restricted they are allowed to answer yes and the install proceeds. APAR SE30183 : CA400EXP-OPNAV-DBASE-MSGSQL0302 UPDATE A TABLE WITH J FIELDS Using iSeries Navigator, when trying to update a table with J-field columns, the user may get a MSGSQL0302. This could happen if the column being updated is defined as J-field (DBCS only field) and the data being updated has fewer characters than the defined length of the column. This kind of field is only created through Data Definition Specification (DDS) language, there is no way to create it through SQL. For example the table could be created with a DDS source file as: A* A R RCRD A FIELD1 15O A JFIELD 12J CCSID(937) A* Although the first update completes successfully, the second update fails with MSGSQL0302 Error type 7. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: The user can work around the problem by doing one of the following things: 1) For the J-field being updated, always right-pad with DBCS blanks so the length of the new value would be equal to the field length, taking into account the shift-control characters. 2) If possible, change the DDS definition to use an O-field or create the file as an SQL table by using an SQL statement like: CREATE TABLE MYTABLE LIKE TBLWJFLD Where the TBLWJFLD is the table defined with DDS and contains at least one J-field. The new table will translate the J-field to O-field and the new type will be correctly handled for updates. APAR SE30770 : CA400EXP-OPNAV CONFIGURATION AND SERVICE FAILS WITH CPF3CF1 iSeries Navigator fails with CPF3CF1 error. Selection sequence: My Connections > System_name > Configuration and Service > Hardware May result in the following error: Error occurred while retrieving usage information for User_name on System_name CPF3CF1- Error code parameter not valid. where User_name is the signed on user and System_name is the connected system. APAR SE30848 : CA400EXP-OPNAV- ERROR CREATING NEW USER WITH JAPANESE CLIENT iSeries Navigator problem on Windows 2000 and client on Japanese environment. When creating a new user, CWBUNNAV.EXE fails with application error. The problem does not occur on Windows XP. Recreate as follows: 1. Run iSeries Navigator 2. My Connections -> System -> right click on Users and Groups and select "New User..." 3. Enter new user name 4. Click on Capabilities 5. Click on Application tab. APAR SE30855 : CA400EXP Help is not available on Rules Editor. The customer is using R540 iSeries Accesss for Windows and in iSeries Navigator he brings up the Rules Editor then tries to display the general help without success, there isn't help avialable. APAR SE31060 : CA400EXP-OPNAV-DBASE-MSGCWB0111 UPDATING A CHARACTER COLUMN When updating a character column within the Edit Contents dialog in iSeries Navigator, the user may get a MSGCWB0111 error message. One way to recreate is if the user updates a value where the actual value is larger than the column length. The next attempt to update the value will fail with the MSGCWB0111 error message. It is possible to set a value larger than the column length by: 1. Having significant (non-blank) characters up to the maximum column length. 2. Adding blank spaces at the end, so the sum of the significant plus the blank characters is greater than the column length. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: The problem is because of the mismatch between the server value and the overflowed client value. So using the Refresh action will reload the data from server and the user will not end up with the error on the next update. APAR SE31024 : CA400EXP UCW and ISW do not show new hardware types 576C Modem resource type is not shown under Universal Connection Wizard. 1819,181A,181B,181C,1820,1830 and 1831 Ethernet types are not shown under Internet Setup Wizard. APAR SE31061 : CA400EXP-OPNAV-DBASE-INCORROUT UPDATE NOT SAVED INTO SERVER When the user updates a row through Edit Contents dialog, the data is not saved on the server and no error is signaled to the user. This is possible if the user repeatedly updates the same row and commits the change without moving between rows and using the File -> Save menu option. The dialog shows the new value, but the server does not reflect the change. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Move to another row to submit the change to the server. Then the user should use the File -> Save menu option to commit the transaction. APAR SE29016 : CA400EXP-OPNAV-OTHER-UNPRED RUNTIME ERROR IN NAVIGATOR The following Microsoft C++ Runtime error is displayed, when iSeries Navigator is started: Error: ------------------ iSeries Navigator Microsoft Visual C++ Runtime Library Runtime Error! Program: This application has requested the runtime to terminate it in an unusual way. Please contact the applications support team for more information. After the user clicks OK, is possible to continue working with iSeries Navigator, however the error is displayed intermittently while using the iSeries Navigator functions that use Eclipse help. This problem was reported on Windows XP Professional x64 Edition Version 2003 and SP1. APAR SE31155 : CA400XW1-INCORROUT UNABLE TO RETRIEVE SERVICE AGENT REGISTRATION DETAILS Using the Extreme Support -> Agents - > Electronic Service Agent plug-in to "Retrieve Registration ID", select the local system name from the drop-down list and click the retrieve button receives message "Unable to retrieve Service Agent registration Details". QZRCSRVS joblog receives - msgcpf9810 f/QWDRSBSD QSYS x/03CE t/QZRCSRVS QSYS *STMT Library QSVCDRCTR not found. msgCPD0030 f/QCARULE QSYS x/07A7 t/QC2SYS QSYS *STMT Command QS9DUPOBJ in library QSYS not found. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE29793 : CA400EXP-DTRANSFER-INCORROUT CUSTOMIZED IASP IS NOT ALLOWED The Data Transfer Excel Add-in as well as the Data Transfer To/From GUI, do not allow to specify an IASP on a per system basis, as V5R3 did. APAR SE29838 : CA400EXP-DTRANSFER-MSGCWBTF0009 CSV FILE TYPE UPLOAD WARNING When a Comma Separated Variable file type containing DBCS data is uploaded to the iSeries, CWBTF0009 warning is displayed when it should not. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE29150 : CA400EXP-ODBC-MSGSQL0104 INCORRECT ERROR DUE TO SQL PACKAGE An ODBC application is getting an erroneous error message from the iSeries. The application was receiving an SQL0104 error message when preparing an SQL statement that appeared to have a null character embedded in the middle of a column name. The actual problem was much more complex. The connection is not using extended dynamic (package) support but the job was reused and the previous use of the job had used an SQL package for extended dynamic support. The host attempted to use extended dynamic on the prepare of the statement because the ODBC driver passed the code for an SQL package name, but it didn't actually send a package name. This code point should not have been sent at all. The problem can easily recreated in the lab using the ODBCTest program and performing the following steps: Make a full connect with odbctest using a DSN with extended dynamic turned off. Perform and SQLExecDirect on the following statement: "Set transaction isolation level none" Then peform an SQLPrepare on the following statement: "Select * from qiws.qcustcdt where lstnam = ?" Next bind some data like 'Jones' to the parameter marker and execute the statement. APAR SE29339 : CA400EXP-ODBC-WAIT VARIABLE FIELD COMPRESSION The V5R4 ODBC driver when connected to a V5R4 i5/OS will request and get data back with variable field compression. In some cases, the ODBC driver cannot parse the compressed data correctly. This failure will result in a hang in the ODBC driver, the application using the ODBC driver will likely appear to have stopped responding. This problem can be circumvented by adding a keyword to the data source or connection string. The ODBC driver supports a number of features through the use of a keyword, DEBUG, which works like a bitmap value. If the debug value is already set to add 1024 to that value. If the keyword doesn't exist on the connection string, you need to add it and set its value to 1024. This change cannot be made through the ODBC data source setup program, it has to be done either programmatically if DSN-less connections are used. If a file DSN is being used, modify the data source file with a text editor and add a new line to the data source: DEBUG=1024 If a machine data source is being used, then the data source will have to be changed by updating the windows registry. We do not advocate directly editing the registry though. The iSeries Access for Windows product provides a console application, cwbodbcreg, that can be used to modify the data source from a windows command line. As an example of how to use this tool, imagine that you have a data source named "My iSeries ODBC DSN". To update the data source, run the following command at a Windows command prompt (DOS prompt): cwbodbcreg "My iSeries ODBC DSN" debug 1024 RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Disable variable length compression setting the debug keyword to: "DEBUG=1024" APAR SE30295 : CA400EXP-ODBC-INCORROUT INCORRECT TYPE CONVERSION USED A PC application is using the iSeries Access for Windows ODBC driver through Microsoft's MSDASQL OLEDB provider. Because of this configuration, the application is not making ODBC API calls directly, they are using ADO and the MSDASQL provider determines which ODBC APIs to call and how to call them. When a query returns a LOB type followed by a numeric type it was discovered that the MSDASQL provider will not bind the non-LOB columns or even use the SQLGetData and specify a data type to return the data as. Instead they are defining a descriptor using the SQLSetDescField function to define the column type and size as numeric then later calling the the SQLGetData function specifying SQL_ARD_TYPE for the target type. Tracing and re-creates showed that the iSeries Access ODBC driver is returning the data as character rather than the ARD type which was defined as numeric. This may ultimately result in another error such as a truncation error or data out of range type of error but that error is because of what the application does with the data that was returned to them in the incorrect format. APAR SE30749 : CA400EXP-ODBC-WAIT HANG ENDING XA ENLISTMENT iSeries Access for Windows ODBC driver is being used in conjunction with Microsoft's Distributed Transaction Coordinator in Microsoft SQL Server environment with an ODBC connection pool. The first use of the ODBC connection enlists the ODBC driver in a distributed transaction and uses the connection without commiting or rolling the the transaction back. The connection is returned to the connection pool and sits idle until the next use. The second use first has to end the existing transaction. The ODBC driver enters into the function to un-enlist it from the existing distributed transaction. The ODBC driver never returns back from that function. To the SQL Server application it appears to be hung. OLE DB PROVIDER --------------- APAR SE30751 : CA400EXP-INCORROUT DISTRIBUTED TRANSACTION WITH SQL SERVER 2005 AND IBMDASQL FAILS. Customer is attempting to run a distributed transaction with the IBMDASQL provider and a linked server in MS SQL Server 2005. Here is the syntax that they're using from a query window in the SQL Server Management Studio: SET XACT_ABORT ON GO BEGIN DISTRIBUTED TRANSACTION; INSERT INTO IBMDB2i.iDatabase.LibName.FileName (ITDSC) VALUES('MicrosoftXA') COMMIT TRANSACTION; This fails with the following output in the messages window: OLE DB provider "IBMDASQL" for linked server "IBM_DB2" returned message "PWS0002: Function completed successfully. Cause . . . . . : The requested function completed without any errors.". Msg 7394, Level 16, State 2, Line 2 The OLE DB provider "IBMDASQL" for linked server "IBM_DB2" reported an error committing the current transaction. APAR SE30788 : CA400EXP-OLEDB-MSGSQL0104 DUE TO SINGLE LINE COMMENTS IN SQL Customer was complaining that Carrige Returns were being stripped off in OLEDB provider. trace showed SQL0104 .NET DATA PROVIDER ------------------ No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE29302 : CA400EXP-AFPVIEWER INCORRECT LANGUAGE USED WITH AFP VIEWER iSeries Access is installed in a windows server environment with multiple languages. Users will connect to the server that have the preferred language specified in their iSeries access properties. It works for all functions of iSeries Access, except for the AFP workbench viewer. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.1 (2008-01-11) and the equivalent of 5722JC1 PTFs: SI29774 and SI29775 APAR SE29800 : TOOLBOXJAVA-JT400 SCS5553WRITER CLASS CPI Support missing Class SCS5553Writer is documented to support 10 and 15 CPI. However, a real 5553 printer is capable of other CPI values, including 12, 13.3, 18, and 20 CPI. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20071214 APAR SE29388 : CA400EXP-TERMEMUL-UNPRED PCSWS.EXE EXITS WHEN WINDOWS REGIONAL SETTINGS ARE VIETNAMESE PCSWS.EXE crashes when setting Windows Regional settings to Vietnamese. PC5250 is configured for Vietnamese. The issue occurs both at V5R3 and V5R4 version of the client. APAR SE29578 : CA400EXP-PRINTEMUL TURKISH CHARACTERS NOT PRINTED CORRECTLY PC5250 printer emulation is used to print spooled files with Turkish characters. Host print transform is not use, neither is PDT. The Turkish characters are not printing correctly. APAR SE29829 : CA400EXP-TERMEMUL-INCORROUT WRONG KEY WITH BULGARIAN KEYBOARD LAYOUT V5R4M0 SI27741 and Bulgarian Keyboard. Key of hex 002E (codepage 1251) is wrongly dispaying hex 002E (codepage 1251) instead. APAR SE30424 : CA400EXP-TERMEMUL-INCORROUT THE CURSOR DOES NOT APPEAR ON THE FIELD IF THAT IS DEFINED DSPATR(BL HI). The cursor does not appear on the field If that is defined dspatr(BL HI). Blink atribute. For instance: there are three field as FA(first) FB(second) FC(third) FA _____ FB ____ FC ____ FA and FB do not show up the cousor but FC can see it Any condition: This happens on V5R3 as well. APAR SE30508 : CA400EXP-TERMEMUL-UNPRED IN A KOREAN INSTALL ENVIRONMENT, SWITCHING BETWEEN APPLICATIONS CAUSES THE EMULATOR TO CLOSE. When a user with a Korean installation of iSeries Access opens multiple sessions and attempts to switch between them, all sessions close without warning. APAR SE30613 : CA400EXP-TERMEMUL-INCORROUT CLOSING SESSION WITH FILE EXIT ALL CAUSES APPLICATION ERROR ON PCSWS.EXE Win2003 Server 64-bit version with Citrix. When closing PC5250 display session by using File, exit all option Application error PCSWS.EXE error module MSVCRT.DLL is issued. Problem happens only after installing servicepack SI17741 SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE30656 : CA400EXP-SSL-MSGCWBCO1052 STASH PASSWORD IS NO LONGER CHECKED BY DEFAULT. Design on SSL with iSeries Access called for the STASH PASSWORD box to be checked by default in iKeyMan. This is no longer checked by default. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE29546 : CA400EXP - XDA stack corruption problem number 2 XDA has intermittent problem when running heavy ISV workloads that causes memory corruption. The problem occurs on three-tier environment due to data intensive workload. The result is that the ISV work process abort and need to be restarted. RESOLUTION: XDA was fixed for a memory corruption problem and was also fixed for DBCLOB access. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI27741 Build date = July, 2007 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE28143: CA400EXP-INCORROUT CCSID override needed for 300 and others APAR SE28646: CA400EXP-LICMGMT-MSGCWB0999 RC 9052 274D INTERMITTENT CWB0999 RC 9052 274D LICENSE MANAGEMENT ERROR. APAR SE28767: CA400EXP-COMM-INCORROUT CWBPING FAILS FOR MIXED-CASE SERVICE APAR SE29219: CA400EXP-INSTALL-UNPRED Welcome Wizard flashes on Vista Reboot OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE28166: CA400EXP-OPNAV-DBASE-UNPRED ANALYZE CLOSES RUN SQL SCRIPTS APAR SE28319: CA400EXP-OPNAV Cannot change MGTC Job Monitor metrics APAR SE28454: CA400EXP-OPNAV-FILESYS-INCORROUT Missing files in QSYS.LIB APAR SE28529: CA400EXP-OPNAV-OTHER-MSGAS400SECURITYEXCEPTION TOOL ENHANCED APAR SE28632: CA400EXP Association of physical to virtual IP address fails APAR SE28636: CA400EXP-2-INCORROUT START OPTION NOT AVAILABLE APAR SE28749: CA400EXP-OPNAV-DBASE-WAIT WHEN A QUERY HAS AN ERROR IN RSS APAR SE28860: CA400EXP-OPNAV-DBASE-MSGSQL0454 CREATING NEW INDEX APAR SE28988: CA400EXP-OPNAV-DBASE-MSGCPF3219 REORGANIZE AFTER SUSPENDED APAR SE28989: CA400EXP-OPNAV-DBASE-INCORROUT INDEX ADVISOR OVER AN MQT APAR SE29303: CA400EXP-OPNAV-INCORROUT No iSeries Navigator help APAR SE29155: CA400EXP-OPNAV-DBASE-INCORROUT SHOW STATEMENTS FROM ADVISOR APAR SE29214: CA400EXP-OPNAV Last used date APAR SE29215: CA400EXP Subnets sorted on DHCP Monitor APAR SE29217: CA400EXP hardware type 5767/5768 does not allow 1Gb ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE29218: CA400EXP-OPNAV Multi-Path Group Properties Disabled APAR SE29220: CA400EXP Network gui does not show new hardware types APAR SE29223: CA400EXP MGTC Wrong License Key Expiration Date exported DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE28290: CA400EXP-DTRANSFER DOWNLOAD GUI FAILS TO APPEND TO BIG FILES APAR SE28716: CA400EXP-DTRANSFER-INCORROUT HANG DOWNLOADING FILE DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE28376: CA400EXP-2-MSG "Enlist with DTC phase failed. 2" failure in distributed transaction APAR SE28524: CA400EXP-ODBC-INCORROUT ODBC DRIVER KEYWORD TRIMMING OPTION OLE DB PROVIDER --------------- APAR SE28443: CA400EXP-OLEDB-INCORROUT LEADING WHITE SPACE NOT IGNORED APAR SE28973: CA400EXP-OLEDB-PERFM OLEDB NEW BLOCK SIZE PROPERTY APAR SE29198: CA400EXP-OLEDB-INCORROUT LIBRARY LIST PROPERTY ON 64-BIT .NET DATA PROVIDER ------------------ APAR SE28398 : CA400EXP-IDB2DATA-INCORROUT DESERIALIZING IDB2EXCEPTION OBJECT FAILS WITH EXCEPTION. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 6.1 (2008-01-11) and the equivalent of 5722JC1 PTFs: SI29774 and SI29775 No fixes. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20070614 APAR SE28231: CA400EXP-TERMEMUL-INCORROUT YEN SIGN IS CHANGED TO THE MIDDL APAR SE28352: CA400EXP-TERMEMUL-INCORROUT TOOLBAR OPTIONS NOT GRAYED OUT APAR SE28504: CA400EXP-TERMEMUL-UNPRED RUN THE SAME CAUSES PROMPT APAR SE28527: CA400EXP-PRINTEMUL PRINT TO FILE ERROR ON VISTA APAR SE28541: CA400EXP-TERMEMUL-INCORROUT HACL SCREEN RECOGNITION EVENT APAR SE28564: CA400EXP-TERMEMUL-PC5250 SBCS in DBCS field hangs session APAR SE28682: CA400EXP-SECURITY-UNPRED USER PROFILES BELONGING TO MULTIPLE ACTIVE DIRECTORY GROUPS MAY FAIL WITH PC5250 KERBEROS SSO. APAR SE28732: CA400EXP-APIS-OTHER-PERFM CUSTOM PROGRAM USING AUTSESS.DLL, CAUSES A PC5250 PERFORMANCE ISSUE. APAR SE28893: CA400EXP-TERMEMUL-MSGCPIAD06 FAILURE IN APAR SE27644 STILL OCCURS WITH PTFS SI26600 OR SI26879 IF USING MULTIPLE SESSIONS. APAR SE28940: CA400EXP-PRINTEMUL SLOWER PRINTING WITH ESC_P.PDT APAR SE29092: CA400EXP-TERMEMUL-MSGPCSERR101 PC5250 COPY PASTE AFTER EXCEL USED APAR SE29104: CA400EXP-PRINTEMUL FONT IS PRINTED TOO SMALL SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE27311: CA400EXP-SSL-WAIT SSL SLOW RESPONSE PENTIUM D PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE29216: CA400EXP - XDA Stack Corruption Problem VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI26879 Build date = March, 2007 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE28194 : CA400EXP-INCORROUT CWBCFG fails with /IPADDR values OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE28301 : CA400EXP-MSGCPF26A7 ISERIES NAVIGATOR SPOOLED FILE ERROR APAR SE28184 : CA400EXP-OPNAV MGTC MONITORS SHOW FUNCTION NOT SUPPORTED APAR SE27912 : CA400EXP-NETWORK-INCORROUT wrong username on UCW profiles APAR SE28060 : CA400EXP-OPNAV-DBASE-MSGSQL0501 SCROLLING RESULT SET VIEWER APAR SE27913 : CA400EXP-OPNAV-NETWORK-INCORROUT ATT prefix problems APAR SE28171 : CA400EXP-FILESYS Source physical file member is not copied APAR SE28018 : CA400EXP-NETWORK-INCORROUT Incomplete UCW phone list APAR SE28073 : CA400EXP-OPNAV DISPLAY MOUNTED VOLUME APAR SE28169 : CA400EXP-OPNAV-FILESYS Drag and drop causes lost focus APAR SE28165 : CA400EXP COPY MONITOR ONLY COPIES FIRST SELECTION APAR SE28196 : CA400EXP-OPNAV-NETWORK-INCORROUT Remove CIMOM Server APAR SE27684 : CA400EXP-OPNAV-FILESYS Create new folder in QDLS APAR SE27946 : CA400EXP-OPNAV-DBASE CLOSE ACTION NOT WORKING IN MAIN WINDOW APAR SE27976 : CA400EXP-OPNAV-DBASE CANNOT UPDATE DBCS BLANK-ENDED COLUMN APAR SE28007 : CA400EXP-OPNAV-FILESYS Time is missing in date-time columns APAR SE28011 : CA400EXP iNav hangs if user cancels out of SST signon. APAR SE28045 : CA400EXP-OPNAV-UNPRED Long environment name not displayed APAR SE28067 : CA400EXP Add Disk Unit Wizard shows the wrong Frame/Unit APAR SE28130 : CA400EXP-OPNAV DIRECTOR SERVER JOB QCPMGTSVR IS NOT LISTED DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE28174 : CA400EXP-DTRANSFER CHARACTER TRUNCATION WARNING NOT SHOWN APAR SE27880 : CA400EXP-DTRANSFER BATCH APPS CRASH WITH EMPTY LIST FILES APAR SE27774 : CA400EXP-DTRANSFER BATCH /I IGNORE WARNINGS NOT WORKING FINE APAR SE28396 : CA400EXP-DTRANSFER-PERFM TRANSFERS SLOW WITH SI25949 DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE27879 : CA400EXP-DTRANSFER PROTECTED SHEETS CAUSE EXCEL TO CRASH APAR SE28192 : CA400EXP-DTRANSFER EXCEL CRASHES WHEN REQUEST FILE IS EMPTY APAR SE27881 : CA400EXP-DTRANSFER FIELD LENGTH IS INCORRECTLY VALIDATED APAR SE27553 : CA400EXP-DTRANSFER COMMA NOT SUPPORTED AS DECIMAL SEPARATOR APAR SE27739 : CA400EXP-DTRANSFER EXCEL ADDIN DOWNLOAD FAILS IN EXCEL 2007 ODBC ---- APAR SE27524 : CA400EXP-ODBC-INCORROUT AUTOCOMMIT/ISOLATION NOT HONORED APAR SE28179 : CA400EXP-ODBC-MSGCWBCO1047 CONNECTIONS MAY HANG OR ABNORMALL APAR SE28373 : CA400EXP-ODBC-MSGSQL0180 SQLDescribeParam problem OLE DB PROVIDER --------------- APAR SE27877 : CA400EXP-OLEDB-INCORROUT MS SQL SERVER 2005 SP1 DTS Wizard APAR SE27941 : CA400EXP-OLEDB-INCORROUT Error 0x80040E00 in SQLServer SSIS .NET DATA PROVIDER ------------------ No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.3 (02/14/2007) and the equivalent of PTF 5722JC1 SI26731. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20070214 APAR SE28195 : CA400EXP-TERMEMUL-INCORROUT IN A CL PGM THE COMMAND STRPCCMD APAR SE27542 : CA400EXP-PRINTEMUL-PERFM SLOW PERFORMANCE OR FAILURES USING APAR SE27543 : CA400EXP-PRINTEMUL-INCORROUT COLLECT PRINT JOBS FUNCTION APAR SE27549 : CA400EXP-OUTPUT-INCORROUT COMMAND LINE OR UNDERLINE DISAPPEA APAR SE27620 : CA400EXP-2-INCORROUT TERMINAL SERVER ENVIRONMENT DOES NOT APAR SE27644 : CA400EXP-COMM-MSGE004 AUTO RECONNECT WITH BYPASS SIGNON PASS APAR SE27733 : CA400EXP-PRINTEMUL-UNPRED PRINTER SETUP WINDOW ALWAYS DISPLA APAR SE27827 : OSP-PAR PC5250, KOREAN KEYBORD DOESN'T RETURN TO ENGLISH MOD APAR SE28001 : CA400EXP-2-PERFM MEMORY LEAK WHEN RUNNING VB MACRO APAR SE28209 : CA400EXP-INCORROUT APPDATA IDs do not work in Properties APAR SE28247 : CA400EXP-2-UNPRED WINDOW SIZE NOT RESTORED ON SAVED VIEW APAR SE28249 : CA400EXP-OUTPUT-INCORROUT PCOMM TP5250 TERMINAL-FONT INCORRE SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE28292 : CA400EXP-SSL-WAIT Mgmt Central with SSL fails with SI25949 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE28193 : CA400EXP-OPCON-UNPRED RCS cannot reconnect after close PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE27888 : CA400EXP - Enhance XDA Windows client serviceability VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- APAR SE28228 : OSP-INCORROUT EZ-Setup support for Domino 7 --------------------------------- Service Pack Level = SI25949 Build date = December 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE27505 : CA400EXP-NLS-INCORROUT Japanese character conversion APAR SE27507 : CA400EXP Support running on Windows Vista OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE26734: CA400EXP-OPNAV-INCORROUT Wrong Shortcuts settings APAR SE27312: CA400EXP-OPNAV-FILESYS Authority error creating a folder APAR SE26127: CA400EXP-OPNAV ENVIRONMENT CANNOT BE DELETED APAR SE27313: CA400EXP-OPNAV-DBASE-INCORROUT VARYING DATA SIZE DESC DIALOG APAR SE27315: CA400EXP-OPNAV-DBASE-WAIT UNSUPPORTED REFRESH ACTION IN VE APAR SE27411: CA400EXP-OPNAV-DBASE-INCORROUT SHOW ACTIONS OVER MQTs IN VE APAR SE27460: CA400EXP-OPNAV-NETWORK-INCORROUT Router selection hangs APAR SE27412: CA400EXP-OPNAV-DBASE-MSGSQL0443 CANCELING THRESHOLD PROMPT APAR SE27413: CA400EXP-OPNAV-DBASE NONE TREATED AS A DELIMITER IN IMP/EXP APAR SE27459: CA400EXP-OPNAV-DBASE SUPPORT CONDENSED INDEX ADVICE APAR SE27461: CA400EXP-NETWORK-INCORROUT DNS autostart checkbox not saved APAR SE27468: CA400EXP-OPNAV-DBASE NODE UNEXPANDED IN HEALTH CENTER HIST APAR SE27470: CA400EXP-OPNAV-DBASE DISPLAY SIZE FORMAT APAR SE26797: CA400EXP-OPNAV-INCORROUT CLUSTER SWITCH IASP FAILS APAR SE27073: CA400EXP associate virtual IP to physical interfaces APAR SE27216: CA400EXP-DATABASE AN SQL STATEMENT WITH JDBC ESCAPE SEQUENCE APAR SE27281: CA400EXP-OPNAV-PRINTERS-PERFM PERFORMANCE PROBLEM Listing DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE27163: CA400EXP-DTRANSFER BATCH PROGRAMS SHOW ERROR AND CRASH APAR SE26929: CA400EXP-DTRANSFER RXFERPCB & ACTIVEX NOT REPORTING ERRORS APAR SE27233: CA400EXP-DATAXFER MEMBER AND FILE TEXT DO NOT SUPPORT DBCS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE27102: CA400EXP-DTRANSFER EXCEL ADD-IN CONVERTS TABS TO SPACES ODBC ---- APAR SE26738: CA400EXP-ODBC-PERFM - Several ODBC driver performance fixes APAR SE27506 : CA400EXP-ODBC-INCORROUT BLOCK UPDATABLE CURSOR BEHAVIOR WITH ADO/ODBC APAR SE26605: CA400EXP-ODBC-INCORROUT - CORRUPTS PARAMETER MARK APAR SE26785: CA400EXP-ODBC-INCORROUT INTERNAL DRIVER ERROR WHEN CACHE OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE27502 : CA400EXP-IDB2DATA-MSGSQL0470 Don't set null for output-only parameters APAR SE27503 : CA400EXP-IDB2DATA-MSGSQL0502 after calling SP using ExecuteNonQuery APAR SE27521: CA400EXP-IDB2DATA-UNPRED IDB2DATAADAPTER METHOD LEAKS MEMORY LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.2 (08/28/2006) and the equivalent of PTF 5722JC1 SI25173. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20061116 APAR SE25556: CAEXP-PC5250-PRINT-INCORROUT SPOOL FILE IS HELD WITH MSGCPF5 APAR SE26231: OSP MACRO NAME WITH SPACE HIDES OTHER MACRO NAMES APAR SE26558: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION IS INCORRECT AFT APAR SE26717: CA400EXP-TERMEMUL-MSGECL37180 THE '@' KEY STROKE THROWS AN APAR SE27562: CA400EXP-TERMEMUL Unique session ID limit too small SECURE SOCKETS LAYER (SSL) -------------------------- Non-APAR fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE27504 : CA400EXP-DTATRANS-INCORROUT ZonedConverter FromBytes fails APAR SE26929: CA400EXP-DTRANSFER RXFERPCB & ACTIVEX NOT REPORTING ERRORS VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI24893 Build date = September 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE25733: CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION SIGNON APAR SE25775: CA400EXP - LOB optimization in XDA APAR SE26399: CA400EXP-OPNAV-INCORROUT JOBS FUNCTION UNAVAIL WITH SSL APAR SE26420: CA400EXP-INCORROUT CWBNL0101 FOR CODEPAGE 1386 to 937 OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE25164: CA400EXP-OPNAV CAN NOT SELECT ANSI/ASCII CCSID ON NETSERVER APAR SE25671: CA400EXP-OPNAV Cannot create remote system configuration APAR SE25735: CA400EXP-OPNAV-FILESYS UNABLE TO ADD HOST TO NETGROUP BY IP APAR SE25909: CA400EXP-OPNAV-DBASE MAINTAINED TEMPORARY INDEXES IN ADVISOR APAR SE25910: CA400EXP-OPNAV-DBASE JOB LOG VIEWER HANGS APAR SE25911: CA400EXP-OPNAV-DBASE RSS CANCEL REQUEST NOT FREEING RESOURCE APAR SE25934: CA400EXP-OPNAV-INCORROUT SWITCHABLE DEVICES JAVA TRACE APAR SE25945: CA400EXP-OPNAV-INCORROUT Unable to restart shared monitors APAR SE26107: CA400EXP-OPNAV-DBASE-INCORROUT MULTI-GLOBAL TRANSACT SUPPORT APAR SE26172: CA400EXP-OPNAV-DBASE-INCORROUT SHOW INDEXES AND MQTs APAR SE26232: CA400EXP-OPNAV-DBASE IMPORT DATA WIZARD ALLOWS INVALID INPUT APAR SE26326: CA400EXP-OPNAV-OUTPUT-INCORROUT PAGES PER COPY DOES NOT SORT APAR SE26328: CA400EXP-OPNAV-OUTPUT-INCORROUT SHORTCUTS TO PRINTER OUTPUT APAR SE26339: CA400EXP-OPNAV-INCORROUT ADD SECONDARY DISK POOL FAILS APAR SE26342: CA400EXP-OPNAV-DBASE-INCORROUT BLANK LINES PASTING FROM RSS APAR SE26346: CA400EXP-OPNAV-DBASE-INCORROUT GLOBAL TRANSACTION PROPERTIES APAR SE26430: CA400EXP-OPNAV RUN SQL DEBUGGER NOT DISPLAYING PROPER NLV APAR SE26540: CA400EXP-OPNAV-DBASE-INCORROUT DESCRIPTOR INDEX NOT VALID DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE25348: CA400EXP-DTRANSFER-INCORROUT PASTING DATA AS LINK IN EXCEL APAR SE25421: CA400EXP-DTRANSFER-INCORROUT WRONG COLUMN SORTING IN DISPLAY APAR SE26348: CA400EXP-DTRANSFER CREATE HOST FILE WITH EMPTY COLUMNS FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE26329: CA400EXP-DTRANSFER EXCEL ADD-IN HANGS AFTER DOWLOADING FILE ODBC ---- APAR SE25951: CA400EXP-ODBC-INCORROUT - SQLTABLES PROBLEM WITH MQT APAR SE26128: CA400EXP-ODBC-INCORROUT PCBVALUE NOT SET FOR RETURN CODE APAR SE26325: CA400EXP-ODBC-MSGERROR IN HOST SERVER DATASTREAM MSACCESS 97 OLE DB PROVIDER --------------- APAR SE25382: CA400EXP-OLEDB-MSGSQL0104 When update recordset using system naming APAR SE25454: CA400EXP-OLEDB-UNPRED WHEN IN PARM IS DEFINED AS IN/OUT APAR SE25755: CA400EXP-OLEDB BLANK PROPERTY IN EXTENDED PROPERTIES FAILS .NET DATA PROVIDER ------------------ APAR SE25710: CA400EXP-IDB2DATA Read & Write LOB data in chunks more often LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.1.1 (05/17/2006) and the equivalent of PTF 5722JC1 SI23572. Also includes the equivalent of PTF 5722JC1 SI24544: APAR SE26135: CA400EXP-OPNAV-INCORROUT COMMAND PROMPTER INVALID PWD LENGTH 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20060806 APAR SE24106: CA400EXP-OPCON-HOST PRINT FAILS WITH MSGMCH0601 OR MSGCPF519 APAR SE25092: CA400EXP-TERMEMUL-INCORROUT PC5250 WINDOW DISAPPEARS WHEN APAR SE25262: CA400EXP-PRINTEMUL-INCORROUT PRINT SAME SPOOLED FILE TWICE I APAR SE25697: CA400EXP-COMM-UNPRED PC5250 HANGS AFTER HITTING RESET KEY APAR SE26108: CA400EXP-OUTPUT-INCORROUT DISPLAY FIELDS ARE NOT PRESENTING APAR SE26139: CA400EXP-TERMEMUL-INCORROUT IN A CL PGM THE COMMAND STRPCCMD SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ APAR SE25533: CA400EXP-OUTPUT-INCORROUT V5R4 FAXING PC DOCUMENTS SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE25845: CA400EXP-OPCON-INCORROUT cpanel src changes not displayed 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 = SI23696 Build date = May 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE24562: CA400EXP-OPNAV HANDLE LEAK IN APPLICATION ADMINISTRATION APAR SE24598: CA400EXP-OPNAV-INCORROUT extended attributes trap in IFS APAR SE24713: CA400EXP-INSTALL-INCORROUT INSTALL SAME SERVICEPACK TWICE APAR SE24726: CA400EXP-ODBC-INCORROUT SQL BIG-ENDIAN UTF16 WITH 'XXFF' APAR SE25099: CA400EXP-COMM-MSGCWBSY1040 Windows credentials not found APAR SE25422: CA400EXP-TERMEMUL NO PC5250 SOUNDS AFTER V5R4 INSTALL OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE24032: CA400EXP-OPNAV-DBASE-INCORROUT INDEX ADVISOR EMPTY WITH IASP APAR SE24173: CA400EXP-OPNAV-MSGCWBNL0107 EDIT TABLE CONTENTS DBCS BLANKS APAR SE24176: CA400EXP-OPNAV-DBASE-INCORROUT ACCESS PLAN REBUILD COUNT APAR SE24257: OSP-DB-MSGCPFA0A2 ACCESSING PERMISSIONS FROM ISERIES NAVIGAT APAR SE24550: CA400EXP-OPNAV-DBASE-INCORROUT REORGANIZE TABLE INFORMATION APAR SE24551: CA400EXP-OPNAV-MSGCPD8ED5-MSGCPF2718 When adding VE to NWSD APAR SE24625: CA400EXP-OPNAV- Export LPAR configuration to IFS fails APAR SE24642: CA400EXP- Disks on 5787 expansion unit are not displayed APAR SE24710: CA400EXP-OPNAV-INCORROUT History Log msgs of < 5 chars gone APAR SE24711: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY APAR SE24873: CA400EXP-OUTPUT-INCORROUT WHEN EXPORT MONITOR DATA FROM INAV APAR SE24882: CA400EXP-OPNAV-JOBS-INCORROUT CURRENT SQL STATEMENT STATUS APAR SE24894: CA400EXP-OPNAV-NETWORK-MSGDATA DATA ENTRY ERROR MESSAGE APAR SE25008: CA400EXP-OPNAV-DBASE EXPLAIN SQL FROM VISUAL EXPLAIN APAR SE25012: CA400EXP-OPNAV-DBASE PREFERENCES IN RUN SQL SCRIPTS ARE LOST APAR SE25014: CA400EXP-OPNAV-DBASE-INCORROUT TIMESTAMP ON SHOW INDEXES APAR SE25050: CA400EXP-OPNAV-NETWORK-INCORROUT IPv6 GUI problems APAR SE25054: CA400EXP-OPNAV Error setting spooled file expiration date APAR SE25068: CA400EXP-OPNAV-DBASE-INCORROUT INVALID COLUMN ID ON INDEXES APAR SE25104: CA400EXP-OPNAV-DBASE SHOW STATEMENTS DIALOG DIMENSION APAR SE25107: CA400EXP-OPNAV Error code 7 on mirror synchronization on IPL APAR SE25123: CA400EXP-OPNAV Unable to add nodes to administrative domain APAR SE25124: CA400EXP-OPNAV CHANGES TO ADMIN DOMAIN NOT PRESERVED APAR SE25125: CA400EXP-OPNAV-INCORROUT Cannot stop cluster APAR SE25235: CA400EXP-OPNAV User name/password not correct on initialize APAR SE25236: CA400EXP-OPNAV Upper case CHAP name shown in mixed case APAR SE25298: CA400EXP-OPNAV LOAD IMAGE CATALOG PANEL APAR SE25299: CA400EXP-OPNAV-DBASE-INCORROUT SHOW STATEMENTS SORT COLUMNS DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE24961: CA400EXP-DTRANSFER USERID NOT SAVED CORRECTLY IN DTT FILE APAR SE25102: CA400EXP-DTRANSFER UNEXPECTED ERROR IN EXCEL WIZARD DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE24170: CA400EXP-DTRANSFER USERID TRUNCATION IN EXCEL ADD-IN ODBC ---- APAR SE00013: CA400EXP-ODBC FETCH PROBLEMS WITH SQL_ATTR_ROW_ARRAY_SIZE APAR SE24285: CA400EXP-ODBC-INCORROUT CAN NOT REGISTER ODBC TRANSLATION OP APAR SE24755: CA400EXP-ODBC DRIVER CRASH WITH LARGE SQL_C_DOUBLE VALUES OLE DB PROVIDER --------------- APAR SE24629: CA400EXP-OLEDB-MSGSQL0104 Problems with long database names .NET DATA PROVIDER ------------------ APAR SE24436: CA400EXP-IDB2DATA-INCORROUT CLOB LENGTH SET INCORRECTLY WITH APAR SE24985: CA400EXP-IDB2DATA-INCORROUT NullReferenceException in GetDcRow LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE25325: CA400EXP-AFPVIEWER VERSION 2.02.01.01 TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.0 (12/16/2005) and the equivalent of PTF 5722JC1 SI20169. Also includes the equivalent of PTF 5722JC1 SI23220: APAR SE24779: CA400EXP-OPNAV-INCORROUT Prompting problem with CALLPRC 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20060324 APAR SE22922: CA400EXP-TERMEMUL-INCORROUT CURSOR DOESN'T MOVE TO THE FIRST APAR SE23600: CA400EXP-TERMEMUL-INCORROUT EVENT NOTIFICATION NOT WORKING APAR SE23782: CA400EXP-TERMEMUL-INCORROUT HACL NOTIFYKEYEVENT APAR SE24597: CA400EXP-TERMEMUL-INCORROUT STRPCCMD FAILS WITH BATCH FILES APAR SE24958: CA400EXP-PRINTEMUL-INCORROUT EXTRA SPACE CHARACTER INVALIDAT APAR SE25088: CA400EXP-TERMEMUL-INCORROUT Keyword support for color settings on 5250 APAR SE25221: CA400EXP-TERMEMUL-INCORROUT Not using iNav default SSL port APAR SE25222: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window size APAR SE25223: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window focus APAR SE25224: CA400EXP-TERMEMUL-INCORROUT Collect and Print PC5250 jobs SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE24807: CA400EXP-OPCON-INCORROUT File access failure causes fault APAR SE24809: CA400EXP-OPCON-INCORROUT Control Panel close may fault APAR SE24811: CA400EXP-OPCON-INCORROUT Apply button causes bootp failure APAR SE25097: CA400EXP-OPCON-INCORROUT Device id out of sync APAR SE25176: CA400EXP-OPCON-INCORROUT gui hang during close APAR SE25177: CA400EXP-OPCON-INCORROUT cwbopcon.exe ends APAR SE25424: CA400EXP-OPCON-INCORROUT UNUSABLE GERMAN CONFIG PANEL 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 = SI22257 Build date = February 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE23024: CA400EXP-ODBC-INCORROUT UTF8 to ME Linux PWS0006 APAR SE23309: CA400EXP - Update the extended user defined field support in XDA APAR SE24325: CA400EXP-TERMEMUL-INCORROUT PRINTER ASSOCIATION CHECKBOX OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE22769: CA400EXP-OPNAV-DBASE-PERFM SPECIFY QAQQINI FILE FOR ANALYZE APAR SE22770: CA400EXP-OPNAV-DBASE-INCORROUT SORTING PERFMON AND SNAPSHOT APAR SE22936: CA400EXP-OUTPUT-INCORROUT Precache causes cwbundbs.exe hang APAR SE23087: CA400EXP-OPNAV-MSGCPF2422 Wrong reply with message monitor APAR SE23239: CA400EXP- IFS GUI crashes when getting usage of directories APAR SE23263: CA400EXP-OPNAV Disk Management Miscellaneous problems APAR SE23288: CA400EXP-OPNAV HISTORY LOG DBCS PARSING APAR SE23295: CA400EXP - Problems in DM GUI when TCP/IP is down APAR SE23296: CA400EXP-OPNAV-DBASE STRING INDEX OUT OF RANGE: -1 WILDCARD APAR SE23312: CA400EXP-OPNAV-INCORROUT Unable to change Model System APAR SE23332: CA400EXP-OPNAV-INCORROUT MRE STACK TRACE ERROR APAR SE23401: CA400EXP-OPNAV-NETWORK Missing Virtual Ethernet Ifc Support APAR SE23447: TCPIP-MSGCPF3CF1 CREATING THE PPP PROFILE FAILS WITH CPF3CF1 APAR SE23507: CA400EXP-OPNAV-DBASE-MSGSQL0443-MSGCPF3224 INDEX ANALYZER APAR SE23618: CA400EXP - Slot D03 on 0595 Tower is not displayed APAR SE23657: CA400EXP-OPNAV DDM SERVER PROPERTIES ON JAPANESE DBCS APAR SE23809: CA400EXP-OPNAV-DBASE-PERFM RSS NO BLOCKS RECS ON CALL PARAMS APAR SE23824: CA400EXP-OPNAV-INCORROUT HISTORY LOG MESSAGE PROPERTIES APAR SE23825: CA400EXP-OPNAV-DBASE-UNPRED EXPLAIN SQL FROM VE EMPTY ERROR APAR SE23835: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY APAR SE23837: CA400EXP-OPNAV-DBASE-INCORROUT INDEX FUNCTIONS APAR SE23840: CA400EXP-OPNAV-DBASE-INCORROUT NATIONAL LANGUAGE SUPPORT APAR SE23846: CA400EXP-OPNAV-DBASE-INCORROUT IMPORTING FIXED FORMAT DATA APAR SE23847: CA400EXP-OPNAV-DBASE-INCORROUT SQL PERFORMANCE FUNCTIONS APAR SE23864: CA400EXP-OPNAV DUPLICATE TAPE USES WRONG FROMVOL APAR SE23941: CA400EXP-OPNAV-NETWORK RAS Profile connections may fail APAR SE23946: CA400EXP-OPNAV-NETWORK UCW fixes for ECC support APAR SE23965: CA400EXP-OPNAV-NETWORK AC3 not required for V5R4 VPN server DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE22760: CA400EXP-DTRANSFER - Vertical aligment incorrect for HTML APAR SE23381: CA400EXP-DTRANSFER-INCORROUT DATA TRANSFER TO PRINTER APAR SE23668: CA400EXP-DTRANSFER Customized sheet names for Excel files APAR SE24030: CA400EXP-DTRANSFER A CRASH OCCURS WHEN BROWSE FOR LIBRARIES APAR SE24081: CA400EXP-DTRANSFER INCORRECT CELL TEXT ALIGNMENT IN HTML DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE23267: CA400EXP-DTRANSFER-WAIT DATA TRANSFER EXCEL ADD-IN HANGS ODBC ---- APAR SE22732: CA400EXP-ODBC-PERFM RESULTS SETS ARE RETURNED WITH BLOCKING APAR SE22932: CA400EXP-ODBC Support loosely-coupled XA transactions APAR SE23227: CA400EXP-ODBC-INCORROUT POUND STERLING SYMBOL IN ODBC DS APAR SE23930: CA400EXP-ODBC-INCORROUT Improved Delimited Names Support OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE22266: CA400EXP-IDB2DATA Item has already been added to collection APAR SE22506: CA400EXP-IDB2DATA .NET Provider with .NET Framework 2.0 APAR SE23880: CA400EXP-IDB2DATA-MSGCPD0005 Trace - wrong decimal separator APAR SE24056: CA400EXP-IDB2DATA Server trace fails with system naming LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.0 (12/16/2005). 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20051220 APAR SE23207: CA400EXP-TERMEMUL-INCORROUT SPECIFIC CHARACTERS GET GARBAGE APAR SE23367: CA400EXP-TERMEMUL-UNPRED LONG NAME MACRO IN .PMP APAR SE23503: CA400EXP-TERMEMUL-INCORROUT DBCS PASTE ADDS SBCS BLANK SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE23862: CA400EXP-OPCON-INCORROUT CWBOPAOC.EXE FAULT CONNECTING LAN 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 = SI20465 Build date = October 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE21177: CA400EXP-INCORROUT cwbback.exe faults on some PCs APAR SE21440: CA400EXP-ODBC-INCORROUT INSERT OR UPDATE FROM PC UNICODE TO APAR SE21823: CA400EXP-INSTALL-INCORROUT AFP VIEWER ON 64BIT APAR SE22152: CA400EXP-RMTCMD RMTCMDS WHICH PREVIOUSLY RETURNED ERROR LEVE APAR SE22356: CA400EXP-OPNAV-INCORROUT IFS fault with extended attributes OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE21629: CA400EXP-OPNAV-DBASE-WAIT LOCK NOT RELEASED BY EDIT CONTENTS APAR SE22008: CA400EXP-OUTPUT-INCORROUT Change URL of Infocenter APAR SE22609: CA400EXP-OPNAV-INCORROUT Problems in some Cluster wizards DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE20527: CA400EXP-DTRANSFER UNICODE DATA WITH X'1A' IN THE DATA APAR SE20765: CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD OF MS EXCEL APAR SE21329: CA400EXP-DTRANSFER-INCORROUT WARNING MESSAGES STOP RFROMPCB APAR SE21880: CA400EXP-DTRANSFER-INCORROUT SENDS MULTIPLE SHEETS APAR SE22045: CA400EXP-DTRANSFER INCORRECT TRANSLATE FROM VALUE DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE21228: CA400EXP-DTRANSFER-WAIT MS EXCEL TRANSFER FROM HANGS ODBC ---- APAR SE20631: CA400EXP-ODBC-INCORROUT BLOCK UPDATE FAILS WITH NO MESSAGE APAR SE20801: CA400EXP-ODBC-INCORROUT SPORADIC CONVERSION ERROR APAR SE20919: CA400EXP-ODBC-INCORROUT STORED PROCEDURES COMPILED WITH *CAL APAR SE21192: CA400EXP-ODBC-INCORROUT ODBC RUNNING AT INCORRECT ISOLATION APAR SE21505: CA400EXP-ODBC-MSGSQL0100 PRE-FETCH OF DATA APAR SE21580: CA400EXP-ODBC-MSG7399 DISTRIBUTED TRANSACTION FAILS WITH ERR APAR SE21773: CA400EXP-ODBC-WAIT A CALL TO A PROCEDURE CONTAINING BLOB APAR SE21909: CA400EXP-ODBC Character truncation error converting exponential number from SQL_C_CHAR to SQL_DECIMAL OLE DB PROVIDER --------------- APAR SE21950: CA400EXP-OLEDB-INCORROUT SETTING PROPERTIES WITH SQL SERVER .NET DATA PROVIDER ------------------ APAR SE20843: CA400EXP-IDB2DATA DataAdapter with LOB locators fail APAR SE21919: CA400EXP-IDB2DATA Avoid implicit prepares when not necessary APAR SE21966: CA400EXP-IDB2DATA-INCORROUT .NET PROVIDER CONNECTION MANAGEMENT LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.8 (10/06/2005). 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20050818 APAR SE20279: OSP-PAR PRINTER SESSION, FILE, PAGE SETUP, FORMS SETTING APAR SE20458: CA400EXP-INCORROUT DISABLE STRPCCMD COMMAND VIA WS KEYWORD APAR SE20629: CA400EXP-PRINTEMUL-MSGCPF5261 ERROR PRINTING WITH RHM WITHIN APAR SE20734: CA400EXP-PC5250 KANA MODE INPUT INCORROUT ON CP1399 SESSION. APAR SE20890: CA400EXP-TERMEMUL-INCORROUT FUNCTION KEY NOT ALLOWED WHEN US APAR SE20923: CA400EXP-TERMEMUL-INCORROUT LETTER "O" AND ZERO NOT DISCERNA APAR SE21646: CA400EXP-TERMEMUL-INCORROUT POPUP MENU BAR OPERATION APAR SE21726: CA400EXP-TERMEMUL-INCORROUT KOREAN INPUT ON CODEPAGE 037 SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE22490: CA400EXP-INSTALL-INCORROUT SSL GSKIT 7.0.3.18 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE21607: CA400EXP-OPCON-INCORROUT OpNav service functions unavailable PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No 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 (if the service pack was originally installed with the Enable Service Pack Uninstall option): 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 Change or Remove Programs button (if necessary), then find and click on the IBM iSeries Access for Windows SI25949 item, and then click on the Change/Remove button. 4. Follow the instructions on the screen. Note: The SSL component fixes installed with this service pack cannot be removed as part of the service pack. To remove SSL fixes, use Selective Setup to remove the SSL component, then run Selective Setup again to re-install the SSL component, then apply the desired level of product service pack. 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. If installing from a CD or a faster connection is not possible, then the service pack could be installed in this manner: 1) A setting exists on 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"). 2) Run Check Service Level (either from the IBM iSeries Access for Windows Service folder shortcut or when Check Service Level runs at system boot on its defined schedule) 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. 3) Proceed through the Service Pack 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. 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, .TFR, .DTT, and .DTF 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.