JDBC update takes forever.

Posted on 2011-04-19
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
    LVL 142

    Assisted Solution

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

    Author Comment

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

    LVL 14

    Accepted Solution

    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

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

    LVL 14

    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now