Answer Posted / vat

Not trying to be cute, but, to the question "after
precompilation how many plans and packages will
created?" the answer would be zero.

You would have to do bind to even talk about packages/plans.

How can record locking be achieved in those DB2 versions which do not support it?

1019

---

Who uses db2?

981

---

What is the maximum No of rows per page?

1011

---

Explain about open switch business continuity software?

1072

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4214

---

Is db2 free?

1035

---

What is a bind card?

1141

---

List down the types of triggers in the db2 database?

962

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2865

---

How does db2 sample database connect?

972

---

What is meant by union and union all?

948

---

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

2179

---

What is dclgen (declaration generator)?

1009

---

Explain about cursor stability?

981

---

What is package in db2 mainframe?

917

---