KateDawson 060001TQ2C Visits (488)
Have you ever tried watching on of our IBM Support videos on YouTube? We have a wide variety of videos available on the IBM
Today, we wanted to make you aware of a few NEW videos:
Downloads and Fixes
IBM Support Assistant
gorddbds 060001JCXS Visits (567)
External Stored procedures and UDFs (collectively referred to as routines) that utilize the database are susceptible to the same performance issues as any other application. Unlike other database applications, external routines are run in DB2 processes that are managed by an infrastructure. This infrastructure can be configured through the Database Manager Configuration or the dbm cfg.
In this blog post I will explain some of the dbm cfg parameters that are related to external routine performance, including KEEPFENCED, FENCED_POOL and NUM_IINTFENCED.
The primary setting that effects external routine performance is the KEEPFENCED parameter. When this parameter is set to YES. DB2 will keep the process used to execute a routine once the routine completes. DB2 places this process in a pool, which eliminates the overhead of starting a process the next time a routine is invoked. The dbm cfg also includes parameters that can be used to tune this pool.
kdillon 20000024FQ Visits (420)
Below are five new self-assist videos in the IBM Electronic Support tools and resources section of the IBM Education Assistant website:
IMLillianLei 120000CR7P Visits (529)
IBM Software Group InfoCenter is organized in the same way, so the information below applies to MDM versions, as well as other IBM software such as Websphere and DB2 products.
MDM v10.0 to the latest MDM v11.0 combined three different MDM products: MDM Server, MDM Collaboration Edition and MDS. Since the three individual MDM products combined into one product family, the InfoCenter documentation is combined as well.
Sometimes when you need to search on MDMCS documentation from the combined InfoCenter, and you want to avoid the similar topic from the other two products (MDMS, or MDS) to return as search results, it helps to create a search scope.
The search scope can be set from the InfoCenter main page.
Select the new scope you created, so only the related topic is displayed on the left nav.
You may download the MDM v11.0 eGA from the IBM Passport Advantage website:
Here is the MDM v11.0 InfoCenter, where you can find all product related documentation:
Find out what's new in MDM v11.0:
Here is the important system requirement technote for MDM v11.0
IMLillianLei 120000CR7P Visits (459)
Important Announcement: IBM InfoSphere Master Data Management Collaboration Server versions 10.0.0 and 10.1.0 are being merged. Please see the following technote for detail.
gorddbds 060001JCXS Visits (561)
The CLP or Command Line Processor is the primary and lowest level interface available for DB2 LUW. It is capable of running SQL statements and DB2 commands, changing the DB2 Configuration and running DB2 scripts. The clp “db2” command can even be added to OS scripts to execute DB2 commands. The CLP also has various options that can be used to change its behavior, a few of these are:
-c option. This option changes the autocommit behavior. By default autocommit is on and the CLP issues a commit after every query run. By issuing db2 -c the autocommit behavior can be toggled on and off, as there are some situations where it may not be desirable to commit every query.
-l option . Using the -l <filename> option will cause the CLP to log the commands issued to a history file.
-m option. Adding the -m option will cause the CLP to print the number of rows effect by an INSERT, UPDATE, DELETE or MERGE statement.
The standard CLP “DB2” prompt can also be customized to display authorization Ids, instance and database names by using the db2 registry variable DB2_CLPPROMPT.
The following URL documents the options available for the CLP.
The following URL documents the features of the CLP and customizing the prompt.
The following URL documents the return codes from the CLP
KateDawson 060001TQ2C Visits (435)
Hot off the press!! The Q2 2
If you are interested in support resources for any of the following products, chec
This quarter we are focused on providing you with links and resources from our Information Centers, as well as many other useful links. If you haven't used them before, Information Centers provide a simple way to find technical information to help you plan, install, configure, use, tune, monitor, troubleshoot, and maintain your IP&S products.
ubektas 27000478GM Visits (775)
The IBM Information Management best practices present advice on the optimal way to use a variety of IBM Information Management products. They include technical papers, presentations, and articles authored by leading experts in IBM's development and consulting teams and are designed to give you practical advice to improve the value of your IBM data servers and data integration products.
ubektas 27000478GM Visits (910)
IBM offers a number of information management related free ebooks that were written and published with the cooperation of subject matter experts and the community
Please see the some of published free ebooks :