Oninit cdi / Archive
Talk to an expert →

How to Find FREE Extents via Sysmaster Query

Posted in 2008

Topics: Storage & Space Management, Server Administration, Platform-Specific Issues

Clifton Bean — — source: IIUG Forums & Mailing Lists

When you perform an oncheck -pe, there are areas marked "FREE" within each dbspace. I am trying to figure out how to find these items via a sysmaster query. Thanks in advance and Happy New Year. Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics 1431 Greenway Drive #700 Irving, Texas 75038 Main (972) 812-1411 x244 Toll Free (800) 834-8807 x244 Fax (469) 417-0665

↪ replying to Clifton Bean
Art S. Kagel — — source: IIUG Forums & Mailing Lists

Clifton Bean wrote: > When you perform an oncheck -pe, there are areas marked "FREE" within each > dbspace. > > I am trying to figure out how to find these items via a sysmaster query. > SELECT * FROM sysmaster:syschfree; Art S. Kagel > Thanks in advance and Happy New Year. > > Take care. > > Clifton M. Bean > Informix DBA / AIX System Admin > Currency Technics & Metrics >

Glossary