Toad for IBM DB2 Beta Program Community

Toad for IBM DB2 - Beta Forum

mojoala
Follow / 30 Mar 2018 at 2:00pm / Toad for IBM DB2 Beta Program
Latest post by on 13 Apr 2018 at 9:21pm

Ctrl F - How to undock this?

Expand content
The find and replace dialog. We just upgraded TOAD and the Find and Replace Dialog is no-longer undocked. I don't like it being fixed in place. It reduces my vertical real estate on my screen....

The find and replace dialog.

We just upgraded TOAD and the Find and Replace Dialog is no-longer undocked. 

I don't like it being fixed in place.  It reduces my vertical real estate on my screen. 

How do I undock it?

49 1 / Create an account to join the discussion.
Jeff Podlasek
Follow / 3 Nov 2017 at 2:53pm / Toad for IBM DB2 Beta Program
Latest post by on 12 Jan 2018 at 5:24pm

Toad DB2 beta v6.5.0.70 posted

Expand content
We just posted the Toad DB2 v6.5 Beta 6.5.0.70. That beta drop contains several fixes and extends the beta expiration into December, 2017. This installer now has a new option that can prohibit users...

We just posted the Toad DB2 v6.5 Beta 6.5.0.70.

That beta drop contains several fixes and extends the beta expiration into  December, 2017.
This installer now has a new option that can prohibit users from saving their connection profile passwords.
Please try out this new drop and let us know what you think.

You can download this new beta at:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/

422 4 / Create an account to join the discussion.
Shimonj
Follow / 21 Nov 2017 at 7:37am / Toad for IBM DB2 Beta Program
Latest post by on 4 Jan 2018 at 8:37pm

Compare Data on a Table containing CLOB corrupts the DATA in the ...

Expand content
Hi, When comparing data between two schemas, if one of the fields is a CLOB and there is a difference in aonther field, the resulting update script includes an update of the CLOB field that results in...

Hi,

When comparing data between two schemas, if one of the fields is a CLOB and there is a difference in aonther field, the resulting update script includes an update of the CLOB field that results in erroneous data. 

The update stataement does not replace the data with the data from the source but it adds part of the data to what already exists.

This behavior is similar to what I complained about here:

https://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/f/88/t/32088

Whereas that was anuisance reaulting in the way I used the resulting script, the issue I have here is clearly a BUG.

Sincerely,

Shimon J.

259 2 / Create an account to join the discussion.
Shimonj
Follow / 24 Oct 2017 at 1:41pm / Toad for IBM DB2 Beta Program
Latest post by on 21 Nov 2017 at 7:25am

Compare Data WHERE clause is not available

Expand content
Hi, I've run into this problem several times in the last few days. Using the Compare Data wizard, I am not able to enter a WHERE clause. Sincerely, Shimon J.

Hi,

I've run into this problem several times in the last few days. Using the Compare Data wizard, I am not able to enter a WHERE clause.

Sincerely,

Shimon J.

494 4 / Create an account to join the discussion.
Db2Developer
Follow / 4 Oct 2017 at 8:56pm / Toad for IBM DB2 Beta Program
Latest post by on 15 Oct 2017 at 7:30am

Color Connection on Object Explorer

Expand content
Good Afternoon, I have started using the new beta version (6.5.0.9) of TOAD and have to say I can't wait for it to go live! I really enjoy the save script to PDS member! I noticed one issue and...

Good Afternoon,

I have started using the new beta version (6.5.0.9) of TOAD and have to say I can't wait for it to go live!  I really enjoy the save script to PDS member!   

I noticed one issue and I am not sure if its a set up issue or not.  When I started Toad for the first time it usually asks me to import my settings from an older version but never did this time so I am not sure I missed the setting to enable this feature or not.  I always set up TOAD to color my background based on the connection of the database I am using. This works great helping when I am working in different environments such as development, model and production. 

In version 6.3 the object explorer would so be colored based on connection, but now it seems to always stay white.  Is this a setting I need to change or was its it a built in feature?  I thought it was a feature.  There are a few settings I change out of the gate when I first start using Toad so I might have missed it.  

Thanks for your help! And keep up the great work.

Robert

453 3 / Create an account to join the discussion.
Jeff Podlasek

Updated Toad for DB2 v6.5 Beta Drop posted

Expand content
We just posted the Toad DB2 v6.5 Beta 6.5.0.24. That beta drop contains several fixes and extends the beta expiration to November 3, 2017. You can download that beta at: http://www.toadworld.com...

