Re: db2 database physical structure ?

Posted in 2003

Rajib Sarkar — Fri, 9 May 2003 10:11:42 -0700 — source: Usenet: comp.databases.informix

the .dat file is only for SMS spaces ... if you have DMS spaces you will have files like the chunks u define in Informix. What are you looking in the page structure ?? Are you looking for a page or are you looking something similar to oncheck -pe output. HTH Thanx much, Rajib Sarkar Advisory Support Engineer IBM Data Management Solutions Ph: 602-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi Friday, May 09, 2003 10:06 AM To: informix-list@iiug.org cc: From: hopehope_123@yahoo.com (utkanbir) Subject: db2 database physical structure ? Dear Gurus, I have just started to learn db2 and created a database. What i have realized was , for each database , db2 created a new directory and for each table , new .dat file. (like our Standard engine) . Is this the only way or am i missing something? If so , is there any page structure in db2 as in Informix 5.x,7.x,9.x . Good old informix........ Bye, hope

↪ replying to Rajib Sarkar

utkanbir — 11 May 2003 22:13:59 -0700 — source: Usenet: comp.databases.informix

Hi Gurus, Thank you very much for your help. Kind Regards, hope Rajib Sarkar <rsarkar@us.ibm.com> wrote in message news:<b9gp70$r49$1@terabinaries.xmission.com>... > the .dat file is only for SMS spaces ... if you have DMS spaces you will > have files like the chunks u define in Informix. > > What are you looking in the page structure ?? Are you looking for a page or > are you looking something similar to oncheck -pe output. > > HTH > > > Thanx much, > Rajib Sarkar > Advisory Support Engineer > IBM Data Management Solutions > Ph: 602-217-2100 > > As long as you derive inner help and comfort from anything, keep it -- > Mahatma Gandhi > > > > Friday, May 09, 2003 10:06 AM > To: informix-list@iiug.org > cc: > From: hopehope_123@yahoo.com (utkanbir) > Subject: db2 database physical structure ? > > > > Dear Gurus, > > I have just started to learn db2 and created a database. What i have > realized was , for each database , db2 created a new directory and for > each table , new .dat file. (like our Standard engine) . Is this the > only way or am i missing something? If so , is there any page > structure in db2 as in Informix 5.x,7.x,9.x . > > > Good old informix........ > > Bye, > hope