What is page size in db2?
No Answer is Posted For this Question
Be the First to Post Answer
When is the skeleton cursor table created?
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?
What is db2 bind process?
i want to delete 20th million record how ?
Mention and explain the contention situations caused by locks?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
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..
What is referential integrity?
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?
Explain dclgen.
Explain what a plan is?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time