We just posted the Toad DB2 v6.5 Beta 6.5.0.24.

That beta drop contains several fixes and extends the beta expiration to November 3, 2017.

You can download that beta at:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/

245 0 / Create an account to join the discussion.
Jeff Podlasek
Follow / 22 Sep 2017 at 2:49pm / Toad for IBM DB2 Beta Program
Latest post by on 25 Sep 2017 at 6:20am

Toad for DB2 v6.5 Beta Program begins

Expand content
We are pleased to announce the beginning of the Toad for DB2 v6.5 beta program. Please visit the beta program page at: http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program...

We are pleased to announce the beginning of the Toad for DB2 v6.5 beta program.

Please visit the beta program page at:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/

..to view the release notes and download the beta installer.

Some product highlights:

- For tables, indexes and tablespace, Toad now has a new object 'Overview' tab that can be customized to display information about those objects that you feel is important - on one tab!

- Dashboards have been enhanced to include a new 'Live Query' scroll-able and resize-able widget and now include the ability to quickly clone dashboards

- In the SQL Editor feature, DB2 z/OS users in can now read scripts from and write scripts to Partitioned Dataset (PDS) members on the mainframe

The beta release notes contain information on all new enhancements and features.

Please try the new beta and provide any feedback in the beta forum

Thanks.

315 1 / Create an account to join the discussion.
Jeff Podlasek
Follow / 20 Jun 2017 at 1:19pm / Toad for IBM DB2 Beta Program
Latest post by on 27 Jun 2017 at 12:48am

Toad DB2 Beta

Expand content
Our last posted beta- Toad for DB2 Beta 6.3.0.232 - expires on July 17 and will be our last posted beta in the 6.3 series...

Our last posted beta-  Toad for DB2 Beta 6.3.0.232 - expires on July 17 and will be our last posted beta in the 6.3 series...

549 2 / Create an account to join the discussion.
Shimonj
Follow / 9 Apr 2017 at 6:59am / Toad for IBM DB2 Beta Program
Latest post by on 26 Jun 2017 at 6:38pm

An attempt to allocate a handle failed because there are no more handles...

Expand content
Hi, Somtimes I need to assign a few thousand ID's ( for copying a *** of records from one environment to another). The way to do this is to incremet the sequence of DB2, assuring that no other client...

Hi,

Somtimes I need to assign a few thousand ID's ( for copying a *** of records from one environment to another). The way to do this is to incremet the sequence of DB2, assuring that no other client will insert into the ID range that I will get.

When I tried getting a NEXTVAL a few thousand times, I recieved an error.

Today this happened again when I ran a statement to update the sequence to the MAX ID that I created by copying records. According to our DB2 expert, the error was coused by the Toad driver.

972 3 / Create an account to join the discussion.
yahya.nattagh
Follow / 15 Jun 2017 at 2:36pm / Toad for IBM DB2 Beta Program
Latest post by on 19 Jun 2017 at 1:01pm

DB Parameters error message

Expand content
Selecting "DB Parameters" tab for a LUW database fails with "ERROR [42884] [IBM][DB2/AIX64] SQL0440N No authorized routine named "DB_GET_CFG" of type "FUNCTION" having...

Selecting "DB Parameters" tab for a LUW database fails with "ERROR [42884] [IBM][DB2/AIX64] SQL0440N  No authorized routine named "DB_GET_CFG" of type "FUNCTION" having compatible arguments was found."

Thank you for great work on this new version.

Toad for DB2 Beta 6.3.0.232 (32 bit)

635 3 / Create an account to join the discussion.
Db2Developer
Follow / 5 Jun 2017 at 2:44pm / Toad for IBM DB2 Beta Program
Latest post by on 13 Jun 2017 at 2:02pm

Alter table script bad delimiter

Expand content
Good Morning, I recently came across the functionality that TOAD will create alter scripts for you via the GUI (Right click on Table --> Alter table --> Change table settings) and an alter script...

Good Morning,

I recently came across the functionality that TOAD will create alter scripts for you via the GUI (Right click on Table --> Alter table --> Change table settings) and an alter script is created.

It corrects pretty good!  There is a small issue with it though.  My script is 125 lines long right now and one of the statements has the wrong delimiter for an odd reason. I think its just a issues with how the script is created.  I have changed my delimiter so # sign, but its using ; sign one line.  Here is a screen shot from a code preview.

Error Message:

