GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Mainframe  >  DB2
Go To First  |  Previous Question  |  Next Question 
 DB2  |  Question 140 of 196    Print  
In DB2, table space is an LDS which does not support index concept. But index is an back bone of DB2. How DB2 supports index? Explain?

  
Total Answers and Comments: 1 Last Update: May 30, 2007     Asked by: k r rao 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 19, 2007 03:31:36   #1  
Raghuram Balakrishnan Member Since: July 2007   Contribution: 6    

RE: In DB2, table space is an LDS which does not suppo...

DB2 supports index with the help of leaf pages, non-leaf pages, and root pages.

Leaf pages - Contains indexed values followed by Record Identifiers (RIDs).

Non-leaf pages- Contains the upper range value of each of the leaf pages along with a pointer to each leaf page.

Root pages - Contains upper range values for each of the non-leaf pages with a pointer to the corresponding entry.

If we are searching for emp no 15001 in an employee table. The DB2 will search in root page to find out non-leaf page having entry greater than 15000. From the non-leaf page, it will search for the entry corresponding to emp no greater than 15000 and then in the leaf page, it will be pointed directly to the row in the table with emp no 15001.

Root page
NL1 10000
NL2 20000
NL3 30000

Non-Leaf page - NL2
LP1 - 11000
LP2 - 12000
LP3
LP4
LP5 - 15000
LP6 - 16000

Leaf page - LP6
15001 - the pointer


 
Is this answer useful? Yes | No

 Related Questions

These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.  
Latest Answer : Foreign Keys are keys used in a table as an attribute and are primary keys of some other table ...

Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement?

Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.

Joins, unions and nested selects are used to retrieve data.  
Latest Answer : The two tables has to be linked.EXEC SQL SELECT A.EMP_ID, B.WAGE FROM Table1 A,  Table2 B WHERE A.EMP_ID = B.EMP_ID AND A.EMP_ID = ...

A view is a virtual table made up of data from base tables and other views, but not stored separately.  
Latest Answer : View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating ...

An outer join includes rows from tables when there are no matching values in the tables.  
Latest Answer : 3 types. Left outer Join----left table unmatched valyes are included.Right Outer Join---right table unmatched values are included.Full outer Join----Both table unmatched values are selected. ...

The explain statement provides information about the optimizer's choice of access path of the sql.  
Latest Answer : The EXPLAIN statement obtains information about access path selection for an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE or DELETE statement.The information obtained is placed ...

The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between 

A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value. It's the DB2 equivalent of TBD on an organizational chart and often correctly 
Latest Answer : A NULL value is different from a blank or a zeroA NULL value can be inserted into columns of any data typeA NULL value will evaluate to NULL in any expression (e.g.NULL multiplied by 10 is NULL)If a column has a NULL value, Oracle ignores any UNIQUE, ...

A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities 
Latest Answer : Also, a Synonym is specific to the DB2 subsystem.  Synonym can only access the table or view in the subsystem in which it is defined.   A synonym is dropped when the table is dropped.An Alias is yet another name for a table or view. But ...


 Sponsored Links

 
Related Articles

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

jQuery Table Row Finished Code

jQuery Table Row Finished Code The Finished Code Our second example page has demonstrated table row striping highlighting tooltips collapsing expanding and filtering Taken together the JavaScript code for this page is mosgoogle geshibot lang php" document ready function var highlighted
 

jQuery Expanding and Collapsing Table Rows

jQuery Expanding and Collapsing Table Rows The expanding and collapsing behavior added earlier also conflicts with our filters If a section is collapsed and a new filter is chosen then the matching items are displayed even if in the collapsed section Conversely if the table is filtered and a section
 

jQuery Table Row Filtering

jQuery Table Row Filtering Earlier we examined sorting and paging as techniques for helping users focus on relevant portions of a table s data We saw that both could be implemented either with server side technology or with JavaScript Filtering completes this arsenal of data arrangement strategies B
 

jQuery Collapsing and Expanding Table Rows

jQuery Collapsing and Expanding Table Rows When large sets of data are grouped in tables as each year s set of articles are in our News page collapsing or hiding a section s contents can be a convenient way to get a broad view of all of the table s data without having to scroll so much mosgoogle To
 

jQuery Table Manipulation

Learning jQuery Table Manipulation By Karl Swedberg Jonathan Chaffer Better Interaction Design and Web Development with Simple JavaScript Techniques Learning jQuery packtpub com jQuery book Table Manipulation Let em wear gaudy colors Or avoid display Devo Wiggly World" In the first si
 

ERP Systems as Quality Control Support

ERP Systems as Quality Control Support For the past few years ERP systems have became one of the most powerful tools for quality control management But ERP is just an informatics system that provides support to the integrated business management mosgoogle center Goals of the Quality Control Module i
 

What is Bit Mapped Index

Bit Map Indexing is a technique commonly used in relational databases where the application uses binary coding in representing data. This technique was originally used for low cardinality data but recent applications like the Sybase IQ have used this technique efficiently. The word cardinality is
 

Explain about TNSPING

You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID. Open Command prompt. Write tnsping < SID for the database connectivity you want to check > If you get the message “Used TNSNAMES
 

SQL Table Commands

SQL Table Commands Overview As mentioned previously in this series of SQL articles, databases are primarily composed of tables. The “columns and rows” structure of the table allows data to be efficiently inserted, manipulated, updated, and deleted from the database. The three mos
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape