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]
We're pleased to announce that the first Support newsletter for IBM PureData System for Analytics is now available! This quarterly publication was sent to My Notifications subscribers last week and is also available here . If you use or are interested in PureData for Analytics, you can subscribe to receive the newsletter through the subscribe link at the bottom of the newsletter OR (better yet!) subscribe to PureData for Analytics through My Notifications to receive this newsletter as well as additional proactive support... [More]
Bye Bye, Control Center! So, what's next? Starting from DB2 Version 9.7, Control Center tools have been deprecated. In DB2 Version 10.1, Control Center tools and all the related components such
as wizards and advisors are discontinued. The following Control Center tools
and related features have been discontinued: Activity Monitor Command Editor Configuration Assistant Control Center and associated wizards and advisors Add Partitions launchpad Alter Database Partition Group wizard Backup wizard Configuration advisor wizard Configure... [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]
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]
IBM Information On Demand (IOD) 2012 will be hosted in Mandalay Bay, Las Vegas from October 21st through 25th. I hope you will have a chance to attend this exciting event to learn about the products in the IBM Software Group InfoSphere portfolio, and see what we can do to help you and your business compete in today's challenging global economy. Here is a short overview of the event from my own personal experience, and some suggestions to help you prepare before you head out to the Silver State. When you first check in to the event, you will be... [More]
Do you see different results for same query from Websphere Application, even though the underlying data is not changed? Consider a table with column of datatype decimal(5,2). If you are inserting "0.18999999999999995" into this table multiple times from Websphere applications using JCC drivers, you will see the results as follows: COL1 ----- 0.19 < First Run 0.18 < Second Run 0.18 < Third... [More]
Abstract IBM is pleased to announce a new support option available to you when your software reaches End of Service (EOS). IBM will offer Continuing Support for selected Analytics(Db2,Informix,ILG, ECM&Cognos) products and releases. This offering will provide you with continued access to the same knowledgeable global Support team you are working with today. Content IBM is pleased to announce a new support option available to you when your software reaches End of Service (EOS). IBM will offer Continuing Support for selected Analytics... [More]
The Information on Demand Conference will get under way this weekend! If you aren't able to attend the event in person, there are many ways to connect with the event from home. Check out our suggestions below:
On the IOD Livestream site , you can watch streaming video of the conference throughout the day. See the EXPO, listen to keynote speeches, watch interviews with key IBMers and IOD attendees.
Connect with our Support Leaders on Facebook! Our Leaders are at the event and actively posting photos and information from the conference to... [More]
One reason why a tablespace might get marked offline after a db2 database restore might be due to issues with tablespace container filesystem or, anything related to access to filesystem containing containers of the tablespace. For this kind of reason it will show I/O messages in the db2diag.log. This can happen both during restore as well as during rollforward. But, another common reason why a tablesapce get marked offline during rollforward could be due to the... [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]
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]
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]