I think this is a fairly easily fix; most likely an over site. 

Thanks for all the hard work with TOAD!

Toad for DB2 Beta 6.3.0.232 (64 bit) - TOAD for Db2 z/OS

701 3 / Create an account to join the discussion.
Db2Developer
Follow / 2 May 2017 at 3:23pm / Toad for IBM DB2 Beta Program
Latest post by on 5 Jun 2017 at 6:22pm

Bad Format on Date Import

Expand content
Hello, I have another suggestion (Or maybe there is a setting I need to turn one). I think this will be an easy one, but correctly its causing a lot of issues for me. I have a table in DB2 with a column...

Hello,

I have another suggestion (Or maybe there is a setting I need to turn one).  I think this will be an easy one, but correctly its causing a lot of issues for me.

I have a table in DB2 with a column defined as a varchar(120) but when I upload a spreadsheet its reformatting the date field as a time stamp with a bad formatting for db2 time stamp format.

Let me explain in greater detail.

Here is the Table DDL:


CREATE TABLE DateTEST (
ColA varchar(120)
)

Here is the spreadsheet:

Book1.xlsx

I am using the import wizard (which I Love and its a great you can create templates and just fire those templates off whenever you want).

Here is screen one of the wizard:

As you can see its keeping the format of Date. Now when we go the next screen its re-formatting the data to this:

Here is the results in the table:

The problem with this format is DB2 can't cast it as a date as I need it in the format of date when I push to final table.

When you run this SQL: Select cast(cola as date) from DateTEST

You get this error: Lookup Error - DB2 Database Error: ERROR [22007] [IBM][DB2] SQL0181N  The string representation of a datetime value is out of range.

My suggestion is can you keep it as a date field and not convert the value to a time stamp? Or better yet can you rather format the time stamp as what is stated in the settings? 

Such as this:

I know Dates and Time stamps are hard to use in Db2 for z/OS if they are not formatted correctly.

Thanks again for bringing a great product to us.

Toad for DB2 Beta 6.3.0.57 (64 bit)

1480 9 / Create an account to join the discussion.
shiva444
Follow / 29 May 2017 at 10:50am / Toad for IBM DB2 Beta Program
Latest post by on 5 Jun 2017 at 3:15pm

Unable to connect to DB2 database using toad 6.3 beta version on windows...

Expand content
Getting the below error while connecting to DB2 database. System Information ********************************************************************** Operating System Microsoft Windows 7 Professional...

Getting the below error while connecting to DB2 database.

System Information
**********************************************************************
Operating System
Microsoft Windows 7 Professional 6.1.7600 AMD64

DB Details. 

**********************************************************************

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09075" with
level identifier "08060107".
Informational tokens are "DB2 v9.7.500.4299", "special_27924", "IP23286_27924",

and Fix Pack "5".

*******************************************************************
Exception Information
**********************************************************************
Exception: System.EntryPointNotFoundException
Message : Unable to find an entry point named 'SQLFreeConnAttribsADONET' in DLL 'db2app.dll'.
Stack Trace:
at IBM.Data.DB2.UnsafeNativeMethods.DB232.SQLFreeConnAttribsADONET(DB2SQLGetConnAttribsADONETParams& pParam)
at IBM.Data.DB2.ConnSettingsFromXmlConfig.Dispose(Boolean disposing)
at IBM.Data.DB2.ConnSettingsFromXmlConfig.Finalize()

Requesting help.

750 3 / Create an account to join the discussion.
rgconrad
Follow / 31 May 2017 at 5:28pm / Toad for IBM DB2 Beta Program
Latest post by on 5 Jun 2017 at 3:13pm

DB2 connection fails

Expand content
Getting the same error in v6.0, 6.2 and 6.3. I created a new DB2 connection from a cataloged connection; when trying to open in 6.0 and 6.2 it dumps the stack trace: System.ArgumentOutOfRangeException...

Getting the same error in v6.0, 6.2 and 6.3. I created a new DB2 connection from a cataloged connection; when trying to open in 6.0 and 6.2 it dumps the stack trace:

System.ArgumentOutOfRangeException
Length cannot be less than zero.
Parameter name: length
Stack Trace:
   at IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn)
   at IBM.Data.DB2.DB2Connection.Open()
   at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
   at Quest.Toad.DB2.DB2ToadConnection.OpenConnection(IDbConnection connection)
   at Quest.Toad.Db.Connection.AllocConnection()
   at Quest.Toad.Db.Connection.Connect(Boolean notify)
   at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

