
Toad® for IBM DB2
Beta Version 4.6.0.493
Beta Release Notes
January 27, 2010
| Third-Party Known Issues | ||||
| System Requirements |
Toad for DB2 is a database development and administration solution that provides productivity features for rapidly creating and executing queries, automating database object management, developing SQL code, and instant access to DB2 expertise.
Developers and administrators have access to a community of users, peers, and experts to help solve development and administration issues and assist in developing applications and feedback for improving Quests products.
All of this comes with the backing of Quest Software, a healthy and growing corporate entity that can provide the necessary training, support, and superior customer service demanded by IT management.
The Toad for DB2 4.6 Beta will be introducing new features, enhancements and fixes throughout the Beta cycle.
Click to review the updates and new features in the following areas:
Toad ships and installs IBM DB2 for LUW Client 9.7 as the DB2 client. The new default location for the DB2 client is C:\Program Files\ Toad for DB2 Beta 4.6\SQLLIB.
You can increase screen real-estate in Toad by pressing SHIFT+ALT+ENTER or selecting View | Full Screen from the menu to hide the default toolbars and display Toad in full screen mode.

In full screen mode, you can toggle back to your previous screen size and displayed toolbars by clicking Full Screen beside the menu.
![]()
Toad has introduced the ability to categorize connections and also apply a coloring scheme to allow you to easily identify what connection you are working with. To enable this feature, navigate to Tools | Options | Database | General and check the "Show category in explorer and object editors" checkbox:

You can assign a category on your connections:

Toad will then shade its features with category colors to allow for easy identification.
We removed the Database Explorer toolbar and added toolbar buttons on the Explorer toolbar.
Click a category in the list to view the features and updates for this release:
The LUW DBM Parameters and DB Parameters were moved from the Database Explorer tree to right-hand-side tabs on the database object. See below Object Management - DB2 for LUW section for screen shots.
Toad now allows you to share object filters by allowing you to export and import them. To export your filters on the database explorer select the dropdown on the schema filter control as shown below:

Other Toad users with the same Database connection defined can import and use those filters. To import those filters in Toad, use File | Open File to open the tpf (Toad filter pack) file:




Object Editors and Utility Editors now execute scripts on a background thread allowing you to drive other features in Toad when long running scripts are being executed.

On the Database - Applications tab, you can now send Dynamic SQL statements to the SQL Editor or SQL Optimizer for tuning:

The DBM Parameters and Database Parameters are now in right-hand-side tabs on the Database.

The DB Parameters can be view in Tabbed view or in Side-by-Side view.

Side-by-side view allows you to see and easily set parameters for all nodes:

Registry Variables are displayed in a tab on the right-hand-side of the Database. For DB2 LUW v9.7, you can view the details of the new DB2_COMPATIBILITY_VECTOR:

For LUW v9.7, Cataloged Global Temporary Tables are now displayed in the Database browser

Toad includes support for new datatype/attributes introduces in LUW v9.7 including precision for Timestamp columns and Inline Lengths for LOB and XML columns.


For DB2 LUW v9.7 indexes, the new Compress attribute can be specified.

We have added new launch-points (on the database object in the database browser and on the monitor tab) to launch Spotlight and SQL Analysis:

We have added additional features at the DB2 LUW Database level, including Activate, Deactivate, Quiesce and Unquiesce. We modified the Tools menu to reflect these additions:

Toad now includes a options to create copies of your data during the loading of data to remove any COPY-PENDING statuses.
Note: Many of the z/OS Admin features require that you have the Quest IBM DB2 z/OS Components installed on the DB2 z/OS subsystem. This Beta will operate with the GA version 4.5 components, so if you already have those installed you are fine. See the Quest IBM DB2 z/OS Component Installation Guide for more information.
The Quest IBM DB2 z/OS Components are required to manage your DB2 for z/OS subsystems. There have been no changes made to the Quest IBM DB2 z/OS Components since version 4.5, so if you already have those installed there is no need to install them again.
Toad now has a new Tablespace Freespace Exceptions report:

We removed the top 'filter' panel from all exception reports to be able to show more details and we added highlighting to the "Stats Time" column to identify old statistics.
All actions can now be accomplished via a right-click popup menu.

A new "Details" tab has been added to the Database Space Usage Report. This tab allows you to view summary and detailed container pages sizes across partitions and tablespaces.

Click a category in the list to view the features and updates for this release:
Toad now has support for exporting directly to Excel 2007 and 2010.
Several enhancements have been made to the Import wizard. The wizard now allows you to specify a discard file. Rows failing to import will be written to that discard file.

Error messages stating the row(s) in error will be displayed on the Import Error window:

The "Import data summary results" now displays a link to the discard file.

Click a category in the list to view the features and updates for this release:
When opening a previously saved Query Builder file, you can right-click the Diagram pane and select Refresh to get the latest objects from the database.

