Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    18

    Unanswered: % of free blob chunk (XPS)

    Hi

    I would like to have help in forming qurey to find % of free blob chunk in XPS machines, (i know in IDS its related to pagesize buts hows it in XPS?)

    does Qurey below hold good?

    SELECT name, round(sum(chksize),0), round(sum(chksize),0) - sum(nfree), sum(nfree), round(sum(nfree),0) / round(sum(chksize),0)*100 FROM sysdbstab d, syschunks c WHERE ((d.dbsnum = c.dbsnum) AND (is_blobchunk=1)

  2. #2
    Join Date
    Nov 2008
    Posts
    18
    SELECT name, round(sum(chksize),0), round(sum(chksize),0) - sum(nfree),
    sum(nfree), round(sum(nfree),0) / round(sum(chksize),0)*100
    FROM sysdbstab d, syschunks c
    WHERE ((d.dbsnum = c.dbsnum) AND (prtpage=0) )

    or is this the right one?

Posting Permissions

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