Oninit cdi / Archive
Talk to an expert →

Tables for a chunk

Posted in 2000

Topics: Storage & Space Management

eonder@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Hello, I need to find the tables for a chunk. Is it possible with SMI tables? Regards Enrico Sent via Deja.com http://www.deja.com/

↪ replying to eonder@my-deja.com
Phillip — — source: Informix-list mailing list archive (1991-1998)

you can run an oncheck -pe to find the tables in a chunk. I'm sure you could do it via SQL hitting the SMI tables but I think this is easier. eonder@my-deja.com wrote: > Hello, > > I need to find the tables for a chunk. Is it possible with SMI tables? > > Regards Enrico > > Sent via Deja.com > http://www.deja.com/ -- Phillip Tien Database Administrator Whole Foods Market, Inc. Most of the time it was probably real bad being stuck down in a dungeon. But some days, when there was a bad storm outside, you'd look out your little window and think, "Boy, I'm glad I'm not out in that."

↪ replying to eonder@my-deja.com
Norman Erickson Lugtu — — source: Informix-list mailing list archive (1991-1998)

Its possible,try this, database sysmaster ; select hex(start) hexnum,dbsname,tabname from sysextents into temp tempext ; select unique fname, dbsname,tabname from tempext a, syschunks b where hex(a.hexnum[3,5]) = hex(b.chknum); Give me feedback. Erickson In article <91netc$hu5$1@nnrp1.deja.com>, eonder@my-deja.com wrote: > Hello, > > I need to find the tables for a chunk. Is it possible with SMI tables? > > Regards Enrico > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/

↪ replying to Norman Erickson Lugtu
eonder@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Thank you, it is all right; I have apported only a little modication to a condition of a second query: From: where hex(a.hexnum[3,5]) = hex(b.chknum) To: where hex(a.hexnum[1,5]) = hex(b.chknum) This modication is necessary for a corret link between two hexadecimal numers (the link was from a text with a hexadecimal). Regards Enrico In article <91o4bj$3ur$1@nnrp1.deja.com>, Norman Erickson Lugtu <elugtu@my-deja.com> wrote: > Its possible,try this, > > database sysmaster > ; > select hex(start) hexnum,dbsname,tabname > from sysextents > into temp tempext > ; > select unique fname, dbsname,tabname > from tempext a, syschunks b > where hex(a.hexnum[3,5]) = hex(b.chknum) where hex(a.hexnum[1,5]) = hex(b.chknum) > ; > > Give me feedback. > > Erickson > > In article <91netc$hu5$1@nnrp1.deja.com>, > eonder@my-deja.com wrote: > > Hello, > > > > I need to find the tables for a chunk. Is it possible with SMI tables? > > > > Regards Enrico > > > > Sent via Deja.com > > http://www.deja.com/ > > > > Sent via Deja.com > http://www.deja.com/ > Sent via Deja.com http://www.deja.com/

Glossary