Answer / s

Packages are single bound DBRMs which contains SQL
statements of a single application program or subroutine.
Before the application program can be executed, you need to
bind a plan. The plan can be bound with DBRM members and/or
Package list. Without the use of packages, if there is any
change made to the program, even if there are no changes to
the SQL, the whole plan need to bound which cause
unavailabilty of the plan and it is resource intensive
since all the unrelated DBRMs are also need to be bound.
With the use of packages, only the package need to be bound
without the need to bind the plan. Also bind parameters can
be specified at package level rather than plan level

Answer / guest

First u need to know the concept precompliation and
compliation process of db2 cobol program...

the maina dvange of pakage is, supose u have cobol db2
program, this prgoram is using 4 sub programs. if any one
of the sub programs undergoes changes u need to precompile
the main program. this can avoided by using the pakage
concept.

so u need to create one pakage for on sub program. if any
sub programs undergoes any change, u need to compile only
sub program.

Filnally one program will have one pakage and one DBRM lib.

Why do we bind in db2?

0 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

What kind of database is db2?

0 Answers  

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

What is meant by a unit of recovery?

1 Answers  

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)

2 Answers  

---

What is the use of commit in db2?

0 Answers  

---

What is role in db2?

0 Answers  

---