Re: Number of extents in a tblspace

Posted in 1992

emory!ncratl!ncr-sd!sdsu!isg100!sdsu!isg100.isg.com!abc0 — Fri, 03 Jan 92 09:17:15 -0800 — source: Informix-list mailing list archive (1991-1998)

> > > > >Hi folks, > >How can I figure out the number of extents in EVERY tblspace of a database? > >Thanks in advance. > >ats :) > >-------------------------------------------------------------------------------- >| Abilio Tavares da Silva | >| S.S.F. - Servicos de Software Financeiro, Lda VOICE: +351 (1) 727-0303 | >| Estrada da Luz 104, Loja A FAX: +351 (1) 727-0335 | >| 1600 Lisboa E-MAIL: ats@ssf.pt | >| PORTUGAL | >-------------------------------------------------------------------------------- Hi Abilio, The easiest way for you to figure out the number of extents of a database is to run tbcheck -pt. You can run tbcheck -pt database to scan the whole database or run tbcheck -pt database:tablename to scan for a particular table. Hope this help ---- Anne Beatrice Tan Information Systems Group Project Leader Unix, C, and Database Consulting abc0@isg.com 450 B Street 16th Floor sdsu!isg100!abc0 San Diego, CA 92101 (619) 234-3405 x285