Danny Torres
Follow / 14 Sep 2016 at 7:08pm / Toad for IBM DB2

Toad for DB2 - How to get the most out of this forum – Best practices...

Expand content
The better a problem is described, the better the assistance tends to be. In order to better assist with your issue at hand, please include the following information in your initial post: - Product...

The better a problem is described, the better the assistance tends to be.

In order to better assist with your issue at hand, please include the following information in your initial post:

 

-          Product, Version, and relevant environment details.

-          Include a screenshot of the problem

-          Describe the problem fully. What result was expected?

-          Can the issue be created on demand or is it intermittent?

-          If the problem can be generated faithfully, what are the exact steps to recreate the problem?

-          Any other pertinent information (see below)

 

Create Support Bundles

 You can create a support bundle and send it to Dell Support or to the Toad for IBM DB2 community Web site (peer-to-peer support). The support bundle provides information (about your application and the database) that is used to help troubleshoot problems.

 Select Help | Support Bundle. It may take time for Toad to generate the support bundle depending on your system configuration.

 

 Create Support Bundle for a SQL Query Issue

 If your issue is a SQL query issue, it is helpful if additional log files are included in the support bundle. These log files are automatically included if you generate a support bundle immediately after executing the query in either the Editor or Query Builder.

 To create a support bundle for a SQL query issue

1. In the Editor or Query Builder, reproduce the error or issue.

2. After reproducing the error, immediately select Help | Support Bundle to generate a support bundle.

3. Toad asks if you want to log the row count for each table used in the query. If you select Yes, Toad determines the size of each table used in the query. This adds additional time to the generation process, but also provides additional information about your issue.

 4. When Toad is finished generating the support bundle attach log.

  

Note: For best results, always send the entire support bundle. This provides Support with the most information about your issue and aids the troubleshooting process.

*Note: Please refrain from including private data in your posts

Be as thorough as you can with the provided info. We will reply to you as quick as possible. We are glad to assist you

 

Latest Release Information:

 This announcement includes information on our latest releases, links to our downloads and documentation and overview of new features.  This way you can stay as informed as possible:

 -          What’s New Section (why they would want to pay attention to this new version)

https://support.software.dell.com/toad-for-db2/release-notes-guides

-          Link to Download & Documentation

https://support.software.dell.com/toad-for-db2/6.2

-          Link to Trial (if applicable)

https://software.dell.com/register/54941

-          Overview of new feature(s) (with link to the release notes)

https://support.software.dell.com/toad-for-db2/release-notes-guides

 

 

Top 5 Knowledge Base Articles:

 On this post, you can find our top trending knowledge articles that other customers are inquiring about and popular solutions.

 This month’s Top Knowledge Base Articles

  1. What is new in Toad for DB2 Suites 6.2. (196996) https://support.software.dell.com/toad-for-db2/kb/196996
  2. Where can I find the License Number for Toad for DB2? (211767) https://support.software.dell.com/toad-for-db2/kb/211767
  3. VIDEO - Overview of the new dashboard features in Toad for DB2 (157889) https://support.software.dell.com/toad-for-db2/kb/157889
  4. Connection, Installing LUW cannot create a catalog entry (210787) https://support.software.dell.com/toad-for-db2/kb/210787
  5. Getting Error SQLSTATE=07001 when executing query with parameters (212011) https://support.software.dell.com/toad-for-db2/kb/212011

  Feel free to browse them. Remember to sign in to your account to view.

2720 0 / Create an account to join the discussion.
sgerper
Follow / 2 May 2018 at 5:45pm / Toad for IBM DB2
Latest post by on 14 Jun 2018 at 1:57pm

toad for db2 freeware install error (64 bit version)

Expand content
devexpress.xpf.grid dll cannot be written to, make sure you have admin rights etc etc, I start the installation from an elevated cmd prompt.if I install the 32 bit version then it installs fine.

devexpress.xpf.grid  dll cannot be written to, make sure you have admin rights etc etc,

I start the installation from an elevated cmd prompt.if I install the 32 bit version then it installs fine.

868 7 / Create an account to join the discussion.
Paul D
Follow / 24 May 2018 at 3:27pm / Toad for IBM DB2
Latest post by on 31 May 2018 at 3:39pm

Opena new file in same editor

Expand content
Is it possible to open a new file and overwrite the existing data in an open editor? I am using v6.3 Thanks, Paul

Is it possible to open a new file and overwrite the existing data in an open editor?

I am using v6.3

Thanks,

Paul

342 3 / Create an account to join the discussion.
dkirby
Follow / 21 May 2018 at 10:31pm / Toad for IBM DB2
Latest post by on 22 May 2018 at 2:53pm

date question

Expand content
I am trying to do a date calc that has me confused. i want to use a date in the past to as my starting point to get the most recent full 12 mont period 3/1/2003 = 3/1/2017 - 3/1/2018 6/1/2005 = 6/1...

I am trying to do a date calc that has me confused.   i want to use a date in the past to as my starting point to get the most recent full 12 mont period

3/1/2003  =  3/1/2017 - 3/1/2018

6/1/2005 =  6/1/2016 - 6/1/2017

does this make sense?  any help appreciated.

435 6 / Create an account to join the discussion.
DanielX
Follow / 9 May 2018 at 3:31am / Toad for IBM DB2
Latest post by on 17 May 2018 at 2:14pm

Is it able to launch Toad for DB2 4.7 and make connection to designated...

Expand content
- Version: Toad for DB2 4.7 on Win 10, DB2 Server on AIX , - Purpose: We are implementing PAM (Privilege Account Management ) so the goal is to launch Toad for DB2 4.7 and make connection to designated...

-  Version: Toad for DB2 4.7 on Win 10,  DB2 Server on AIX ,
-  Purpose: We are implementing PAM (Privilege Account Management ) so the goal is to launch Toad for DB2 4.7 and make connection to designated database with all the credentials been provided by PAM, no entry required for operators.
-  What have tried:  Searched on internet and all information I got are for Toad for Oracle, and it seems many people are using that way:  
            Toad.exe -c $Username/$Password@$Database   or  
            Toad.exe connect=$Username/$Password@$Database
            ($parameters will be substituted by PAM)

-  when using above commands in DOS command line with real credentials the Toad for DB2 just started with an empty editor window and no connection was made, and no error message.  

So I wonder if launch a connection by command line is feasible for Toad for DB2?

592 3 / Create an account to join the discussion.