Interested to Buy Any Domain ? << Click Here >> for more details...
Where is the access path logic created by the DB2 Optimizer
stored?
- 1 Answers
- 8367 Views
- I also Faced
- E-Mail Answers
Answer / s
It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.
| Is This Answer Correct ? | 4 Yes | 2 No |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
How to find last record before record through SQLRPGLE?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
How do you retrieve the data from a nullable column?
what is the use of commit ? and what is the syntax?
How do I copy a table in db2?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What is the function of buffer manager?
What is a bind in db2?
COBOL 
