Part of the IBM Analytics family, focused on Analytic Platform product support. This blog is administered by Andrew McCarl (amccarl) and Kate Nichols (KateDawson), and follows the IBM Social Computing Guidelines.
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]
The IBM Service Request Tool is the best way to report a problem or open a PMR with IBM. If you are already a user of the Service Request Tool, you are probably familiar with some of its benefits. If you haven't used it before, try it the next time you need to contact IBM Support. To see one of the many advantages of Service Request, watch our new video showing you how you can view and update PMRs quickly and easily on the web. To access the Service Request Tool, visit the IBM Support Portal and click the Service Requests & PMRs tab.... [More]
One of our clients has a JCC application going through a DB2 Connect gateway connecting to DB2/Z database, instead of direct connection to DB2/Z. They wanted to know how to setup the automatic client re-route(ACR) if the DB2 Connect goes down. Here are the steps: Common Step: In the case of the DB2 Connect server, because there is no requirement for the synchronization of local databases, you only need to ensure that both the original and alternate DB2 Connect servers have the target IBM mainframe database cataloged in such a way that it... [More]
Information on Demand 2011 is in full swing! Here are a few key observations from our team on-site at the event and our team watching the event from our IBM offices! The Support, Services, and Education Hub has been busy throughout the event and is in a great location right behind the IBM Watson pedestal! Attached are photos of the Support part of the Hub as they got ready for today's rush! If you are at the event, visit the Hub in the EXPO, pedestal 625. Demos, demos, demos ! The Support Hub has been showing tons of demos of all of our... [More]
How to restore critical administrative files with onbar utility? It is already known to us that onbar backs up some critical administrative files during storage space backup. These critical files are as follows: The onconfig file UNIX: The sqlhosts file The ON-Bar emergency boot file: ixbar.servernum The server boot file: oncfg_servername.servernum There may be a situation when you need to restore one of these files, for example: replace disks, restore to a second computer system (imported restore) etc. However, previously there was no easy way... [More]
If you need regular database backup during night or weekends, use DB2 automatic maintenance feature. Here is DB2 V9.7 Information Center URL: http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.ha.doc%2Fdoc%2Ft0051357.html 1) How automatic maintenance job run? The automatic maintenance feature has two phases. 1) Evaluation and 2) Execution. 1) Evaluation: Check whether we do task. Evaluation activity starts in every 2 hours since database is activated. 2) Execution: Do the task Once... [More]
IBM is providing BigData on YouTube. BigData on YouTube allows viewing of serveral on-line videos for various BigData topics. The topics range from client stories, what's new in BigData, InfoSphere Streams and more... Click here to see the videos
The following new IP&S IEA modules went to production : Monitoring memory consumption of DataStage processes - This module explains how to monitor memory consumption of DataStage processes during run time. Configure MQ connector for client connection mode on UNIX and Linux - This module demonstrates how to setup a simple DataStage job using the MQ connector stage to write and read messages from a WebSphere MQ queue
New IBM Education Assistant presentation - How to relocate an IBM InfoSphere Information Analyzer analysis database (IADB) to a new location . Related techdoc #7042099 . This presentation discusses both the restrictions and requirements for relocating the IADB database. It also walks you through the overall process and steps that are required to relocate IADB. This presentation is valid for Information Analyzer version 9.1.
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]
We have listed a number of Datastage job failures troubleshooting guides connected with low system resources : Resources unavailable to create a DataStage parallel job DataStage is unable to create parallel jobs when system resources are limited. DataStage error "The section leader on xxx died" This error occurs when resources are temporarily unavailable and the conductor process times out. ... [More]
Can you believe that August is almost over? The end of August is the beginning of a new season for us here at Thoughts from IM Support. And that season is none other than IOD SEASON! Information on Demand is now officially only 75 days away. As we have done for the past several IOD conferences, we'll be running a blog series on key IOD sessions, activities, etc. to help get you ready. So, without further ado, let's get this blog series going! We know that when you attend IOD you want to make the most out of every moment -- there really... [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 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 team on Facebook and Twitter! Our team will be at the event and actively posting photos and information from the... [More]
Tech Tip: Changing DB2's query
behavior using the DB2_COMPATIBILITY_VECTOR. Starting in Version 9.5 DB2 LUW has
provided the ability to modify DB2's query behavior so that it alines
with other database platforms . This functionality is enabled
through a DB2 registry variable called the DB2_COMPATIBILITY_VECTOR.
This variable accepts several hexadecimal values. For example if you
would like to execute the truncate command so that the Immediate
keyword is no longer required (as in the case of DB2 for Z/OS) you
can set the... [More]