Toad® for IBM DB2

Version 3.1  (Click here for previous versions)

Release Notes

February 2008


Contents

Welcome to
Toad for DB2

New in this Release

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

Upgrade and Compatibility

System Requirements

Global Operations

Getting Started

For More Information


Welcome to Toad for DB2

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.


New in This Release

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.

 

Updates in Toad for DB2 3.1

This release includes updates in the following areas:

General

Database Administration

Data Management

Query Development

 

New Features in Toad for DB2 3.1

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.

General

Database Administration

Query Development

 

Version Control


Resolved Issues and Enhancements

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:

 

Resolved Issues and Enhancements in 3.1

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

 


Known Issues

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
Object reference not set to an instance of an object.
Stack Trace:
   at Quest.Toad.DB2.Common.DB2Utils.EnumerateClients
   (ClientInfo&defaultClient)
   at Quest.Toad.DB.DB2Provider..ctor()"

Workaround:
If you encounter the above error when you start up a remaining Toad product, do the following:

  1. Close the Toad product.
  2. Select Start | Programs | IBM DB2 | Toad_DB2_copy | Setup Tools | Default DB2 Selection Wizard, where Toad_DB2_copy is the DB2-installed copy of the Toad product (for example, TOADC31).
  3. Run the Default DB2 Selection wizard, specifying the Toad product as the default DB2 copy.
  4. Restart the Toad product.
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:
Use either method:

  • Use the Client Configuration wizard to import connections.
  • Right-click the Toad for DB2 icon on your desktop, and select Run as. On the Run As window, select The following user and specify an administrator in the User name field. This workaround should enable you to use the Add Catalog Entry feature in the Client Configuration wizard to catalog databases.
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:
If performance issues do arise and caching is enabled (that is, Enable caching is selected in Toad on the Tools | Options | Database | Cache page), do the following to help maximize performance: Verify that the Maximum in-memory size value specified on the Cache page is greater than or equal to the Current in-memory value displayed. If necessary, increase the Maximum in-memory size value.

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:
  • Triggers
  • Procedures
  • Functions
  • Users
  • Hosts
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:

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.dndp.doc/htm/frlrfIBMDataDB2DB2CommandClassCommandTextTopic.htm

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.


Note: This issue does not affect Excel 2000 or 2003.

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:
Include "user@" in the Provider Information Server field. Information in the Server field should use the following format:

:sspi:user@server:/cvsrepository

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


If you do not specify user@, CVS or CVSNT assumes that the user name is the ID that is logged on to the computer. This ID might not be valid for connecting to the CVS or CVSNT server.

CR#228200
(CVS only) You cannot successfully configure CVS using the SSH protocol.
 

Workaround:

  1. If the CVS binary is not accessible from the user's SSH home directory, set the CVS_SERVER environment variable on the client to enable the Unix shell account to access the CVS binary:

CVS_SERVER=CVSbinaryPath

where /CVSbinaryPath is your path for the CVS binary.

(To display the list of environment variables to edit, right-click My Computer, and select Properties. From the System Properties window, select the Advanced tab, and click Environment Variables.)

  1. Run the client from a command prompt so that the user's password for the server gets cached. (You cannot enter the password within Toad.)

cvs -d ":ssh:user@server:repositoryPath" login

where repositoryPath is your path to the CVS repository.

  1. Start Toad for DB2, and configure CVS (through the Options window), entering :ssh:user@server:repositoryPath as the server string in the Server field.
  2. Log in to CVS.
CR#228718

 


Third Party Known Issues

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:
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:
Refer to the following IBM documentation for an explanation and a solution:

http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc=DB520&q1=DML&uid=swg21208123&loc=en_US&cs=utf-8&lang=en

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
CR#133139

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:
Perform the following:

  1. Click the Filter Data icon in the data grid.
  2. Select the SQL tab.
  3. Select the Enable custom SQL checkbox.
  4. Enter a query that casts the decimal column as a character data type with 32 characters similar to the following:

