Related links:
Title
|
Date
|
|---|---|
| Extract data from Excel sources in IBM InfoSphere Information Server using
DataStage Java Integration Stage and Java Pack
Explore the functions
of the Java Integration Stage (DataStage Connector) introduced in IBM
InfoSphere Information Server version 9.1. This article addresses the Excel
data source connectivity problem in older releases of IBM InfoSphere Information
Server (7.5.x, 8.0.x, 8.1.x, 8.5.x, and 8.7.x) using Java Pack Plug-ins and the Java Pack
API. The older releases of Information Server do not have a dedicated component for
Excel connectivity. Third-party ODBC to ODBC bridges were used as an alternative, but they
are licensed. The Java Pack Stages coupled with the Java Pack API and Apache POI API can
be used to fetch Excel data into DataStage in a cost-effective way.
|
23 May 2013 |
| IBM Business Analytics Proven Practices: IBM Cognos Active Report 10.2 Cookbook
A description of the various features available within IBM Cognos Active Report and how they can be used to create and distribute interactive reporting applications.
Also available in:
Chinese
|
23 May 2013 |
| Build a data library with Hive
Storing massive amounts of data is great until you need to do something with
it. No incredible discoveries or futuristic predictions come from unused data, no matter how
much of it you store. Big data can be a complicated beast. Writing complex MapReduce
programs in the Java programming language takes time, good resources, and know-how that most
organizations don't have available. This is where building a data library using a tool like Hive
on top of Hadoop becomes a powerful solution.
|
21 May 2013 |
| Performance characteristics of IBM InfoSphere Information Server 8.7
running on VMware vSphere 5.0 on Intel Xeon Processors
With the continuous growth of processing power and the increasing number of processor cores in servers,
virtualization has become very attractive for many companies. As more and more IBM InfoSphere Information Server
customers begin to adopt virtualization technology, understanding the performance characteristics of InfoSphere
Information Server running in virtualized environments has become critical.
|
17 May 2013 |
| Online DB2 for z/OS migration
Increasingly, customers must keep their applications online and available
all hours of every day, 24X7. Fortunately, the DB2 migration process has been designed
specifically to allow the business application set to continue to run while
you migrate. This article provides hints and tips to make your online migration
successful.
|
16 May 2013 |
| Schema replication with IBM InfoSphere Data Replication, Part
1: Uni-directional schema subscriptions in DB2 for Linux, UNIX, and Windows
10.1
IBM InfoSphere Data Replication allows the synchronization of data between two or
more database management systems either on the same or on different operational
platforms. Many different usage scenarios exist. Starting in Version 10.1 of IBM
InfoSphere Data Replication, replication is now supported at the schema level. This
means that defined changes to the database structure such as the creation of new
tables are automatically added to the replication system without any need for
administration or intervention. This not only eliminates or greatly reduces the
administrative efforts when tables are added or changed at the primary database but also
significantly increases the reliability of the replication system, especially when used
as a synchronization mechanism for an active disaster recovery site. This article is the
first in a series that uses a disaster recovery use case to explain how to set up
schema-level subscriptions for uni-directional replication topologies available in the Q
Replication technology that comes with IBM InfoSphere Data Replication v10.1.3 for
Linux, UNIX, and Windows. We encourage you to replay the scenario. To make this as
convenient as possible, various scripts are provided in the Download section of this
article. Watch out for more articles in this series that cover schema-level
subscriptions for bi-directional topologies and more.
|
16 May 2013 |
| Analyze text from social media sites with InfoSphere BigInsights
Learn how you can start creating, testing, deploying, and using custom text extractors to analyze social media data and other forms of text data using technologies available in IBM's big data platform.
|
14 May 2013 |
| IBM Cognos Proven Practices: The IBM Cognos 10 Dynamic Query Cookbook
This document is intended to provide a single point of reference for techniques and product behaviours when dealing with the Dynamic Query Mode delivered with IBM Cognos 10.
Also available in:
Chinese
|
13 May 2013 |
| Optim Query Tuner: Capture and tune DB2 z/OS SQL statements using a user-defined SQL repository
Learn how to create query workloads directly from your own SQL repository, without
the overhead of archiving or staging your workload data. Leverage the Query Tuner user
interface to define dynamic and static SQL statement filters, and tune the saved workload
without implementing your own client. This article describes how you can define database
views against your existing SQL repository that stores dynamic or static SQL
statements in your environment. The Optim Query Tuner user-defined SQL repository can use these views to filter and capture SQL statements directly from your SQL
repository for single-query tuning or workload tuning.
|
09 May 2013 |
| Integrating InfoSphere Streams 3.0 applications with InfoSphere
Information Server 9.1 DataStage jobs, Part 1: Connecting the Streams job and DataStage job
This article describes the integration architecture between InfoSphere
Streams and InfoSphere DataStage, and it provides step-by-step instructions
for connecting InfoSphere Streams 3.0 applications with InfoSphere DataStage
9.1 jobs using the InfoSphere Streams DataStage Integration toolkit for
Streams and the InfoSphere DataStage Streams connector.
|
09 May 2013 |
| DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX, and Windows
IBM DB2 10 for Linux, UNIX, and Windows has out-of-the-box support for
Oracle's SQL and PL/SQL dialects. This allows many applications written
against Oracle to execute against DB2 virtually unchanged. In this article,
get a high-level overview of what Oracle compatibility means in DB2. Whether
you want to switch your custom application to DB2 or extend your DBMS vendor
support to DB2, now is your time.
|
08 May 2013 |
| An introduction to InfoSphere Streams
Learn about InfoSphere Streams, part of the IBM big data
platform. InfoSphere Streams addresses a crucial emerging need for platforms
and architectures that can process vast amounts of generated streaming data in
real time. Find out what the product is designed to do, when it can be useful,
how it works, and how it can complement InfoSphere BigInsights to perform
highly complex analytics.
|
07 May 2013 |
| Restricting database connections using the CONNECT_PROC database configuration parameter in DB2 for Linux, Unix, and Windows
System administrators are responsible for, among other things, protecting a database against unauthorized access
or misuse by authorized database users (for example, inappropriate access to sensitive information within a database).
A common requirement to mitigate such risks is ensuring that users are allowed to connect to the database only from
a list of trusted hosts or IP addresses that are known to be secure. This article gives a practical example of how
such a requirement can be put in practice by making use of the CONNECT_PROC database configuration parameter of
IBM DB2 for Linux, UNIX, and Windows.
|
02 May 2013 |
| Get the most out of DB2 optimizer: Leveraging statistical views to improve query execution performance
Statistical views provide the necessary sophisticated statistics to the optimizer
to more accurately model complex relationships. In this article, you learn
through examples how to identify these complex relationships and create
statistical views to allow the optimizer to compute more accurate cardinality
estimates.
|
02 May 2013 |
| Modeling created global temporary tables for DB2 with InfoSphere
Data Architect 8.5, Part 2: Modifying an existing data model
Business applications commonly need to reuse aggregated or processed data
from a set of data sources over a single series of operations. An example for this could
be generation of reports for analysis and decision making. In order to support this
need, some database vendors have introduced support for temporary tables that can
hold such aggregated or processed data. Beginning with IBM InfoSphere Data
Architect version 8.5, you can model created global temporary tables (CGTTs)
for DB2 for z/OS version 10 and DB2 for Linux, UNIX, and Windows version 9.7.
This two-part series will demonstrate how you can accelerate data modeling with
CGTTs with DB2 for z/OS version 10 and DB2 for Linux, UNIX, and Windows
version 9.7 by adopting InfoSphere Data Architect 8.5.
|
02 May 2013 |
| IBM SPSS Collaboration and Deployment Services 5.0: Clustering
The IBM SPSS Collaboration and Deployment Services 5.0 product
(also known as C&DS 5.0) is a JEE-based application that can be leveraged by
other IBM SPSS products to provide enhanced capabilities. As a JEE-based
application C&DS requires an application server to run on, and the logical
choice is the IBM WebSphere Application Server. This article describes how you
can configure C&DS 5.0 to run on an IBM WebSphere Application Server
Cluster in order to provide high availability and
scalability.
|
30 Apr 2013 |
| Integrate PureData System for Analytics and InfoSphere BigInsights for
email analysis
PureData System for Analytics is IBM's core warehousing platform and part of the PureSystems product family.
This article explains how to integrate it with InfoSphere BigInsights,
IBM's enterprise-ready Hadoop distribution. We'll discuss the
integration concepts, as well as a primary use cases for this integration,
combining the advanced text analytics capabilities of BigInsights with your warehouse.
We'll illustrate how to create a small scenario that enriches employee data with information
extracted from email. Then we will demonstrate how to extract this information in
BigInsights and how to upload the extracted results to PureData for Analytics.
We will also show how to access data stored in BigInsights from the warehouse to
facilitate drill-through capabilities.
|
30 Apr 2013 |
| Verify DB2 Net Search Extender indexes using the NSE Index Verification tool
DB2 Net Search Extender, here after called NSE, is an IBM DB2 extender providing
full text search support in DB2. NSE searches documents stored in columns of database
tables by maintaining its internal text indexes. Rather than searching sequentially
through text documents stored in database columns at query time, NSE uses its text
indexes to search in an efficient manner. Verification of NSE indexes are
vital because the errors reported by the top layer applications on full text index can be
misleading. This unnecessarily delays the problem resolution at the production system. To
prevent such a situation, the NSE Index Verification tool was developed to verify the NSE index
validity and consistency, and to check whether or not indexes are valid.
Also available in:
Chinese
|
25 Apr 2013 |
| Modeling created global temporary tables for DB2 with InfoSphere
Data Architect 8.5, Part 1: Getting started
Business applications commonly need to reuse aggregated or processed data
from a set of data sources over a single series of operations. An example for this could
be generation of reports for analysis and decision making. In order to support this
need, some database vendors have introduced support for temporary tables that can
hold such aggregated or processed data. Beginning with IBM InfoSphere Data
Architect version 8.5, you can model created global temporary tables (CGTTs)
for DB2 for z/OS version 10 and DB2 for Linux, UNIX, and Windows version 9.7.
This two-part series will demonstrate how you can accelerate data modeling with
CGTTs with DB2 for z/OS version 10 and DB2 for Linux, UNIX, and Windows
version 9.7 by adopting InfoSphere Data Architect 8.5.
|
25 Apr 2013 |
| DB2 pureScale Feature
The DB2 pureScale Feature keeps your distributed database system available 24x7.
WLB, ACR, and client affinities provide uninterrupted service during both planned and
unplanned outages. If a member fails, applications are automatically rerouted to
other DB2 members. When the failed member comes back online, applications are
transparently routed to the restarted member. With the DB2 pureScale Feature,
scaling your database solution to meet the most demanding business needs is easy.
|
25 Apr 2013 |
| Upgrading to Informix 12.10
IBM Informix version 12.10.xC1 comes with striking new features and enhancements in
existing features--as well as a few features or products that were removed. Understanding the
new, enhanced, and discontinued features is crucial for better planning and determining
which functions should be disabled or enabled during the upgrade process. This
minimizes the impact of conversion/reversion and results in a smooth upgrade
to Informix 12.10. This article provides all the necessary information to help
database
administrators make an informed decision on setting the 12.10 features during
conversion
and then changing the settings, if needed, after the upgrade. The article also covers the
required steps in case a reversion is needed.
|
25 Apr 2013 |
| InfoSphere MDM Collaboration Server V10.0 design strategy and
implementation, Part 2: A guide to designing and implementing solutions using IBM
InfoSphere MDM Collaboration Server v10.0
In Part 1 of this series, a sample business case scenario illustrated the best approach for designing and creating
technical specifications for an application using IBM InfoSphere Master Data
Management Collaboration Server v10.0. Part 2 examines the implementation strategy
and shows step-by-step how to build a robust application using InfoSphere
Master Data Management. Read this article to gain an understanding of the basic
considerations for implementing an application using MDM Collaboration Server.
|
24 Apr 2013 |
| Developing a big data application for data exploration and
discovery
Exploring big data and traditional enterprise data is a common
requirement of many organizations. In this article, we outline an approach and
guidelines for indexing big data managed by a Hadoop-based platform for use
with a data discovery solution. Specifically, we describe how data stored in
IBM's InfoSphere BigInsights (a Hadoop-based platform) can be pushed to
InfoSphere Data Explorer, a sophisticated tool that enables business users to
explore and combine data from multiple enterprise and external data sources.
|
23 Apr 2013 |
| What's new in DB2 10.5 for Linux, UNIX, and Windows
This article outlines the key features and enhancements in IBM
DB2 10.5 for Linux, UNIX, and Windows. To be released in June, this latest
version delivers a wide range of new function that directly addresses your
business needs in the areas of cost reduction, application performance,
productivity, and reliability.
|
23 Apr 2013 |
| Compare the Informix Version 12 editions
Get an introduction to the various editions of IBM Informix, and compare features,
benefits, and licensing considerations in a
side-by-side table. Regardless of which edition you choose, Informix brings you
legendary ease-of-use, reliability, stability, and access to extensibility
features.
|
18 Apr 2013 |
| Accelerate the path to PCI DSS data compliance using InfoSphere Guardium
This article gives you a step-by-step overview of using the Payment Card
Industry (PCI) Data Security Standard (DSS)
accelerator that is included with the standard InfoSphere Guardium data security and
protection solution. The PCI DSS is a
set of technical and operational requirements designed to protect cardholder data and
applies to all organizations who store, process, use, or transmit cardholder data.
Failure to comply can mean loss of privileges, stiff fines, and, in the case of a data
breach, severe loss of consumer confidence in your brand or services. The InfoSphere
Guardium accelerator helps guide you through the process of complying with parts of the
standard using predefined policies, reports, group definitions, and more.
|
18 Apr 2013 |
| Introduction to the DB2 Continuous Data Ingest feature
IBM DB2 10.1 for Linux, Unix and Windows has introduced the Continuous Data Ingest
feature. The INGEST command provides an alternative to the known methods of previous DB2
versions: IMPORT and LOAD. In this article you will understand the main Ingest
concepts and find examples and situations where this tool will help you to populate your
databases.
|
18 Apr 2013 |
| Creating data marts with the IBM OpenAdmin Tool (OAT) for Informix
The IBM OpenAdmin Tool (OAT) for Informix is a web application for
administering and analyzing the performance of IBM Informix database servers. You can
now use OAT to administer Informix Warehouse Accelerator. Informix Warehouse Accelerator
processes warehouse queries more quickly than the Informix database server does. With
OAT, you can create data marts based on workload analysis, which is a process that
analyzes the query workload in a data warehouse. You can use OAT to schedule loads to
refresh the data in the data marts. You can also use OAT to create and drop accelerators
and enable and disable data marts. In this article, learn how to create data
marts using OAT.
|
18 Apr 2013 |
| IBM Cognos Proven Practices: IBM Cognos BI – Improve Performance for Interactive Relational Data Access
Guidelines and techniques that can help to improve performance when authors and analysts deal interactively with relational data sources within the IBM Cognos BI studios (Query Studio, Analysis Studio, Report Studio Express).
|
16 Apr 2013 |
| Accelerating batch processing with IBM DB2 Analytics Accelerator
This article provides an overview of the benefits that a company can achieve by introducing IBM DB2 Analytics Accelerator in their batch processing systems.
The example given is
based on real implementations done at Swiss Re, a major re-insurance company based in Zurich, Switzerland.
|
16 Apr 2013 |
| Calling Python code from IBM InfoSphere Streams
The Python programming language is a popular choice among
enterprise developers to quickly put together working solutions. Many
companies adopt Python to build IT assets for regular use. IBM InfoSphere
Streams is a novel middleware product designed for implementing logic directly
in C++ and Java. It is also possible to call Python code within the context of
a Streams application. Learn how to call Python code directly from IBM
InfoSphere Streams applications.
|
15 Apr 2013 |
| DataStage command line integration
Develop IBM InfoSphere DataStage jobs that can be called from a
command line or shell script using UNIX pipes for more compact and efficient
integration. This technique has the potential of saving storage space and bypassing
landing intermediate files that eventually will feed an ETL job. This also reduces
overall execution time and allows sharing the power of DataStage jobs through
remote execution.
|
04 Apr 2013 |
| IBM Mobile OpenAdmin Tool for Informix
Have you ever wanted to monitor your IBM Informix database servers on
the go from your mobile device? This article introduces the IBM Mobile OpenAdmin Tool
for Informix (OAT) application. It explains how you can use this new app to check the status
and performance of one or more Informix database server instances quickly and easily
from the palm of your hand. It describes how to set up Mobile OAT and how to
connect it to your regular OpenAdmin Tool for Informix installation. This article also
outlines some recommended security best practices when using Mobile
OAT.
|
04 Apr 2013 |
| Tuning the Oracle Connector performance in IBM InfoSphere
DataStage, Part 2: Optimization of bulk load operation and considerations for reject links and
data types
The Oracle Connector is a connectivity component in IBM InfoSphere
Information Server. It is utilized by IBM InfoSphere DataStage and other
products in the Information Server suite to perform extract, lookup, load,
and metadata import operations on Oracle databases. This article is Part 2
of a series of two articles that provide a set of guidelines for tuning the
Oracle Connector stages in DataStage parallel jobs with the goal of
maximizing their performance.
|
04 Apr 2013 |
| Tuning the Oracle Connector performance in IBM InfoSphere DataStage, Part 1: Overview of the connector tuning process and optimization of fetch, lookup and DML operations
The Oracle Connector is a connectivity component in IBM InfoSphere
Information Server. It is utilized by IBM InfoSphere DataStage and other products in the
Information Server suite to perform extract, lookup, load, and metadata import operations
on Oracle databases. This article is Part 1 of a series of 2 articles that provide
a set of guidelines for tuning the Oracle
Connector stages in DataStage parallel jobs with the goal of maximizing their
performance.
|
28 Mar 2013 |
| Simplify backup and recovery with IBM DB2 Merge Backup
for Linux, UNIX, and Windows
It is important to have an up-to-date and consistent backup available so that you can speed database recovery times.
IBM DB2 Merge Backup for Linux, UNIX and Windows gives you alternative strategies to eliminate the need to take regular DB2 full
backups and instead use multiple delta and incremental backups to build a new full
backup copy that is fully recognized by DB2. This step-by-step article introduces you
to IBM DB2 Merge Backup and teaches you how to create merge backups using the control file structure in IBM DB2 Merge Backup.
|
28 Mar 2013 |
| Selected common SQL features for developers of portable DB2 applications
This summary of the common SQL application features is a quick reference for application developers who need to understand the
frequently used features and functions across platforms.
|
28 Mar 2013 |
| IBM InfoSphere DataStage job validation steps using IBM Optim Test Data
Management Solution
Large numbers of extract, transform, and load (ETL) jobs need to be
validated during the following two common job
lifecycle scenarios: Migrating ETL projects/jobs from older version to a new
version, or moving jobs from development to QA to production. Enterprises typically validate that
their jobs running in a new version of the software or new hardware environment are
producing same results as before, giving them confidence that the new system can replace
the old system. In a similar way, before a job in the data integration process is
deployed in the production environment, it must be shown to have the expected behavior
in development, testing, and production environments. In this article, a
step-by-step example is given on how DataStage users can use IBM InfoSphere
Optim Test Data Management Solution to validate the results of ETL jobs.
|
28 Mar 2013 |
| Supply cloud-level data scalability with NoSQL databases
This article explores NoSQL databases, including an overview of the
capabilities and features of NoSQL systems HBase, MongoDB, SimpleDB. It also covers cloud and NoSQL database design basics.
|
25 Mar 2013 |
| Zigzag join enablement for DB2 star schema queries
IBM DB2 10.1 Linux, UNIX, and Windows introduces a new join method called zigzag join. Zigzag join
improves consistency in performance as well as reduces the execution time of
queries in data warehouse or data mart environments with large volumes of
potentially partitioned data, complex ad hoc queries, and where database
design uses a star schema. This article provides insight into the eligibility
criteria of selecting the zigzag plan, how the zigzag join method works, using
a zigzag join with a gap in the fact table multi-column index, using the
ZZJOIN operator, and using the index advisor for zigzag join.
|
21 Mar 2013 |
| OpenAdmin tool for Informix's Health Advisor plug-in
This article is a deep dive into the Health Advisor plug-in for the OpenAdmin
Tool for Informix. As the graphical user interface for monitoring and
administering the Informix database server, the OpenAdmin Tool for Informix (OAT) is
an ideal vehicle for a health check system for your database server. With the
introduction of the Health Advisor plug-in, you can use OAT to regularly analyze the
health and performance of your Informix database server. This article covers how the
Health Advisor plug-in works, how to use it, and how it can benefit an Informix DBA. It
also provides a step-by-step guide to customizing the Health Advisor by adding your own
health checks and alarms.
|
21 Mar 2013 |
| DB2 Tools corner: Using IBM Tools Customizer for z/OS in a multiple-LPAR environment
Although Tools Customizer currently supports only the local LPAR, you can use several methods to customize products on multiple LPARs where Tools Customizer
is not installed.
Also available in:
Russian
|
14 Mar 2013 |
| Capture and store DB2 performance data in an easy way
Did you ever wonder how you can collect performance data about your DB2
system in a simple way without using extra tools? In this article, learn
how to leverage the new DB2 for Linux, UNIX, and Windows monitoring framework available
in V10.1 (initially introduced in version 9.7). The article also explains how to combine DB2
utilities to select, capture, and store data that you can use for analysis with plain SQL
or using BI tools.
Also available in:
Russian
|
14 Mar 2013 |
| Enhancing IBM Enterprise Market Management solutions with master data
Having good data backing Enterprise Marketing Management (EMM)
solutions reduces the number of duplicate, missing, and incorrect offers that you send to
your customers and prospects. In this article, learn the design considerations and
patterns for supplying master data to EMM solutions. The article also
describes good practices when using IBM InfoSphere Master Data Management in
your solution. After you have a
single view of the master data for EMM, you can leverage this source-trusted data across
your enterprise. Master data then becomes the foundation of your Smarter Analytics and
Smarter Commerce solutions.
|
14 Mar 2013 |
| A guided tour to IBM Database Patterns, Part 4: Provision and manage your database using the REST API and command-line
interface
IBM Database Patterns provides solutions to easily provision and manage databases
on IBM Workload Deployer (IWD) in a private cloud. IWD is a cloud management appliance
that delivers a patterns-based approach to deploy and manage application
environments in the cloud. The REST API and command-line interface enables you to use IBM
Database Pattern in batch processing with no GUI, thereby allowing it to be mashed up
into existing applications and user interfaces.
|
07 Mar 2013 |
| IBM Cognos Proven Practices: IBM Cognos Insight – Overview and Use Case
This document will demonstrate the power and flexibility of IBM Cognos Insight by giving an overview of how the desktop tool can be used as a stand alone application as well as an integrated piece of IBM Cognos TM1 and Business Intelligence. A sales plan use case will also be demonstrated to show how IBM Cognos Insight is used in the creation, publishing, and contribution of a plan to the distribution of professional reports detailing the results of the plan. This use case will illustrate the life-cycle of a collaborative effort to budget and report for one year of the business.
Also available in:
Chinese
Portuguese
|
28 Feb 2013 |
| Using InfoSphere Streams with Informix
Learn you how to connect and use Informix as a data source or a data target with InfoSphere Streams. It covers the use of both the Informix-specific protocol
and the more general IBM Common Driver protocol that is used by several IBM database products. After reading this article, a reader will be able to use Informix in a Streams environment.
|
28 Feb 2013 |
| IBM Accelerator for Machine Data Analytics, Part 4: Speeding the up-and-running experience for a variety of data
Machine logs from diverse sources are generated in an enterprise in voluminous quantities. IBM Accelerator for Machine Data Analytics simplifies the task of
implementation required so analysis of semi-structured, unstructured or structured
textual data is accelerated. In this article, the fourth in a series, learn
step-by-step how to use the web or Eclipse tooling in IBM InfoSphere BigInsights to more
quickly get up-and-running with IBM Accelerator for Machine Data Analytics.
|
28 Feb 2013 |
| Designing an alerts mechanism on the IBM InfoSphere DataStage and QualityStage
Operations Console Database, Part 1: Alerts for common scenarios
The IBM InfoSphere DataStage and QualityStage Operations Console is a
web-based application that is used to monitor the DataStage engine components in real
time. It consists of a back-end database, DataStage Operations Database, where all the
information about job runs and system resources is stored. This article describes an
approach on how to construct email alerts on the operations database using database
triggers. Also, you will learn how to use the data
that is available in the operations database tables and how these tables get updated.
|
28 Feb 2013 |
| Use the InfoSphere Optim 9.1 Test Data Management and Data Masking solution
for Netezza Data Warehouse
IBM Netezza is known as the simple data warehouse appliance for serious
analytics. Customers using Netezza have been looking at ways to leverage InfoSphere
Optim to create their right-sized environments with realistic data for application
testing and development. InfoSphere Optim 9.1 now has native support for Netezza to
leverage Test Data Management (TDM) and Data Masking (DM) capabilities. This
developerWorks
article will give you an understanding of InfoSphere Optim solutions for Netezza,
help you understand the technical architecture between the two products, and
show you how Netezza can leverage the InfoSphere Optim solutions to reduce costs,
reduce risks, and speed up data delivery.
|
28 Feb 2013 |
| Use data-level security for granular access control of auditing results
in InfoSphere Guardium
InfoSphere Guardium offers enterprise-wide data activity monitoring for
data protection and auditing. Two critical elements to consider for a successful
enterprise implementation of InfoSphere Guardium for enterprise-wide data
protection and audit include support for separation of duties, and enterprise
deployment capabilities that eliminate redundant configurations and streamline
enterprise deployments to match your organizational structures. By using Guardium
data-level security mechanisms, administrators can assign responsibilities for
particular databases or systems to individuals (or groups) which align with their
hierarchical organizational structure. This article describes the benefits of
data-level security as well as step-by-step instructions for implementing the
solution for a sample scenario.
|
21 Feb 2013 |
| Implementing Windows desktop single sign-on for InfoSphere Business
Glossary
IBM InfoSphere Business Glossary 9.1 uses the Simple and
Protected GSS-API Notification (SPNEGO) support provided by WebSphere Application Server
to enable configuration of a seamless single sign-on environment for InfoSphere Business
Glossary and InfoSphere Business Glossary Anywhere users. Deploying this feature
requires correct configuration of several interlocking components, including some
synchronization details that might not be immediately apparent. This article
provides a step-by-step walkthrough of the configuration for a scenario that
includes using a
Microsoft Active Directory domain controller for the external user registry, Windows
Server 2008 on the WebSphere Application Server tier and for the domain controller, and
Windows 7 on the client tier. The article also includes troubleshooting tips and references for some
common pitfalls.
|
21 Feb 2013 |
| IBM Cognos Proven Practices: IBM Cognos 10 Audit Extension
A IBM Cognos 10 SDK application that provides additional auditing, including Role Auditing, for IBM Cognos 10 BI. The version of the application is 1.1.01 and it will work with IBM Cognos 10 BI versions 10.1 and up.
|
15 Feb 2013 |
| Choice of SUPERASYNC mode for disaster recovery using DB2 HADR
DB2 High Availability Disaster Recovery (HADR) is an easy-to-use data replication
feature of IBM DB2 for Linux, UNIX, and Windows that provides a high availability (HA)
solution for both partial and complete site failures. Beginning with DB2 V9.5 Fix Pack 8
and DB2 V9.7 Fix Pack 5, a new HADR sync mode called SUPERASYNC has been introduced.
This article explains the purpose of SUPERASYNC mode, the deployment of a HADR pair using this
mode, as well as standby state transition in this mode. In addition, it includes use case
scenarios that explain the implementation of SUPERASYNC mode for disaster recovery.
It will also look at how Primary will overcome the back pressure and
perform better in case of single or multiple standby, and what the benefits
and drawbacks are from using this mode.
|
14 Feb 2013 |
| What's new in RDF application development in DB2 10.1 Fix Pack 2
Beginning with DB2
10.1 for Linux, UNIX, and Windows, DB2 has supported RDF data and SPARQL
application development. In this article, learn about important enhancements for RDF
application development that were added in DB2 10.1 Fix Pack 2.
|
07 Feb 2013 |
| Configure Data Facility Storage Management Subsystem for DB2 10 for z/OS
installation
Installation of DB2 10 requires configuring z/OS Storage Management Subsystem
(SMS) for DB2 system objects, and migrating the system data sets to SMS to exploit its
benefits. Since the migration to DB2 10 is possible from DB2 8, some customers, upon
reaching DB2 10 new-function mode (NFM), can benefit from many features related to
z/OS SMS, including those introduced in DB2 9. This article will help you in
reorganizing DB2 catalog and directory objects.
|
07 Feb 2013 |
| Road map to real-time monitoring in DB2 for Linux, UNIX, and Windows
Are you wondering where to find the information you need to learn about and start using the
real-time monitoring information available in the DB2 for Linux, UNIX, and Windows product?
This article sets out a path through the documentation that will help you deal with this question
by providing direct links to the appropriate topics in the Information Center.
Also available in:
Russian
|
07 Feb 2013 |
| Save energy with the DB2 10.1 for Linux, UNIX, and Windows data compression feature
The DB2 for Linux, UNIX, and Windows data compression feature allows you to store your data in a compact form.
There are two known benefits of this approach: first, reduction of storage space, and second, improvement of performance.
In this article we describe a case study showing the third benefit: reduction of electricity consumption per unit of work.
As a result, data compression reduces the cost of database maintenance and
makes your database greener.
|
07 Feb 2013 |
| Choosing partitioning keys in DB2 Database Partitioning Feature
environments
Choosing proper partitioning keys is important for optimal query
performance in IBM DB2 Enterprise Server Edition for Linux, UNIX, and Windows
environments with the Database Partitioning Feature (DPF). To help with this
task, this article provides new routines to estimate data skews for existing
and new partitioning keys. The article also details best practices and shows
how to change a partitioning key while keeping the table
accessible.
|
04 Feb 2013 |
| Using DB2 for z/OS pureXML to process SEPA transactions
Single Euro Payments Area (SEPA) is a payment integration mechanism widely used in Europe to handle standard payment messages. Each SEPA document
can contain up to 100,000 credit transfer transactions and must be processed
accurately in a short period of time. This article outlines the author's experience in
performing a benchmark for a large European corporate and investment bank using DB2 for z/OS
pureXML for SEPA (ISO 20022). Learn how the team resolves obstacles and
eventually achieves their performance goal.
|
31 Jan 2013 |
| DB2 pureScale disaster recovery using Storwize V7000 Metro Mirror
The DB2 pureScale feature leverages the IBM Storwize V7000 storage system
synchronous remote copy function like Metro Mirror to maintain an identical copy on both
the primary and secondary volumes for the disaster recovery purposes. The Metro Mirror
features enable you to set up a relationship between two volumes, so that updates that
are made by an application to one volume are mirrored on the other volume. The volumes
can be in the same system or on two different systems. Read on to learn the steps
required to deploy a Metro Mirror solution with the Storwize V7000 storage
subsystem.
|
31 Jan 2013 |
| Using section explain in InfoSphere Optim Query Workload Tuner for DB2 for
Linux, UNIX, and Windows 3.2
Take advantage of the section explain feature in DB2 for Linux, UNIX,
and Windows 9.7.1 and later when you tune SQL with InfoSphere Optim Query Workload
Tuner 3.2.
|
24 Jan 2013 |
| Utilizing the DB2 HADR reads on standby feature in a business intelligence
environment
The DB2 High Availability and Disaster Recovery (HADR) feature is a
database replication method that provides a high availability solution for both partial
and complete site failures. HADR protects against data loss by replicating data changes
from a source database, called the Primary, to a target database, called the Standby.
The HADR reads on standby (HADR ROS) feature, allows read only applications to access
either the HADR Primary or the HADR Standby database. This enables an organization to
offload some of the read-only workloads running on the Primary to the Standby database.
This paper shows a practical application of this HADR ROS feature in conjunction with
Virtual IP addresses to ensure continued, automatic connectivity in an Business
Intelligence Environment.
|
24 Jan 2013 |
| Install IBM InfoSphere Guardium Data Encryption on the IBM PureApplication System
This article focuses on deploying the IBM InfoSphere Guardium data encryption software to provide data encryption for Red Hat Linux V6.2 IBM DB2
hosts. This software provides encryption for both regular files and DB2 files. InfoSphere
Guardium also provides a DB2 agent for DB2 encrypted backup and restore operations.
Also available in:
Chinese
|
16 Jan 2013 |
| Deploying DB2 pureScale with IBM Storwize V7000 6.4.0.1
A key aspect to the DB2 pureScale solution lies around the capabilities
of the underlying storage. In addition to that, DB2 pureScale takes advantage of
specific storage capabilities to enhance the solution. This paper will take you through
the value proposition of DB2 pureScale on IBM Storwize V7000 storage demonstrating a
solution that meets the needs of even the most demanding businesses.
|
10 Jan 2013 |
| Mask archived and extracted data directly into CSV, XML and ECM
formats using InfoSphere Optim Data Masking Solution
Learn how file format types that are now supported by IBM InfoSphere Optim
Data Masking Solution will help you to increase the interoperability of your data and
support data privacy and security requirements. This article describes options to convert your data
to XML, CSV, or ECM format types, and explains how various threshold limits can be
applied. In addition, you'll learn how to apply data privacy
modules for these file format types and how to manage LOB and XML data
types during this process.
|
10 Jan 2013 |
| Tips for using SQL to query foreign key relationships
This article discusses how to write SQL queries to find foreign key
relationships in IBM DB2 for Linux, UNIX, and Windows database. Given a
table with a primary key, you will learn how to return the children and
descendant tables, as well as the referential integrity (RI) relationship
paths from the parent table to these children and descendants. Also, you
will see how the query can be modified to return the results for all tables
in the database.
|
10 Jan 2013 |
| Configuring DB2 pureScale for backup and restore using Storwize V7000 V6.4.0.1
FlashCopy
The DB2 pureScale feature leverages the IBM Storwize V7000 storage system
FlashCopy services to mitigate critical requirements from the customer in an extremely
efficient manner. The FlashCopy function enables you to make point-in-time, full volume
copies of data, with the copies immediately available for read or write access. This
article describes the steps required to deploy a FlashCopy solution with the Storwize
V7000 storage subsystem.
|
03 Jan 2013 |
| IBM Accelerator for Machine Data Analytics, Part
1: Speeding up machine data analysis
Machine logs from diverse sources are generated in an enterprise in
voluminous quantities. IBM Accelerator for Machine Data Analytics simplifies the task
of implementation required so analysis of semi-structured, unstructured or structured
textual data is accelerated.
Also available in:
Japanese
|
03 Jan 2013 |
| Cognos Business Intelligence 10.2 reporting on InfoSphere
BigInsights
Find guidance on consuming IBM InfoSphere
BigInsights data through IBM Cognos Business Intelligence 10.2.
Also available in:
Chinese
Portuguese
|
01 Jan 2013 |
| Sybase to DB2 migration, Part 4: Issues and resolutions
Information assets are key to day-to-day business. They are also a huge
source of institutional value and intellectual property that must be preserved,
extended, and repurposed as the systems underpinning them change. Given the current
business environment, migration has taken on strategic importance for a number of
reasons. This article helps you to understand and map various features and data types of
Sybase and DB2.
Also available in:
Chinese
|
20 Dec 2012 |
| Sybase to DB2 migration, Part 3: Test strategy
Information assets are key to day-to-day business. They are also a huge
source of institutional value and intellectual property that must be preserved,
extended, and repurposed as the systems underpinning them change. Given the current
business environment, migration has taken on strategic importance for a number of
reasons. This article helps you to understand various processes, verifications, and
validations of post database migration.
Also available in:
Chinese
|
13 Dec 2012 |
| Using InfoSphere MDM Collaboration Server Java APIs
IBM InfoSphere MDM Collaboration Server exposes several interfaces through which the
system can be customized - InfoSphere MDM Collaboration Server scripting, and InfoSphere MDM
Collaboration Server Java APIs being the major interfaces. This article provides the
details of developing applications using InfoSphere MDM Server Collaboration Server Java
APIs in the Eclipse Integrated Development Environment (IDE). Steps required
to set up the environment, create the Java API-based project, run the classes, and debug
using Eclipse IDE are highlighted in this article. Sample code is provided to illustrate
the steps used in the development.
|
13 Dec 2012 |
| Real-time transliteration using InfoSphere Streams custom Java operator and
ICU4J
With the ever growing importance of Internet monitoring and sentiment
analysis, there is an immediate need for identifying patterns (performing text analytics)
in big data. However, one of the challenges during this exercise is that countries can
have multiple languages that creates a challenge for effectively running the text
analytics, since rules are not available for all the languages. For example, in India,
the official language of each state is different and data is available in both English
and local languages. This article describes how to bring about consistency during the
transliteration process, and to use IBM InfoSphere Streams to prepare linguistic data
and apply text analytics or pattern recognition logic.
|
13 Dec 2012 |
| IBM Business Analytics Proven Practices: Solving an IBM Cognos 10.2 PowerCube Package Attribute and Measure Translation Issue
The purpose of this document is to outline the scenario in which IBM Cognos Business Intelligence(BI) reports fail after being deployed to IBM Cognos 10.2.X BI. The document will also provide the steps required to fix any report errors that are caused by this particular scenario.
|
12 Dec 2012 |
| Data mining techniques
Examine different data mining and analytics
techniques and solutions. Learn how to build them using existing software
and installations.
Also available in:
Russian
Vietnamese
|
11 Dec 2012 |
| Configure FIPS mode for DB2 and WebSphere
Learn the necessary steps to configure an application
to be compliant with the US Federal Information Processing Standard (FIPS). The
application in this article uses DB2 and WebSphere in a Windows system.
|
11 Dec 2012 |
| IBM Cognos Proven Practices: Auto Cascading Prompts without Page Refresh in IBM Cognos Report Studio
This document provides technique to implement auto-cascading of Value prompts without having to do a page refresh.
Also available in:
Chinese
|
10 Dec 2012 |
| Sybase to DB2 migration, Part 2: Integrity check guidelines
Information assets are key to day-to-day business. They are also a huge source of
institutional value and intellectual property that must be preserved, extended, and
re-purposed as the systems underpinning them change. Given the current business
environment, migration has taken on strategic importance for a number of reasons. This
article helps you to understand the integrity check process for various database objects
while migrating the databases to DB2.
Also available in:
Chinese
|
06 Dec 2012 |
| Set up DB2 for Linux, UNIX, and Windows for high availability using
Microsoft Cluster Server
IBM DB2 for Linux, UNIX, and Windows has a number of options to
provide high availability for production systems such as high availability
and disaster recovery (HADR), DB2 pureScale, and DB2 MSCS. This article shows you how to set up a
DB2 cluster in a virtual Microsoft Windows environment, including how to quickly set up a
training and testing system in a virtual environment such as the cloud.
This article will also help you to learn and practice db2MSCS without special hardware.
Finally, simple troubleshooting methods are introduced to help you with
common issues. This article is an update of a previously published white paper on ibm.com.
|
06 Dec 2012 |
| Big Data, Fractal Geometry, and Pervasively Parallel Processing
Big data platforms must push the nanoscopic frontier of scalability. It’s useful to think of a consolidated big data platform, architecturally, as a fractal structure. What that means is that big data must be self-similar on all platform scales — from macro to nano — and leverage the full parallel processing resources that are available at each level.
|
04 Dec 2012 |
| Migrating Data from a Mainframe to a Distributed Environment
The Data Movement Tool is easy to install and flexible to operate. It can be run from the command line or a GUI. Importantly, the Data Movement Tool allows the selection of objects that you want to copy. You can copy individual objects, entire database, objects by authID, or schema.
|
04 Dec 2012 |
| Getting Started With Fit for Purpose Architectures
We are going to revisit Fit for Purpose architectures today. It has been encouraging to see how quickly customers have picked up the Fit for Purpose concept and how many are now thinking in terms of matching the compute problem to the best underlying compute paradigm.
|
04 Dec 2012 |
| Sybase to DB2 migration, Part 1: Process and methodology
Information assets are key to day-to-day business. They are also a huge
source of institutional value and intellectual property that must be preserved,
extended, and re-purposed as the systems underpinning them change. Given the current
business environment, migration has taken on strategic importance for a number of
reasons. The benefits of rationalizing processes and systems hinges on outcomes where
services and functionality are as good or better than before, while free of costly
redundancies or unnecessarily diverse technologies. Poorly executed migrations diminish
these returns and fail to meet the "as good as or better than before" criteria.
Also available in:
Chinese
|
29 Nov 2012 |
| Maintaining DB2 Analytics Accelerator in a DB2 for z/OS data
sharing environment
The IBM DB2 Analytics Accelerator (IDAA) is a workload optimized appliance
that uses both System z and Netezza technologies. In this article, learn
how to maintain IDAA in configurations other than the standard
configuration of connecting a single IDAA to a single DB2 subsystem or to a
single member of a DB2 data sharing group.
|
29 Nov 2012 |
| Benefits of InfoSphere Guardium for System Z in the healthcare industry
Mark Simmonds is a guest on The Pulse Network TV to discuss the benefits
of InfoSphere Guardium on System z for the healthcare industry.
|
27 Nov 2012 |
| IBM Cognos Proven Practices: IBM Cognos BI Dispatcher Routing Explained
A short document to explain the main concepts of IBM Cognos Dispatchers when routing requests.
|
22 Nov 2012 |
| Private installation feature of Informix: Client perspective
Starting with IBM Informix 11.70xC2, Informix started supporting
the private installation feature. The private installation feature(non-root user
installation) will allow Informix to be installed by a user other than root, and will
permit the software to run without user Informix or group Informix on the machine.
Inside the server, Informix will be used as the owner of the system catalog, but neither
user Informix nor group Informix will have any special privileges with respect to a
private server. The CSDK and other installers which are part of the Informix bundle will
also permit non-root users to install the software. In this article, we discuss aspects
of this feature in Informix and provide tutorials on how to manage users using JDBC,
ESQL/C and ODBC drivers.
|
21 Nov 2012 |
| Mining your package cache for problem SQL in DB2 for Linux, UNIX, and
Windows
In both OLTP and DSS database environments, DBAs can use information stored in the package cache to find problematic SQL statements either before or after they
begin to negatively impact performance. While there are many third party tools available that can be used to identify and analyze problematic SQL, by executing a few
simple queries, DBAs can locate such SQL without having to use one of these tools. This article shows you how to mine package cache data using some of those queries.
Also available in:
Russian
Portuguese
|
21 Nov 2012 |
| Big data business intelligence analytics
Learn about integrating business intelligence and big data analytics.
Explore the similarities, differences, and what choices to consider.
|
20 Nov 2012 |
| IBM Cognos Proven Practices: Performance Tips when using Cross JoinQueries against a TM1 Datasource
The purpose of this document is to provide performance guidance when querying large datasets from a TM1 Datasource.
|
19 Nov 2012 |
| Compare IBM data masking solutions: InfoSphere Optim and DataStage
Many organizations use production data to populate their test environments.
The problem with this is that if there is sensitive data in your production
environment, then you are exposing that data to software developers and testers.
IBM offers the following two solutions to solve this problem: The
InfoSphere Optim Data Masking option for Test Data Management, and the
InfoSphere DataStage Pack for Data Masking. Both mask data and depersonalize it
while still maintaining it's realism. This article explores the common functions
that both solutions have that are requirements for effective data masking, and
then it explores the differences between the products. After reading this
article you should be able to pick the right IBM data masking solution to best
meet your requirements.
Also available in:
Portuguese
Spanish
|
15 Nov 2012 |
| Shredding XML in DB2 with pureXML and XMLTable
DB2's XML processing capability makes it simpler to turn XML data into relational data.
The built-in XMLTABLE function provides an easy-to-use and powerful mechanism to turn hierarchical XML data into parent-child relational data.
Whether your tools do not support XML, or relational processing is required, XMLTABLE provides a means to bridge the gap.
|
15 Nov 2012 |
| Create customer segmentation models in SPSS Statistics from
spreadsheets
Learn how to bring a spreadsheet
of raw data into SPSS Statistics and apply two classification algorithms to create
customer segmentation models. Then, use options in SPSS Statistics to create persistent
files that contain the rules for the models that can be used for both deployment of
customer classifications back to spreadsheets and into a big data environment.
|
13 Nov 2012 |
| IBM federated database technology
In a large modern enterprise, information is almost inevitably distributed among several database management systems. Despite considerable attention from the
research community, relatively few commercial systems have attempted to address this issue. This article describes the technology that enables clients of IBM's
federated database engine to access and integrate the data and specialized computational capabilities of a wide range of relational and nonrelational data sources.
Also available in:
Japanese
|
13 Nov 2012 |
| Use InfoSphere Guardium Universal Feed to create a customized
data activity monitoring solution, Part 2: Creating a feed for a user-defined data source
New databases and new applications are continually being created and adopted to
meet specific organizational needs. The requirement for data protection and auditing
capabilities is required by mandate and is more critical than ever. The InfoSphere
Guardium data protection solution is extensible to enable the integration of a wide
variety of new databases and sources into its platform, thereby providing a consistent
enterprise-wide monitoring solution. In this article series, you learn how to integrate
event logs from any software into InfoSphere Guardium using Guardium Universal Feed.
Part 1 described how to create a feed for a relational data source. In this article you
will learn how to create a feed for any arbitrary data source. You will learn how to
upload event descriptions into the Guardium repository and how to use the reporting
capability for event data. This article includes a sample event description file and
sample program.
Also available in:
Portuguese
|
08 Nov 2012 |
| Enable DB2 in OpenStack
OpenStack is a cloud operating system that controls large pools of compute,
storage, and networking resources throughout a data center. All resources are managed
through a dashboard that gives administrators control while empowering users to
provision resources through a web interface. OpenStack supports MySQL, SQLite and
PostgreSQL as its default databases. In this article, the author shows you how to
quickly enable OpenStack to support DB2.
|
05 Nov 2012 |
| Best practices for IBM InfoSphere Blueprint Director, Part
2: Designing information blueprints from the ground up
This article provides best practices using InfoSphere Blueprint Director.
Understanding and applying these best practices enables you to create brand new
architecture blueprints that are effective and actionable. It is intended for
experienced users of InfoSphere Blueprint Director.
Also available in:
Portuguese
|
01 Nov 2012 |
| Boost JDBC application performance using the IBM Data Server Driver for JDBC and
SQLJ
Developing high performing JDBC applications is not an easy task. This article
helps you gain a better understanding of the factors that contribute to your JDBC
application performance using the IBM Data Server Driver for JDBC and SQLJ to
access DB2 and Informix. Learn to
identify these issues and to find and alleviate client-side bottlenecks.
|
01 Nov 2012 |
| Optim Test Data Management for Teradata: Load techniques and performance tips
Whether it's about managing database archive life cycle, application
decommissioning, or test data management using InfoSphere Optim, the performance
challenges remain the same. A narrow maintenance window, moving billions of rows,
complex architecture, and limited hardware resources all contribute to performance in
some way or the other. This article provides an insight into best
practices and comparisons of various load mechanisms in Optim support for Teradata, along with
performance considerations for the same.
|
01 Nov 2012 |
