Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2006
    Posts
    56

    Unanswered: Finding, estimating, and setting table storage space

    I need this for both Sybase and DB2.

    Is there a SQL command or executable that can tell me the current disk space allocation for a table? As well as setting the size.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    moving thread to Sybase forum

    not really appropriate for Standard Query Language forum

    once you get your Sybase answer, you might consider having it moved on to the DB2 forum, or start a separate thread there (yes, normally we discourage cross-posting, but this appears to be an exception)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2006
    Posts
    56
    Quote Originally Posted by r937
    moving thread to Sybase forum

    not really appropriate for Standard Query Language forum

    once you get your Sybase answer, you might consider having it moved on to the DB2 forum, or start a separate thread there (yes, normally we discourage cross-posting, but this appears to be an exception)

    Yes, I wanted to avoid cross-posting. That is why I put it in a generic forum.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by mburke
    Yes, I wanted to avoid cross-posting. That is why I put it in a generic forum.
    yes, i understand, but the SQL forum is not a "generic" forum, it is a forum specifically for the purpose of discussing the Structured Query Language

    the only way SQL might help you is if the answer is in the INFORMATION_SCHEMA views

    see http://www.dbazine.com/db2/db2-disarticles/pelzer4
    Last edited by r937; 08-31-06 at 15:07.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Quote Originally Posted by mburke
    I need this for both Sybase and DB2.

    Is there a SQL command or executable that can tell me the current disk space allocation for a table?
    For Sybase:
    sp_spaceused [objname]

  6. #6
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    sp_estspace <table_name> can also provide a rough estimate of table storage space required.

Posting Permissions

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