JDBC update takes forever.

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11
Hi Experts
I have an application runnng on an as/400.
I connect to the SQL server data base and get a record that I want to update as "processed"

When I try to perform the update the system simply hangs and all other users start to time out.

I have an index over the file by the key I am trying to update and when I run a select query in enterprise manage it takes sub second.

the update statemnt is

Update CpArchiveIndex   set Tba = '2011-01-01'
where ARC_DOCNAME ='a0d2ab215f676c4c8bcde9d6a495aa36.pdf'

ARC_DOCNAME is defined as 255 varchar null not alowed.

any ideas

Question by:daveslater
  • 3
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 200 total points
ID: 35423269
do you have a index on ARC_DOCNAME ?
do you have a trigger (on update) on the table?
LVL 14

Author Comment

ID: 35423286
Yes I have an index on Arc_Docname
No there are not ay triggers

LVL 14

Accepted Solution

Daniel_PL earned 800 total points
ID: 35423297
Trying to run DML operation on DB2 from SQL Server over linked server requires to turn on Journaling for the destination object. Maybe it applies to rewerse direction also?
LVL 14

Author Comment

ID: 35423308
I can run the updates via a VBA application using the same update string.

LVL 14

Author Closing Comment

ID: 37024400
tidy up - I would like to get to the bottom of it evebntually.

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question