IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 11 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 9.1 FIX PACK 11 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 11 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 9 Release 1, Fix Pack 11 README file. This README file contains descriptions of fixes for DB2 QMF for Workstation and DB2 QMF for WebSphere. ************************************************************* 2.0 PROBLEMS CORRECTED IN QMF for Workstation 9.1 Fix Pack 11 ************************************************************* QMFDQ-4572 Added documentation for visual report functions to the help and publications. QMFDQ-5734 Added documentation for user defined edit codes to the help and documentation. QMFDQ-6377 When exporting a visual report as a PDF to a file that already exists at the specified file directory location, no prompt opens asking to confirm the overwrite. QMFDQ-6885 Added the option to specify the maximum number of simultaneous database connections to the repository. QMFDQ-6922 In the Data Source Connections view, the Terminate All Inactive Connections button is disabled if the Connections Timeouts Cancel limit is set to zero. QMFDQ-6948 In the Open from QMF Catalog dialog, clicking refresh in the From List window causes duplicate object lists to be displayed. QMFDQ-6950 Added an option to tailor database, tablespace, and index names according to specific standards. QMFDQ-6953 In the SQL query editor, color formatting errors may occur when entering text that wraps to a second line with breaks. QMFDQ-6954 Disabled the editing of cell values in top and side groups of query result sets. QMFDQ-6956 The command bar does not automatically resize when the application window is resized. QMFDQ-6969 The application disconnects from the repository automatically after editing the active repository connection. QMFDQ-6995 An error may occur when importing a QMF scheduled job. QMFDQ-7025 Added support for stored procedures for MS SQL Server 2005. QMFDQ-7034 During an export function, if a specific file path is not entered in the Export Query Results wizard, then no file is created after the Export Query Results wizard closes. QMFDQ-7061 Objects in the Personal view do not refresh when their corresponding objects are deleted in the repository. QMFDQ-7077 If an error occurs while a table is being copied to the repository, a blank table is displayed when the repository objects are refreshed. QMFDQ-7087 Added support for network and web connections in Network repository service QMFDQ-7091 If the Disable LOB data retrieval resource limit is checked, when a query is run that contains LOB data and the Try to display LOB content in cell option is selected, many information messages are displayed. QMFDQ-7142 The Scheduled Jobs dialog does not sort listed jobs when a new job is created. QMFDQ-7153 An error may occur when you expand a link to a deleted data source. QMFDQ-7185 Column names may be displayed with additional quotation marks in the Columns pane of the Prompted query editor. QMFDQ-7200 An error may occur when you cancel out of the Connection Parameters page of the Properties dialog if the HTTP URL field is empty. QMFDQ-7205 Substitution variables that are populated in a procedure are ignored during the EXPORT command and when exporting using the Export menu; the substitution variable names are displayed instead. QMFDQ-7209 An error may occur when you open the data source that contains the repository storage tables of the active repository. QMFDQ-7224 A prompt dialog asking to replace the current table opens twice when a table is imported that has the same name as a preexisting table in the data source. QMFDQ-7227 An error may occur when attempting to create a new QMF catalog in a data source that does not require a user name or password. QMFDQ-7229 After clearing user information from a data source, the Log On dialog opens twice after entering new user data in the Set User Information dialog. QMFDQ-7248 In visual dashboards, the Execute Shell Command event action may not work properly. QMFDQ-7252 In the Favorites folder of the Personal view, virtual tables may be incorrectly treated as folders, allowing additional objects to be added to them. QMFDQ-7253 An error may occur when you attempt to copy a virtual table from an original virtual data source to its duplicate virtual data source. QMFDQ-7254 Extended QMF catalogs do not refresh in a data source's Properties view after changing the data source's URL. QMFDQ-7257 When Data Source is selected in the Object types field of the Search in Repository dialog, the user is prompted to login to every data source in the repository. QMFDQ-7258 In the Table editor, the Edit Row and Delete Row commands are incorrectly disabled in the Results menu when one row is selected, and enabled if multiple rows are selected. QMFDQ-7266 If a comment is entered in the Properties view of a new query, when the editor is closed and the query reopened, the comment will no longer display. QMFDQ-7272 It is not possible to enter a file type in the Confirm Stored Procedure Parameters dialog. QMFDQ-7283 Rows containing cells with overly long string values may not be displayed in the Results view. QMFDQ-7285 Added the ability for users to change their DB2 passwords. QMFDQ-7294 Personal repositories are displayed in the Export connection and JDBC library settings dialog. QMFDQ-7342 In a virtual data source, SELECT queries with a join condition for two tables only returns the columns from the first table. QMFDQ-7351 Cannot select multiple objects for deletion, or show objects in the repository in the Personal view. QMFDQ-7358 If a repository contains more than twenty data sources, it may take a long time to delete a data source. QMFDQ-7366 Personal repositories created in the WebSphere application can not be accessed using a web service repository connection. QMFDQ-7369 Visual reports can not be saved while using a web service repository connection. QMFDQ-7377 Fixpacks with changes to the QMF static packages can now coexist within the same repository. QMFDQ-7392 The JRE is not updated when a new fixpack is installed. QMFDQ-7396 Table and column comments are now displayed in the comments field of the Properties view. QMFDQ-7408 When saving a query to a file from the Prompted query editor, the file extension is not changed from *.qry to *.pq. QMFDQ-7411 User defined substitution variables may not be correctly displayed in report headers when exported to PDF or displayed on screen. QMFDQ-7425 An error may occur when trying to open an object from a workspace that has been renamed in the Repository Explorer view. QMFDQ-7458 Multiplatforms version fails to bind static SQL packages using version DB2 JDBC Universal Driver supplied with the product. QMFDQ-7495 Multiple workspaces are now supported. QMFDQ-7583 An error may occur when listing query objects from a QMF catalog that contains unsupported object types. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 9.1 FIX PACK 11 ************************************************************* QMFDQ-6784 An error occurs when using complex queries using INSERT or UPDATE to create virtual tables; only SELECT statements may be used. QMFDQ-6919 An error may occur when trying to import a scheduled job file that contains non-English characters its file path. QMFDQ-6948 In the Open from QMF Catalog dialog, clicking refresh in the From List window causes duplicate object lists to be displayed. QMFDQ-6950 Added an option to tailor database, tablespace, and index names according to specific standards. QMFDQ-6953 In the SQL query editor, color formatting errors may occur when entering text that wraps to a second line with breaks. QMFDQ-6954 Disabled the editing of cell values in top and side groups of query result sets. QMFDQ-6955 The application does not prompt the user to save changed or new objects when user closes session. QMFDQ-7038 In the form designer, the column width value can not be set. QMFDQ-7061 Objects in the Personal view do not refresh when their corresponding objects are deleted in the repository. QMFDQ-7077 If an error occurs while a table is being copied to the repository, a blank table is displayed when the repository objects are refreshed. QMFDQ-7091 If the Disable LOB data retrieval resource limit is checked, when a query is run that contains LOB data and the Try to display LOB content in cell option is selected, many information messages are displayed. QMFDQ-7122 When a GetObject command is called from an HTML page to a non-existent object on the repository, no message is displayed to the user, only a blank window. QMFDQ-7135 The BOTTOM command may not work properly to refresh the Results view content. QMFDQ-7142 The Scheduled Jobs dialog does not sort listed jobs when a new job is created. QMFDQ-7153 An error may occur when you expand a link to a deleted data source. QMFDQ-7182 If using WAS 6.0 on Linux Red Hat, the upload file function may not work properly. QMFDQ-7185 Column names may be displayed with additional quotation marks in the Columns pane of the Prompted query editor. QMFDQ-7219 When importing a table, the Open file dialog may open twice. QMFDQ-7223 If an incorrect data source is set for a query in the SQL query editor, when the Prepare option is selected in the Query menu, an error occurs and Prepare is permanently disabled for the query. QMFDQ-7232 Options that are set in the Appearance page in Preferences dialog reset to defaults when the dialog is reopened. QMFDQ-7255 New folders may not be allowed in newly created Personal repositories. QMFDQ-7257 When Data Source is selected in the Object types field of the Search in Repository dialog, the user is prompted to login to every data source in the repository. QMFDQ-7258 In the Table editor, the Edit Row and Delete Row commands are incorrectly disabled in the Results menu when one row is selected, and enabled if multiple rows are selected. QMFDQ-7266 If a comment is entered in the Properties view of a new query, when the editor is closed and the query reopened, the comment will no longer display. QMFDQ-7273 Small files may not be able to be opened by the Open From File option. QMFDQ-7276 An error may occur when fetching a large table while using the web service client. QMFDQ-7283 Rows containing cells with overly long string values may not be displayed in the Results view. QMFDQ-7285 Added the ability for users to change their DB2 passwords. QMFDQ-7292 DBCS characters may not display correctly in queries or QMF catalog objects. QMFDQ-7294 Personal repositories are displayed in the Export connection and JDBC library settings dialog. QMFDQ-7297 When the language preference is set to auto, the locale setting of the browser is not used. QMFDQ-7342 In a virtual data source, SELECT queries with a join condition for two tables only returns the columns from the first table. QMFDQ-7358 If a repository contains more than twenty data sources, it may take a long time to delete a data source. QMFDQ-7362 The command bar displays the same previously used command list for all users. QMFDQ-7363 The server path to third-party libraries can not be specified in the Third-party Libraries preferences page. QMFDQ-7377 Fixpacks with changes to the QMF static packages can now coexist within the same repository. QMFDQ-7380 Administrator sessions may stay open after the application is closed. An error occurs when you attempt to start a new session. QMFDQ-7396 Table and column comments are now displayed in the comments field of the Properties view. QMFDQ-7408 When saving a query to a file from the Prompted query editor, the file extension is not changed from *.qry to *.pq. QMFDQ-7429 Added enhancement to GetObject function to omit toolbars from the embedded content window. QMFDQ-7437 When converting a classic report to a visual report, an error in column width formatting may occur. QMFDQ-7452 Administrator console opens with the User perspective as default instead of the Administrator perspective. QMFDQ-7482 Sessions may time out during operations and connections can not be reestablished. QMFDQ-7495 Multiple workspaces are now supported. QMFDQ-7513 URLs for accessing the User and Admin WebSphere consoles have changed. Check documentation for new URLs.