Where is the access path logic created by the DB2 Optimizer
stored?
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 |
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the maximum size of varchar data type in db2?
How many sub queries can you combine together ?
Explain dclgen.
What is the command used by TSO users to invoke DB2?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
How do you insert a record with a nullable column?
What is an instance in db2?
What is commit in db2?
wht is d/f between union and joins ?