============================================================================ Readme File for iSeries Access for Windows Service Packs 5722-XE1 V5R4M0 Cumulative Service Pack Level ------------- SI24893 ------------- (c) Copyright IBM Corporation 2006. All rights reserved. ======================================================================== Co-requisite PTF SI24894 is automatically included with any shipment or web download of SI24893. SI24894 exists only for packaging reasons. All service pack level references will be to SI24893. SI24893 can be installed on any PC/server that is at V5R4 service level SI20465 or newer. See iSeries Access for Windows Properties in the IBM iSeries Access for Windows folder to determine current service level. NOTICE: ------- Application of this PTF may disable or render ineffective programs that use system memory addresses not generated by the IBM translator, including programs that circumvent control technology designed to limit interactive capacity to purchased levels. This PTF may be a prerequisite for future PTFs. By applying this PTF you authorize and agree to the foregoing. This PTF is subject to the terms of the license agreement which accompanied, or was contained in, the Program for which you are obtaining the PTF. You are not authorized to install or use the PTF except as part of a Program for which you have a valid Proof of Entitlement. SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT, REGARDING THE PTF. The applicable license agreement may have been provided to you in printed form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR) CL command. ----------------- Table of Contents ----------------- 1.0 INSTALLATION INSTRUCTIONS 1.1 INSTALLING FROM AN iSeries SYSTEM 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE 2.0 RECOMMENDATIONS/RESTRICTIONS 2.1 iSeries SERVER FIXES 2.2 APPLICATION DEVELOPMENT FUNCTION WITHIN iSeries NAVIGATOR 2.3 iSeries NAVIGATOR DATABASES COMPONENT 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS - SERVICE PACK LEVEL = SI24893 (September 2006) 4.0 INSTALL/UNINSTALL CONSIDERATIONS 4.1 REMOVING THE SERVICE PACK 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? 4.3 SERVICE PACK CONTROL 5.0 DATA TRANSFER CONSIDERATIONS 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 --------------------------------------------------------------------- 1.0 INSTALLATION INSTRUCTIONS ------------------------------ 1.1 INSTALLING FROM AN iSeries SYSTEM -------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack through the iSeries PTF ordering process either as an individual PTF order or as part of an OS/400 PTF cumulative package. Once this service pack has been applied to an iSeries system with the LODPTF and APYPTF iSeries commands, it can be installed on individual PC's with the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Check Service Level, controlled by the iSeries Access for Windows Properties Service tab, will detect that the Service source directory has been updated, and will present the user with the option to install the service pack at startup time as well. The APYPTF will update the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) on the iSeries. Any client that installs iSeries Access for Windows (or selected components) from this image will automatically receive this service pack level (no extra steps or reboots). In this scenario, the service pack cannot be uninstalled on the client PC because it is merged in with the base release. Running setupsp.bat from the iSeries Access for Windows install image directory (\QIBM\ProdData\Access\Windows\Install\Image) will launch the service pack install wizard. View setupsp.bat via Notepad or Wordpad to see instructions on how to invoke setupsp.bat to record or run a silent service pack install. RMVPTF will restore your iSeries install image to the prior service level (or the base release if there was no prior service pack applied). 1.2 INSTALLING FROM A LOCAL OR NETWORK DRIVE --------------------------------------------- The following method would be used if you have received the iSeries Access for Windows service pack as a set of install image files via a download from IBM's FTP site. Install the service pack by running the "SETUP.EXE" program from your PC. This program is part of the install image files shipped with a service pack. If you change the iSeries Access for Windows Properties Service tab Source Directory to the directory containing these install image files, you can also use the "Check Service Level" or "Install Service Pack" shortcuts in the iSeries Access for Windows Service folder. Before running this program, copy the service pack install image files to a local drive on your PC or to any accessible network drive. Once the install setup program has completed, you can then remove the install image files from that drive. 1.3 COMBINING THE SERVICE PACK WITH AN iSeries ACCESS FOR WINDOWS INSTALLATION IMAGE ------------------------------------------------------------------------------------- The following method could be used if you downloaded the service pack image from the iSeries Access for Windows web page location: http://www-03.ibm.com/servers/eserver/iseries/access/casp.html The iSeries Access for Windows service pack PTFs are combined with the original iSeries Access for Windows installation image in QIBM\ProdData\Access\Windows\Install\Image NOTE: this directory is a symbolic link to QIBM\ProdData\CA400\Express\Install\Image There is one physical directory - either of these paths will access the directory. This means that a user can install (or upgrade) iSeries Access for Windows from this combined image directory and get the latest applied service level automatically in one integrated step - since the original installation image files have been replaced by updated versions via the service pack PTF. Selectively installing components from this combined image directory will also automatically get the latest applied service level for that component. If you tailored the iSeries Access for Windows install image to another directory (for instance, on another server), using the Create Tailored Installation Image (cwbinimg.bat) tool, you can use the PTFFORM.EXE download in the FTP directory to duplicate the function of applying the iSeries PTF by following these steps: 1. Download PTFFORM.EXE (from the tailored/ FTP directory) to a directory on your PC or server. 2. Run PTFFORM.EXE to automatically expand the service pack image files to a temporary directory. 3. You will then be prompted via a wizard panel to select the iSeries Access for Windows install image directory to update to the new service level. 4. The components that are contained in the target install image will be automatically updated to the new service level from the files in the temporary directory, and then the temporary directory will be removed. 5. After completion, you can delete the downloaded PTFFORM.exe file, as it is no longer needed. Now you have combined this service pack level with the iSeries Access for Windows installation image, so that users can install iSeries Access for Windows plus this service pack in one integrated step. Note that this procedure also works if the installation image has already been combined with a prior service pack level. This procedure will replace the prior service level in the combined image with this new level. Alternatively, if you have a full copy of the original iSeries Access for Windows install image in a directory, you can combine PTFFORM.EXE with this full image, using the same 5-step procedure detailed above. Then you can run Create Tailored Installation Image (cwbinimg.bat) from this full image directory, to create tailored image directories that will automatically have the service pack merged in. 2.0 RECOMMENDATIONS/RESTRICTIONS --------------------------------- 2.1 iSeries SERVER FIXES -------------------------- In addition to installing the iSeries Access for Windows Service Pack, all servers should stay current on the latest Cumulative PTF Package, HIPER Group PTF, and Database Group PTF. Refer to IBM eServer iSeries Technical Support: Recommended fixes at http://www-912.ibm.com/s_dir/slkbase.nsf/recommendedfixes 2.2 Application Development function within iSeries Navigator --------------------------------------------------------------- The Application Development folder within iSeries Navigator is added when the iSeries Navigator Network component is installed. Application Administration can be used to restrict the display of the Application Development folder to certain users or groups of users. 2.3 iSeries NAVIGATOR DATABASES COMPONENT ------------------------------------------ The 'Import Data' and 'Export Data' wizards in iSeries Navigator use the CPYFRMIMPF and CPYTOIMPF CL commands, respectively. The commands may function check with an MCH3402 message when executed by iSeries Navigator. The first time the wizards execute the command it will succeed, but later attempts may fail if the database host server job is reused for a later use of the wizard. The commands may fail with a CPF4248 message with reason code 3 for an ASCII or Unicode CCSID. This is an error in writing data to the error record file (ERRRCDFILE parameter on the CPYFRMIMPF command) if the data file is ASCII or Unicode. Lastly, a problem with system names that contain double quote characters has been identified. Apply the latest PTFs for CPYFRMIMPF and CPYTOIMPF on the server if you plan to use the 'Import Data' and 'Export Data' wizards. PTFs SI20896 and SI17385 for product 5722SS1 V5R3M0 are required. PTFs SI21418 and SI21459 for product 5722SS1 V5R4M0 are recommended. In V5R4M0, SQL Assist has been changed so that 'smart statement selection' can be used to pre-prime the SQL statement at the cursor position into the SQL Assist dialog. In V5R3M0 and earlier, the user had to manually select the SQL statement that SQL Assist would use. The new design is similar to using 'smart statement selection' to execute an SQL statement. However, when 'smart statement selection' is enabled, the user will be unable to position the cursor at an arbitrary place in the script and start with a default SQL statement in SQL Assist. The SQL statement nearest the cursor position will be shown in the SQL Assist dialog. If the user wishes to use SQL Assist to insert a new statement into the script, disable 'smart statement selection' with the 'Options/Smart Statement Selection' menu item. SQL Assist will appear with a default statement, or with the text that was explicitly selected as it would in V5R3M0. APAR SE22766 documents the following scenario that will be addressed in a future release: Run SQL Scripts now reports the return code from a stored procedure for the CALL statement. The return code is specified by an optional RETURN statement in an SQL stored procedure, or by a high level language construct in an external stored procedure. If the user runs a CALL statement to call a stored procedure A that returns a return code, Run SQL Scripts will report the return code. However, if the user runs another CALL to a stored procedure B which does not execute the RETURN statement, Run SQL Scripts will report the previous return code from A as the return code for the latter stored procedure B. The following document conditions that will be fixed in a future release: APAR SE25353: CA400EXP-OPNAV-DBASE-MSGSQL0443 ANALYSIS QUERIES FETCHING The 'Analysis Queries' dialog from 'Analyze...' option for a SQL Performance Monitor or SQL Plan Cache Snapshot may stop displaying results after working with a specific SQL Performance monitor or SQL Plan Cache Snapshot after displaying several reports. This symptom may happen with any detailed report or SQL Plan Cache Snapshot, such as the resulting list from 'Analysis Queries' option on 'Analyze...' for SQL Performance Monitor or SQL Plan Cache Snapshot. Everything in the report may work fine for a while before the user may see the MSGSQL0443 error message and a resulting blank list. Right-click on a SQL Performance Monitor or SQL Plan Cache Snapshot, select 'Analyze...' option on the context menu. It will bring up the Analyze dialog. Select 'Analysis Queries' option from 'Actions' menu. From the resulting list, stepping through the rows, one at time and clicking 'View Results' from 'Actions' menu causes the behavior. You may see the MSGSQL0443 error message, and then if you scroll up or down, the list becomes empty. APAR SE25354: CA400EXP-OPNAV-DBASE OVERSIZED ICON ON VISUAL EXPLAIN Visual Explain shows oversized icons. This may happen if you resize the Visual Explain window as it is being drawn and the 'Graph Detail' option is set to FULL. The following document conditions that are permanent restrictions, however, circumventions do exist: APAR SE25179: CA400EXP-OPNAV-DBASE-MSGMCH0602 VISUAL EXPLAIN Visual Explain fails with 'Boundary alignment of pointer or template not valid' error message. You may see this error when you use iSeries Navigator for V5R4 against a v5r3 or v5r4 system and try to run Visual Explain. This may happen if the QIWS.QQQDBVE2 stored procedure has been created incorrectly. CIRCUMVENTION: Recreate the QIWS.QQQDBVE2 stored procedure using the following steps: 1) In STRSQL, Run SQL Scripts in iSeries Navigator, or any SQL interface, execute the following statement: DROP SPECIFIC PROCEDURE QIWS.QQQDBVE2 2) From iSeries Navigator, go to Databases > DatabaseName > Schemas > QIWS > Procedures and then Delete the QQQDBVE2 procedure. If the QIWS is not listed on schemas, you can add it through 'Select Schemas to Display' option of the context menu of the Schemas folder. 3) iSeries Navigator is responsible for creating this procedure. The next time Visual Explain is used it will recreate the QQQDBVE2 procedure. APAR SE25238: CA400EXP-OPNAV-DBASE-MSGSQL0332 NEW SQL PLAN CACHE SNAPSHOT iSeries Navigator cannot create a SQL Plan Cache Snapshot. A message dialog may display the MSGSQL0332 and a MSGCPD4381 may be displayed in the Job log. If the control files that iSeries Navigator uses to retrieve the list of monitors have different CCSID's, the query will only work if the conversion between both CCSID's are supported. CIRCUMVENTION: The control files QAUGDBPMD and QAUGDBPMD2 are used to get the list of SQL Performance Monitors and SQL Plan Cache Snapshots. The control files may exist in QUSRSYS library if working with the SYSBAS ASP and may be in the QRCYnnnnn library if connecting to an IASP as well. Alter either one or the other control file's columns that are CCSID based so they have the same CCSID in those columns as the other control file. Another work-around is to delete one of the control files, sign-on to iSeries Navigator using a userid with a compatible CCSID and this will recreate the control file using the user's CCSID. 3.0 AUTHORIZED PROGRAM ANALYSIS REPORT (APAR) ABSTRACTS -------------------------------------------------------- This a list of APAR fixes included in this service pack. Each service pack is cumulative; the current service pack includes all the fixes from the prior service pack levels. The APAR abstracts are listed by installable component within a service pack level. --------------------------------- Service Pack Level = SI24893 Build date = September 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE25733: CA400EXP-OPNAV-INCORROUT APPLICATION ADMINISTRATION SIGNON "Application Administration" is prompting for password at start up time of Windows session. This occurs in spite of "Use Windows user name and password, no prompting" option is enabled, and the Windows user matches the "Current administration user" as configured on the "Administration System" of "iSeries Access for Windows Properties". APAR SE25775: CA400EXP - LOB optimization in XDA When using LOBs and doing a FETCH operation in a 3-tier XDA environment, the size of the LOB field is used to determine how much data to send back to the XDA client rather than the actual size of the LOB data fetched. RESOLUTION: XDA now uses the actual length fetched for the LOB data to determine how much data to send back to the XDA client in a 3-tier environment. APAR SE26399: CA400EXP-OPNAV-INCORROUT JOBS FUNCTION UNAVAIL WITH SSL With iSeries Navigator V5R4 connected with SSL, some of the Jobs function under the Basic Operations section will not be listed when looking at Function Availability. RESOLUTION: A key was missing in the registry that allowed the iSeries Navigator Jobs function to be displayed and function in an SSL environment. The service pack install will create this key to fix the missing key problem. In addition, any new install, upgrade install, or reinstall from a merged image containing this service pack will create the key at initial installation time. CIRCUMVENTION: Via careful usage of the Registry Editor, an "SSL" subkey with a key value of "Support Level" and a DWORD value of 2 can be added to the following key to fix this problem: -- HKEY_CLASSES_ROOT\IBM.AS400.Network\3RD PARTY EXTENSIONS\IBM.UserJobs APAR SE26420: CA400EXP-INCORROUT CWBNL0101 FOR CODEPAGE 1386 to 937 A PC is getting a CWBNL0101 when starting the connection from iSeries Access Navigator. The code pages given are 1386 to 937. RESOLUTION: Allows more than 2 step conversions when the source and target code pages are not Unicode. OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE25164: CA400EXP-OPNAV CAN NOT SELECT ANSI/ASCII CCSID ON NETSERVER ASCII/ANSI Code Character Set ID (CCSID) are not selectable in "Browse Code Character Set ID" panel from NetServer Properties. APAR SE25671: CA400EXP-OPNAV Cannot create remote system configuration Attempting to create a new remote system configuration object results in a failure. RESOLUTION: The create new remote system configuration function has been updated to succesfully create the object. CIRCUMVENTION: Select a different service processor configuration object from the list prior to selecting OK on the new remote system configuration object dialog. APAR SE25735: CA400EXP-OPNAV-FILESYS UNABLE TO ADD HOST TO NETGROUP BY IP When attempting to create a Netgroup for NFS, using hosts from the list of known hosts, the error MSGCPFA1CE is displayed. CIRCUMVENTION: When creating the new NFS group specify only the host name, without the IP address, in the "Host or netgroup" field. APAR SE25909: CA400EXP-OPNAV-DBASE MAINTAINED TEMPORARY INDEXES IN ADVISOR With PTF 5722SS1 SI24100, Maintained Temporary Index (MTI) information will be reported by the system-wide index advisor. RESOLUTION: The Index Advisor in iSeries Navigator will report the new MTI information with three new columns: MTI USED, MTI CREATED and MTI LAST USED. These columns will appear even if the PTF is not applied, but will be empty. See http://publib.boulder.ibm.com/infocenter/iseries/ v5r4/index.jsp?topic=/rzajq/rzajqindexadvisor.htm for more information on the MTI columns. APAR SE25910: CA400EXP-OPNAV-DBASE JOB LOG VIEWER HANGS When a user is analyzing an SQL Performance Monitor or SQL Plan Cache Snapshot, they may encounter an SQL Exception. If they press the Job Log button on the SQL Exception message dialog box, the job log viewer may start to display but then hang. RESOLUTION: The Job Log Viewer will not hang and the correct Job Log dialog will be displayed. CIRCUMVENTION: You can avoid this updating the data file of the SQL Plan Cache Snapshot, through a SQL interactive or Run SQL Script or any SQL interface: UPDATE . SET QVP15F = NULL WHERE QQRID = 1000 AND QVP15F = 0; Where is the name of the schema where the data file's name of the Plan Cache Snapshot. APAR SE25911: CA400EXP-OPNAV-DBASE RSS CANCEL REQUEST NOT FREEING RESOURCE When the user runs an SQL statement in the Run SQL Scripts dialog, some threads are created by the Job. If the user wants to cancel the execution through the 'Cancel Request' Tool Bar button or 'Cancel Request' option in Run menu, the threads for the Job are not released. RESOLUTION: iSeries Navigator will release resources when the user requests to cancel the statement that is being executed. APAR SE25934: CA400EXP-OPNAV-INCORROUT SWITCHABLE DEVICES JAVA TRACE A java trace is shown when opening the Switchable Devices container of a cluster, if at least one of the switchable hardware groups of the cluster has no disk pools. CIRCUMVENTION: Use the following CL command to add a disk pool to the switchable hardware groups that do not have disk pools: ADDCRGDEVE CLUSTER(cluster_name) CRG(device_crg_name) CFGOBJ((device_description)) Then try to open the Switchable Devices container again. APAR SE25945: CA400EXP-OPNAV-INCORROUT Unable to restart shared monitors When a user, that is not the owner of a failed monitor, tries to restart it, the option is disabled even though the monitor is shared as controlled. APAR SE26107: CA400EXP-OPNAV-DBASE-INCORROUT MULTI-GLOBAL TRANSACT SUPPORT The 'Result Status' dialog may not display correct information for a Global Transaction. It is possible that more than one Global Transaction had the same Unit of Work ID (UOWID) by having the locked sharing property enabled. The specific transaction should display specific and different information than others which have the same UOWID, however all of them present the same information in the dialog. RESOLUTION: The 'Result Status' dialog will show the specific information of the Global Transaction selected, no matter whether the lock sharing property is enabled or has the same UOWID. APAR SE26172: CA400EXP-OPNAV-DBASE-INCORROUT SHOW INDEXES AND MQTs For a schema with a delimited name, Show Indexes or Show Materialized Query Tables for tables, and Show Indexes for Materialized Query Tables (MQTs) that exist in the schema, may not work. Unexpected output or an SQL error (MSGSQL0204) are the most common results. RESOLUTION: iSeries Navigator will be able to correctly display the Materialized Query Tables and Indexes dialog. This fix requires the following PTFs applied on the iSeries system: R540 SI24513 R530 SI24512 R520 SI24511 APAR SE26232: CA400EXP-OPNAV-DBASE IMPORT DATA WIZARD ALLOWS INVALID INPUT You may see the following problems with the Import data wizard in iSeries Navigator over a Table or Materialized Query Table (MQT): 1) The value 'None' for the Row delimiter field is not compatible with delimited stream files and should appear only when the data file is a fixed format stream file. 2) The Import data wizard allows the user to specify 'Use CCSID of the data file' if the data file has a CCSID of 65535. If the user specifies a hexadecimal value for a delimiter, the wizard will become unresponsive. APAR SE26326: CA400EXP-OPNAV-OUTPUT-INCORROUT PAGES PER COPY DOES NOT SORT The WRKSPLF.EXE does not sort the printer output list when the column to be sorted is numeric. APAR SE26328: CA400EXP-OPNAV-OUTPUT-INCORROUT SHORTCUTS TO PRINTER OUTPUT iSeries Navigator is opened. Navigate to Basic Operations. Right click on Printer Output and create a shortcut. Right click again, and create another shortcut. Then, modify each shortcut to go to a different view. However, whichever shortcut you click on takes you to the last view. In earlier releases, you could have multiple shortcuts, each hardcoded to a different view. APAR SE26339: CA400EXP-OPNAV-INCORROUT ADD SECONDARY DISK POOL FAILS When you try to add a Secondary Disk Pool to an existing Switchable Device CRG, you will get the following message: CPFBB60 - The value 0 specified for the configuration object online attribute is not valid. A configuration object which is not a secondary auxiliary storage pool can have a value of 0 or 1. A secondary auxiliary storage pool can have a value of only 2. Steps to recreate this problem: 1. Open iSeries Navigator and select a Management Central -> Clusters-> ClusterName -> Switchable Devices -> DevCrgName. 2. Right click and select "Add Existing Disk Pool.." . 3. Enter the name of an existing secondary disk pool and click "ok" button. CIRCUMVENTION: Connect to a node of the cluster using a 5250 session and do the following: Enter the command "ADDCRGDEVE CLUSTER(clusterName) CRG(devCrgName) CFGOBJ((aspName *DEVD *PRIMARY))" and press enter. Now the existing Secondary Disk Pool should be added to that device crg. Note: For further help on the commands please refer to iSeries Information Center. APAR SE26342: CA400EXP-OPNAV-DBASE-INCORROUT BLANK LINES PASTING FROM RSS When you copy text from Run SQL Scripts (RSS) window and paste it into other text editors, some blank lines might appear between the pasted text. It can happen when you use the Generate SQL option on some database objects in iSeries Navigator to get the SQL script of the objects selected. APAR SE26346: CA400EXP-OPNAV-DBASE-INCORROUT GLOBAL TRANSACTION PROPERTIES The 'Properties' dialog may not display correct information for a Global Transaction. This problem only happens with Global Transactions that have the same UOWID. The transaction folder is populated and the list is ordered by 'Branch Qualifier' column as default. If you right-click on a transaction that is not the first one displayed, the information in the dialog correspond with the first transaction with the same UOWID listed. After it, the transaction object in the list, is modified in all its columns so it has the same information as the first one listed. RESOLUTION: The 'Properties' dialog will display the correct information of the Global Transaction selected and will keep the transactions list with no changes. APAR SE26430: CA400EXP-OPNAV RUN SQL DEBUGGER NOT DISPLAYING PROPER NLV The Run SQL Scripts Debugger (tes.jar) panels and dialogs always appear in English regardless of the PC locale. It appears that tesMri.jar is missing from the classpath. CIRCUMVENTION: Via regedit, add the path to tesMri.jar to the JavaMRI key value in HKEY_CLASSES_ROOT\IBM.AS400.Network\3RD PARTY EXTENSIONS\IBM.Databases For instance, add: C:\Program Files\IBM\Client Access\jt400\lib\tesMri.jar; APAR SE26540: CA400EXP-OPNAV-DBASE-INCORROUT DESCRIPTOR INDEX NOT VALID The Summary dialog from 'Analyze...' option for a SQL Performance Monitor and SQL Plan Cache Snapshot does not display right results. A 'Descriptor index not valid' error message is displayed. Right-click on a SQL Performance Monitor or a SQL Plan Cache Snapshot, select 'Analyze...' option on the context menu. It will bring up the Analyze tool dialog. Drill down and select the 'Distinct Query Option File' record under 'What options were provided to the optimizer' folder. Press Summary button. From the resulting list, right-click over any listed record and select 'SQL Statements with the Same Statement Text' of the context menu. The error dialog will appear. Other analysis reports may receive the same error. RESOLUTION: An error dialog with the text 'This action is not valid for the current selection.' will appear unless the PTF V5R4 5722SS1 SI24872 is applied in the server. The 'SQL Statements with the Same Statement Text' option of the context menu will not be displayed if this PTF is applied. DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE25348: CA400EXP-DTRANSFER-INCORROUT PASTING DATA AS LINK IN EXCEL When using Data Transfer from iSeries to download a file using BIFF8, BIFF7 or BIFF5 Excel file formats to a local file, and copying as link, the contents, or part of the contents from this file to another Excel file, an error comes up stating the legend "Unable to read file" when updating the pasted data by clicking the "Update" button on Excel. RESOLUTION: This PTF fixes the reported problem. Should there be any files downloaded previously to apply this fix, use the circumvention on each one of them. CIRCUMVENTION: Open the downloaded file and click on the save button, close it and then open it again. APAR SE25421: CA400EXP-DTRANSFER-INCORROUT WRONG COLUMN SORTING IN DISPLAY When downloading a table to the Display output device in the Data Transfer From program, the output window is supposed to let the user sort the records by clicking on the column heading. Sorting character columns doesn't work at all and numeric colums are not sorted correctly. APAR SE26348: CA400EXP-DTRANSFER CREATE HOST FILE WITH EMPTY COLUMNS FAILS When uploading a file containing several empty columns, using the "Data Transfer to" program, and selecting the "Create iSeries database file" wizard, this does not work and user will not be able to navigate from the dialog where the host file is being created as "Next" button does not work. RESOLUTION: This PTF fixes the reported problem, however, when the data file contains empty columns, by design considerations, these will not be included in the File Description File, so, when using the "Data Transfer to" program, to create the host file, there might be a mismatch between the File Description File and the created host file. To avoid this situation, user needs to include each empty column in the File Description File, by selecting each empty column in this dialog and clicking the Details button, and checking the "Include in file description file" checkbox. DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE26329: CA400EXP-DTRANSFER EXCEL ADD-IN HANGS AFTER DOWLOADING FILE Excel stops responding after downloading any table from the host by using the Data Transfer Add-in. This behavior occurs due to a conflict between a Data Transfer dialog box and an Excel dialog box. The Excel dialog is titled "Installing COM Component" and it is displayed as a result of an unusual combination of settings in Excel. RESOLUTION: In addition, some changes to the registry need to be applied as described in the following Microsoft website: http://support.microsoft.com/kb/323207 The article talks about Internet Explorer, but Microsoft Excel appears to also be affected by this registry issue. Consult with IBM Service if you have questions or concerns about modifying the registry. ODBC ---- APAR SE25951: CA400EXP-ODBC-INCORROUT - SQLTABLES PROBLEM WITH MQT When calling SQLTables and passing a table type of "MATERIALIZED QUERY TABLE", the driver is incorrectly reporting an error. MQTs were introduced on V5R3 systems and ODBC should ignore the "MATERIALIZED QUERY TABLE" table type on systems that don't support them. The driver should also not report "MATERIALIZED QUERY TABLE" as a valid table type on pre-V5R3 systems. APAR SE26128: CA400EXP-ODBC-INCORROUT PCBVALUE NOT SET FOR RETURN CODE A stored procedure with a return code is called through ODBC and the return code, an integer value, is assigned to a parameter marker. After the stored procedure is executed, the returncode value is returned correctly but the length of that value, which should be 4 byte for an integer, is not set by the iSeries Access ODBC driver. This variable is usually referred to as the pcbValue or StrLen_or_IndPtr. This problem is specific to the return code parameter and does not occur with handling of other parameters. The SQL statement being used for this problem begins with the ?=CALL syntax. APAR SE26325: CA400EXP-ODBC-MSGERROR IN HOST SERVER DATASTREAM MSACCESS 97 MS Access 97 can get the following error when executing SQL using the iSeries Access for Windows ODBC provider: err: IBM iSeries Access ODBC Driver Error in host server data stream. The ODBC provider is incorrectly requesting Parameter Marker Format when no parameter markers have been used. OLE DB PROVIDER --------------- APAR SE25382: CA400EXP-OLEDB-MSGSQL0104 When update recordset using system naming A problem was discovered on the iSeries Access for Windows OLE DB provider when using system naming and attempting to update a recordset of an unqualified table name with no default collection set. The update statement that the provider builds results in an sql0104 error for the invalid '/' token. APAR SE25454: CA400EXP-OLEDB-UNPRED WHEN IN PARM IS DEFINED AS IN/OUT An access violation occurs in the OLE DB provider when an input parameter is defined as input/output using a command object to execute a SQL statement. CIRCUMVENTION: Declare the parameter as input instead of input/output, or better yet just not declare it at all and let our provider produce the correct parameter from the prepare. APAR SE25755: CA400EXP-OLEDB BLANK PROPERTY IN EXTENDED PROPERTIES FAILS If the value of a property in the extended properties is blank or empty, the OLEDB driver fails and the connection is not made. A CWBZZTRC trace shows the following: Property not set, unsupported property value specified for Extended Properties (000000A0). .NET DATA PROVIDER ------------------ APAR SE25710: CA400EXP-IDB2DATA Read & Write LOB data in chunks more often When the .NET Provider reads and writes Large Object (LOB) data, and LOB Locators are being used (ref. the MaximumInlineLobSize property), the provider reads the entire LOB in one large read or write operation, unless the application uses the iDB2DataReader.GetBytes() or GetChars() method. This can be a problem when the iSeries host is not able to process this much data at once. This could result in a dropped connection or other problems. A solution is needed to help alleviate this problem. RESOLUTION: This PTF adds a new ConnectionString property called LobBlockSize. This value specifies the number of megabytes (MB) of data the provider will read or write at one time, when using LOB locators. The default value is 512 (0.5 GB). The valid range for LobBlockSize is from 1-1024 (1MB - 1GB). The LobBlockSize is not used with the iDB2DataReader.GetBytes() and GetChars() methods, because with those methods, the application specifies the number of bytes or characters of data to read at one time. LobBlockSize is ignored when reading character LOB data (CLOB), when the host ccsid is either a mixed-ccsid, or UTF-8. In that case, the provider reads the entire CLOB in one operation. LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.1.1 (05/17/2006) and the equivalent of PTF 5722JC1 SI23572. Also includes the equivalent of PTF 5722JC1 SI24544: APAR SE26135: CA400EXP-OPNAV-INCORROUT COMMAND PROMPTER INVALID PWD LENGTH When prompting CRTUSRPRF command using Command Prompter allows user to enter a 128 characters password when the iSeries is on password level 0 or 1. The maximum password length allowed in level 0 and 1 is 10. RESOLUTION: Additional length validation was added to User Password parameter when prompting CRTUSRPRF command to consider the QPWDLVL system value. 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20060806 APAR SE24106: CA400EXP-OPCON-HOST PRINT FAILS WITH MSGMCH0601 OR MSGCPF519 When execute host print from Operation Console session, it fails with msgMCH0601 or msgCPF5192. The error occurred since applied SP SI16496 but this issue reminded on SI21917 environment. APAR SE25092: CA400EXP-TERMEMUL-INCORROUT PC5250 WINDOW DISAPPEARS WHEN PC5250 window disappears when accessing macros. PC was configured with the command CWBCFG /pc5250path *MYDOCUMENTS, and the My Documents folder was redirected to a UNC name of a network drive. CIRCUMVENTION: Use a mapped network drive (drive letter notation) rather than a UNC name. APAR SE25262: CA400EXP-PRINTEMUL-INCORROUT PRINT SAME SPOOLED FILE TWICE I Create a PC5250 printer session. Do not specify to use host print transform or a PDT. Specify the driver for a PCL laser printer. Under File/Page setup..., turn off automatic orientation, and select Portrait for both drawers. On the iSeries, generate a simple text spooled file, perhaps a one page joblog. Change the spooled file to save after printing. Print it on the PC5250 session. Then, release the saved file to print again. The second time, the print will be smaller. APAR SE25697: CA400EXP-COMM-UNPRED PC5250 HANGS AFTER HITTING RESET KEY PC5250 hangs after hitting reset key APAR SE26108: CA400EXP-OUTPUT-INCORROUT DISPLAY FIELDS ARE NOT PRESENTING Intermittently display fields that should be blinking and red are not displaying correctly. APAR SE26139: CA400EXP-TERMEMUL-INCORROUT IN A CL PGM THE COMMAND STRPCCMD The command STRPCCMD PCCMD('PAUSE') PAUSE(*NO) is used in a CL PGM. During executing the Pause command (or any long running PC program) the PC5250 isn't input inhibit. The CL pgm will not wait till the PC command finishes. SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ APAR SE25533: CA400EXP-OUTPUT-INCORROUT V5R4 FAXING PC DOCUMENTS The cover page created by the IBM AFP Facsimile/400 printer driver contains invalid characters. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE25845: CA400EXP-OPCON-INCORROUT cpanel src changes not displayed A LAN control panel may not automatically display new SRCs. RESOLUTION: With this change, the LAN control panel automatically updates when new SRCs are available. CIRCUMVENTION: Clicking on the control panel's mode button will cause the control panel SRC display to refresh. The current list of SRCs can be obtained by clicking on the plus sign before the configuration name in the Operations Console GUI, right-clicking on the Control Panel line, and choosing one of the options to view the SRCs. 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 = SI23696 Build date = May 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE24562: CA400EXP-OPNAV HANDLE LEAK IN APPLICATION ADMINISTRATION APAR SE24598: CA400EXP-OPNAV-INCORROUT extended attributes trap in IFS APAR SE24713: CA400EXP-INSTALL-INCORROUT INSTALL SAME SERVICEPACK TWICE APAR SE24726: CA400EXP-ODBC-INCORROUT SQL BIG-ENDIAN UTF16 WITH 'XXFF' APAR SE25099: CA400EXP-COMM-MSGCWBSY1040 Windows credentials not found APAR SE25422: CA400EXP-TERMEMUL NO PC5250 SOUNDS AFTER V5R4 INSTALL OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE24032: CA400EXP-OPNAV-DBASE-INCORROUT INDEX ADVISOR EMPTY WITH IASP APAR SE24173: CA400EXP-OPNAV-MSGCWBNL0107 EDIT TABLE CONTENTS DBCS BLANKS APAR SE24176: CA400EXP-OPNAV-DBASE-INCORROUT ACCESS PLAN REBUILD COUNT APAR SE24257: OSP-DB-MSGCPFA0A2 ACCESSING PERMISSIONS FROM ISERIES NAVIGAT APAR SE24550: CA400EXP-OPNAV-DBASE-INCORROUT REORGANIZE TABLE INFORMATION APAR SE24551: CA400EXP-OPNAV-MSGCPD8ED5-MSGCPF2718 When adding VE to NWSD APAR SE24625: CA400EXP-OPNAV- Export LPAR configuration to IFS fails APAR SE24642: CA400EXP- Disks on 5787 expansion unit are not displayed APAR SE24710: CA400EXP-OPNAV-INCORROUT History Log msgs of < 5 chars gone APAR SE24711: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY APAR SE24873: CA400EXP-OUTPUT-INCORROUT WHEN EXPORT MONITOR DATA FROM INAV APAR SE24882: CA400EXP-OPNAV-JOBS-INCORROUT CURRENT SQL STATEMENT STATUS APAR SE24894: CA400EXP-OPNAV-NETWORK-MSGDATA DATA ENTRY ERROR MESSAGE APAR SE25008: CA400EXP-OPNAV-DBASE EXPLAIN SQL FROM VISUAL EXPLAIN APAR SE25012: CA400EXP-OPNAV-DBASE PREFERENCES IN RUN SQL SCRIPTS ARE LOST APAR SE25014: CA400EXP-OPNAV-DBASE-INCORROUT TIMESTAMP ON SHOW INDEXES APAR SE25050: CA400EXP-OPNAV-NETWORK-INCORROUT IPv6 GUI problems APAR SE25054: CA400EXP-OPNAV Error setting spooled file expiration date APAR SE25068: CA400EXP-OPNAV-DBASE-INCORROUT INVALID COLUMN ID ON INDEXES APAR SE25104: CA400EXP-OPNAV-DBASE SHOW STATEMENTS DIALOG DIMENSION APAR SE25107: CA400EXP-OPNAV Error code 7 on mirror synchronization on IPL APAR SE25123: CA400EXP-OPNAV Unable to add nodes to administrative domain APAR SE25124: CA400EXP-OPNAV CHANGES TO ADMIN DOMAIN NOT PRESERVED APAR SE25125: CA400EXP-OPNAV-INCORROUT Cannot stop cluster APAR SE25235: CA400EXP-OPNAV User name/password not correct on initialize APAR SE25236: CA400EXP-OPNAV Upper case CHAP name shown in mixed case APAR SE25298: CA400EXP-OPNAV LOAD IMAGE CATALOG PANEL APAR SE25299: CA400EXP-OPNAV-DBASE-INCORROUT SHOW STATEMENTS SORT COLUMNS DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE24961: CA400EXP-DTRANSFER USERID NOT SAVED CORRECTLY IN DTT FILE APAR SE25102: CA400EXP-DTRANSFER UNEXPECTED ERROR IN EXCEL WIZARD DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE24170: CA400EXP-DTRANSFER USERID TRUNCATION IN EXCEL ADD-IN ODBC ---- APAR SE00013: CA400EXP-ODBC FETCH PROBLEMS WITH SQL_ATTR_ROW_ARRAY_SIZE APAR SE24285: CA400EXP-ODBC-INCORROUT CAN NOT REGISTER ODBC TRANSLATION OP APAR SE24755: CA400EXP-ODBC DRIVER CRASH WITH LARGE SQL_C_DOUBLE VALUES OLE DB PROVIDER --------------- APAR SE24629: CA400EXP-OLEDB-MSGSQL0104 Problems with long database names .NET DATA PROVIDER ------------------ APAR SE24436: CA400EXP-IDB2DATA-INCORROUT CLOB LENGTH SET INCORRECTLY WITH APAR SE24985: CA400EXP-IDB2DATA-INCORROUT NullReferenceException in GetDcRow LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- APAR SE25325: CA400EXP-AFPVIEWER VERSION 2.02.01.01 TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.0 (12/16/2005) and the equivalent of PTF 5722JC1 SI20169. Also includes the equivalent of PTF 5722JC1 SI23220: APAR SE24779: CA400EXP-OPNAV-INCORROUT Prompting problem with CALLPRC 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20060324 APAR SE22922: CA400EXP-TERMEMUL-INCORROUT CURSOR DOESN'T MOVE TO THE FIRST APAR SE23600: CA400EXP-TERMEMUL-INCORROUT EVENT NOTIFICATION NOT WORKING APAR SE23782: CA400EXP-TERMEMUL-INCORROUT HACL NOTIFYKEYEVENT APAR SE24597: CA400EXP-TERMEMUL-INCORROUT STRPCCMD FAILS WITH BATCH FILES APAR SE24958: CA400EXP-PRINTEMUL-INCORROUT EXTRA SPACE CHARACTER INVALIDAT APAR SE25088: CA400EXP-TERMEMUL-INCORROUT Keyword support for color settings on 5250 The emulator screen color should come in 2 choices: the traditional green screen or black text on white background. RESOLUTION: We will provide the keyword ScreenColor in both pcswin.ini and .ws files for specifying the color mode. For pcswin.ini, ScreenColor should be placed in the [Session] section. For a .ws file, ScreenColor should be placed in the [Colors] section. There will be four color key values: 1. UseDefault - Default green text on black background (Multi-color mode). 2. WhiteBoard - Black text on white background. 3. BlackBoard - White text on black background. 4. SystemDefault - Take foreground & background colors specified for 'Window' Item on Display Properties or Advanced Appearance dialog ('Control Panel -> Display -> Appearance tab -> Advanced button for Windows XP). The value specified in the .ws profile will take precedence over the pcswin.ini value. This way, Administrators can specify an alternative default color mode in pcswin.ini (system-wide color mode setting). So when the user configures a new session, admin-specified alternative default value will be picked up. If the user wishes to override admin-specified alternative default value then, they can specify it in the .ws. This would be per session. If nothing is specified in either pcswin.ini or in the .ws, the default display text will be traditional green screen (multi-color mode). Example for pcswin.ini: [Session] ScreenColor=WhiteBoard Example for a .ws file: [Colors] ScreenColor=SystemDefault CIRCUMVENTION: The colors can be changed/personalized on the menu Edit->Preferences->Appearance->Color Mapping. The color changes will be saved into the .ws if the current session is saved. Also, the color key value will be set to UseDefault (multi-color mode) in the saved .ws file by the application. APAR SE25221: CA400EXP-TERMEMUL-INCORROUT Not using iNav default SSL port The communications port on a PC5250 emulation session created by iSeries Navigator should automatically change to match any subsequent port change in the iSeries Navigator connection. This way, when the user chooses to connect with iSeries Navigator using SSL (Port 992), the port should be automatically changed on the PC5250 emulation session to the iSeries Navigator defined port rather than having the user enter the configuration for that emulation session and change the port manually, since by default it is always port 23. RESOLUTION: If the host port number is defaulted (i.e. no port specified in .ws file), and if SSL Security is enabled, then the user can specify a port number to be used by doing the following: 1) Edit the services file in the Windows System drivers directory. For example, edit: C:\WINDOWS\system32\drivers\etc\services 2) At the end of this services file, add a new service name and port. The text line should be: telnet-ssl-pcomm 992/tcp 3) Save the services file 4) Start Pc5250 again via Display Emulator in iSeries Navigator Pc5250 will now look up the port number 992 in the services file, and connect using that port over SSL. APAR SE25222: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window size In V5R3,PC5250 when the Poppad (Pop-up Keypad) size is decreased below a certain width/height, the horizontal and vertical scroll bars are displayed while the button size inside the poppad remains constant. As a result, the number of visible buttons decreases as the size of the poppad window is decreased. When there is a lot of buttons mapped to macros, scroll bars are used to browse and display all the buttons, making it more difficult for the user to find the button needed. RESOLUTION: The PC5250 macro poppad needs to have all of the buttons visible at all times without scroll bars on the window. In V5R2 PC5250, all buttons are resized so they fit into the poppad. For V5R3 and V5R4 to operate without scrollbars on the poppad, add the following keyword to the workstation file (.ws) under the [Poppad] section: ShowScrollBars=FALSE The default value for ShowScrollBars is TRUE, which will show scrollbars on the poppad. APAR SE25223: CA400EXP-TERMEMUL-INCORROUT PC5250 Macro poppad window focus On V5R2,PC5250 the user would work on the active principal window (focused) having the macro poppad window posted in a permanent way but out of focus. The user would select a macro from the poppad while the principal window would remain active (focused), this way the user could keep on working on the principal window. With V5R3 PC5250, when the user clicks on a macro inside the poppad window, the principal window would lose the focus and then pass it on to the poppad, thus the user has to click on the principal window to make it active again. In other words, on V5R2 PC5250, the poppad window never became active unless the user clicked inside it on a zone that is not a macro button. RESOLUTION: The PC5250 macro poppad window will stay focused by default, when a user clicks on a macro within a poppad window. For V5R3 and V5R4 to operate similar to V5R2 where the principal window retains focus even when the user clicks on a macro within the poppad window, add the following keyword to the workstation file (.ws) under the [Poppad] section: Focus2PS=TRUE The default value for Focus2PS is FALSE, which will bring the focus to the poppad window when the user clicks on a macro within the poppad. APAR SE25224: CA400EXP-TERMEMUL-INCORROUT Collect and Print PC5250 jobs The printing options do not have a feature to send many print jobs to a single job for storage/distribution or printing. RESOLUTION: To enable PC5250 to collect many print jobs and print them as a single job, three new functions will be added: 1. Switching to Collect Mode. All host print jobs will be saved in a file instead of sent to physical printer. 2. Printing all the collected jobs. All host print jobs saved in the file will be sent to physical printer. 3. Purge collected jobs. The file containing all the print jobs will be deleted. The user can create keyboard shortcuts for these functions using the keyboard re-map utility and also add them as an item in the Toolbar. By default the Collect mode will create the .scs file in the user profile directory by the convention MACHINE NAME_USER_TIME_WS THREADID_DATE_TIME.SCS. -- If the user wants to change the file name, he can use the keyword:SCSFile=.scs in the [printers] section of the ws profile of the printer session. -- If the user wants to change the directory, he can use the keyword:SCSPath= in the [printers] section of the ws profile of the printer session. -- Also there will be an option of printing all the jobs as individual jobs. i.e., if user wishes to, save all the host sent jobs, send them to physical printer without combining all as a single job, but as separate jobs with the advantage of user going to the physical printer only once for collecting printouts. This will be enabled using a .WS keyword "CombineJobs=N" under the [printers] section. This enhancement is available for English National Language Versions (NLVs) only. This includes: -- English (2924) -- English Uppercase DBCS (2938) -- English Mixed Case DBCS (2984) In addition, to enable this function fully, pcsmgres.dll must be downloaded from this site: For V5R3: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r3m0/files/pc5250/standard/se25224 For V5R4: ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r3m0/files/pc5250/standard/se25224 The above addresses should all be on one line for your browser URL. Please consult the readme located in the FTP directory for install instructions. SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE24807: CA400EXP-OPCON-INCORROUT File access failure causes fault APAR SE24809: CA400EXP-OPCON-INCORROUT Control Panel close may fault APAR SE24811: CA400EXP-OPCON-INCORROUT Apply button causes bootp failure APAR SE25097: CA400EXP-OPCON-INCORROUT Device id out of sync APAR SE25176: CA400EXP-OPCON-INCORROUT gui hang during close APAR SE25177: CA400EXP-OPCON-INCORROUT cwbopcon.exe ends APAR SE25424: CA400EXP-OPCON-INCORROUT UNUSABLE GERMAN CONFIG PANEL PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI22257 Build date = February 2006 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE23024: CA400EXP-ODBC-INCORROUT UTF8 to ME Linux PWS0006 APAR SE23309: CA400EXP - Update the extended user defined field support in XDA APAR SE24325: CA400EXP-TERMEMUL-INCORROUT PRINTER ASSOCIATION CHECKBOX OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE22769: CA400EXP-OPNAV-DBASE-PERFM SPECIFY QAQQINI FILE FOR ANALYZE The 'Analyze' and 'Compare' functions for large SQL Performance Monitors or SQL Plan Cache Snaphots may take a long time to display the results. The time required to run the analysis can be improved by increasing the parallel processing degree that the analysis queries may use. The CHGQRYA CL command and/or a query options file (QAQQINI) and the SET CURRENT DEGREE SQL statement and the QQRYDEGREE system value influence the parallel processing degree. The user cannot use any of these methods effectively to modify the parallel degree used by the analysis queries. The user may right-click the 'SQL Performance Monitors' or 'SQL Plan Cache Snapshots' folder and select the 'Preferences/Settings for Analysis' menu item. A dialog will appear so that the user can specify a schema for the query options file (QAQQINI). The user can then specify the query options file which contains the parallel processing degree option they wish to use. The query options file refers to the parallel processing degree option with the name 'PARALLEL_DEGREE'. The options will be in effect for iSeries Navigator's analysis and comparison queries for both performance monitors and plan cache snapshots. The query options file is in effect only for the named-database that contains the 'SQL Performance Monitors' and 'SQL Plan Cache Snapshots' folder. In other words, the query options file is in effect only for the analysis queries that use a certain database connection in iSeries Navigator. The user must have job control authority (*JOBCTL) and *USE authority to the CHGQRYA command, or the query options file will be ignored. A query options file may be created in iSeries Navigator by right-clicking a named-database and selecting 'Change Query Attributes'. Select the schema where the file exists, or should be created. Press the 'Edit Options' button to create and/or edit the file. APAR SE22770: CA400EXP-OPNAV-DBASE-INCORROUT SORTING PERFMON AND SNAPSHOT APAR SE22936: CA400EXP-OUTPUT-INCORROUT Precache causes cwbundbs.exe hang APAR SE23087: CA400EXP-OPNAV-MSGCPF2422 Wrong reply with message monitor APAR SE23239: CA400EXP- IFS GUI crashes when getting usage of directories APAR SE23263: CA400EXP-OPNAV Disk Management Miscellaneous problems APAR SE23288: CA400EXP-OPNAV HISTORY LOG DBCS PARSING APAR SE23295: CA400EXP - Problems in DM GUI when TCP/IP is down APAR SE23296: CA400EXP-OPNAV-DBASE STRING INDEX OUT OF RANGE: -1 WILDCARD APAR SE23312: CA400EXP-OPNAV-INCORROUT Unable to change Model System APAR SE23332: CA400EXP-OPNAV-INCORROUT MRE STACK TRACE ERROR APAR SE23401: CA400EXP-OPNAV-NETWORK Missing Virtual Ethernet Ifc Support APAR SE23447: TCPIP-MSGCPF3CF1 CREATING THE PPP PROFILE FAILS WITH CPF3CF1 APAR SE23507: CA400EXP-OPNAV-DBASE-MSGSQL0443-MSGCPF3224 INDEX ANALYZER Right click a table object and select 'Indexes'. Error MSGSQL0443 may appear in the Index Analyzer if the signed on user does not have authority to the table. The error message may be presented in a number of ways: 1) An error occured while attempting to initialize the list. [SQL0443] UNKNOWN 2) An error occured while attempting to initialize the list. [SQL0443] NOT FOUND 3) SQL State: FFFFF Vendor Code: -443 Message: [SQL0443] UKNOWN ERROR In addition, the job log will contain MSGSQL0443, MSGCPF3224 and MSGMCH1001. iSeries Navigator will display an appropriate authority message when connected to a server at release V5R4M0 or higher with the following server PTFs applied: 5722SS1 V5R4M0 SI20953 5722SS1 V5R4M0 SI19453 MSGSQL0443, MSGCPF3224 and MSGMCH1001 will no longer appear in the job log. iSeries Navigator will display "[SQL0443] UKNOWN ERROR" when connected to a server at V5R3M0 or V5R2M0. Also, MSGSQL0443, MSGCPF3224 and MSGMCH1001 will no longer appear in the job log when the following server PTFs are applied: 5722SS1 V5R3M0 SI19457 5722SS1 V5R2M0 SI19600 APAR SE23618: CA400EXP - Slot D03 on 0595 Tower is not displayed APAR SE23657: CA400EXP-OPNAV DDM SERVER PROPERTIES ON JAPANESE DBCS APAR SE23809: CA400EXP-OPNAV-DBASE-PERFM RSS NO BLOCKS RECS ON CALL PARAMS APAR SE23824: CA400EXP-OPNAV-INCORROUT HISTORY LOG MESSAGE PROPERTIES APAR SE23825: CA400EXP-OPNAV-DBASE-UNPRED EXPLAIN SQL FROM VE EMPTY ERROR APAR SE23835: CA400EXP-OPNAV-DBASE PER MON QUERY JAPANESE COMPATIBILITY APAR SE23837: CA400EXP-OPNAV-DBASE-INCORROUT INDEX FUNCTIONS APAR SE23840: CA400EXP-OPNAV-DBASE-INCORROUT NATIONAL LANGUAGE SUPPORT APAR SE23846: CA400EXP-OPNAV-DBASE-INCORROUT IMPORTING FIXED FORMAT DATA APAR SE23847: CA400EXP-OPNAV-DBASE-INCORROUT SQL PERFORMANCE FUNCTIONS APAR SE23864: CA400EXP-OPNAV DUPLICATE TAPE USES WRONG FROMVOL APAR SE23941: CA400EXP-OPNAV-NETWORK RAS Profile connections may fail APAR SE23946: CA400EXP-OPNAV-NETWORK UCW fixes for ECC support APAR SE23965: CA400EXP-OPNAV-NETWORK AC3 not required for V5R4 VPN server DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE22760: CA400EXP-DTRANSFER - Vertical aligment incorrect for HTML APAR SE23381: CA400EXP-DTRANSFER-INCORROUT DATA TRANSFER TO PRINTER APAR SE23668: CA400EXP-DTRANSFER Customized sheet names for Excel files User's application requires Microsoft Excel sheet names to be sheet1, sheet2, etc. but iSeries Access uses the file name as sheet names. This PTF fixes the reported problem. Considerations: - By activating this feature it's possible to customize the name of the sheets of Excel files generated through the Data Transfer From GUI ONLY. - This feature is available ONLY for biff5, biff7 and biff8 formats. - Customized names can ONLY be ANSI strings. UNICODE strings are NOT SUPPORTED. This feature is activated through an INI file (plain text) named CWBTFR.INI. It must reside in the Windows directory (which may be c:\windows, c:\winnt, etc., depending on how and what version of Windows is installed) and it must contain a section like this: [Client Access Data Transfer] BaseSheetName=custname where custname can be any string of up to 10 VALID CHARACTERS. Create the file if it doesn't exist or just add the above section if it already exists. NOTE: Characters such as \,/,?,[,] or * are not allowed. This is an Excel restriction. APAR SE24030: CA400EXP-DTRANSFER A CRASH OCCURS WHEN BROWSE FOR LIBRARIES APAR SE24081: CA400EXP-DTRANSFER INCORRECT CELL TEXT ALIGNMENT IN HTML DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE23267: CA400EXP-DTRANSFER-WAIT DATA TRANSFER EXCEL ADD-IN HANGS ODBC ---- APAR SE22732: CA400EXP-ODBC-PERFM RESULTS SETS ARE RETURNED WITH BLOCKING Currently, when using a Sensitive cursor type in an iSeries Access ODBC application, results sets will be returned with blocking of one row. This can negatively impact performance. This change will allow the iSeries Access ODBC provider to do block fetches of data when the SQL_ATTR_CONCURRENCY attribute is set to SQL_CONCUR_LOCK and the Database host server indicates that the cursor is Read-only. APAR SE22932: CA400EXP-ODBC Support loosely-coupled XA transactions The ODBC driver currently supports loosely coupled XA/MTS transactions, but does not have the ability to share locks across the loosely coupled transaction branches. An enhancement is needed to provide in this support. New keywords and a new connection attribute will be added to control the locking with loosely coupled distributed transaction branches. Note, this support requires a V5R4 iSeries. The new keywords can be set in the ODBC DSN using the cwbodbcreg.exe tool or passed in on the SQLDriverConnect connection string. The new keywords are: XALCS or XALooselyCoupledSupport Setting this keyword affects whether locks are shared between loosely coupled distributed transaction branches. Possible Values: 0 = Locks are not shared 1 = Locks are shared Default Value: 1 Alternatively, you can activate this new support by calling the SQLSetConnectAttr API and setting the 2144 attribute. The 2144 attribute expects that an unsigned integer value be passed in. Setting this to 0 indicates to not share locks. Setting this to 1 will share locks. The default behavior is 1 which is to share locks. APAR SE23227: CA400EXP-ODBC-INCORROUT POUND STERLING SYMBOL IN ODBC DS APAR SE23930: CA400EXP-ODBC-INCORROUT Improved Delimited Names Support The ODBC driver is not consistent with how it returns delimited identifier names back to the application. An example of a delimited identifier name is "MyTable" where "MyTable" is the name of a table on an iSeries. Some applications, such as Microsoft Excel, generate SQL statements based off the identifiers the driver returns. These applications build invalid SQL statements if the driver does not return the names in a particular way. To make these applications work better and to be more consistent, an enhancement is being provided. A new keyword is being added that will give the application the ability to affect how delimited identifier names are returned to it. Keyword: DelimitNames Description: This keyword controls how the driver will return delimited identifier names back to the application. This setting affects the following catalog APIs: SQLTables, SQLColumns, SQLSpecialColumns, SQLPrimaryKeys, SQLForeignKeys, SQLSpecialColumns, and SQLStatistics. It also affects how the driver returns identifiers for the SQLColAttribute, SQLDescribeCol, and SQLGetDescField APIs. If set to 1, the driver would return a table name of "MyTable" as "MyTable" instead of as MyTable. Values: 0 = Return undelimited identifier names to the application 1 = Return delimited names to the application Default Value: 0 Notes: - To set this keyword you can specify "DelimitNames=1;" in the SQLDriverConnect connection string. If you can not modify the application, you can use the cwbodbcreg.exe tool found on your machine in the \Program Files\IBM\Client Access directory. To use cwbodbcreg.exe, open a DOS command prompt, navigate to the \Program Files\IBM\Client Access directory, and then run the following (replacing MYDSN with the ODBC DSN you want to update): cwbodbcreg MYDSN DelimitNames 1 - When working with MS Excel you will need to set the DelimitNames keyword to 1 if you have identifiers that are delimited. OLE DB PROVIDER --------------- No fixes. .NET DATA PROVIDER ------------------ APAR SE22266: CA400EXP-IDB2DATA Item has already been added to collection APAR SE22506: CA400EXP-IDB2DATA .NET Provider with .NET Framework 2.0 When using the IBM.Data.DB2.iSeries .NET provider with .NET Framework 2.0, an ObjectDisposedException occurs when the application terminates, with a message indicating "Safe handle has been closed." This problem occurs because of an incompatible change made in the .NET Framework. This PTF fixes the reported problem. Note that this is not an official support statement for .NET Framework 2.0. Future compatability with .NET Framework 2.0 is not guaranteed. APAR SE23880: CA400EXP-IDB2DATA-MSGCPD0005 Trace - wrong decimal separator APAR SE24056: CA400EXP-IDB2DATA Server trace fails with system naming LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 5.0 (12/16/2005). 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20051220 APAR SE23207: CA400EXP-TERMEMUL-INCORROUT SPECIFIC CHARACTERS GET GARBAGE APAR SE23367: CA400EXP-TERMEMUL-UNPRED LONG NAME MACRO IN .PMP APAR SE23503: CA400EXP-TERMEMUL-INCORROUT DBCS PASTE ADDS SBCS BLANK SECURE SOCKETS LAYER (SSL) -------------------------- No fixes. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE23862: CA400EXP-OPCON-INCORROUT CWBOPAOC.EXE FAULT CONNECTING LAN PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. --------------------------------- Service Pack Level = SI20465 Build date = October 2005 --------------------------------- REQUIRED PROGRAMS ----------------- APAR SE21177: CA400EXP-INCORROUT cwbback.exe faults on some PCs APAR SE21440: CA400EXP-ODBC-INCORROUT INSERT OR UPDATE FROM PC UNICODE TO APAR SE21823: CA400EXP-INSTALL-INCORROUT AFP VIEWER ON 64BIT APAR SE22152: CA400EXP-RMTCMD RMTCMDS WHICH PREVIOUSLY RETURNED ERROR LEVE RMTCMD was updated to take advantage of a new message level on the host side (x'02' - return all messages). The return all messages option also returns messages from both the server and program message queues, whereas previous host levels and message levels only returned information from the server queue. This additional message source (program queue) can cause a previously working RMTCMD to return an error level higher than 00. This can cause some client applications to abnormally end. The remote command (RMTCMD.EXE) and remote program interfaces (CWBRC.H) have been changed to allow a more complete list of job messages to be returned. For RMTCMD.EXE, this might cause a different exit ERRORLEVEL to be returned depending on the severity of any newly included job messages. To enable the old behavior for a given PC process, set up an environment variable called CWB_RMTCMD_V5R2_MSG=*ALL or a process name. For example: CWB_RMTCMD_V5R2_MSG=rmtcmd.exe will enable the old behavior for rmtcmd.exe. *ALL would enable the old behavior for all processes within this environment variable scope. CIRCUMVENTION: Job messages can be removed from the returned list by calling RCVMSG MSGTYPE(*EXCP) RMV(*YES) during normal MONMSG processing routines. APAR SE22356: CA400EXP-OPNAV-INCORROUT IFS fault with extended attributes OPTIONAL COMPONENTS ------------------- INCOMING REMOTE COMMAND ----------------------- No fixes. iSeries NAVIGATOR ----------------- APAR SE21629: CA400EXP-OPNAV-DBASE-WAIT LOCK NOT RELEASED BY EDIT CONTENTS APAR SE22008: CA400EXP-OUTPUT-INCORROUT Change URL of Infocenter APAR SE22609: CA400EXP-OPNAV-INCORROUT Problems in some Cluster wizards DATA ACCESS ----------- DATA TRANSFER ------------- DATA TRANSFER BASE SUPPORT -------------------------- APAR SE20527: CA400EXP-DTRANSFER UNICODE DATA WITH X'1A' IN THE DATA APAR SE20765: CA400EXP-DTRANSFER-MSGCWBTF0005 UPLOAD OF MS EXCEL APAR SE21329: CA400EXP-DTRANSFER-INCORROUT WARNING MESSAGES STOP RFROMPCB APAR SE21880: CA400EXP-DTRANSFER-INCORROUT SENDS MULTIPLE SHEETS APAR SE22045: CA400EXP-DTRANSFER INCORRECT TRANSLATE FROM VALUE DATA TRANSFER EXCEL ADD-IN -------------------------- APAR SE21228: CA400EXP-DTRANSFER-WAIT MS EXCEL TRANSFER FROM HANGS ODBC ---- APAR SE20631: CA400EXP-ODBC-INCORROUT BLOCK UPDATE FAILS WITH NO MESSAGE APAR SE20801: CA400EXP-ODBC-INCORROUT SPORADIC CONVERSION ERROR APAR SE20919: CA400EXP-ODBC-INCORROUT STORED PROCEDURES COMPILED WITH *CAL In V5R3 a change has been made to have the Stored Procedures compiled to use the *CALLER activation group to run under compiled level for every transaction instead of isolation level set by the application, As a result, an unexpected isolation level may be used. Support has been added to enable Stored Procedures that are compiled to use the *CALLER activation to pick up the isolation level set by the application using SET TRANSACTION. APAR SE21192: CA400EXP-ODBC-INCORROUT ODBC RUNNING AT INCORRECT ISOLATION APAR SE21505: CA400EXP-ODBC-MSGSQL0100 PRE-FETCH OF DATA APAR SE21580: CA400EXP-ODBC-MSG7399 DISTRIBUTED TRANSACTION FAILS WITH ERR APAR SE21773: CA400EXP-ODBC-WAIT A CALL TO A PROCEDURE CONTAINING BLOB APAR SE21909: CA400EXP-ODBC Character truncation error converting exponential number from SQL_C_CHAR to SQL_DECIMAL Character data right truncation error when iSeries ODBC driver converts an exponential or scientific number from SQL_C_CHAR to SQL_DECIMAL Example: 8.16e+007 which equals 81600000. The iSeries ODBC Driver does not support the conversion of scientific number from SQL_C_CHAR to SQL_DECIMAL. In order to have same functionality as other DBMS, support to convert exponential or scientific number from SQL_C_CHAR to SQL_DECIMAL was added. CIRCUMVENTION: If posible change the application to convert from SQL_C_FLOAT to SQL_DECIMAL OLE DB PROVIDER --------------- APAR SE21950: CA400EXP-OLEDB-INCORROUT SETTING PROPERTIES WITH SQL SERVER .NET DATA PROVIDER ------------------ APAR SE20843: CA400EXP-IDB2DATA DataAdapter with LOB locators fail APAR SE21919: CA400EXP-IDB2DATA Avoid implicit prepares when not necessary The .NET Provider usually does an implicit Prepare of commands when one of the iDB2Command's Execute methods is called. In many cases, this implicit Prepare is unnecessary, and results in extra data flowing to and from the iSeries server each time a command is executed. The provider should only implicitly Prepare commands when a Prepare is necessary. This PTF fixes the reported problem. The provider will still implicitly Prepare commands that need to be prepared, but it will no longer implicitly Prepare commands that don't need to be prepared. If the application repeatedly runs a command and wishes to ensure the command gets Prepared, it can call the iDB2Command.Prepare() method to prepare the command before executing it. APAR SE21966: CA400EXP-IDB2DATA-INCORROUT .NET PROVIDER CONNECTION MANAGEMENT LOTUS 123 FILE FORMAT SUPPORT ----------------------------- No fixes. AFP WORKBENCH VIEWER -------------------- No fixes. TOOLBOX FOR JAVA ---------------- Includes JTOpen 4.8 (10/06/2005). 5250 DISPLAY AND PRINTER EMULATION ---------------------------------- PC5250 Version 5.8 Level 20050818 APAR SE20279: OSP-PAR PRINTER SESSION, FILE, PAGE SETUP, FORMS SETTING APAR SE20458: CA400EXP-INCORROUT DISABLE STRPCCMD COMMAND VIA WS KEYWORD iSeries Access for Windows PC5250 needs client-side control on commands issued via the STRPCO/STRPCCMD server commands. PC5250 will allow users to disable STRPCCMD through a new WS profile keyword, "Ignore_STRPCCMD". Users can edit a .ws file to add the following to the [5250] section of the .ws profile to enable/disable STRPCCMD. The keyword can have values 'Y' and 'N' with the default being 'N' to allow the STRPCCMD command. Users who want to block STRPCCMD will have to set the keyword to 'Y'. The keyword can be set as follows: [5250] Ignore_STRPCCMD=Y When the keyword is set to 'Y', PC5250 ignores the parameters associated with STRPCCMD and simply sends back to the server an Enter key to refresh the screen. CIRCUMVENTION: Control access to STRPCO and STRPCCMD commands via iSeries authority permissions. APAR SE20629: CA400EXP-PRINTEMUL-MSGCPF5261 ERROR PRINTING WITH RHM WITHIN APAR SE20734: CA400EXP-PC5250 KANA MODE INPUT INCORROUT ON CP1399 SESSION. APAR SE20890: CA400EXP-TERMEMUL-INCORROUT FUNCTION KEY NOT ALLOWED WHEN US APAR SE20923: CA400EXP-TERMEMUL-INCORROUT LETTER "O" AND ZERO NOT DISCERNA When using the Monotype Sans Duospace WT font in a PC5250 session, the capital "O" and number zero cannot be differentiated. This will be fixed by providing a new font that differentiates the capital "O" and zero characters. This new font is named "PComm Session" and the file is pcommsess.ttf . During install, the previous True Type Font file "Monotype Sans Duospace WT" (file name mtsandw.ttf) will be deleted. Any users that previously were using the Monotype Sans Duospace WT font for a higher resolution display, will automatically be switched to the default IBM3270 font. Those users that want to return to using a True Type Font or start using a True Type Font for the first time, need to follow the instructions for the Select Display Font dialog included in the following revised text from APAR SE18848: A change from raster (bitmap) fonts to True Type Fonts will be made. True Type Fonts are scalable and display text well at higher resolutions. This new feature will be implemented only for English and West European languages (PC codepage 1252). No other languages will support these higher resolutions. New monospaced True Type Fonts containing all the characters from the current IBM3270 raster font will be installed in the PC5250 installation folder. -- PComm Session (pcommsess.ttf) (for displaying text) -- PCOMMAPL (pcommapl.ttf) (for displaying APL characters like box drawing, scrollbars, etc) IBM3270 will still be the default font. The new PComm Session font (pcommsess.ttf) will need to be selected by the user via the Select Display Font dialog. Whenever the Pcomm Session font is selected, PC5250 will automatically select PCOMMAPL (pcommapl.ttf) as the APL font. Note: Operator Information Area (OIA) fonts will not be changed. At higher resolutions, characters displayed in the OIA might appear smaller than the PC5250 window text. APAR SE21646: CA400EXP-TERMEMUL-INCORROUT POPUP MENU BAR OPERATION If the Menu-Bar is hidden, and the Popup Menu-Bar is used, duplicate menu items can result. For instance, if Communication-> Configure is selected, and then the resulting panel is closed, the next time a right click is done on the title bar, multiple Popup Menu-Bar menu items appear, and within those, multiple duplicate menu items. Also, during this process, if the emulator window is maximized, it will be restored to non-maximized form, rather than staying at the desired maximized position. APAR SE21726: CA400EXP-TERMEMUL-INCORROUT KOREAN INPUT ON CODEPAGE 037 SECURE SOCKETS LAYER (SSL) -------------------------- APAR SE22490: CA400EXP-INSTALL-INCORROUT SSL GSKIT 7.0.3.18 Update Secure Sockets Layer (SSL) component to level GSkit 7.0.3.18 . This PTF updates SSL to the new level. PRINTER DRIVERS --------------- AFP PRINTER DRIVER ------------------ No fixes. SCS PRINTER DRIVER ------------------ No fixes. OPERATIONS CONSOLE ------------------ APAR SE21607: CA400EXP-OPCON-INCORROUT OpNav service functions unavailable PROGRAMMER'S TOOLKIT -------------------- HEADERS, LIBRARIES, AND DOCUMENTATION ------------------------------------- No fixes. VISUAL BASIC WIZARDS -------------------- No fixes. JAVA PROGRAMMER'S TOOLS ----------------------- No fixes. EZ-SETUP -------- No fixes. 4.0 INSTALL/UNINSTALL CONSIDERATIONS ------------------------------------- The following sections describe additional support and known problems that you may notice while using the Install/Uninstall function. 4.1 REMOVING THE SERVICE PACK ------------------------------ To remove this service pack from your PC (if the service pack was originally installed with the Enable Service Pack Uninstall option): 1. Click the Windows Start button, click on Settings, and then click on Control Panel. 2. Double-click on the Add/Remove Programs icon. 3. Click on the Change or Remove Programs button (if necessary), then find and click on the IBM iSeries Access for Windows SI24893 item, and then click on the Change/Remove button. 4. Follow the instructions on the screen. 4.2 UNABLE TO INSTALL FROM THE SERVICE SOURCE? ----------------------------------------------- InstallShield is the tool used to provide the install support for iSeries Access for Windows. The same tool is used for installing service packs. Setup.exe has a 2 minute timeout to initialize to the first wizard panel, which could expire when installing service packs over very slow communication lines. If installing from a CD or a faster connection is not possible, then the service pack could be installed in this manner: 1) A setting exists on the iSeries Access for Windows Properties Service tab that will copy the service pack image to the PC's temporary directory, install the service pack, then remove the copied files. To use this support you will need to specify this setting ("Copy install image to PC before installing"). 2) Run Check Service Level (either from the IBM iSeries Access for Windows Service folder shortcut or when Check Service Level runs at system boot on its defined schedule) STATUS: No status information is displayed while the files are copied. To determine if the transfers are progressing, look in the 'CA400CKV' temporary directory (beneath the PC temporary directory, for example C:\Documents and Settings\username\Local Settings\Temp). You should see new files appear periodically. 3) Proceed through the Service Pack install wizard to complete the install. 4.3 SERVICE PACK CONTROL ------------------------- To prevent users from installing the Service Pack, an administrator can use the SP.TXT file. If the administrator places a file named SP.TXT (with a 'N' in the first position of the first line) in the service pack installation image directory, the service pack will not be installed. 5.0 DATA TRANSFER CONSIDERATIONS --------------------------------- The following sections describe additional support or known problems that you may notice while using the Data Transfer function. 5.1 TRANSFERRING DATA WHEN THE FILE OR DATA CCSID IS 65535 ----------------------------------------------------------- WHY DOES MY DATA LOOK LIKE GARBAGE WHEN I PERFORMED A DOWNLOAD? By default, the Data Transfer function will not convert data between EBCDIC and ASCII if the data is tagged with a CCSID of 65535. In older versions of the Win 95/NT Client Access product, the 65535 conversion was controlled by the CWBTFR.INI file. This process has been changed, and the conversion is now controlled by the Data Transfer user interface. Once the setting has been made in the user interface, it is then stored in the transfer request. This is only true for .TTO, .TFR, .DTT, and .DTF files. .RTO and .DT files are still controlled by the CWBTFR.INI file. The conversion setting for .RTO and .DT files can be modified in the Data Transfer user interface, but the setting will not be saved. The setting to control the conversion is found in the File, Properties information. WARNING: This feature is designed as a workaround for people that can not change the CCSID of their files. In order for this translation to work properly, you must be confident the data in the file matches the CCSID of your user profile. The design of the iSeries is that data with a 65535 CCSID are not to be converted. This feature will attempt to do a conversion of the data from the job CCSID to the PC CCSID. This conversion may not work if the data in the file does not match the user profile/job CCSID. The correct solution to this problem is to appropriately tag the data with the correct CCSID. One way of doing this is by using CHGPF. For more information on the 65535 CCSID, please reference the iSeries National Language Support Manual.