query timeout - DB2 Database

Similar topics

by: Stefano | last post by:

Hi everibody, it's the first time i post on this newsgroup. I'm Stefano from Milano, italy. I'm a beginners with Sql2000. My problem is this. I run a View using enterprise manager and after less...

Microsoft SQL Server

query timeout

by: Philip.M.Collins | last post by:

It looks like mysql doesn't have the ability to set a query timeout. Is this true? So in the mean time I created the following perl DBI script to do it for me. #!perl # DBI service name use...

MySQL Database

Access SQL query incompatability (nolock)

by: Robert | last post by:

Greetings I am assisting a developer with an Access application performance problem and an ODBC timeout. In a nutshell they have a combo box with a drop down that queries a lookup table on a SQL...

Microsoft Access / VBA

Cancel query based on a timeout

by: Stijn Vanroye | last post by:

Hi List, I'm running a query on a not-so-small db. Mostly this query runs fast enough, but every once in a while the query takes a long time to complete in wich case the users start banging away...

PostgreSQL Database

Different query plans

by: traceable1 | last post by:

I have 2 SQL databases which are the same and are giving me different query plans. select s.* from hlresults h inner join specimens s on s.specimen_tk = h.specimen_tk where s.site_tk = 9 and...

Microsoft SQL Server

Table Query Timeout Problem very specific

by: msmith | last post by:

MSSQL Server 2000 SP3 in both houston and memphis I have a database in houston, lets call it RED. Specific tables from database RED are copied to database BLUE. Database BLUE is then backed...

Microsoft SQL Server

Query with Group By Causes TimeOut Error

by: laurenquantrell | last post by:

I have a table with 6 million rows. I'm trying to perform a group by query that incudes a row count of the PK column: SELECT COUNT(DataID) AS Cnt, Column1Name FROM dbo.TableName WHERE...

Microsoft SQL Server

Group By Query Casues TimeOut Error

by: laurenquantrell | last post by:

I have a table with 6 million rows. I'm trying to perform a group by query that incudes a row count of the PK column: SELECT COUNT(DataID) AS Cnt, Column1Name FROM dbo.TableName WHERE...

Microsoft SQL Server

Odbc SQL Query Timeout Error - VB.Net

by: nilaangel78 | last post by:

Hi, I am developing winforms project using vb.net. In this i am connecting SQL 2000 DB using odbc connection. When i run SQL select query i am getting timeout error. But the same select query...

.NET Framework

Doing a query through php to sql server 2005 and get query timeout

by: mikek12004 | last post by:

doing a (not so simple) query -which works fine in sql server using PDO like this: // attempt a connection try { $pdo = new...

Microsoft SQL Server

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...

Oracle Database

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...

General

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...

General

FPGA Question

by: Oralloy | last post by:

Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...

General

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...

General

Mastering Python: A Versatile Programming Language for All

by: Rahul1995seven | last post by:

Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

General

Problems to capture mouse_down event on a control within a form with lots of controls

by: Ricardo de Mila | last post by:

Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

Microsoft Access / VBA