Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: call to get_dbsize_info hangs, why ??

    Hello all,

    I have an issue on one database DB2v8.2 on AIX 5.3 - that call to get_dbsize_info(?,?,?,0) function hangs.

    I have waited for 15 minutes only. Then I pressed Ctrl-C.

    What should I look for to investigate the cause ? I mean if I monitor via db2mon tool while executing it.

    Can it help me (db2mon) or suggest any other tool to find cause of long running query ? I understand that I have db2top available, but not used it much.

    Thanks,

    DBFinder

    ps: same thing with get_dbsize_info(?,?,?,-1)

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have you checked the status of the agent - maybe lockwait ??
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Actually, not checked.

    I will check it today, I assumed that this function queries only catalog tables.

    Correct me if I am wrong, it calculates the size by summing all used pages (tablespace) multiplied by page size.

    I will investigate today and let you know.

    Regards

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Yes, I think it looks at the tablespaces's used pages when it calculates the databasesize (this info is stored in the tablespace's control files). So, you can use list tablespaces or db2pd instead.

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Found,
    One agent querying dbsize info was hanging around for 6 days. My call was waiting for that agent to finish.

    When first agent was forced off, it returned db size promptly.

    Thanks for your support.

    DBFinder

Posting Permissions

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