Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
1 5026
How do you stop a db2 database in linux?
Explain various types of locks in db2?
How do I change the column size in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How to execute stored procedure in db2 command editor?
What is dclgen in db2?
How many types of page locks can be held in db2?
What is sqlca?
Which component is responsible for processing sql statements and selecting access paths?
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 any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is view db2?
What does reorg do in db2?
can all users have the privilage to use the sql statement select * (dml)?
Can you use max on a char column?