============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R4M0 Cumulative Service Pack Level ------------- SI22257 ------------- (c) Copyright IBM Corporation 2006. All rights reserved. ======================================================================== Co-requisite PTF SI22258 is automatically included with any shipment or web download of SI22257. SI22258 exists only for packaging reasons. All service pack level references will be to SI22257. SI22257 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. 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 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI22257 (February 2006) 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. 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 = SI22257 Build date = February 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE23024: CA400EXP-ODBC-INCORROUT UTF8 to ME Linux PWS0006 UTF8 to MixedEbcdic conversions will fail. UTF8 to Mixed Ebcdic conversion will be fixed. APAR SE23309: CA400EXP - Update the extended user defined field support in XDA The extended user defined field support needs to be updated in the XDA Windows and Linux clients. The extended user defined field support in the XDA Windows and Linux clients has been updated. APAR SE24325: CA400EXP-TERMEMUL-INCORROUT PRINTER ASSOCIATION CHECKBOX On iSeries Access for Windows when creating an 'Associate Printer Session' on the 'Associate Printer' Panel, if the checkbox labeled 'Automatically close the associate printer session when closing session' is selected, the associated printer session will always close and the checkbox will always be UNCHECKED. Whatever options you select before clicking OK will be saved however the selected options will not be shown next time you enter this menu. CIRCUMVENTION: When configuring a display session and accessing the 'Associate Printer' menu, whatever options you select are saved. If you re-enter this menu again, the options selected will not be displayed even though they still apply, so if necessary please select whatever options you want and click the OK button if you want to save them or press the CANCEL button if you want to discard them. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE22769: CA400EXP-OPNAV-DBASE-PERFM SPECIFY QAQQINI FILE FOR ANALYZE The 'Analyze' and 'Compare' functions for large SQL Performance Monitors or SQL Plan Cache Snaphots may take a long time to display the results. The time required to run the analysis can be improved by increasing the parallel processing degree that the analysis queries may use. The CHGQRYA CL command and/or a query options file (QAQQINI) and the SET CURRENT DEGREE SQL statement and the QQRYDEGREE system value influence the parallel processing degree. The user cannot use any of these methods effectively to modify the parallel degree used by the analysis queries. The user may right-click the 'SQL Performance Monitors' or 'SQL Plan Cache Snapshots' folder and select the 'Preferences/Settings for Analysis' menu item. A dialog will appear so that the user can specify a schema for the query options file (QAQQINI). The user can then specify the query options file which contains the parallel processing degree option they wish to use. The query options file refers to the parallel processing degree option with the name 'PARALLEL_DEGREE'. The options will be in effect for iSeries Navigator's analysis and comparison queries for both performance monitors and plan cache snapshots. The query options file is in effect only for the named-database that contains the 'SQL Performance Monitors' and 'SQL Plan Cache Snapshots' folder. In other words, the query options file is in effect only for the analysis queries that use a certain database connection in iSeries Navigator. The user must have job control authority (*JOBCTL) and *USE authority to the CHGQRYA command, or the query options file will be ignored. A query options file may be created in iSeries Navigator by right-clicking a named-database and selecting 'Change Query Attributes'. Select the schema where the file exists, or should be created. Press the 'Edit Options' button to create and/or edit the file. APAR SE22770: CA400EXP-OPNAV-DBASE-INCORROUT SORTING PERFMON AND SNAPSHOT iSeries Navigator does not sort the list of SQL Performance Monitors and SQL Plan Cache Snapshots by date created correctly. iSeries Navigator will sort the list of SQL Performance Monitors and SQL Plan Cache Snapshots correctly by date created. APAR SE22936: CA400EXP-OUTPUT-INCORROUT Precache causes cwbundbs.exe hang When cwbundbs.exe (a part of iSeries Navigator) is launched, the process runs, but no program screen is displayed. APAR SE23087: CA400EXP-OPNAV-MSGCPF2422 Wrong reply with message monitor When a new message monitor is created and the user selects a value to reply with, the wrong value is sent to the server. Code was changed to send the correct reply value. APAR SE23239: CA400EXP- IFS GUI crashes when getting usage of directories In folders with many files and subdirectories, when selecting the properties of an Integrated File System folder, selecting the Use tab and then clicking the "Folder usage..." button, iSeries Navigator retrieves information for a long time and then it crashes. This has been fixed, now the information shows up faster and iSeries Navigator does not crash. APAR SE23263: CA400EXP-OPNAV Disk Management Miscellaneous problems This patch fixes 3 problems: 1. When resynching parity sets, Disk Units status show as 'Active', not 'Synchronizing'. 2. When the cluster is down you cannot deconfigure Geographic Mirroring, but if you try nothing happens, you don't even get an error message. 3. In Graphical View, when choosing to display Device Position a RESOURCEMISSING title appears in every table header. The code will be enhanced to display the resynching status. An error message will be displayed when cluster is down and you try to deconfigure Geographic Mirroring. The "Device Position" header will be displayed instead of "RESOURCEMISSING" APAR SE23288: CA400EXP-OPNAV HISTORY LOG DBCS PARSING When trying to display the history log in iSeries Navigator, double-byte languages, such as Japanese, appear corrupted, or fail to display entirely. A change will be made to correctly display history log information for double-byte languages. CIRCUMVENTION: There is no alternate way to display history log in iSeries Navigator. To view the history log in i5/OS, use the DSPLOG command. APAR SE23295: CA400EXP - Problems in DM GUI when TCP/IP is down When TCP/IP is down and you connect to the iSeries through the Service Tools GUI this happens: If you try to create a new disk pool, then select the Type of Disk Pool and click Ok, nothing happens and you can not continue with the process. When TCP/IP is down, Disk Management will provide the same functionality of Dedicated Service Tools mode. APAR SE23296: CA400EXP-OPNAV-DBASE STRING INDEX OUT OF RANGE: -1 WILDCARD A 'String index out of range: -1' error may occur in iSeries Navigator where wildcards are supported to act on a set of objects. The error occurs when the user enters a single wildcard character for the name ('*'). This affects the search function in Database Navigator as well as the 'Queries that use or reference these objects' filter in the Show Statements dialog. iSeries Navigator will allow a single wildcard character for the name of an object where wildcards are supported. APAR SE23312: CA400EXP-OPNAV-INCORROUT Unable to change Model System When you are doing a Compare and Update of system values, you cannot change the Model System. CIRCUMVENTION: Before you try to change the Model System, you need to open a connection to that system. APAR SE23332: CA400EXP-OPNAV-INCORROUT MRE STACK TRACE ERROR An error message is shown when you try to check the MRE (Monitored Resource Entry) messages of an Administrative Domain. You must have at least 2 Administrative Domains (with their MREs); check the MRE messages of an Administrative Domain, then check the MRE messages of a different Administrative Domain; you may get an error message showing a stack trace. CIRCUMVENTION: Restart iSeries Navigator every time you want to review the MRE messages under an Administrative Domain. APAR SE23401: CA400EXP-OPNAV-NETWORK Missing Virtual Ethernet Ifc Support When opening the properties of a virtual ethernet interface associated to a LAN interface, the properties shows an incorrect address of the interface as associated interface. The properties for the Virtual Ethernet Interface will show the correct associated address of its associated interface. APAR SE23447: TCPIP-MSGCPF3CF1 CREATING THE PPP PROFILE FAILS WITH CPF3CF1 When using DBCS in the description field: For one character, the error doesn't happen. However, the profile is not created. From 2 to 9 characters, CPF3CF1 occurred. From 10 to 24 characters, the error doesn't happen. However, the profile is not created. For 25 characters or more, the following pop up is displayed: The server data cannot be taken out. The problem with creating a PPP profile is fixed by this PTF. APAR SE23507: CA400EXP-OPNAV-DBASE-MSGSQL0443-MSGCPF3224 INDEX ANALYZER Right click a table object and select 'Indexes'. Error MSGSQL0443 may appear in the Index Analyzer if the signed on user does not have authority to the table. The error message may be presented in a number of ways: 1) An error occured while attempting to initialize the list. [SQL0443] UNKNOWN 2) An error occured while attempting to initialize the list. [SQL0443] NOT FOUND 3) SQL State: FFFFF Vendor Code: -443 Message: [SQL0443] UKNOWN ERROR In addition, the job log will contain MSGSQL0443, MSGCPF3224 and MSGMCH1001. iSeries Navigator will display an appropriate authority message when connected to a server at release V5R4M0 or higher with the following server PTFs applied: 5722SS1 V5R4M0 SI20953 5722SS1 V5R4M0 SI19453 MSGSQL0443, MSGCPF3224 and MSGMCH1001 will no longer appear in the job log. iSeries Navigator will display "[SQL0443] UKNOWN ERROR" when connected to a server at V5R3M0 or V5R2M0. Also, MSGSQL0443, MSGCPF3224 and MSGMCH1001 will no longer appear in the job log when the following server PTFs are applied: 5722SS1 V5R3M0 SI19457 5722SS1 V5R2M0 SI19600 APAR SE23618: CA400EXP - Slot D03 on 0595 Tower is not displayed On Disk Management Graphical View, the 0595 Expansion I/O Tower graphic does not show the disk attached to the D03 slot. The disk on slot D03 will be displayed correctly. APAR SE23657: CA400EXP-OPNAV DDM SERVER PROPERTIES ON JAPANESE DBCS Adding specific clients does not retain information with Japanese DBCS iSeries Navigator. 1. Click User connection -> System -> Network -> Server -> TCP/IP 2. Right click on DDM and select Properties(R) on popup menu 3. Select SUBSYSTEM tab 4. Select "Specific client" radio button and Add button 5. Input the description and IP address, and change the SBS then 6. Press OK. Make sure the IP address is shown in specific client box 7. Then press OK button 8. Right click and select Properties on DDM again. 9. The specific client information previously added has disappeared. APAR SE23809: CA400EXP-OPNAV-DBASE-PERFM RSS NO BLOCKS RECS ON CALL PARAMS In Run SQL Scripts, CALL statements without parameters return result sets from the stored procedure faster than a CALL statement that has parameters. Run SQL Scripts uses an updatable cursor when the user executes a CALL statement with parameters. As a result, JDBC does not perform record blocking and retrieving the result set takes longer. CALL statements with parameters will use a read-only cursor that blocks records and improves the performance of CALL statements with parameters. APAR SE23824: CA400EXP-OPNAV-INCORROUT HISTORY LOG MESSAGE PROPERTIES When viewing the history log in iSeries Navigator and there are multiple messages with the sending job and time, the properties for these messages may be displayed incorrectly. The second level text (message help containing the cause and recovery) for a message may display the second level text for a different message in the with the same sending job and time. A change will be made to verify the correct message information is returned when multiple messages are sent in the same second by the same job. APAR SE23825: CA400EXP-OPNAV-DBASE-UNPRED EXPLAIN SQL FROM VE EMPTY ERROR The 'Explain SQL' action from a "User-Defined Table Function" icon in Visual Explain shows a dialog box titled "Exception", but no error message is displayed. A java.lang.NullPointerException will appear in the Java trace. The 'Explain SQL' dialog from Visual Explain will appear as expected or an appropriate error message will appear if the User-Defined Table Function does not exist. APAR SE23835: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY MSGSQL0205 'Column "Time Ended" not in table QAUGDBPMD in QUSRSYS.' may appear when viewing the 'SQL Performance Monitors' or 'SQL Plan Cache Snapshots' folders, or when the user creates an SQL performance monitor or SQL plan cache snapshot. This happens on servers configured with NLV 2962 (Japanese Double-Byte Character Set (DBCS)). It may also appear if the user profile configured to use CCSID 5026 or 290. The user will not see the SQL error message MSGSQL0205 and will be able to get the contents of 'SQL Performance Monitors' and 'SQL Plan Cache Snapshots' folders, create a new SQL Performance Monitor or SQL Plan Cache without problems. APAR SE23837: CA400EXP-OPNAV-DBASE-INCORROUT INDEX FUNCTIONS 1) In the Index Advisor, if the user chooses to create an index, but presses the 'Cancel' button on the 'Create Index' dialog, the Index Advisor will prompt the user with "The index has been created successfully. Would you like to remove the advised index entry?". 2) In the Index Advisor, if the user chooses to create an EVI (Encoded Vector Index) and answers 'Yes' to the "The index has been created successfully. Would you like to remove the advised index entry?" prompt, the EVI is not removed from the list. 3) The Manage Index Rebuilds function in iSeries Navigator may display MSGSQL0204, "An error occurred while attempting to initialize the list. [SQL0204] QADBERAP in QRECOVERY type *FILE not found....". This may happen on a server where no indexes require a rebuild. 4) The 'Create Index' action from an advised index in the Index Advisor will send errors if the table does not exist, the table is a program-described file and other error conditions. The CREATE INDEX SQL statement for the advised index may still be useful to the user, but it is not accessible due to the error. These are solved as follows: 1) If the user cancels the 'Create Index' dialog, the Index Advisor will not prompt to remove the advised index. 2) The Index Advisor will remove the advised EVI from the list at the user's request. 3) Manage Index Rebuilds will display an empty list instead of MSGSQL0204. 4) The 'Create Index' action will show the error message, and then will show the CREATE INDEX SQL statement for the advised index in Run SQL Scripts. For program-described files, this is the only way to create an index in the iSeries Navigator interface. APAR SE23840: CA400EXP-OPNAV-DBASE-INCORROUT NATIONAL LANGUAGE SUPPORT The user may encounter data that is not formatted correctly for their National Language Version (NLV). 1) The units for the 'Maximum Size' field on the 'Access Path Size' tab of the 'Description' dialog are not translated. Also, the unit for 'Total space used for all statistics' on the 'General' tab of 'Statistic Data Details' dialog is not translated. 2) For NLVs that require a comma for the decimal separator, a number of dialogs that display decimal data may use a decimal point including: a) The 'Data Size' on the 'General' tab of the 'Description' dialog b) The 'Total space used for all statistics' on the 'General' tab of 'Statistic Data Details' dialog c) Size limits in the 'Health Center' dialog. d) The LOB output parameter length reported by Run SQL Scripts when the LOB output parameter from a stored procedure has a length greater than 32 KB. e) The progress panel of the 'Export Data' wizard when data is exported to a stream file. f) The size of the data file as reported by the 'Properties' dialog for an SQL performance monitor or SQL plan cache snapshot. 3) Time spinner fields show the English time format instead of the format for the NLV. This affects the following dialogs: a) The 'Queries run after this date and time' filter on the 'Show Statements' dialog b) The 'Queries run after this date and time' filter on the 'New Snapshot of SQL Plan Cache' dialog iSeries Navigator now respects the PC NLV settings. APAR SE23846: CA400EXP-OPNAV-DBASE-INCORROUT IMPORTING FIXED FORMAT DATA 1) The browse dialog for the field definition file in the 'Import Data' wizard is primed with the user's selection for the data file, regardless of what is currently chosen for the field definition file. 2) MSGCPF2817 "Copy command ended because of error" may occur in the 'Import Data' wizard if a relative path is specified for the field definition file (e.g. 'QSYS.LIB/MYLIB.LIB/MYFILE.FILE'). The job log will also contain MSGCPF2885 "Field Definition or Error file NULL in NULL not allowed". The 'Show Command' button on the wizard will report the FLDDFNFILE parameter of the CPYFRMIMPF command as "FLDDFNFILE(null/null *FIRST)". 3) The 'Import Data' wizard is specifying RCDDLM(*NONE) on the CPYFRMIMPF command when the user selects 'None' as the row delimiter. As a result, the user-specified value for 'Maximum row length' and STMFLEN parameter of the CPYFRMIMPF command is ignored. *NONE is not a defined value for the RCDDLM parameter. The user's data may not import correctly. These are solved as follows: 1) The priming of the browse dialog for the field definition file does not depend on the data file. 2) The field definition file will be correct when a relative path is specified by the user. 3) The wizard will use RCDDLM(*EOR) when the user selects 'None' for the record delimiter. As a result, CPYFRMIMPF will use the STMFLEN parameter to determine where each row in the data file ends. APAR SE23847: CA400EXP-OPNAV-DBASE-INCORROUT SQL PERFORMANCE FUNCTIONS 1) The SQL queries produced by the 'Modify Statements Query' button on the 'Analyze' dialog may contain unexpected literal values. The value '/* VVVVVVVVVV */' may appear instead of the expected value from the summary data. 2) The 'Overview/SQL Statements' summary results on the 'Analyze' dialog may fail to sort by the 'Statement Text' column. This is caused if any of the statement text values are null, which appears as a blank value in the results. A java.lang.NullPointerException will appear in a Java trace. 3) If the user selects one of the rows in the summary data tree and then collapses the tree, the buttons and menu items of the 'Analyze' dialog will become unresponsive. The 'Analyze' dialog cannot be closed unless iSeries Navigator is closed. A 'java.lang.ArrayIndexOutOfBoundsException: 0' or 'java.lang.NullPointerException' error will appear in the Java trace. 4) The 'Show Statements' dialog for an SQL Plan Cache Snapshot sorts the 'Last Time Run' incorrectly. The values are sorted as text instead of time data. 5) The 'Save As' menu item and the flyover help for the 'Save' menu item and toolbar icon in Visual Explain are incorrect for an SQL Plan Cache Snapshot. Each item refers to the object as an SQL Performance Monitor. 6) The 'Explainable Statements' dialog does not appear when the user selects the 'Monitor/Show Statements' menu item in Run SQL Scripts. This happens when the Run SQL Scripts session is connected to a pre-V5R4M0 server. "java.lang.ClassCastException: javax.swing.JDialog" will appear in the Java trace. 7) MSGSQL0510 "Cursor x for table QAQQINI read-only" will occur if attempting to edit the Query Options File (QAQQINI) in the 'Change Query Attributes' dialog. These are solved as follows: 1) The 'Modify Statements Query' button will produce SQL queries with the expected literal values. 2) The 'SQL Statements' summary results will sort correctly if null statement text is present. 3) The 'Analyze' dialog will operate correctly after collapsing the summary tree. 4) 'Show Statements' will sort columns with time and date information correctly. 5) The menu item and the associated flyover help will refer to an SQL Plan Cache Snapshot, instead of an SQL Performance Monitor. 6) The 'Explainable Statements' dialog will appear. 7) The user can edit the query options file. APAR SE23864: CA400EXP-OPNAV DUPLICATE TAPE USES WRONG FROMVOL Duplicate Tape is issued using *MOUNTED instead of the selected "From Volume" from the virtual tape Work with Volumes list. The Tape code has been changed to use the correct Volume List entry on a Duplicate Tape. APAR SE23941: CA400EXP-OPNAV-NETWORK RAS Profile connections may fail Attempting to open the connections for a remote access profile may cause unexpected behaviors, including crashes. APAR SE23946: CA400EXP-OPNAV-NETWORK UCW fixes for ECC support Various issues existed when configuring ECC with UCW prior to this PTF. Issues include broken and unusable connection profiles, support server start problems, and other minor issues. -- Service and Support Proxy start order causes changes made to not take affect. -- Line pool creation may fail in CAP scenarios. -- Incorrect defaulted data. -- Saving incorrect configuration data. -- Incomplete country selection choices on some panels. APAR SE23965: CA400EXP-OPNAV-NETWORK AC3 not required for V5R4 VPN server In V5R4, the AC3 program product is no longer required by the VPN server. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE22760: CA400EXP-DTRANSFER - Vertical aligment incorrect for HTML When doing a Data Transfer to an HTML document, the customer sets Horizontal and Vertical text alignment. After the HTML document is created, the vertical alignment setting does not seem to have been honored. APAR SE23381: CA400EXP-DTRANSFER-INCORROUT DATA TRANSFER TO PRINTER A wrong behavior results when the "Convert CCSID 65535" option in the Conversion tab of the Properties dialog box is selected and the Output Device in the main dialog box is set to "Printer"; whether the option is selected or not, data is always transferred in HEX and in EBCDIC (the conversion doesn't take place). APAR SE23668: CA400EXP-DTRANSFER Customized sheet names for Excel files User's application requires Microsoft Excel sheet names to be sheet1, sheet2, etc. but iSeries Access uses the file name as sheet names. This PTF fixes the reported problem. Considerations: - By activating this feature it's possible to customize the name of the sheets of Excel files generated through the Data Transfer From GUI ONLY. - This feature is available ONLY for biff5, biff7 and biff8 formats. - Customized names can ONLY be ANSI strings. UNICODE strings are NOT SUPPORTED. This feature is activated through an INI file (plain text) named CWBTFR.INI. It must reside in the Windows directory (which may be c:\windows, c:\winnt, etc., depending on how and what version of Windows is installed) and it must contain a section like this: [Client Access Data Transfer] BaseSheetName=custname where custname can be any string of up to 10 VALID CHARACTERS. Create the file if it doesn't exist or just add the above section if it already exists. NOTE: Characters such as \,/,?,[,] or * are not allowed. This is an Excel restriction. APAR SE24030: CA400EXP-DTRANSFER A CRASH OCCURS WHEN BROWSE FOR LIBRARIES The Data Transfer To iSeries crashes when the user presses the "Browse" button to search for libraries in the iSeries. This problem only happens when the application is run by right clicking in any explorer windows and selecting the options: "New -> Data Transfer to iSeries Server" from the pop-up menu. APAR SE24081: CA400EXP-DTRANSFER INCORRECT CELL TEXT ALIGNMENT IN HTML An incorrect cell text alignment happens when the user transfers to an HTML file. Regardless of the alignment selected from the "Text Data" option in the "Cell" tab of the "HTML Details" dialog box, text is aligned exactly like numeric data. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE23267: CA400EXP-DTRANSFER-WAIT DATA TRANSFER EXCEL ADD-IN HANGS Uploading or downloading database files from Microsoft Excel using the iSeries Access for Windows Data Transfer Excel add-in hangs during the transfer. This problem is complex and not all causes are known at this time. This PTF fixes some failure cases, but not all, and perhaps not all the time. ODBC ---- APAR SE22732: CA400EXP-ODBC-PERFM RESULTS SETS ARE RETURNED WITH BLOCKING Currently, when using a Sensitive cursor type in an iSeries Access ODBC application, results sets will be returned with blocking of one row. This can negatively impact performance. This change will allow the iSeries Access ODBC provider to do block fetches of data when the SQL_ATTR_CONCURRENCY attribute is set to SQL_CONCUR_LOCK and the Database host server indicates that the cursor is Read-only. APAR SE22932: CA400EXP-ODBC Support loosely-coupled XA transactions The ODBC driver currently supports loosely coupled XA/MTS transactions, but does not have the ability to share locks across the loosely coupled transaction branches. An enhancement is needed to provide in this support. New keywords and a new connection attribute will be added to control the locking with loosely coupled distributed transaction branches. Note, this support requires a V5R4 iSeries. The new keywords can be set in the ODBC DSN using the cwbodbcreg.exe tool or passed in on the SQLDriverConnect connection string. The new keywords are: XALCS or XALooselyCoupledSupport Setting this keyword affects whether locks are shared between loosely coupled distributed transaction branches. Possible Values: 0 = Locks are not shared 1 = Locks are shared Default Value: 1 Alternatively, you can activate this new support by calling the SQLSetConnectAttr API and setting the 2144 attribute. The 2144 attribute expects that an unsigned integer value be passed in. Setting this to 0 indicates to not share locks. Setting this to 1 will share locks. The default behavior is 1 which is to share locks. APAR SE23227: CA400EXP-ODBC-INCORROUT POUND STERLING SYMBOL IN ODBC DS Illegible characters are saved in the "SQL Default Library" parameter in an iSeries Access for Windows ODBC DSN when using the pound sterling symbol as the first character in an OS/400 library name. This occurs in iSeries Access V5R2M0 and V5R3M0. APAR SE23930: CA400EXP-ODBC-INCORROUT Improved Delimited Names Support The ODBC driver is not consistent with how it returns delimited identifier names back to the application. An example of a delimited identifier name is "MyTable" where "MyTable" is the name of a table on an iSeries. Some applications, such as Microsoft Excel, generate SQL statements based off the identifiers the driver returns. These applications build invalid SQL statements if the driver does not return the names in a particular way. To make these applications work better and to be more consistent, an enhancement is being provided. A new keyword is being added that will give the application the ability to affect how delimited identifier names are returned to it. Keyword: DelimitNames Description: This keyword controls how the driver will return delimited identifier names back to the application. This setting affects the following catalog APIs: SQLTables, SQLColumns, SQLSpecialColumns, SQLPrimaryKeys, SQLForeignKeys, SQLSpecialColumns, and SQLStatistics. It also affects how the driver returns identifiers for the SQLColAttribute, SQLDescribeCol, and SQLGetDescField APIs. If set to 1, the driver would return a table name of "MyTable" as "MyTable" instead of as MyTable. Values: 0 = Return undelimited identifier names to the application 1 = Return delimited names to the application Default Value: 0 Notes: - To set this keyword you can specify "DelimitNames=1;" in the SQLDriverConnect connection string. If you can not modify the application, you can use the cwbodbcreg.exe tool found on your machine in the \Program Files\IBM\Client Access directory. To use cwbodbcreg.exe, open a DOS command prompt, navigate to the \Program Files\IBM\Client Access directory, and then run the following (replacing MYDSN with the ODBC DSN you want to update): cwbodbcreg MYDSN DelimitNames 1 - When working with MS Excel you will need to set the DelimitNames keyword to 1 if you have identifiers that are delimited. OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE22266: CA400EXP-IDB2DATA Item has already been added to collection An application uses the .NET provider with Crystal Reports. Sometimes while trying to connect to the database server, the application receives the following exception: ArgumentException: Item has already been added. The exception's StackTrace shows the exception originates from: System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) APAR SE22506: CA400EXP-IDB2DATA .NET Provider with .NET Framework 2.0 When using the IBM.Data.DB2.iSeries .NET provider with .NET Framework 2.0, an ObjectDisposedException occurs when the application terminates, with a message indicating "Safe handle has been closed." This problem occurs because of an incompatible change made in the .NET Framework. This PTF fixes the reported problem. Note that this is not an official support statement for .NET Framework 2.0. Future compatability with .NET Framework 2.0 is not guaranteed. APAR SE23880: CA400EXP-IDB2DATA-MSGCPD0005 Trace - wrong decimal separator An error occurs when the managed provider connection attempts to use iDB2TraceOptions on a system where the client is using a locale setting for German (or any culture setting that uses something other than the '.' character for the decimal separator). The command that is sent to the server to perform the trace is using the wrong decimal separator in the call it makes to QCMDEXC. This results in an error message CPD0005 in the QZDASOINIT job. The problem can be circumvented by setting the PC locale to English. CIRCUMVENTION: Set the PC locale to English, or don't use Trace in the ConnectionString. APAR SE24056: CA400EXP-IDB2DATA Server trace fails with system naming When setting both Naming=System and Trace in the ConnectionString, the provider does not properly use the slash / separator when turning on host traces. As a result, traces are not produced. CIRCUMVENTION: Don't use both Trace and Naming=System in the ConnectionString. 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 When try to display SO/SI by Ctrl+F1 key with Japanese keyboard after input specific characters as below. Shift_JIS code |x/A2 |x/A3 |x/A5 EBCDIC |x/43 |x/44 |x/46 Replaced by(EBCDIC)|x/4A(Cent)|x/B1(Pound)|x/B2(Yen) Use HostCodePage 930 and 939 session for recreate this problem. 1) Change input mode to DBCS KANA mode (FEP ON). 2) Input japanese kakko sign (EBCDIC x'4342'). 3) Execute F8 key to change it to SBCS sign. 4) Do Ctrl+F1 to show SO/SI sign after determine the character. Above 3 sign are appeared as garbage to each different sign. This problem is not seen when the display only has SBCS characters and the session host code page set to 1399. We also confirmed incorrect behavior with system display with following operation. 1) Do 'WRKJOB' command for display 'Work with Job' menu. 2) Select Opt.12 to show 'Work with locks' display. 3) When it appears, depress Ctrl+F1 to show SO/SI sign. The display appears as garbage. APAR SE23367: CA400EXP-TERMEMUL-UNPRED LONG NAME MACRO IN .PMP In V5R3M0, the Pc5250 macro is 'Not Found' once the customer edits the .pmp file to reflect the long file name. The macros still work fine when they are found by using the Windows short file name. APAR SE23503: CA400EXP-TERMEMUL-INCORROUT DBCS PASTE ADDS SBCS BLANK V5R3M0 service pack SI20055 introduced a problem with Pc5250 when the DBCS Copy/Paste function is used. One SBCS blank ("40")is being added for each "0E" and "0F" SO/SI character when pasted. 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 Using iSeries Access V5R4, a LAN connect attempt may result in a fault "exception in cwbopaoc.exe" when the Windows Remote Access Connection Manager (RasMan) service is disabled. The fault is resolved. CIRCUMVENTION: Right click on My Computer and choose Manage. This brings up the Computer Management application. Locate and open Services under Services and Applications. Locate the service "Remote Access Connection Manager" which is also known as RasMan. Right click and choose Properties. On the General tab, ensure the Startup type is either Automatic or Manual (not Disabled). On that same tab one can then press the Start button to start the service. 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 RMTCMD was updated to take advantage of a new message level on the host side (x'02' - return all messages). The return all messages option also returns messages from both the server and program message queues, whereas previous host levels and message levels only returned information from the server queue. This additional message source (program queue) can cause a previously working RMTCMD to return an error level higher than 00. This can cause some client applications to abnormally end. The remote command (RMTCMD.EXE) and remote program interfaces (CWBRC.H) have been changed to allow a more complete list of job messages to be returned. For RMTCMD.EXE, this might cause a different exit ERRORLEVEL to be returned depending on the severity of any newly included job messages. To enable the old behavior for a given PC process, set up an environment variable called CWB_RMTCMD_V5R2_MSG=*ALL or a process name. For example: CWB_RMTCMD_V5R2_MSG=rmtcmd.exe will enable the old behavior for rmtcmd.exe. *ALL would enable the old behavior for all processes within this environment variable scope. CIRCUMVENTION: Job messages can be removed from the returned list by calling RCVMSG MSGTYPE(*EXCP) RMV(*YES) during normal MONMSG processing routines. 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 In V5R3 a change has been made to have the Stored Procedures compiled to use the *CALLER activation group to run under compiled level for every transaction instead of isolation level set by the application, As a result, an unexpected isolation level may be used. Support has been added to enable Stored Procedures that are compiled to use the *CALLER activation to pick up the isolation level set by the application using SET TRANSACTION. 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 Character data right truncation error when iSeries ODBC driver converts an exponential or scientific number from SQL_C_CHAR to SQL_DECIMAL Example: 8.16e+007 which equals 81600000. The iSeries ODBC Driver does not support the conversion of scientific number from SQL_C_CHAR to SQL_DECIMAL. In order to have same functionality as other DBMS, support to convert exponential or scientific number from SQL_C_CHAR to SQL_DECIMAL was added. CIRCUMVENTION: If posible change the application to convert from SQL_C_FLOAT 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 The .NET Provider usually does an implicit Prepare of commands when one of the iDB2Command's Execute methods is called. In many cases, this implicit Prepare is unnecessary, and results in extra data flowing to and from the iSeries server each time a command is executed. The provider should only implicitly Prepare commands when a Prepare is necessary. This PTF fixes the reported problem. The provider will still implicitly Prepare commands that need to be prepared, but it will no longer implicitly Prepare commands that don't need to be prepared. If the application repeatedly runs a command and wishes to ensure the command gets Prepared, it can call the iDB2Command.Prepare() method to prepare the command before executing it. 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 iSeries Access for Windows PC5250 needs client-side control on commands issued via the STRPCO/STRPCCMD server commands. PC5250 will allow users to disable STRPCCMD through a new WS profile keyword, "Ignore_STRPCCMD". Users can edit a .ws file to add the following to the [5250] section of the .ws profile to enable/disable STRPCCMD. The keyword can have values 'Y' and 'N' with the default being 'N' to allow the STRPCCMD command. Users who want to block STRPCCMD will have to set the keyword to 'Y'. The keyword can be set as follows: [5250] Ignore_STRPCCMD=Y When the keyword is set to 'Y', PC5250 ignores the parameters associated with STRPCCMD and simply sends back to the server an Enter key to refresh the screen. CIRCUMVENTION: Control access to STRPCO and STRPCCMD commands via iSeries authority permissions. 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 When using the Monotype Sans Duospace WT font in a PC5250 session, the capital "O" and number zero cannot be differentiated. This will be fixed by providing a new font that differentiates the capital "O" and zero characters. This new font is named "PComm Session" and the file is pcommsess.ttf . During install, the previous True Type Font file "Monotype Sans Duospace WT" (file name mtsandw.ttf) will be deleted. Any users that previously were using the Monotype Sans Duospace WT font for a higher resolution display, will automatically be switched to the default IBM3270 font. Those users that want to return to using a True Type Font or start using a True Type Font for the first time, need to follow the instructions for the Select Display Font dialog included in the following revised text from APAR SE18848: A change from raster (bitmap) fonts to True Type Fonts will be made. True Type Fonts are scalable and display text well at higher resolutions. This new feature will be implemented only for English and West European languages (PC codepage 1252). No other languages will support these higher resolutions. New monospaced True Type Fonts containing all the characters from the current IBM3270 raster font will be installed in the PC5250 installation folder. -- PComm Session (pcommsess.ttf) (for displaying text) -- PCOMMAPL (pcommapl.ttf) (for displaying APL characters like box drawing, scrollbars, etc) IBM3270 will still be the default font. The new PComm Session font (pcommsess.ttf) will need to be selected by the user via the Select Display Font dialog. Whenever the Pcomm Session font is selected, PC5250 will automatically select PCOMMAPL (pcommapl.ttf) as the APL font. Note: Operator Information Area (OIA) fonts will not be changed. At higher resolutions, characters displayed in the OIA might appear smaller than the PC5250 window text. APAR SE21646: CA400EXP-TERMEMUL-INCORROUT POPUP MENU BAR OPERATION If the Menu-Bar is hidden, and the Popup Menu-Bar is used, duplicate menu items can result. For instance, if Communication-> Configure is selected, and then the resulting panel is closed, the next time a right click is done on the title bar, multiple Popup Menu-Bar menu items appear, and within those, multiple duplicate menu items. Also, during this process, if the emulator window is maximized, it will be restored to non-maximized form, rather than staying at the desired maximized position. 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 Update Secure Sockets Layer (SSL) component to level GSkit 7.0.3.18 . This PTF updates SSL to the new level. 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 SI22257 item, and then click on the Change/Remove button. 4. Follow the instructions on the screen. 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- InstallShield is the tool used to provide the install support for iSeries Access for Windows. The same tool is used for installing service packs. Setup.exe has a 2 minute timeout to initialize to the first wizard panel, which could expire when installing service packs over very slow communication lines. 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.