Home
Topics
Database management systems (DBMS)
IBM DB2 management
Explaining LEVEL parameter of pre-compilation

Ask the Expert

Explaining LEVEL parameter of pre-compilation

Craig Mullins, Years 2005-2006

What is LEVEL parameter of pre-compilation?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

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.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- denormalization

This was first published in May 2004

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Management UK
Content Management
Oracle
SAP
SOA
SQL Server

Business Analytics
- No more shortcuts: Sound data quality strategy a must for BI success
  
  In the past, companies might have gotten away with not building data quality efforts into business intelligence programs. That's less likely now.
- Member Exclusive Downloads
  
  Member Exclusive Downloads from SearchBusinessAnalytics
- In-memory applications take on big data analytics challenge
  
  In-memory tools and big data can be a potent analytics mix. But before you put them together, read advice from experienced users and consultants.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Content Management
- Records management program aims to restore order to SharePoint system
  
  Mobile network operator Telenor Group is adopting information governance and records management standards to better control internal SharePoint use.
- Cloud collaboration software connects at networking company Enterasys
  
  Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.
- Data value chain puts the focus on what matters most to a business
  
  In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.
Oracle
- The future of Dell Toad: Oracle DBAs can use BI, Exadata features
  
  Dell Toad is pushing itself into business intelligence and now has an edition to support Oracle's big Exadata appliance.
- Unlock the potential of the Oracle Exadata architecture
  
  Despite being almost five years old now, many implementations haven't realized all of the Oracle Exadata architecture benefits.
- The state of Dell Toad: Oracle DBAs and how they can still benefit
  
  Since Dell acquired Quest Software, maker of the Toad tool for Oracle databases and applications, some questions have arisen about what would happen.
SAP
- Food bank network delivers with SAP mobility
  
  The nation's largest network of food banks is cutting out labor-intensive paper-bound processes with the help of SAP mobile technology.
- SAP adds hybris to its SAP CRM tool set: More choices, or confusion?
  
  One expert calls SAP's purchase of hybris long overdue. Another wonders if SAP is confusing its own SAP CRM customers.
- Limit returns, SAP procurement expenses with a stability study
  
  Stability studies, which measure how different materials respond to various conditions, can save companies huge amounts of money, writes Jawad Akhtar.
SOA
- Inside Red Hat Summit 2013 through the Twittersphere
  
  Highlights from Red Hat Summit 2013 told in 140 characters or less via Twitter.
- An easy database and mainframe modernization game plan
  
  Database and mainframe modernization can seem overwhelming. Red Hat service delivery manager Emily Brand shares her simple action plan for success.
- Why, how to build an intelligent integrated enterprise
  
  Intelligent integrated enterprises can help businesses better serve customers and meet sales objectives.
SQL Server
- SQL Server 2014 'keeps up with the Joneses,' says analyst
  
  Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.
- SQL Server high availability: Natural enemy of virtualization?
  
  Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.
- SQL Server 2014 due out in late 2013, in-memory OLTP a big feature
  
  Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.

All Rights Reserved,Copyright 2005 - 2013, TechTarget