SELECT COLUMN, CAST ("DECIMALCOLUMN" AS CHAR (32)) AS DECIMAL FROM DB2ADMIN.TESTDECIMAL

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:
Use the Editor to insert data into tables that include the "Generated always as" option set.

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:
To avoid the heap memory issue, increase the application heap size on the server.

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:
You can use either of the following methods as a workaround:

  • Select the schema that you are logged into and fully qualify the schema name for the objects.
  • Issue a SET CURRENT SQLID statement to set the schema on which you want to create objects.
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:
 

2003 PIAs
http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en

2007 PIAs
http://www.microsoft.com/downloads/details.aspx?FamilyID=59DAEBAA-BED4-4282-A28CB864D8BFA513&displaylang=en

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

 


Upgrade and Compatibility

Please review upgrade information in the Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for DB2 | Documentation.

 


System Requirements

Verify that your system meets the minimum requirements described in the following sections:

Client Requirements

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:

  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
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
Microsoft .NET Framework 2.0 or later

Note: In order to run Toad, the .NET security policy must be set to unrestricted. For more information, see User Privilege Requirements.

Browser
Microsoft Internet Explorer 6.0

PDF Viewer
Adobe® Acrobat® Reader 5.0 or later (for viewing the Toad for DB2 Getting Started Guide)

Other Requirements SVGA monitor with a minimum resolution of 800x600, 1024x768 recommended

 

Server Requirements

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:

  • IBM AIX 5.1, 5.2, 5.3, 6.1
  • HP-UX 11i 1.5, 2 (32- and 64-bit)
  • Red Hat Enterprise Linux AS release 3 and 4 (32- and 64-bit)
  • Solaris 7, 8, 9, 10 (32- and 64-bit)
  • SuSE 7, 8, 9
  • Windows 2000, 2003 (including 64-bit), XP

 

User Privilege Requirements

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.

Citrix Requirements

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.

LDAP Requirements

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

  1. Open the Command Window for the DB2 client installed with Toad by selecting Start | All Programs | IBM DB2 | <ToadCom, ToadEval, or ToadFree> | Command Line Tools | Command Window.
  2. Type the following command to enable LDAP support:

db2set DB2_ENABLE_LDAP=YES

  1. Type the following command to specify the TCP/IP host name and port number of the LDAP server:

db2set DB2LDAPHOST=hostname[:port]

The port number defaults to 389 (default LDAP port) if you leave the port number blank.

  1. Exit the Command Window.
  2. Launch Toad and open the New Connection window.

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

Compile and Debug Requirements for Stored SQL Procedures

The following are the requirements for using Toad to compile and debug stored SQL procedures in DB2 for z/OS.

Toad Client Requirements

To use the Toad debugger on stored SQL procedures, the following Toad client requirement must be met:

DB2 Subsystem Requirements

Each DB2 subsystem on which you want to compile and debug stored SQL procedures must meet these requirements:

Requirements for Executing DB2 for z/OS Utilities

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.

Recommended Indexes to Improve Toad Performance in DB2 for z/OS

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;

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;
 

Requirements for Object Migration

Adhere to these requirements when you use the Toad's Schema Migration wizard to migrate DB2 objects and their dependencies.

Methods for Handling Target Tablespaces

You must handle target tablespaces in one of two ways:

Migration of Tables with Referential-Integrity Relationships

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.

Additional Special Specifications for Sources and Targets

The following requirements and restrictions exist for source and targets:

Version Control Requirements

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.

 


Global Operations

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:


Getting Started

Contents of the Release Package

The Toad for DB2 release package contains the following products:

  1. Toad for DB2 3.1
  2. Quest IBM DB2 z/OS component
  3. Product Documentation, including:

Installation Instructions

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:
  • Do not attempt to manually import catalog entries from the IBM CLP window provided with Toad. If you have any DB2 ODBC entries, db2cfimp will overwrite your existing ODBC system DSN entries and can cause previously configured DB2 ODBC connections to stop working.
  • 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.

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.


For More Information

Contacting Quest Software:

Email info@quest.com
Mail Quest Software, Inc.
World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656
USA
Web

http://www.quest.com

Refer to our Web site for regional and international office information.

Contacting Quest Support:

(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.

 

Yahoo Group

(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
 

www.quest.com

Email: legal@quest.com

Refer to our web site for regional and international office information.

Trademarks

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

Disclaimer

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.