Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2014
    Posts
    1

    Red face Unanswered: Catalog Query performance slow

    hi,

    I have an issue with catalog tables in DB2, when I query the db2 catalog tables, its taking more time to fetch a data. Please help me on this

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    its taking more time to fetch a data
    Compared with what?
    (more time than what?)

    when I query the db2 catalog tables
    What query did you executed?


    Anyway,
    the first thing you should clarify might be DB2 version/release and platform OS.

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    also try explain your query you might be able to answer your own question as to why it is taking more time to fetch data.
    Dave

Tags for this Thread

Posting Permissions

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