Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    1

    Unanswered: DB2 Query taking different execution times in different schemas..

    Hi,
    I am facing a problem in DB2 (ZOS) that I could not resolve.
    While running a query say in DSNV I am getting good response time. The query is getting executed as per our expectation.

    But while I am running the same query in other Schemas say DSNT, the query is taking huge time to execute. I had also tried to run the query in other available schemas like DSNA,DSNB,DSNC etc.., but didn't succeed.

    The Query is an Update query that fires a trigger which inserts a new record in the history table (kept as a backup/log of the records in parent table).

    I had tried the following options:
    1. Ran the EXPLAIN for DSNV and DSNT and found the access path to be exactly the same.
    2. Ran REORG and RUNSTAT for DSNT
    3. Compared the INDEXES and TRIGGERS in both DSNV and DSNT
    4. CHECKED the parameters in SYSTABLES and SYSTABLESPACES and found the entries to match.

    Please suggest....

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Are DSNV and DSNT running on the same lpar?

    Does one have priority?

    Are the same data content both places?

    When you say "it didn't succeed" does this mean an abend, unexpected results, or that these all ran too long?

    How is "too long" defined?

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    ... DSNA,DSNB,DSNC etc.., but didn't succeed.
    Are these worked same as DSNV? (DSNT is specific)
    Or, are these worked same as DSNT? (DSNV is specific)
    Or, are these doesn't work(an abend, unexpected results, so on...)?

    The Query is an Update query that fires a trigger which inserts a new record in the history table ...
    Are there any differences in the history table?

Posting Permissions

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