IBM(R) DB2(R) QMF for Workstation & DB2 QMF for WebSphere, Version 10 Release 1, Fix Pack 1 README CONTENTS 1.0 ABOUT THIS README FILE 2.0 PROBLEMS CORRECTED IN QMF FOR WORKSTATION 10.1 FIX PACK 1 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 10.1 FIX PACK 1 *************************** 1.0 ABOUT THIS README FILE *************************** Welcome to DB2 QMF for Workstation and DB2 QMF for WebSphere, Version 10 Release 1, Fix Pack 1 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 10.1 Fix Pack 1 ************************************************************* QMF for Workstation 10.1 Fix Pack 1 QMFDQ-2911 In visual dashboards, the x-axis of a bar chart object does not automatically adjust to include bar labels. QMFDQ-3167 If caching is turned on in resource limits, when you edit a table and close and reopen it, the old cached data is returned. QMFDQ-6658 The More Help button in the save dialog leads to a broken link. QMFDQ-6992 In visual dashboards, the update references operation may not work correctly. QMFDQ-8074 In visual dashboards, some components may not display properly when viewed in the Flash rendering mode. QMFDQ-8077 In the data source properties dialog info page, parameter values can not be edited and the same parameter can be added multiple times. QMFDQ-8264 Attempt to open a form with custom edit codes (VZIP, VSSN, VTEL2, etc) causes an error. QMFDQ-8497 Added support for ER diagrams. QMFDQ-8654 Added the DSQDC_COL_LABELS global variable, which allows you to choose whether the default QMF forms display the column labels or column names for each column of the report. QMFDQ-8690 In visual dashboards, clicking the Back button in the Google Map Layout wizard may cause an error. QMFDQ-8697 Added support for data template summary rows in visual dashboard table objects. QMFDQ-8734 The list of data sources in the edit scheduled job dialog is not updated after adding the new relational data source. QMFDQ-8782 Improved the security model by only allowing administrators or users with full permissions for an object to delete the object. QMFDQ-8819 (PMR78504) Repeated errors occur when the password that is entered into the Set User Information dialog from the Query menu is different than the password in the mainframe. QMFDQ-8862 Made corrections to the help and publications. QMFDQ-8943 Corrected multiple Mac OS specific issues QMFDQ-9002 Virtual table names and column names are case sensitive. QMFDQ-9015 While creating a new shared repository, the Import user names from QMF Catalog option is active whether or not a QMF EE license is available. QMFDQ-9101 When running in Windows Vista OS; in visual dashboards, Result options in the Export to PDF action dialog are not visible, because the dialog is too small. QMFDQ-9119 Implemented support for data source environments. QMFDQ-9139 No navigation toolbar displays when viewing an OLAP query in the Preview tab. QMFDQ-9141 An error may occur when you run a scheduled job that contains a procedure from a web service repository connection with internal security enabled. QMFDQ-9174 In visual dashboards, if you switch between the rich client and Flash rendering mode quickly, the application may hang. QMFDQ-9182 When the application is displayed in Arabic, the product numbers in the About dialog are incorrectly displayed. QMFDQ-9230 You cannot drag and drop a table from a virtual data source to a visual dashboard query. QMFDQ-9243 When you overwrite an existing repository object, its comment property is deleted. QMFDQ-9268 When you change the JDBC URL for any relational data source in the Properties dialog, the changes are not saved when you close the dialog. QMFDQ-9294 In visual dashboards, if you change the color sequence name property of a dial object several times, the dial may be displayed in solid black color when you view it in the Runtime mode. QMFDQ-9302 New forms are marked as saved when they are exported to a file system. QMFDQ-9335 In virtual data sources, names of tables are case sensitive. QMFDQ-9338 An error occurs when you expand the tree in the Login Mapping page of a repository with database-based security provider. QMFDQ-9339 When you attempt to create a new workspace by right-clicking the Workspaces folder in the Repositories view, the workspace option is not present. QMFDQ-9361 If you save over a query with a new query of the same name, close and restart the application, then open the new query, it may be blank. QMFDQ-9388 Embedded scene objects can not zoom content in rich client mode. QMFDQ-9390 Changes in Export to PDF action are not saved correctly. QMFDQ-9407 In secured repository, if permission to workspaces is set to 'None' for the user, there is no workspaces and templates object visible to user. Only Workspaces object should be hidden. QMFDQ-9410 RUN QUERY command preceded by a DRAW command causes an error. QMFDQ-9415 Runtime error occurs in scheduling a job using a QMF object if there is no QMF license file in the USER_HOME directory. QMFDQ-9419 An error occurs while editing a table offline and then returning to the table editor. QMFDQ-9420 When printing an OLAP Query, incorrect column headers are displayed and "Fixed side groups" are not displayed. QMFDQ-9428 (PMR03278) The Export to Excel operation truncates 0x00 characters. QMFDQ-9430 A NullPointerException error occurs when trying to use Search In Repository without an active repository connection. QMFDQ-9435 Procedure does not find a virtual report stored in the same workspace. QMFDQ-9437 "License file not found" message appears for all license problems. QMFDQ-9474 Implement expressions for fields in Send Email Action dialog. QMFDQ-9476 'Display a Report Using the Current Query Result' doesn't work for OLAP queries. QMFDQ-9480 Administering database based security requires that the user's primary ID has SYSADM authorization on DB2 for z/OS. QMFDQ-9484 Entries in the Repository Explorer Name Filter are now case sensitive. QMFDQ-9485 (PMR53611) In classic reports, user-entered values for substitution variables in the report headers are not being entered on all pages of the report. QMFDQ-9489 Corrected multiple issues which prevented the effective rollout of the new repository security model option that is based upon database accounts. QMFDQ-9513 Local parameters for embedded scene are not set if jump to new scene action navigates inside an embedded scene. QMFDQ-9519 Two database connections are required to expand Tables node in the Repository Explorer QMFDQ-9520 Percents in Pie chart are calculated incorrectly when it is contained in an embedded scene. QMFDQ-9531 Application may hang after "Jump To" event in an embedded scene (Rich Client only). QMFDQ-9537 In Export to PDF, after adding local parameter, it doesn't appear in Project Explorer view. QMFDQ-9623 Table Editor cannot insert row with TIMESTAMP data. QMFDQ-9629 Font settings of component are reset on copying. QMFDQ-9632 Global variables: wrong behavior when DSQQW_PROC_WNDWS=2. QMFDQ-9638 Multiline tooltip displays in a single line in Rich and Flash rendering modes. QMFDQ-9639 Error while opening dashboard with global variable of TextSet type that contains empty string value. QMFDQ-9647 The Workspaces view displays incorrectly after a mouse click on any workspace in the view. QMFDQ-9671 Dragging a query that contains a prompt into Visual Reports node in the Project Explorer tree causes the application to hang. QMFDQ-9674 Deadlock may occur after intensive use of a dashboard with content that relies on query results. QMFDQ-9692 The "Substitution variable values" dialog appears many times during opening visual dashboard that contains a query with substitution variables. QMFDQ-9693 In the Properties view pressing the Delete key deletes two characters from the selected property's value. QMFDQ-9699 Items in TreeCharts stack on top of each other in flash rendering mode. QMFDQ-9705 After exporting a visual dashboard to HTML, file names for temporary png files were generated without full paths and were created in current application installation folder. QMFDQ-9743 "Jump to new location" action may show incorrect repository. QMFDQ-9755 (PMR00487) Available CCSID list does not contain 930a. QMFDQ-9756 Type conversion error occurred for local scene parameter when parameter has NumberSet type and the application uses French locale for numbers. QMFDQ-9761 Prompted query cannot handle ROW condition WHERE clause with LIKE when character data contains '&'. QMFDQ-9825 Scene background color is not changed when jump to the other scene occurs. QMFDQ-9830 (PMR12776) A NullPointerException error may occur when running a specific SQL code against DB2 v9 on z/OS without a column alias. QMFDQ-9846 Error running scheduled job that contains the MAIL DATA TO command. QMFDQ-9848 (PMR79431) More than one connection is required to run a query against a data source. QMFDQ-9849 Axis labels are rotated incorrectly if rotation is used. QMFDQ-9850 The Google Map wizard does not honor the 'Enable information window' checkbox. QMFDQ-9873 In some cases images are not drawn correctly in HTML renderer mode. QMFDQ-9878 (PMR79278) An error may occur during a bind against DB2 z/OS 9.1.5 if the decimal delimiter in the database is a comma. QMFDQ-9879 Color sequences and Color maps won't paste in virtual report from visual dashboard. QMFDQ-9895 Global Variables item disappears from View/Preferences menu when there is no active connection. ************************************************************* 3.0 PROBLEMS CORRECTED IN QMF FOR WEBSPHERE 10.1 FIX PACK 1 ************************************************************* QMF for WebSphere 10.1 Fix Pack 1 QMFDQ-3167 If caching is turned on in resource limits, when you edit a table and close and reopen it, the old cached data is returned. QMFDQ-6658 The More Help button in the save dialog leads to a broken link. QMFDQ-7634 The Product Tutorials help menu item leads to a broken link. QMFDQ-8077 In the data source properties dialog info page, parameter values can not be edited and the same parameter can be added multiple times. QMFDQ-8125 In visual reports, there is no way to zoom. QMFDQ-8264 Attempt to open a form with custom edit codes (VZIP, VSSN, VTEL2, etc) causes an error. QMFDQ-8497 Added support for ER diagrams. QMFDQ-8547 Reestablishing a Network Repository Connection is not possible. QMFDQ-8644 The rename dialog may open unexpectedly after closing it a first time in the QMF catalog object list. QMFDQ-8654 Added the DSQDC_COL_LABELS global variable, which allows you to choose whether the default QMF forms display the column labels or column names for each column of the report. QMFDQ-8734 The list of data sources in the edit scheduled job dialog is not updated after adding the new relational data source. QMFDQ-8782 Improved the security model by only allowing administrators or users with full permissions for an object to delete the object. QMFDQ-8862 Made corrections to the help and publications. QMFDQ-9002 Virtual table names and column names are case sensitive. QMFDQ-9015 While creating a new shared repository, the Import user names from QMF Catalog option is active whether or not a QMF EE license is available. QMFDQ-9119 Implemented support for data source environments. QMFDQ-9139 No navigation toolbar displays when viewing an OLAP query in the Preview tab. QMFDQ-9140 The Go to menu item was removed from the Results menu. QMFDQ-9141 An error may occur when you run a scheduled job that contains a procedure from a web service repository connection with internal security enabled. QMFDQ-9182 When the application is displayed in Arabic, the product numbers in the About dialog are incorrectly displayed. QMFDQ-9188 When you change the language locale from English to Arabic to Czech, the New dialog is displayed in Arabic. QMFDQ-9205 When you send query results to an email recipient, the exported file is empty. QMFDQ-9243 When you overwrite an existing repository object, its comment property is deleted. QMFDQ-9268 When you change the JDBC URL for any relational data source in the Properties dialog, the changes are not saved when you close the dialog. QMFDQ-9302 New forms are marked as saved when they are exported to a file system. QMFDQ-9335 In virtual data sources, names of tables are case sensitive. QMFDQ-9338 An error occurs when you expand the tree in the Login Mapping page of a repository with database-based security provider. QMFDQ-9339 When you attempt to create a new workspace by right-clicking the Workspaces folder in the Repositories view, the workspace option is not present. QMFDQ-9348 (PMR72838) An error may occur when signing in to the application if the user name has been changed since signing in and checking the Remember Password check box at logon. QMFDQ-9352 Changing the locale of the application does not always change the language of the help system. QMFDQ-9410 RUN QUERY command preceded by a DRAW command causes an error. QMFDQ-9412 (PMR76712) If you run several queries with results separated on several pages, then the application will contain parsed contents of a special XML file in memory for each results page in each query, and may consume a lot of memory. QMFDQ-9430 A NullPointerException error occurs when trying to use Search In Repository without an active repository connection. QMFDQ-9435 Procedure does not find a virtual report stored in the same workspace. QMFDQ-9463 Leading zeros in CHAR data are truncated in Table layouts. QMFDQ-9480 Administering database based security requires that the user's primary ID has SYSADM authorization on DB2 for z/OS. QMFDQ-9484 Entries in the Repository Explorer Name Filter are now case sensitive. QMFDQ-9485 (PMR53611) In classic reports, user-entered values for substitution variables in the report headers are not being entered on all pages of the report. QMFDQ-9489 Corrected multiple issues which prevented the effective rollout of the new repository security model option that is based upon database accounts. QMFDQ-9681 User names and passwords that are stored in the DataQuant for WebSphere User are not available in DataQuant for WebSphere Administrator. QMFDQ-9699 Items in TreeCharts stack on top of each other in flash rendering mode. QMFDQ-9755 (PMR00487) Available CCSID list does not contain 930a. QMFDQ-9761 Prompted query cannot handle ROW condition WHERE clause with LIKE when character data contains '&'. QMFDQ-9825 Scene background color is not changed when jump to the other scene occurs. QMFDQ-9836 Context help for some non-English languages doesn't work. QMFDQ-9830 (PMR12776) A NullPointerException error may occur when running a specific SQL code against DB2 v9 on z/OS without a column alias. QMFDQ-9848 (PMR79431) More than one connection is required to run a query against a data source. QMFDQ-9849 Axis labels are rotated incorrectly if rotation is used. QMFDQ-9873 In some cases images are not drawn correctly in HTML renderer mode. QMFDQ-9895 Global Variables item disappears from View/Preferences menu when there is no active connection.