Explaining LEVEL parameter of pre-compilation

Craig S. Mullins, Mullins Consulting

Published: 10 May 2004

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.

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

Related Q&A from Craig S. Mullins

SAP BW certification: Tips, advice and skepticism

Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading

Data export command: Migration from a DB2 table to a flat file

To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading

Resources on creating and supporting BLOBs in DB2

Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading

Have a question for an expert?

Please add a title for your question

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

Meet all of our Data Management/Data Warehousing experts

View all Data Management/Data Warehousing questions and answers

SearchBusinessAnalytics

ThoughtSpot BI platform an early adopter of AI

Due to AI, ThoughtSpot's analytics tools have been accessible to citizen data scientists from the start, Andrew Yeung, the ...

ThoughtSpot 6 advances AI power of BI platform

New augmented intelligence and machine learning tools, along with a new mobile app, highlight the release of the new update to ...

Promethium tool taps natural language processing for analytics

The software, called Data Navigation System, was designed to enable non-technical users to make complex SQL requests using plain ...

SearchAWS

AWS' open source entreaties now include cloud credits

AWS will offer promotional cloud credits to open source project maintainers that meet certain criteria. The move comes after ...

Amazon wraps Oracle to AWS migration, looks to poach workloads

Amazon has moved its consumer division's IT operations off of Oracle's database and onto AWS services, a towering effort that ...

Amplify improvements streamline AWS mobile app development

Once just an open source Java library, AWS Amplify is now a full-fledged AWS mobile app development platform. Learn how it works ...

SearchContentManagement

Digital asset management benefits the future of work

Digital asset management promises to transform digital work, making it easier to tag documents, analyze video and provide image ...

Box cloud content management adds PDF tools, boosts security

Box partners with Adobe in releasing a new set of PDF tools that can be used within Box's content management cloud to enable ...

AI optimizes content management workflows, personalizes CX

AI is poised to revolutionize content management workflows, bringing order to enterprise documents, greater insights into ...

SearchOracle

Oracle OpenWorld 2019 coverage: Oracle seeks loftier cloud perch

This guide covers technology developments and other news from the Oracle OpenWorld 2019 conference, plus key trends for Oracle ...

Oracle applications development EVP on Fusion, SaaS and what's ahead

Steve Miranda discusses lessons learned from Oracle Fusion Applications, SaaS, best-of-breed apps vs. suites and Oracle's ...

The roots of Oracle's cloud evolution: A 20-year review

Oracle, like other prominent on-premises software vendors, has traced a long path into the cloud. These 10 events over the past ...

SearchSAP

Road ahead for new SAP leadership team isn't an easy one

New SAP co-CEOs Jennifer Morgan and Christian Klein must clarify SAP's products strategy, explain the experience economy and help...

CEO of SAP Bill McDermott abruptly resigns

Bill McDermott, CEO of longtime ERP, CRM and BI software vendor SAP, resigned Thursday triggering a succession plan that promotes...

What is an SAP Intelligent Enterprise? Don't look for a clear answer

What does Intelligent Enterprise actually mean? If the SAP term confuses you, you're not alone. Learn what the experts say and ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

Dig Deeper on IBM DB2 management

Related Q&A from Craig S. Mullins

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.