In 6.3 is appears to swallow the exception, but when I set the connection to connect at startup it displays:

(1)  COT2 : Length cannot be less than zero.
Parameter name: length

Installation is on Windows Server 2012 R2 virtual machine with .NET 4.6.01055. I have the exact installation and .NET version on a Windows 7 machine that works fine, not sure what's different with this installation. I'm using an AD account with local admin access on both machines. Thanks for any help!

483 1 / Create an account to join the discussion.
qiqiangzhu
Follow / 22 Feb 2017 at 3:45pm / Toad for IBM DB2 Beta Program
Latest post by on 31 May 2017 at 1:56pm

Installation failed on new Beta 6.3.0.508

Expand content
Tried to run an install (ToadForDB2_Beta_6.3.0.508) on a Windows 7 64bit box, an Error pops up immediately: "Could not load the DLL Library C:\Users\Administrator\AppData\Local\TempCustomActions...

Tried to run an install (ToadForDB2_Beta_6.3.0.508) on a Windows 7 64bit box, an Error pops up immediately:

"Could not load the DLL Library

C:\Users\Administrator\AppData\Local\TempCustomActions.dll.

The specified module could not be found."

Please advice.

Thanks

761 4 / Create an account to join the discussion.
Paul D
Follow / 30 May 2017 at 5:20pm / Toad for IBM DB2 Beta Program
Latest post by on 31 May 2017 at 3:03am

Beta Period for Toad for DB2 6.3 Expired

Expand content
Just wondering if I need to re-install or will 6.3 be released or is there an upcoming beta version.

Just wondering if I need to re-install or will 6.3 be released or is there an upcoming beta version.

Unanswered 481 1 / Create an account to join the discussion.
martin.ebneter
Follow / 12 May 2017 at 9:36am / Toad for IBM DB2 Beta Program
Latest post by on 22 May 2017 at 7:21am

Script for Table ist not showing up

Expand content
I try to display the script for a certain z/OS table in TOAD for DB2 (6.3.0.232 (32 bit)) but it will never been shown. There ist just a Line: "-- Generating script in background" showing up...

I try to display the script for a certain z/OS table in TOAD for DB2 (6.3.0.232 (32 bit)) but it will never been shown.
There ist just a Line: "-- Generating script in background"  showing up and a Task ist running in the backgrout that cannot be canceled.
The same happens when I try to extract the DDL.

I tried to do the same in Toad 6.2. There I got a display but with a small error.There is a extra ' in front of the last X'FF': PARTITION 22 ENDING AT (X'FF',X'FF','X'FF') )