When saving an Editor file where Group Execute is enabled, Toad defaults to saving the file as a Toad Editor File (.tef). If you save as this file type, the selected group, the selected connections, and query are saved. (When you are saving the file, you can choose to save the script as a sql file only as well.)
Toad now shows how many Group Execute targets are selected and provides a new "Merge result sets" option:


Files are now added to the Recent Files list when you drag them into the Editor.

The "Pivot Grid & Chart" tab now allows you to display the Chart at the side or bottom:

Selecting "Chart Horizontal" in the above picture will move the chart to the bottom as shown below:

We reintroduced (by popular demand) the ability to rename Editor tabs, via a right-clicking or F2 on the tab:

We have introduced support for generating PL/I formatted SQL:


We are introducing our support of new DB2 LUW v9.7 features. This beta now supports the new Oracle-like datatypes such as NUMBER, VARCHAR2, BOOLEAN as well as new logic control statements such as LOOP, CASE, and IF/THEN.

The following is a list of issues addressed and enhancements implemented in the current release:
|
Feature |
Resolved Issue |
Defect ID |
Drop |
|
Debugger |
DB2 Error modifying value of watch variable |
ST#41821 CR#188846 |
4.6.0.305 |
| Debugger | Debugger shows incorrect values in variables |
ST#42673 CR#226217 |
4.6.0.305 |
| Debugger | Bad return code returned while debugging |
ST#42687 CR#226577 |
4.6.0.305 |
| Debugger | DB2 z/OS Debugger, incorrectly shows "Procedure not compile with Debug" message |
ST#41962 CR#207662 |
4.6.0.305 |
| View Editor | Enhancement to add integration to Query Builder from View Editor |
ST#42673 61347 |
4.6.0.305 |
| General | Color tabs to match the connection that they are acting on. All tabs related to the same connection should have the same color/shading. This is to easily identify what tabs go with what connection | ST#53104 | 4.6.0.305 |
| SQL Editor | Offer PL/I code as Application Code Generation option within the SQL Editor. | ST#61668 | 4.6.0.305 |
| SQL Editor | Code completion not working when a correlation name is used in the Statement. | ST#61922 | 4.6.0.305 |
| SQL Editor | Code completion not listing user tables after a comma is typed. | ST#62058 | 4.6.0.305 |
| Filters | Database explorer Schema filter set to '*' and object filter set to a string doesn't display the objects that exist. | ST#61200 | 4.6.0.305 |
| Filters | Add the ability to share custom filters for use on the database explorer. | ST#58386 | 4.6.0.305 |
| Permissions | In Toad v4.5 when an altering GROUP privilege to a package and trying to generate a script, an exception might be thrown. |
ST#68717 Case#768617 |
4.6.0.305 |
| Import Wizard | The Import wizard does not recognize 2007 Excel files. | ST#42416 | 4.6.0.305 |
| Database Parameters | User would like the ability to view and edit Parameters for all nodes side by side. | ST#56774 | 4.6.0.305 |
| Stand-alone Utilities (DB2 for LUW) | When you run the Reorg Tables or Runstats Tables feature from the right-click menu on a tablespace that contains partitioned tables, both the object list in the Reorg (or Runstats) Tables window and the resulting script omit the partitioned tables. |
ST#63778 63779 |
4.6.0.371 |
| Migration | Migration with objects with Identity columns causes invalid script. | ST#68774 | 4.6.0.371 |
| Export Wizard | Enhancement to Allow renaming of primary and foreign key constraints. | ST#67331 | 4.6.0.371 |
| DDL Generation | Generation of the zOS Tablespace DEFINE YES/NO parameters are not consistent | ST#67829 | 4.6.0.371 |
| Compare Object | LUW Compare Object from Schema with thousands of objects many cause several errors to be shown and the script will not generate. | ST#68003 | 4.6.0.371 |
| View Editor | Enhancement to allow a qualifier to be specified in the View editor to be used when validating a query with unqualified object names. | ST#59560 | 4.6.0.371 |
| View Editor | Alter View: DOE doesn't show query of view if view was created as "Create or Replace View" | ST#67476 | 4.6.0.371 |
| Procedure Editor | Enhancement request to enable fields on the BUILD page of the Create Stored procedure DOE for z/OS so users can specify their own build procedure name. | ST#62594 | 4.6.0.371 |
| Import Export Wizard | Import/Export as DELIMITED TEXT fails to import correctly when a bar (|) is used as the DELIM character. | ST#67557 | 4.6.0.371 |
| Explain | Incorrectly generated SQL when SCHEMA is all numbers invariably leads to EXPLAIN error. | ST#68405 | 4.6.0.371 |
| Alter Table | Altering a table with an identity column may cause and error when brining up the Alter Table Dialog. | ST#68569 | 4.6.0.371 |
| Data Compare | The Data compare feature was under construction and can now be used in drop 4.6.0.401 | ST#69253 | 4.6.0.401 |
| FTP feature | An exception might be thrown when attempting to establish an FTP connection. | ST#68756 | 4.6.0.401 |
| LUW Constraints | DB2 LUW v9.7 allows constraint names with lengths up to 128 bytes. Toad only allows 18 and should allow the maximum length. | N/A | 4.6.0.447 |
| Compiling Procedures | A DB2 error might be displayed when compiling SQL Procedures with Debug. |
ST#68842 Case#767707 |
4.6.0.447 |
| LUW Constraint Alter | Altering a primary key constraint results in an invalid script. | ST#70120 | 4.6.0.493 |
| Space Calculator | When running Space Calculator on a DB2 LUW database with a version less than v8.1 fixpack 10, a DB2 internal error will result in the DB2 bringing the DB2 instance down. |
ST#70151 Case#782822 |
4.6.0.493 |
| z/OS Index Dataset tab | The datasets displayed on a z/OS Index Dataset DOV are actually the datasets of the index's tables's tablespace. |
ST#69987 Case#780790 |
4.6.0.493 |
| Result Set Tabs | When multiple result set tabs are displayed, the Duration in the second and later tabs displays the DURATION as 0:00:00 |
ST#66745 Case#750641 |
4.6.0.493 |
| Connections | Symbols in password field of signon cause exceptions/errors in Toad |
ST#67525 Case#758153 |
4.6.0.493 |
| Object Lists | Beta - Expanding Object lists in the browser does not work all of the time. | ST#68845 | 4.6.0.493 |
| LUW Tablespace Space Management | Advanced Resize of DMS tablespaces does not reflect of changes in space calculator and space exceptions even when refresh all is done. |
ST#70187 Case#782938 |
4.6.0.493 |
The following is a list of issues known to exist at the time of the Toad for DB2 release.
|
Feature |
Known Issue |
Defect ID |
| General |
Attempting to launch Toad
results in a System.Security.Policy.PolicyException error.
Workaround: |
CR#166752 Case#408845 |
| Customized options defined in Toad's Configuration wizard are not applied if you are running as a Restricted user. | CR#216699 | |
|
As a security measure in Windows Vista, when a standard user belonging to an Administrators group launches a
process and the Vista User Access Control security feature is
enabled, the process launches with only standard user privileges.
However, under these restricted privileges, Toad can have problems cataloging DB2
systems (including transferring a DB2 catalog at Toad setup) and running
utilities through CLP, thus affecting advanced alters and other Toad
functionality.
Additionally, this user does not have write access to the Toad default storage folder (the Toad installation folder) where files, such a the license key file and export profiles generated in the Client Configuration wizard, are stored when no explicit path is specified. Instead, Vista automatically copies files to C:\Users\db2admin\AppData\Local\Virtual Store\Program Files\Quest Software\Toad for DB2 version. The Toad user can have the following issues:
Workaround: |
N/A | |
|
If a Vista standard user belonging to an Administrators group has launched
Toad with the Vista User Access Control security feature enabled, the
user cannot open a Spotlight on DB2 for z/OS session within Toad due to
insufficient privileges. Workaround: |
ST#60,819 | |
The Toad db2cli.ini file defines that Toad connects
to the catalog node on multi-partitioned DB2 for LUW databases.
To change the node to which Toad connects, use the
following steps to edit the file:
|
ST#53,860 | |
| Installation/ Upgrade |
The Toad for DB2 installation process installs a DB2 client in the specified Toad installation path. If the user chooses to override the default Toad installation path, the new path cannot include Unicode characters because the DB2 client installation does not support such characters. | N/A |
|
If a Vista standard user belonging to an Administrators group attempts to
uninstall Toad when the Vista User Access Control security feature is
enabled, the uninstall might hang.
Workaround: |
ST#52,914 | |
| If a DB2 for LUW 7 client is installed on the machine where you are installing Toad, you must upgrade the DB2 client to version 8 before installing Toad to avoid losing functionality in some DB2 native tools. |
CR#192879 Case#462823 | |
| Network and LAN installations are currently not supported. | N/A | |
|
If a Windows XP power user attempts to uninstall Toad, initially installed
by a power user, the uninstall might fail. Workaround: |
ST#63,284 | |
| Data Reports | Currently, you cannot create a Label Report in the Toad Data Report wizard. |
ST#42,133 CR#215945 |
| Database or Object Explorer | ||
|
Performance problems might occur when browsing a large number of
database objects. Workaround: |
CR#220761 CR#220757 | |
| Debugger | Currently, the debugger does not support Unicode schema names. |
ST#41,770 CR#184638 |
| Debugger | Request for Toad DB2 to support debugging Native SQL Procedures in v9.7. | ST#68,419 |
| Debugger | Enhance the debugger to support additional PL/SQL syntax including: FOR IN LOOP/ WHILE LOOP | ST#69368 |
| Editor | ||
The following object types are not found when using the View Object at
Cursor feature:
|
ST#41,627 CR#164917 | |
| When you edit a script in Toad, you must delimit SQL identifiers that begin with @ to differentiate these identifiers from named parameters. For more information, refer to the following IBM documentation: |
CR#224375 Case#552946 | |
| Export Data (Toad core feature) | Binary data types cannot be exported in this release. |
ST#41,665 CR#170430 Case#419715 |
|
When exporting large result sets (approximately 500K), you might run out
of memory before the operation completes. Workaround: |
ST#41,935 CR#203483 Case#483802 | |
| FTP Connections | When you use Toad's FTP Connections feature to transfer scripts, reports, or files to a z/OS machine, you can transfer only in USS directory mode. Currently Toad does not support FTP connections in dataset mode to z/OS machines. | ST#62,340 |
| Help in Toad | The help does not state the DB2 restriction that you cannot drop packages containing triggers | N/A |
| Migration/Object Compare/Schema Compare | ||
| (DB2 for LUW only) If the source schema contains a table alias with the same name as the target schema, synchronizing the schemas results in the target schema name being replaced with the actual table name from the source table. | CR#140343 | |
| (DB2 for z/OS only) A comparison of materialized query tables generates an "undefined name" error. |
ST#42,913 CR#228511 | |
|
Schema Compare synchronization does not create tablespaces on target to
synchronize tablespace differences. Workaround: |
ST#41,983 CR#210132 Case#491910 | |
| (DB2 for LUW) The Object Compare synchronization script is not generating the required DROP statements for target functions and procedures that need to be recreated to synchronize them with those on the source. | ST#53,435 | |
| (DB2 for z/OS) Toad supports the migration and synchronization of LOB object DDL, but does not support the migration or preservation of LOB data. | ST#53,640 | |
|
(DB2 for z/OS) During synchronization, Schema Compare fails to create
the partitioned tablespace in which to place an index-controlled
partitioned table. Workaround: |
ST#61,109 | |
|
(DB2 for z/OS) During synchronization, Schema Compare places a newly
created index-controlled partitioned table in an implicit tablespace,
instead of the intended partitioned tablespace. A DB2 error is generated
during the creation of the partitioned index. Workaround: |
ST#61,112 | |
| (DB2 for z/OS) When synchronizing partitioned indexes, Schema Compare fails to create the partitioned tablespaces in which to place the partitioned tables that the indexes control. | ST#63,613 | |
| (DB2 for LUW) When synchronizing range-clustered tables, Schema Compare fails to generate CREATE TABLE statements. | ST#64,099 | |
| (DB2 for z/OS) Schema Compare synchronization is creating auxiliary tables in temporary tablespaces, instead of creating them in the proper existing (empty) tablespaces. | ST#64,130 | |
| When preserving target data, Schema Compare and Object Compare generate scripts that list columns for the re-created tables in source-table order, which can be different from the order in which the target data is unloaded. | ST#64,749 | |
| (DB2 for LUW) When you are migrating data only and the data contains XML and identity columns, the resulting script is invalid, causing the migration to fail. | ST#64,750 | |
| Object Management | ||
| Toad supports scripting, creation, and alteration of nicknames that are based on DRDA-type wrappers only. | N/A | |
| (DB2 for z/OS only) When you alter a table to reduce the size of a column referenced in other tables via RI, the LOAD phase in the advanced ALTER fails with a DSNU334I INPUT FIELD INVALID error. The load cards show the original column length. | ST#44,753 | |
| SQL Analysis for LUW | SQL Analysis does not provide support for Unicode, multi-language, or Microsoft cluster environments. | N/A |
|
DB2 truncates dynamic SQL statement text in a DB2 event monitor when
deadlock monitoring is enabled in SQL Analysis. The truncated statement
text displays in SQL Analysis with three consecutive periods (. . .) at
the end. Workaround: |
N/A | |
| Version Control | ||
|
The Update Schema function for version control often requires that
objects be dropped and recreated. If tables are referenced by foreign
key constraints, the following error occurs when executing the script: "Could not drop object N because it is referenced by a FOREIGN KEY constraint." |
ST#42,093 CR#214601 | |
| Currently Version Control handles only DB2-standard schema names and file and folder names that are compatible with the underlying Version Control repository. |
ST#42,184 CR#217475 | |
| You currently cannot check object list definitions into version control. |
ST#42,188 CR#217524 | |
| (CVS only) Each version control configuration should point to a unique Root Folder location on the Source Repository to avoid conflicting file usage. | CR#228422 | |
|
(CVS only) You
might receive an "Unknown Error..." message when using the sspi protocol
to connect to a CVSNT server. Possible
Workaround: |
CR#226256 | |
|
(CVS only) You cannot successfully configure CVS using the SSH protocol. Workaround:
|
CR#228718 |
The following is a list of third party issues known to exist at the time of the Toad for DB2 release.
|
Feature |
Known Issue |
Change Request |
| General | You cannot insert a double-byte character into a database with a single-byte codepage. IBM PMR30857,756,000 states that this configuration is not supported. |
CR#220327 Case#537948 |
| (DB2 for LUW only) Certain Toad functions use the DB2 snapshot monitor to capture information about containers used in a database. To capture this information in a multi-partition database, the snapshot monitor requires that all database partitions be active. Therefore, to ensure that Toad obtains container information across all partitions, execute the DB2 command ACTIVATE DATABASE real_database_name on the server before connecting Toad to the database. This command keeps all partitions on the database active. For more information about ACTIVATE DATABASE, refer to the IBM DB2 for Linux, Unix, and Windows documentation. | N/A | |
| Connections to Toad are lost, generating SQL0902 errors from the .NET driver. IBM has opened PMR 47384,756,000 to investigate this issue. |
ST#56,141 Case#669950 |
|
|
Installation/ Upgrade |
You cannot install DB2 for LUW 8 on the same system that already has Toad for
DB2 3.0 installed. This problem exists because of a current DB2 limitation in
which DB2 for LUW 8 cannot be installed on a system on which DB2 for LUW
9 resides. (Toad for DB2 includes a customized version of DB2 for LUW 9.) Workaround: If you need to install DB2 for LUW 8, uninstall Toad, install DB2 for LUW 8, and then reinstall Toad. For more information, refer to the Release Notes for IBM DB2 9 for Linux, Unix, and Windows. |
CR#187913 |
|
An SQL0805N error occurs when performing a DML statement on a database. Workaround: |
CR#220160 | |
| Database Explorer/ Object Explorer | ||
| Schemas containing empty names or special characters are not supported in this release and will display as QUEST_SCHEMA_PLACE_HOLDER when used. |
CR#133127 CR#133139 |
|
| (DB2 for LUW) Initially, an SQL0873N error occurred when you attempted to view tablespace container information. The error stemmed from running SNAP and SNAPSHOT-level table functions against a codepage 819 database. IBM addressed the issue with APAR IZ41782. | ST#59,222 | |
| Data Grid | A Microsoft .NET Framework issue causes an exception error when you attempt to browse the Data tab for a table containing a decimal value with a precision greater than 28 or 29. This issue is described in http://msdn2.microsoft.com/en-us/library/xtba3z33(vs.71).aspx. | CR#186529 |
| Timestamp data causes exceptions when you click the Data tab or attempt to query the table. This issue is related to the IBM DB2 APAR IY87346. | CR#220839 | |
| (DB2 for LUW) Attempting to update a table column value that is not generated causes an error when another column in the table is defined as GENERATED ALWAYS. IBM has opened PMR 48511,756,000 to investigate this issue. | ST#51,035 | |
|
(DB2 for z/OS) Tables that contain decimal data larger than 28 or 29 decimals
results in an error stating:
"Value was either too large or too small for a Decimal." This is due to a limitation in the .NET Framework in which the maximum decimal that the Framework can handle is 10^31 with 0 decimal.
Workaround:
Note: When using this workaround, if the number of characters is less than 32, leading zeros display. |
CR#186529, CR#186535 |
|
|
You cannot add data to tables that include columns that have the GENERATED
ALWAYS AS option enabled. The IBM Command Builder generates the INSERT statement
and includes the generated always column, which results in the following error:
"A value cannot be specified for column "GEN" which is defined as GENERATED ALWAYS. SQLSTATE=428C9" Workaround: |
CR#142504 | |
| Debugger | When compiling with debug, disable AutoCommit (Tools | Options | Database | General) to allow a rollback if there is a problem when dropping and creating the procedure. Once you successfully create the procedure, commit the changes before starting the debugging session. | N/A |
| When debugging, you must enter a value for every start parameter, regardless of whether they are input or output values or an error message incorrectly informs you that the procedure must be compiled with debug information. | CR#143234 | |
|
(DB2 for LUW) The following error message is displayed when you attempt to modify a
watch value during a Debug session on a DB2 for LUW 9 database: "ERROR [57011] [IBM][DB2/NT] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011" The call to modify the watch value fails on DB2, and the server runs out of heap memory.
Workaround: |
CR#188846 | |
| (DB2 for z/OS) A message stating that a procedure is not compiled with the Debug code, when in fact it is, is being generated. This issue is due to an error in the z/OS implementation of Create_Session. | CR#207662 | |
| (DB2 for LUW) The "Unable to initialize debug session" error that is generated when you attempt to debug procedures in DB2 for LUW is a DB2-related issue. A future release of a DB2 unified debugger should help reduce the occurrence of this issue. |
Case#517909 Case#529227 CR#213765 |
|
| Editor |
Attempting to create an object in the Editor when the schema selected from
the drop-down list in the Editor toolbar is different than the schema you logged
into, results in an error. Toad issues a SET CURRENT SCHEMA statement the
first time you execute a script/statement. Workaround:
|
CR#183855 |
| (DB2 for LUW) Dropping a nickname does not drop its primary key. This issue (PMR 30432,756,000) was fixed in DB2 9.1 Fixpak 3. |
ST#42,503 CR#223155 |
|
| Export Data (Toad core feature) |
In order to export to an Office 2003 or 2007 Excel instance, the Office 2003 Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from
one of the following locations: |
CR#138239 |
| Migration/Object Compare/Schema Compare | (DB2 for LUW) You cannot synchronize schemas if the Code Pages on the compared schemas do not match. | CR#141383 |
| Object Management | (DB2 for z/OS) There is a known z/OS issue when attempting to ALTER partitioning index values for PRIQTY and SECQTY. If these values are changed in Toad, the subsequent ALTER statement is generated without ENDING AT values for the partition keys. The generated syntax is correct; however a database error will occur. IBM has issued z/OS APAR PK69271 to address the issue. | ST#49,829 |
| (DB2 for LUW) Running queries or performing database administrative tasks in Toad on DB2 databases running on an AIX 5.2 machine can cause the DB2 instance to crash. IBM has addressed this issue with APAR IY79365. | ST#57,962 | |
| (DB2 for LUW) db2bp.exe can fail with a Windows error during advanced alters, migrations, Object Compare synchronization, and regular object management. IBM has issued APAR JR33088 to address this issue. | ST#59,491 | |
| You cannot create a DB2 8 database from a DB2 9 client. Therefore, you cannot use Toad's DB2 LUW Create Database wizard to create a DB2 8 database. | N/A | |
|
(DB2 for z/OS) Attempting to drop a distinct type or sequence with a delimited
blank name results in following error due to server side abends: "IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003" This is a known IBM DB2 issue and IBM has opened APAR PK3269 to track this issue. |
N/A | |
| (DB2 for z/OS) In some cases, a user can revoke INSERT privileges on a table for the owner and cause a cascading revoke of privileges for any user (including the revoker) who was granted privileges by the table owner. This is a known IBM DB2 issue and IBM has opened APAR PK30558 to track this issue. | N/A | |
|
(DB2 for z/OS) The following DB2 error is generated when you try to refresh an MQ table: "ERROR [58031] [IBM] SQL1034C The database is damaged..." This error is identified in APAR PQ97328. The APAR states that, if the statement text in the CREATE TABLE statement for a materialized table is more than 4K, the statement text stored in the SYSVIEW.VIEWS catalog table entries for the table (after the first three sequence number entries) contains unusable data. The APAR has been fixed with PTF UK00557. However, any materialized tables created before this fix need to be dropped and recreated and REFRESH rerun. |
N/A | |
| Space Management | (DB2 for LUW) APAR IY90197 states: RUNNING SNAPSHOT TABLE FUNCTIONS CAN CORRUPT MEMORY INSIDE THE DB2FMP (C) PROCESS DUE TO STACK OVERFLOW. This issue was fixed in DB2 8.1 Fixpak 14. | N/A |
| SQL Analysis for DB2 LUW | Databases on DB2 for LUW 8.1 (with FixPaks 1 through 4 applied) generate deadlock events that show a zero lock-wait start time. IBM has addressed this issue with APAR JR18739 in DB2 8.1 FixPak 5. | N/A |
Please review upgrade information in the Toad for DB2 Installation Guide available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.
Verify that your system meets the requirements described in the following sections:
Requirement for Capturing Container Information in a DB2 for LUW Multi-Partition Database
Recommended Indexes to Improve Toad Performance in DB2 for z/OS
Toad for DB2 client installation requires the following.
Note: If a DB2 for LUW 7 client is installed on the machine where you are installing Toad, you must upgrade the DB2 client to version 8 before installing to avoid losing functionality in some DB2 native tools.
| Platform | 1 GHz minimum |
| Memory | 512 MB of RAM minimum, 1 GB recommended Note: The memory required may vary based on the following:
|
| Hard Disk Space | 212 MB of disk space required to run Toad. Allocate the following additional space as needed:
|
| Operating System | Any of the following:
Note: The Toad SQL Analysis for DB2 LUW client is not supported on Windows Vista or Windows Server 2008. |
| Additional Software |
.NET Framework Microsoft .NET Framework 3.5 (Service Pack 1) Notes:
Web Browser Existing DB2 Client Support |
| Other Requirements | SVGA monitor with a minimum resolution of 800x600, 1024x768 recommended |
Toad supports any of these DB2 and operating system versions.
| Database Versions |
Any of these database versions: Supported DB2 for z/OS versions
Note: At this time, Toad supports DB2 8.1 for z/OS running in Full Function mode, but does not support DB2 8.1 running in Compatibility mode. Supported DB2 for LUW versions
Notes:
|
| Database Operating System Platforms | Any of these operating systems: Supported z/OS platforms
Support Linux, Unix, or Windows platforms
|
| Operating System Platforms for the Toad for DB2 Agent | Toad requires that the Toad for DB2 Agent 5.1 reside on DB2 for
LUW server on which you intend to execute scripts server-side (using the
Toad LUW Remote Script Execution component) or to collect SQL using Toad SQL
Analysis for DB2 LUW. The agent supports servers running in any of these operation systems:
Notes:
See the Toad for DB2 LUW Installation Guide for agent requirements and installation instructions. |
| Hard Disk Space for Toad for DB2 Agent |
|
The following are user requirements for installing and running Toad:
Only Administrators and Power Users can install Toad.
Note: The following exceptions exist for Power Users:
If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user--a Power User, Restricted User, Vista standard user--on the computer.
If a Power User installs Toad, a Restricted User cannot do the following:
The following describes the requirements and restrictions for users who launch and run Toad:
http://www.toadsoft.com/toaddb2/ReleaseNotes/Beta/ToadDB2LUWAuthorizations.xls
http://www.toadsoft.com/toaddb2/ReleaseNotes/Latest/ToadDB2zOSAuthorizations.doc
- Select Control Panel from the Windows Start menu.
- Double-click Administrative Tools.
- Double-click Microsoft .NET Framework version Configuration.
- Select My Computer, and then select the Runtime Security Policy node.
- Select Evaluate Assembly from the list of tasks in the right panel.
- In the File field, locate and select Toad.exe.
- Click Next, and set the permission to Unrestricted.
Toad has been tested for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the Metaframe Access Suite 4.0 and Citrix Presentation Server Clients 10.2. For information about installing Toad in a Citrix environment, refer to Install Toad on Citrix Systems in the Toad for DB2 Installation Guide.
To connect to a Lightweight Directory Application Protocol (LDAP) server, you must enable LDAP support and specify the host name and port number of the LDAP server for the DB2 client installed with Toad.
Note: Keep the following mind:
To configure Toad to use LDAP
db2set DB2_ENABLE_LDAP=YES
db2set DB2LDAPHOST=hostname[:port]
The port number defaults to 389 (default LDAP port) if you leave the port number blank.
Databases on the LDAP server should now be available from the Database Alias drop-down list in the Connections window. To complete the Toad connection setup, you must create a Toad profile for each database. See Create Toad Connection Profiles in the Toad for DB2 Installation Guide.
Certain Toad functions use the DB2 snapshot monitor to capture information about containers used in DB2 for LUW databases. To capture this information for a multi-partition database, the snapshot monitor requires that all database partitions be active. Therefore, to ensure that Toad obtains container information across all partitions, execute the DB2 command ACTIVATE DATABASE real_database_name on the server before connecting Toad to the database. This command keeps all partitions on the database active. For more information about ACTIVATE DATABASE, refer to the IBM DB2 for Linux, Unix, and Windows documentation.
The following are the requirements for using Toad to compile and debug stored SQL procedures.
Each DB2 subsystem on which you want to compile and debug stored SQL procedures must meet these requirements:
To perform any of the following functionality in Toad, you must have Quest IBM DB2 z/OS Component 4.5 or greater installed on your DB2 for z/OS subsystems:
Bind and rebind DB2 for z/OS packages and plans
Invoke DB2 for z/OS utilities and commands within scripts that Toad for DB2 advanced alters, migrations, and synchronizations generate
Run stand-alone DB2 for z/OS utilities and commands in Toad
Run DB2 for z/OS commands from the Editor
Execute remote DB2 for z/OS scripts
Create, alter, or drop dataset templates
Run Display, Start, and Stop commands on DB2 for z/OS databases, tablespace, and indexes
Access accurate buffer-pool information for the DB2 subsystem
View volumes available for defining storage
Access information about current threads connected to the DB2 subsystem
Assign a RACF group to a Toad Security role to control the Toad features available to all users belonging to the RACF group.
If you currently have the Quest IBM DB2 z/OS component version 4.5 installed on your DB2 subsystem, you can use those with the 4.6 Beta.
If the Quest IBM DB2 z/OS component version 4.5 installation does not currently exist on your DB2 subsystem, perform a new installation of Quest IBM DB2 z/OS Component 4.6. Use the instructions found in the Quest IBM DB2 z/OS Installation Guide (available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation).
Note: A 32K character-size limit exists for each utility statement executing through DSNUTIILU.
User-defined indexes on specific system catalog tables can improve performance when you are browsing DB2 for z/OS objects in Toad. The following link contains the DDL for indexes that can optimize Toad performance on your DB2 for z/OS subsystem. Keep in mind that the creation of these indexes is a recommendation only. The indexes can have different results in different environments, depending on the number of DB2 objects and the amount of data involved. To create these indexes, edit and run the DDL contained in the following file:
http://www.toadsoft.com/toaddb2/ReleaseNotes/Latest/ToadDB2zOSIndexes.txt
Additionally, if the schema drop-down lists in the Object Migration wizard populate slowly, consider creating an index on the SCHEMA and CREATOR columns in the catalog table for each object type. Here is a list of some of the object-type tables:
SYSIBM.SYSSYNONYMS
SYSIBM.SYSSEQUENCES
SYSIBM.SYSROUTINES
SYSIBM.SYSTABLES
SYSIBM.SYSDATATYPES
SYSIBM.SYSINDEXES
SYSIBM.SYSTRIGGERS
SYSIBM.INDEXES
The following are specifications for using Toad's Object Migration wizard to migrate DB2 objects and their dependencies:
Toad for DB2 supports the following version control providers for the versions and platforms listed. Testing is not complete for versions and platforms not listed:
| Supported Provider | Server Version Tested | Client Version Tested |
| Visual SourceSafe (VSS) | VSS 6.0d | VSS 6.0d |
| Concurrent Versions System (CVS) | CVS 1.11.22 on Solaris CVSNT 2.5.03 on Windows |
CVNT 2.5.03 |
| Subversion | Subversion 1.5.6 | CollabNet Subversion Command-Line Client 1.5.6 Notes:
|
| Team Foundation Server (TFS) | TFS 2005, 2008 | Visual Studio (2005 and 2008) Team Foundation Server MSSCCI Provider |
You must configure Toad to work with your existing version control system. Ensure that you install the following on the same computer where you installed Toad.
Note: Toad connects to your version control system based on login information included in your configuration. Your version control client does not need to run for Toad to connect.
| Provider | Prerequisite |
| VSS | VSS client |
| CVS | CVSNT 2.5 client |
| Subversion | Subversion client must be 1.5.6 or later,
and the client must include the Subversion binary executable (svn.exe)
in the client installation directory to work in Toad. Notes:
|
| TFS | Visual Studio Team Foundation Server MSSCCI
Provider Notes:
|
This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Far-East Asia, Japan.
However, this release has the following known capabilities or limitations:
The Toad for DB2 Beta package contains the following products:
For important information about installing Toad for DB2, refer to the Toad for DB2 Installation Guide available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.
Caution:
|
This Beta will work with the commercial GA versions of the following components. To install other Toad DB2 commercial components, please refer to the following documentation.
| Component | Installation Instructions | Documentation Location |
| Quest IBM DB2 z/OS component | Quest IBM DB2 z/OS Component Installation Guide | From the Start menu, Program Files | Quest Software | Toad for DB2 | Documentation |
| Toad for DB2 agent | Toad for DB2 LUW Agent Installation Guide | From the Start menu, Program Files | Quest Software | Toad for DB2 | Documentation |
| Quest SQL Optimizer for DB2 LUW | Quest SQL Optimizer for IBM DB2 LUW Installation Guide | Downloaded from Quest SupportLink (http://support.quest.com/) or from the Quest product site (http://www.quest.com) |
| Toad SQL Tuning for DB2 z/OS | Toad for DB2 Installation Guide | From the Start menu, Program Files | Quest Software | Toad for DB2 | Documentation |
| Toad SQL Analysis for DB2 LUW | Toad for DB2 Installation Guide | From the Start menu, Program Files | Quest Software | Toad for DB2 | Documentation |
| info@quest.com | |
| Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA | |
| Web |
Refer to our Web site for regional and international office information.
(Commercial and Trial Support only)
Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com/.
From SupportLink, you can do the following:
View the Global Support Guide for a detailed explanation of support programs,
online services, contact information, and policy and procedures.
The guide
is available at: http://support.quest.com/pdfs/Global%20Support%20Guide.pdf.
(Freeware Support)
You can join the Toad for DB2 discussion group by sending an email to: toad_db2-subscribe@yahoogroups.com
© 2010 Quest Software, Inc.
ALL RIGHTS RESERVED.
This document contains proprietary information protected by copyright. The software described in this document is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.
If you have any questions regarding your potential use of this material, contact:
|
Quest Software World Headquarters LEGAL Dept 5 Polaris Way Aliso Viejo, CA 92656 Email: legal@quest.com |
Refer to our web site for regional and international office information.
Quest, Quest Software, the Quest Software logo, Aelita, Akonix, Akonix, AppAssure, Benchmark Factory, Big Brother, ChangeAuditor, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.
The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.