============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R3M0 Cumulative Service Pack Level ------------- SI16496 ------------- (c) Copyright IBM Corporation 2004. All rights reserved. ======================================================================== Co-requisite PTF SI15637 is automatically included with any shipment or web download of SI16496. SI15637 exists only for packaging reasons. All service pack level references will be to SI16496. SI16496 can be installed on any PC/server that is at V5R3 service level SI10817. See iSeries Access for Windows Properties in the IBM iSeries Access for Windows folder to determine current service level. NOTICE: ------- Application of this PTF may disable or render ineffective programs that use system memory addresses not generated by the IBM translator, including programs that circumvent control technology designed to limit interactive capacity to purchased levels. This PTF may be a prerequisite for future PTFs. By applying this PTF you authorize and agree to the foregoing. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN iSeries SYSTEM 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE 2.0 RECOMMENDATIONS/RESTRICTIONS 2.1 iSeries SERVER FIXES 2.2 APPLICATION DEVELOPMENT FUNCTION WITHIN iSeries NAVIGATOR 2.3 UNIVERSAL CONNECTION WIZARD WITHIN iSeries NAVIGATOR 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI16496 (December 2004) 4.0 INSTALL/UNINSTALL CONSIDERATIONS 4.1 REMOVING THE SERVICE PACK 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? 4.3 SERVICE PACK CONTROL 5.0 DATA TRANSFER CONSIDERATIONS 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 --------------------------------------------------------------------- 1.0 INSTALLATION INSTRUCTIONS ------------------------------ 1.1 INSTALLING FROM AN iSeries SYSTEM -------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack through the iSeries PTF ordering process either as an individual PTF order or as part of an OS/400 PTF cumulative package. Once this service pack has been applied to an iSeries system with the LODPTF and APYPTF iSeries commands, it can be installed on individual PC's with the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Check Service Level, controlled by the iSeries Access for Windows Properties Service tab, will detect that the Service source directory has been updated, and will present the user with the option to install the service pack at startup time as well. The APYPTF will update the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) on the iSeries. Any client that installs iSeries Access for Windows (or selected components) from this image will automatically receive this service pack level (no extra steps or reboots). In this scenario, the service pack cannot be uninstalled on the client PC because it is merged in with the base release. Running setupsp.bat from the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) will launch the service pack install wizard. View setupsp.bat via Notepad or Wordpad to see instructions on how to invoke setupsp.bat to record or run a silent service pack install. RMVPTF will restore your iSeries install image to the prior service level (or the base release if there was no prior service pack applied). 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE --------------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack as a set of install image files via a download from IBM's FTP site. Install the service pack by running the "SETUP.EXE" program from your PC. This program is part of the install image files shipped with a service pack. If you change the iSeries Access for Windows Properties Service tab Source Directory to the directory containing these install image files, you can also use the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Before running this program, copy the service pack install image files to a local drive on your PC or to any accessible network drive. Once the install setup program has completed, you can then remove the install image files from that drive. 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE ------------------------------------------------------------------------------------- The following method could be used if you downloaded the service pack image from the iSeries Access for Windows web page location: http://www-1.ibm.com/servers/eserver/iseries/clientaccess/casp.htm The iSeries Access for Windows service pack PTFs are combined with the original iSeries Access for Windows installation image in QIBM\ProdData\Access\Windows\Install\Image NOTE: this directory is a symbolic link to QIBM\ProdData\CA400\Express\Install\Image There is one physical directory - either of these paths will access the directory. This means that a user can install (or upgrade) iSeries Access for Windows from this combined image directory and get the latest applied service level automatically in one integrated step - since the original installation image files have been replaced by updated versions via the service pack PTF. Selectively installing components from this combined image directory will also automatically get the latest applied service level for that component. If you tailored the iSeries Access for Windows install image to another directory (for instance, on another server), using the Create Tailored Installation Image (cwbinimg.bat) tool, you can use the PTFFORM.EXE download in the FTP directory to duplicate the function of applying the iSeries PTF by following these steps: 1. Download PTFFORM.EXE (from the tailored/ FTP directory) to a directory on your PC or server. 2. Run PTFFORM.EXE to automatically expand the service pack image files to a temporary directory. 3. You will then be prompted via a wizard panel to select the iSeries Access for Windows install image directory to update to the new service level. 4. The components that are contained in the target install image will be automatically updated to the new service level from the files in the temporary directory, and then the temporary directory will be removed. 5. After completion, you can delete the downloaded PTFFORM.exe file, as it is no longer needed. Now you have combined this service pack level with the iSeries Access for Windows installation image, so that users can install iSeries Access for Windows plus this service pack in one integrated step. Note that this procedure also works if the installation image has already been combined with a prior service pack level. This procedure will replace the prior service level in the combined image with this new level. Alternatively, if you have a full copy of the original iSeries Access for Windows install image in a directory, you can combine PTFFORM.EXE with this full image, using the same 5-step procedure detailed above. Then you can run Create Tailored Installation Image (cwbinimg.bat) from this full image directory, to create tailored image directories that will automatically have the service pack merged in. 2.0 RECOMMENDATIONS/RESTRICTIONS --------------------------------- 2.1 iSeries SERVER FIXES -------------------------- In addition to installing the iSeries Access for Windows Service Pack, all servers should stay current on the latest Cumulative PTF Package, HIPER Group PTF, and Database Group PTF. Refer to IBM eServer iSeries Technical Support: Recommended fixes at http://www-912.ibm.com/s_dir/slkbase.nsf/recommendedfixes 2.2 Application Development function within iSeries Navigator --------------------------------------------------------------- The Application Development folder within iSeries Navigator is being added back in V5R3 when the iSeries Navigator Network component is installed. All help and panels associated with Application Development functions will appear in English language only. To see the Application Development folder within the iSeries Navigator hierarchy, perform either of the following: -- Selectively Install (or initially install) the Network component of iSeries Navigator from an installation image containing V5R3 service pack SI13587 or newer. -- If the Network component is already installed on the PC, install service pack SI13587 or newer to receive the Application Development folder in the hierarchy. Application Administration can be used to restrict the display of the Application Development folder to certain users or groups of users. If secondary languages are installed on the PC, the Application Development English help and panels will be copied to each installed language directory. If a subsequent secondary language is installed, install service pack SI13587 or newer to copy the Application Development English help and panels into the new language directory. 2.3 Universal Connection Wizard within iSeries Navigator ---------------------------------------------------------- Running the Universal Connection Wizard to a V5R3M0 server that has not had PTF SI15166 for 5722SS1 installed could produce non-working universal connections in some scenarios. 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 = SI16496 Build date = December 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE17422: CA400EXP-OPNAV-INCORROUT FUNCTIONS UNAVAIL WITH SSL With iSeries Navigator V5R3 connected with SSL, some of the functions will not be listed when looking at Function Availability. These include Message, Jobs, and Printer Output under the Basic Operations section. Three keys were missing in the registry that allowed iSeries Navigator functions to be displayed and function in an SSL environment. The service pack install will create these keys to fix the missing keys problem. In addition, any new install, upgrade install, or reinstall from a merged image containing this service pack will create the keys at initial installation time. CIRCUMVENTION: Via careful usage of the Registry Editor, an "SSL" subkey with a key value of "Support Level" and a DWORD value of 1 can be added to the following keys to fix this problem: -- HKEY_CLASSES_ROOT\IBM.AS400.Network\3RD PARTY EXTENSIONS\IBM.Messages -- HKEY_CLASSES_ROOT\IBM.AS400.Network\3RD PARTY EXTENSIONS\IBM.PrinterOutput -- HKEY_CLASSES_ROOT\IBM.AS400.Network\3RD PARTY EXTENSIONS\IBM.UserJobs APAR SE17423: CA400EXP-ODBC-INCORROUT LARGE VARCHAR DOESNT SHOW DBCS DATA The ODBC API SQLGetData can be called with a buffer size of zero to figure out how big of a buffer needs to be created to hold the data. When dealing with DBCS database data there are some cases where the wrong length is being returned. The correct result length will now be returned on the SQLGetData API. APAR SE17688: CA400EXP IDB2DATA INCORROUT LibList added in wrong order When setting the LibraryList property, any library names listed before *USRLIBL are added in the reverse order. APAR SE17943: OSP-DB ODP NOT REUSED. Open data paths for certain SQL statements are not being reused in a client-server environment, resulting in decreased performance. APAR SE17955: CA400EXP - XDA Windows client enhancements The following are problems addressed in this fix for the XDA Windows client: 1. An error message is not properly returned to the XDA caller when an internal function to the QxdaConnectEDRS API fails with a return code of -1 from the XDA Windows client. Instead, a valid connect handle is returned. 2. When updating a NULL capable BLOB column it is valid to set the SQLDATA pointer to NULL in the SQLDA if the SQLIND is set to -1. In a 3-tier environment the XDA API needs to pass the SQLDA provided by the application to the database server system via the specified network protocol. The XDA API was not checking the SQLIND value before trying to access the SQLDATA pointer, thus causing the MCH3601 to be signalled. 3. When returning large data from the server, during a call to the QxdaCallProgramEDRS API, the client and server are falling out of synchronization. These are solved by: 1. The proper error is returned to the XDA caller when an internal function to the QxdaConnectEDRS API fails, with a return code of -1, in the XDA Windows client. 2. The XDA QxdaProcessExtDynEDRS API now checks the SQLIND value before trying to access the SQLDATA pointer. 3. The XDA Windows client now receives the data properly from the server during a call to the QxdaCallProgramEDRS API. APAR SE18001: CA400EXP-TERMEMUL-INCORROUT CWBLM0040 with multiple sessions Error message CWBLM0040 is displayed sometimes when launching multiple display or printer sessions. The PC license software will be changed to allow more time for multiple emulation sessions to launch. CIRCUMVENTION: Retry launching the emulation session. APAR SE18197: CA400EXP-TERMEMUL-INCORROUT HMC connection timeouts Error message CWBLM0018 is sometimes displayed when connecting console through HMC. The PC license software will be changed to allow more time for HMC Telnet Proxy console connections. APAR SE18389: CA400EXP IDB2DATA PWS0043 stored procedure with parameters An application uses the .NET Managed provider to run a stored procedure which has input parameter markers and returns a result set. If the stored procedure is called more than once, the error "PWS0043 Unable to use the parameter marker values provided" is received. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE16054: CA400EXP-OPNAV-DBASE VE SHOW RELATED OPTION MISSING In V5R3 Visual Explain does not provide a way to retrieve the indexes for a table. This is important information to know when tuning a query, and it is inconvenient to return to the 'Databases' tree in iSeries Navigator to find this information. Information about indexes for a table is provided by the 'Show Related' and 'Indexes' actions on the icons in Visual Explain. APAR SE16574: CA400EXP-OPNAV CAN'T REFLECT A COLUMN HEADING VALUE IN ADD N Can't reflect the column heading value when added new column from OpNav. The 'Heading' parameter setting doesn't reflect. For example: === Specified Value as === Column Name : FLD1 Short column name : Field1 Heading : Atype === Saved value as === Column Name : FLD1 Short column name : Field1 Heading : FLD1 CIRCUMVENTION: The column heading can be changed in iSeries Navigator by opening the Run SQL Scripts window and entering the following command: LABEL ON COLUMN libname.tablename (thecolumnname IS 'column header') Note the column header can be up to 60 characters, and is displayed as three 20 character lines. APAR SE16800: CA400EXP-OPNAV CWBUNNAV.EXE Error on browsing long directory When using iSeries navigator and select IFS to browse trough a long directory path like : \QIBM\UserData\WebASE\ASE5\SYSINST\config\cells\LOCAL \applications\iSeriesNavigatorforWeb.ear\deployments\ iSeriesNavigatorforWeb\iSeriesNavigator.war\WEB-INF\web.xml a cwbunnav.exe error is reported and iSeries access aborts. This problem has existed since V5R1 of iSeries Navigator. When IFS path names get very long, iSeries Navigator has a problem accommodating that length, and the problem occurs. This problem will be fixed via service pack, and in the next available release of iSeries Navigator. CIRCUMVENTION: Note: A circumvention until a fix is available, involves using the green screen command: Work with Object Links (WRKLNK), specifying the path. For example: WRKLNK OBJ("\QIBM\UserData\WebASE\ASE5\SYSINST\config\cells\LOCAL\ applications\iSeriesNavigator.ear\deployments\iSeriesNavigator\ iSeriesNavigator.war\WEB-INF\") Once the path is entered using the WRKLNK command, you should be able to manipulate the file as needed from the green screen. APAR SE17023: CA400EXP-OPNAV-INCORROUT Server browse button in New Cluster wizard fails to refresh The Browse server window for a create cluster gives a incomplete list of servers when servers have been added or deleted. New server names are not added to the list of servers if a different form of the name is already in the list. APAR SE17085: CA400EXP-OPNAV UNIVERSAL CONNECTION WIZARD RESOURCE ERROR In the Universal Connection Wizard , when configuring a connection using the dial-up ATT scenario. Changing how the hardware resources are listed will cause the selected hardware resource to not be stored. This results in the following error when done with the wizard and saving the configuration: "An error occurred creating the Universal Connection: " CIRCUMVENTION: On the hardware resource panel, if the "List..." radio button selection is changed by the user, then selecting "Next" then "Back" and re-selecting the desired hardware resource will successfully prevent the error. APAR SE17092: QPWFSERVSO job hangs around after iSeries Navigator closes QPWFSERVSO job hangs around after iSeries Navigator closes. APAR SE17205: CA400EXP-OPNAV-INCORROUT- CPF9810 confusing message when Licensed Option 12 is not installed When trying to add a node to an existing cluster, we get the error message CPF9810 - Library QGY not found. It would be better to state that we were missing Licensed option 12. The message should indicate that Licensed Option 12 is not installed instead of the message, CPF9810 - Library QGY not found. CIRCUMVENTION: Install Boss option 12 APAR SE17213: CA400EXP-OPNAV-DBASE-MSGSQL0109-MSGSQL0190 ALTERING COLUMNS 1) Adding a new column to a table with the 'Table Definition' dialog can result in SQL0109. This will occur when the 'Nullable' checkbox is unchecked which changes the value of the 'Default value' field to "No default". The 'Show SQL' button will show the SQL statement as: ALTER TABLE MYTBL ADD COLUMN COL1 CHARACTER (1) NOT NULL ; The NOT NULL clause is not allowed in the definition of a column being added to a table unless a default value is specified. This is, however, legal when creating a table. 2) Altering an existing column by unchecking the 'Nullable' checkbox and specifying "No default" in the 'Default value' field will result in SQL0190. The 'Show SQL' button will show the SQL statements as: ALTER TABLE MYTBL ALTER COLUMN COL2 SET NOT NULL ; ALTER TABLE MYTBL ALTER COLUMN COL2 DROP DEFAULT; DROP DEFAULT can only be specified if a default value is defined for the existing column and the column does not have NOT NULL as the null attribute. The "No default" option for the 'Default value' field will not be available when altering the definition of a table, and the 'Nullable' checkbox is unchecked. CIRCUMVENTION: Specify default values or 'Use datatype default' for the new or altered columns. APAR SE17322: CA400EXP-OPNAV-NETWORK-INCORROUT ISERIES NAVIGATOR TELNET In iSeries Navigator, when going into Network -> Server -> TCP/IP and right clicking on Telnet to get properties, the properties that deal with OS/400 System Values are not all displayed correctly. This can actually cause an inadvertent change to the System Value. The problem has been corrected to properly set the values for the controls that have radio button selection choices on the telnet properties page. APAR SE17396: CA400EXP-OPNAV-NETWORK-INCORROUT single quotes in RMTSYS The GUI needs to put single quotes in RMTSYS parameter In the RMTSYS parameters of the CHGNTPA we will add single quotes so the command doesn't fail with special characters APAR SE17398: CA400EXP-OPNAV-NETWORK-INCORROUT DNS SOA serial number A change in the configuration increases the SOA record for all the zones listed in the DNS configuration. The SOA serial number will be increased only for a zone that configuration has been changed APAR SE17405: CA400EXP-OPNAV-NETWORK-INCORROUT SOCKS Domain name server not saved iSeries Navigator client V5R3, Network > TCP/IP Configuration - properties - SOCKS tab, if you have a value in "SOCKS domain name server" and you hit OK, the value will be removed. A new value can not be entered either. APAR SE17503: CA400EXP-OPNAV Inav Parity option fails to mark all options in Availability when "CHECK ALL" box is checked When starting Parity in iSeries Navigator, the "SELECT ALL" box occasionally fails to select all parity sets. Additionally, sometimes the user will not be able to manually select all parity sets. Problem has been fixed, all checkboxes now work as designed. CIRCUMVENTION: Easy workaround: Start as many parity sets as you can the first time, and then do another Start Parity to get the rest of them. APAR SE17521: CA400EXP-OPNAV-NETWORK-INCORROUT allow to configure zone TTL The Zone resource record default cache interval field on the Resources page of Zone properties is not checked or saved correctly. When the zone default cache interval is intended to be saved it is converted to seconds in some part of the process, we will add the right unit (seconds). This will avoid the TTL value to go out of the range when it is saved. APAR SE17574: CA400EXP-OPNAV-MESSAGES SQL0107 when do Analyze Results on German SQL performance monitor SQL0107 when do Analyze Results on German SQL performance monitor CIRCUMVENTION: In the Analyze Results dialog, push the Modify Selected Queries button and in the Run SQL Scripts window that appears, shorten any column name that is more than 28 characters long (Informationen für Optimierungsprogramm). Then run the query from the Run SQL Scripts window. APAR SE17654: CA400EXP-OPNAV-DBASE-INCORROUT IDENTITY COLUMN ORDER The 'Generate values in the order requested' checkbox on the 'Column definition' dialog always appears unchecked for an existing identity column. The checkbox should be checked for an identity column created with the checkbox selected, or created in SQL with "ORDER" attribute specified in the identity options clause. The 'Generate values in the order requested' checkbox will report the actual value of the column. APAR SE17709: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DOUBLE $ORIGIN STRING An extra $ORIGIN string is saved in the zone config files The zone configuration files will be saved with only one $ORIGIN string APAR SE17769: CA400EXP-OPNAV-OUTPUT-MSG INVALID DATA INCLUDE CRITERIA In V5R3 iSeries Navigator at service pack SI15176, you get an error message when entering certain values for user-specified data. For example, in Basic Operations->Printer Output->View->Customize this view->Include->User-specified data, if you enter a value either beginning with a number or including an embedded space, you get an error. The error says that this value is invalid. APAR SE17793: CA400EXP-OPNAV INCORROUT Gui Graphics fails to show all dasd DASD locations DB2-D06 through DB2-D11 done show up in graphical view. APAR SE17794: CA400EXP-OPNAV-NETWORK-INCORROUT CHILD ZONE CREATION When we try to create a Child Zone under the DNS configuration window, It is created but when we try to save the changes the Child Zone is not saved along with other configuration changes. DNS Configuration will allow to create a Child Zone APAR SE17854: CA400EXP-OPNAV Cannot change order of nodes in recovery domain of a CRG When changing the order of the nodes in the recovery domain of a cluster resource group,the change appears to work ok (the function completes without any messages). However, if one goes back in and looks at the properties of the CRG Recovery Domain, the change did not occur. Changing the order of the nodes in the recovery domain of a cluster resource group will now be honored. APAR SE17869: CA400EXP-OPNAV-NETWORK-INCORROUT Dbg Server not started Bad job name and job user specified to indicate that the server is started We will change to the right job name and job user for the Debug server APAR SE17880: CA400EXP-OPNAV-INCORROUT Standard Service Port set incorrectly for Java When Port Lookup STANDARD is selected, data is not returned correctly in Performance Tools and other Central/License/NLS Server related tasks. APAR SE17883: CA400EXP-OPNAV INCORROUT Images missing on Properties Dasd Properties does not show the graphic on Location tab. APAR SE17996: CA400EXP-OPNAV-DBASE INDEXES SUPPORT ON V5R2 The 'Indexes' function in iSeries Navigator was PTFed in V5R3M0 Service Pack 2. This support requires i5/OS V5R3M0 PTFs SI12938 and SI15255 on the server, and was only available when connected to a V5R3M0 server. This APAR will enable the Indexes functionality when connected to a V5R2M0 server where OS/400 PTF SI16313 is applied. Also, in SP3 the Indexes function is available regardless of the release level of the host. When selected, an empty window will be displayed. 'Indexes' action from the context menu of a table is enabled and functional for servers at OS/400 V5R2M0 and greater. APAR SE18006: CA400EXP-OPNAV-DBASE-INCORROUT TEMPORARY INDEXES The 'Indexes' action from the context menu of a table may display the message "An error occurred while attempting to initialize the list.". This happens if temporary indexes are included in the result. The 'Indexes' function will display the list of indexes when the result includes temporary indexes. APAR SE18049: CA400EXP-OPNAV-MSGCPF3342 DRAG AND DROP OF SPOOLED FILE If you drag and drop a spooled file to the desktop, MSGCPF3342 will be displayed, job not found. When, if fact, the job does exist with that spooled file. The error message will contain a job name containing unreadable or incorrect characters. APAR SE18070: CA400EXP-OPNAV-DBASE TABLE NAME LOST WHEN CREATING ALIAS If the user wants to create an alias with the 'New Alias' dialog, the behavior of the 'Referenced object schema' and 'Referenced object name' controls may produce undesired results if the user enters data in the fields from top to bottom. If the name of a table is input into the 'Referenced object name' field, and then a different schema is chosen from the 'Referenced object schema' field, the table name that was entered will be removed, and replaced with the name of the first table in the selected schema. If the user does not notice the change, the alias will be created for the wrong table. This may be more common if an 'Unknown alias' is created. Such an alias is created when the referenced table does not yet exist. The new index dialog will preserve user input when the referenced object schema name is changed. CIRCUMVENTION: Specify the table name after selecting the table schema name. APAR SE18109: CA400EXP-OPNAV-NETWORK UCW update to state list use Universal Connection Wizard was using the incorrect list of countries and states to populate the server Location page. This could potentially cause the created connection to fail for some selected locations. APAR SE18110: CA400EXP-OPNAV-DBASE MULTIPLE INDEXES ADVISED PER TABLE DB Performance Monitors may contain multiple indexes advised for a single table. The index advisor in Visual Explain can display and create multiple indexes per table. APAR SE18216: CA400EXP-OPNAV-INCORROUT SSL Icon not displayed correctly. SSL connections do not display the SSL indicator when the user clicks on the system. APAR SE18247: CA400EXP-OPNAV-NETWORK-INCORROUT iNav hangs, SMTP properties When customer tries to open SMTP properties navigator hangs, and in the java trace we can see a ClassCastException caused by MultilineLabel. We will avoid the ClassCastException and the iNav won't hang when SMTP properties is clicked APAR SE18254: CA400EXP-OPNAV-INCORROUT Function Availability prompting incorrect name Extra signon dialog is displayed when starting Function Availability that contains a single character system name. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE16662: CA400EXP-DTRANSFER-INCORROUT EXCEL WITH MULTIPLE SHEETS FAILS When using Data Transfer to upload an Excel spreadsheet with multiple sheets to the iSeries, only every other sheet is uploaded. No errors are displayed, only the data is incompletely transferred. APAR SE16753: CA400EXP-DTRANSFER-MSGCWBDB0014 WHEN DOING A DATA TRANSFER CWBDB0014 when doing a Data Transfer with unqualified file name. 530 client with SI13587. Qualified file names work OK. APAR SE17556: CA400EXP-DTRANSFER-MSGSQL5016 CONTAINING DOT IN FILE NAME When a file name in the request contains a dot character ('.'), the file name is truncated and the transfer fails. Code has been changed to correctly parse file names including a dot character ('.') APAR SE17875: CA400EXP-DTRANSFER-INCORROUT EXCEL EMPTY CELLS AS UNICODE When an Excel file contains empty cells (detected as UNICODE in the Contents of PC File section of the Wizard in V5R3), and the iSeries field does not have a default value specified, blank spaces are not uploaded correctly to the iSeries. Code has been changed to correctly upload empty cells to the iSeries. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE17733: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS Several problems exist in ODBC: When using ODBC Setup and typing in a translation option, you are limited to specifying a value less than 32768. In an MTS environment, an application may attempt to unenlist a transaction before the transaction's two phase commit has been completed. APAR SE18215: CA400EXP-ODBC-UNPRED - VARIABLE LENGTH COMPRESSION ENHANCEMENT The driver's fetching of data from variable-length fields (VARCHAR, VARBINARY, VARGRAPHIC,... ) can be inefficient in some cases. An enhancement is being provided that will help with performance when using forward-only cursors. To take advantage of this enhancement, the application must be using the 'Block if fetch of 1 row' DSN option (or the BLOCKFETCH=1 keyword). That setting is enabled by default. Note, to get this enhancement to work a V5R3 iSeries server and some additional server PTFs are required. As the server PTFs become available they will be documented at: http://www-1.ibm.com/servers/eserver/iseries/access/servernotes.html APAR SE18251: CA400EXP-ODBC - IIS HANG DUE TO CLOSE CURSOR 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. OLE DB PROVIDER --------------- APAR SE17223: CA400EXP-OLEDB-MSGCWBZZ5014 CWBZZ5014 WHEN USING IBMDA400 MDAC 2.7 changed how small numeric values were handled. Specifically, scientific notation is passed to us when VB.SINGLE variables are used in the client application. When a comma decimal separator is in use as well, the conversion will be incorrect. .NET DATA PROVIDER ------------------ APAR SE17385: CA400EXP IDB2DATA Incorrect result data on 2nd call to Execute The application executes a command that returns a result set (either by calling ExecuteReader or ExecuteScalar). The first time the command is executed, the correct result data is returned. On the second and subsequent calls, the original result data is always returned instead of the correct results. CIRCUMVENTION: To avoid this error, the application can use a new iDB2Command object each time it wants to execute the statement. APAR SE17432: CA400EXP IDB2DATA MSGSQL0519 after failed Execute The application calls one of the iDB2Command.Execute methods (ExecuteReader or ExecuteScalar) and receives an SQL error. The application calls the execute method again, and this time receives an error SQL0519, indicating the statement is in use. APAR SE17639: CA400EXP IDB2DATA MSGSQL0518 Select statement parsed as a stored procedure The application attempts to execute a Select statement on a table whose name or column contains the substring 'CALL'. An SQL0518 message results. CIRCUMVENTION: This problem only occurs if the statement text is a SELECT statement, and the table name or a column name in the select statement contains the phrase 'CALL'. To circumvent the problem, rename the table or column name. APAR SE17960: CA400EXP IDB2DATA INCORROUT FAILURE W/RESTRICTED PERMISSIONS A .NET solution uses the IBM.Data.DB2.iSeries managed provider from iSeries Access for Windows V5R3. Adding a restriction to the assembly to refuse FileIOPermission causes the application to fail to run. Instead, the following error appears: Unhandled Exception: System.Security.SecurityException: Security error. at MainApplication.Main() If no connection is created using the IBM.Data.DB2.iSeries data provider, the program will run without this error. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.6 (10/29/2004) and the equivalent of 5722JC1 SI16227. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE15390: CA400EXP-PRINTEMUL-INCORROUT PC5250 BESTFIT OPTION CANNOT BE Unchecking the use Bestfit option under file and page setup, does not disable Bestfit. APAR SE15842: CA400EXP-TERMEMUL-INCORROUT PC5250 CROSSHAIR FLICKER If Customer is using the crosshair in his PC5250 sessions the crosshair is flickering. It looks like that the screen is permanently refreshed. But only the crosshair is flickering not the Background. This problem occurs only with his RPG programs, not with the system shipped menus. APAR SE15974: CA400EXP-TERMEMUL-INCORROUT MACRO RECORDING CAUSES INSTRUCTI Customer executes the following steps: iSeries Access R520, Emulator, new session, (add ip-address but don't signon), click the 'record' button, give the macro a name. Pressing OK to save will result in the following error: "The instruction at "0x62d85202" referenced memory at "0x1fffffff". The memory could not be read." APAR SE16377: CA400EXP-TERMEMUL-INCORROUT PCSWS ERROR ON WIN2003 PC customer creates a new .ws giving the session a name (he must do that since sbsd accepts only devd beginning with specific chars). He fills in the uid/pwd request (license) and gets the signon screen Then he closes and saves the session He then opens it again, now when he's prompted for the UID/PWD he clicks on CANCEL instead of providing uid/pwd Then, as expected , the pc5250 session is blank and he can't get the signon screen He then clicks on the X to close the session and session properly closes Then he starts again the same saved session He's prompted for uid/pwd , he clicks on CANCEL again Now the problem occurs, PCSWS error appears, he must click on OK button to get rid of it but since that session can't be closed, he must close it from task manager APAR SE16461: CA400EXP-TERMEMUL-INCORROUT WS FILE STORED ON NETWORK DRIVE WS File stored on network drive cause network load, WS file is read for each keystroke except alphanumeric keys APAR SE16941: CA400EXP-TERMEMUL-MSGPCSWS PLAYBACK OF A MACRO CAUSES PCSWS When attempting to playback a macro a pcsws error message appears. Issue seems to be intermittent. APAR SE17146: CA400EXP-PRINTEMUL-INCORROUT INCORRECT OUTPUT WHEN USING A spooled file contains columns of data. If there is DBCS data in the first column, the data in the second column is not lined up correctly. If both columns are SBCS data, there is no problem. The esc_p.pdt seems to be generating relative move commands from the end of the text data, instead of using relative moves from a constant position, such as the left margin. Since DBCS data is wider than SBCS data, the data in the second column is positioned further to the right. APAR SE17386: CA400EXP-TERMEMUL-INCORROUT PC5250 DISPLAY MOSTLY BLANK FIEL After applying SI14294 PC5250 does not display all the data in the fields until the user presses enter. Once enter is pressed the data in the fields are filled out. APAR SE17656: CA400EXP-TERMEMUL-INCORROUT BATCH FILE PROCESSING RUN statements in a .BCH file are not processed by the EPCSBAT.EXE The .BCH file worked for years but fails with iSeries Access V5R2. Sample of a failing RUN statement: Run1=C:\Program Files\Client Access\Emulator\Pcsws.EXE H:\Apps\ClientAccess\IWP_F.WS /S=Z The problem is because of not putting CWBLOGON parameters in " (double quotes). A modified RUN statement that is executed correctly is: Run1=C:\Program Files\Client Access\Emulator\Pcsws.EXE "H:\Apps\ClientAccess\IWP_F.WS" /S=Z There is no documentation found for the exact syntax for .BCH-files? There seems to be a change in the way the parameters are parsed. APAR SE17658: OSP CAEXP-DSP-INCORROUT SHAPE OF YEN: AND DOLLAR:$. This problem is the same problem as IC41568 of PCOM. Shape of Yen: and Dollar:$ have been changed CAEXP V5R3. It is the shape which was crushed. 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. APAR SE17843: CA400EXP-TERMEMUL-INCORROUT HACL AUTOMATION OBJECT EVENTS NO A number of problems were found when using the HACL automation objects. If an AutSess object is instantiated and the RegisterCommEvent and RegisterSessionEvent methods are invoked, subsequent events are not fired for other automation objects such as AutPS or AutOIA. If the AutSess UnregisterCommEvent and UnregisterSessionEvent methods are subsequently invoked, the events resume firing for the other automation objects. 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 SE18068: CA400EXP-TERMEMUL-WAIT EXIT HANGS WITH READ-ONLY .WS A user has a read-only Pc5250 workstation file (.ws), and changes a setting or preference in the emulation session. When the user attempts to exit the emulation session, the session will not close, and user must cancel the task via Windows Task Manager. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE17216: CA400EXP-OPCON-INCORROUT some signon failures not displayed A signon failure due to an expired userid may be displayed to the user as a communication error. The user is now prompted to change the password for an expired userid. APAR SE18139: CA400EXP-OPCON-INCORROUT RCP listed as not authorized Connecting a direct cable configuration with the remote control panel option may produce the message "Authority has not been granted to the partition nnn remote control panel. Remove it from the selected list?" The message is not correct and the control panel is not displayed. Connecting a direct cable configuration with the remote control panel option will no longer produce the listed message. APAR SE18189: CA400EXP-OPCON-MSG Virtual Control panel CWBOPAOC.EXE fault Under certain conditions, particularly with WinNT and autostart, a configuration which has a selected control panel may not display the treeview line associated with the control panel. Connecting such a config and starting and stopping the control panel may produce an Application Exception in CWBOPAOC.EXE. With this change the fault no longer occurs. CIRCUMVENTION: To avoid the problem, turn off autostart for that configuration. APAR SE18351: CA400EXP-OPCON-INCORROUT AFTER RCS TO LCS CONNECTION FAILURE If the connection between an RCS and LCS is lost, the RCS may ignore all future attempts to connect to the LCS. The RCS can now connect more than once to the LCS. CIRCUMVENTION: To connect the RCS to the LCS a second time one must end and restart Operations Console on the RCS. PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI15176 Build date = September 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE15339: CA400EXP-DTRANSFER-MSGCWBDB0052 DATA TFR DOWNLOAD TO HTML APAR SE16157: CA400EXP-SSL-INCORROUT MANDATING SSL FAILS 5250, VERIFY APAR SE16446: CA400EXP-OPNAV-INCORROUT DISCOVERY OF ADMINISTRATION SYSTEM PROBLEM APAR SE16477: CA400EXP-OPCON-INCORROUT LAN CONSOLE NOT CONNECTING ANYMORE APAR SE16866: CA400EXP-OPNAV-MESSAGES-INCORROUT MULTIPLE SEND MESSAGE ITEMS APAR SE16920: CA400EXP - Multiple Platform XDA APAR SE17036: CA400EXP-2-MSGCWB4028 RMTCMD REJECTS RESTRICTED USERS The RMTCMD program in the V5R3 iSeries Access for Windows client behaves differently than previous versions did. If the user has limit capabilities set to *YES on their user profile, RMTCMD is now rejecting attempts to run commands with a message CWB4028. It makes no difference if the command is allowed by restricted users or not, it is rejecting all commands with this message. The change was made to the client without any notification in the Memo To Users for V5R3 and is causing existing customer programs to fail and if this function does not revert back to the old behavior, those programs will need to be rewritten. The RMTCMD program will be changed back to it's previous behavior of allowing iSeries profiles with limited capabilities to execute commands. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE14716: LIC OPS NAV WAIT CONDITION APAR SE15235: OSP-DB TIME LABEL INCORRECT ON TOTAL RUNTIME LABEL IN INAV APAR SE15469: CA400EXP-OPNAV-INCORROUT Sys Monitor crash when edit values APAR SE15492: CA400EXP-OPNAV-DBASE-INCORROUT Canceling insert of a row into table causes following row to be deleted APAR SE15899: CA400EXP-OPNAV-NETWORK-INCORROUT DNS DELETE HOST DYNAMIC APAR SE15911: CA400EXP-OPNAV-DBASE-INCORROUT SORT EXPLAINABLE STMTS LIST APAR SE15929: CA400EXP-OPNAV-NETWORK-INCORROUT DNS needs to validate subnet field APAR SE15947: CA400EXP-OPNAV-DBASE-WAIT Run SQL Scripts Save changes dialog does not appear APAR SE15975: CA400EXP-OPNAV INCORROUT create of new ASP fails to display 2105 type ESS LUNS APAR SE15985: CA400EXP-OPNAV-DBASE-UNPRED CLICKING JOURNALING CAUSES ABEND APAR SE16000: CA400EXP-OPNAV-WAIT Two TaskActionEvents for a shared propertysheet causing a hang in iNav APAR SE16041: CA400EXP-OPNAV-DBASE-INCORROUT CANNOT CREATE RANGE PARTITION APAR SE16053: CA400EXP-OPNAV-DBASE VE INDEX ADVISOR COLUMNS INFO TRUNCATED APAR SE16055: CA400EXP-OPNAV-DBASE DBNAV SCHEMA IN PROPERTIES INCORRECT APAR SE16056: CA400EXP-OPNAV-DBASE F4 KEY DOES NOT LAUNCH SQL ASSIST APAR SE16075: CA400EXP-OPNAV HAT V5R3 GEO mirroring returns inappropriate message for error condition APAR SE16130: CA400EXP-OPNAV Send SNA panel hangs APAR SE16141: CA400EXP-OPNAV SQL7008 WHEN EDIT TABLE IN CHINESE APAR SE16167: OSP SI13587 CAUSED DATE/TIME FORMAT CHANGE IN OPSNAV APAR SE16458: CA400EXP-OPNAV-MSGJAVAX.SWING.JLABEL WHEN VIEWING PERMISSION APAR SE16475: CA400EXP-OPNAV-INCORROUT SMTP SERVER NAME GETS CHANGED TO APAR SE16486: CA400EXP-OPNAV-INCORROUT Preferred node status change - error for site name APAR SE16561: CA400EXP-OPNAV Inserting rows into table with default values for DATE field produces "Error in assignment" APAR SE16646: CA400EXP-OPNAV-NETWORK-INCORROUT Can't create 1GB ifc w/5700 APAR SE16647: CA400EXP-OPNAV-NETWORK-INCORROUT NAS Batch file NET USER password should not be random string APAR SE16661: CA400EXP-OPNAV-USRGRP-INCORROUT Add LCLPWDMGT parameter The Local password management (LCLPWDMGT) parameter is not available when using iSeries Navigator Users and Groups to create or change a user profile. A checkbox needs to be added to the Users and Groups Capabilities->Password tab display panel to allow IBM Integration for Windows Server users to decide if they want to "Manage this password locally". For more information regarding the changes to iSeries Navigator for managing your IBM Integration for Windows Server users go to http://www.ibm.com/servers/eserver/iseries/navigator/faqs.html#lclpwdmgt APAR SE16751: CA400EXP-OPNAV-NETWORK UCW support for backup VPN to Rochester SDC This Universal Connection Wizard update corresponds with host PTF 5722SS1 SI15166 to configure a backup VPN universal connection. This fix affects the output of the Universal Connection Wizard to support a backup service data center for downloading fixes. The wizard will create a second dial profile in the VPN scenario QTOCL2TP2. To complete creation of the second VPN connection there will be an additional VPN connection QIBMSERVICE52 and a corresponding IKE policy. The Universal Connection Manager on the iSeries will use the backup VPN connection should the primary be unavailable. APAR SE16752: CA400EXP-OPNAV-DBASE-INCORROUT CREATE ADVISED INDEX SCHEMA APAR SE16762: CA400EXP-OPNAV-INCORROUT System status field 'Shared processor pool usage' shows incorrect data APAR SE16838: CA400EXP-OPNAV-DBASE-INCORROUT COLUMN WITH NO DEFAULT APAR SE16926: CA400EXP-OPNAV CPFB957 Endpoint system not found APAR SE17022: CA400EXP-OPNAV CTL-C of spooled file Followed by Paste Fails APAR SE17045: CA400EXP-OPNAV-FILESYS-INCORROUT OSP COPY/PASTE FROM QTCPTMM IN OPS NAV PUTS FILES IN ROOT OF APAR SE17082: CA400EXP-OPNAV-MESSAGES String index out of range when execute blank statement in Run SQL Scripts DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- No fixes. DATA TRANSFER EXCEL ADD-IN -------------------------- No fixes. ODBC ---- APAR SE15149: CA400EXP-ODBC-UNPRED - ROW-WISE BINDING PROBLEM APAR SE15598: CA400EXP-ODBC-UNPRED SQLSETPOS RETURNS DRIVER NOT CAPABLE ER An application uses Microsoft RDO and iSeries Access for Windows ODBC to access lob fields. The application uses a block size of 100 rows on the fetch, then attempts to use SQLSetPos and SQLGetData to access the lob data. The ODBC driver returns SQLState S1C00 "Driver not capable" on the SQLGetData api. The error is caused because the odbc driver does not support positioning to a specific row in a block fetch when the requested block size is greater than 1. This restriction is described in the ODBC driver metadata via the SQLGetInfo SQL_GETDATA_EXTENSIONS API. The driver is adding support so that SQLSetPos can be called to position to the first row in a rowset. The driver will return the "driver not capable" error on a SQLSetPos call if an attempt is made using this API to position to a row beyond on the first in the rowset. APAR SE15814: CA400EXP-ODBC CATALOG_NAME NAMES ARE PADDED WITH SPACES APAR SE15895: CA400EXP-ODBC-MSGINTERNAL DRIVER ERROR INTERMITTENT FAULT IN APAR SE16131: CA400EXP-ODBC-UNPRED - PACKAGE PROBLEM WITH STATEMENT IN USE APAR SE16287: CA400EXP-ODBC-MSGSQL7008 AUTOCOMMIT OFF COMMIT MODE CHANGED APAR SE16834: CA400EXP-ODBC-INCORROUT INCORRECT DECIMAL PARAMETER VALUES APAR SE16919: CA400EXP-ODBC-INCORROUT - MISCELLANEOUS ODBC PROBLEMS OLE DB PROVIDER --------------- APAR SE15785: CA400EXP-OLEDB-INCORROUT ADO ActualSize wrong for LOBS. APAR SE15809: CA400EXP-OLEDB-MSGCPF9810 TABLE NAME LISTED AS THE LIBRARY APAR SE16302: CA400EXP-OLEDB-MSGCWBZZ5014 INSERT/UPDATE TABLE WITH LOB APAR SE16667: CA400EXP-OLEDB-INCORROUT SQLSTATE NOT SET FOR COMM ERROR .NET DATA PROVIDER ------------------ APAR SE15897: CA400EXP IDB2DATA Add iDB2ProviderSettings class A new class is needed to enable static, process-wide settings for the IBM.Data.DB2.iSeries .NET provider. The following new class will be created: Class name: iDB2ProviderSettings Description: Provides a way to set process-global provider settings. This class cannot be inherited. Property name: static string ProviderVersion (read-only) Description: Returns a string containing the IBM.Data.DB2.iSeries .NET provider's AssemblyFileVersion. Method name: static void CleanupPooledConnections() Description: Performs orderly cleanup of pooled connections. Calling this method just before your process terminates will ensure pooled iDB2Connections get cleaned up properly. Make this method the last call you make before your process terminates. This ptf adds the new iDB2ProviderSettings class. APAR SE16002: CA400EXP IDB2DATA CommandBuilder fails with WHERE clause APAR SE16003: CA400EXP IDB2DATA Exception with Decimal/Numeric result data APAR SE16036: CA400EXP IDB2DATA Fix incorrect parameter handling for Stored Procedures APAR SE16951: CA400EXP IDB2DATA Add support for LOBs and Library List Add support for LOBs and Library List to the .NET provider. The following new data types are added: iDB2Blob - represents a binary large object iDB2Clob - represents a character large object iDB2DbClob - represents a double byte character large object A new iDB2NamingConvention enum is created that allows the application to select SQL naming or System naming. The iDB2Connection class has the following new properties: Naming - to control the naming convention (SQL or System). Value is specified as either SQL or System. MaximumInlineLobSize - to control the threshold at which LOB data is transferred using LOB Locators, instead of as inline data. Value is an integer in the range 0-15360 which specifies the maximum size (in kilobytes) of a LOB which can be retrieved from the host server in a single operation. LibraryList - allows the application to set the user portion of the host server job's library list. If the application wants the DefaultCollection included in the library list, it must include it in the LibraryList property. LibraryList is a comma-delimited list of library names which may contain the special name *USRLIBL, which is a placeholder to indicate the host server job's current user portion of the library list. By placing other library names before or after *USRLIBL, the application can control where the libraries get added in relation to the job's current user library list. If *USRLIBL is not specified in the LibraryList, the specified libraries will replace the server job's current user library list, so applications that wish to add to the library list should be sure to specify *USRLIBL somewhere in the LibraryList. The iDB2DataReader class has the following new methods: GetiDB2Blob(int index) GetiDB2Clob(int index) GetiDB2DbClob(int index) This ptf adds LOB and Library List support to the .NET provider. APAR SE17162: CA400EXP IDB2DATA Decimal/Numeric digits truncated LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.5 (07/30/2004) and the equivalent of 5722JC1 SI14873. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE14730: CA400EXP-TERMEMUL-INCORROUT PC5250 NEGOTIATES WRONG KBDTYPE APAR SE15297: OSP PCSERR101 ERROR WHEN A COPY/PASTE FUNCTION IS PERFORMED. APAR SE15562: CA400EXP-TERMEMUL-MSGPCSERR999 MACRO LIMITED TO 64KBYTE APAR SE15735: CA400EXP-PRINTEMUL-UNPRED PRINTER SETUP WINDOW DOES NOT DISP APAR SE15931: CA400EXP-TERMEMUL-INCORROUT AFTER RETURNING TO CALLING PGM APAR SE16801: CA400EXP-TERMEMUL-INCORROUT GERMAN FUNCTION KEY ALT K IS NOT PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE13412: CA400EXP-OPCON-INCORROUT REMOTE CONTROL PANEL FAILS APAR SE16299: CA400EXP-OPCON-INCORROUT wizard hangs in WinNT APAR SE16534: CA400EXP-OPCON-INCORROUT fault RCS to LCS and firewall APAR SE16535: CA400EXP-OPCON-INCORROUT close may hang APAR SE16821: CA400EXP-OPCON-INCORROUT emulator may not start PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- Non-APAR fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI13587 Build date = May 2004 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE12606: CA400EXP-2-MSGCWBCF0005-F/CWBBACK CWBBACK FAILS WHEN DBCS INVOLVED APAR SE13599: CA400EXP - Add 64 bit support to XDA Windows client APAR SE13926: CA400EXP-CONNECTIONS-UNPRED NO CWBCFG KERBEROS SETTING The cwbcfg utility provides a parameter for configuring the signon mode of the connection being defined: /uid . All signon modes may be set using this parameter except the use of Kerberos. The /uid parameter of cwbcfg now accepts the value *KERBEROS which configures the connection to use Kerberos for authentication. For example: cwbcfg /host server1 /uid *KERBEROS creates a connection to server "server1" and configures it for all users of the PC, and for the Default User, so that Kerberos is used for authentication. Previously, the only allowed values were *WINLOGON, *PROMPTALWAYS, and an actual iSeries user ID. IMPORTANT NOTE: Although you can now configure the new connection to use Kerberos, authenticating this way may not work. One possible reason is that the new or changed connection is configured only for accounts local to the PC on which cwbcfg is run. Successful use of Kerberos may require logging on to a domain, and local account configuration information is not typically used for domain logons. This is no different from the case in which a user logs on to the local PC, then uses iSeries Navigator to configure a connection to use Kerberos as the means of authentication. APAR SE14941: CA400EXP-DTRANSFER Help not displayed APAR SE15016: SSL - Update default key database A VeriSign Global Server Intermediate Root CA certificate has expired on January 7, 2004. This CA certificate was included in the default SSL key database shipped with the product. Updated SSL key database files (cwbssldf.kdb and cwbssldf.sth) will be provided by this service pack. The new files will only be installed if the previous files are deleted or do not exist in the Common Documents folder. APAR SE15205: CA400EXP - Incorrect data passed to database server from XDA Windows client APAR SE15507: CA400EXP-OPCON-INCORROUT CWBOPAUT.DLL ERROR APAR SE15715: CA400EXP-INCORROUT cwblmsrv background task not exiting OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE12438: CA400EXP-OPNAV-OUTPUT-INCORROUT CWBUN_GETPUBLICLISTOBJECT AP APAR SE12441: CA400EXP-OPNAV-NETWORK-MSGCPI0954 CREATE DISK TO MAX ASP USE APAR SE12774: CA400EXP-OPNAV-DBASE-INCORROUT CREATE NEW VIEW DIALOG MAY NO APAR SE12976: CA400EXP-OPNAV-DBASE-INCORROUT PROMPTING FOR PASSWORD APAR SE13504: CA400EXP-OPNAV-INCORROUT LPAR Create wizard doesn't use regional setting for shared procs APAR SE13614: CA400EXP-OPNAV-NETWORK Universal Connection Wizard modal to frame APAR SE13616: CA400EXP-OPNAV-NETWORK-INCORROUT Leased lines line profile cannot be updated APAR SE13629: CA400EXP-OPNAV-NETWORK Remote support authentication ids to allow connect APAR SE14019: CA400EXP-OPNAV-NETWORK-INCORROUT File extensions corrupted on add share APAR SE14236: CA400EXP-OPNAV ISERIES NAVIGATOR HANG LISTING PRINTER OUTPUT APAR SE14383: CA400EXP-OPNAV-NETWORK Routes not added when configuring an ATT dial connection APAR SE14408: CA400EXP-OPNAV-FILESYS-PERFM LONG DELAYS WHEN MOVING MULTIPL APAR SE14555: CA400EXP-OPNAV-NETWORK-INCORROUT DNS ENABLES ADD HOST APAR SE14558: CA400EXP-OPNAV-NETWORK-INCORROUT SMTP properties update fails APAR SE14569: CA400EXP-OPNAV-INCORROUT MC Task Status window does not always paint APAR SE14570: CA400EXP-OPNAV-NETWORK UCW Qtocl2txx line description wrong APAR SE14574: CA400EXP-OPNAV-INCORROUT Changing Max graph value on graph history takes two refreshes to take effect APAR SE14585: CA400EXP-OPNAV-NETWORK UCW phone5 call list to phone4 APAR SE14644: CA400EXP-OPNAV-NETWORK RAS PPP filter identifier list empty APAR SE14720: LIC-DISK-STG OPS NAV DISK POOLS DISPLAY PROBLEM APAR SE14734: CA400EXP-OPNAV-INCORROUT CURRENT ADMINISTRATION SYSTEM/USER CAN NOT BE REMOVED APAR SE14800: CA400EXP-OPNAV-NETWORK-INCORROUT Webfacing settings not saved APAR SE14802: CA400EXP-OPNAV-NETWORK-INCORROUT Netserver Single Signon failing due to uppercase keytab entries. APAR SE14914: CA400EXP-OPNAV-INCORROUT Capabilities->Auditing page must be hidden for non-administrators APAR SE14968: CA400EXP-OPNAV- PRINTER OUTPUT ACTION ERROR IN OUTQ SHORTCUT APAR SE14983: CA400EXP-OPNAV-NETWORK-INCORROUT QoS Configuration GUI ignores subnet mask input when creating a new Client object APAR SE15045: CA400EXP-OPNAV User registration is not working Service Agent user registration fails using iSeries Navigator. NOTE: In order for this fix works properly you need to install PTF SI13239 for the OS/400 operating system (5722SS1) or one that supersedes it in the iSeries server that is specified as Management Central system. APAR SE15048: CA400EXP-OPNAV ESA Verify connection to IBM is hung Verifying connection to IBM window is hung NOTE: In order for this fix works properly you need to install PTF SI13239 for the OS/400 operating system (5722SS1) or one that supersedes it in the iSeries server that is specified as Management Central system. APAR SE15049: CA400EXP-OPNAV ESA Subsystem jobs window APAR SE15050: CA400EXP-OPNAV ESA License not displayed for any release APAR SE15052: CA400EXP-OPNAV-AUTHLIST-INCORROUT Need to display description of Authority lists in iSeries Navigator Window APAR SE15081: CA400EXP-OPNAV-UNPRED Moving node up to be primary in Recov. Domain doesn't show entire line moving & "ineligible" node status APAR SE15105: CA400EXP-OPNAV-INCORROUT When adding a data port ip address fails, the address still shows up in the gui like it was successful APAR SE15106: CA400EXP-OPNAV-PERFM Occasional Hangs during make available APAR SE15122: CA400WINOPT-OPNAV Support new hardware for V5R3M0 on Graphical Views No graphical views for the new hardware. Graphical views added. Requires PTF 5722999 MF32576 as well. APAR SE15148: CA400EXP-OPNAV-INCORROUT Cannot Display Disk Pool Properties Of Mirrored IASP APAR SE15212: CA400EXP-OPNAV-DBASE-INCORROUT SCHEMA STARTS WITH @ # $ APAR SE15219: CA400EXP-OPNAV-OUTPUT-INCORROUT SPOOLED FILE LIST INCOMPLETE APAR SE15222: CA400EXP-OPNAV-INCORROUT Error removing user in Customize Access dialog APAR SE15282: CA400EXP-OPNAV-INCORROUT Consolidated Hardware File saved to incorrect path APAR SE15308: CA400EXP-OPNAV-INCORROUT Suspend Geographic Mirroring menu item occasionally in incorrect state APAR SE15367: CA400EXP-OPNAV-NETWORK-WAIT Directory Server Propertysheet hangs searching/updating the configuration APAR SE15388: CA400EXP-OPNAV-UNPRED APPLICATION DEVELOPMENT FOLDER MISSING APAR SE15395: CA400EXP-OPNAV-INCORROUT Adding a data port ip address failure still shows up as successful APAR SE15500: LIC-DISK-STG-UNPRED APAR SE15501: CA400EXP-OPNAV Drop down with wrong value on Edit Time Zone APAR SE15511: CA400EXP-OPNAV-INCORROUT Intelligent Agent panel hangs APAR SE15512: CA400EXP-OPNAV-NETWORK Unable to turn off LDAP filter cache support APAR SE15513: CA400EXP-OPNAV-INCORROUT Configuring a V5R2 server that is a replica to a master fails. APAR SE15514: CA400EXP-OPNAV-INCORROUT Directory Server publishing fields not enable/disabled correctly. APAR SE15526: CA400EXP-OPNAV-DBASE-WAIT CANNOT LAUNCH EXPRESSION BUILDER APAR SE15527: osp - Deleting a data port IP address fails APAR SE15528: CA400EXP-OPNAV-INCORROUT Removing a node in a recovery domain handled incorrectly APAR SE15545: CA400EXP-OPNAV Cannot Deconfigure Just A Secondary IASP APAR SE15546: CA400EXP-OPNAV-INCORROUT GUI is partially untranslated APAR SE15748: CA400EXP-OPNAV Site name & membership status incorrect in recovery domain when moving nodes DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE15025: CA400EXP-DTRANSFER - UTF-8 ALWAYS TRUNCATES SPACES APAR SE15133: CA400EXP - DTRANSFER - trap opening TTO file APAR SE15135: CA400EXP-DTRANSFER UNICODE AND UTF8 PROBLEMS APAR SE15716: CA400EXP-DTRANSFER trailing blanks cause CWBLM0040 APAR SE15767: CA400EXP-DTRANSFER THE BROWSE FILES AND MEMBERS WINDOW FAILS DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE15356: CA400EXP-DTRANSFER-INCORROUT FDF DATE/TIME SETTINGS RESET WHEN USING USING EXCEL WIZARD ODBC ---- APAR SE13347: CA400EXP-ODBC-UNPRED SQLCOLATTRIBUTES SQL_COLUMN_SEARCHABLE APAR SE14242: CA400EXP-ODBC-MSGCPF5035 OVERLAY OF PARAMETER DATA ON SECON APAR SE14415: CA400EXP-ODBC-INCORROUT - RETURN TIME, DATE, TIMESTAMP AS SQL_CHAR APAR SE14963: CA400EXP SQLEXTENDEDFETCH RETURNS PWS0001 RETURNING DATA FRO APAR SE15056: CA400EXP-ODBC-INCORROUT - OVERRIDE PASSWORD ENHANCEMENT When connecting with ODBC and your password is expired on the server, an error or a dialog asking the user to change the password is returned to the application. To avoid the error and possible dialog, an enhancement is being provided to allow an application to programmatically change the user's password. An example scenario on how this might be used is listed below: The application calls SQLDriverConnect with the SQL_DRIVER_NOPROMPT DriverCompletion option and the userid (UID keyword) and password (PWD keyword) specified in the connection string. Since the userid and password combination is expired, an error (SQL_ERROR) is returned to the application. No prompts are returned because of the SQL_DRIVER_NOPROMPT option. The application calls SQLError (or SQLGetDiagRec) to get back the NativeError. If the native error is 8003 then this is the case where the userid/password combination was expired. The application calls SQLDriverConnect with the userid (UID keyword), current password (PWD keyword), and the new password (NEWPWD keyword) specified in the connection string. The driver will change the password for that user profile to the new password if the current password is valid. APAR SE15502: CA400EXP-ODBC-INCORROUT - FIX SQLPROCEDURECOLUMNS ISSUES THAT COULD CAUSE FAULTS OLE DB PROVIDER --------------- APAR SE14470: CA400EXP-OLEDB-INCORROUT ZERO LENGTH PARAMETER DATA INCORREC APAR SE15283: CA400EXP-OLEDB-UNPRED RLA RANDOM TRACE APAR SE15503: CA400EXP-OLEDB-INCORROUT BLANK STRINGS RETURN INCORRECT DATA .NET DATA PROVIDER ------------------ APAR SE13984: CA400EXP IDB2DATA MSGSQL0501 Cursor not open error APAR SE13985: CA400EXP IDB2DATA INCORROUT iDB2CommandBuilder fails with table created using DDS APAR SE13986: CA400EXP IDB2DATA INCORROUT DeriveParameters not setting Size and IsNullable APAR SE14008: CA400EXP IDB2DATA INCORROUT DeriveParameters not setting ParameterName APAR SE15169: CA400EXP IDB2DATA .NET traces and logs sometimes do not work APAR SE15170: CA400EXP IDB2DATA Fix several problems with .NET provider A new method is added: iDB2DataReader.HasRows(). This method can be called to determine if the iDB2DataReader returned any rows. A final change is made to remove the public constructor for the iDB2ParameterCollection class. The parameter collection is always associated with an iDB2Command and should not be created by an application. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- Non-APAR fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.3 (04/02/2004) and the equivalent of 5722JC1 SI13437. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- APAR SE12161: CA400EXP-TERMEMUL-INCORROUT IBM3270-1250 FONTS ARE NOT APAR SE12423: CA400EXP-TERMEMUL-INCORROUT CHARACTERS NOT CHANGED TO UPPERC APAR SE12821: CA400EXP-TERMEMUL-UNPRED PC5250 SESSION DROPPING WHEN USING APAR SE13349: CA400EXP-TERMEMUL-DBCS U/3010(EBCDIC:X/4466) CANNOT DISPLAY APAR SE13430: CA400EXP - TERMEMUL - Add support for LotusScript Extension APAR SE13431: TERMEMUL Signed Numeric won't paste to protected fields Currently if you copy and paste numeric fields they will paste into unprotected and protected fields. But if you copy and paste signed numeric fields, they will not paste into protected fields. This fix is enabled when the existing option, "Force Leading +/-", is ON. APAR SE13658: CA400EXP-TERMEMUL-INCORROUT COPY AND PASTE ISSUE ON JAPANESE APAR SE13859: OSP-PAR RUNTIME ERROR. ABNORMAL PROGRAM TERMINATION. APAR SE13964: CA400EXP-TERMEMUL-INCORROUT DATA IN BLINKING FIELDS DOES NOT APAR SE13971: OSP-PAR USING VBSCRIPT MACROS MULTIPLE TIMES IN PC5250 HANGS APAR SE13991: CA400EXP-TERMEMUL-UNPRED FUNCTION AND ENTER KEYS INTERMITTEN APAR SE15134: CA400EXP-TERMEMUL PrintScreen doesn't work PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE14819: CA400EXP-OPCON-INCORROUT GUI can hang when CPU is busy APAR SE15504: CA400EXP-OPCON-INCORROUT cwbopcon fault during disconnect APAR SE15505: CA400EXP-OPCON-INCORROUT 5250 emulator doesn't connect APAR SE15506: CA400EXP-OPCON-INCORROUT status 'connected' but system down PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- APAR SE15136: CA400EXP-INCORROUT cwbCO_GetPasswordExpireDate The API cwbCO_GetPasswordExpireDate returns CWB_INV_BEFORE_VALIDATE when user profile set to *NOMAX. The documentation for API cwbCO_GetPasswordExpireDate will be updated as follows: CWB_INV_BEFORE_VALIDATE The user ID and password that were set in the specified system object have not been validated (so the password expire date is not available), or validation has occurred and the user profile password expiration interval is set to *NOMAX. Usage You must successfully call cwbCO_VerifyUserIDPassword, cwbCO_Signon, or cwbCO_Connect before calling cwbCO_GetPasswordExpireDate. (Note: CWB_INV_BEFORE_VALIDATE can represent a successful call, if the user profile password is set to never expire (*NOMAX) ) If you want to ensure that the value that is returned is recent, you either must call cwbCO_VerifyUserIDPassword explicitly, or set the Validate Mode to CWBCO_VALIDATE_ALWAYS before you call cwbCO_Signon or cwbCO_Connect. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. 4.0 INSTALL/UNINSTALL CONSIDERATIONS ------------------------------------- The following sections describe additional support and known problems that you may notice while using the Install/Uninstall function. 4.1 REMOVING THE SERVICE PACK ------------------------------ To remove this service pack from your PC (if the service pack was originally installed with the Enable Service Pack Uninstall option): 1. Click the Windows Start button, click on Settings, and then click on Control Panel. 2. Double-click on the Add/Remove Programs icon. 3. Click on the Change or Remove Programs button (if necessary), then find and click on the IBM iSeries Access for Windows SI16496 item, and then click on the Change/Remove button. 4. Follow the instructions on the screen. 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- InstallShield is the tool used to provide the install support for iSeries Access for Windows. The same tool is used for installing service packs. Setup.exe has a 2 minute timeout to initialize to the first wizard panel, which could expire when installing service packs over very slow communication lines. If installing from a CD or a faster connection is not possible, then the service pack could be installed in this manner: 1) A setting exists on the iSeries Access for Windows Properties Service tab that will copy the service pack image to the PC's temporary directory, install the service pack, then remove the copied files. To use this support you will need to specify this setting ("Copy install image to PC before installing"). 2) Run Check Service Level (either from the IBM iSeries Access for Windows Service folder shortcut or when Check Service Level runs at system boot on its defined schedule) STATUS: No status information is displayed while the files are copied. To determine if the transfers are progressing, look in the 'CA400CKV' temporary directory (beneath the PC temporary directory, for example C:\Documents and Settings\username\Local Settings\Temp). You should see new files appear periodically. 3) Proceed through the Service Pack install wizard to complete the install. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator can use the SP.TXT file. If the administrator places a file named SP.TXT (with a 'N' in the first position of the first line) in the service pack installation image directory, the service pack will not be installed. 5.0 DATA TRANSFER CONSIDERATIONS --------------------------------- The following sections describe additional support or known problems that you may notice while using the Data Transfer function. 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 ----------------------------------------------------------- WHY DOES MY DATA LOOK LIKE GARBAGE WHEN I PERFORMED A DOWNLOAD? By default, the Data Transfer function will not convert data between EBCDIC and ASCII if the data is tagged with a CCSID of 65535. In older versions of the Win 95/NT Client Access product, the 65535 conversion was controlled by the CWBTFR.INI file. This process has been changed, and the conversion is now controlled by the Data Transfer user interface. Once the setting has been made in the user interface, it is then stored in the transfer request. This is only true for .TTO and .TFR files. .RTO and .DT files are still controlled by the CWBTFR.INI file. The conversion setting for .RTO and .DT files can be modified in the Data Transfer user interface, but the setting will not be saved. The setting to control the conversion is found in the File, Properties information. WARNING: This feature is designed as a workaround for people that can not change the CCSID of their files. In order for this translation to work properly, you must be confident the data in the file matches the CCSID of your user profile. The design of the iSeries is that data with a 65535 CCSID are not to be converted. This feature will attempt to do a conversion of the data from the job CCSID to the PC CCSID. This conversion may not work if the data in the file does not match the user profile/job CCSID. The correct solution to this problem is to appropriately tag the data with the correct CCSID. One way of doing this is by using CHGPF. For more information on the 65535 CCSID, please reference the iSeries National Language Support Manual.