In terms of DB2 indexing, what is the root page?
Answer / s
Root page is at topmost level of the index which has the
upper range values and pointers to non-leaf pages.
Is This Answer Correct ? | 1 Yes | 0 No |
Could anyone clearly explain the diference between sub query and correlated sub query?
What is meant by index cardinality?
What can the Locate option of the Repair Utility accomplish?
Why use RUNSTAT Utility?
What will the DB2 optimizer do?
How can you quickly find out the # of rows updated after an update statement?
What is the physical storage length of timestamp data type?
What is the self-referencing constraint?
What is database manager in db2?
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.
how can u nderstand the sql stmts executed successfully or not ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?