Answer Posted / steve

Check that the DBRMLIB being used in the bind has a time
stamp for the abending program that matches the LOADLIB.
Sometimes all we need to do is point to the correct
libraries. If that does not work then a rebind or
precompile, compile, relink and then rebind will work. The
last option always works, but many times an interviewer
wants to know if we understand what causes an -818. If we
just say we would recompile, link and bind we do not
demonstrate understanding of the root cause.

what are bind concepts in db2 cobol?

1033

---

How do I add a column to a table in db2?

1048

---

Define sqlca.

1052

---

What are the rules for db2 programming?

1039

---

Which components manage deadlocks in db2?

1014

---

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 ?...

4213

---

What is explain in db2?

958

---

What is dbrm in db2 database?

1032

---

How do you select a row using indexes in db2?

1072

---

What is catalog database in db2?

1098

---

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

1050

---

What is a db2 schema?

1172

---

What is dclgen in db2?

1079

---

List out the buffer pools in db2

1018

---

What types of tables are there in the db2 database?

1004

---