Oninit cdi / Archive
Talk to an expert →

How can i identify what chunk?

Posted in 1999

Topics: Storage & Space Management, Platform-Specific Issues

Pons Roca, Isidre — — source: Informix-list mailing list archive (1991-1998)

Hi gurus. I'm trying to identify the location of a table. To identify the dbspace where tha table reside i use: select dbinfo("dbspace",partnum) location, tabname from systables where partnum is not null and --for exclude fagmented tables tabid > 99 --for exclude system catalog union select dbinfo("dbspace",partn) location, t.tabname from sysfragments f, systables t where t.tabid > 99 and f.tabid = t.tabid and f.fragtipe="T" and work fine. But, Whow i can identify the chunk where a extent reside? working environment: IDS = 7.24.UC7-1 OS = Solaris 2.4 Thanks. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------

↪ replying to Pons Roca, Isidre
Kernoal Stephens — — source: Informix-list mailing list archive (1991-1998)

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> &nbsp; <p>"Pons Roca, Isidre" wrote: <blockquote TYPE=CITE>Hi gurus. <p>I'm trying to identify the location of a table. <p>To identify the dbspace where tha table reside i use: <br>&nbsp;&nbsp;&nbsp; select dbinfo("dbspace",partnum) location, tabname <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from systables <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where partnum is not null and&nbsp;&nbsp; --for exclude fagmented tables <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tabid > 99 --for exclude system catalog <br>&nbsp;&nbsp; union <br>&nbsp;&nbsp; select dbinfo("dbspace",partn) location, t.tabname <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from sysfragments f, systables t <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where t.tabid > 99 and <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f.tabid = t.tabid and <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f.fragtipe="T" <p>and work fine. <p>But, Whow i can identify the chunk where a extent reside? <br>&nbsp; <p>working environment: <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IDS = 7.24.UC7-1 <br>&nbsp;&nbsp;&nbsp;&nbsp; OS = Solaris 2.4 <p>Thanks. <p>--------------------------------------- <br>&nbsp;Isidre PONS ROCA <br>&nbsp;BASE - Gesti&oacute; d'Ingressos Locals <br>&nbsp;(Diputacio de Tarragona) <br>&nbsp;Servei de Sistemes de Informacio <br>&nbsp;Av President Lluis Companys 12-C <br>&nbsp;43005 - Tarragona <br>&nbsp;SPAIN <br>&nbsp;Tel # +34 977 236731 <br>&nbsp;Fax # +34 977 227302 <br>&nbsp;<a href="http://www.altanet.org">http://www.altanet.org</a>; <br>&nbsp;ipons@dtgna.altanet.org <br>---------------------------------------</blockquote> </html>

Glossary