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 |
When reorg is used?
How can you find out the # of rows updated after an update statement?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How to find the maximum value in a column in the db2 database?
Is db2 a programming language?
What is PRIME TABLE and what are the uses of it
What is an asychronous write?
Where are plans stored?
What is meant by repeatable read?
Can we use select * statement in cobol program without giving field names ???
How many Buffer pools are there in DB2 and what are they?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?