what is the process of precompiler?2 9334
what is REORG? what is the use?4 8108
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?2 3693
How do you filter out the rows retrieved from a Db2 table ?1 5411
What is a clustered index?1 8721
When will you chose to run RUNSTATS?1 5796
What does DML stand for and what are some examples of it?3 4479
What is meant by a unit of recovery?1 3136
What is CHECK PENDING ?4 10613
What is a thread?3 3718
What is filter factor?2 7131
What's the maximum number of volumes that can be added to a STOGROUP?1 5788
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
can we view the access paths created by dbrm ? how ? thx
How to restart a DB2 program?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How to fetch the uncommited data from table ?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
what is utility for parm lib
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
what is the sqlcode -501
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
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?
what is diffrence b/w file-aid tool and file-aid utility???