What is dbrm? What it contains? When it will be created?
No Answer is Posted For this Question
Be the First to Post Answer
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
is it compulsory commitment control in journal?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is a Resource Control Table(RCT)? Describe its characteristics.
What are the isolation levels possible ?
what is static sql? what is dynamic sql? Give me details
how to unload different table data into different gdg files/ vsam files.
What are the full forms of spufi and dclgen and why are they used?
What are the two types of logging in the db2 database? Explain them.
how can we retrieve the 100 records of the file ?