Problem solve Get help with specific problems with your technologies, process and projects.

Explaining LEVEL parameter of pre-compilation

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.

Dig Deeper on IBM DB2 management

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.