Explanation of tbcheck -pt output

--openmail-part-03f2139e-00000002 Content-Type: text/plain; charset=ISO-8859-1; name="BDY.RTF" Content-Disposition: inline; filename="BDY.RTF" Content-Transfer-Encoding: 8bit Hi, The following is the output of the command tbcheck -pt for a table in my database : ... ... Maximum row size 1549 Number of special columns 5 Number of keys 6 Number of extents 32 Current serial value 1 First extent size 460800 Next extent size 184320 Number of pages allocated 5312017 Number of pages used 5246787 Number of data pages 3134215 Number of data bytes 554916459 Number of rows 3134215 ... ... Need the answer for the following questions: 1. Why is there a difference between pages allocated and pages used ? 2. When monitoring on a daily basis only the value of data pages increases. Pages used stays constant. Why? 3. How do I find out the actual space usage of the table ? 4. When is the next extent added to a tblspace and how does it compute the space required ? I am trying to develop a utily that will send out a warning when the tablespace reaches a threshold limit of say 80% Thanks in advance Jinu Joseph --openmail-part-03f2139e-00000002 Content-Type: application/rtf; name="BDY.RTF" Content-Disposition: attachment; filename="BDY.RTF" Content-Transfer-Encoding: base64 e1xydGYxXGFuc2lcYW5zaWNwZzEyNTBcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYw XGZzd2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmls XGZjaGFyc2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5l dzt9fQ0Ke1xjb2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1 NTt9DQpcdWMxXHBhcmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwXGNmMCBIaSxccGFyDQpU aGUgZm9sbG93aW5nIGlzIHRoZSBvdXRwdXQgb2YgdGhlIGNvbW1hbmQgdGJjaGVjayAtcHQg Zm9yIGEgdGFibGUgaW4gbXkgZGF0YWJhc2UgOlxwYXINCi4uLlxwYXINCi4uLlxwYXINCiAg ICBNYXhpbXVtIHJvdyBzaXplICAgICAgICAgICAgICAgMTU0OVxwYXINCiAgICBOdW1iZXIg b2Ygc3BlY2lhbCBjb2x1bW5zICAgICAgNVxwYXINCiAgICBOdW1iZXIgb2Yga2V5cyAgICAg ICAgICAgICAgICAgNlxwYXINCiAgICBOdW1iZXIgb2YgZXh0ZW50cyAgICAgICAgICAgICAg MzJccGFyDQogICAgQ3VycmVudCBzZXJpYWwgdmFsdWUgICAgICAgICAgIDFccGFyDQogICAg Rmlyc3QgZXh0ZW50IHNpemUgICAgICAgICAgICAgIDQ2MDgwMFxwYXINCiAgICBOZXh0IGV4 dGVudCBzaXplICAgICAgICAgICAgICAgMTg0MzIwXHBhcg0KICAgIE51bWJlciBvZiBwYWdl cyBhbGxvY2F0ZWQgICAgICA1MzEyMDE3XHBhcg0KICAgIE51bWJlciBvZiBwYWdlcyB1c2Vk ICAgICAgICAgICA1MjQ2Nzg3XHBhcg0KICAgIE51bWJlciBvZiBkYXRhIHBhZ2VzICAgICAg ICAgICAzMTM0MjE1XHBhcg0KICAgIE51bWJlciBvZiBkYXRhIGJ5dGVzICAgICAgICAgICA1 NTQ5MTY0NTlccGFyDQogICAgTnVtYmVyIG9mIHJvd3MgICAgICAgICAgICAgICAgIDMxMzQy MTVccGFyDQouLi5ccGFyDQouLi5ccGFyDQpccGFyDQpOZWVkIHRoZSBhbnN3ZXIgZm9yIHRo ZSBmb2xsb3dpbmcgcXVlc3Rpb25zOlxwYXINCjEuIFdoeSBpcyB0aGVyZSBhIGRpZmZlcmVu Y2UgYmV0d2VlbiBwYWdlcyBhbGxvY2F0ZWQgYW5kIHBhZ2VzIHVzZWQgP1xwYXINCjIuIFdo ZW4gbW9uaXRvcmluZyBvbiBhIGRhaWx5IGJhc2lzIG9ubHkgdGhlIHZhbHVlIG9mIGRhdGEg cGFnZXMgaW5jcmVhc2VzLiBQYWdlcyB1c2VkIHN0YXlzIGNvbnN0YW50LiBXaHk/XHBhcg0K My4gSG93IGRvIEkgZmluZCBvdXQgdGhlIGFjdHVhbCBzcGFjZSB1c2FnZSBvZiB0aGUgdGFi bGUgP1xwYXINCjQuIFdoZW4gaXMgdGhlIG5leHQgZXh0ZW50IGFkZGVkIHRvIGEgdGJsc3Bh Y2UgYW5kIGhvdyBkb2VzIGl0IGNvbXB1dGUgdGhlIHNwYWNlIHJlcXVpcmVkID9ccGFyDQpc cGFyDQpJIGFtIHRyeWluZyB0byBkZXZlbG9wIGEgdXRpbHkgdGhhdCB3aWxsIHNlbmQgb3V0 IGEgd2FybmluZyB3aGVuIHRoZSB0YWJsZXNwYWNlIHJlYWNoZXMgYSB0aHJlc2hvbGQgbGlt aXQgb2Ygc2F5IDgwJVxwYXINClxwYXINClRoYW5rcyBpbiBhZHZhbmNlXHBhcg0KSmludSBK b3NlcGhccGFyDQp9 --openmail-part-03f2139e-00000002--