What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

---

what is SPUFI ?

2 Answers  

---

How can you count the number of rows from a table tab?

0 Answers  

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

How does cobol compile db2 program?

0 Answers  

---

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 ?

0 Answers   JPMorgan Chase,

---

What is copy pending status in db2?

0 Answers  

---

What are data types?

2 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---