============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R2M0 Cumulative Service Pack Level ------------- SI16915 ------------- (c) Copyright IBM Corporation 2002. All rights reserved. ======================================================================== Co-requisite PTF SI17953 is automatically included with any shipment or web download of SI16915. SI17953 exists only for packaging reasons. All service pack level references will be to SI16915. 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 = SI16915 (May 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. 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 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 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 = SI16915 Build date = May 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 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. 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. APAR SE19783: CA400EXP-INRMTCMD IRC shutdown vulnerability Certain inputs to Incoming Remote Command (the iSeries Access for Windows Remote Command service) can cause a fault, stopping the service. 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 SE18171: CA400EXP-OPNAV UNABLE TO DELETE SQL MONITOR DATA BY INAV DBC When using iSeries Navigator SQL performance monitor, summary monitor data which was started for all jobs won't be deleted. The data file will remain in library though the record on iSeries Navigator was deleted. And when a monitor started for a specific job, the monitor record on iSeries Navigator won't be deleted with message "error 1 was returned from stored procedure". This issue occurs only with iSeries Navigator DBCS Japanese V5R2M0. iSeries Navigator V5R3M0 or iSeries Navigator V5R2M0 English can delete these records and files correctly. The monitor will be deleted. APAR SE18444: OSP-DB ISERIES NAVIGATOR MENU BAR FLASHING The options on the iSeries Navigator and/or Run SQL Script menu bar are flashing and very hard to use. iSeries Navigator is changing to fix the menu bar flashing. 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 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 SE19153: CA400EXP-OPNAV USER IS NOT ALLOWED TO ADD CONNECTIONS TO ENVIRONMENT User is unable to add connections in iSeries Navigator after scanning the Administration System. This is because of the settings defined in the 'Application Administration (Central Settings) Advanced' dialog, under the 'Environments' page. When the 'Allow user to add connections to environment' option is not selected, it means no connections can be added to the environments defined in iSeries Navigator. However, the problem is that, when there is no environment defined in the 'Environments' page, the 'Allow user to add connections to environment' option is disabled and user can not select it. CIRCUMVENTION: To enable the 'Allow user to add connections to environment' check box when there is no environment defined: 1. From the 'Application Administration (Central settings) Advanced' dialog, select the 'Environments' page. 2. Click on 'Add Environment' and create a temporary environment, the 'Allow user to add connections to environment' option will be enabled. 3. Change the state of the check box. 4. Delete the temporary environment, select the environment previously created and click on 'Remove'. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE19445: CA400EXP-DTRANSFER CWBDB0050 AND PWS9801 EXPECTED We add an exit program of QIBM_QZDA_ROI1, format ZDAR0100 to control the access of data transfer of iSeries Access from client PC. When we try to transfer the data from a client PC (cwbtf.exe) with a user profile that is not permitted, the data transfer hangs with the following message. It doesn't end unless we press cancel button. +---------------------------------+ |iSeries Data Transfer | +---------------------------------+ | @ Receiving data from iSeries...| | | | +--------+ | | Received record | Cancel | | | +--------+ | +---------------------------------+ However, it should be MSGCWBDB0050 and MSGPWS9801 are issued like below. +-----------------------------------------------------+ |iSeries Access Message Displayer | +-----------------------------------------------------+ | CWBDB0050 - Server returned exit program error. | | | | PWS9801 - Function rejected by user exit program... | | : | | +--------+ +--------+ +---------+ | | | OK | | Detail | | History | | | +--------+ +--------+ +---------+ | +-----------------------------------------------------+ APAR SE19590: CA400EXP-DTRANSFER-UNPRED WARNING BEHAVIOR The Display Warnings During Data Transfer option is being set and checked at inconsistent times. This problem could result in warnings (CWBTF0020, among others) being issued to Data Transfer users even if the option to display warnings is disabled. APAR SE19871: CA400EXP-DTRANSFER CRFF not treated as EOL With iSeries Access for Windows V5R1 GA level, user data could contain both 0x0D0A and 0x0D0C as EOL markers and they would be treated as such. When the first service pack for V5R1 was installed, 0x0D0C was no longer accepted as an EOL marker and was instead treated as data and sent to the host. The change that was made to not accept EOL markers other than 0x0D0A was deemed correct, and matched the industry standard. Unfortunately it broke some customer applications. A circumvention would be to modify existing data and replace the 0x0D0C with 0x0D0A. But given the amout of data that would need to be changed in this particular case, it was not feasible. Instead a flag has been added to the CWBTFR.INI file to allow 0x0D0C to also be allowed as an EOL marker. In order to activate this fix, the CWBTFR.INI file must be created/modified to include the following lines [Client Access Data Transfer] AlternateEOL=1 If the CWBTFR.INI file already exists on the PC, then only the second line needs to be added. The location of the CWBTFR.INI file, by default, would be in C:\WINNT on WinNT and Win2000, and in C:\WINDOWS on WinXP. This fix only applies to files of type "ASCII Text" as defined in the Data Transfer to iSeries GUI. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE18251: CA400EXP-ODBC - IIS HANG DUE TO CLOSE CURSOR The ODBC driver can have two threads deadlock if the threads try to close a cursor at the same time. To cause the deadlock, each thread has to be attempting to close the cursor on a different statement handle under the same connection. This customer problem was occurring when one thread was calling SQLCloseCursor and the other thread was calling SQLMoreResults to close a cursor. APAR SE18494: CA400EXP-ODBC-INCORROUT - Miscellaneous ODBC fixes If the database or IASP name is in lowercase, the server gives the error: "The specified database can not be accessed at this time." Native Error Code: 30305 A driver fix is needed to always uppercase the database name before establishing the connection with the server. The setup GUI will be changed in a future release to automatically uppercase names as they are typed in. 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 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 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. APAR SE19889: CA400EXP-ODBC-INCORROUT - END DISTRIBUTED TRANSACTION FAILURE When ending a distributed transaction through ODBC, a call to SQLSetConnectAttr is made for the SQL_ATTR_ENLIST_IN_DTC option. The parameter passed in on the call is a NULL transaction ID. The distributed transaction coordinator normally calls xa_end before asking for the unenlist to happen. However, in some cases it does not. The driver should do an xa_end before moving out of distributed transaction mode on that connection. The current behavior results in a "SQL0428 - SQL statement cannot be run" error being reported. OLE DB PROVIDER --------------- No fixes. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- 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 SI16669. Please refer to the cover letter for fix details. 5250 Display and Printer Emulation ---------------------------------- APAR SE17835: OSP-PAR PCSWS026 ERROR WHEN SAVING .WS FILES AFTER LOADING On some PCs, the error PCSWS026 will be given when trying to save or close PC5250 sessions. No matter what location is used, the error will be given, even if the user does have full rights to the folder. This happens after applying SI15176 to iSeries Access for Windows V5R3 or SI16136 to iSeries Access for Windows V5R2. APAR SE17965: CA400EXP-TERMEMUL-INCORROUT PC5250 PUSH BUTTON NOT RETURNING In our RPG application with push buttons defined in DSPF DDS, when you tab/arrow the cursor to the push button to select it and press "Enter" the key value passed back to the RPG program is for the "Enter" key while it should be for the push button choice key defined in the DDS (F3 in this instance). 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 SE18436: CA400EXP-TERMEMUL PCSBAT.EXE CAN'T RUN *.LNK FROM BCH FILE. After applying SI16136, PC5250 batch couldn't be run if it contains a link (shortcut) object of MS-DOS batch (*.bat) named *.bat. APAR SE18841: CA400EXP-PRINTEMUL-INCORROUT GAIJI CHARACTER WRONG SIZE WITH iSeries Access V5R2M0 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 V5R2M0 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 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 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 ------------------ No fixes. 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 = SI16136 Build date = November 2004 --------------------------------- REQUIRED PROGRAMS ----------------- 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 SE17423: CA400EXP-ODBC-INCORROUT LARGE VARCHAR DOESNT SHOW DBCS DATA APAR SE17955: CA400EXP - XDA Windows client enhancements APAR SE18001: CA400EXP-TERMEMUL-INCORROUT CWBLM0040 with multiple sessions OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE16018: CA400EXP-OPNAV-NETWORK DHCP not parsing correctly in v5r3 APAR SE16078: CA400EXP-OPNAV-DBASE-INCORROUT SQL ASSIST FOR DDL STATEMENT APAR SE16458: CA400EXP-OPNAV-MSGJAVAX.SWING.JLABEL WHEN VIEWING PERMISSION APAR SE16475: CA400EXP-OPNAV-INCORROUT SMTP SERVER NAME GETS CHANGED TO APAR SE16574: CA400EXP-OPNAV CAN'T REFLECT A COLUMN HEADING VALUE IN ADD N APAR SE16646: CA400EXP-OPNAV-NETWORK-INCORROUT Can't create 1GB ifc w/5700 APAR SE16700: OpNav exception with SSL APAR SE17398: CA400EXP-OPNAV-NETWORK-INCORROUT DNS SOA serial number 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 SE17869: CA400EXP-OPNAV-NETWORK-INCORROUT Dbg Server not started APAR SE17880: CA400EXP-OPNAV-INCORROUT Standard Service Port set incorrectly for Java DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE16662: CA400EXP-DTRANSFER-INCORROUT EXCEL WITH MULTIPLE SHEETS FAILS APAR SE17300: CA400EXP-DTRANSFER-INCORROUT TTO PARSES INCORRECT SQL DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE17326: CA400EXP-DTRANSFER-MSGCWBTF0073 EXCEL ADD-IN UPLOAD FAILS ODBC ---- APAR SE16919: CA400EXP-ODBC-INCORROUT - ODBC SETUP PROBLEM WITH % IN LIBRARY NAME APAR SE17523: CA400EXP-ODBC-INCORROUT / Problems inserting DBCLOB Data APAR SE17733: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS OLE DB PROVIDER --------------- APAR SE17223: CA400EXP-OLEDB-MSGCWBZZ5014 CWBZZ5014 WHEN USING IBMDA400 LOTUS 123 FILE FORMAT SUPPORT ----------------------------- 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 SI14424. Please refer to the cover letter for fix details. 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 SE16441: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION PROBLEM AFTER 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 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ No fixes. 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 = SI14294 Build date = June 2004 --------------------------------- REQUIRED PROGRAMS ----------------- 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 SE15016: SSL - Update default key database A VeriSign Global Server Intermediate Root CA certificate has expired on 01/07/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 OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE12441: CA400EXP-OPNAV-NETWORK-MSGCPI0954 CREATE DISK TO MAX ASP USE APAR SE12695: CA400EXP-OPNAV-NETWORK-PERFM Duplicate MX records in DNS configuration APAR SE13106: CA400EXP-OPNAV-NETWORK-INCORROUT change Service Agent login The existing login for Service Agent: login.secureip.URUS.AS400ESUS, needs to be changed to: login.internet.ACCT.USERID Change made to set the correct login for Service Agent. The following PTF need to be applied in the iSeries box in order to have Service Agent connecting with the new userid: PTF SI13334 APAR SE14236: CA400EXP-OPNAV ISERIES NAVIGATOR HANG LISTING PRINTER OUTPUT APAR SE14302: OSP-DB INVALID OPERATIONS OH, UH, AND FH IN VISUAL EXPLAIN O 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 SE14563: CA400EXP-OPNAV-NETWORK PPP Navigator incorrect default for SBSD APAR SE14734: CA400EXP-OPNAV-INCORROUT CURRENT ADMINISTRATION SYSTEM/USER CAN NOT BE REMOVED APAR SE14799: CA400EXP-OPNAV Performance problem in Run SQL Scripts 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. Single signon is failing for Netserver due to problems with the Netserver Keytab entries created by the Network Authentication wizard. For both V5R2 and V5R3 versions of iSeries Navigator: The Network Authentication wizard will be updated so that the uppercase Netserver keytab entries are no longer created. These keytab entries begin with 'HOST/Q' and 'cifs/Q'. After applying the service pack, rerun the Network Authentication configuration wizard and these duplicate uppercase Netserver entries will be removed. For the V5R2 version of iSeries Navigator: Several of the Network Authentication Services (NAS) configuration tasks can be automated by creating a batch file of commands for you to run on the Windows Active Directory server. An enhancement has been made to the NAS configuration wizard in this service pack to generate this batch file. To generate the batch file you must create the QKRBKTBATF data area in the QUSRSYS library before running the NAS configuration wizard. The following is an example of the command that can be run on a V5R2 iSeries system where Network Authentication Service is about to be configured. This command will cause the NAS configuration wizard to create the C:\Temp\NasCfg_sysname.bat batch file. In this example, the batch file will be created with configuration commands that contain passwords. CRTDTAARA DTAARA(QUSRSYS/QKRBKTBATF) TYPE(*CHAR) LEN(100) VALUE('P C:\Temp\NasCfg_sysname.bat') TEXT('NAS configuration bat file info with passwords') Once this command has completed, sign on to the V5R2 iSeries system using iSeries Navigator. Run the NAS configuration wizard to configure Network Authentication Service on the system. The batch file will be created when the NAS configuration wizard completes. The format of the QUSRSYS/QKRBKTBATF data area is as follows: Characters 1 & 2 : "P " to include passwords in the batch file "NP" to indicate that passwords will NOT be included in the batch file Characters 3 - # : Contains the fully qualified file name for the batch file. If no name is specified, a default name will be generated. The filename will be displayed at the completion of the NAS wizard. Warning: If you choose to include passwords in your batch file, they will be in clear text and viewable to anyone with read access to the batch file. Delete this file immediately after using! If you do not include passwords in the batch file, you will be prompted for each password when the batch file is run. APAR SE14968: CA400EXP-OPNAV- PRINTER OUTPUT ACTION ERROR IN OUTQ SHORTCUT APAR SE15219: CA400EXP-OPNAV-OUTPUT-INCORROUT SPOOLED FILE LIST INCOMPLETE APAR SE15222: CA400EXP-OPNAV-INCORROUT Error removing user in Customize Access dialog APAR SE15235: OSP-DB TIME LABEL INCORRECT ON TOTAL RUNTIME LABEL IN INAV S APAR SE15899: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DELETE HOST DYNAMIC APAR SE15929: CA400EXP-OPNAV-NETWORK-INCORROUT DNS needs to validate subnet field APAR SE15930: CA400EXP-OPNAV-NETWORK-INCORROUT SMTP 3 PARAMETERS OUT APAR SE16141: CA400EXP-OPNAV SQL7008 WHEN EDIT TABLE IN CHINESE DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE13715: CA400EXP-DTRANSFER-INCORROUT CREATE ISERIES DATABASE FILE APAR SE15151: CA400EXP-DTRANSFER-INCORROUT UNICODE data conversion error using automation APAR SE15339: CA400EXP-DTRANSFER-MSGCWBDB0052 DATA TFR DOWNLOAD TO HTML DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE15357: CA400EXP-DTRANSFER-INCORROUT INVALID DATE/TIME SEPARATORS ENABLED ODBC ---- APAR SE14242: CA400EXP-ODBC-MSGCPF5035 OVERLAY OF PARAMETER DATA ON SECON APAR SE14415: CA400EXP-ODBC-INCORROUT - RETURN TIME, DATE, TIMESTAMP AS SQL_CHAR The ODBC-defined data type for date (SQL_TYPE_DATE), time (SQL_TYPE_TIME), and timestamp (SQL_TYPE_TIMESTAMP) do not allow for all possible iSeries date, time, and timestamp values to be returned in them. For example, with an iSeries time value of 24:00:00, the ODBC data type of SQL_TYPE_TIME can not handle this as it is defined for the largest possible time to be 23:59:59. To give a way for an application to work with those fields more easily, an enhancement is necessary so that the ODBC driver reports those fields as SQL_CHAR. This PTF provides the new functionality. APAR SE14963: CA400EXP SQLEXTENDEDFETCH RETURNS PWS0001 RETURNING DATA FRO APAR SE15598: CA400EXP-ODBC-UNPRED SQLSETPOS RETURNS DRIVER NOT CAPABLE ER 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 OLE DB PROVIDER --------------- APAR SE14470: CA400EXP-OLEDB-INCORROUT ZERO LENGTH PARAMETER DATA INCORREC APAR SE14643: CA400EXP-OLEDB-INCORROUT SQL Server hangs APAR SE15809: CA400EXP-OLEDB-MSGCPF9810 TABLE NAME LISTED AS THE LIBRARY LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR SE12423: CA400EXP-TERMEMUL-INCORROUT CHARACTERS NOT CHANGED TO UPPERC APAR SE13208: OSP-PAR CLIENT ACCESS MARGIN SETTINGS LOST AFTER FIRST PRINT APAR SE13349: CA400EXP-TERMEMUL-DBCS U/3010(EBCDIC:X/4466) CANNOT DISPLAY 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 SE14730: CA400EXP-TERMEMUL-INCORROUT PC5250 NEGOTIATES WRONG KBDTYPE APAR SE14747: OSP-PAR PC5250 CURSOR POSITIONING PROBLEMS WITH V5R1 OF CLIE 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 PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE13412: CA400EXP-OPCON-INCORROUT REMOTE CONTROL PANEL FAILS 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 Notes: You must have successfully called cwbCO_VerifyUserIDPassword(), cwbCO_Signon(), or cwbCO_Connect() before using this API. If you want to guarantee that the value returned is recent, you must either call cwbCO_VerifyUserIDPassword() explicitly, or set the Validate Mode to CWBCO_VALIDATE_ALWAYS before you call cwbCO_Signon() or cwbCO_Connect(). If the user profile password expiration interval is set to *NOMAX, a password expire date does not exist. To detect this case, first validate the user ID and password as noted above, and then, if successful, call cwbCO_GetPasswordExpireDate. A return code of CWBCO_INV_BEFORE_VALIDATE means that the password expiration interval is set to *NOMAX. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI10914 Build date = February 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 OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE11922: CA400EXP-OPNAV-OUTPUT-INCORROUT TOP OF PDF FILE IS CUT OFF W APAR SE12158: CA400EXP-OPNAV-INCORROUT CPD0082 IS RECEIVED BY CHANGING THE SCHEDULE DATE OF A J APAR SE12240: CA400EXP-OPNAV-UNPRED UNABLE TO SCHEDULE CHANGE TO VIRTUAL APAR SE12353: CA400EXP-OPNAV-NETWORK-INCORROUT QoS data corruption APAR SE12354: CA400EXP-OPNAV-NETWORK UCW support new version 5 QTOCcit.fil APAR SE12355: CA400EXP-OPNAV-NETWORK VPN needs to use Tunnel Mode APAR SE12356: CA400EXP-OPNAV-NETWORK-INCORROUT Wrong policy priority value written when connected to V5R1 system Quality of Service ( QoS ) APAR SE12438: CA400EXP-OPNAV-OUTPUT-INCORROUT CWBUN_GETPUBLICLISTOBJECT AP APAR SE12610: Client Access iSeries Navigator System status appears greyed out APAR SE12783: CA400EXP-OPNAV-MSG88 ERROR WHEN TRYING TO CHANGE PARITY APAR SE13297: CA400EXP-OPNAV-NETWORK Incorrect subsystem forced in PPP initiator profiles DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE11455: CA400EXP-DTRANSFER-DBCS CHARACTERS IN PC BIFF8 FILENAME MAKES SHEETNAME INCORRECT APAR SE12420: CA400EXP-DTRANSFER UPLOAD REQUEST LARGER THAN 4K RESULTS IN CWBTF0013 DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE12467: CA400EXP-DTRANSFER DATE PROPERTIES NOT APPLIED USING EXCEL WIZARD ODBC ---- APAR SE12051: CA400EXP-ODBC INTERNAL DRIVER ERROR WHEN USING COM+ APAR SE12232: CA400EXP-ODBC-UNPRED MEMORY LEAK IN CLIENT ACCESS ODBC DRIVE APAR SE12311: CA400EXP-ODBC-INCORROUT PROBLEMS WITH SYNONYM TYPE IN SQLTAB APAR SE13115: CA400EXP-ODBC-INCORROUT - FETCH PROBLEMS WITH PARTIAL BLOCKS APAR SE13347: CA400EXP-ODBC-UNPRED SQLCOLATTRIBUTES SQL_COLUMN_SEARCHABLE OLE DB PROVIDER --------------- APAR SE11849: CA400EXP-OLEDB-MSGCWB0111 ERROR OPENING ADO RECORDSET APAR SE11854: CA400EXP - OLEDB - INSERTING DBCS CHARS INTO UNICODE COLUMN LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- No fixes. 5250 Display and Printer Emulation ---------------------------------- APAR SE11237: CA400EXP-TERMEMUL DISPLAYING SUBFILES CONTAINING FIELDS DEFI APAR SE11341: CA400EXP-PRINTEMUL-INCORROUT PC5250 PRINTER EMULATION APAR SE11890: OSP-PAR ISERIES ACCESS FOR WINDOWS COPY AND PASTE WITH PC525 APAR SE11914: CA400EXP-TERMEMUL-INCORROUT CURSOR POSITION BY NEWLINE KEY W APAR SE12161: CA400EXP-TERMEMUL-INCORROUT IBM3270-1250 FONTS ARE NOT APAR SE12522: CA400EXP-MIGRATION-INCORROUT MIGRATING A WS FILE FOR PC5250 APAR SE12599: CA400EXP KERBEROS SETTING WILL NOT SAVE APAR SE12600: CA400EXP-PC5250 SESSION HANG WITH HYPER THREADING CPU. APAR SE12767: OSP-PAR INCORRECT OUTPUT LABELS PRINT 2 LINES PER LABEL INST APAR SE12821: CA400EXP-TERMEMUL-UNPRED PC5250 SESSION DROPPING WHEN USING APAR SE13430: CA400EXP - TERMEMUL - Add support for LotusScript Extension PCOMM supports a LotusScript Extension to their HACL interface. iSeries Access for Windows does not ship this interface. This support has now been added. APAR SE13431: TERMEMUL Signed Numeric won't paste to protected fields PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE12381: CA400EXP-OPCON-UNPRED Direct connect fails with Windows NT 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 = SI09809 Build date = October 2003 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE10680: CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION V5R2 CLI APAR SE10769: CA400EXP-APIS-INCORROUT SAP400 WITH WINDOWS APPLICATION SERV APAR SE10863: CA400EXP-TERMEMUL-INCORROUT CREATE 5250 ICON FAILS CWBCFG is run to set the PC5250 files path to each users' 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 APAR SE11183: CA400EXP-INSTALL-UNPRED SELECTIVE PLUGIN COMPLETION PERCENTAGE APAR SE11205: CA400EXP-SERVICE-INCORROUT AppAdmin Autostart service job APAR SE11653: OSP - XDA performance enhancements APAR SE11654: OSP - ODP cleanup for XDA Windows Client APAR SE11769: OSP - CA comm layer and tracing in XDA Windows client The XDA Windows client contains minimal support features. The Client Access Detail Trace and Client Access communications layer have been added to the XDA Windows Client. The sndbufsz.reg file will be obsolete and have no effect beginning with the installation of this fix and later fixes. The cwbcopwr tool can be used to set the send and receive buffer sizes. When using this fix to connect to the iSeries, the iSeries being connected to must have PTF SI10128 applied if connecting to a v5r2 server, or PTF SI10160 applied if connecting to a v5r1 server. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE10286: CA400EXP-OPNAV UNABLE TO DELETE SQL MONITOR BY INAV APAR SE10324: TCPIP CANNOT MAKE CHANGES TO DNS CONFIG USING OPSNAV APAR SE10394: OSP-PAR ACCESSING MGTC GRAPH History DATA LOCKS OPERATIONS NAVIGATOR APAR SE10515: CA400EXP-OPNAV-INCORROUT CONFIGURING A SWEDISH LPAR SYSTEM APAR SE10617: OSP-DB ERRORS WHEN USING ISERIES NAVIGATOR APAR SE11065: CA400EXP-OPNAV-OUTPUT Printer Output ERROR non-English workstations APAR SE11159: CA400EXP-OPNAV-OUTPUT PASTING SPOOLED FILES TO DESKTOP FAILS APAR SE11223: CA400EXP-OPNAV-OUTPUT-PERFM CONVERT TO PDF OPTION IN OPS NAV APAR SE11504: CA400EXP-OPNAV-OUTPUT-INCORROUT INCORRECT DISPLAY OF ISERIES APAR SE11590: OSP-DB FILE CREATED WITH SRTSEQ TABLE SHOWS INCORRECT SRTSEQ 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 APAR SE11646: CA400EXP-OPNAV-NETWORK-INCORROUT Keep RBL if add SMTP filter APAR SE11647: CA400EXP-OPNAV-NETWORK-INCORROUT Allow apostrophe in SMTP filter APAR SE11648: CA400EXP-OPNAV-NETWORK-INCORROUT BOOTP Relay Configuration 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. APAR SE11650: CA400EXP-OPNAV-NETWORK-INCORROUT Writing DNS config failure APAR SE11651: FTP Properties Config Fails TCP9503 APAR SE11669: INCORROUT Journaling dialog box shows different for IASPs under the Integrated File System APAR SE11714: CA400EXP-OPNAV-FILESYS-INCORROUT LARGE FILES SHOW INCORRECT APAR SE11743: CA400EXP-OPNAV-INCORROUT WHEN USING A MOUSE WHEEL WITHIN APP. ADMIN. APAR SE11892: CA400EXP-OPNAV-AUTHLIST-INCORROUT CANNOT ADD AN AUTL TO A APAR SE11901: CA400EXP-OPNAV-FILESYS-INCORROUT - Changing AUTL on a NetServer share in v5r2 OpNav to v5r2 OS400 fails 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 APAR SE11009: CA400EXP-DTRANSFER-INCORROUT CANNOT DELETE THE WHERE CLAUSE 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. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE11659: CA400EXP-DTRANSFER EXCEL ADD-IN LIMITED TO 16K ROWS ON XP ODBC ---- APAR SE10773: CA400EXP-ODBC SQL SERVER 2000 LINKED SERVERS RETURN PARTIAL 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 APAR SE11453: CA400EXP-ODBC-INCORROUT COLUMN NAMES FOR RESULT SETS NOT 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. 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 APAR SE10544: CA400EXP-TERMEMUL-INCORROUT PCSCM GETS AN APPLICATION ERROR APAR SE10659: CA400EXP-PC5250 PCSFONT WAS FILTERED FROM WIN2K/XP OS. APAR SE10660: CA400EXP-PC5250 JAPANESE KATAKANA APPEARED INCORRECTLY IF APAR SE10707: CA400EXP-TERMEMUL-LOOP RPG APPLICATION IS CAUSING PCSWS.EXE APAR SE10729: CA400EXP-TERMEMUL-INCORROUT PCSWS.EXE FAULTS STARTING AND ST APAR SE10742: CA400EXP-TERMEMUL-INCORROUT EHLLAPI MNEMONIC RESET FAILS TO APAR SE10864: OSP DISPLAYING A SUBFILE, IT IS BLANK. APAR SE10879: CA400EXP PCSWS APPLICATION ERROR WHEN USING SEQUENCE KEY TO APAR SE11161: OSP-PAR COPY AND PASTE WITH ISERIES ACCESS FOR WINDOWS PC525 APAR SE11324: OSP-PAR COPY AND PASTE WITH ISERIES ACCESS FOR WINDOWS PC525 APAR SE11656: CA400EXP-PRINTEMUL-INCORROUT Problem with IBM5577.PDT APAR SE11657: CA400EXP-TERMEMUL-INCORROUT 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 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 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 SI16915 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.