Ask the Expert

Explaining LEVEL parameter of pre-compilation

What is LEVEL parameter of pre-compilation?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: