
Toad® for IBM DB2
Version 3.1 (Click here for previous versions)
Release Notes
February 2008
| 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.
Review the following:
To review the updates and new features included in Toad for DB2 3.0, access the New in This Release section in the previous Release Notes.
This release includes updates in the following areas:



New code page support for Log Reader—Log Reader for DB2 now supports code page 923.
Specific to DB2 for z/OS
CHECK DATA execution during advanced ALTERs and migrations—During advanced ALTERs and migrations, Toad generates statements to run CHECK DATA as needed to remove the CHECK PENDING status from objects. The most common case in which the CHECK PENDING status is applied occurs when the generated script loads data in an the object that has foreign keys or check constraints.




Press F6 to switch between
the two panels.


Date ranges—When
you add a WHERE condition for a column that uses a date or time data
type, a new Date Range tab displays in the Where Condition window. The
Date Range tab allows you to select a plain text tag, such as
Today,
Last week,
Last 30 days, or
Current year. The tab
is added to the WHERE condition of your query and, when executed, is
substituted with a BETWEEN command using the appropriate date range.
Date Range tags are also used in the Editor so that you can create
queries manually.

This release offers new features in the following areas:
To review the new features included in Toad for DB2 3.0, access New Features in Toad for DB2 3.0 in the previous Release Notes.









After creating the subquery, click the
parent query in the Queries panel to return to the original query. A
From Clause Subquery table now displays in the Diagram panel with all
the columns in the subquery. Use this new table as you would any other
database object.

