Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: how to estimate space required for Dataabase

    Dear all,

    What are the factors i have to consider while estimating space required for database for the for upcoming one year, other than containers (for DMS), logpath in db cfg
    i found logarchmeth1=TSM for some servers and logarchmeth1=off for some servers
    thnx in advance...............

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You need free space for SMS tablespaces, typically used for system temporary tablespaces. These may grow to as a large as you biggest table temporarily during a query or utility operation.
    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
  •