============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R2M0 Cumulative Service Pack Level ------------- SI09809 ------------- (c) Copyright IBM Corporation 2002. All rights reserved. ======================================================================== 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 RESTRICTIONS 2.1 iSeries NAVIGATOR 2.2 iSeries OPERATIONS CONSOLE 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI09809 (October 2003) 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. 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. 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 tailor the Client Access Express 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 temporary directory. 2. Run PTFFORM.EXE to expand the service pack files and copy them into an iSeries Access for Windows installation image directory, replacing any existing files. 3. Delete PTFFORM.EXE after it has completed its processing. 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 3-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 RESTRICTIONS ----------------- 2.1 iSeries NAVIGATOR ---------------------- 1) Due to technology incompatibilities, occasionally a window can be displayed behind other windows when running the iSeries Navigator. If the iSeries Navigator looks like it has stopped working, it is possible that the window you are waiting for is being displayed behind another window on your desktop. Press the Alt key and then the Tab key to see a list of all the windows on your system and select window behind the iSeries Navigator window, or another window on your desktop. 2.2 iSeries OPERATIONS CONSOLE -------------------------------- 1) It is recommended that you restrict LAN topologies for LCS attachment to a single, physical ring/hub/switch fabric. In the event that the LCS is used in a larger network topology, broadcast (DHCP) packet filtering is always recommended. 2) The maximum number of concurrent active sessions via the PCOM 5250 emulator is 26. 3) If an automatic session re-connect to an OS/400 image on an iSeries or iSeries server on iSeries Operations Console start-up fails, simply use the manual re-connect process by right-clicking the connection profile that failed to re-connect and selecting 'Connect'. 2.3 Management Central -------------------------------- The problem identified regarding a Management Central File Monitor not triggering when "System logs" is the option selected for "Files to monitor" on the General property page has been resolved. IMPORTANT NOTE: You must also install V5R2 HOST PTF SI08454 in order to fix this problem. 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 = SI09809 Build date = October 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE10680: CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION V5R2 CLI Client Detection of Central Settings in Application Administration of iSeries Navigator only works for Manual Detect; fails for Automatic and Install. Automatic and Install Client Discovery methods have been added. CIRCUMVENTION: The client must manually add a system/user pair and set that system/user pair as the current Administration System and Administration User in order for Central settings to be successfully administered from the Administration System to the Client PC. APAR SE10769: CA400EXP-APIS-INCORROUT SAP400 WITH WINDOWS APPLICATION SERV Running the SAP400 application with a Windows application server, the database may return no data (null values) for fields in the database that contain data, but experience data truncation during the fetch. This happens only on the Windows application server, iSeries application server and local instances (2-tier) work properly. The XDA Windows Client has been enhanced to fix the data truncation problem seen after doing a FETCH or an Execute. APAR SE10863: CA400EXP-TERMEMUL-INCORROUT CREATE 5250 ICON FAILS CWBCFG is run to set the PC5250 files path to each user's My Documents directory, as follows: cwbcfg /pc5250path *MYDOCUMENTS After this, restricted users cannot perform PC5250-related tasks that require changing or creating PC5250 files. For example, creating an icon for or saving a new session, creating a macro, and changing the keyboard map settings all may fail. This PTF fixes the reported problem. However, there are possible side-effects the user should be aware of. If cwbcfg.exe was used with "/pc5250path *MYDOCUMENTS" before applying this fix, the following are true: 1) All users' PC5250 paths were set to the My Documents of the user who last ran cwbcfg.exe with this option. 2) Any user who changed his PC5250 path using the PC5250 tab of iSeries Access for Windows Properties replaced the incorrect path with the correct one. 3) Users with enough authority -- for example, users in the Administrators group -- will see no failure since they have write access to the other user's My Documents. 4) Users without such authority will fail as described. 5) After this fix is applied, running cwbcfg.exe specifying "/pc5250path *MYDOCUMENTS" will change each users' PC5250 path to that user's correct My Documents location. Because of (3) and (5) above, some users may, after this fix is applied and cwbcfg.exe is run, no longer have access to their saved PC5250 connections, macros, etc. To have access to these things, an administrator of the PC must manually copy PC5250-related files from the old PC5250 path to the new one. This has always been true when a user's PC5250 path has been changed. APAR SE11169: CA400EXP-OPNAV-FILESYS-INCORROUT IFS NETSERVER SHARE LISTING When an IFS netserver directory is selected in iSeries Navigator, the right pane file listing shows no contents. Additionally, the directory cannot be expanded in the left pane. This occurs after changing something related to the directory, such as sharing the directory. It occurs only when a policy is active that mandates that a specific default user ID is used for all connections. Ending and re-starting iSeries Navigator causes expanding and browsing IFS directories to work again. When the same default user ID policy is active, then verifying any connection also fails. Using iSeries Navigator, when a system is selected, then File -> Connection to Server -> Verify Connection is selected, the verify window that usually contains messages showing the results of the verification instead contains no messages. Also, connection verification from a command prompt using the cwbping program fails. When run, the program banner is displayed, but messages showing the results of the verification are not displayed. CIRCUMVENTION: After making a change to a directory that causes that directory to become unnavigable, end and re-start iSeries Navigator. A circumvention for all problems listed is to disable the policy that mandates a specific default user ID. APAR SE11183: CA400EXP-INSTALL-UNPRED SELECTIVE PLUGIN COMPLETION PERCENTAGE When selectively installing an iSeries Navigator plugin that is larger than approximately 20.5 MB, the install completion percentage indicator behaves unpredictably. In most cases it will stay at the starting percentage for the duration of the plugin install. Selective Setup will be fixed to properly handle a large size value within a 4-byte integer calculation. APAR SE11205: CA400EXP-SERVICE-INCORROUT AppAdmin Autostart service job The "Start diagnostic tools at computer startup" check box on the diagnostic tools tab in the control panel iSeries Access properties, would remain checked when the corresponding Application Administration setting was only suggested and the user tried to clear the check box. CIRCUMVENTION: Create/Update the following registry key with the proper value ( 1=start, 0=no start ): [HKEY_CURRENT_USER\Software\IBM\Client Access Express\CurrentVersion\Service\Cwbsvd] "Autostart background service job"=dword:00000000 APAR SE11653: CA400EXP - XDA performance enhancements The current to/from ASCII/EBCDIC data conversion is causing performance problems within XDA. The to/from ASCII/EBCDIC data conversion performance problems have been alleviated and the user can now specify whether to use the new data conversion, or the old data conversion via the DataConv.reg registry file that has been added to this service pack. The user may edit the DataConv.reg file in any text editor and determine which data conversion method to use. When editing the registry file and setting the ConversionVal to '0' (default), the new conversion method will be used. By setting the ConversionVal to '1', the old conversion method will be used. The user can apply the value to the proper spot in the Windows registry by double-clicking on the DataConv.reg file or by opening a command prompt and typing "start dataconv.reg". This change will affect the whole PC. APAR SE11654: CA400EXP - Hard Close output incorrect in XDA Windows Client The output returned when specifying the ODP threshold on a "Hard Close" operation through the XDA Windows Client is incorrect. Endian conversion was added to return the proper data when specifying the ODP threshold on a "Hard Close" operation through the XDA Windows Client. APAR SE11769: CA400EXP - CA comm layer and tracing in XDA Windows client The XDA Windows client is not well-integrated into the iSeries Access for Windows core. The XDA Windows client has been more tightly integrated with the iSeries Access for Windows core. This makes the Windows XDA client more serviceable, since it now logs to iSeries Access for Windows Detail Trace. It makes the Windows XDA client more configurable, since communications parameters that could only be set before through use of sndbufsz.reg, specifically the TCP send buffer size and TCP receive buffer size, can now be set using the cwbcopwr.exe utility, as can others. (Note: Because of this enhancement, sndbufsz.reg is obsolete starting with this service pack. Also note that use of cwbcopwr.exe is recommended for advanced users only.) Implementation of this tighter integration required changes to the XDA server. Once this service pack or any later one is installed, any iSeries server connected to using the Windows XDA client must have PTF SI10128 applied if running v5r2 OS/400, or PTF SI10160 applied if running v5r1 OS/400. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- IMPORTANT NOTE for Management Central: You must also install V5R2 HOST PTF SI08454 in order to fix the problem identified regarding a Management Central File Monitor not triggering when "System logs" is the option selected for "Files to monitor" on the General property page. APAR SE10286: CA400EXP-OPNAV UNABLE TO DELETE SQL MONITOR BY INAV When we try to delete SQL performance monitor from iSeries Navigator, it failes with message such as monitor status not valid, but it actually in End status. CIRCUMVENTION: The following instructions explain how to delete the SQL monitors until the fix is applied: 1. DELETE THE DATA FILES ON THE ISERIES. To do this, Right-click on the SQL monitor in the iSeries Navigator list, and select Properties. Then select the Saved Data tab. This tab shows the name of the library and the names of the files into which the SQL monitor data was saved on the iSeries. Write down the names, and then delete those files. You can delete them either from the iSeries Navigator by opening the library folder that the files are in (you may need to add the library to the list of displayed libraries) or by entering the following SQL statement into the Run SQL Scripts window: DROP TABLE library.filename (note: "library" and "filename" are the names you wrote down) 2. REMOVE THE SQL MONITOR FROM THE LIST. To do this, open a Run SQL Scripts window by right-clicking on the folder with the database name in the tree pane of the iSeries Navigator. Then enter one of the following commands, depending on whether the monitor is a 'Detailed' or 'Summary' monitor. For summary monitors: DELETE FROM QUSRSYS.QAUGDBPMD WHERE "Name" = 'mymonitor' For detailed monitors: DELETE FROM QUSRSYS.QAUGDBPMD2 WHERE "Name" = 'mymonitor' (note: mymonitor is the name of the monitor to be deleted) APAR SE10324: TCPIP CANNOT MAKE CHANGES TO DNS CONFIG USING OPSNAV Customer adds DNS information to primary domain. When he tries to save config. OPSNAV hangs and he loses his config. APAR SE10394: OSP-PAR ACCESSING MGTC GRAPH History DATA LOCKS OPERATIONS NAVIGATOR Accessing Management Central graph history data locks Operations Navigator, when viewing the data at one hour intervals. APAR SE10515: CA400EXP-OPNAV-INCORROUT CONFIGURING A SWEDISH LPAR SYSTEM LPAR system with two partitions named PRIMARY and UTVECKL. When customer uses iSeries Navigator to work with LPAR the name of the primary partition is translated into Swedish. Thus the error: "Character is not allowed in partition name". When changing attributes on the primary partition, customers who are using NLVs other than English can get an error message stating that their partition name is incorrect. This error message has been removed. APAR SE10617: OSP-DB ERRORS WHEN USING ISERIES NAVIGATOR "The instruction at "0x7092c4c1" referenced memory at "0x09ac3eb4". The memory could not be "written". This error occurs simply clicking once on "File Systems" and then on "Integrated File System" or "File Shares". The instruction number and the memory addresses referenced in the error text may vary. Sometimes the customer got error for instruction "0x73D41351" to address "0x00000004" and instructions "0X64B845D3" to address "0x00000004". These hex instructions and number seems to change when the tests are repeated and/or different functions are clicked (opening DB or File System). APAR SE11065: CA400EXP-OPNAV-OUTPUT Printer Output ERROR non-English workstations iSeries Navigator issues CWBUNNAV.EXE error when opening Work Management, Outq and right clicking on a spool file. This only occurs on non-English workstations. APAR SE11159: CA400EXP-OPNAV-OUTPUT PASTING SPOOLED FILES TO DESKTOP FAILS Attempting to copy/paste or drag/drop multiple spooled files from iSeries Navigator to the desktop will fail and not all of the spooled files will reach the target. APAR SE11223: CA400EXP-OPNAV-OUTPUT-PERFM CONVERT TO PDF OPTION IN OPS NAV Attempting to email a SPLF in *HOLD or *SAVE status using the convert to PDF option in Operations Navigator, the copy of the SPLF shows up in a HOLD status in the Infoprint server email outq. The SPLF has to be released in the Infoprint server OUTQ before the SPLF will be emailed. If the original spooled file is held, AFP Manager releases the copy of the spooled file so it will automatically be sent as e-mail, stored in the IFS, or spooled to an output queue. CIRCUMVENTION: Release the copied spooled file. APAR SE11504: CA400EXP-OPNAV-OUTPUT-INCORROUT INCORRECT DISPLAY OF ISERIES Status of system monitor was incorrect after a server ended. Status indicator stayed green. Japanese language may be an issue. String literals were used in the naming of certain system monitor iSeries Navigator internal structures causing problems in languages other than US English. The string literals are no longer used. APAR SE11590: OSP-DB FILE CREATED WITH SRTSEQ TABLE SHOWS INCORRECT SRTSEQ File created with SRTSEQ table shows incorrect SRTSEQ in iSeries Navigator DSPFD shows: Sort Sequence SRTSEQ Table Name . . . . . . . . . . . . . . . : QLA10025S Library . . . . . . . . . . . . . . . . : QSYS iSeries Navigator table properties shows a value of "By hex value". APAR SE11599: CA400EXP-OPNAV-DBASE-INCORROUT RUN & EXPLAIN DOES NOT Run & Explain does not accurately display the "Total Execution Time" for a query. This PTF fixes the reported problem. Note that it may now take longer to see the Visual Explain diagram when performing Run & Explain in the Run SQL Scripts window, because with this change the diagram is not built until all rows of the query have been fetched. This change will only be in effect when the graph detail setting is FULL, and the query is not for update. APAR SE11645: CA400EXP-OPNAV-NETWORK-INCORROUT Error on domain "A" record The DNS configuration interface iSeries Navigator does not allow an "A" record for a domain. APAR SE11646: CA400EXP-OPNAV-NETWORK-INCORROUT Keep RBL if add SMTP filter If a user goes into SMTP properties and adds any filter without first looking at the Connections Restrictions page, the RBL list will be reset. APAR SE11647: CA400EXP-OPNAV-NETWORK-INCORROUT Allow apostrophe in SMTP filter In SMTP properties, you can't add a filter containing an apostrophe. CIRCUMVENTION: Enter a pair of apostrophes in the GUI instead of a single one (the resulting filter will contain only one) APAR SE11648: CA400EXP-OPNAV-NETWORK-INCORROUT BOOTP Relay Configuration The BOOTP/DHCP Relay agent "Configure" menu item is not available in Italian. APAR SE11649: CA400EXP-OPNAV-NETWORK-INCORROUT UCW not set dial attempts The Universal Connection is incorrectly setting the Number of Dial Attempts, Delay between Dial Attempts, and Line Inactivity Timeout when creating the connection profiles. The Universal Connection will be changed to set the Number of Dial Attempts to 3, Delay between Dial Attempts to 15, and Line Inactivity Timeout to 10 minutes. CIRCUMVENTION: These values can be changed by the user manually after the profiles are created by the Universal Connection Wizard. Expand your system. Expand Network. Expand Remote Access Services. Expand Originator Connection Profiles. Right click on the Qesdial (or Qysddial) profile in the list and select Properties. Click on the Connection tab and select Advanced. Change the Number of dial attempts to 3, the Delay between dial attempts to 15 seconds, and the Line inactivity timeout to 600 seconds. Click OK to set Advanced Properties. Click OK to set the Properties. Right click on the Qtocl2tp profile in the list and select Properties. Click the Connection tab. Change the Line inactivity timeout to 10 minutes. Click OK to change the Properties. APAR SE11650: CA400EXP-OPNAV-NETWORK-INCORROUT Writing DNS config failure DNS configuration file errors cause loss of data APAR SE11651: FTP Properties Config Fails TCP9503 FTP configuration file is not closed if an access problem occurs. APAR SE11669: INCORROUT Journaling dialog box shows different for IASPs under the Integrated File System When the Journaling dialog box is opened under the Integrated File Systems IASP context menu. The dialog box is showing the options for the folder options. When the journals name and library name selected and click start. It gives an error "0 of 1 objects have started journaling." or 0 of 1 objects have ended journaling. This Problem is fixed in the next release. CIRCUMVENTION: The alternative way to start and stop journaling in IASPs is to use the Databases. APAR SE11714: CA400EXP-OPNAV-FILESYS-INCORROUT LARGE FILES SHOW INCORRECT V5R2M0 iSeries Navigator is returning the wrong size for large files. APAR SE11743: CA400EXP-OPNAV-INCORROUT WHEN USING A MOUSE WHEEL WITHIN APP. ADMIN. When running Application Administration and you use the wheel of your mouse to scroll iSeries Navigator crashes. You get an error on cwbunnav.exe In addition, using a mouse wheel on the Component Selection window within Selective Setup, will cause the setup to abnormally terminate. CIRCUMVENTION: Do not use the mouse wheel to scroll in the Application Administration dialog. Only use left mouse clicks on the scroll bars or page up/down. The same circumvention applies to Selective Setup. APAR SE11892: CA400EXP-OPNAV-AUTHLIST-INCORROUT CANNOT ADD AN AUTL TO A Using Operations Navigator GUI to display authorization list in permission for NetServer Shared Objects ended with error: 'An error occurred when trying to view the xxxxxx authorization list.' If we try to assign authorization list to some Shared Object using ON,we get error: 'You cannot attach the selected authorization list to the object. Authorization to the list other than Exclude is required.' (*PUBLIC for auth. list is *ALL, user has *ALLOBJ authority). Recreation instructions: - from Operations Navigator start Network -> Servers -> TCP/IP and open AS/400 NetServer - click on Shared Objects and choose one of the Shares - right click on this share and select Permissions RE-IPL= - click on the Authorization List button REGRESSION= - select one authorization list and click on View button to display it or on OK button to add this authorization list to Shared object. The error was caused by an unnecessary check which was failing because of an API change in v5r2. This unnecessary check was removed. APAR SE11901: CA400EXP-OPNAV-FILESYS-INCORROUT - Changing AUTL on a NetServer share in v5r2 OpNav to v5r2 OS400 fails When opening a shared folder in NetServer in a v5r2 version of OpNav after connecting to a v5r2 system, if you try to change the Authorization List by clicking on the "Authorization List" button, you will get an error that you must have some authority to the object other than exclude. An extra error checking routine was failing due to code changes in v5r2 to the QSYUSRA API. Since this check is no longer accurate or needed, it has been removed. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE10644: CA400EXP-DTRANSFER CSV FILE WITH DBCS CAN BE TRANSFERED TO Data Transfer To iSeries (AS/400) may not report data conversion warnings if DBCS data is transferred to a SBCS only column. This is typically the case if the data in the file contains a mix of DBCS and SBCS data. As a result, no warning is displayed and DBCS data transferred to the SBCS column is normally corrupt. After installing this fix a translation error will produce a warning message. The warning message will contain an OK button to allow the user to continue the transfer and a Cancel button to cancel the transfer. APAR SE10934: CA400EXP-DTRANSFER-PERFM SLOW TAB DELIMITED TRANSFER Data Transfer From AS/400 using the Tab Delimited Text file format may perform much slower than using the CSV format, which is very similar. APAR SE11009: CA400EXP-DTRANSFER-INCORROUT CANNOT DELETE THE WHERE CLAUSE Positioning the cursor in the where clause window, and then backspacing or deleting, will cause only one character to be affected and the cursor will be repositioned outside the window. APAR SE11667: CA400EXP-DTRANSFER ADDED RXFERPCB TO DATA TRANSFER RXFERPCB is a new utility for facilitating remote data transfers. A new tool, RXFERPCB.EXE has been added to iSeries Access for Windows Data Transfer. This new tool was added to aid in remote data transfers via Incoming Remote Command and RUNRMTCMD from the iSeries. RXFERPCB is much like RTOPCB and RFROMPCB except that it allows you to specify a user ID and password on the command line. This helps to alleviate remote signon problems that are typical when trying to do remote transfers with RTOPCB and RFROMPCB. To run RXFERPCB, specify the transfer request profile name, userID, and password. An example invocation of RXFERPCB and its parameter descriptions are as follows: RXFERPCB request userID password request - Fully qualified file name of any Client Access upload or download request of type .DTF, .DTT, .TTO, or .TFR. userID - A valid iSeries user profile for the system specified in the request. password - A valid password for the specified user profile. RXFERPCB C:\TRANSFERS\MYREQUEST.DTF myuserid mypassword RXFERPCB can be found in the directory where you installed iSeries Access for Windows. NOTE: RXFERPCB specific messages and help text will display as English only. However, most error and warning messages will display using the correct language. If any parameter contains embedded blanks, you must enclose it in double quotation marks. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE11659: CA400EXP-DTRANSFER EXCEL ADD-IN LIMITED TO 16K ROWS ON XP Using the Data Transfer To iSeries function of the Data Transfer Add-in for Microsoft Excel on Excel version XP (2002) may fail if more than 16385 rows are selected. ODBC ---- APAR SE10773: CA400EXP-ODBC SQL SERVER 2000 LINKED SERVERS RETURN PARTIAL SQL Server 2000 linked server does not return a complete result set using SQLExtendedFetch and a rowset size of one with the Client Access Express ODBC driver. There is no error returned, just the partial result set. The SQL Server 2000 tested issues the first fetch with a block size of 1. It issues a fetch with a block size of 100 and the rows 1 to 100 are returned. It issues another fetch with a block size of 100 and rows 101 to 200 are returned. It issues the final SQLExtendedFetch with a block size of 100 and rows 201 to 261 are returned (that's the end of the result set) with a SQL_SUCCESS message and SQL_NOROW status in 62 to 100. SQL server assumes this is EOF and stops fetching. APAR SE10781: CA400EXP-ODBC-UNPRED EXTENDED DYNAMIC WARNINGS ON CATALOG The V5R2M0 iSeries Access ODBC driver retrieves catalog (metadata) information differently than previous incarnations of the Client Access ODBC driver did. This difference can cause catalog requests to receive a return code of 1 meaning success with additional information, rather than a return code of 0 which simply means success. Some applications may be coded in such a way that they treat this as a failure rather than success. Specific examples of applications behaving in this incorrect manner include Microsoft Query and Microsoft Word. While this really is a coding defect in the application, it is one that the application would not have previously encountered using older versions of Client Access. The problems may be circumvented by disabling extended dynamic support in the ODBC data source on the Packages tab. APAR SE11349: CA400EXP-ODBC-INCORROUT PRECISION NOT CORRECT FOR FLOATING ODBC driver is incorrectly rounding floating point data so not all precision is given to the requesting application. Example: Data in a float column of 1.1234567890123456789 results in 1.123457 when retrieved from ODBC interface. APAR SE11453: CA400EXP-ODBC-INCORROUT COLUMN NAMES FOR RESULT SETS NOT After upgrading to R520 Express (service pack SI08894) an ODBC application stopped returning the first 8 column names after running an SQL query. Once the OEM application called SQLStatistics (or SQLSpecialColumns) all of the column names for other result set generating calls fail. SQLStatistics has 13 result set columns. SQLSpecialColumns has 8 result set columns. After SQLStatistics is called any result set generating call will have its first 13 column names fail and with with SQLSpecialColumns the first 8 column names fail. In this case the application appeared to be treating a "" name as being an unnamed column and returned it as EXP0 for "Expression0", etc. OLE DB PROVIDER --------------- APAR SE11652: CA400EXP-DBACCESS-OLEDB APPLICATION FAILS WITH SQL0904 RC7 An application uses iSeries Access for Windows OLE DB (IBMDA400) to access DB2 UDB for iSeries data. The application creates and destroys a very large number of ADO command objects. The same SQL Statement is run multiple times with different values. After approximately 40,000 command objects the application fails with the error message SQL0904 RESOURCE LIMIT EXCEEDED, RESOURCE LIMIT TYPE 7 EXCEEDED. OLEDB will now reuse statement names. Note that applications that run large quantities of unique SQL Statements (different SQL statements after converting literals to parameters) will still hit the SQL0904 error when the maximum number of prepared statements is reached. This is a restriction of DB2 UDB for iSeries. CIRCUMVENTION: Create one parameterized SQL statement and execute it multiple times. This technique offers much better performance in addition to cirucumventing the problem. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR SE10503: CA400EXP-PRINTEMUL-INCORROUT WORD CLAMPING WITHIN PAGE WIDTH Applying the fix of SE09573 via the PCSPD.DLL corrects the initial page alignment issue. However it create a new problem. Output has word clamping when printing in landscape. I.E. the output is being fit within the page width of a portrait layout and also of the wrong font. Thus the letters seem to be clamping to each other. APAR SE10544: CA400EXP-TERMEMUL-INCORROUT PCSCM GETS AN APPLICATION ERROR Customer created a DSPF with one numeric field and the FRCDTA attribute and a rpg pgm that increases the number in the numeric field like a counter. If the counter reaches 300 - 400 PC5250 crashes with error: PCSCM.EXE - Application Error received stating 'The instruction at "0x?" referenced memory at "0x?". The memory could not be read.' APAR SE10659: CA400EXP-PC5250 PCSFONT WAS FILTERED FROM WIN2K/XP OS. PCSGothic and PCSMincho appears on fontlist of emulator session preferences under Windows2000/XP OS. These fonts are not supported from above operating systems. so, If you choose these fonts, unexpected error occurs. APAR SE10660: CA400EXP-PC5250 JAPANESE KATAKANA APPEARED INCORRECTLY IF The customer created PC5250 display session on CA400EXP by using unicode(1399). When entered Japanese hankaku Katakana 'so' at the top of input field, it appeared as '->->->....->'. It doesn't depend on the field type.('A' or 'O') APAR SE10707: CA400EXP-TERMEMUL-LOOP RPG APPLICATION IS CAUSING PCSWS.EXE By analysing trace, support found out that when user hits a NewLine key in an RPG application, his session goes to 99% of CPU. APAR SE10729: CA400EXP-TERMEMUL-INCORROUT PCSWS.EXE FAULTS STARTING AND ST Error message window for PCSWS.EXE may occur when controlling the start/stop of PC5250 sessions with applications that makes use of ACTIVEX and EHLLAPI scripts. THe problem did not occur when using CAExpress R510 and now is present with iSeries Access R520 with SI07677. The PC running the application is an IXS running WIN2K TSE and the problem occurs at most when the system is heavily used. APAR SE10742: CA400EXP-TERMEMUL-INCORROUT EHLLAPI MNEMONIC RESET FAILS TO Customer is using an old EHLLAPI application that uses the mnemonic reset (ESC R) to clear the input inhibit and the message for certain conditions like 'Cursor in protected area of display'. Since moving to XE1 R510 and R520 this no longer works. Same application works fine with standalone PCOM v4.3 and V5. APAR SE10864: OSP DISPLAYING A SUBFILE, IT IS BLANK. Displaying a subfile, it is blank. If the screen is minimized and then maximized again, the subfile now displays. APAR SE10879: CA400EXP PCSWS APPLICATION ERROR WHEN USING SEQUENCE KEY TO WinNT , Win2K , Ca400exp r510 Si06804 or Si05361 . Cust uses for one year a software named DTM400 (Inventive Designer) which replace OfficeVision400 (Word processing) For the first time they uses a new Sequence, this sequence is used to make a Copy/Paste of text. On ALL PCs , when use the following sequence F1 (begining of the text to copy) + Enter (End of the text) + Enter (to copy the selected text at the palce where is presently the cursor), then ATTN (to pass on an alternate session, => CA crashes with the following : PCSWS.EXE Application Error : Exception unknow software exception (0xc00000fd) has been detected in application at location 0x63b74cfc . APAR SE11161: OSP-PAR COPY AND PASTE WITH ISERIES ACCESS FOR WINDOWS PC525 Repeated copies and pastes with iSeries Access for Windows PC5250 cause PCSERR101. APAR SE11324: OSP-PAR COPY AND PASTE WITH ISERIES ACCESS FOR WINDOWS PC525 Copy the DBCS data with blank(1byte) + x/0E then paste to DBCS field which behind x/0E, the pcsws.exe process using 99% CPU on TaskManager and the session task shows as 'NO ANSWER' status. cause hang abend APAR SE11656: CA400EXP-PRINTEMUL-INCORROUT Problem with IBM5577.PDT When using PC5250 Printer Emulation in combination with the IBM5577.pdt in a Japanese environment, printing stops after the first line. APAR SE11657: CA400EXP-TERMEMUL-INCORROUT Horizontal Scroll bar when Font Size is changed is not working Horizontal Scroll bar when Font Size is changed is not working APAR SE11658: CA400EXP-TERMEMUL-INCORROUT Connect and Config options are disabled if the Host code page is changed and autoconnect is disabled CA/400 - Connect and Configure Options are disabled. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE11182: CA400EXP-OPCON-UNPRED Direct connect fault with Win2k SP4 Attempting to connect a direct cable config on Windows 2000 Service Pack 4 (SP4) results in a fault. The fault occurs in KERNEL32.DLL while running in the process CWBOPCON.EXE. The Windows 2000 SP4-induced problem is avoided with this change. CIRCUMVENTION: Using Windows 2000 SP3 instead of SP4 avoids the problem. 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 = SI08894 Build date = June 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE09627 OSP-PAR USING CHECK VERSION TO COPY INSTALL CODE TO PC BEFORE INSTALLING APAR = SE09912 CA400EXP-OPNAV-DBASE-INCORROUT AFTER SP INSTALL INSERT APAR = SE10014 OSP-PAR FUNCTIONS GRAYED-OUT OR FAIL EVEN WHEN ADMIN APAR = SE10564 CA400EXP-INCORROUT Cannot use Windows logon on 64-bit PC OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR = SE09708 CA400EXP-INRMTCMD-INCORROUT CMDS FAIL AFTER UPGRADING WINDOWS A PC used for running Incoming Remote Command (IRC) requests is upgraded from Windows 9x/Me to Windows NT/2000/XP. Some commands sent using RUNRMTCMD to this PC now fail, when they had worked before the Windows upgrade. Incoming Remote Command (IRC) now recognizes a new option: /loadprof This option tells IRC that whenever a command will be run in the context of a user ID sent with the command, the user profile should be loaded first. If it is successfully loaded, the command will have access to user-specific configuration information it might need to succeed. This information includes the HKEY_CURRENT_USER part of the registry and user-specific environment variables. The /loadprof option may be used in either of two ways. The first is to enter it as a Start Parameter when you start the iSeries Access for Windows Remote Command service. If you do that, the option will be applied to all commands run by IRC. The second method is to enter it as part of the command string, before the actual command. This method is useful if you want the option applied only to some commands but not others. For example, to tell IRC to load the user profile and then run the command 'myprog.exe' you would specify as the command the string '/loadprof myprog.exe'. If /loadprof is specified, but IRC has no user context to run the command in, the user profile will not be loaded. For example, when /runassystem ("run as system") is also used, the command is run in the context of whatever account the iSeries Access for Windows Remote Command service is configured to run under, not the context of the user ID sent with the command. Another example is when /nosecok ("Allow generic security") is also used, and *NONE is sent as the user ID. In both of these cases, no user profile can be loaded. There are several considerations to keep in mind when the /loadprof option is used. Firstly, use of this option does not guarantee that the user profile will be loaded successfully before your command is run. If IRC fails to load the user profile, it will run the command anyway, and the command may not have access to the user-specific configuration information. If this occurs, a message will be logged to the History Log indicating that the user profile was not loaded successfully. Secondly, omitting /loadprof does not guarantee that the user profile is not loaded when your command runs. User profiles are system-wide things, and some other process may have already loaded the user profile. If the user is signed-on to the PC on which the command is run, their profile might already be loaded and available to the command. APAR = SE10619 CA400EXP-INRMTCMD MSG1313 IRC DAEMON SERVICE DOES NOT START iSeries Navigator ----------------- APAR = SE06054 CA400EXP-OPNAV-NETWORK-INCORROUT Updating SMTP filters APAR = SE08141 OSP-DB-F/QZDACMDP-MSGPWS0010-T/QZDACMDP OPERATIONS NAVIGATOR APAR = SE09027 CA400EXP-OPNAV-NETWORK-INCORROUT RouteD config loses data APAR = SE09604 CA400EXP-OPNAV-INCORROUT ERROR CWBUNPLA DIALOG APPEARED APAR = SE09614 CA400EXP-OPNAV-MESSAGES-MSGSQL7959 CA400EXP USING OPSNAV APAR = SE09628 CA400EXP-2-INCORROUT UCW DOES NOT RECOGNIZE D/T2742 APAR = SE09640 CA400EXP-OPNAV-NETWORK-INCORROUT iNav hangs changing SMTP APAR = SE09684 CA400EXP-OPNAV-DBASE-MSGCPF0001 USING ISERIES NAVIGATOR TO D APAR = SE09706 CA400EXP-OPNAV-OUTPUT-MSGCPD0083 Error Moving Printer Output APAR = SE09727 CA400EXP-OPNAV-INCORROUT ADMINISTRATION SYSTEM TAB WITHIN APAR = SE09743 CA400EXP-OPNAV-DBASE-INCORROUT RUN SQL SCRIPTS HANGS WINDOWS APAR = SE09747 CA400EXP-OPNAV-OUTPUT-INCORROUT INTERNET SETUP WIZARD ON FRENCH APAR = SE09826 CA400EXP-OPNAV-DBASE-INCORROUT ADDITIONAL FILES DISPLAYED IN APAR = SE09851 CA400EXP-OPNAV-DBASE-MSGSQL0100 CANNOT UPDATE A TABLE THROUG APAR = SE09915 CA400EXP-OPNAV-NETWORK-MSGTCP2652 ENABLE PROXY ARP ON VIRTUA APAR = SE10078 OSP-IMPORT OF OVERLAY FAIL USING AFP MANAGER APAR = SE10161 CA400EXP-OPNAV-OUTPUT Error copying multiple spooled files APAR = SE10222 OSP FAILURE TO ACCESS THE PM400 TREND ANALYSIS DATA ON THE W APAR = SE10229 CA400EXP-OPNAV-OUTPUT-INCORROUT OUTPUT QUEUE DELETE ERROR APAR = SE10562 CA400EXP-OPNAV-NETWORK-INCORROUT Subsystem name discarded APAR = SE10565 CA400EXP-OPNAV-NETWORK-INCORROUT Can't add SMTP RR address APAR = SE10566 CA400EXP-OPNAV-NETWORK-UNPRED Improve diagnostics DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE09811 CA400EXP-DTRANSFER-INCORROUT WRONG MBR DISPLAYED IN BROWSE DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE09057 CA400EXP-ODBC SQLFETCHSCROLL DOESN'T RETURN CORRECT NUMBER O APAR = SE09116 CA400EXP-ODBC-INCORROUT DATA RETURNED FOR CLOB FIELDS APAR = SE09139 CA400EXP-ODBC-MSGERROR IN ROW ODBC APPLICATION FAILS WHEN ZE APAR = SE09168 CA400EXP-ODBC-MSG7357 (1CBD) OLE DB PROVIDER 'MSDASQL' APAR = SE09180 CA400EXP-ODBC-MSGSQL0666 R520 PERFORMANCE PROBLEM W/ APAR = SE09306 CA400EXP-ODBC-INCORROUT INCORRECT OUTPUT WITH EXTENDED FETCH APAR = SE09746 CA400EXP-ODBC SQLSTATE 22018 ERROR IN ASSIGNMENT APAR = SE09933 CA400EXP-ODBC-INCORROUT STACK OVERFLOW WHEN RETRIEVING CATAL APAR = SE10041 CA400EXP-ODBC-INCORROUT FILE DSN CONFIGURED TO USE WINDOWS U APAR = SE10057 CA400EXP-ODBC-MSGCWB0111 VERSION 2.0 APPLICATIONS AND UNICODE APAR = SE10374 CA400EXP-ODBC-UNPRED ORS DATA IS NOT RELEASED BECAUSE RETURN APAR = SE10563 ODBC XA support ODBC allows the MTS interface for distributed transactions in a Windows environment. However, in certain environments, like Linux, that is not an option. An interface is needed for Linux so that XA APIs can be called to perform distributed transactions. API changes: SQLSetConnectAttr now supports a 2140, 2141, and 2142 option. SQLGetConnectAttr now supports a 2140, 2141, 2142, 2143 option. Attribute: 2140 Description: An unsigned integer value that specfies the amount of time (in seconds) that an XA transaction will wait until it times out. A value of 0 indicates to wait indefinitely for the transaction to finish. Setting this overrides any value that was set for the XATIMEOUT connection string keyword. The default value for this attribute is 0. Setting this value at the present time will have no effect. Atribute: 2141 Description: An unsigned integer value that specfies the maximum amount of time (in seconds) that an XA transaction will wait on a lock request before timing out. A value of 0 indicates to use the default system settings. Setting this overrides any value that was set for the XALOCKTIMEOUT connection string keyword. The default value for this attribute is 0. Setting this value at the present time will have no effect. Attribute: 2142 Description: An integer value that specifies the RMID to use for XA transaction work. This can be set at anytime. The RMID that is set must be unique for the process. If this value is set to 0 it indicates that any current XA transaction work has been completed for this connection. The default value for this attribute is 0. Attribute: 2143 Description: A character string that identifies the iSeries Access driver to call into for XA calls. This string is only valid if the 2142 connection attribute has been set. This string is set after the connection is established. The default value for this attribute is an empty-string. SQLDriverConnect now supports the XATXNTIMEOUT and XALOCKTIMEOUT connection string keywords. See Attribute 2140 and 2141 for a description of what these attributes set. - xa_open is only called by the application for recovery purposes. When connecting through the ODBC API SQLConnect or SQLDriverConnect the xa_open is done automatically if the RMID was set via the 2142 connection attribute. - The connection attribute SQL_ATTR_AUTOCOMMIT must be set as SQL_AUTOCOMMIT_ON. - If an application wishes to start an XA transaction and then do some non-XA transaction work, one must set the RMID to 0 to indicate to the driver that the XA work is completed. - To do XA recovery an application calls xa_open with a string of "SYSTEM=mySystem;UID=myUserID;PWD="myPassword";DATABASE=myDatabase;" where mySystem is your system name, myUserID is your user ID on that system, and myPassword is that user ID's password. Note the string must be specified exactly as above or as "SYSTEM=mySystem;". Those two strings are the only two strings that will work. Below is the basic scenario on how an application calls into the driver to do a distributed transaction: 1. Application calls SQLSetConnectAttr and specifies the 2142 option indicating the RMID to use 2. Application calls SQLConnect / SQLDriverConnect (the driver does an xa_open) Optional: Application calls SQLGetConnectAttr to get the DLL name needed to make the xa_open call for recovery 3. Application calls ODBC APIs like normal and calls XA APIs to coordinate the transaction by calling into the iSeries Access DLL that supports the xa_switch. 4. Application calls SQLDisconnect (the driver does an xa_close) OLE DB PROVIDER --------------- APAR = SE09140 CA400EXP-OLEDB-INCORROUT AD400SEEKLASTEQ PARTIAL SEEK FAILS AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI08536. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE08385 CA400EXP-PC5250 IME_AUTO_START_N FUNCTION INCORROUT APAR = SE08553 CA400EXP-TERMEMUL-MSGPCSWS044 PCSWS044 PREVENTS PC FROM This issue affects laptops- the laptop cannot enter sleep mode without the user responding to this message- PCSWS044. Would like a way to turn it off. A keyword setting has been provided to control this behavior. The keyword should be added to the pcswin.ini file. PromptBeforeSleep=Y This is the default setting. When the keyword is set to Y, PC5250 will will prompt the user about whether to go into power saving mode if the session is connected. If the session is not connected, permission for Windows to go into power saving mode will be granted without prompting. PromptBeforeSleep=N When the keyword is set to N, permission for Windows to go into power saving mode will always be granted without prompting. APAR = SE08696 CA400EXP-TERMEMUL-INCORROUT PCSWS.EXE FAULTS STOPPING A SESSION APAR = SE08902 CA400EXP-TERMEMUL-INCORROUT UNABLE TO TYPE KATAKANA "WO" APAR = SE08973 PC5250 CAN'T TYPE N-TILDE IN ALPHABETIC FIELD IN DSPF, WHICH APAR = SE08975 CA400EXP-TERMEMUL-PERFM RUNNING MACROS IN MORE THAN 1 PC5250 APAR = SE09006 CA400EXP-TERMEMUL-PERFM PC5250 DISPLAY SESSION HANGS & LOOSE APAR = SE09016 CA400EXP-TERMEMUL-INCORROUT KEYBOARD MAPPING PROBLEM WITH GREEK APAR = SE09349 CA400EXP-PRINTEMUL-INCORROUT PC5250 PRINTER CAUSES FONT APAR = SE09502 CA400EXP-PRINTEMUL-INCORROUT AFTER APPLYING SI06631 THE FONT APAR = SE09761 CA400EXP-PRINTEMUL-INCORROUT PC5250 UNICODE CHARACTERS ARE APAR = SE09776 CA400EXP PC5250 INPUT INHIBIT DISPLAY SESSION APAR = SE10023 CA400EXP-PRINTEMUL DBCS COMPUTER OUTPUT REDUCTION PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE09791 CA400EXP-OPCON-UNPRED CWBOPCON.EXE ERRORS AFTER APPLY OF APAR = SE10250 OpConsole - CA400EXP-OPCON-UNPRED REMOTE CONTROL PANEL VIA CABLE WILL NO APAR = SE10315 CA400EXP-OPCON-INCORROUT SELECTING THE AUTO CONNECTION OPTION --------------------------------- Service Pack Level = SI07675 Build date = February 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE08411 CA400EXP-INSTALL-UNPRED INSTALL OF AFP/SCS PRINT DRIVERS ON WIN XP SP1 Installing the AFP or SCS Printer Drivers drivers included with V5R2 of iSeries Access for Windows, or V5R1 of Client Access Express, on a PC with Windows XP and XP Service Pack 1, generates a Windows Logo Testing warning/error during installation. With Windows XP SP1, Microsoft enforced the Driver Signing warn and block options, where previously, install programs could bypass these settings. Users can avoid this problem by not selecting the AFP and SCS Printer Driver components for installation. These components are in a Typical Install, so the user should select a Custom Install, and de-select the AFP and SCS Printer Driver components, if those components are not needed. If the user needs AFP and SCS Printer Driver components, then answer the Microsoft Driver Signing Option warning box with the Continue option to continue with the install. In addition, the user can specify to Ignore Driver Signing via the Windows Control Panel, System applet, Hardware tab, Driver Signing button. After the install, the setting can be restored to its previous value by the user. APAR = SE09143 CA400EXP-AFPVIEWER-INCORROUT CWBNP1019 RESOURCE AFP OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- APAR = SE08698 CA400EXP-INRMTCMD-UNPRED USE WINDOWS LOGON DOES NOT WORK WITH IRC iSeries NAVIGATOR ----------------- APAR = SE08264 OSP-F/QCARULE-MSGCPD0039-T/QSQCALL APAR = SE08543 CA400EXP-OPNAV-DBASE-UNPRED SAVED DATABASE MAP CANNOT NOT BE APAR = SE08599 CA400EXP-OPNAV-MSGCWBUN0148 CWBUN0148 MESSAGE IS RECIEVED WH APAR = SE08724 CA400EXP-OPNAV-DBASE DETAILED SQL PERFORMANCE MONITOR FAILS APAR = SE08845 CA400EXP-OPNAV-PERFM OPS NAV APPEARS TO HANG OR IS SLOW TO APAR = SE09107 CA400EXP-OPNAV-FILESYS-MSGCPFA0A9 Permissions problem DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE08489 CA400EXP-ODBC ADO ERRORS 2147217887 AND 2147467259 IN CA APAR = SE08671 CA400EXP-ODBC-INCORROUT SQLGETINFO CATALOG_USAGE VALUE RETUR APAR = SE08715 CA400EXP-ODBC-INCORROUT ODBC RETURNS INCORRECT DATE, TIME, A APAR = SE08723 CA400EXP-ODBC CLOB FIELDS AND NULL VALUES APAR = SE08942 CA400EXP-ODBC-MSGSQL0551 MSGSQL0551 QSYS/QADBKFLD ODBC APP APAR = SE09104 CA400EXP-ODBC-PERFM PERFORMANCE PROBLEM WITH V5R2 ODBC OLE DB PROVIDER --------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI05645. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE08554 CA400EXP-PRINTEMUL-INCORROUT OUTPUT CHANGED ON R520 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE08827 CA400EXP-OPCON-UNPRED OPERATIONS CONSOLE SETUP HANGS AT MODE APAR = SE09008 CA400EXP-OPCON-INCORROUT HOST FILE ON THE PC IS NOT UPDATED --------------------------------- Service Pack Level = SI06631 Build date = November 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE07361 CA400EXP-DTRANSFER-INCORROUT TRANSFERRING TO CCSID 13488 APAR = SE07669 OSP-PAR CLIENT ACCESS LICENSE NOT ALWAYS RELEASING AFTER SET APAR = SE07950 CA400EXP-TERMEMUL-MSGCWBLM0011 CWBLM0011 ERROR WITH CLIENT APAR = SE08029 CA400EXP-DTRANSFER-WAIT CWBLMSRV.EXE INHERITING THE FILE APAR = SE08320 CA400EXP-CONNECTIONS-INCORROUT cwbcfg configs not changed; add /ipaddr modes When cwbcfg is run, even when /r is specified, not all existing user profiles are updated with the specified configuration information.  Users created after cwbcfg is run do get the configuration information, as desired. Also, the only IP Address setting possible using cwbcfg is to specify the IP Address explicitly, which implicitly sets the IP Address Lookup Frequency to Never. The other lookup frequencies cannot be set. The /ipaddr parameter now can be used with any of the following: n.n.n.n If the actual IP address is specified in the format n.n.n.n, it will be set, and will never be looked-up. *ALWAYS The IP address will be looked-up every time a connection is attempted. *HOURLY The IP address will be looked-up only if an hour has passed since the last lookup. *DAILY The IP address will be looked-up only if a day has passed since the last lookup. *WEEKLY The IP address will be looked-up only if a week has passed since the last lookup. *STARTUP The IP address will be looked-up only if Windows has been shutdown and re-started since the last lookup. For example, the following command will not only set the default user ID of system MySys to Frank, it will also set the IP Address Lookup Frequency so the address is looked-up only if at least a day has passed since the last lookup. Because /r is used, it will modify even existing MySys configurations. cwbcfg /host MySys /ipaddr *DAILY /uid Frank /r APAR = SE08343 CA400EXP-2-LOOP ByteStream type 1 directories with large number of entries will hang iNav IFS OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE06986 OSP-AFP-PRT UNABLE TO USE IMPORT OVERLAY FUNCTION OF AFP MAN APAR = SE07200 TCPIP-SMTP OP NAV FAILURE ATTEMPTING TO CHANGE/DISPLAY SMTP APAR = SE07618 OSP-MSGCPD0104-PAR-CA400EXP-OPNAV CANNOT ENROLL TO DOMAIN APAR = SE07701 CA400EXP-OPNAV-INCORROUT ISERIES NAVIGATOR GETS AN INVALID P APAR = SE07991 OSP-DB VISUAL EXPLAIN HANGS WITHOUT DISPLAYING RESULTS APAR = SE08031 CA400EXP-OPNAV-NETWORK-INCORROUT UNIVERSAL CONNECTION WIZARD APAR = SE08075 CA400EXP-OPNAV-DBASE-MSGSQL0615 VISULAEXPLAIN GOT SQL EXCEPT APAR = SE08101 CA400EXP-OPNAV-DBASE-INCORROUT OPERATIONS NAVIGATOR "RUN SQL APAR = SE08145 CA400EXP-OPNAV-DBASE-INCORROUT SQL SCRIPT SAVE AS SHOWS AN APAR = SE08162 CA400EXP-ODBC FAILURE. ERROR "DESCRIPTOR INDEX NOT VALID" IS APAR = SE08220 OSP-DB CA400EXP-OPNAV SQL EXCEPTION DURING CREATE LIBRARY APAR = SE08329 CA400EXP-OPNAV-INCORROUT Numeric at start domain name APAR = SE08346 CA400EXP-OPNAV-NETWORK-UNPRED Add new 2793 modem for UCW APAR = SE08403 CA400EXP-OPNAV-INCORROUT RESOURCEBUNDLEERROR RECEIVED IN OPN DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE07804 CA400EXP-DTRANSFER NATIVE SQL STATEMENT FAILS ON WINDOWS 98 DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE07497 CA400EXP-ODBC-INCORROUT STORED PROCEDURE EXPECTED TO RETURN APAR = SE07922 CA400EXP-ODBC-INCORROUT UNABLE TO LINK TO SPECIFIC LIBRARY APAR = SE07999 CA400EXP-ODBC-INCORROUT MS EXCEL 2000 GIVES ERROR IN ASSIGNM APAR = SE08021 CA400EXP-ODBC-INCORROUT MS ACCESS 2000 LINK EXTERNAL TABLE APAR = SE08207 CA400EXP-ODBC-INCORROUT - ODBC Driver uses too much memory OLE DB PROVIDER --------------- APAR = SE08268 CA400EXP-OLEDB-INCORROUT SEEK FUNCTION USED WITH IBMDA400 OL AFP WORKBENCH VIEWER -------------------- APAR = SE08202 CA400EXP-AFPVIEWER ERROR OCCURS USING *VIEW FROM AFPU TOOLBOX FOR JAVA ---------------- This iSeries Access for Windows service pack will also install the equivalent of 5722JC1 product PTF SI05645. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR = SE06873 OSP-PAR PCSWS IPF IN MODULE UNKNOWN WHEN STARTING RUNNING VB APAR = SE07574 CA400EXP-TERMEMUL-INCORROUT BACKSPACE IN A WORD WRAPPABLE FI APAR = SE07671 CA400EXP-TERMEMUL-INCORROUT UNABLE TO USE SYSREQ ON PC5250 APAR = SE07743 CA400EXP-TERMEMUL-INCORROUT PC5250 HANGS WHEN USING SYSREQ APAR = SE07771 CA400EXP-PRINTEMUL-MSGPCSWS.EXE ERROR INTEGER DIVISION BY 0 APAR = SE07847 CA400EXP-TERMEMUL-INCORROUT NO ALARM ON ICF CLIENTS WHEN APAR = SE08022 CA400EXP-TERMEMUL-INCORROUT CURSOR DOES NOT POSITION PROPERL APAR = SE08139 CA400EXP-PRINTEMUL-MSGPCSWS PAGE FAULT WINDOWS 2K DESKJET APAR = SE08188 CA400EXP-PC5250 FILE TRANSFER FAILS WITH 'APPLICATION ERROR' APAR = SE08283 OSP-PAR V5R2M0 C2260 5722XE1 WITH PTF SI05853 ON MS WINDOWS APAR = SE08322 CA400EXP INCORECT FONTS FOR VIETNAMESE CAPS 5250 DISP EMU APAR = SE08323 CA400EXP-PRINTEMUL-UNPRED PC5250 IS RESTORING DEFAULT PAGE PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. --------------------------------- Service Pack Level = SI05853 Build date = September 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE06839 CA400EXP-OLEDB-MSGCWBDB0052 OLEDB APP CANNOT FIND CONVERSION TBL APAR = SE07116 OSP-PAR CWBCO1004 MESSAGE RETURNED FOR LOCAL PORT LOOKUP OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE05818 OSP-DB DATABASE NAVIGATOR 'ADD TO MAP' FUNCTION FAILS IF APAR = SE06093 OSP-AFP-PRT IMPORT OF OVERLAY ONLY WORKS FOR ENGLISH CA APAR = SE06804 CA400EXP-OPNAV-SECPOL-UNPRED ADD BUTTON DOES NOT SHOW UP APAR = SE06921 CA400EXP-BOOTP OPERATIONS NAVIGATOR LIMITS RANGE OF MAC ADDR APAR = SE07405 OSP PROBLEM WITH LOADING OF USER LIST WHEN WORKING WITH THE DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE06350 CA400EXP-DTRANSFER-INCORROUT ASCII TEXT WITH ZERO PAD DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE06149 CA400EXP-ODBC-INCORROUT INVALID LENGTH REPORTED ON CATALOG APAR = SE06414 CA400EXP-ODBC-MSGSQL0181 AND MSGCPF5035 RC18 ON ODBC TIMESTA APAR = SE06447 CA400EXP-ODBC-INCORROUT - ODBC FAILS TO RETURN FULL STORED PROCEDURE RESULT SET APAR = SE06802 CA400EXP-ODBC-INCORROUT RIGHT TRUNCATION ON CHAR DATA APAR = SE07095 CA400EXP-ODBC-INCORROUT PROBLEM IS RELATED TO EMBEDDED NULLS APAR = SE07172 CA400EXP-ODBC-INCORROUT NULL OUTPUT PARAMETERS RETURNING APAR = SE07583 CA400EXP-ODBC-INCORROUT - SQLProcedureColumns results incorrect OLE DB PROVIDER --------------- APAR = SE06106 CA400EXP-OLEDB-INCORROUT SINGLE PRECISION DEC INCORRECTLY INSERTED APAR = SE06588 CA400EXP-OLEDB-UNPRED EXECUTING A PREPARED CALL STATEMENT APAR = SE07584 CA400EXP-OLEDB-INCORROUT Better support for LOB bindings and SQL Server AFP WORKBENCH VIEWER -------------------- APAR = SE07260 CA400EXP-OPNAV Viewer Process Fails to end when error occurs TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR = SE03962 CA400EXP-DBCS PRINTED AS GARBAGE BY PRINTER SESSION APAR = SE04192 CA400EXP-SECURITY-MSG656 UNABLE TO CONNECT PC5250 WHEN PASSW APAR = SE05180 CA400EXP-TERMEMUL PCSCM.EXE-APPLICATION ERROR. THE INSTRUCTI APAR = SE06164 CA400EXP-TERMEMUL-MSGMCH0601 CSRINPONLY SPECIFIED IN DSPF APAR = SE06296 OSP-PAR PC5250 PROCESSING OF FIELD WITH WORD WRAP AFTER SI02 PC5250 processing of a field with continuous input and word wrap ( CNTFLD WRDWRAP ) has changed. Previously, PC5250 sent data to the OS/400 telnet server with blanks padded at the end of the line when a word was wrapped. SC41-5715 specifies that the blank padding will be removed. Once this change was made, some customers have had application problems. Some programs depend on this feature for processing of the field. A new keyword has been added to specify the wordwrap behavior as follows. This should be added to the workstation profile (.ws file). [LT52] WordWrapRemoveNulls = Y or N (default value is N) Value of Y: The nulls within wordwrap entry fields are removed from the data sent to the server. Value of N: The nulls within wordwrap entry fields are padded with blanks (instead of removing them) and then sent to server. APAR = SE06586 CA400EXP-TERMEMUL-LOOP WHEN USING IWMP2000 TO SCAN DOCUMENTS APAR = SE06719 CA400EXP-PC5250-INCORROUT VIETNAMESE 5250 DISPLAY EMULN APAR = SE06869 CA400EXP-TERMEMUL-INCORROUT SESSION HANGS ON EXIT IF CHANGES APAR = SE06871 CA400EXP-TERMEMUL-INCORROUT UNABLE TO SPECIFY A SECURE WEBSI PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR = SE04218 CA400EXP-TERMEMUL-INCORROUT CLIENT ACCESS EXPRESS V5R1M0 EZ-SETUP -------- Non-APAR fixes. --------------------------------- Service Pack Level = SI04684 Build date = June 2002 --------------------------------- REQUIRED PROGRAMS ----------------- APAR = SE03830 CA400WINOPT IBMDA400 PARAMETER BIDI TRANSFORM IGNORED APAR = SE03863 CA400WINOPT - ARABIC TRANSLATION LAM-ALEF CHARACTER NOT GET APAR = SE05333 OSP-INCORROUT UNABLE TO USE DBCS SPECIFIC CHARACTER ON MS AC APAR = SE06009 CA400EXP-OLEDB-INCORROUT IBMDA400 MIXES DATA IN BIDI APAR = SE06195 INCORROUT UNABLE TO USE THREE THAI CHARACTERS WITH MS ACCESS OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR = SE06470 OSP-PAR CLIENT ACCESS V450 OPERATIONS NAVIGATOR FATAL EXCEPT DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR = SE04511 CA400EXP-DTRANSFER-UNPRED UPLOADING BIFF8 FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR = SE06297 CA400EXP-ODBC-PERFM PARAMETER MARKER DESCRIPTION APAR = SE06298 CA400EXP-ODBC-INCORROUT - Miscellaneous ODBC problems APAR = SE06344 CA400EXP-ODBC-INCORROUT - Tool to update DSN information The CursorSensitivity keyword was added late in the V5R2 release. Consequently, it does not show up on the ODBC DSN Setup GUI. To better handle situations like this in the future a tool is needed to make it easier to update DSN information for new keywords. The current method for handling new keywords is to manually go edit the registry for User or System DSNs or the file for file DSNs. Also, another change in V5R2 was to have two ODBC driver names. ODBC DSNs created using the new driver name of "iSeries Access ODBC Driver" will not work with older versions of Client Access. To handle this compatibility issue, the tool being created should also provide a way to change the driver name to the old name of "Client Access ODBC Driver (32-bit)". The tool that is created is called cwbODBCreg.exe and is installed when ODBC is installed as part of Client Access. The tool resides in the \Program Files\IBM\Client Access directory. The syntax for running the tool can be found by running cwbODBCreg from a DOS command prompt without any parameters. APAR = SE06546 CA400EXP-ODBC-MSGCWB0111 CHARACTER DATA RIGHT TRUNCATION WIT OLE DB PROVIDER --------------- APAR = SE06083 CA400EXP-OLEDB-INCORROUT NUMBER OF ROWS AFFECTED IS INCORRECT APAR = SE06468 CA400EXP-OLEDB-UNPRED Adjust block factor to 1 for LOBs APAR = SE06469 CA400EXP-OLEDB-INCORROUT IBMDA400 RETURNS EMPTY RESULT SET F AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ Non-APAR fixes. EZ-SETUP -------- Non-APAR 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: 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 Install/Uninstall tab, click on IBM iSeries Access for Windows SI09809 item, and then click on the Add/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. The suggested way of installing the service pack in this case is: 1) A setting has been added to 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"). 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. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator can set the Install Service Pack policy restriction, or 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.