Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: DB2 application running slow

    Hi,
    DB2 V8.2 ON WINDOWN2003

    Can someone help on this issue pls?

    Since we have implemented the HADR, one of the weekly MIS application running very very slowley. Normaly takes 8 hours to run. But this week it took over 14 hours and still running.
    Appart from this application no one logged on to the system.
    I have checked the locks , applications snapshot and i could not find any thing.
    This application creates lots of temp tables and does export and import too. I have noticed it has produced over 500 transaction logs and each logs size is 10mb.

    Is it possible that the HADR is slowing down this applications? how can i trouble shoot this further?
    Please post your comments. Thanks.
    Dgunas

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by dgunas

    Is it possible that the HADR is slowing down this applications?
    It could, if HADR_SYNCMODE were set to SYNC.
    Quote Originally Posted by dgunas
    how can i trouble shoot this further?
    Check the database configuration.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    slow

    Thanks Nick.
    It has been set to NEAR SYNC.

    DB CFG looks ok. any specific parameter ?

    Regards, Dgunas

  4. #4
    Join Date
    Sep 2003
    Posts
    237
    Set the HADR_SYNCMODE = ASYNC
    I am suspecting you have a slow tcpip network; with near sync, primary database has to receive acknowledgement from the standby system that the logs have also been written to main memory on the standby system;

    ASYNC:
    In this mode, log writes are considered successful when they
    have been delivered to the TCP layer of the primary system’s host
    machine. Because the primary system does not wait for acknowledgement
    from the standby system, transactions might be considered committed
    when they are still on their way to the standby.
    A slow network would explain the extra 6 or more hours using HADR.
    mota

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •