Q

Explaining LEVEL parameter of pre-compilation

This Content Component encountered an error
What is LEVEL parameter of pre-compilation?
The LEVEL parameter of the pre-compile process can be used to override DB2's consistency token. The value supplied to the LEVEL parameter is used by DB2 to generate the consistency token. Using LEVEL you can change the source code of the program and as long as you do not change any SQL you can get away without rebinding the plan or package. This is not a practice to be undertaken lightly and it is not supported in the DSNH CLIST or the DB2 Program Preparation panels in TSO.

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .VO7aaqqaAFk.0@/search390>discussion forums.

This was first published in May 2004

Dig deeper on IBM DB2 management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close