Interested to Buy Any Domain ? << Click Here >> for more details...
What are leaf pages?
- 3 Answers
- 8650 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Leaf pages points to data pages. It stores the key value
and the RIDS associated with the values. RIDS are pointers
to the data rows.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rbs
Hi S,
Above, u defined the INDEX. Is index and Leaf Pages are
same?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mehdee
About the above question. We create INDEX when we create a
DB2 table, but Leaf pages are created by DB2 as this DB2
table being accessed and it keeps going on. That is why
DBADM use the SYSIBM.SYSINDEXES table and check on the
column LEAFDIST to see for example if it is greater than
500, then they run the REORG job then RUSTATS to bring down
the Leaf pages distribution to less then 500 to improve
access performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to solve S0C7 abend with out using DISPlay in 10 mins?
Is db2 a database?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
What is the difference between static and dynamic SQL?
What is db2 bind process?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What are simple, segmented and partitioned table spaces ?
How can the duplicate values be eliminated from db2 select?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
COBOL 
