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.

3018 0 / Create an account to join the discussion.
villalva11
Follow / 4 Jul 2018 at 7:33pm / Toad for IBM DB2
Latest post by on 16 Jul 2018 at 3:51pm

Issue with a SELECT ... FOR UPDATE DB2 11.1

Expand content
Hi! We are a issue in our database DB2 11.1 with a SELECT ... FOR UPDATE which is executed many time by seconds and it is generating many locks and the applications hangs. SQL_TEXT: SELECT flag1,flag2...

Hi!

We are a issue in our database DB2 11.1 with a SELECT ... FOR UPDATE which is executed many time by seconds and it is generating many locks and the applications hangs.

SQL_TEXT:
SELECT flag1,flag2,flag3,status1,status2,status3,status4,status5,status_ext,device_fitness,cassette_fitness,configid,last_cmdtype,last_txntype,oar_screen,lastmsg_time,trace,tpdu,emv_identifier,language,pcode,respcode,acct_num,acct_num2,tvn,luno,cap_date,msg_coord_num,oar_line,model_specific,node, cassette_dispense, statetablename, statetablever, fault, severity, availdate, availtime,cmdmbid, balancerid, site_id, shclog_id, last_modify_dttime FROM atmdevicestate WHERE institutionid = ? and group_name = ? and unit = ? FOR UPDATE


The ATMDEVICESTATE table only has 1063 rows and two indexes:

INDEX ATMDEVICESTATE_1 ("LASTMSG_TIME" ASC,"GROUP_NAME" ASC,"UNIT" ASC) COMPRESS YES INCLUDE NULL KEYS ALLOW REVERSE SCANS
UNIQUE INDEX ATMDEVICESTATE_IX ("INSTITUTIONID" ASC, "GROUP_NAME" ASC,"UNIT" ASC) COMPRESS YES INCLUDE NULL KEYS ALLOW REVERSE SCANS


Is there a way to prevent these locks generated by the application in the database by SELECT ... FOR UPDATE with some parameter in the instace/database or howto can avoid this locks ???

In the top 5 SQL by executions appears the sentences SELECT...FOR UPDATE, the UPDATE of CURSOR and SELECT, the tree for the same table ATMDEVICESTATE:

EXECUTIONS TIME_SECONDS TEXT
-------------------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4617270 0 SELECT flag1,flag2,flag3,status1,status2,status3,status4,status5,status_ext,device_fitness,cassette_fitness,configid,last_cmdtype,last_txntype,oar_screen,lastmsg_time,trace,tpdu,emv_identifier,language,pcode,respcode,acct_num,acct_num2,tvn,luno,cap_date,msg_coord_num,oar_line,model_specific,node, cassette_dispense, statetablename, statetablever, fault, severity, availdate, availtime,cmdmbid, balancerid, site_id, shclog_id, last_modify_dttime FROM atmdevicestate WHERE institutionid = ? and group_name = ? and unit = ? FOR UPDATE
4616826 0 UPDATE atmdevicestate SET flag1 = ?,flag2 = ?,flag3 = ?,status1 = ?,status2 = ?,status3 = ?,status4 = ?,status5 = ?,status_ext = ?,device_fitness = ?,cassette_fitness = ?,configid = ?,last_cmdtype = ?,last_txntype = ?,oar_screen = ?,lastmsg_time = ?,trace = ?,tpdu = ?,emv_identifier = ?,language = ?,pcode = ?,respcode = ?,acct_num = ?,acct_num2 = ?,tvn = ?,luno = ?,cap_date = ?,msg_coord_num = ?,oar_line = ?,model_specific = ?,node = ?, cassette_dispense = ?, statetablename = ?, statetablever = ?, fault = ?, severity = ?, availdate = ?, availtime = ?,cmdmbid = ?, balancerid = ?, site_id = ?, shclog_id = ?, last_modify_dttime = ? WHERE CURRENT OF SQL_CURSH200C4
3174610 0 SELECT flag1,flag2,flag3,status1,status2,status3,status4,status5,status_ext,device_fitness,cassette_fitness,configid,last_cmdtype,last_txntype,oar_screen,lastmsg_time,trace,tpdu,emv_identifier,language,pcode,respcode,acct_num,acct_num2,tvn,luno,cap_date,msg_coord_num,oar_line,model_specific,node, cassette_dispense, statetablename, statetablever, fault, severity, availdate, availtime,cmdmbid, balancerid, site_id, shclog_id, last_modify_dttime FROM atmdevicestate WHERE institutionid = ? and group_name = ? and unit = ?


We are think it's a programming issue, but the applications say than is a problem with the db2sync since his analysis they are observed high time in commits/checkpoints in the database

IBM team said there is no way to avoid this locks. We are check isolation level but we do not know what level of isolation is recommended to reduce/avoid blocking in the application side ???


-> The history file is less than 5 mb
-> Lock waits are not so high in the snapshots
-> Query execution times are good


Thks !

297 8 / Create an account to join the discussion.
voorkey
Follow / 10 Jul 2018 at 4:30pm / Toad for IBM DB2

DB2 LUW Restricted database - Permissions to be granted for READ ...

Expand content
Hi, We created a DB2 restrictive database and trying to grant permissions for READ / SELECT ONLY Unix group so they have minimum level of access and yet are able to SELECT from application objects /...

Hi,

We created a DB2 restrictive database and trying to grant permissions for READ / SELECT ONLY Unix group so they have minimum level of access and yet are able to SELECT from application objects / tables.  Does anyone know what are the system objects (we are fine with application objects) to which access needs to be granted?  Checked with IBM and they are asking to contact TOAD for list.  Temporarily granted DATAACCESS capability in dev to the READ / SELECT group, but that is too much access for this group.

OS - Linux

DB2 LUW version - 10.5

Toad data Point 4.0.0.624

Thanks for your time!

Unanswered 73 0 / Create an account to join the discussion.
JRSK
Follow / 6 Jul 2018 at 6:31pm / Toad for IBM DB2
Latest post by on 9 Jul 2018 at 12:28pm

SQLSTATE=58005 - InnerException Message "No data exists for the...

Expand content
Hi, One of my customer is using TOAD to connect to our DB2 Reporting Database. When they run a SELECT query, they are getting the below error. Because of the InnerException Message "No data...

Hi,

One of my customer is using TOAD to connect to our DB2 Reporting Database. 

When they run a SELECT query, they are getting the below error. 

Because of the InnerException Message "No data exists for the row/column." , the customer is thinking that this error is coming because of a data issue in the table. 

But, when I run the same SELECT query in DB2 SPUFI, I am not getting any error. 

Has anyone come across this issue before and identified the root cause. If yes, could you please share your findings. 

Appreciate any help on this. Thanks. 

Error Message: 

DB2 Database Error: ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in  Process: 45924 Thread 33 AppDomain: Name:toad.exe

There are no context policies.

Function: DB2DataReader.Read()

CallStack:    at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

   at System.Environment.get_StackTrace()

   at IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception exception, Boolean bThrow)

   at IBM.Data.DB2.DB2DataReader.Read()

   at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()

   at Quest.Toad.Db.ToadDataAdapter.InternalFillBackground()

   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)

  at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

   at System.Threading.ThreadHelper.ThreadStart() InnerException Message: No data exists for the row/column. Check InnerException property for more detail.  SQLSTATE=58005

SQL Query: 

SELECT V02.MEMBER_ID
FROM VIEW_V01 V01,
VIEW_V02 V02
WHERE V02.MEMBER_ID = V01.MEMBER_ID
AND V01.EFF_END_DATE >= '20180605'
AND V02.EFF_MONTH =
( SELECT MAX(EFF_MONTH)
FROM VIEW_V02
WHERE MEMBER_ID = V02.MEMBER_ID )

Unanswered 208 1 / 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.

1401 7 / Create an account to join the discussion.