Unix Technical Forum

DB2 physical data structures

This is a discussion on DB2 physical data structures within the DB2 forums, part of the Database Server Software category; --> I'm looking for information about DB2 UDB v.8 's physical data structures (structure of primary and secondary indexes). I ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 05:58 PM
emanuela
 
Posts: n/a
Default DB2 physical data structures

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 05:58 PM
Serge Rielau
 
Posts: n/a
Default Re: DB2 physical data structures

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-26-2008, 05:58 PM
Mark A
 
Posts: n/a
Default Re: DB2 physical data structures

"emanuela" <em614@virgilio.it> wrote in message
news:833383f9.0405100044.7fd430fa@posting.google.c om...
> 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


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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-26-2008, 05:58 PM
emanuela
 
Posts: n/a
Default Re: DB2 physical data structures

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>...
> 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-26-2008, 05:58 PM
emanuela
 
Posts: n/a
Default Re: DB2 physical data structures

thanks

"Mark A" <ma@switchboard.net> wrote in message news:<zQJnc.3$FT5.2707@news.uswest.net>...
> "emanuela" <em614@virgilio.it> wrote in message
> news:833383f9.0405100044.7fd430fa@posting.google.c om...
> > 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

>
> 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:02 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com