============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R4M0 Cumulative Service Pack Level ------------- SI23696 ------------- (c) Copyright IBM Corporation 2006. All rights reserved. ======================================================================== Co-requisite PTF SI23697 is automatically included with any shipment or web download of SI23696. SI23697 exists only for packaging reasons. All service pack level references will be to SI23696. SI23696 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 = SI23696 (May 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. 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. 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 = SI23696 Build date = May 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE24562: CA400EXP-OPNAV HANDLE LEAK IN APPLICATION ADMINISTRATION Semaphore handle leaks in Application Administration, while executing distributed transactions through Microsoft Distributed Transaction Coordinator (MSDTC). APAR SE24598: CA400EXP-OPNAV-INCORROUT extended attributes trap in IFS iSeries Navigator could fault when browsing the IFS tree if files contain large extended attributes. APAR SE24713: CA400EXP-INSTALL-INCORROUT INSTALL SAME SERVICEPACK TWICE If the .NET Data Provider component is installed, a service pack install error (-112) can occur if the following conditions are met: -- The same service pack is installed twice on the same PC -- Must select the Enable Service Pack Uninstall option during each install -- The AFP Printer Driver component must be installed on the PC and have fixes present in the service pack. RESOLUTION: This problem will be fixed when the service pack representing this PTF is installed. CIRCUMVENTION: If encountering this problem, delete the following file and run the service pack install again: C:\Program Files\IBM\Client Access\Archive\mp.msi Note: the directory path up to the \Archive subdirectory may vary based on the installation path chosen for iSeries Access for Windows. APAR SE24726: CA400EXP-ODBC-INCORROUT SQL BIG-ENDIAN UTF16 WITH 'XXFF' When executing the SQL statement containing the character of 'xxFF' in Big-endian UTF16, the record is updated incorrectly. For example, they are x'52FF', x'59FF', x'5BFF', x'67FF', x'7AFF' in UTF-16 big-endian. If one of these characters is in the first position in the string, it is converted into '6F' without SO/SI. In the other case, it is converted into 'FEFE'. RESOLUTION: The Unicode to Mixed Ebcdic converter will be fixed to allow 0x**FF characters to be converted correctly. APAR SE25099: CA400EXP-COMM-MSGCWBSY1040 Windows credentials not found A connection to an iSeries server is configured to use Windows logon information for the iSeries credentials. Either always or intermittently, using functions that communicate with this iSeries results in the message "CWBSY1040 - Windows logon credentials are unavailable" being displayed. APAR SE25422: CA400EXP-TERMEMUL NO PC5250 SOUNDS AFTER V5R4 INSTALL PC5250 does not make sounds after installing V5R4M0 iSeries Access for Windows to a new PC. RESOLUTION: pcssnd.exe will be executed when installing iSeries Access for Windows. This will enable PC5250 sounds on the computer. Especially when a new installation is performed or when upgrading from releases prior to V5R3M0. CIRCUMVENTION: Run pcssnd.exe from a Windows Command prompt. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE24032: CA400EXP-OPNAV-DBASE-INCORROUT INDEX ADVISOR EMPTY WITH IASP The Index Advisor does not show index advice for tables or schemas that are in the system (SYSBAS) database and viewed from an Independent Auxiliary Storage Pool (IASP) database in iSeries Navigator. Index advice is shown as expected for the objects when launched from the SYSBAS database. The 'Clear All Advised Indexes' and 'Prune Advised Indexes' actions of the Index Advisor will also not remove data from the list as expected. RESOLUTION: Index Advisor is querying the QSYS2000xx.SYSIXADV table in the IASP database (where xx is the ASP number). This table only contains information for the current database. As a result, the Index Advisor erroneously shows that no indexes are advised, or does not remove advised indexes from the table upon request for the SYSBAS schema or table. Index Advisor will operate as expected for SYSBAS schemas and tables when it is working from an IASP database. CIRCUMVENTION: Launch Index Advisor through the SYSBAS database for schemas and tables that exist in the SYSBAS database instead of the IASP database. APAR SE24173: CA400EXP-OPNAV-MSGCWBNL0107 EDIT TABLE CONTENTS DBCS BLANKS The 'Edit Contents' dialog does not allow the user change contents on DBCS columns. It happens on GRAPHIC or VARGRAPHIC columns, when trying to update it with only DBCS blanks or if the column is not NULL and contains only blanks. It fails with CWBNL0107 error message. The two cases in which the dialog fails are: 1) If the column contains only DBCS blanks (gx'4040') and the user updates it or another column in the same row with any DBCS character. 2) The user changes a column to all DBCS blanks, no matter what the column's original value was. RESOLUTION: User will be able to edit contents of tables that contain GRAPHIC or VARGRAPHIC columns without getting the CWBNL0107 error. APAR SE24176: CA400EXP-OPNAV-DBASE-INCORROUT ACCESS PLAN REBUILD COUNT Access plan rebuild information from analysis tool for a SQL Performance Monitor is not giving correct results. The 'Total Access Plans Rebuilt' column on the results shows values based on how many times the ODP (Open Data Path) was reused instead of how many QQRID = 3006 records are in the SQL Performance Monitor's control file. This information is available from 'Detailed Results' tab and selecting 'Access plan rebuild information' box of the 'Analyze Results' option of the monitor's contextual menu. RESOLUTION: 'Database Performance Monitor Access Plan Rebuild Information' dialog will show the correct value on the 'Total Access Plan Rebuilt' column based on how many QQRID = 3006 records are in the performance monitor's control file. APAR SE24257: OSP-DB-MSGCPFA0A2 ACCESSING PERMISSIONS FROM ISERIES NAVIGAT When accessing the permissions for a stored procedure where the program is in the QSYS library, an error message with CPFA0A2 will be issued. RESOLUTION: The problem is occuring because the full IFS path for the stored procedure is being generated incorrectly prior to issuing the request from iSeries Navigator. '/QSYS.LIB/QSYS.LIB/QCMDEXC.PGM' is being generated which is causing the error message to occur. The code will be updated to generate the path as: '/QSYS.LIB/QCMDEXC.PGM' APAR SE24550: CA400EXP-OPNAV-DBASE-INCORROUT REORGANIZE TABLE INFORMATION The reorganize table progress dialog displays the wrong value for the Reorganize the table by: information when the By compressing out deleted rows option was selected on the reorganize dialog. If the Preserve arrival sequence was checked, the value displayed was Replacing deleted rows, but the correct value to display should have been Compressing out the deleted rows. If the Preserve arrival sequence was left unchecked, the value displayed was Compressing out the deleted rows, but the correct value to display should have been Replacing deleted rows. RESOLUTION: The correct values will now be displayed. APAR SE24551: CA400EXP-OPNAV-MSGCPD8ED5-MSGCPF2718 When adding VE to NWSD When using the Virtual Ethernet tab on the Server property sheet to add a virtual Ethernet port, the operation sometimes fails with message CPD8ED5, followed by message CPF2718. APAR SE24625: CA400EXP-OPNAV- Export LPAR configuration to IFS fails 1. In iSeries Navigator tree, click on Configuration and Service and then right click on Logical Partitions. 2. Type the Service Tools username and password. 3. From the Logical Partitions context menu select 'Export to IFS'. 4. Select Yes from the prompt dialog. 5. An error message appear with this text: "com.ibm.as400.access.AS400SecurityException: Password is not set." RESOLUTION: This fix will reenable this function. APAR SE24642: CA400EXP- Disks on 5787 expansion unit are not displayed On a system with an attached 5787 expansion unit and with disks on any of the positions from P1-D1 to P1-D9 and P2-D1 to P2-D9 1. In iSeries Navigator tree, click on Configuration and Service->Hardware->Disk Units. 2. Type the Service Tools username and password. 3. Right click on All Disk Units and select Graphical view from the context menu. 4. You will not see highlighted any of the units listed above. RESOLUTION: This fix will display all the Disk Units correctly. APAR SE24710: CA400EXP-OPNAV-INCORROUT History Log msgs of < 5 chars gone The history log that is displayable within iSeries Navigator is currently not showing messages of less than 5 characters in length. This occurs both within the iSeries Navigator client application, and also via the web task (task=dsplog). APAR SE24711: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY MSGSQL0206 'Column "Name" not in specified tables.' may appear on SQL Performance Monitor when 'Analyze...' option of the context menu is selected. This happens on servers configured with NLV 2962 (Japanese Double-Byte Character Set (DBCS)). It may also appear if the user profile is configured to use CCSID 5026 or 290. APAR SE24873: CA400EXP-OUTPUT-INCORROUT WHEN EXPORT MONITOR DATA FROM INAV Exporting data on iSeries Navigator System Monitor and using CSV and ASCII (txt) file formats may result on incorrect output when working with DBCS languages. Problem may also be found on other export actions within Management Central. RESOLUTION: Code was modified to correctly write into a File on CSV and ASCII(txt) formats when using DBCS languages. APAR SE24882: CA400EXP-OPNAV-JOBS-INCORROUT CURRENT SQL STATEMENT STATUS When selecting a Job that contains SQL statements from the Current SQL for a Job dialog and pushing the SQL Statement button on the dialog, the "SQL statement for selected job" display area will show the incorrect status for the statement. If the statement is no longer running it will show the status of "Statement currently running as of ..." when it should show "Last statement to finish as of ...", and if the statement is currently running it will show the status of "Last statement to finish as of ..." when it should show "Statement currently running as of ...". RESOLUTION: The current SQL for a Job dialog will show the correct status information for the SQL Statement. APAR SE24894: CA400EXP-OPNAV-NETWORK-MSGDATA DATA ENTRY ERROR MESSAGE When opening iSeries Navigator, select: - Network - Servers - User-Defined - IBM DIRECTOR - Right click - Deselect "Start when TCP/IP is started" - OK An error message reads "Data Entry error message - The server name is not valid" Changing the default name "IBM DIRECTOR" to "IBM_DIRECTOR", the "OK" is accepted. APAR SE25008: CA400EXP-OPNAV-DBASE EXPLAIN SQL FROM VISUAL EXPLAIN The 'Explain SQL' dialog may show information from a different "User-Defined Table Function" (UDTF) than the one the user wants to explain from Visual Explain. If the schema, where the UDTF the user wants to explain, has more than one function, the dialog will show the last function in the schema alphabetically listed. RESOLUTION: The 'Explain SQL' dialog from Visual Explain will now show the correct information from the User Defined Table Function. APAR SE25012: CA400EXP-OPNAV-DBASE PREFERENCES IN RUN SQL SCRIPTS ARE LOST Run SQL Scripts window may lose user preferences. When you change settings they should be kept even after you close Run SQL Scripts and bring it up again, but this may not happen. Here are some things that are affected by user preferences: - Font and dimension window - JDBC setup dialog - etc. You may see that doing the following steps: 1) Open iSeries Navigator 2) Open RSS 3) Close RSS 4) Open RSS stand alone and change the font, dimension, etc. 5) Open RSS from the still running iSeries Navigator. You will get the old settings. APAR SE25014: CA400EXP-OPNAV-DBASE-INCORROUT TIMESTAMP ON SHOW INDEXES The time portion of the Last Used Date column on the Show Indexes dialog is not valid. RESOLUTION: The time portion of the Last Used Date column on Show Indexes will no longer be displayed. APAR SE25050: CA400EXP-OPNAV-NETWORK-INCORROUT IPv6 GUI problems There are 2 problems in the New IPv6 interface wizard, both on the Attributes page: - Duplicate Address Detection (DAD) default should be 1 (currently blank) - fix 'dupplicate' spelling error RESOLUTION: The IPv6 Wizard will show the correct Label in the Duplicate Address Detection (DAD) checkBox, and also will have "1" as the default value of Maximum Transmits for DAD. APAR SE25054: CA400EXP-OPNAV Error setting spooled file expiration date Attempting to set a spooled files expiration date using the date push button, results in an error message. APAR SE25068: CA400EXP-OPNAV-DBASE-INCORROUT INVALID COLUMN ID ON INDEXES Showing indexes for a table does not display the correct information for some of the columns of the dialog. It displays 'Invalid column ID: xx' instead of the correct data. RESOLUTION: Indexes dialog now shows the correct information for the columns. APAR SE25104: CA400EXP-OPNAV-DBASE SHOW STATEMENTS DIALOG DIMENSION The dimension of the 'Show Statements...' dialog does not fit in a 1024x768 screen resolution. The dialog may also display multiple scroll bars which make it uncomfortable to use. It is difficult to adjust the dialog to an optimum size. RESOLUTION: The 'Show Statements...' dialog will fit in a 1024x768 screen resolution and will not display horizontal scroll bars in the split pane. APAR SE25107: CA400EXP-OPNAV Error code 7 on mirror synchronization on IPL On iSeries Navigator tree when right clicking on Disk Units and selecting 'Mirror Synchronization on IPL disabled' and/or 'Mirror Synchronization on IPL enabled' an error message comes up: 'Error Message: Session needs to be opened (Error code: 7)' RESOLUTION: This fix will perform the action with no errors. APAR SE25123: CA400EXP-OPNAV Unable to add nodes to administrative domain When adding a node to an administrative domain, sometimes the message "No other nodes are available in this cluster" is shown, even if there are other active nodes in the cluster which are not in the recovery domain of an administrative domain, and therefore those nodes should be listed as available nodes. CIRCUMVENTION: Delete the administrative domain and create a new one that includes the nodes that have to be added in its recovery domain. APAR SE25124: CA400EXP-OPNAV CHANGES TO ADMIN DOMAIN NOT PRESERVED If you try to add or remove a node from an existing administrative domain, the administrative domain is not changed, but you get no error messages. Steps to recreate: 1. Create an administrative domain with at least two nodes 2. Go to Clusters->Cluster Name->Peer Resources-> Admin domain name->Properties 3. Select a node in the admin domain, and click on Remove 4. Click Ok 5. Go to Clusters->ClusterName->Peer Resources-> Admin Domain name->Properties. You will see that the node was not removed from the administrative domain. RESOLUTION: Delete the existing administrative domain and create a new one with all the nodes that should be part of it. APAR SE25125: CA400EXP-OPNAV-INCORROUT Cannot stop cluster You must have a cluster with at least two nodes; try to stop the cluster by doing right click and selecting from the context menu the option "Stop..." The process may be not completed and in this case you will receive the message "Cluster Resource Services not active or not responding.", you will note that the cluster nodes information was not refreshed and if you do a refresh you will realize that not all the nodes were stopped. CIRCUMVENTION: Connect to a node using a 5250 session, check if it is active using dspcluinf command and if it is not, switch to one that is active. Do the following: 1. Stop all the Cluster Resource Groups in this suggested order: Application, device, data and peer; using the endcrg command (use dspcrginf command to check which ones are active). 2. End all the nodes that are started using the endclunod command (use dspcluinf command to check which ones are active). End the node where you are executing the commands last. For further help on the commands, please refer to iSeries Information Center. APAR SE25235: CA400EXP-OPNAV User name/password not correct on initialize The userid and password on the initialize command is not being quoted, end result is the text will be set to uppercase on the set command. RESOLUTION: The user id and password are now being built as quoted strings to maintain the proper case. The synchronize option is now the default action when bringing up the initialize service processor panel. APAR SE25236: CA400EXP-OPNAV Upper case CHAP name shown in mixed case When a new remote system configuration is created with iSeries Navigator that was based on an existing remote system configuration, the CHAP name in the new remote system configuration is capitalized. However, if you save the new remote system configuration, the CHAP name is not capitalized. This is confusing to the user. RESOLUTION: CHAP name will now be displayed in the proper format. APAR SE25298: CA400EXP-OPNAV LOAD IMAGE CATALOG PANEL Via iSeries Navigator, the following tape-related problems exist: 1) If you connect to a system that has no available virtual tape devices and select "Load Image Catalog..." from the context menu, no window is displayed. 2) If you connect to a system that has only one stand-alone tape device available, and select "Duplicate..." from the context menu, no window is displayed. 3) When creating the first Image Catalog on a system, and Reference Catalog is selected, the combo box list is empty and selecting OK may cause a long wait. 4) When all Image Catalogs on the system are in a Loaded status, no window is displayed when selecting "Load Image Catalog...". RESOLUTION: The Tape media code has been changed to correctly display the windows. APAR SE25299: CA400EXP-OPNAV-DBASE-INCORROUT SHOW STATEMENTS SORT COLUMNS The Show Statements dialog may not correctly sort the information for numeric columns. It may happen when the numeric values differ in length and they are treated as string values. Basically, this may happen with numeric columns that have floating point data and distinct length of digits between the rows listed. RESOLUTION: The Show Statements dialog will correctly sort the statements listed using a numeric column. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE24961: CA400EXP-DTRANSFER USERID NOT SAVED CORRECTLY IN DTT FILE The "User ID" field in the "Connection" tab of the "Properties" dialog box is not saved correctly in the DTT file when the option "Specify a User ID" is selected. APAR SE25102: CA400EXP-DTRANSFER UNEXPECTED ERROR IN EXCEL WIZARD After finishing the Data Transfer Excel Add-in wizard, the user gets an unexpected error "CWBDB0036 - Server returned SQL error SQL0104" instead of "CWBTF0060 - A member name must not be specified for this type of operation" while filling in the library/file name, because a member is not expected. RESOLUTION: Message "CWBTF0060 - A member name must not be specified for this type of operation" will be displayed. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE24170: CA400EXP-DTRANSFER USERID TRUNCATION IN EXCEL ADD-IN A truncation of the User ID occurs in the Excel Add-in when the user tries to transfer to the iSeries or from the iSeries. This problem only happens when the option "Specify a User ID" in the "Connection" tab of the "Properties" dialog box is selected and the User ID has ten characters. ODBC ---- APAR SE00013: CA400EXP-ODBC FETCH PROBLEMS WITH SQL_ATTR_ROW_ARRAY_SIZE When the ODBC client retrieves data from the server, there are some conditions where a full block of rows can not be retrieved. The ODBC driver is incorrectly returning partial rowsets back to the application. The array should contain the data of the first count of rows. The second fetch should put the next count of rows in the array. The expected result should be, that the SQL-Fetch with SQL_ATTR_ROW_ARRAY_SIZE and CONCUR_LOCK should also build up the expected records in an array.(defined by SQL_ATTR_ROW_ARRAY_SIZE). APAR SE24285: CA400EXP-ODBC-INCORROUT CAN NOT REGISTER ODBC TRANSLATION OP When configuring a Data Source Name (DSN) the settings of the 'Date and time data types' checkboxes on the "Advanced Translation options dialog" are not saved properly. APAR SE24755: CA400EXP-ODBC DRIVER CRASH WITH LARGE SQL_C_DOUBLE VALUES The driver can crash/fault when large SQL_C_DOUBLE values are passed in. A value like 9.90779e+196 being inserted into a packed decimal field can cause this. The appropriate behavior is for the driver to return an error. OLE DB PROVIDER --------------- APAR SE24629: CA400EXP-OLEDB-MSGSQL0104 Problems with long database names A problem was discovered with the iSeries Access for Windows OLEDB provider when trying to export a table using SQL Server DTS Wizard. If a SQL statement is performed using three part names with the RDB name longer than ten characters and using updateable cursors, it causes the error 'SQL0104' which is "Token . was not valid. Valid tokens: ". CIRCUMVENTION: Remove RDB/DB name manually from the "Destination" column in the "Select Source Tables And Views" window of the DTS Wizard. .NET DATA PROVIDER ------------------ APAR SE24436: CA400EXP-IDB2DATA-INCORROUT CLOB LENGTH SET INCORRECTLY WITH A table contains a CLOB field set to use CCSID 1208 (UTF-8). When the IBM DB2 UDB for iSeries .Net provider is used to retrieve this data from an iDB2DataReader as a unicode string, the length of the data is returned incorrectly, the length given is actually the size in bytes instead of the size in characters. This problem does not occur when the same data are stored in a CHAR or VARCHAR data type. APAR SE24985: CA400EXP-IDB2DATA-INCORROUT NullReferenceException in GetDcRow A .NET application receives a NullReferenceException when using an iDB2DataReader or using an iDB2DataAdapter. The exception details point to the GetDcRow method within the .NET data provider. CIRCUMVENTION: Add the following to the the ConnectionString: EnablePreFetch=false; LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE25325: CA400EXP-AFPVIEWER VERSION 2.02.01.01 Upgrade the AFP Workbench Viewer component to a newer level. RESOLUTION: The AFP Workbench Viewer level will be updated to 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 No action is taken when trying to prompt CALLPRC command using Command Prompter for iSeries Access. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20060324 APAR SE22922: CA400EXP-TERMEMUL-INCORROUT CURSOR DOESN'T MOVE TO THE FIRST Customer keys in a date on first screen and then hits enter to move to the next screen, but the cursor doesn't move to the first input field like it use to; it stays in the same relative position as it was on the first screen. APAR SE23600: CA400EXP-TERMEMUL-INCORROUT EVENT NOTIFICATION NOT WORKING A C# application is using Personal Communications autECLConnMgr NotifyStartEvent event and a method is registered to be notified when the session starts. While the same type of calls work in Visual Basic Version 6, they do not work properly in the .Net environment. While the events do seem to be fired, the method that is listening for the event isn't called. APAR SE23782: CA400EXP-TERMEMUL-INCORROUT HACL NOTIFYKEYEVENT The Host Access Class Library automation object autECLPS includes functionality for event-driven keystroke notification from a presentation space. In order to use this functionality, a function NotifyKeyEvent has to be created and it will be called once event notification has been enabled by calling the RegisterKeyEvent method on the presentation space automation object. The documentation for the NotifyKeyEvent parameters is incorrect in the object and the manual. No combination of types similar to those documented were found to work. APAR SE24597: CA400EXP-TERMEMUL-INCORROUT STRPCCMD FAILS WITH BATCH FILES The STRPCCMD is failing to start or run certain commands as well as batch programs. The failure seems to only happen on some PCs as well, not all are affected. An example of the type of command that failed: STRPCCMD PCCMD('START HTTP:\\WWW.IBM.COM') or STRPCCMD PCCMD('C:\DOIT.BAT') In both cases the command shell that says, 'Press any key to continue' would be the only output, the web page wasn't opened, the batch file didn't run. APAR SE24958: CA400EXP-PRINTEMUL-INCORROUT EXTRA SPACE CHARACTER INVALIDAT 2 spooled files are printed to a printer emulation session. The first file specifies to print from drawer 3, and the second file specifies to print from drawer 2. A X'20' space character is sent before the drawer command for the second file. This blank causes the printer to be off a page boundary; and, therefore, the subsequent drawer command does not work. APAR SE25088: CA400EXP-TERMEMUL-INCORROUT Keyword support for color settings on 5250 The emulator screen color should come in 2 choices: the traditional green screen or black text on white background. RESOLUTION: We will provide the keyword ScreenColor in both pcswin.ini and .ws files for specifying the color mode. For pcswin.ini, ScreenColor should be placed in the [Session] section. For a .ws file, ScreenColor should be placed in the [Colors] section. There will be four color key values: 1. UseDefault - Default green text on black background (Multi-color mode). 2. WhiteBoard - Black text on white background. 3. BlackBoard - White text on black background. 4. SystemDefault - Take foreground & background colors specified for 'Window' Item on Display Properties or Advanced Appearance dialog ('Control Panel -> Display -> Appearance tab -> Advanced button for Windows XP). The value specified in the .ws profile will take precedence over the pcswin.ini value. This way, Administrators can specify an alternative default color mode in pcswin.ini (system-wide color mode setting). So when the user configures a new session, admin-specified alternative default value will be picked up. If the user wishes to override admin-specified alternative default value then, they can specify it in the .ws. This would be per session. If nothing is specified in either pcswin.ini or in the .ws, the default display text will be traditional green screen (multi-color mode). Example for pcswin.ini: [Session] ScreenColor=WhiteBoard Example for a .ws file: [Colors] ScreenColor=SystemDefault CIRCUMVENTION: The colors can be changed/personalized on the menu Edit->Preferences->Appearance->Color Mapping. The color changes will be saved into the .ws if the current session is saved. Also, the color key value will be set to UseDefault (multi-color mode) in the saved .ws file by the application. APAR SE25221: CA400EXP-TERMEMUL-INCORROUT Not using iNav default SSL port The communications port on a PC5250 emulation session created by iSeries Navigator should automatically change to match any subsequent port change in the iSeries Navigator connection. This way, when the user chooses to connect with iSeries Navigator using SSL (Port 992), the port should be automatically changed on the PC5250 emulation session to the iSeries Navigator defined port rather than having the user enter the configuration for that emulation session and change the port manually, since by default it is always port 23. RESOLUTION: If the host port number is defaulted (i.e. no port specified in .ws file), and if SSL Security is enabled, then the user can specify a port number to be used by doing the following: 1) Edit the services file in the Windows System drivers directory. For example, edit: C:\WINDOWS\system32\drivers\etc\services 2) At the end of this services file, add a new service name and port. The text line should be: telnet-ssl-pcomm 992/tcp 3) Save the services file 4) Start Pc5250 again via Display Emulator in iSeries Navigator Pc5250 will now look up the port number 992 in the services file, and connect using that port over SSL. APAR SE25222: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window size In V5R3,PC5250 when the Poppad (Pop-up Keypad) size is decreased below a certain width/height, the horizontal and vertical scroll bars are displayed while the button size inside the poppad remains constant. As a result, the number of visible buttons decreases as the size of the poppad window is decreased. When there is a lot of buttons mapped to macros, scroll bars are used to browse and display all the buttons, making it more difficult for the user to find the button needed. RESOLUTION: The PC5250 macro poppad needs to have all of the buttons visible at all times without scroll bars on the window. In V5R2 PC5250, all buttons are resized so they fit into the poppad. For V5R3 and V5R4 to operate without scrollbars on the poppad, add the following keyword to the workstation file (.ws) under the [Poppad] section: ShowScrollBars=FALSE The default value for ShowScrollBars is TRUE, which will show scrollbars on the poppad. APAR SE25223: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window focus On V5R2,PC5250 the user would work on the active principal window (focused) having the macro poppad window posted in a permanent way but out of focus. The user would select a macro from the poppad while the principal window would remain active (focused), this way the user could keep on working on the principal window. With V5R3 PC5250, when the user clicks on a macro inside the poppad window, the principal window would lose the focus and then pass it on to the poppad, thus the user has to click on the principal window to make it active again. In other words, on V5R2 PC5250, the poppad window never became active unless the user clicked inside it on a zone that is not a macro button. RESOLUTION: The PC5250 macro poppad window will stay focused by default, when a user clicks on a macro within a poppad window. For V5R3 and V5R4 to operate similar to V5R2 where the principal window retains focus even when the user clicks on a macro within the poppad window, add the following keyword to the workstation file (.ws) under the [Poppad] section: Focus2PS=TRUE The default value for Focus2PS is FALSE, which will bring the focus to the poppad window when the user clicks on a macro within the poppad. APAR SE25224: CA400EXP-TERMEMUL-INCORROUT Collect and Print PC5250 jobs The printing options do not have a feature to send many print jobs to a single job for storage/distribution or printing. RESOLUTION: To enable PC5250 to collect many print jobs and print them as a single job, three new functions will be added: 1. Switching to Collect Mode. All host print jobs will be saved in a file instead of sent to physical printer. 2. Printing all the collected jobs. All host print jobs saved in the file will be sent to physical printer. 3. Purge collected jobs. The file containing all the print jobs will be deleted. The user can create keyboard shortcuts for these functions using the keyboard re-map utility and also add them as an item in the Toolbar. By default the Collect mode will create the .scs file in the user profile directory by the convention MACHINE NAME_USER_TIME_WS THREADID_DATE_TIME.SCS. -- If the user wants to change the file name, he can use the keyword:SCSFile=.scs in the [printers] section of the ws profile of the printer session. -- If the user wants to change the directory, he can use the keyword:SCSPath= in the [printers] section of the ws profile of the printer session. -- Also there will be an option of printing all the jobs as individual jobs. i.e., if user wishes to, save all the host sent jobs, send them to physical printer without combining all as a single job, but as separate jobs with the advantage of user going to the physical printer only once for collecting printouts. This will be enabled using a .WS keyword "CombineJobs=N" under the [printers] section. This enhancement is available for English National Language Versions (NLVs) only. This includes: -- English (2924) -- English Uppercase DBCS (2938) -- English Mixed Case DBCS (2984) In addition, to enable this function fully, pcsmgres.dll must be downloaded from this site: For V5R3: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r3m0/files/pc5250/standard/se25224 For V5R4: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r3m0/files/pc5250/standard/se25224 The above addresses should all be on one line for your browser URL. Please consult the readme located in the FTP directory for install instructions. 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 Operations Console may fault when an attempt to access the authentication tracking file fails. RESOLUTION: Operations Console will no longer fault when the attempt to access the authentication tracking file fails. APAR SE24809: CA400EXP-OPCON-INCORROUT Control Panel close may fault When closing an Operations Console Control Panel, sometimes the application ends with a fault. RESOLUTION: Operations Console no longer faults when the control panel is being closed. APAR SE24811: CA400EXP-OPCON-INCORROUT Apply button causes bootp failure The bootp function of Operations Console may not respond to valid requests for a particular config after the config's Properties have been displayed, changes made, the Apply button pressed, and then the OK button. RESOLUTION: With this change, the Apply button may be pressed any number of times before OK is pressed and the config is properly maintained at each step resulting in the expected bootp function. CIRCUMVENTION: Either do not press Apply before OK, or follow the Apply with Cancel to avoid the unwanted double-modification of the config. APAR SE25097: CA400EXP-OPCON-INCORROUT Device id out of sync In certain recoverable socket loss cases, the device ID may be reported as out of sync when it is not. RESOLUTION: Operations Console now recovers correctly from certain socket loss situations. APAR SE25176: CA400EXP-OPCON-INCORROUT gui hang during close Operations Console may hang when both Operations Console and console emulation sessions are closed at the same time. RESOLUTION: Operations Console will now close when emulation sessions are ended at the same time as Operations Console. APAR SE25177: CA400EXP-OPCON-INCORROUT cwbopcon.exe ends When Alt+F4 is used multiple times to close certain Operations Console dialogs, the message "Lost communications with cwbopcon.exe" may be displayed. RESOLUTION: The server portion of Operations Console now honors only valid Alt+F4 terminate requests. APAR SE25424: CA400EXP-OPCON-INCORROUT UNUSABLE GERMAN CONFIG PANEL In languages 2929 and 2939 a LAN console configuration panel is incomplete. The panel has no input fields for 'iSeries Service Host Name' and 'Target Partition'. RESOLUTION: With this fix the configuration panel is properly 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 = 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 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 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 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 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 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 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 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 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 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 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 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 SI23696 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.