Answer Posted / hatam

A package contains control structures used to execute SQL
statements
A plan is
1- A list of package names
2- The bound form of SQL statements taken from one or more
DBRMs
package is executable and plan not

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3090

---

Explain about rct.

1024

---

What kind of database is db2?

975

---

What is the difference between dbm cfg and db cfg file in db2 ?

1477

---

Which is faster delete or truncate?

1069

---

What is dbrm? What it contains? When it will be created?

991

---

Is db2 free?

1035

---

What is null indicator in db2?

1051

---

What are host variables in db2?

991

---

How do you pull up a query which was previously saved in qmf?

1099

---

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?

2021

---

What are the benefits of using the db2 database?

1154

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1180

---

How can you quickly find out the # of rows updated after an update statement?

985

---

Why do we need reorg in db2?

922

---