What is page size in db2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

When is the skeleton cursor table created?

1 Answers  


we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  


What is db2 bind process?

0 Answers  


i want to delete 20th million record how ?

4 Answers   IBM,


Mention and explain the contention situations caused by locks?

1 Answers  






How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,


What is referential integrity?

5 Answers  


Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  


Explain dclgen.

0 Answers  


Explain what a plan is?

3 Answers   CTS,


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  


Categories