I'm looking for information about DB2 UDB v.8 's physical data
structures (structure of primary and secondary indexes). I looked for
in IBM site, but I just found out something about B+tree. Do you know
where can I look for?
thanks

Emanuela,

Is this for your education or are you trying to write your own utilities?
I don't think IBM publishes the physical structures.
AFAIK this information is available upon requests.
Drop me a note and I pass it along.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Emanuela,

Is this for your education or are you trying to write your own utilities?
I don't think IBM publishes the physical structures.
AFAIK this information is available upon requests.
Drop me a note and I pass it along.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

"emanuela" <em614@virgilio.it> wrote in message
news:833383f9.0405100044.7fd430fa@posting.google.c om...[color=blue]
> I'm looking for information about DB2 UDB v.8 's physical data
> structures (structure of primary and secondary indexes). I looked for
> in IBM site, but I just found out something about B+tree. Do you know
> where can I look for?
> thanks[/color]

There is some conceptual information and diagrams in the Administration
Guide: Planning which can be downloaded at the IBM web site:

ftp://ftp.software.ibm.com/ps/produc...r/db2d1e80.pdf

"emanuela" <em614@virgilio.it> wrote in message
news:833383f9.0405100044.7fd430fa@posting.google.c om...[color=blue]
> I'm looking for information about DB2 UDB v.8 's physical data
> structures (structure of primary and secondary indexes). I looked for
> in IBM site, but I just found out something about B+tree. Do you know
> where can I look for?
> thanks[/color]

There is some conceptual information and diagrams in the Administration
Guide: Planning which can be downloaded at the IBM web site:

ftp://ftp.software.ibm.com/ps/produc...r/db2d1e80.pdf

It's for a university course in DB tecnologies.

Serge Rielau <srielau@ca.eye-be-em.com> wrote in message news:<c7nml8$2jd$1@hanover.torolab.ibm.com>...[color=blue]
> Emanuela,
>
> Is this for your education or are you trying to write your own utilities?
> I don't think IBM publishes the physical structures.
> AFAIK this information is available upon requests.
> Drop me a note and I pass it along.
>
> Cheers
> Serge[/color]

It's for a university course in DB tecnologies.

Serge Rielau <srielau@ca.eye-be-em.com> wrote in message news:<c7nml8$2jd$1@hanover.torolab.ibm.com>...[color=blue]
> Emanuela,
>
> Is this for your education or are you trying to write your own utilities?
> I don't think IBM publishes the physical structures.
> AFAIK this information is available upon requests.
> Drop me a note and I pass it along.
>
> Cheers
> Serge[/color]

thanks

"Mark A" <ma@switchboard.net> wrote in message news:<zQJnc.3$FT5.2707@news.uswest.net>...[color=blue]
> "emanuela" <em614@virgilio.it> wrote in message
> news:833383f9.0405100044.7fd430fa@posting.google.c om...[color=green]
> > I'm looking for information about DB2 UDB v.8 's physical data
> > structures (structure of primary and secondary indexes). I looked for
> > in IBM site, but I just found out something about B+tree. Do you know
> > where can I look for?
> > thanks[/color]
>
> There is some conceptual information and diagrams in the Administration
> Guide: Planning which can be downloaded at the IBM web site:
>
> ftp://ftp.software.ibm.com/ps/produc...r/db2d1e80.pdf[/color]

thanks

"Mark A" <ma@switchboard.net> wrote in message news:<zQJnc.3$FT5.2707@news.uswest.net>...[color=blue]
> "emanuela" <em614@virgilio.it> wrote in message
> news:833383f9.0405100044.7fd430fa@posting.google.c om...[color=green]
> > I'm looking for information about DB2 UDB v.8 's physical data
> > structures (structure of primary and secondary indexes). I looked for
> > in IBM site, but I just found out something about B+tree. Do you know
> > where can I look for?
> > thanks[/color]
>
> There is some conceptual information and diagrams in the Administration
> Guide: Planning which can be downloaded at the IBM web site:
>
> ftp://ftp.software.ibm.com/ps/produc...r/db2d1e80.pdf[/color]