============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R3M0 Cumulative Service Pack Level ------------- SI17742 ------------- (c) Copyright IBM Corporation 2004. All rights reserved. ======================================================================== IMPORTANT NOTE: Service pack SI17742 replaces SI17411. After SI17411 was released on March 16th, 2005, a problem with the Data Transfer component was discovered: APAR SE19596: CA400EXP-DTRANSFER-INCORROUT UPLOAD OF ASCII FILE FAILS WITH CWBDB0052 and CWBTF0020 When uploading certain ASCII files (for example files created directly with notepad) messages CWBDB0052 and CWBTF0020 may appear and the data won't be uploaded correctly. Code was changed to correctly upload these types of ASCII files. SI17742 includes this Data Transfer fix. If you do not use Data Transfer component to upload data to the iSeries, then you can skip the rest of this section as it does not apply to you. The SI17411 service pack web download was repackaged on March 25th, 2005 to include the Data Transfer fix. However, the PTF SAVF version (LODPTF/APYPTF on the iSeries) was not repackaged. PTF users were directed to a FTP site to get the Data Transfer fix. -- If you downloaded and installed SI17411 after March 25th, 2005, then you do not need to install SI17742. -- If you installed the PTF SAVF form of SI17411, or a web download of SI17411 prior to March 25th, 2005, and have already fixed Data Transfer via the FTP site, then you do not need to install SI17742. -- If you have SI17411 installed with Data Transfer component, and are not sure if you have the Data Transfer fix: 1. Locate the file cwbtfutl.dll on your client workstation. This file should be located in the Windows System directory (for example, C:\WinNT\System32 or C:\WINDOWS\System32 ) 2. The modification date/timestamp on cwbtfutl.dll will be March 13, 2005 5:31 AM. If you have a different version of cwbtfutl.dll with SI17411, then you should install SI17742. If installing SI17742 is inconvenient or you need the fix quickly, the fix for SI17411 may be obtained at the following FTP site: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r3m0/files/DataXfer -- If you install SI17742, you will have the Data Transfer fix. There is no need to look at the file modification date. It will be March 4, 2005 5:30 am, but this is correct for SI17742 and consistent with the other files in the service pack. We specifically date the files - the '4' for the day indicates our 4th service pack. The 5:30 indicates V5R3M0. SI17742 and SI17411 are identical other than SI17742 in all forms, includes the Data Transfer fix. There are no other differences. SI17742 was created so that the same service pack level would exist on web download and PTF SAVF medias. ======================================================================== Co-requisite PTF SI17413 is automatically included with any shipment or web download of SI17742. SI17413 exists only for packaging reasons. All service pack level references will be to SI17742. SI17742 can be installed on any PC/server that is at V5R3 service level SI10817 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. ----------------- 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 UNIVERSAL CONNECTION WIZARD WITHIN iSeries NAVIGATOR 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI17742 (March 2005) 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-1.ibm.com/servers/eserver/iseries/clientaccess/casp.htm 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 being added back in V5R3 when the iSeries Navigator Network component is installed. All help and panels associated with Application Development functions will appear in English language only. To see the Application Development folder within the iSeries Navigator hierarchy, perform either of the following: -- Selectively Install (or initially install) the Network component of iSeries Navigator from an installation image containing V5R3 service pack SI13587 or newer. -- If the Network component is already installed on the PC, install service pack SI13587 or newer to receive the Application Development folder in the hierarchy. Application Administration can be used to restrict the display of the Application Development folder to certain users or groups of users. If secondary languages are installed on the PC, the Application Development English help and panels will be copied to each installed language directory. If a subsequent secondary language is installed, install service pack SI13587 or newer to copy the Application Development English help and panels into the new language directory. 2.3 Universal Connection Wizard within iSeries Navigator ---------------------------------------------------------- Running the Universal Connection Wizard to a V5R3M0 server that has not had PTF SI15166 for 5722SS1 installed could produce non-working universal connections in some scenarios. 2.4 JAVA RUNTIME ENVIRONMENT (JRE) 1.4.2 ------------------------------------------ PTF 5722XE1 V5R3M0 SI16716 contains Java Runtime Environment (JRE) 1.4.2 which will replace version 1.4.1, which was on the original iSeries Access for Windows V5R3M0 media. The following APARs are fixed in JRE 1.4.2: APAR SE17968: CA400EXP-OPNAV USER-DEFINED CHARACTERS HALT STARTUP When a user-defined character(GAIJI) is created on the Windows client, iSeries Navigator does not start. The window screen appears a moment, but it ends immediately. This problem occurs on Windows XP and doesn't occur on Windows 2000. This problem disappears if we delete the GAIJI file named EUDC.EUF and EUDC.TTE from the C:\Windows\Fonts directory. A problem was found in the version of the Java Runtime Environment (JRE 1.4.1) that is shipped with iSeries Navigator. An update of the JRE to 1.4.2 is being provided to solve this problem. CIRCUMVENTION: Remove private characters to continue using iSeries Navigator without this fix. APAR SE18028: CA400EXP-OPNAV-WAIT ISERIES NAVIGATOR HANGS WITH IPV6 When Microsoft Extended TCP/IP Version 6 (IPV6) protocol is configured on the PC, iSeries Navigator Basic Operations, Printer Output never displays, and the user gets a message that iSeries Navigator is no longer responding. A problem was found in the version 1.4.1 of the Java Runtime Environment (JRE) that is shipped with iSeries Navigator. An update of the JRE to version 1.4.2 is required to solve this problem. CIRCUMVENTION: Remove Microsoft Extended TCP/IP Version 6 (IPV6) protocol by running the following from a PC Command Prompt: ipv6 uninstall If SI16716 is applied to the iSeries, and a service pack install is run from that iSeries image, the service pack install will upgrade the JRE level, if needed. Subsequent service packs will not reinstall the JRE if the latest level already exists on the PC. A new install, reinstall, or upgrade from an install image with SI16716 applied, will install the new JRE 1.4.2. For best results with reinstalls, apply PTF 5722XE1 V5R3M0 SI17496 (APAR SE19431) so that you don't have any obsolete files left over after the reinstall. A JRE 1.4.2 install package will also be provided on the IBM FTP site in a subdirectory off of the service pack FTP directory, for those users that prefer to get their service packs from the IBM FTP site. The following APAR addresses a side-effect of JRE 1.4.2 which will be fixed in the next release of iSeries Access for Windows: APAR SE19540: CA400EXP-OPNAV-INCORROUT JRE 1.4.2 INSTALL DIRECTORY When iSeries Navigator (with Java Runtime Environment (JRE) 1.4.2) is installed into a PC directory with a parenthesis '(' or ')' in the directory name, unpredictable results occur with Java operations. In particular, this is a problem with the default installation directory name on 64-bit Windows servers: C:\Program Files (x86)\IBM\Client Access This will be fixed in the iSeries Access for Windows release following V5R3M0. CIRCUMVENTION: Install into a PC directory that does not contain a parenthesis character '(' or ')'. If the PC already has iSeries Access for Windows installed into such a directory, uninstall iSeries Access for Windows, and install it again into a PC directory with no parenthesis character, prior to using iSeries Navigator with Java Runtime Environment 1.4.2. 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 = SI17742 Build date = March 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE18332: CA400EXP-2-UNPRED MEMORY LEAK IN CWBDATAQUEUETEXTBOX ACTIVE Every TransferTextData method call from CWBDataQueueTextBox appears to leaking about 32 bytes. The memory leak has been fixed. APAR SE18533: CA400EXP-OPNAV-INCORROUT NOT ALL COMPONENTS LISTED UNDER After release upgrade to V5R3, customers cancel out of Scan Function prompt that comes up at 1st usage of iSeries Navigator in V5R3 -- issue is whether iSeries Navigator should prompt or just do the scan automatically. If user does a manual scan then all components are listed under iSeries Navigator. iSeries Navigator is changing such that the scan for supported plugins happens automatically after a release upgrade. APAR SE18852: CA400EXP-SECURITY-MSGCWBSY1040 Cannot find Windows logon information One server is configured in iSeries Access for Windows Properties to be the Administration System. When the connection to this system is configured to use 'Use Windows userID and password, no prompting' for the signon mode, the message CWBSY1040 results. CIRCUMVENTION: Configure the signon mode for the Administration System to be something other than 'Use Windows userID and password, no prompting.' APAR SE18899: CA400EXP-OPNAV-INCORROUT TIME MGMT UNAVAIL WITH SSL With iSeries Navigator V5R3 connected with SSL, the Time Management folder under the Configuration and Service section will not be listed when looking at Function Availability. A key was missing in the registry that allowed the Time Management folder to be displayed and function in an SSL environment. The service pack install will create this key to fix the missing key problem. In addition, any new install, upgrade install, or reinstall from a merged image containing this service pack will create this key at initial installation time. CIRCUMVENTION: Via careful usage of the Registry Editor, an "SSL" subkey with a key value of "Support Level" and a DWORD value of 1 can be added to the following key to fix this problem: -- HKEY_CLASSES_ROOT\IBM.AS400.Network\3RD PARTY EXTENSIONS\IBM.TimeManagement APAR SE19086: CA400EXP-OPNAV-INCORROUT ez prerequisites not passed When running EzSetup application, the Prerequisite check indicates that prerequisites are not satisfied, but if the Details button is clicked, the Results screen shows that all prerequisites were satisfied. Code has been changed to get a correct prerequisites check process. APAR SE19141: CA400EXP-OPNAV-MSGCWBAD1003 ACCESS IS NOT RESTORED CORRECTLY Using Application Administration a group profile is added to the Access allowed list of a function. When a user profile is removed out from the group profile and then added back in, the access is not restored for the user profile, causing message CWBAD1003 to be displayed when the user tries to use the function. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR SE19438: CA400EXP-INRMTCMD-PERFM CWBRXD.EXE USES TOO MUCH CPU A PC running the Incoming Remote Command daemon (the service called iSeries Access for Windows Remote Command) occasionally experiences performance problems. Windows Task Manager shows that CWBRXD.EXE, which is the name of the program for the service, is using a large percentage of the CPU, possibly 100%. This problem can occur if a network port scanner connects to port 512 on the PC. This condition does not end; to restore an acceptable performance level requires stopping and re-starting the service. CIRCUMVENTION: Ensure that network port scanners and other tools designed to connect to, and then disconnect from, various ports of PCs do not connect to port 512 on the PC. iSeries NAVIGATOR ----------------- APAR SE16931: CA400EXP-OPNAV-DBASE-LOOP LIST EXPLAINABLE STATEMENTS PERF For a very large SQL Performance monitor, List Explainable Statements can be very slow to appear or appears to hang. List Explainable Statements may also run out of memory when working with large performance monitors. List Explainable Statements will display 1000 statements at a time. If the performance monitor contains more than 1000 statements, an item will appear at the bottom of the list. When selected, the 'Run Visual Explain' button will change and when pressed it will allow the user to display the next 1000 statements. Sorting is performed on all explainable statements, whether or not they are displayed, with one exception. Sorting by 'SQL Text' only sorts the statements that are currently displayed. Also, sorting the 'Date' and 'Time' columns will sort on both columns by date, and then time. Performance of List Explainable Statements for large performance monitors may also be improved by manually creating the following indexes on the performance monitor data file: create index dbmon_ix1 on dbmondata (qqrid, qqi5, qqucnt, qqjfld, qqc11, qqc21, qvc1c); create index dbmon_ix2 on dbmondata (qqjfld, qqrid); create index dbmon_ix3 on dbmondata (qqrid, qqtime, qqc21, qqc181); APAR SE18365: CA400EXP-OPNAV-ONBACKUP MISSING WHERE PANEL ON PROPERTIES Backup policies properties on iSeries Navigator, is missing the "Where" tab when accessing a V5R3M0 iSeries system. APAR SE18421: CA400EXP-CUSTCONTROLS-INCORROUT CONTEXT MENU HANDLERS Context menu handlers registered with iSeries Navigator on existing types are no longer being invoked with V5R3 iSeries Access. The exact same code is working fine on V5R2 iSeries Access. The folder registry entries and context menu handlers associated with our own (new) folders seem to work fine. All of the context menu handlers that add entries to the 'IBM' folders (e.g. 'Basic Operations' and 'Databases'), even when they are the same GUID as the context menu handlers of our own folders, are not being invoked. We have existing users that are now unable to use our plug-in software so this is a critical problem for us. APAR SE18471: CA400EXP-OPNAV-NETWORK DHCP incompatibility within versions When trying to use a DHCP configuration in iSeries Navigator v5r2, it pops up an error message if the configuration file was previously modified in a v5r3 iSeries Navigator version. The code has been changed for backwards DHCP configuration compatibility. APAR SE18661: CA400EXP-OPNAV-NETWORK UCW Rollback of IES changes in v5r1,v5r2,v5r3 A defective PTF was released for V5R1 and V5R2 OS/400 that was intended to provide support for PTF downloads through a fenced internet. The Universal Connection Wizard was updated to work with this PTF. The fenced internet support is being withdrawn, and so too will its support from the Universal Connection Wizard. The Universal Connection Wizard paths affected by this update is the configuration for Service Agent application using an ATT dial scenario to a V5R1 or V5R2 OS/400. This PTF is meant to operate in conjunction with the following OS/400 PTFs: V5R1 OS/400: SF67792, SI15863, SI15855, and SI15862 V5R2 OS/400: SF67793, SI15865, SI15857, and SI15867 APAR SE18790: CA400EXP-OPNAV-DBASE MSGSQL0444 INDEXES FAILS ON V5R2 SERVER Using V5R3 iSeries Navigator Index Evaluator tool when connecting to V5R2 of OS/400 fails with MSGSQL0444 "External program QZDGDSPI in QIWS not found." The 'Indexes' function will now work correctly on V5R2 servers with no intervention from the user. CIRCUMVENTION: In STRSQL, Run SQL Scripts in iSeries Navigator, or any SQL interface, execute the following two statements: DROP SPECIFIC PROCEDURE QIWS.GET_INDEXES CREATE PROCEDURE QIWS.GET_INDEXES ( IN SYSTEM_TABLE_SCHEMA VARCHAR(10) , IN SYSTEM_TABLE_NAME VARCHAR(10) , IN MEMBER_NAME VARCHAR(10) ) DYNAMIC RESULT SETS 1 LANGUAGE C SPECIFIC QIWS.GET_INDEXES NOT DETERMINISTIC MODIFIES SQL DATA CALLED ON NULL INPUT EXTERNAL NAME 'QIWS/QZDGPGMI' PARAMETER STYLE SQL The 'Indexes' function will then work against a V5R2 server. APAR SE18804: CA400EXP-OPNAV-DBASE CHANGE COLUMN LENGTH DOES NOT WORK Using iSeries Navigator to change a column length, the following occurs: Change by -> SERVER -> Databases -> SERVER -> Schemas -> LIBRARY -> Tables -> Right Click on Table name and choose definition -> Click the columns tab -> Select a column and press the now highlighted definition button. -> Change the length and choose OK. Now either use DSPFFD TESTFILE or go back into the column definition. SI15176 = Length changes. SI16496 = Length does NOT change. The table will now be altered as expected. APAR SE18862: CA400EXP-OPNAV-NETWORK-INCORROUT IPv6 incompatibility Because of significant changes, the IPv6 configuration on systems greater than v5r3 cannot be done with v5r2 and v5r3 iSeries Navigator. The IPv6 function is disabled for iSeries Navigator v5r2 and v5r3 when connected to servers greater than v5r3. APAR SE18977: CA400EXP-OPNAV-DBASE ALIAS DISPLAYED INCORRECTLY For an alias which references the system name of a table or view that has a long or delimited name, iSeries Navigator will display the alias as an 'Unknown alias'. This implies that the based on table does not exist, which is not the case. For an alias based on all partitions of a partitioned table, the alias definition dialog surrounds the 'For All Partitions' text in quotes. iSeries Navigator will display aliases that reference the short name of an existing table or view correctly. 'For all partitions' will not be enclosed in single quotes by the alias definition dialog. APAR SE19071: CA400EXP-OPNAV-INCORROUT IASP properties option not saved iSeries Navigator IASP Geographic Mirroring properties are not saved in Spanish. The problem is reproduced using the following steps: 1. Vary off the IASP 2. Change the synchronization type. 3. When selecting the option Change attribute check the type asynchronous 4. Vary on the IASP 5. When checking the properties of IASP the type is not set Code has been changed to correctly display the IASP properties. APAR SE19129: CA400EXP-OPNAV-DBASE GENERATE SQL DOES NOT APPEND TO PC FILE Generate SQL does not append output to an existing PC file, as it can for a source file on the server. It forces the user to choose a new PC file or overwrite the existing PC file. Generate SQL can now append output to a PC file. APAR SE19139: CA400EXP SNTP ok button not working inside Time Management When the SNTP is launched from the Time Management folder and the ok button is clicked the GUI does not do anything. Code has been modified to allow changes to be saved when the ok button is clicked from the Time Management folder. APAR SE19140: CA400EXP-OPNAV-NETWORK-INCORROUT Poll interval not displayed The SNTP Poll Interval field is not displayed when we run a v5r2 host with iSeries Access for Windows v5r3. SNTP properties now displays the poll interval data. APAR SE19149: CA400EXP-OPNAV-NETWORK UCW Remote Dial for Service Agent fails Using the Universal Connection Wizard to configure a remote dial configuration for service agent could result in a non-functioning configuration. APAR SE19203: CA400EXP-OPNAV-NETWORK-INCORROUT DHCP denies valid address When adding excluded addresses on the DHCP configuration, it does not accept IP addresses ending with 255, which are valid ones. The DHCP configuration will now accept excluded addresses ending with 255. APAR SE19214: CA400EXP-OPNAV Add option to Run SQL Scripts window to allow deferring messages in the Run History pane Users of the Run SQL Scripts window in the iSeries Navigator database need the ability to defer messages from appearing in the output pane (the Run History) to improve the performance when executing large numbers of statements, and the ability to see messages immediately as statements are executed, so the user can know right away if a statement failed. The new option DEFER RUN HISTORY will be provided on the Options menu of the Run SQL Scripts window. It will be provided with English-only text, since translated text cannot be changed after a release has shipped. APAR SE19269: CA400EXP-OPNAV-DBASE-INCORROUT UPDATE STATISTICS The statistics data for a table may be manually updated in the 'Statistics Data' dialog. The 'Update Statistics' dialog that is then displayed, show incorrect information for the 'Type' and 'Stale' columns. 'Update Statistics' will display the correct information for the statistic. APAR SE19369: CA400EXP-OPNAV-DBASE-INCORROUT SQL STATEMENT TRUNCATED List Explainable Statements only shows the first 1000 characters of statement text in the 'SQL statement selected' field. When Visual Explain is launched, the query text is also truncated in the 'Statement text' tab. List Explainable Statements and Visual Explain will now show the SQL statement in its entirety. APAR SE19420: CA400EXP DNS does not allow zone forwarders DNS GUI does not allow forwarders to be set for a specific zone. Code has been changed to allow forwarders for a specific zone. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE18219: CA400EXP-DTRANSFER-INCORROUT RFROMPCB FAILS WITH /I SWITCH When using RFROMPCB with the /I switch, some warnings (such as truncation warnings) may not be ignored and could lead the transfer to fail. The code has been changed to correctly ignore warnings during batch transfers. APAR SE18429: CA400EXP-DTRANSFER-MSGCWBTF0005 WHEN EXCEL FIELD CONTAINS $ MSGCWBTF0005 is thrown when uploading a field containing a $ character using the iSeries Access Data Transfer Add-In for Microsoft Excel. Code was changed to correctly handle currency fields (marked with a $ character) in Excel worksheets. APAR SE18555: CA400EXP-DTRANSFER-MSGCWBTF0009 DBCS DATA TRUNCATION When uploading double byte data with length equal or less than field length, MSGCWBTF0009 is incorrectly issued. The code was changed to prevent this warning from displaying. APAR SE18657: CA400EXP-DTRANSFER-INCORROUT ASCII FILE PADDING ERROR An iSeries Access data transfer to PC, using the ASCII text format with the option checked to pad numeric values with leading 0's, places extra zeroes on the numeric field. Code was changed to correctly pad numeric fields on ASCII files. APAR SE18994: CA400EXP-DTRANSFER-INCORROUT HTML DOWNLOAD INCOMPLETE When using Data Transfer to download a file to HTML format, if the host file contains a character field with a single space in it, the resultant file will be truncated and not all records will be transferred. The code was changed to avoid HTML file truncation. APAR SE19191: CA400EXP-DTRANSFER-INCORROUT ZEROS UPLOADED INSTEAD OF MESSAGE When transferring data to the iSeries, zeros are uploaded in the last field if the number of decimal places doesn't match the precision definition for the field specified in the FDF. A warning message should be issued instead. Code was changed to display the correct message instead of uploading zeroed data. APAR SE19249: CA400EXP-DTRANSFER-INCORROUT ADDIN SCANS CHAR FIELD AS DATE When scanning a Microsoft Excel file with the option to convert Excel date and time cells to iSeries date or time, some CHARACTER fields will be detected as DATE instead. Code was changed to prevent CHARACTER fields from being detected as DATE when the option to convert Excel date and time is selected. APAR SE19296: CA400EXP-DTRANSFER-INCORROUT COPY FROM DISPLAY TO EXCEL FAILS When copying data from the Display window to Microsoft Excel, numeric data is not copied correctly. Code was changed to correctly copy data from the Display window to Microsoft Excel. APAR SE19306: CA400EXP-DTRANSFER-INCORROUT WIZARD SETS TRANSLATION FROM ASCII When the Create Database File Wizard detects a Unicode Text file, the Details panel in the Data Transfer GUI incorrectly sets the translation option to ASCII. Code was changed to set the correct translation option in the Details panel. APAR SE19307: CA400EXP-DTRANSFER-INCORROUT MISSING VALUE FOR HTML TEMPLATE The template tag in the HTML output options is empty, when a default should have been provided. Code was changed to display a correct default template tag. APAR SE19416: CA400EXP-DTRANSFER-INCORROUT ISERIES LIBRARY BROWSE BEHAVIOR When a library is specified by name in Data Transfer and the Browse button clicked, the library is not added to the library list in the browse window. If a forward slash is added to the library name, the browse window shows the library correctly, but Data Transfer should add the library even without the slash. Code changed to allow browsing a library when its name is provided in Data Transfer. CIRCUMVENTION: Add a forward slash after the library name. APAR SE19596: CA400EXP-DTRANSFER-INCORROUT UPLOAD OF ASCII FILE FAILS WITH CWBDB0052 and CWBTF0020 When uploading certain ASCII files (for example files created directly with notepad) messages CWBDB0052 and CWBTF0020 may appear and the data won't be uploaded correctly. Code was changed to correctly upload these types of ASCII files. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE18494: CA400EXP-ODBC-INCORROUT - Miscellaneous ODBC fixes If the database or IASP name is in lowercase, the server gives the "The specified database can not be accessed at this time." Native Error Code: 30305 The GUI allows to enter lowercase database names also the driver do not uppercase database name when it is lowercase in the connection string, the server respond with "- Invalid RDB specified." error. CIRCUMVENTION: Valid relational database names and aliases must begin with a letter and consist of uppercase A-Z, 0-9, and underscore. APAR SE18606: CA400EXP-ODBC-INCORROUT - CONNECTION POOLING ISSUES Two issues exist when using connection pooling with the ODBC driver: 1) If an application connects with the commit mode setting of 0 (*NONE) and runs a transaction a later error can be experienced. The problem occurs after the connection gets placed into the connection pool. When the application reconnects and gets the 1st connection out of the pool, the application gets an error that the "Driver's SQLSetConnectAttr failed". The root cause of this problem is that the ODBC driver is incorrectly returning a value of 0 for the SQL_ATTR_TXN_ISOLATION connection attribute. 2) When using connection pooling, the ODBC driver manager occasionally polls an ODBC driver to determine if a connection is down or not. The ODBC driver can not currently detect this, particularly if the server job went down unexpectedly. To better handle this, an improvement is being made to help the ODBC driver better detect down connections. APAR SE19073: CA400EXP-ODBC-MSGSQL0206 COLUMN SQL_DATE NOT IN SPECIFIED Lotus Approach is used with the iSeries Access for Windows ODBC driver to build and execute a query with a selection criteria specified on a date field. When the the SQL statement built by Approach is run it receives an error message, 'SQL0206-Column SQL_DATE not in specified tables.' The query built by Approach is invalid and this really is a defect in the Approach product. The same query used to work with the V4R5 version of the ODBC driver, though. Traces of the V4R5 client revealed that Approach never put any selection criteria on the SQL statement that was passed to the ODBC driver when using the V4R5 driver. The reason for the change in application behaviour appears to stem from the value they get from the ODBC driver when they query the driver's ability to provide conversions from one type to another. SQLGetInfo's SQL_CONVERT_TIMESTAMP option returns an incorrect value with the V4R5 driver. The newer driver is returning the correct value but that causes Approach to build an incorrect SQL statement that is overly complex: WHERE ({fn CONVERT("EBONY"."GLFILE"."GLPOSTP".GPD_ENTDAT,SQL_DATE)} = {fn CONVERT({d '2004-07-09'},SQL_DATE)}) This could have been as simple as: WHERE GPD_ENTDAT = '2004-07-09' In order to allow Lotus Approach to continue working with the latest versions of the iSeries Access ODBC driver, the ODBC driver was changed to optionally return the V4R5 values when using SQLGetInfo() with Infotype SQL_CONVERT_TIMESTAMP. To configure the ODBC driver to return this value, set the DEBUG keyword to 2048. Contact IBM Support if you need assistance setting this special flag. APAR SE19091: CA400EXP-ODBC SQLSETCONNECTATTR FAILED WITH CONNECTION POOL The iSeries Access for Windows ODBC driver is being used in a connection pool with a data source using *NONE commit (isolation) level. The connection pool would attempt to set the transaction isolation level back to the original setting using the SQLSetConnectionAttr to set the isolation level to 0. The ODBC driver returns an error stating that this is not a valid value. According to the ODBC specification, a value of 0 is not defined but neither is a commit level of *NONE, this is a feature most databases do not support. The level of 0 is what our driver returned when it was queried for the isolation level after the connection was initially established. The error returned to the application when the error occurs is, DIAG! IM006 Microsoft ODBC Driver Manager Driver's SQLSetConnectAttr failed (0) APAR SE19359: CA400EXP-ODBC-MSGSQL0104 USER() FUNCTION Message SQL0104 "Token ( was not valid " is returned when the ODBC USER() function is used with the version 5 iSeries Access for Windows ODBC drivers. This same function worked correctly with Version 4 and older versions of the ODBC driver. An example of the type of SQL statement that would be incorrectly parsed by the ODBC driver is: SELECT {fn USER()} FROM MYTABLE Traces reveal that the version 5 ODBC drivers are sending the statement: SELECT USER() FROM MYTABLE to the iSeries server rather than the correct format: SELECT USER FROM MYTABLE USER is a special register on the iSeries database rather than a scalar function as it is on some platforms. OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE18503: CA400EXP IDB2DATA INCORROUT .NET provider quotes names w/@#$ If the application uses an SQL name that contains one of the three special code points reserved as alphabetic extenders for national languages (@, #, and $ in the United States -- EBCDIC code points 0x5B, 0x7B and 0x7C), then the .NET provider does not recognize the names unless they are quoted. For example, the name CRORD# should not need to be quoted. APAR SE18607: CA400EXP IDB2DATA InvalidOperationException after ExecuteScalar If ExecuteScalar is called to execute a query, and the query returns no result data, then the iDB2Command object used for the ExecuteScalar cannot be reused. An InvalidOperationException results, with a message saying "There is already an open iDB2DataReader associated with this command which must be closed first." APAR SE18608: CA400EXP IDB2DATA Null Provider type fails on GetHashCode If an application references a variable whose type is one of the provider data types (for instance, iDB2Binary, iDB2Char, iDB2Decimal, etc), and that variable's value is null, then calling GetHashCode() on the object returns a NullReferenceException. The same problem can occur when tracing that object, because the provider's trace/log calls GetHashCode on the objects it traces. APAR SE18811: CA400EXP IDB2DATA MSGSQL0206 if CommandBuilder used on View If the application uses an iDB2CommandBuilder to build statements for a VIEW, and the VIEW column names are different from the base table's column names, then the following message is generated: "SQL0206 Column not in specified tables" CIRCUMVENTION: Create the view using the same column names as the based-on-table. APAR SE19150: CA400EXP IDB2DATA WAIT DELAY INITIALIZING NUMERIC VARIABLES A program using the IBM DB2 UDB for iSeries .Net Provider experiences long delays when retrieving numeric or decimal data. Managed provider traces show the delay occurs in the initialization of the large decimal or numeric constant variable MaxValue. The problem appears to be much worse on some PCs than on others. The delay occurs when the provider calls System.Convert.ToDecimal() on a string that is larger than Microsoft's Decimal data type can hold. An exception occurs, and it takes a long time for Microsoft to return control to the provider's "catch" block to handle the exception. This PTF fixes the delay which occurs when constructing the iDB2Decimal and iDB2Numeric constants MaxValue and MinValue. A delay could still occur if the application uses a decimal or numeric value which is too large to fit into a System.Decimal variable. APAR SE19262: CA400EXP IDB2DATA MSGIDB2COMMERROREXCEPTION - Add property to verify pooled connections on Open When iSeries server jobs get recycled (ENDPJ, ENDJOB, ENDSBS, or IPL), .NET connections receive a comm error the next time that connection is used: iDB2CommErrorException: A communication error occurred. When this happens, the normal recovery is for the application to close and then reopen the connection. In cases where ALL or MANY pooled connections are ended (for instance, during an IPL), the application could continue to get communication errors even after reopening the connection. New functionality is needed to give applications a better way to recover from this condition. This PTF gives applications a way to have the provider check pooled connections for validity before using them on a connection.Open request. To validity check pooled connections during Open, add the following to your ConnectionString: CheckConnectionOnOpen=true; This causes the provider to send a small flow to the host in order to see if the connection is still active. If the connection is no longer active, the provider reconnects to the host server before returning from the Open request. By default, the CheckConnectionOnOpen property is set to false, meaning pooled connections are not checked for validity during Open. APAR SE19266: CA400EXP IDB2DATA MSGPWS0006 Error reading CLOB and DBCLOB An application attempts to read CLOB or DBCLOB data from the host using LOB locators. The first row is read ok, but the second row fails with PWS0006. CIRCUMVENTION: Change the ConnectionString to specify a large value for MaximumInlineLobSize, to force LOBs to be treated as inline data instead of as locators. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.7 (2/24/2005) and the equivalent of 5722JC1 SI17296 and SI17439. SI17296 fixes the following APARS: APAR SE18119: CA400EXP-OPNAV-INCORROUT-Command Prompter error The command prompter is sometimes treating special values (*SPCVAL) as single values (*SNGVAL). An example is: DSPOBJD *CURLIB/*ALL *ALL Entering this and pressing the prompt button the object parameter has the *ALL with *CURLIB with library, but disabled. When OK is pressed it comes back with: DSPOBJD OBJ(*ALL) OBJTYPE(*ALL) Additional validations were added. APAR SE18980: CA400EXP-OPNAV-INCORROUT ClassCastException in PanelTreeTable When using JRE 1.4.2 with iSeries Navigator parts of the program don't respond. SI17439 fixes the following APAR: APAR SE19074: TOOLBOXJAVA-JT400-ACCESS-JDBC CANNOT CONNECT RUN SQL SCRIPTS The Run SQL Scripts function of iSeries Navigator will connect and disconnect from the iSeries with an error message, 'Exception. The requested operation cannot be performed because the server connection was dropped.' This started happening after applying service pack SI16496 to the V5R3 iSeries Access for Windows Client. It would appear that this failure might only happen on systems running Windows XP, Windows 2000 PCs did not seem to be affected. The problem can be circumvented/corrected manually by performing the following steps: End iSeries Navigator. Delete the OpNav.Java.User.ser file. This file is typically located in the following path: C:\Documents and Settings\All Users\Documents\IBM\Client Access\Config (note this path wraps two lines) Logoff/Logon or restart the PC. Start iSeries Navigator. A check was added to insure that the SocketProperties object is not null before trying to set the socket properties for the AS400 object. Fix accomplished by upgrading to jtOpen 4.7 release. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE16441: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION PROBLEM AFTER After applying SI14294 the cursor position will move to top left hand corner in OEM software program as well using OS/400 menu and SYS ATTN key in PC5250 Also, for a multi-screen application, when the user enters data on the second screen, then the user uses a PF key to move to another screen, when they return to the second screen the cursor is at the end of the text previously entered. However, if the user then begins to type where they left off, the cursor jumps to the beginning of a previous entry field causing them to type over the text. APAR SE18210: CAEXP PC5250-BEHAVIOR OF IME IS INCORRECT WHEN CURSOR IS Behavior of IME is incorrect when cursor mode is blink mode, and display size is 27x132. IME indicator is not changed when display returns to previous screen. APAR SE18245: CA400EXP-PRINTEMUL-MSGPCSCM.EXE APPLICATION ERROR PCSCM.EXE When using Windows XP with SP2, if 2 printer sessions are open and then a session is stopped and spool files are moved to the outq, a PC application error comes up and all sessions are dropped. The error is PCSCM.EXE application error, access exception. APAR SE18385: OSP-MSGPCSERR100 PCSERR100 WITH PC5250 The shared memory is not getting reinitialized properly when whlapi32.dll unloads. When user logs off from USO Client and then logs in, the shared memory is not getting cleared properly and not getting reinitialized. This is a problem in PC5250. This problem will be fixed in V5R3 and beyond. APAR SE18436: CA400EXP-TERMEMUL PCSBAT.EXE CAN'T RUN *.LNK FROM BCH FILE After applying SI16136, PC5250 batch couldn't be run if the containing link (shortcut) object of MS-DOS batch (*.bat) is named *.bat. APAR SE18821: CA400EXP-TERMEMUL-INCORROUT NO SOUND ON PC AFTER UPGRADING After upgrading to iSeries Access for Windows R530 + SI16496, customer no longer gets any sound in the 5250 session. This was working fine on R520. APAR SE18841: CA400EXP-PRINTEMUL-INCORROUT GAIJI CHARACTER WRONG SIZE WITH iSeries Access R520 SI16136 with a printer session using IBM5577.pdt is in use. They find that if they print a GAIJI character using codepage 939 it prints out as expected. If they use codepage 1399 it is smaller. APAR SE18842: CA400EXP-PRINTEMUL-INCORROUT DBCS DASH CHARACTER PRINTS iSeries Access R520 with SI16136 is in use. A printer session is created that uses IBM5577.pdt and code page 1399. If DBCS character x'4260' is printed, it prints as an incorrect character. It appears that the jpn1399.fnt file needs to be corrected. APAR SE18848: CA400EXP-TERMEMUL HIGHER RESOLUTION DISPLAY SUPPORT PC5250 does not display its screen properly at high resolutions. PC5250 works best with lower resolutions like 1024x768. At higher resolutions, much of the emulator screen is blank and the text displayed is centered. PC5250 needs to use most of the available window space, and display the text as large as possible with good quality. 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. -- Monotype Sans Duospace WT (mtsansdw.ttf) (for displaying text) -- IBM3270APL5 (pcommapl.ttf) (for displaying APL characters like box drawing, scrollbars, etc) IBM3270 will still be the default font. The new Monotype Sans Duospace WT font (mtsansdw.ttf) will need to be selected by the user via the Select Display Font dialog. Whenever the Monotype Sans Duospace WT font is selected, PC5250 will automatically select IBM3270APL5 (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 SE19080: CA400EXP-PRINTEMUL-INCORROUT INCORRECT FONT SIZE WHEN ROTATI A spooled file is being printed that has a PAGRTT(90) specified, and a 10 CPI font. When printed, the font is reduced to a 15 CPI font. APAR SE19101: OSP-PAR PCSWS026 ERROR WHEN SAVING .WS PROFILES AFTER On some PCs, the error PCSWS026 will be received when trying to save or close PC5250 sessions. No matter what location is used, the error will occur, even if the user has full rights to the folder. This happens after applying SI16496 of iSeries Access for Windows V5R3M0. APAR SE19188: CA400EXP-TERMEMUL-INCORROUT COPY FAILS TO COPY NEW DATA TO When a user copies new data and attempts to paste, the old data that had been copied is now pasted instead of the new data. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE18498: CA400EXP-OPCON-INCORROUT autostart doesn't start Sometimes a configuration marked for autostart doesn't automatically start when Operations Console is started. Configurations marked for autostart now start automatically when Operations Console is started. 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 = SI16496 Build date = December 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE17422: CA400EXP-OPNAV-INCORROUT FUNCTIONS UNAVAIL WITH SSL APAR SE17423: CA400EXP-ODBC-INCORROUT LARGE VARCHAR DOESNT SHOW DBCS DATA APAR SE17688: CA400EXP IDB2DATA INCORROUT LibList added in wrong order APAR SE17943: OSP-DB ODP NOT REUSED. APAR SE17955: CA400EXP - XDA Windows client enhancements APAR SE18001: CA400EXP-TERMEMUL-INCORROUT CWBLM0040 with multiple sessions APAR SE18197: CA400EXP-TERMEMUL-INCORROUT HMC connection timeouts APAR SE18389: CA400EXP IDB2DATA PWS0043 stored procedure with parameters OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE16054: CA400EXP-OPNAV-DBASE VE SHOW RELATED OPTION MISSING APAR SE16574: CA400EXP-OPNAV CAN'T REFLECT A COLUMN HEADING VALUE IN ADD N APAR SE16800: CA400EXP-OPNAV CWBUNNAV.EXE Error on browsing long directory APAR SE17023: CA400EXP-OPNAV-INCORROUT Server browse button in New Cluster wizard fails to refresh APAR SE17085: CA400EXP-OPNAV UNIVERSAL CONNECTION WIZARD RESOURCE ERROR APAR SE17092: QPWFSERVSO job hangs around after iSeries Navigator closes APAR SE17205: CA400EXP-OPNAV-INCORROUT- CPF9810 confusing message when Licensed Option 12 is not installed APAR SE17213: CA400EXP-OPNAV-DBASE-MSGSQL0109-MSGSQL0190 ALTERING COLUMNS APAR SE17322: CA400EXP-OPNAV-NETWORK-INCORROUT ISERIES NAVIGATOR TELNET APAR SE17396: CA400EXP-OPNAV-NETWORK-INCORROUT single quotes in RMTSYS APAR SE17398: CA400EXP-OPNAV-NETWORK-INCORROUT DNS SOA serial number APAR SE17405: CA400EXP-OPNAV-NETWORK-INCORROUT SOCKS Domain name server not saved APAR SE17503: CA400EXP-OPNAV Inav Parity option fails to mark all options in Availability when "CHECK ALL" box is checked APAR SE17521: CA400EXP-OPNAV-NETWORK-INCORROUT allow to configure zone TTL APAR SE17574: CA400EXP-OPNAV-MESSAGES SQL0107 when do Analyze Results on German SQL performance monitor APAR SE17654: CA400EXP-OPNAV-DBASE-INCORROUT IDENTITY COLUMN ORDER APAR SE17709: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DOUBLE $ORIGIN STRING APAR SE17769: CA400EXP-OPNAV-OUTPUT-MSG INVALID DATA INCLUDE CRITERIA APAR SE17793: CA400EXP-OPNAV INCORROUT Gui Graphics fails to show all dasd APAR SE17794: CA400EXP-OPNAV-NETWORK-INCORROUT CHILD ZONE CREATION APAR SE17854: CA400EXP-OPNAV Cannot change order of nodes in recovery domain of a CRG APAR SE17869: CA400EXP-OPNAV-NETWORK-INCORROUT Dbg Server not started APAR SE17880: CA400EXP-OPNAV-INCORROUT Standard Service Port set incorrectly for Java APAR SE17883: CA400EXP-OPNAV INCORROUT Images missing on Properties APAR SE17996: CA400EXP-OPNAV-DBASE INDEXES SUPPORT ON V5R2 APAR SE18006: CA400EXP-OPNAV-DBASE-INCORROUT TEMPORARY INDEXES APAR SE18049: CA400EXP-OPNAV-MSGCPF3342 DRAG AND DROP OF SPOOLED FILE APAR SE18070: CA400EXP-OPNAV-DBASE TABLE NAME LOST WHEN CREATING ALIAS APAR SE18109: CA400EXP-OPNAV-NETWORK UCW update to state list use APAR SE18110: CA400EXP-OPNAV-DBASE MULTIPLE INDEXES ADVISED PER TABLE APAR SE18216: CA400EXP-OPNAV-INCORROUT SSL Icon not displayed correctly. APAR SE18247: CA400EXP-OPNAV-NETWORK-INCORROUT iNav hangs, SMTP properties APAR SE18254: CA400EXP-OPNAV-INCORROUT Function Availability prompting incorrect name DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE16662: CA400EXP-DTRANSFER-INCORROUT EXCEL WITH MULTIPLE SHEETS FAILS APAR SE16753: CA400EXP-DTRANSFER-MSGCWBDB0014 WHEN DOING A DATA TRANSFER APAR SE17556: CA400EXP-DTRANSFER-MSGSQL5016 CONTAINING DOT IN FILE NAME APAR SE17875: CA400EXP-DTRANSFER-INCORROUT EXCEL EMPTY CELLS AS UNICODE DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE17733: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS APAR SE18215: CA400EXP-ODBC-UNPRED - VARIABLE LENGTH COMPRESSION ENHANCEMENT The driver's fetching of data from variable-length fields (VARCHAR, VARBINARY, VARGRAPHIC,... ) can be inefficient in some cases. An enhancement is being provided that will help with performance when using forward-only cursors. To take advantage of this enhancement, the application must be using the 'Block if fetch of 1 row' DSN option (or the BLOCKFETCH=1 keyword). That setting is enabled by default. Note, to get this enhancement to work a V5R3 iSeries server and some additional server PTFs are required. As the server PTFs become available they will be documented at: http://www-1.ibm.com/servers/eserver/iseries/access/servernotes.html APAR SE18251: CA400EXP-ODBC - IIS HANG DUE TO CLOSE CURSOR OLE DB PROVIDER --------------- APAR SE17223: CA400EXP-OLEDB-MSGCWBZZ5014 CWBZZ5014 WHEN USING IBMDA400 .NET DATA PROVIDER ------------------ APAR SE17385: CA400EXP IDB2DATA Incorrect result data on 2nd call to Execute APAR SE17432: CA400EXP IDB2DATA MSGSQL0519 after failed Execute APAR SE17639: CA400EXP IDB2DATA MSGSQL0518 Select statement parsed as a stored procedure APAR SE17960: CA400EXP IDB2DATA INCORROUT FAILURE W/RESTRICTED PERMISSIONS LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.6 (10/29/2004) and the equivalent of 5722JC1 SI16227. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE15390: CA400EXP-PRINTEMUL-INCORROUT PC5250 BESTFIT OPTION CANNOT BE APAR SE15842: CA400EXP-TERMEMUL-INCORROUT PC5250 CROSSHAIR FLICKER APAR SE15974: CA400EXP-TERMEMUL-INCORROUT MACRO RECORDING CAUSES INSTRUCTI APAR SE16377: CA400EXP-TERMEMUL-INCORROUT PCSWS ERROR ON WIN2003 PC APAR SE16461: CA400EXP-TERMEMUL-INCORROUT WS FILE STORED ON NETWORK DRIVE APAR SE16941: CA400EXP-TERMEMUL-MSGPCSWS PLAYBACK OF A MACRO CAUSES PCSWS APAR SE17146: CA400EXP-PRINTEMUL-INCORROUT INCORRECT OUTPUT WHEN USING APAR SE17386: CA400EXP-TERMEMUL-INCORROUT PC5250 DISPLAY MOSTLY BLANK FIEL APAR SE17656: CA400EXP-TERMEMUL-INCORROUT BATCH FILE PROCESSING APAR SE17658: OSP CAEXP-DSP-INCORROUT SHAPE OF YEN: AND DOLLAR:$. APAR SE17835: OSP-PAR PCSWS026 ERROR WHEN SAVING .WS FILES AFTER LOADING APAR SE17843: CA400EXP-TERMEMUL-INCORROUT HACL AUTOMATION OBJECT EVENTS NO APAR SE17965: CA400EXP-TERMEMUL-INCORROUT PC5250 PUSH BUTTON NOT RETURNING APAR SE18068: CA400EXP-TERMEMUL-WAIT EXIT HANGS WITH READ-ONLY .WS PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE17216: CA400EXP-OPCON-INCORROUT some signon failures not displayed APAR SE18139: CA400EXP-OPCON-INCORROUT RCP listed as not authorized APAR SE18189: CA400EXP-OPCON-MSG Virtual Control panel CWBOPAOC.EXE fault APAR SE18351: CA400EXP-OPCON-INCORROUT AFTER RCS TO LCS CONNECTION FAILURE 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 = SI15176 Build date = September 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE15339: CA400EXP-DTRANSFER-MSGCWBDB0052 DATA TFR DOWNLOAD TO HTML APAR SE16157: CA400EXP-SSL-INCORROUT MANDATING SSL FAILS 5250, VERIFY APAR SE16446: CA400EXP-OPNAV-INCORROUT DISCOVERY OF ADMINISTRATION SYSTEM PROBLEM APAR SE16477: CA400EXP-OPCON-INCORROUT LAN CONSOLE NOT CONNECTING ANYMORE APAR SE16866: CA400EXP-OPNAV-MESSAGES-INCORROUT MULTIPLE SEND MESSAGE ITEMS APAR SE16920: CA400EXP - Multiple Platform XDA APAR SE17036: CA400EXP-2-MSGCWB4028 RMTCMD REJECTS RESTRICTED USERS The RMTCMD program in the V5R3 iSeries Access for Windows client behaves differently than previous versions did. If the user has limit capabilities set to *YES on their user profile, RMTCMD is now rejecting attempts to run commands with a message CWB4028. It makes no difference if the command is allowed by restricted users or not, it is rejecting all commands with this message. The change was made to the client without any notification in the Memo To Users for V5R3 and is causing existing customer programs to fail and if this function does not revert back to the old behavior, those programs will need to be rewritten. The RMTCMD program will be changed back to it's previous behavior of allowing iSeries profiles with limited capabilities to execute commands. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE14716: LIC OPS NAV WAIT CONDITION APAR SE15235: OSP-DB TIME LABEL INCORRECT ON TOTAL RUNTIME LABEL IN INAV APAR SE15469: CA400EXP-OPNAV-INCORROUT Sys Monitor crash when edit values APAR SE15492: CA400EXP-OPNAV-DBASE-INCORROUT Canceling insert of a row into table causes following row to be deleted APAR SE15899: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DELETE HOST DYNAMIC APAR SE15911: CA400EXP-OPNAV-DBASE-INCORROUT SORT EXPLAINABLE STMTS LIST APAR SE15929: CA400EXP-OPNAV-NETWORK-INCORROUT DNS needs to validate subnet field APAR SE15947: CA400EXP-OPNAV-DBASE-WAIT Run SQL Scripts Save changes dialog does not appear APAR SE15975: CA400EXP-OPNAV INCORROUT create of new ASP fails to display 2105 type ESS LUNS APAR SE15985: CA400EXP-OPNAV-DBASE-UNPRED CLICKING JOURNALING CAUSES ABEND APAR SE16000: CA400EXP-OPNAV-WAIT Two TaskActionEvents for a shared propertysheet causing a hang in iNav APAR SE16041: CA400EXP-OPNAV-DBASE-INCORROUT CANNOT CREATE RANGE PARTITION APAR SE16053: CA400EXP-OPNAV-DBASE VE INDEX ADVISOR COLUMNS INFO TRUNCATED APAR SE16055: CA400EXP-OPNAV-DBASE DBNAV SCHEMA IN PROPERTIES INCORRECT APAR SE16056: CA400EXP-OPNAV-DBASE F4 KEY DOES NOT LAUNCH SQL ASSIST APAR SE16075: CA400EXP-OPNAV HAT V5R3 GEO mirroring returns inappropriate message for error condition APAR SE16130: CA400EXP-OPNAV Send SNA panel hangs APAR SE16141: CA400EXP-OPNAV SQL7008 WHEN EDIT TABLE IN CHINESE APAR SE16167: OSP SI13587 CAUSED DATE/TIME FORMAT CHANGE IN OPSNAV APAR SE16458: CA400EXP-OPNAV-MSGJAVAX.SWING.JLABEL WHEN VIEWING PERMISSION APAR SE16475: CA400EXP-OPNAV-INCORROUT SMTP SERVER NAME GETS CHANGED TO APAR SE16486: CA400EXP-OPNAV-INCORROUT Preferred node status change - error for site name APAR SE16561: CA400EXP-OPNAV Inserting rows into table with default values for DATE field produces "Error in assignment" APAR SE16646: CA400EXP-OPNAV-NETWORK-INCORROUT Can't create 1GB ifc w/5700 APAR SE16647: CA400EXP-OPNAV-NETWORK-INCORROUT NAS Batch file NET USER password should not be random string APAR SE16661: CA400EXP-OPNAV-USRGRP-INCORROUT Add LCLPWDMGT parameter The Local password management (LCLPWDMGT) parameter is not available when using iSeries Navigator Users and Groups to create or change a user profile. A checkbox needs to be added to the Users and Groups Capabilities->Password tab display panel to allow IBM Integration for Windows Server users to decide if they want to "Manage this password locally". For more information regarding the changes to iSeries Navigator for managing your IBM Integration for Windows Server users go to http://www.ibm.com/servers/eserver/iseries/navigator/faqs.html#lclpwdmgt APAR SE16751: CA400EXP-OPNAV-NETWORK UCW support for backup VPN to Rochester SDC This Universal Connection Wizard update corresponds with host PTF 5722SS1 SI15166 to configure a backup VPN universal connection. This fix affects the output of the Universal Connection Wizard to support a backup service data center for downloading fixes. The wizard will create a second dial profile in the VPN scenario QTOCL2TP2. To complete creation of the second VPN connection there will be an additional VPN connection QIBMSERVICE52 and a corresponding IKE policy. The Universal Connection Manager on the iSeries will use the backup VPN connection should the primary be unavailable. APAR SE16752: CA400EXP-OPNAV-DBASE-INCORROUT CREATE ADVISED INDEX SCHEMA APAR SE16762: CA400EXP-OPNAV-INCORROUT System status field 'Shared processor pool usage' shows incorrect data APAR SE16838: CA400EXP-OPNAV-DBASE-INCORROUT COLUMN WITH NO DEFAULT APAR SE16926: CA400EXP-OPNAV CPFB957 Endpoint system not found APAR SE17022: CA400EXP-OPNAV CTL-C of spooled file Followed by Paste Fails APAR SE17045: CA400EXP-OPNAV-FILESYS-INCORROUT OSP COPY/PASTE FROM QTCPTMM IN OPS NAV PUTS FILES IN ROOT OF APAR SE17082: CA400EXP-OPNAV-MESSAGES String index out of range when execute blank statement in Run SQL Scripts DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE15149: CA400EXP-ODBC-UNPRED - ROW-WISE BINDING PROBLEM APAR SE15598: CA400EXP-ODBC-UNPRED SQLSETPOS RETURNS DRIVER NOT CAPABLE ER An application uses Microsoft RDO and iSeries Access for Windows ODBC to access lob fields. The application uses a block size of 100 rows on the fetch, then attempts to use SQLSetPos and SQLGetData to access the lob data. The ODBC driver returns SQLState S1C00 "Driver not capable" on the SQLGetData api. The error is caused because the odbc driver does not support positioning to a specific row in a block fetch when the requested block size is greater than 1. This restriction is described in the ODBC driver metadata via the SQLGetInfo SQL_GETDATA_EXTENSIONS API. The driver is adding support so that SQLSetPos can be called to position to the first row in a rowset. The driver will return the "driver not capable" error on a SQLSetPos call if an attempt is made using this API to position to a row beyond on the first in the rowset. APAR SE15814: CA400EXP-ODBC CATALOG_NAME NAMES ARE PADDED WITH SPACES APAR SE15895: CA400EXP-ODBC-MSGINTERNAL DRIVER ERROR INTERMITTENT FAULT IN APAR SE16131: CA400EXP-ODBC-UNPRED - PACKAGE PROBLEM WITH STATEMENT IN USE APAR SE16287: CA400EXP-ODBC-MSGSQL7008 AUTOCOMMIT OFF COMMIT MODE CHANGED APAR SE16834: CA400EXP-ODBC-INCORROUT INCORRECT DECIMAL PARAMETER VALUES APAR SE16919: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS OLE DB PROVIDER --------------- APAR SE15785: CA400EXP-OLEDB-INCORROUT ADO ActualSize wrong for LOBS. APAR SE15809: CA400EXP-OLEDB-MSGCPF9810 TABLE NAME LISTED AS THE LIBRARY APAR SE16302: CA400EXP-OLEDB-MSGCWBZZ5014 INSERT/UPDATE TABLE WITH LOB APAR SE16667: CA400EXP-OLEDB-INCORROUT SQLSTATE NOT SET FOR COMM ERROR .NET DATA PROVIDER ------------------ APAR SE15897: CA400EXP IDB2DATA Add iDB2ProviderSettings class A new class is needed to enable static, process-wide settings for the IBM.Data.DB2.iSeries .NET provider. The following new class will be created: Class name: iDB2ProviderSettings Description: Provides a way to set process-global provider settings. This class cannot be inherited. Property name: static string ProviderVersion (read-only) Description: Returns a string containing the IBM.Data.DB2.iSeries .NET provider's AssemblyFileVersion. Method name: static void CleanupPooledConnections() Description: Performs orderly cleanup of pooled connections. Calling this method just before your process terminates will ensure pooled iDB2Connections get cleaned up properly. Make this method the last call you make before your process terminates. This ptf adds the new iDB2ProviderSettings class. APAR SE16002: CA400EXP IDB2DATA CommandBuilder fails with WHERE clause APAR SE16003: CA400EXP IDB2DATA Exception with Decimal/Numeric result data APAR SE16036: CA400EXP IDB2DATA Fix incorrect parameter handling for Stored Procedures APAR SE16951: CA400EXP IDB2DATA Add support for LOBs and Library List Add support for LOBs and Library List to the .NET provider. The following new data types are added: iDB2Blob - represents a binary large object iDB2Clob - represents a character large object iDB2DbClob - represents a double byte character large object A new iDB2NamingConvention enum is created that allows the application to select SQL naming or System naming. The iDB2Connection class has the following new properties: Naming - to control the naming convention (SQL or System). Value is specified as either SQL or System. MaximumInlineLobSize - to control the threshold at which LOB data is transferred using LOB Locators, instead of as inline data. Value is an integer in the range 0-15360 which specifies the maximum size (in kilobytes) of a LOB which can be retrieved from the host server in a single operation. LibraryList - allows the application to set the user portion of the host server job's library list. If the application wants the DefaultCollection included in the library list, it must include it in the LibraryList property. LibraryList is a comma-delimited list of library names which may contain the special name *USRLIBL, which is a placeholder to indicate the host server job's current user portion of the library list. By placing other library names before or after *USRLIBL, the application can control where the libraries get added in relation to the job's current user library list. If *USRLIBL is not specified in the LibraryList, the specified libraries will replace the server job's current user library list, so applications that wish to add to the library list should be sure to specify *USRLIBL somewhere in the LibraryList. The iDB2DataReader class has the following new methods: GetiDB2Blob(int index) GetiDB2Clob(int index) GetiDB2DbClob(int index) This ptf adds LOB and Library List support to the .NET provider. APAR SE17162: CA400EXP IDB2DATA Decimal/Numeric digits truncated LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.5 (07/30/2004) and the equivalent of 5722JC1 SI14873. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE14730: CA400EXP-TERMEMUL-INCORROUT PC5250 NEGOTIATES WRONG KBDTYPE APAR SE15297: OSP PCSERR101 ERROR WHEN A COPY/PASTE FUNCTION IS PERFORMED. APAR SE15562: CA400EXP-TERMEMUL-MSGPCSERR999 MACRO LIMITED TO 64KBYTE APAR SE15735: CA400EXP-PRINTEMUL-UNPRED PRINTER SETUP WINDOW DOES NOT DISP APAR SE15931: CA400EXP-TERMEMUL-INCORROUT AFTER RETURNING TO CALLING PGM APAR SE16801: CA400EXP-TERMEMUL-INCORROUT GERMAN FUNCTION KEY ALT K IS NOT PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE13412: CA400EXP-OPCON-INCORROUT REMOTE CONTROL PANEL FAILS APAR SE16299: CA400EXP-OPCON-INCORROUT wizard hangs in WinNT APAR SE16534: CA400EXP-OPCON-INCORROUT fault RCS to LCS and firewall APAR SE16535: CA400EXP-OPCON-INCORROUT close may hang APAR SE16821: CA400EXP-OPCON-INCORROUT emulator may not start PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- Non-APAR fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI13587 Build date = May 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE12606: CA400EXP-2-MSGCWBCF0005-F/CWBBACK CWBBACK FAILS WHEN DBCS INVOLVED APAR SE13599: CA400EXP - Add 64 bit support to XDA Windows client APAR SE13926: CA400EXP-CONNECTIONS-UNPRED NO CWBCFG KERBEROS SETTING The cwbcfg utility provides a parameter for configuring the signon mode of the connection being defined: /uid . All signon modes may be set using this parameter except the use of Kerberos. The /uid parameter of cwbcfg now accepts the value *KERBEROS which configures the connection to use Kerberos for authentication. For example: cwbcfg /host server1 /uid *KERBEROS creates a connection to server "server1" and configures it for all users of the PC, and for the Default User, so that Kerberos is used for authentication. Previously, the only allowed values were *WINLOGON, *PROMPTALWAYS, and an actual iSeries user ID. IMPORTANT NOTE: Although you can now configure the new connection to use Kerberos, authenticating this way may not work. One possible reason is that the new or changed connection is configured only for accounts local to the PC on which cwbcfg is run. Successful use of Kerberos may require logging on to a domain, and local account configuration information is not typically used for domain logons. This is no different from the case in which a user logs on to the local PC, then uses iSeries Navigator to configure a connection to use Kerberos as the means of authentication. APAR SE14941: CA400EXP-DTRANSFER Help not displayed APAR SE15016: SSL - Update default key database A VeriSign Global Server Intermediate Root CA certificate has expired on January 7, 2004. This CA certificate was included in the default SSL key database shipped with the product. Updated SSL key database files (cwbssldf.kdb and cwbssldf.sth) will be provided by this service pack. The new files will only be installed if the previous files are deleted or do not exist in the Common Documents folder. APAR SE15205: CA400EXP - Incorrect data passed to database server from XDA Windows client APAR SE15507: CA400EXP-OPCON-INCORROUT CWBOPAUT.DLL ERROR APAR SE15715: CA400EXP-INCORROUT cwblmsrv background task not exiting OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE12438: CA400EXP-OPNAV-OUTPUT-INCORROUT CWBUN_GETPUBLICLISTOBJECT AP APAR SE12441: CA400EXP-OPNAV-NETWORK-MSGCPI0954 CREATE DISK TO MAX ASP USE APAR SE12774: CA400EXP-OPNAV-DBASE-INCORROUT CREATE NEW VIEW DIALOG MAY NO APAR SE12976: CA400EXP-OPNAV-DBASE-INCORROUT PROMPTING FOR PASSWORD APAR SE13504: CA400EXP-OPNAV-INCORROUT LPAR Create wizard doesn't use regional setting for shared procs APAR SE13614: CA400EXP-OPNAV-NETWORK Universal Connection Wizard modal to frame APAR SE13616: CA400EXP-OPNAV-NETWORK-INCORROUT Leased lines line profile cannot be updated APAR SE13629: CA400EXP-OPNAV-NETWORK Remote support authentication ids to allow connect APAR SE14019: CA400EXP-OPNAV-NETWORK-INCORROUT File extensions corrupted on add share APAR SE14236: CA400EXP-OPNAV ISERIES NAVIGATOR HANG LISTING PRINTER OUTPUT APAR SE14383: CA400EXP-OPNAV-NETWORK Routes not added when configuring an ATT dial connection APAR SE14408: CA400EXP-OPNAV-FILESYS-PERFM LONG DELAYS WHEN MOVING MULTIPL APAR SE14555: CA400EXP-OPNAV-NETWORK-INCORROUT DNS ENABLES ADD HOST APAR SE14558: CA400EXP-OPNAV-NETWORK-INCORROUT SMTP properties update fails APAR SE14569: CA400EXP-OPNAV-INCORROUT MC Task Status window does not always paint APAR SE14570: CA400EXP-OPNAV-NETWORK UCW Qtocl2txx line description wrong APAR SE14574: CA400EXP-OPNAV-INCORROUT Changing Max graph value on graph history takes two refreshes to take effect APAR SE14585: CA400EXP-OPNAV-NETWORK UCW phone5 call list to phone4 APAR SE14644: CA400EXP-OPNAV-NETWORK RAS PPP filter identifier list empty APAR SE14720: LIC-DISK-STG OPS NAV DISK POOLS DISPLAY PROBLEM APAR SE14734: CA400EXP-OPNAV-INCORROUT CURRENT ADMINISTRATION SYSTEM/USER CAN NOT BE REMOVED APAR SE14800: CA400EXP-OPNAV-NETWORK-INCORROUT Webfacing settings not saved APAR SE14802: CA400EXP-OPNAV-NETWORK-INCORROUT Netserver Single Signon failing due to uppercase keytab entries. APAR SE14914: CA400EXP-OPNAV-INCORROUT Capabilities->Auditing page must be hidden for non-administrators APAR SE14968: CA400EXP-OPNAV- PRINTER OUTPUT ACTION ERROR IN OUTQ SHORTCUT APAR SE14983: CA400EXP-OPNAV-NETWORK-INCORROUT QoS Configuration GUI ignores subnet mask input when creating a new Client object APAR SE15045: CA400EXP-OPNAV User registration is not working Service Agent user registration fails using iSeries Navigator. NOTE: In order for this fix works properly you need to install PTF SI13239 for the OS/400 operating system (5722SS1) or one that supersedes it in the iSeries server that is specified as Management Central system. APAR SE15048: CA400EXP-OPNAV ESA Verify connection to IBM is hung Verifying connection to IBM window is hung NOTE: In order for this fix works properly you need to install PTF SI13239 for the OS/400 operating system (5722SS1) or one that supersedes it in the iSeries server that is specified as Management Central system. APAR SE15049: CA400EXP-OPNAV ESA Subsystem jobs window APAR SE15050: CA400EXP-OPNAV ESA License not displayed for any release APAR SE15052: CA400EXP-OPNAV-AUTHLIST-INCORROUT Need to display description of Authority lists in iSeries Navigator Window APAR SE15081: CA400EXP-OPNAV-UNPRED Moving node up to be primary in Recov. Domain doesn't show entire line moving & "ineligible" node status APAR SE15105: CA400EXP-OPNAV-INCORROUT When adding a data port ip address fails, the address still shows up in the gui like it was successful APAR SE15106: CA400EXP-OPNAV-PERFM Occasional Hangs during make available APAR SE15122: CA400WINOPT-OPNAV Support new hardware for V5R3M0 on Graphical Views No graphical views for the new hardware. Graphical views added. Requires PTF 5722999 MF32576 as well. APAR SE15148: CA400EXP-OPNAV-INCORROUT Cannot Display Disk Pool Properties Of Mirrored IASP APAR SE15212: CA400EXP-OPNAV-DBASE-INCORROUT SCHEMA STARTS WITH @ # $ APAR SE15219: CA400EXP-OPNAV-OUTPUT-INCORROUT SPOOLED FILE LIST INCOMPLETE APAR SE15222: CA400EXP-OPNAV-INCORROUT Error removing user in Customize Access dialog APAR SE15282: CA400EXP-OPNAV-INCORROUT Consolidated Hardware File saved to incorrect path APAR SE15308: CA400EXP-OPNAV-INCORROUT Suspend Geographic Mirroring menu item occasionally in incorrect state APAR SE15367: CA400EXP-OPNAV-NETWORK-WAIT Directory Server Propertysheet hangs searching/updating the configuration APAR SE15388: CA400EXP-OPNAV-UNPRED APPLICATION DEVELOPMENT FOLDER MISSING APAR SE15395: CA400EXP-OPNAV-INCORROUT Adding a data port ip address failure still shows up as successful APAR SE15500: LIC-DISK-STG-UNPRED APAR SE15501: CA400EXP-OPNAV Drop down with wrong value on Edit Time Zone APAR SE15511: CA400EXP-OPNAV-INCORROUT Intelligent Agent panel hangs APAR SE15512: CA400EXP-OPNAV-NETWORK Unable to turn off LDAP filter cache support APAR SE15513: CA400EXP-OPNAV-INCORROUT Configuring a V5R2 server that is a replica to a master fails. APAR SE15514: CA400EXP-OPNAV-INCORROUT Directory Server publishing fields not enable/disabled correctly. APAR SE15526: CA400EXP-OPNAV-DBASE-WAIT CANNOT LAUNCH EXPRESSION BUILDER APAR SE15527: osp - Deleting a data port IP address fails APAR SE15528: CA400EXP-OPNAV-INCORROUT Removing a node in a recovery domain handled incorrectly APAR SE15545: CA400EXP-OPNAV Cannot Deconfigure Just A Secondary IASP APAR SE15546: CA400EXP-OPNAV-INCORROUT GUI is partially untranslated APAR SE15748: CA400EXP-OPNAV Site name & membership status incorrect in recovery domain when moving nodes DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE15025: CA400EXP-DTRANSFER - UTF-8 ALWAYS TRUNCATES SPACES APAR SE15133: CA400EXP - DTRANSFER - trap opening TTO file APAR SE15135: CA400EXP-DTRANSFER UNICODE AND UTF8 PROBLEMS APAR SE15716: CA400EXP-DTRANSFER trailing blanks cause CWBLM0040 APAR SE15767: CA400EXP-DTRANSFER THE BROWSE FILES AND MEMBERS WINDOW FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE15356: CA400EXP-DTRANSFER-INCORROUT FDF DATE/TIME SETTINGS RESET WHEN USING USING EXCEL WIZARD ODBC ---- APAR SE13347: CA400EXP-ODBC-UNPRED SQLCOLATTRIBUTES SQL_COLUMN_SEARCHABLE APAR SE14242: CA400EXP-ODBC-MSGCPF5035 OVERLAY OF PARAMETER DATA ON SECON APAR SE14415: CA400EXP-ODBC-INCORROUT - RETURN TIME, DATE, TIMESTAMP AS SQL_CHAR APAR SE14963: CA400EXP SQLEXTENDEDFETCH RETURNS PWS0001 RETURNING DATA FRO APAR SE15056: CA400EXP-ODBC-INCORROUT - OVERRIDE PASSWORD ENHANCEMENT When connecting with ODBC and your password is expired on the server, an error or a dialog asking the user to change the password is returned to the application. To avoid the error and possible dialog, an enhancement is being provided to allow an application to programmatically change the user's password. An example scenario on how this might be used is listed below: The application calls SQLDriverConnect with the SQL_DRIVER_NOPROMPT DriverCompletion option and the userid (UID keyword) and password (PWD keyword) specified in the connection string. Since the userid and password combination is expired, an error (SQL_ERROR) is returned to the application. No prompts are returned because of the SQL_DRIVER_NOPROMPT option. The application calls SQLError (or SQLGetDiagRec) to get back the NativeError. If the native error is 8003 then this is the case where the userid/password combination was expired. The application calls SQLDriverConnect with the userid (UID keyword), current password (PWD keyword), and the new password (NEWPWD keyword) specified in the connection string. The driver will change the password for that user profile to the new password if the current password is valid. APAR SE15502: CA400EXP-ODBC-INCORROUT - FIX SQLPROCEDURECOLUMNS ISSUES THAT COULD CAUSE FAULTS OLE DB PROVIDER --------------- APAR SE14470: CA400EXP-OLEDB-INCORROUT ZERO LENGTH PARAMETER DATA INCORREC APAR SE15283: CA400EXP-OLEDB-UNPRED RLA RANDOM TRACE APAR SE15503: CA400EXP-OLEDB-INCORROUT BLANK STRINGS RETURN INCORRECT DATA .NET DATA PROVIDER ------------------ APAR SE13984: CA400EXP IDB2DATA MSGSQL0501 Cursor not open error APAR SE13985: CA400EXP IDB2DATA INCORROUT iDB2CommandBuilder fails with table created using DDS APAR SE13986: CA400EXP IDB2DATA INCORROUT DeriveParameters not setting Size and IsNullable APAR SE14008: CA400EXP IDB2DATA INCORROUT DeriveParameters not setting ParameterName APAR SE15169: CA400EXP IDB2DATA .NET traces and logs sometimes do not work APAR SE15170: CA400EXP IDB2DATA Fix several problems with .NET provider A new method is added: iDB2DataReader.HasRows(). This method can be called to determine if the iDB2DataReader returned any rows. A final change is made to remove the public constructor for the iDB2ParameterCollection class. The parameter collection is always associated with an iDB2Command and should not be created by an application. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- Non-APAR fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.3 (04/02/2004) and the equivalent of 5722JC1 SI13437. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE12161: CA400EXP-TERMEMUL-INCORROUT IBM3270-1250 FONTS ARE NOT APAR SE12423: CA400EXP-TERMEMUL-INCORROUT CHARACTERS NOT CHANGED TO UPPERC APAR SE12821: CA400EXP-TERMEMUL-UNPRED PC5250 SESSION DROPPING WHEN USING APAR SE13349: CA400EXP-TERMEMUL-DBCS U/3010(EBCDIC:X/4466) CANNOT DISPLAY APAR SE13430: CA400EXP - TERMEMUL - Add support for LotusScript Extension APAR SE13431: TERMEMUL Signed Numeric won't paste to protected fields Currently if you copy and paste numeric fields they will paste into unprotected and protected fields. But if you copy and paste signed numeric fields, they will not paste into protected fields. This fix is enabled when the existing option, "Force Leading +/-", is ON. APAR SE13658: CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE ISSUE ON JAPANESE APAR SE13859: OSP-PAR RUNTIME ERROR. ABNORMAL PROGRAM TERMINATION. APAR SE13964: CA400EXP-TERMEMUL-INCORROUT DATA IN BLINKING FIELDS DOES NOT APAR SE13971: OSP-PAR USING VBSCRIPT MACROS MULTIPLE TIMES IN PC5250 HANGS APAR SE13991: CA400EXP-TERMEMUL-UNPRED FUNCTION AND ENTER KEYS INTERMITTEN APAR SE15134: CA400EXP-TERMEMUL PrintScreen doesn't work PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE14819: CA400EXP-OPCON-INCORROUT GUI can hang when CPU is busy APAR SE15504: CA400EXP-OPCON-INCORROUT cwbopcon fault during disconnect APAR SE15505: CA400EXP-OPCON-INCORROUT 5250 emulator doesn't connect APAR SE15506: CA400EXP-OPCON-INCORROUT status 'connected' but system down PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE15136: CA400EXP-INCORROUT cwbCO_GetPasswordExpireDate The API cwbCO_GetPasswordExpireDate returns CWB_INV_BEFORE_VALIDATE when user profile set to *NOMAX. The documentation for API cwbCO_GetPasswordExpireDate will be updated as follows: CWB_INV_BEFORE_VALIDATE The user ID and password that were set in the specified system object have not been validated (so the password expire date is not available), or validation has occurred and the user profile password expiration interval is set to *NOMAX. Usage You must successfully call cwbCO_VerifyUserIDPassword, cwbCO_Signon, or cwbCO_Connect before calling cwbCO_GetPasswordExpireDate. (Note: CWB_INV_BEFORE_VALIDATE can represent a successful call, if the user profile password is set to never expire (*NOMAX) ) If you want to ensure that the value that is returned is recent, you either must call cwbCO_VerifyUserIDPassword explicitly, or set the Validate Mode to CWBCO_VALIDATE_ALWAYS before you call cwbCO_Signon or cwbCO_Connect. 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 SI17742 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 and .TFR 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.