To review the resolved issues and enhancements included in the previous 3.0.0 and 3.0.1 releases of Toad for DB2, click here to access the "Resolved Issues and Enhancements" section in Toad for DB2 3.0.1 Release Notes.
The following is a list of issues addressed and enhancements implemented in this release of Toad for DB2:
|
Feature |
Resolved Issue |
Change Request |
| General | ||
| Toad has resolved additional character issues that occur when Regional Options is set to Turkish on the client computer. This fix is related to the CR#224551, resolved in Toad for DB2 3.0.1. |
CR#225285 Case#555563-1 |
|
| Connection Manager | ||
| (DB2 for LUW only) The issue with Toad reducing log-on ID authority and causing licensing problems has been resolved. |
CR#222916 Case#543533 |
|
| Advanced ALTER | Toad now provides the option to use either temporary tables or DB2 commands and utilities (including EXPORT and IMPORT for DB2 for LUW and UNLOAD and LOAD for DB2 for z/OS) during advanced ALTERs. |
CR#226760 Case#565223-1 |
| Database Browser/Object Palette | ||
| (DB2 for LUW only) The object editor for Tables now supports data partitioning. | CR#202703 | |
| (DB2 for z/OS) Performance when browsing objects in DB2 for z/OS is greatly improved if you create additional indexes on certain system catalog tables. See Recommended Indexes to Improve Toad Performance in DB2 for z/OS for more details. |
CR#214406, CR#227223 | |
| (DB2 for LUW only) Native EXPORT and IMPORT utilities are now available in Toad. You can export to or import from IXF, ASCII, or worksheet formats. Additionally, the user interface for either utility allows you to run the utility on multiple tables. You can accept the command option defaults in the utility window or change them as needed to execute the multiple commands. |
CR#215819, CR#216566 Case#525202 | |
| When you generate the script to add, remove, or alter an index column or change the index type, the script also contains a warning message about the effects on the update on dependent constraint definitions. | CR#219910 | |
| The issue with a materialized query table name displaying multiple times in the Database Browser is resolved. |
CR#224709 Case#556353 | |
| (DB2 for LUW only) Controls for the MAXSIZE and INCREASESIZE options are now included in the Tablespace object editor. |
CR#226589 Case#565019 | |
| The Database Browser no longer displays incomplete scripts for triggers with long definitions. |
CR#226763 Case#558376 | |
| The timestamp format in the data grid no longer incorrectly shows a hyphen between the date and time. |
CR#227855 Case#565520 | |
| Toad no longer generates incorrect syntax for table columns created with the NOT NULL WITH DEFAULT attribute. |
CR#228001 Case#572279 | |
| Debugger | The parameter size-limitation issue causing output truncation and generating "Error in getting status report..." is resolved. |
CR#225757 Case#560631 |
| Data Diff Viewer | Comparing a script results grid with an XSD file now works. | CR#219662 |
| Editor | Toad can execute SQL scripts in the Editor whether or not syntax highlighting is enabled (Tools | Options | Editor | Highlighting Styles). | CR#167980 |
| The error generated during Explains is resolved. |
CR#215661 Case#521808 |
|
| Stored procedures now display in the object list generated when you press Ctl+ . (period). |
CR#226017 Case#562313 |
|
| Invalid error messages are no longer generated when you cancel a script execution. |
CR#227743 Case#569738 |
|
| Help | The link to tutorials has been removed from the Welcome to Toad page (Help | Contents | Welcome to Toad) in the help for 3.1 since no tutorials were available at the time of this release. However, these tutorials are now available post-release, and the link will be restored in the Toad for DB2 4.0 help. Click here to link to the current tutorials: http://www.toadworld.com/Portals/0/ToadDB2/Videos/Chap00.htm |
CR#229748 Case#583127 |
| Log Reader for DB2 | Log Reader now supports code page 819. |
CR#229407 Case#580081 |
| Toad Security | Toad Security is now disabled for Toad for DB2 DBA licenses. | CR#221808 |
The following is a list of issues known to exist at the time of the Toad for DB2 release.
|
Feature |
Known Issue |
Change Request |
| General | Customized options selected in the Configuration wizard are not applied if you are running as a Restricted user. | CR#216699 |
| Installation/ Upgrade |
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. |
CR#192879 Case#462823 |
|
If you have multiple versions of Toad for DB2 or Toad for Data Analysis
installed and you uninstall the product that was installed first,
you might encounter errors when you start up the other Toad products.
The error contains a call stack trace: "System.NullReferenceException Workaround:
|
CR#228164 | |
| Advanced ALTER | (DB2 for LUW only) When performing an advanced ALTER on a view on which a trigger is defined, the advanced ALTER process does drop and recreate the trigger, thus invalidating it. | CR#44,163 |
| The advanced ALTER process currently does not propagate column name changes to dependencies. | CR#44,495 | |
| (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. | CR#44,753 | |
|
(DB2 for z/OS) Any action that results in an advanced ALTER on a table
that contains constraints results in the tablespace being placed in a
check pending state. This occurs because Toad loads the table data
before re-creating the constraints. Workaround: Run the IBM DB2 Check Data utility to remove the pending state from the affected tablespace. The data loads correctly and the constraints are enforced. |
CR#222564 | |
| (DB2 for z/OS) Toad cannot perform an advanced ALTER on a table that has a large number of columns. | CR#227637 | |
| (DB2 for z/OS) An advanced ALTER on a table that resides in an implicit tablespace does not execute RUNSTATS on the table once the table is re-created. | CR#227672 | |
| Connection Manager | ||
| Manually configuring a connection using the Client Configuration wizard fails on a Windows 2003 64-bit machine. | CR#202308 | |
|
If Toad is running on a Vista machine that does not have another DB2
client installed, problems might occur when you use the Connection
Manager to catalog databases. After you specify the connection
information for a database, its catalog information does not display on
the Client Configuration wizard Results window. Consequently, Toad
cannot connect to the database. Workaround:
|
CR#227752 | |
| Data Reports | Currently, you cannot crate a Label Report in the Toad Data Report wizard. | CR#215945 |
| Database Browser/Obj Palette | ||
|
Under certain conditions (currently being determined), a system
exception error pops up on the Script tab for a selected tablespace when
you select to generate the script for dependent objects. Workaround: Click OK to close the error popup, and proceed. |
CR#43,825 | |
| Currently, you cannot grant privileges to a tables' columns for users. | CR#184359 | |
|
Performance problems might occur when browsing a large number of
database objects. Workaround: |
CR#220761 | |
| (DB2 for LUW) Selecting the Uses tab for a package generates the DB2 database error "String data right truncation." | CR#228752 | |
| Debugger | Currently, the debugger does not support Unicode schema names. | CR#184638 |
| Editor | ||
The following object types are not found when using the View Object at
Cursor feature:
|
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. |
CR#170430 Case#419715 |
|
When exporting large result sets (approximately 500K), you might run out
of memory before the operation completes. Workaround: Create a view for the query and export that view. |
CR#203483 Case#483802 | |
|
Exporting more than 65,536 rows to an Excel 2007 instance causes an
error.
|
CR#211832 | |
| Log Reader for DB2 | If the user has selected the incorrect processor architecture, the wrong error message is displayed as Log Reader reads files. | CR#181504 |
| Log Reader does not support a proxy when using FTP to access log files. | CR#199332 | |
| Log Reader Undo/Redo SQL wizard currently does not provide a comment in the script to explain when Log Reader is unable to redo or undo a specific command. | CR#199336 | |
| Log Reader cannot parse commands involving DATALINK columns. | CR#199338 | |
| Log Reader creates temporary files in Log_Reader_installation_path/Tmp directory on the local disk. Normally, these files are deleted. However, these files can remain on the local disk if, while Log Reader was loading files, either the FTP process was aborted or Toad was closed down through the Task Manager. | CR#199340 | |
| Results from running the Advanced Search function show an invalid data type value for distinct type, structured type, and DATALINK columns. | CR#202208 | |
| The Undo script for stored procedures contains incorrect syntax. | CR#202327 | |
| Object names using different encoding schemes are not displaying properly in the Advanced Search window. | CR#202667 | |
| Log Reader can parse the log files for only the database to which it is currently connected. | N/A | |
| For a multi-partitioned database, Log Reader can parse the log files for only the database partition to which you are currently connected. | N/A | |
| Migration |
(DB2 for z/OS only) On the Define
Transformation Rules and Migration Options page in the Migration wizard,
Toad allows mapping to a non-existent tablespace, but you must specify a
database name to qualify the tablespace name. If you don't specify a
database qualifier, an error occurs at script generation. You should be
able to specify simply the tablespace name, with the Toad recognizing
the database as the default database DSNDB04. Workaround: Specify the database name with the tablespace name on the Define Transformation Rules and Migration Options page. |
CR#44,127 |
|
(DB2 for LUW only) The user needs the
ability to specify the container path for the target tablespace. When
migrating from a Windows to Unix or Linux system or vice versa, the path
generated in the script might be in the wrong format. Workaround: Manually update the container path in the script. |
CR#44537 | |
|
(DB2 for z/OS only) When you are
migrating an implicit tablespace and attempt to map to a different
bufferpool or storage group, the script does not generate the correct
mapping. Workaround: Manually update the script with the correct target bufferpool or storage group. |
CR#229351 | |
| Query Builder | When you drag and drop a table containing a column name identical to a column name in another table already on Query Builder drawing surface, the drawing shows a _1 appended to the column name in the newly added table. Note, however, that the changed column name is actually an alias that does not adversely affect generated queries. | CR#44,499 |
| Schema Compare | (DB2 for z/OS only) A comparison of materialized query tables generates an "undefined name" error. | CR#42,913 |
| (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 | |
| 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." |
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. | CR#217475 | |
| You currently cannot check object list definitions into version control. | 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)
When using the pserver protocol to connect
to a CVS or CVSNT server, you must include "user@" in the
Provider Information Server field. Information in the Server
field should use the following format: :pserver:user@server:/cvsrepository
|
CR#228200 | |
|
(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 |
|
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: |
CR#187913 |
|
An SQL0805N error occurs when performing a DML statement on a database. Workaround: |
CR#220160 | |
| Database Browser/ Obj Palette |
(DB2 for z/OS only) 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 only) 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 | |
| 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 |
|
| 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 | |
|
(DB2 for z/OS only) 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 garbage. 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 | |
| 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 | |
| Data Grid |
(DB2 for z/OS only) 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 |
|
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, it is recommended that you 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 | |
|
(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 | |
| 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 SQL 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 |
| 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 |
| Log Reader for DB2 | Sometimes DB2 writes an UPDATE command to the log after a CREATE TABLE command is executed. An exception error occurs when Log Reader attempts to parse the record for the UPDATE command because the record contains unexpected or unparsed data. | CR#201537 |
| Schema Compare | (DB2 for LUW only) You cannot synchronize schemas if the Code Pages on the compared schemas do not match. | CR#141383 |
Please review upgrade information in the Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.
Verify that your system meets the minimum requirements described in the following sections:
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 is some DB2 native tools.
| Platform | 600 MHz minimum |
| Memory | 512 MB of RAM minimum, 768 MB recommended Note: The memory required may vary based on the following:
|
| Hard Disk Space | 171 MB of disk space required to run Toad Note: The disk space required can vary based on the edition of Toad installed. |
| Operating System | Microsoft® Windows® 2000, XP Professional (32-bit only), 2003 (32-bit only) Windows Vista (tested on 32-bit Ultimate edition with XP Graphics) |
| Additional Software | .NET Framework Note: In order to run Toad, the .NET security policy must be set to unrestricted. For more information, see User Privilege Requirements. Browser PDF Viewer |
| Other Requirements | SVGA monitor with a minimum resolution of 800x600, 1024x768 recommended |
Each DB2 database server requires the following:
| Database Versions |
IBM DB2 UDB for z/OS 8.1 or later Note: At this time, Toad supports DB2 for z/OS running in Full Function mode, but does not support DB2 running in Compatibility mode. IBM® DB2 UDB for Linux, UNIX, and Windows (LUW) 8.1.5 or later, 9.0 Note: To run RUNSTATS and the native REORG utility on tablespaces and indexes, Toad supports version 8.2.2 or later. |
| Database Operating System Platforms | z/OS (V1R6 Base Services [5694-A01] or later) Linux, UNIX, and Windows:
|
The following user privileges are required for installing and running Toad:
Note: Power users cannot install Toad on a Windows Vista Enterprise machine. This Windows limitation is due to the fact that the Power User mode is no longer used in Vista and therefore cannot install applications.
Associate file extensions.
From the Windows Start menu, select Settings | Control Panel.
Double-click Administrative Tools.
Double-click Microsoft .NET Framework 2.0 Configuration.
Click + to expand My Computer, and then select the Runtime Security Policy node. A list of tasks for the node display in the right panel.
Click Evaluate Assembly from the lists of tasks in the right panel. An Evaluate an Assemble window displays.
Browse to the location of Toad.exe in the File field.
Click Next to view permissions for Toad.exe.
Set the permission to Unrestricted.
READ permissions on the log files belonging to the database and on the directory where these files are stored
Database administrator privileges to read the database's log.
Toad has been tested for Citrix support on Windows Server 2003 Enterprise Server Service Pack 2 using the Metaframe Access Suite 3.0 and Citrix Presentation Server Clients 10.0. For information about installing Toad in a Citrix environment, refer to Install Toad on a Citrix Machine in the Toad for DB2 Getting Started 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: You must configure LDAP support for the DB2 client installed with Toad regardless of whether an existing DB2 client on the machine is already configured to support LDAP.
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 be available from the Database Alias drop-down list.
Note: At this point, Toad for DB2 supports only the access of DB2 LDAP catalog entries. Toad does not support the management of these entries (such as adding or removing them) Debugger Requirements
The following are the requirements for using Toad to compile and debug stored SQL procedures in DB2 for z/OS.
To use the Toad debugger on stored SQL procedures, the following Toad client requirement must be met:
Each DB2 subsystem on which you want to compile and debug stored SQL procedures must meet these requirements:
To bind and rebind packages and plans and to invoke utilities during advanced ALTERs on a DB2 for z/OS subsystem, Toad for DB2 requires the following:
If you neither product is installed on a subsystem, run edit and run the DDL that creates these objects. Click the following link to open the file containing this DDL:
http://www.toadsoft.com/toaddb2/ReleaseNotes/Latest/ToadzOSTemplateDDL.txt
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. To ensure the best possible performance from Toad, create the following indexes in each subsystem to which you are connecting in Toad:
CREATE INDEX TOADIX01
ON "SYSIBM"."SYSCOLUMNS"
("TBCREATOR" ASC,
"TBNAME" ASC,
"TYPESCHEMA" ASC,
"TYPENAME" ASC,
"COLTYPE" ASC
)
USING STOGROUP "SYSDEFLT"
PRIQTY 3600
SECQTY 3600
ERASE YES
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
DEFINE YES
BUFFERPOOL BP0
CLOSE NO
DEFER NO
COPY NO
PIECESIZE 2097152 K;
On the SYSTABLES table, as defined in the following DDL. Edit the DDL as needed for your site.
CREATE INDEX TOADIX02
ON "SYSIBM"."SYSTABLES"
("NAME" ASC,
"CREATOR" ASC,
"DBNAME" ASC,
"TSNAME" ASC
)
USING STOGROUP "SYSDEFLT"
PRIQTY 7200
SECQTY 7200
ERASE YES
FREEPAGE 0
PCTFREE 10
GBPCACHE CHANGED
DEFINE YES
BUFFERPOOL BP0
CLOSE NO
DEFER NO
COPY NO
PIECESIZE 2097152 K;
Adhere to these requirements when you use the Toad's Schema Migration wizard to migrate DB2 objects and their dependencies.
You must handle target tablespaces in one of two ways:
or
Notes:
When migrating a table that has referential-integrity relationships to other tables, select the Include dependencies option on the Select Objects for Migration page in the wizard. This option generates the statements necessary in the script to migrate the related tables. If you do not select this option, you must edit the migration script to include these statements.
The following requirements and restrictions exist for source and targets:
Note: When you are migrating objects between different versions, the Include statistics by default on the Select Objects for Migration page in the wizard is disabled.
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.4.2 | Subversion 1.4.2 |
Ensure that you install the following on the same computer on which you installed Toad:
| Provider | Prerequisite |
| Visual SourceSafe (VSS) | VSS client |
| Concurrent Versions System (CVS) | CVS client |
| Subversion | Subversion binary package Note: When configuring version control in Toad, specify the binary path for the BinaryPath value on the Command Based Version Control Properties page in the Version Control wizard. |
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.
This release has the following known capabilities or limitations:
The SQL Optimizer feature for DB2 for z/OS supports single-byte character sets. Double-byte or multi-byte character sets are not supported.
All product components should be configured to use the same or compatible character encodings and be installed to use the same locale and regional options.
The Knowledge Xpert feature is available with English language content only.
The Toad for DB2 release package contains the following products:
For important information about installing Toad for DB2, refer to the Toad for DB2 Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.
Caution:
|
For instructions on installing the Quest IBM DB2 z/OS component, refer to the Quest IBM DB2 z/OS Component Installation Guide. This guide is available from the Windows Start menu under 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
© 2008 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, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, InTrust, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, Vintela, Virtual DBA, 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.
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 |
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.