CREATE TABLE "#DB26DA1".OHPS_ADRESSE (
  PARTNER_NR INTEGER NOT NULL,
  ADRESS_NR SMALLINT NOT NULL,
  ERFASSZEIT_TS TIMESTAMP NOT NULL WITH DEFAULT,
  ART_CD SMALLINT NOT NULL WITH DEFAULT,
  SPRACH_CD SMALLINT NOT NULL WITH DEFAULT,
  ZUSTELL_CD SMALLINT NOT NULL WITH DEFAULT,
  ADRESSZUS CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT,
  STRASSE CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT,
  HAUSNUMMER CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT,
  HNRDAR_CD SMALLINT NOT NULL WITH DEFAULT,
  POSTFACH CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT,
  PLZ CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT,
  PLZ_ZUS CHARACTER(2) FOR SBCS DATA NOT NULL WITH DEFAULT,
  ORT CHARACTER(30) FOR SBCS DATA NOT NULL WITH DEFAULT,
  KANTON_CD SMALLINT NOT NULL WITH DEFAULT,
  GEMEINDENR CHARACTER(5) FOR SBCS DATA NOT NULL WITH DEFAULT,
  PROVINZ CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT,
  LAND_CD SMALLINT NOT NULL WITH DEFAULT,
  KOMBZEIL_CD SMALLINT NOT NULL WITH DEFAULT,
  ANREDE_CD SMALLINT NOT NULL WITH DEFAULT,
  TITELDAR_CD SMALLINT NOT NULL WITH DEFAULT,
  VORNDARST CHARACTER(30) FOR SBCS DATA NOT NULL WITH DEFAULT,
  NAMEDAR_CD SMALLINT NOT NULL WITH DEFAULT,
  NZUSDAR_CD SMALLINT NOT NULL WITH DEFAULT,
  NOTIZ CHARACTER(70) FOR SBCS DATA NOT NULL WITH DEFAULT,
  GLTAB_DT DATE NOT NULL WITH DEFAULT,
  GLTBIS_DT DATE NOT NULL WITH DEFAULT,
  ERFASSER CHARACTER(8) FOR SBCS DATA NOT NULL WITH DEFAULT,
  SPRACHCODE CHARACTER(1) FOR SBCS DATA NOT NULL WITH DEFAULT,
  ORT_ZUSATZ CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT,
  INTKFZ CHARACTER(3) FOR SBCS DATA NOT NULL WITH DEFAULT,
  POSTFACH_DEF SMALLINT NOT NULL WITH DEFAULT,
  HIST_TS TIMESTAMP WITH DEFAULT
  )  PARTITION BY RANGE (
    PARTNER_NR,
    ADRESS_NR,
    ERFASSZEIT_TS ) (
      PARTITION 1 ENDING AT (10399999),
      PARTITION 2 ENDING AT (10799999),
      PARTITION 3 ENDING AT (11199999),
      PARTITION 4 ENDING AT (11599999),
      PARTITION 5 ENDING AT (11999999),
      PARTITION 6 ENDING AT (12399999),
      PARTITION 7 ENDING AT (12799999),
      PARTITION 8 ENDING AT (13199999),
      PARTITION 9 ENDING AT (13599999),
      PARTITION 10 ENDING AT (13999999),
      PARTITION 11 ENDING AT (14399999),
      PARTITION 12 ENDING AT (14799999),
      PARTITION 13 ENDING AT (14999999),
      PARTITION 14 ENDING AT (15199999),
      PARTITION 15 ENDING AT (15399999),
      PARTITION 16 ENDING AT (15599999),
      PARTITION 17 ENDING AT (15799999),
      PARTITION 18 ENDING AT (15999999),
      PARTITION 19 ENDING AT (16199999),
      PARTITION 20 ENDING AT (16399999),
      PARTITION 21 ENDING AT (16599999),
      PARTITION 22 ENDING AT (X'FF',X'FF','X'FF') )
  IN DPSH002.SPSH019
  AUDIT NONE
  DATA CAPTURE NONE
  NOT VOLATILE
  APPEND NO;

Unanswered 996 4 / Create an account to join the discussion.
Db2Developer
Follow / 7 Mar 2017 at 3:41pm / Toad for IBM DB2 Beta Program
Latest post by on 28 Apr 2017 at 3:07pm

re-size widget

Expand content
Hello, I just installed the latest beta version of TOAD. So far its pretty sweet! I am digging the widgets. I was wondering if there was a future plan to allow you to re-size widgets? I created one...

Hello,

I just installed the latest beta version of TOAD. So far its pretty sweet! I am digging the widgets. 

I was wondering if there was a future plan to allow you to re-size widgets?  I created one with some SQL but it's outputting 8 columns and the widget only shows the first 4. 

Toad for DB2 Beta 6.3.0.508 (64 bit)

Thanks so much!

-Robert

776 5 / Create an account to join the discussion.
Jeff Podlasek

New Toad DB2 v6.3.0.232 beta drop is available

Expand content
We have just posted our Toad DB2 v6.3.0.232 beta drop. This drop contains our latest fixes for the product. Please download the latest beta from: http://www.toadworld.com/products/toad-for-ibm-db2...

We have just posted our Toad DB2 v6.3.0.232 beta drop. This drop contains our latest fixes for the product.

Please download the latest beta from:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/

Please post any beta feedback on the forum at:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/f/88

Thanks...

351 0 / Create an account to join the discussion.
Jeff Podlasek
Follow / 30 Mar 2017 at 9:33pm / Toad for IBM DB2 Beta Program
Latest post by on 17 Apr 2017 at 7:37pm

Toad DB2 v6.3 beta msi installers

Expand content
If you have issues installing with the exe - try these msi installers: http://community-downloads.quest.com/toadsoft/DB2/ToadForDB2_Beta_6.3.0.57.x86.msi http://community-downloads.quest.com/toadsoft...

If you have issues installing with the exe - try these msi installers:

http://community-downloads.quest.com/toadsoft/DB2/ToadForDB2_Beta_6.3.0.57.x86.msi


http://community-downloads.quest.com/toadsoft/DB2/ToadForDB2_Beta_6.3.0.57.x64.msi

Use the installer with the same bit-ness as your DB2 client....

631 3 / Create an account to join the discussion.