Free space in an extent

Hello, I am trying to find out how much room is left in dbspace. The output from an onstat -d shows all chunks for that dbspace as full ( 0 free pages) however the next extent size was set rather large so I know we have some room left, I just don't know how much. I am trying the sysextents table in the sysmaster db without much to show for my efforts. Any ideas? Thanks. --- W. Bronson Tubb, Jr. Rotech Systems Group btubb@rotech.com 321.235.3100 ---

oncheck -pt database:table ? "Bronson Tubb" <btubb@rotech.com> wrote in message news:bab6r3$6be$1@terabinaries.xmission.com... > > Hello, > I am trying to find out how much room is left in dbspace. The output > from an onstat -d shows all chunks for that dbspace as full ( 0 free > pages) however the next extent size was set rather large so I know we > have some room left, I just don't know how much. I am trying the > sysextents table in the sysmaster db without much to show for my > efforts. Any ideas? > Thanks. > > --- > W. Bronson Tubb, Jr. > Rotech Systems Group > btubb@rotech.com > 321.235.3100 > --- > > > >

You might try something along the lines of Select ptn.partnum, (ptn.nptotal-ptn.npdata) free FROM sysptnhdr ptn WHERE group by 1 You can join to systabnames if you want to get the table name, or use DBINFO to get the dbspace name... Hope this helps, Will "Bronson Tubb" <btubb@rotech.com> wrote in message news:<bab6r3$6be$1@terabinaries.xmission.com>... > Hello, > I am trying to find out how much room is left in dbspace. The output > from an onstat -d shows all chunks for that dbspace as full ( 0 free > pages) however the next extent size was set rather large so I know we > have some room left, I just don't know how much. I am trying the > sysextents table in the sysmaster db without much to show for my > efforts. Any ideas? > Thanks. > > --- > W. Bronson Tubb, Jr. > Rotech Systems Group > btubb@rotech.com > 321.235.3100 > ---