Re: Size of the archive

Jacob Salomon wrote: > > Hi Family, > > for a specialized reason, my user needs to run an archive (ontape) to > save to a flat file instead of to the tape. He first wanted to know > about how big it should be so I ran the following query: > > select sum(ti_npused) used_pages, sum(ti_nptotal) total_pages > from sysmaster:systabinfo > -- I do not know ver 7xx, but in ver 5.xx, the number in npused is often totally gone... And does this script count tables in all databases ? -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------