The Power of Collecting Your IBM software isn't working as you expected it to, so you're ready
to call IBM Support to get the help you need. Before you pick up the
phone, search the IBM knowledge base and see if there is a Collecting
Data document related to your situation. Collecting data documents (formerly MustGather documents) aid in
problem determination and save time resolving problems by explaining
what information needs to be gathered before calling IBM. Collecting data documents are an extension of the natural
Join us for our upcoming Support Technical Exchange! Our speaker, Gary Foster, will guide us through a deep dive on I BM InfoServer DataStage PX Engine - Lookup Stage. Abstract: The parallel lookup stage is one of the most used stages in PX job design. In this presentation, Gary will show the options for use, case scenarios and how this stage works internally so you can make better decisions on how to use this stage in your job designs. With proper use, you can capitalize on available resources and maximize performance of your jobs. This... [More]
Hi there! When you open a Problem Management Record (PMR) with DB2 Support team, first thing we are interested in looking at is db2support.zip. Its a great handy tool collecting background information on your environment. Ever wondered what it has? Extracting the db2support.zip file, the following files and directories were collected: DB2CONFIG/ - Configuration information (for example, database, database manager, BP, CLI, db2 node configuration and Java developer kit, among others) The files have “supp_cfg” as the file... [More]
Ever wonder where to get a cheatsheet to catalog a connection from a DB2 client to a remote DB2 server on LUW? Here it is with simple step-by-step instructions!!! On the DB2 server: 1) Set the DB2COMM registry variable to tcpip. db2set DB2COMM=tcpip. 2) Verify whether it is set correctly using the following command: db2set -all Output: [i] DB2COMM=tcpip 3)Check the DBM CFG for SVCENAME parameter and make a note of it. db2 get dbm cfg For example: TCP/IP Service name (SVCENAME) = db2c_db2inst1 (Either... [More]
As guardians of data we are constantly faced with the challenge of moving data from one platform to another for a multitude of reasons. We faced such challenge at one of my favorite client location where most databases were being migrated to reside on private cloud environment. A standard procedure in order migrate a few hundred database instance into a Linux cloud farm was built.... [More]
In this demo, I have considered the following to demonstrate DB2 connectivity using type 2 Universal JDBC type 2 driver with 32-bit and 64 application: - Downloaded IBM 32-bit JDK for Windows from the web: http://www.ibm.com/developerworks/java/jdk/ - Installed DB2 V9.7 FP5 64-bit Client on Windows 7 - DB2 V10.1 FP4 database server on Linux. Used the following sample code: import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; import java.sql.SQLException; public... [More]
100 Tech Tips, #59: Collecting the right data for MDM Support team PD Collector tool is a great way to collect all the information MDM Support Team will need for investigation purposes. Please note this PD Collector tool ( Problem Determination Tool ) is available from MDM Server 902 onwards. All you need to do is running the "mdmsupport.sh" script with any of the available options. Here some examples: - mdmsupport.sh --collect=mdm (collects info from MDM layer) - mdmsupport.sh --collect=appserver (collects info from the... [More]
To continue our series covering the most popular technical documents, today we're bringing you a list of the top 10 documents for IBM Optim !
20 Sep 2011: Detailed System Requirements for components of IBM Optim 7.2 03 Nov 2011: Detailed System Requirements for components of IBM Optim 7.3 03 Jun 2011: Detailed system requirements for components of IBM Optim Data Privacy Solution v2.1 28 Jul 2011: Installing your Optim solution in Windows Vista and succeeding Windows platforms 15 Nov 2010: Detailed System Requirements for components of IBM... [More]
In the beginning of May, IBM significantly updated the IBM Support Portal support site, with improvements to make this worldwide one-stop site for technical resources for all IBM products even more effective and useful for our clients. Some are adjustments our clients have requested, others are redesigns to improve our clients' efficiency finding the information they need. Here's a quick rundown of new capabilities to look for.
Several enhancements have been made to the product selection function. In the “Choose your products” module, users... [More]
Here is a list of the Top Ten viewed technical documents for DB2 for Linux, Unix, and Windows: 12 Oct 2010: DB2 Fix Packs by version for DB2 for Linux,...
20 Jul 2010: DB2 Version 9.5 Fix Pack 5 for Linux, UNIX,...
26 May 2010: DB2 database product documentation
30 Aug 2010: DB2 UDB Version 8 - End of Support date is...
23 Feb 2010: DB2 UDB Version 8 Product Manuals
01 Jul 2010: DB2 UDB Version 8 FixPaks & client downloads...
16 Sep 2010: DB2 Version 9.7 Fix Pack 1 for Linux, UNIX,...
16 Mar 2010: DB2 Version 9.1 for Linux,... [More]
IBM InfoSphere Data Explorer, Version 8.2-2 is available to download. InfoSphere Data Explorer Version 8.2-2 includes the following updates: • Data Explorer Engine uses Installation Manager 1.6.1, which provides a 64-bit version of Data Explorer Engine. It is therefore no longer necessary to install 32-bit libraries to use Installation manager on Linux systems. • Data Explorer Engine now supports optionally displaying query results in original document formats, known as rich preview. Displaying rich preview results in a browser is not... [More]
Abstract: There would be a requirement for locating the top N heavy accessing tables in the database for the performance diagnostic purpose. A common tool called db2top is mostly used by DBAs for tracking such performance metrics. However, db2top monitoring has a big performance impact because it uses db2 snapshot mechanism to maintain the counters in the monitor heap which incurs a lot of performance overhead. This article introduces an easy and quick method to detect your top N heavy scanned tables in the database by using db2pd. db2pd... [More]