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.
There are few recent published technotes that address to different InfoSphere Information Server installation related issues : During InfoSphere Information Server 9.1 installation, users might get the message "The image properties file was not found...." In order to avoid this message,You need to download the proper IIS_V9.1_BUNDLE*.zip which contains the license key from the Passport Advantage site for your
purchased InfoSphere Information Server 9.1 product edition and unpack
it into your product media directory,e.g.... [More]
Information Management Bootcamps are technical workshops in a classroom setting. They are held throughout the year in different regions worldwide. These bootcamps contain detailed lectures and labs for deep-dive learning of DB2® 10, Informix®, InfoSphere® products, Optim™, Guardium®, Big Data® and PureData®. Each bootcamp includes a free Technical Mastery Test and/or IBM Certification Exam All available bootcamps listed in here InfoSphere Informatiion Server specific Bootcamps are listed also below : InfoSphere Business Information Exchange... [More]
There is a number of artifacts listed below that are requested by InfoSphere Information Server Support Team. Providing them during initial PMR creation facilitate issue investigation and troubleshooting of the reported problems
The requested items are:
1. Version.xml files for InfoSphere Information Server and Client machines
2. Operating systems Information of InfoSphere Information Server and Client machines
3. The detailed description of the problem and/or screenshots if relevant
4. If Datastage job... [More]
So, someone asked you to install InfoSphere DataStage Server for a new environment in your enterprise, or, to install the new DS version.
You, obviously, ask for the media (CD/DVD/zip) to install it, but, then you realize that you have to obtain it from wherever it's legal to obtain. Question now is... where? how?
Here are some links to download installation packages of InfoSphere DataStage Server 8.7 for different operating systems from IBM Passport Advantage.
So start downloading and install IS DataStage!!
Be honest.... When was the last time you went out to the IBM Education Assistant site?
(WOW, that really ~has~ been a long time! But, even if you were there 2 days ago, a lot has already changed.)
The latest updates:
THIRTEEN new educational modules went live just in the Electronic Support tools and resources section:
Fix Central mobile
Benefits of signing in to Support Portal
How to download an AIX fix from Fix Central
How to download a... [More]
Application using IBM Data Server Driver for JDBC & SQLJ (db2jcc.jar) is an UNICODE client.
When accessing an ASCII Stored Procedure or UDF from a UNICODE client in a DB2 LUW/SAP environments where ALT_COLLATE and DB2_IMPLICIT_UNICODE set on DB2 server, SQL0873N error is expected and is working as designed.
To Workaround the issue, pre-empt the query with a select from SYSIBM.SYSDUMMY1 (a view in DB
code page), so that DB2 commits to the codepage of the database, instead of Unicode and prevents the error.
While your business is growing, you might face some performance issues, that weren't there when you started using DataStage, or even worse, DataStage, has never been as fast as you thought it would be.
As follows, I'm sharing with you some tips to check in general and specific environments, maybe it's matter of changing a parameter or maybe you have to install a product Fix, but remember, it's always useful to test in a controlled environment, stress your environment, and review if modifications helped or not.
There are multiple ways to migrate to InfoSphere Information Server, Versions 8.5, 8.7, or 9.1 depending on the version of InfoSphere DataStage or InfoSphere Information Server you are migrating from, the InfoSphere Information Server products installed, and other factors. IBM offers a Concierge Program for free to provide guidance on the best approach to migrate to Information Server, Version 8.5, Version 8.7, or Version 9.1.
The Concierge Program is offered to all customers, but it is particularly important for customers using the... [More]
IBM Software Support Handbook provides guidelines and reference materials that you may need when you require IBM service and support.
Actual terms and conditions are found in the license materials for your software.
IBM Software Support Handbook includes the following objectives :
Introduce you to IBM Software Support
Share information on the people that make up our World Wide (WW) IBM Software Support Organization
Provide information on the support... [More]
Recently I came across a problem, where we saw the timestamp value returned by DB2 Java application was off by 1 hour than the actual timestamp value being stored in database. This was happening only for timestamp values falling in Daylight Savings range. These are the steps I used to reproduce the issue:
1> Create table timestamptest( col1 timestamp)
2> db2 "insert into timestamptest values ('2013-03-10-18.104.22.1682013')"
3> Select from timestamptest
I thought I would get my BLOG started by saying I'm excited about 12.10 the latest and greatest INFORMIX
DYNAMIC SERVER which was available for download as of March 26.
When downloading the product from Passport Advantage (PPA) you will notice a new naming convention.
In a nutshell, as far as name changes go, Growth became Workgroup, Ultimate became Enterprise, and Warehouse became Advanced.
Check this out!
Here is a full list of Developer Works articles on DB2 for Linux, Unix and Windows Optimizer that our experts have published to this date which you may find useful.
1) Get the most out of DB2 optimizer: Leveraging statistical views to improve query execution performance
2) Recreate optimizer access plans using db2look
3) ... [More]
Informix introduced the PSM (Primary Storage Manager); a new backup storage manager in version 12.10 that replaced the previous ISM (Informix Storage Manager). The PSM manages storage devices used for backup and restore requests that are issued by Onbar. This storage manager supports both serial and parallel processing for backup and restore requests. PSM is easier to set up and use, even in embedded environments. You just need to perform four simple steps to configure PSM and take an Onbar backup:
Decide where you will create the... [More]
Looking for information about end of support dates for DB2 products on Linux, Unix and Windows to plan ahead for upgrade?
Here are the some links you will find it useful.
List of End of support dates for different versions of DB2 Products on Linux, Unix and Windows:
Common FAQ on End of Support products:
Keeping track of your Netezza product names and model numbers can be tricky. The list below summarizes this information in a quick reference table.
IBM Netezza product names and models numbers
Product Line A : PureData System For Hadoop
Product Line B : PureData System for Analytics
Models : "TwinFin product line":