Interested to Buy Any Domain ? << Click Here >> for more details...
Where is the access path logic created by the DB2 Optimizer
stored?
- 1 Answers
- 8376 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 |
How to find the number of rows in a db2 table?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
What does runstats do in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Explain correlated sub-queries.
What is the connection string to connect to the DB2 Database ?
Explain in brief how does db2 determine what lock-size to use?
What are the abend codes occour in ur latest PROJECT in DB2
How will you return the number of records in table?
i have a db2 variable how do u declare tht into working storage section ?
db2 restart logic ?
COBOL 
