What is the difference between instance upgrade and update? Upgrade refers to the fact that you are moving from a different release of DB2 to a higher level of release. Meaning, if you are currently on V9.5 of DB2, then you moving to V9.7, V10.1, V10.5 or any higher release available would mean you are upgrading. Update would mean that you are on the same release, but you are moving up on the fixpack level of the same release you are on. An example would be, if you are currently on V9.7fp5 (DB2 release V9.7, fixpack 5), and... [More]
First off - time flies when you're having blog! I turned around to do a weekly update, and it's been a month. Ouch! Let's try and get together more often! So, what to talk about? Let's pick up where we left off - the documentation that IBM Information Management support is putting together for you! Let's start with the documents that get the most traffic - "fix" documents. There are a number of kinds of documents related to "fixes", so let's try and sort some of them out: APARs Fix Packs Fix Lists Recommended Fixes... [More]
Welcome to the THUNDERDOME! Ok, it's the "Thoughts from Information Management Support" blog. Somehow "the Thunderdome " seemed more exciting... On the other hand, this blog will benefit you in working with your IBM Information Management products (unlike a steel cage match to the death - yikes!). In coming weeks, we'll deliver information to you regarding ways that we can help you, ways that you can help yourself, and hopefully in the process we'll help each other by getting to know each other better. The Magical Mystery... [More]
Today we are very excited to announce two new ways to get Support information specifically for DB2! A crack team of DB2 experts around the world will be sharing their expertise through Twitter and Facebook. Follow us: DB2_Support on Twitter Like us: IBM DB2 Support on Facebook These channels will cover DB2 Tools... JDBC CLI Security Stored Procedures ... and DB2 Engines Memory HADR Internal Architecture DB2 Blog posts will continue to be posted here on our Thoughts from Information Management Support blog. Follow DB2 Support on Twitter... [More]
When you download IBM Data server driver for JDBC and SQLJ, the tar or zip file (For Example, DB2 V10.1 FP3 driver download is v10.5fp3_jdbc_sqlj.tar.gz file) contains following files: db2jcc4.jar db2jcc.jar sqlj4.zip sqlj.zip Wondering which file to use in your application? Let me explain what those files are and you can decide on which file to use for your application. db2jcc4.jar and db2jcc.jar, both of them are DB2 JDBC driver jar files and are Type 4 JDBC drivers. db2jcc.jar includes functions in the JDBC 3.0 and... [More]
I can't believe it... the Information on Demand Conference kicks of this weekend in Vegas! I'm sure many of you are getting packed and ready for the busy, productive, and fun week ahead. If you aren't attending IOD, you can still connect with many of the events/announcements from home! Here is how to do it: On the conference Livestream , 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... [More]
Chat More Chat! Part of IBM's move to improve your technical support experience is the implementation of Technical Support Chat. If chat it available for your product, please feel welcome to try it! A new YouTube video has been posted to introduce Technical Support Chat and how it can work for you! Check It Out!
This small article describe how to track memory leaks using 'gdb' on Linux. If you are using products like 'db2' or any other product that has it's own memory management routines then you should first track possible leaks at the product level using the tools it provides. For 'db2' that would be 'db2pd' for example. This article therefore applies only to memory leaks at the 'malloc()' level, that is blocks of memory allocated using 'malloc()' but never freed. Remember that a debugger is... [More]
More education content on InfoSphere Information Server - Relocating Information Server 9.1 InfoSphere Data Quality Console exceptions database (ESDB) . Related techdoc #7041978 . This presentation discusses how to relocate the InfoSphere® Data Quality Console exceptions database to another server. It assumes that you are still using the same services tier to manage repository registration in the same metadata repository. This presentation is valid for Information Server version 9.1.
Abstract: In DPF environment, the lock timeout issue could be caused by indoubt transactions. The indoubt transactions cannot be automatically committed or rollback by database manager therefore whenever the application restarts the lock timeout issue occurs. Troubleshooting: Collect the locking data by: db2pd -db <dbname> -alldbp -wlock -app -trans -repeat 5 10 Note that the above db2pd must have -alldbp option which runs on each logical node on one physical box, if there are multiple physical boxes, then db2pd needs to be run on... [More]
Making it easier to get your input We've made a few quick changes to make it easier for you to give us feedback on our technical support documents. Now, when you find your solution, in the upper right you should see this: Make your selection and hit Submit - it's that easy! If you want to add more feedback, click on the "Would you like to make additional comments?" link, which will take you to the bottom of the page where you can add your thoughts, opinions, corrections, additions, email address - whatever's on your mind. Your... [More]
Sometimes the best approach to help customers is for IBM Technical Support to connect to customer's systems with their permission. Assist On Site is an IBM Tool widely used to dial into customer's systems for technical support for products such as DB2 Servers, IBM InfoSphere Guardium, IBM Optim Development Studio, IBM Data Studio, InfoSphere Data Architect. Want to learn more about Assist On-site? Check out this link: https://www-304.ibm.com/support/docview.wss?mynp=OCSSMPHH&mync=E&uid=swg21502162&myns=swgimgmt How can I configure... [More]
Hello, Here are the links with details on what to collect when you run into any issues with IBM Infosphere Federation Server. Gathering this information before calling IBM support will help you familiarize with the troubleshooting process and save you time. Collecting data for installation failures for InfoSphere Federation Server versions 9.x Collecting data for InfoSphere Federation Server Data Source Configuration Issues... [More]
Experiencing "TOO MANY OPEN FILES" in db2diag.log under Linux environment. In Linux platforms it's more common to experience "TOO MANY OPEN FILES" from one of db2 enigne process' like db2sysc. Messages in the db2diag.log will contain texts similar to following : MESSAGE : ZRC=0x850F0006=-2062614522=SQLO_FHNL "TOO MANY OPEN FILES" DIA8306C Too many files were opened. CALLED : OS, -, open OSERR: EMFILE (24) Increasing the "nofiles" in the ulimit for the instance owner or,... [More]
100 Tech Tips: #67 IBM announces InfoSphere Warehouse V10.1 IBM® InfoSphere® Warehouse V10.1 makes it easier for you to develop your business analytics solutions, helps speed your warehouse deployment and management, and helps reduce your overall licensing, administration, and storage costs. InfoSphere Warehouse V10.1 offers: Simplified administration and optimal use of you data storage resources with multi-temperature storage Adaptive compression, helping to lower storage costs Real-time analytics with enhanced zigzag join and continuous data... [More]