Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Bangalore
    Posts
    8

    Smile Unanswered: Which table gives me Tablesize or tablespace size.

    Hi,
    Can somebody tell me which system table gives me the actual Size of the tablespace? I need it for programmatically allocating spaces...
    thanks
    Vijay S

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    ts size

    for dms : db2 list tablespaces show detail --> size of ts
    for sms : same command will show the current size
    in sysibm.systables wil give an idea of active pages if runstats up-to-date
    best regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Jun 2004
    Location
    Bangalore
    Posts
    8
    I ran this command in db2 command line window.. (Db2 for OS/390 Ver 7.1)

    It says "SQL1651N The request cannot be executed because the DB2 server version does not support this functionality."
    when I say C:\> db2 list tablespaces show detail

    Any clue?
    Thanks ...

  4. #4
    Join Date
    Nov 2004
    Posts
    374

    size

    It was not indicated which target platform..
    this command was for db2 udb ...
    have a look at npages in sysibm.systables that gives nbr of pages allocated for this table .. do sum(npages) group by tbspace
    Hope this will help
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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