Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    13

    Question Unanswered: snapshot functions dont return page_size

    Hi

    I am using this query for getting the capacity information.

    SELECT tablespace.tablespace_id tablespaceid, tablespace.tablespace_name caption , tablespace.tablespace_type tablespacetype,tablespace.tablespace_state tablespacestate,tablespace.bufferpool_id, (tablespace.used_pages * page_size) usedspace,(tablespace.free_pages * page_size) freespace, (tablespace.total_pages * page_size) allocatedspace, page_size, tablespace.num_containers, tbs_contents_type FROM TABLE( SNAPSHOT_TBS_CFG('dwctrldb',-2) ) as tablespace

    But the page_size is not getting returned there by the capacity is coming (-)

    i am using UDB 8.1 on a windows box.

    any idea why the page_size is coming (-)

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    tbs

    last modif on this function is fp4
    anyhow it does return page_size in higher version
    db2admin:/cygdrive/c/workdir: db2 "select page_size from table(SNAPSHOT


    PAGE_SIZE
    --------------------
    4096
    4096
    4096
    32768
    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
  •