What is package versioning? Please give an example.



What is package versioning? Please give an example...

Answer / mani

Versioning allows multiple packages that share both the
schema and Package ID to co exist in the system catalogs.

A sample application called payroll is compiled from
payroll.sqc.This application would be precompiled and the
package payroll bound to the database and the application
delivered to the users.users then could run the application
in production.
If the application required modification (even without sql
changes) the process of recompiling,binding and sending the
application to the users must be repeated.If the version
option was not specified for this second precompilation of
payroll, the first package is replaced by second package.
Any user who attempts to run the old version of application
would get -818 error.To avoid this use VERSION and it allows
both versions of the appliction to run at the same time.

When the first version of Payroll was created, the version
option should be used during the precompilation step.

DB2 PREP PAYROLL.SQC VERSION V1.1

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

When is the skeleton cursor table created?

1 Answers  


What are the functions in DB2?

3 Answers   Satyam,


What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  


Define db2 and its databases?

0 Answers  


What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,






Are view updateable?

0 Answers  


What is the purpose of using commit?

0 Answers  


how can u understand the end of the table ?

1 Answers   TCS,


How do we specify index to include or not during bind process.

0 Answers   Satyam,


What is db2 catalog database?

0 Answers  


I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,


What is load replace in db2?

0 Answers  


Categories