Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Location
    Tuticorin, India
    Posts
    103

    Unanswered: Tempspace Estimation

    Env: DB2 8.2/AIX 5.3

    Is it possible to estimate tempspace requirement for a complex query before execution using explain plan or any other method ?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Tempspace tablespaces should be defined as SMS (to speed up creating tables). You should have at least enough space for the temp tablespace to grow to as large as your largest table.

    For a particular query, you would need to look places where data is spooled to a temp tablespace in the explain, so you should be able to estimate it. They are usually associated with sorts. Are you having trouble understanding the explain? If so, try the visual explain from the Control Center.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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