============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R4M0 Cumulative Service Pack Level ------------- SI29771 ------------- (c) Copyright IBM Corporation 2007. All rights reserved. ======================================================================== SI29771 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 --------------------- This Service Pack is the fourth that IBM supports running on Windows Vista. (The first was service pack level SI25949.) 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 (SI29771) 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 = SI29771 (January, 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 = 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 System i 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 System i 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 Some users have CCSID values hardcoded in their application, but they would like their CCSID values to be overridden by a better one. For example the CCSID 300 is an old, unchanging CCSID, where CCSID 4396 is a newer and growing CCSID. Some users have the CCSID 300 hardcoded, but they would like to have CCSID 4396 used instead. RESOLUTION: We are going to provide a way to override a CCSID value. The override will be only used when CCSID conversions are done. The override is done using a registry key entry in the string format oldCCSID,newCCSID. Under the registry path: HKLM\Software\IBM\Client Access\CurrentVersion\NLS you can add the following entry of type string: Name = "CCSID-Override" Value= "OldCCSID,newCCSID,oldCCSID,newCCSID,..." For example: CCSID-Override = 300,4396 Restart applications for this to take effect. CIRCUMVENTION: Applications need to use more up-to-date CCSIDs, and should move toward using Unicode. APAR SE28646 : CA400EXP-LICMGMT-MSGCWB0999 RC 9052 274D INTERMITTENT CWB0999 RC 9052 274D LICENSE MANAGEMENT ERROR. Intermittent CWB0999 RC 9052 274D License Management error. APAR SE28767 : CA400EXP-COMM-INCORROUT CWBPING FAILS FOR MIXED-CASE SERVICE When cwbping is run using the /serv parameter, it appears to convert the service name entered to all lowercase letters. If the service name defined in the service table on the iSeries server contains any uppercase letters, cwbping fails to find the port number for the service. Since it cannot find the port to try to connect to, cwbping fails. One example is the service called as-WebFacing. When the following command is run: cwbping systemname /serv:as-WebFacing the following messages are displayed indicating the failure: E - CWBCO1011 - Remote port could not be resolved E - CWBCO1008 - Unable to connect to server application as-webfacing, returned 8407 RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: If you know the port number of the service you are using cwbping to verify connectivity of, run cwbping using the /port option instead of the /serv option, specifying the correct port. Alternatively, modify the service table on the iSeries server. You can either add a new entry, or a new alias to the existing entry, that is all lowercase. APAR SE29219 : CA400EXP-INSTALL-UNPRED Welcome Wizard flashes on Vista Reboot On Windows Vista, if the option to show the Welcome Wizard at startup is set and the computer is restarted, the Welcome Wizard just flashes on the screen and does not start. The problem does not occur on operating systems previous to Windows Vista. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE28166 : CA400EXP-OPNAV-DBASE-UNPRED ANALYZE CLOSES RUN SQL SCRIPTS Run SQL Scripts may close unexpectedly when working with the Analyze function for an SQL Performance Monitor. Many reports in the Analyze tool provide a 'Work with SQL' action which opens Run SQL Scripts. When the user closes the Run SQL Script window launched from the report, the first Run SQL Scripts window and the Analyze tool that it launched will close after a brief delay. This only affects a Run SQL Script window that was launched from the command line or by double-clicking on an SQL script in Windows Explorer. APAR SE28319 : CA400EXP-OPNAV Cannot change MGTC Job Monitor metrics When a user is modifying a Management Central Job Monitor with threshold values higher than 999 and he goes to the metrics tab, the panel stops responding and the only way to close it is by pressing the Cancel button. APAR SE28454 : CA400EXP-OPNAV-FILESYS-INCORROUT Missing files in QSYS.LIB When you expand a library, and then try to expand a second library before the first one is totally expanded; several source physical files could not be showed up under the first library tree. Even though, they all do appear in the right-hand pane when selecting the library; if you attempted to open a directory on the right pane that is not listed in the left, nothing happens. APAR SE28529 : CA400EXP-OPNAV-OTHER-MSGAS400SECURITYEXCEPTION TOOL ENHANCED Customer received As400SecurityException password not sent error. RESOLUTION: The signon panel was not working properly. The panels to run this tool have been modified to fix the problem. The documentation for this tool has been updated as well. CIRCUMVENTION: The users must verify the configuration required to use QYHCHCOP API manually. APAR SE28632 : CA400EXP Association of physical to virtual IP address fails When trying to associate a physical IP interface with a Virtual IP Address, after clicking the OK Button iSeries Navigator hangs. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE28636 : CA400EXP-2-INCORROUT START OPTION NOT AVAILABLE iSeries Navigator client at V5R4 and DNS server Bind8 on V5R4 i5/OS. Problem: Go to iSeries Navigator and right click on a DNS server instance, navigator shows Start option greyed out when is stopped in this case it should be enabled. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE28749 : CA400EXP-OPNAV-DBASE-WAIT WHEN A QUERY HAS AN ERROR IN RSS Using the Run SQL Scripts (RSS) window in iSeries Navigator, a user may see the Run SQL Scripts application hang. It is possible when the SQL Statement being executed has errors and Run SQL Scripts tries to highlight the block of the statement that might be causing the error. This problem is more prevalent with 64-bit platforms than with 32-bit. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Uncheck the 'Stop on Error' option in the Options menu in Run SQL Script window. Run the script. If the script has errors, the execution will not stop, however the message will be logged in the Messages tab. APAR SE28860 : CA400EXP-OPNAV-DBASE-MSGSQL0454 CREATING NEW INDEX When creating a new index, a MSGSQL0454 may be displayed stating that the stored procedure already exists. This error can occur if the user launches the New Index dialog from the Index Advisor and the user chooses to create the index. RESOLUTION: After this PTF is applied and the first time the user tries to create the index again using the same name, they may get an error when trying to create the index. This is because a temporary QAUGDBIX_xxxxx procedure may still exist in the same library/schema as this index's library/schema. However, the next time the user tries to create the index it should work because the temporary procedure will be deleted for the user. CIRCUMVENTION: There are some ways to circumvent the problem: 1) Delete any procedures named QAUGDBIX_xxxxx and try to create the index again. Where xxxxx is the SQL name of the table. Note that the procedure is created in the same library/schema that the index is created. 2)Change the index name in the dialog and try to create the index again. APAR SE28988 : CA400EXP-OPNAV-DBASE-MSGCPF3219 REORGANIZE AFTER SUSPENDED Using iSeries Navigator, a MSGCPF3219 is displayed when trying to start a new reorganize over a table. This is possible if the user selects reorganize a table, but there is a previous reorganize to the same table and it is suspended. Then if the user answered No to the "start a new reorganize" message dialog instead of resume the previously initialized one, and then pressed OK to start the new reorganize, they may see the error message. RESOLUTION: This PTF fixes the reported problem. CIRCUMVENTION: Based on the information the MSGCPF3219 is displayed, you need to run the following: DROP INDEX QRECOVERY.QDBRIxxxxx Where the xxxxx is a set of digits, the same as the number part of the file name related in the error message. Once the index is dropped, try the new reorganize over the table. APAR SE28989 : CA400EXP-OPNAV-DBASE-INCORROUT INDEX ADVISOR OVER AN MQT When trying to get the indexes advised from a Materialized Query Table (MQT), the iSeries Navigator may display more entries than expected. It shows the indexes advised for all the tables and MQTs in the same schema as the Materialized Query Table selected. This happens with the 'Index Advisor' and 'CONDENSE ADVISED INDEXES' options from the MQT's context menu. APAR SE29303 : CA400EXP-OPNAV-INCORROUT No iSeries Navigator help iSeries Navigator help is not displayed when the Windows user is not a member of the administrators group. On Windows Vista, this help is not displayed even for members of the administrators group. APAR SE29155 : CA400EXP-OPNAV-DBASE-INCORROUT SHOW STATEMENTS FROM ADVISOR Trying to show the explainable statements over a table's advised index where the table name is delimited, you may get no statements in the SQL Plan Cache Statements dialog, even though there are statements that reference the table. RESOLUTION: This PTF fixes the reported problem only for simple delimited names as outlined, such as tables named "my table", "my \ table", etc. The entries in the Show Statements dialog are now shown for that table. APAR SE29214 : CA400EXP-OPNAV Last used date Stand-Alone tape device list incomplete. APAR SE29215 : CA400EXP Subnets sorted on DHCP Monitor DHCP Monitor is designed to show the subnets without an order specific. However, DHCP Configuration shows the Subnets on the server in an alphabetic order. When DCHP has a lot of subnets is hard to find one in DHCP Monitor, so the GUI shold change. RESOLUTION: The Subnets in DHCP monitor will be shown sorted in an alphabetic way. APAR SE29217 : CA400EXP hardware type 5767/5768 does not allow 1Gb In the iSeries Navigator trying to create a Line from Connection->Network->TCP/IP Configuration->IPv4->Interfaces ->New LAN interface if you select a hardware with type 5767 or 5768, the option to select a speed of 1 GigaBit is disabled. This kind of hardware supports the speed of 1 GigaBit. ADDITIONAL KEYWORDS: OPNAV-NETWORK-INCORROUT APAR SE29218 : CA400EXP-OPNAV Multi-Path Group Properties Disabled Multi-path group properties of NWSD cannot be set from the System i Navigator gui. APAR SE29220 : CA400EXP Network gui does not show new hardware types Resources types "576C,1819,181A,181B,181C,1820,1830,1831" are missing on Remote Access Services GUI when creating a new profile or displaying a profile properties. APAR SE29223 : CA400EXP MGTC Wrong License Key Expiration Date exported When a software inventory is exported from Management Central using iSeries Navigator, the Licence Key Expiration Date value is not correctly exported. However the properties displayed for a software product have the correct information in the Licence Key Expiration Date field. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE28290 : CA400EXP-DTRANSFER DOWNLOAD GUI FAILS TO APPEND TO BIG FILES Data Transfer from GUI fails to append to big files and displays the following error message: Incorrect parameter. This problem has been reported with files over 4Gb. in size. APAR SE28716 : CA400EXP-DTRANSFER-INCORROUT HANG DOWNLOADING FILE Data Transfer from iSeries hangs when downloading a file to the PC. The display of the number of records transfered stops increasing and the process must be stopped by pressing the Cancel button. The QZDASOINIT joblog displays a data mapping error. Message CPF5035 (MSGCPF5035) with reason code 181, "Value in date, time, or timestamp string not valid.", followed by an SQL0181 (MSGSQL0181), meaning that the actual error will be returned on the next stream fetch. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE28376 : CA400EXP-2-MSG "Enlist with DTC phase failed. 2" failure in distributed transaction An Application that uses the MSDASQL provider is receiving the "ODBC 32-bit : err: [IBM][iSeries Access ODBC Driver]Enlist with DTC phase failed. 2" error message in a distributed transaction. The trace shows that the userID is getting truncated sometimes when a new connection is being started, causing the failure. APAR SE28524 : CA400EXP-ODBC-INCORROUT ODBC DRIVER KEYWORD TRIMMING OPTION The ODBC driver does not have a connection string option to allow trimming of spaces off of CHAR fields retrieved from the iSeries. This APAR is a request for an ODBC connection string keyword to take advantage of functionality available in the SQLSetConnectOption api for trimming spaces from CHAR fields. RESOLUTION: A option for DEBUG keyword has been added to ODBC driver in order to allow trimming of spaces off of char fields. The behavior of this option will be the same to the SQLSetStmtAttr(ATTR_TRIM_CHAR_FIELDS) API. The value for DEBUG Keyword to do this work is: 0x00002000 or 8192. OLE DB PROVIDER --------------- APAR SE28443 : CA400EXP-OLEDB-INCORROUT LEADING WHITE SPACE NOT IGNORED The iSeries Access for Windows OLEDB providers do not ignore leading spaces in the SQL statement or command text when using it for a connection to iSeries through a SQL linked server when using a select statement for open query. This causes the OLEDB provider to not execute the statement or command text when it is preceded by tabs, carriage returns and line feed characters and the following error: Msg 7357, Level 16, State 2, Line 1 Cannot process the object Select * From ". The OLE DB provider "IBMDASQL" for linked server "" indicates that either the object has no columns or the current user does not have permissions on that object. APAR SE28973 : CA400EXP-OLEDB-PERFM OLEDB NEW BLOCK SIZE PROPERTY A poor performance was reported in the iSeries Access for Windows OLEDB provider when a simple statement is executed using a linked server object in SQL Server 2005 compared with the ODBC provider. The problem occurs in the IBMDA400 and IBMDASQL provider as well. The current behavior of the OLE DB provider to determine how many rows to block for each fetch is using the cache size. That is not always the best behavior because applications using ADO often comes in with a cache size of 1, which kills performace. To fix that problem, the provider invented in the past a property called Block Fetch. If Block Fetch is true (default value), then when the cache size is set to 1, the provider ignore it, and instead use the default blocking size then the provider don't send any blocking value to the i5/OS. If Block Fetch is true and cache size is anything other than 1, the provider uses cache size. That can also be a bad decision, because SQL Server usually sets cache size to a small value affecting performance also. If Block Fetch is false, the provider always use cache size. RESOLUTION: To enable applications to have more control over how much data is transferred from the i5/OS during read operations, support is added for a new property called "Block Size". This is a property completely controlled by the end user, so the OLE DB provider will now block the data based in the value set in this property by the consumer. Block Size Specifies the number of Kilobytes to fetch data from the i5/OS. Settings and Return Values: Sets or returns a 4-byte unsigned integer indicating the number of Kilobytes for fetching data. The default value is 0 and indicates that the default i5/OS block size will be used. Notes: a) The Block Size property only applies to applications using SQL statements. Remarks: This custom property is available on the ADO connection object. The property is read/write when the connection is closed and read-only when the connection is open. APAR SE29198 : CA400EXP-OLEDB-INCORROUT LIBRARY LIST PROPERTY ON 64-BIT There were added some custom properties to the R540 iSeries Access for Windows OLE DB provider . When you attempt to set one of these custom properties through the "provider string" field using a Linked Server object In a 64-bit Microsoft Windows environment, it results in an error message (Microsoft SQL Server, Error:7303), this normally happens when you have incorrect authentication credentials OR there is an invalid property defined. For example trying to create a Linked Server in Microsoft SQL Server 2005 with the LIBRARY LIST custom property will result in an Error:7303 message in SQL Server. These same properties work fine in 32-bit Microsoft Windows environment with the iSeries Access for Windows 32-bit OLE DB providers. .NET DATA PROVIDER ------------------ APAR SE28398 : CA400EXP-IDB2DATA-INCORROUT DESERIALIZING IDB2EXCEPTION OBJECT FAILS WITH EXCEPTION. Attempting to serialize/deserialize an IDB2Exception object fails during deserialization with an exception - The constructor to deserialize an object of type 'IBM.Data.DB2.iSeries.iDB2SQLErrorException' was not found. 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 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20070614 APAR SE28231 : CA400EXP-TERMEMUL-INCORROUT YEN SIGN IS CHANGED TO THE MIDDL The yen sign is changed to the middle dot by STRPCCMD. This problem is unique to the Japanese DBCS environment. APAR SE28352 : CA400EXP-TERMEMUL-INCORROUT TOOLBAR OPTIONS NOT GRAYED OUT On Windows Vista, the following toolbar options are not grayed-out as they should be: Help -> Detect and Repair Actions -> Launch -> Information Bundler Internet Service Log Viewer When selected, each of these selections generates the response "PCSERR200". In Windows XP, these options are listed but grayed out. APAR SE28504 : CA400EXP-TERMEMUL-UNPRED RUN THE SAME CAUSES PROMPT When a connection is configured in iSeries Navigator to use the "Prompt every time" option but the PC5250 session is configured for "Use Windows username and password, no prompting", Using File--> Run the same causes new sessions to prompt for the user name and password anyway. APAR SE28527 : CA400EXP-PRINTEMUL PRINT TO FILE ERROR ON VISTA The windows Generic/Text Only printer driver is installed on a PC using Windows Vista Business and uses port FILE:. A PC5250 printer session is setup to use host print transform with QWPDEFAULT workstation customizing object. This session uses the generic printer driver. When you print, the data shows up on the printer queue on the PC, but it shows Error - Printing. APAR SE28541 : CA400EXP-TERMEMUL-INCORROUT HACL SCREEN RECOGNITION EVENT HACL (Host Access Class Library) event notification of screen recognition events are not funtioning in a .net environment. APAR SE28564 : CA400EXP-TERMEMUL-PC5250 SBCS in DBCS field hangs session Entering Single Byte Character Set (SBCS) data into a Double Byte Character Set (DBCS) data field on user menu causes the PC5250 session to hang with X-II (in red) in the Operator Interface Area (OIA) status display. Neither pressing the reset key nor system request help. APAR SE28682 : CA400EXP-SECURITY-UNPRED USER PROFILES BELONGING TO MULTIPLE ACTIVE DIRECTORY GROUPS MAY FAIL WITH PC5250 KERBEROS SSO. Users with multiple groups and/or subgroups assigned to their Active Directory account and using iSeries Access for Windows PC5250 configured for Kerberos single signon may fail to bypass the signon screen APAR SE28732 : CA400EXP-APIS-OTHER-PERFM CUSTOM PROGRAM USING AUTSESS.DLL, CAUSES A PC5250 PERFORMANCE ISSUE. After installing iSeries Access Service Pack SI26600, a customer creates an external program with Visual Basic 6. This program creates an instance of type PCOMM.autECLSession (autsess.dll). While the program is running the first time, no problem exists and the performance is fine. After ending this external program, iSeries Access PC5250 sessions run very slowly. This situation is worsened by starting and ending the external program again. This problem can be solved by uninstalling the service pack SI26600. APAR SE28893 : CA400EXP-TERMEMUL-MSGCPIAD06 FAILURE IN APAR SE27644 STILL OCCURS WITH PTFS SI26600 OR SI26879 IF USING MULTIPLE SESSIONS. The failure described in APAR SE27644, where a CPIAD06 invalid password error is generated in the QTVDEVICE job if an iSeries Access for Windows PC5250 session configured for Bypass Signon and Auto-reconnect reconnects after a communications failure, still occurs even with PTFs SI26600 (V5R3) or SI26879 (V5R4) applied. The problem only still occurs if there are multiple sessions open. APAR SE28940 : CA400EXP-PRINTEMUL SLOWER PRINTING WITH ESC_P.PDT A printer session is setup to use the esc_p.pdt. After install of service pack level SI24723, SI25949, or SI26879, printer performance was slower. APAR SE29092 : CA400EXP-TERMEMUL-MSGPCSERR101 PC5250 COPY PASTE AFTER EXCEL USED Microsoft Excel is run. A PC5250 session is started. The user uses the copy function in Excel to copy data from Excel to the clipboard. The copy function is then used in the PC5250 session. Message PCSERR101 is issued. This problem appears to occur when using some code pages, such as 1390/1399, but not others. APAR SE29104 : CA400EXP-PRINTEMUL FONT IS PRINTED TOO SMALL PC5250 printer session is created that does not use Host Print Transform and does not use PDT. Under File/Page Setup... they have disabled automatic page orientation and selected portrait for both drawers. BestFit is not used. The file should print in the font specified in the printer file, but PC5250 is shrinking the font. SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE27311 : CA400EXP-SSL-WAIT SSL SLOW RESPONSE PENTIUM D A PC5250 session is configured to connect to an iSeries system using SSL. A 20 second - 30 second delay is experienced after entering the user ID and password. After authentication is successful, PC5250 works as expected, with normal performance. This problem has, to this point in time, been experienced only on PCs with Pentium D processors. 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 XDA has intermittent problem when running heavy SAP workload that causes stack memory corruption. The problem occurs on three-tier environment where send and receive buffers need to be adjusted for longer length due to heavy workload and data intensive queries. The result is that the SAP work process aborts and needs to be restarted. 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.