Known problems for InfoSphere Information Server, Version 9.1.2, are documented in APARs and technotes, which are available on the IBM Support Portal.
The following table provides links for customized queries for APARs and technotes for Version 9.1.2.
IBM InfoSphere Information Analyzer evaluates the content and structure of your data for consistency and quality. The following links contain answers to the frequently asked questions about installing, configuring, and running InfoSphere Information Analyzer.
Find the answers to frequently asked questions about installing IBM® InfoSphere® Information Analyzer such as how to correct an error about insufficient space and how to access the log files.
Where are the installation log files?
What should I name the IBM InfoSphere DataStage project during installation?
After installation, why am I unable to log into the IBM InfoSphere DataStage Director client?
Find the answers to frequently asked questions about configuring IBM® InfoSphere® Information Analyzer such as which manual steps you must complete after installation and how to set up an ODBC DSN.
How do I start InfoSphere Information Server on a UNIX or Linux platform?
The installer finished. Do I need to perform any manual steps to complete the installation?
How do I set up an ODBC DSN on UNIX or Linux?
How do I start or restart the ASBAgent?
How do I see if DB2 is running?
How do I stop or start DB2 on UNIX or Linux?
How do I change the locale of a UNIX or Linux server?
If the IBM InfoSphere DataStage server is installed on the same machine as that of the InfoSphere Information Server, how do I test the DSN that was created on the UNIX or Linux server?
Find the answers to frequently asked questions about uninstalling IBM® InfoSphere® Information Server, such as how to proceed if uninstallation fails.
How do I uninstall InfoSphere Information Server?
Uninstallation failed. What should I do now?
IBM InfoSphere Information Server 9.1 has been updated to version 9.1.2. This link describes the changes and enhancements in the 9.1.2 release, including updates to documentation. The software updates include enhancements to InfoSphere DataStage and QualityStage, InfoSphere Metadata Asset Manager, InfoSphere Business Glossary, and connectors. Documentation changes include improvements to information about InfoSphere DataStage, connectors, and stages.
Summary of fixes included in IBM InfoSphere Information Server, Version 9.1.2, with fixes grouped by components
InfoSphere Information Server, Version 9.1.2 includes fixes for product modules and components: ASB Packs, Business Glossary, Connectivity, Balance Optimizer, DataStage, DataStage Engine, DataStage Mainframe, DataStage Parallel Engine, Fast Track, Information Analyzer, Install, Information Services Director, Information Server Framework, Information Server Tools, Metadata Asset Manager and Metadata Integration Bridges, Metadata Workbench, Metadata Common Services, Quality Stage, XML Pack, DataClick and ODBC drivers
InfoSphere Information Server Version 9.1.2 is now available for Windows, AIX, Solaris, Linux for System Z, HP-UX Itanium and Redhat and SUSE Linux
To troubleshoot issues with IBM® InfoSphere® Information Server, you can consult log files and temporary files
Installation log files
Log files are created during the installation and uninstallation process. You can use the log files to troubleshoot installation errors.
Operating system Directory
AIX® HP-UX Solaris /var/tmp/ibm_is_logs
Temporary files generated by installation program
Temporary files are created during the installation process. The temporary files are not used after the installation is completed.
During the installation process, temporary files are saved to the following installation directories
Operating system Directory
AIX® HP-UX Solaris /var/tmp
IBM WebSphere Application Server system log files
The WebSphere® Application Server log files contain information that you can use to monitor WebSphere Application Server startup and diagnose errors.
The following log files are useful for diagnosing problems with IBM® InfoSphere® Information Server:
WebSphere Application Server messages to STDOUT are redirected to this file.
WebSphere Application Server messages to STDERR are redirected to this file.
These files are located in the following directories on each node in your WebSphere Application Server installation:
Operating system Directory
AIX® HP-UX Solaris path/profiles/profile/logs/server1
Path refers to WebSphere Application Server installation path. By default, path is one of the following paths:
Operating system Directory
AIX HP-UX Solaris opt/IBM/WebSphere/AppServer
The IBM InfoSphere DataStage and QualityStage Operations Console is a web application that allows the DataStage engine components of an InfoSphere Information Server installation to be monitored in real time. This provides a complete view of all DataStage job runs on that system, both present time and historic. It also includes the monitoring of key operating system metrics such as CPU usage, free memory and disk space.
We have gathered few published documents concerning this topic below for you :
Explore the IBM InfoCenter documentation for operations database schema.
Explore the IBM InfoCenter documentation for Operations Console.
Read the developerWorks article "Get started with the IBM InfoSphere DataStage and QualityStage Operations Console Database, Part 1: An introduction" (developerWorks, May 2012) to get a deep dive into the schema of the IBM InfoSphere DataStage and QualityStage Operations Database, and the tables and columns that make up its key relationships.
The developerWorks article "Configuring and using IBM InfoSphere DataStage and QualityStage Operations Console in a multiple-node or grid environment" (developerWorks, August 2012) describes how system information can be selected and displayed in the Operations Console UI.
The developerWorks article "Configuration and tuning guidelines for IBM InfoSphere DataStage Operations Console" (developerWorks, July 2012) provides configuration and tuning guidance on how to minimize the performance effect of the Operations Console on the system.
Watch the "InfoSphere DataStage Operations Console" demo of the Operations Console.
The IBM Information Management best practices present advice on the optimal way to use a variety of IBM Information Management products. They include technical papers, presentations, and articles authored by leading experts in IBM's development and consulting teams and are designed to give you practical advice to improve the value of your IBM data servers and data integration products.
Best practices for IBM InfoSphere Information Server
These best practices papers present advice on ways you can leverage InfoSphere Information Server to satisfy key business requirements for your information integration solutions. These articles are authored by leading experts in IBM's InfoSphere development and services teams. Each best practice paper is designed to provide practical guidance for common InfoSphere implementation scenarios. By applying these recommendations, you may improve the value of your InfoSphere solution and align yourself with IBM's technical direction for InfoSphere.
Best practices for DB2 for Linux, UNIX, and Windows and InfoSphere Warehouse
Discover the best practices for IBM® DB2® for Linux®, UNIX®, and Windows® and IBM InfoSphere Warehouse products. Get practical guidance for the most common DB2 product configurations and use this knowledge to improve the value of your DB2 data servers
Best practices for IBM® DB2® for z/OS
Discover the best practices for IBM® DB2® for z/OS®. Get practical guidance for the most common DB2 product configurations and use this knowledge to improve the value of your DB2 data servers
Discover the best practices for MDM
These best practices papers present advice on ways you can leverage IBM® InfoSphere™ MDM to satisfy key business requirements of master data management solutions. These articles are authored by leading experts in IBM's MDM development and services teams
Discover the best practices for IMS
These best practice papers present advice on the most optimal ways you can use IMS to satisfy key business data processing needs. Each best practice paper is designed to provide practical guidance for the most common IMS product configurations. By applying these recommendations, you may improve the value of your IMS data servers and align yourself with IBM's technical direction for IMS
IBM offers a number of information management related free ebooks that were written and published with the cooperation of subject matter experts and the community
Please see the some of published free ebooks :
Understanding Big Data :
In this book, the three defining characteristics of Big Data -- volume, variety, and velocity, are discussed. You'll get a primer on Hadoop and how IBM is 'hardening' it for the enterprise, and learn when to leverage IBM InfoSphere BigInsights (Big Data at rest) and IBM InfoSphere Streams (Big Data in motion) technologies. Deployment and scaling strategies plus industry use cases are also included in this practical guide. Review this book and get started with big data!
Getting Started with DB2 Express-C
This ebook is ideal for developers, consultants, ISVs, DBAs, students, or anyone who wants to get started with DB2. While this ebook focuses on DB2 Express-C , the free database edition of DB2, the concepts and content are equally applicable to other DB2 editions on Linux, UNIX, and Windows.
Getting Started with InfoSphere Data Architect :
InfoSphere Data Architect (IDA), formerly known as Rational Data Architect, is the premier tool from IBM for database design and more!. Learn how to use it in conjunction with DB2 Express-C, the no-charge edition of DB2. Since IDA is built on top of Eclipse, you can integrate it easily with other tools from IBM such as Data Studio also built using Eclipse technology. This book is for beginners in IDA and also in data modeling.
Getting Started with DB2 Application Development
DB2 Express-C from IBM is the no-charge edition of DB2 data server for managing relational and XML data with ease. DB2 Express-C runs on Windows®, Linux®, Solaris, and Mac OS X systems, and provides application drivers for a variety of programming languages and frameworks including C/C++, Java, .NET, Ruby on Rails, PHP, Perl, and Python. Review this book and get started with DB2 application development!
Data is one of the most valuable assets a company has. Relational and hierarchical databases have been used in the industry for decades. This book teaches you the fundamentals of databases, including relational database theory, logical and physical database design, and the SQL language. Advanced topics include using functions, stored procedures and XML. Use this book in conjunction with InfoSphere Data Architect software for database design, and with DB2 Express-C , the no-charge edition of the DB2 database server, and put your new knowledge into practice
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 InfoSphere Foundation Tools (Business Glossary, Metadata Workbench, FastTrack, Information Analyzer) to contact the Concierge Program for guidance and the recommended tools for migration
Please refer to the link to learn more about IBM Concierge Program
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 related issue, the export of the job
To export the job:
Log in to Datastage Designer
Choose Export > Datastage Components on the top menu
Add items to export in Repository Export window
Choose directory to export to a file
Select preferred type (dsx) of the export
5. If Datastage related issue, export of Datastage job log
To produce the detail log file:
Log in to Datastage Director
Select the job-log on the menu
Select menu item View-Show All
Select menu item: Project-Print
Select options - All-Entries -- Full Detail- print a file.
6. In certain cases, InfoSphere Information Server Support Team might request ISALite diagnostic tools logs. For its usage,please refer to the link
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. 'is-suite' directory, please visit the related technote
- The Data Masking stage requires Optim Data Privacy Providers, which is a library to mask privacy data. To use the Data Masking stage, you must install Optim Data Privacy Providers on the InfoSphere Information Server engine tier. Refer to the technote that contains information about installing the IBM InfoSphere DataStage Data Masking stage and installing and configuring Optim Data Privacy Providers, version 9.1.
- Go to the technote to get to know about infoSphere Information Server, Version 9.1 installation issue on Solaris
There are few recently published technotes (FAQs) concerning the product: InfoSphere Information Server that you might find interesting
- Please refer to the technote how to suppress individual warnings from the DataStage DB2 Enterprise stage in a server job
- To learn the differences between a compile and force compile please check the technote
- Go to very easy technote ,to get to know about datastage partitioning requirements for Range-lookups
- Refer to technote to get to know what Information Server clients count toward the "Concurrent User Connections" license limit
Do you want to develop highly efficient and scalable information integration applications using IBM InfoSphere DataStage parallel jobs?
Then this Redbook from IBM expert practitioners with combined proven experience is a must read! InfoSphere DataStage Parallel Framework Standard Practices
This Redbook includes a comprehensive detailed description of the components available and descriptions on how to use them to obtain scalable and efficient solutions for both batch and real-time scenarios. The Redbook is intended for IT architects, Information Management specialists, and Information Integration specialists responsible for delivering cost-effective IBM InfoSphere DataStage performance on all platforms.
IBM InfoSphere Information Server, Version 8.7 Fix Pack 2 is available at IBM Support FixCentral.
IBM InfoSphere Information Server, Version 8.7 Fix Pack 2, includes updates to the following product modules and components: Business Glossary, DataStage, FastTrack, Information Analyzer, Information Services Director, Metadata Workbench, QualityStage, Connectivity, Information Server Framework, Balance Optimizer, Metadata Asset Manager, Metadata Integration Bridges, Metadata Common Services, Operational Metadata, XML Pack, and the DataDirect ODBC drivers.
Model-related problems can cause imports from InfoSphere Data Architect to fail or to create duplicate objects. This can happen when the import file contains disconnected objects, invalid keys, duplicate relationships, or duplicate objects.
guides you through some troubleshooting methods to import InfoSphere Data Architect MetaBroker into InfoSphere Information Server successfuly
If you use InfoSphere Information Server V8.7 and you want to import metadata
from IBM Cognos Version 10,please refer to the technote
to learn how to enable metadata imports from Cognos 10 in InfoSphere Information Server,