Related links:
Title
|
Type
|
Date
|
|---|---|---|
| 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 08 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 18 Apr 2013 |
| Evaluate: InfoSphere Streams
Download a free trial version of InfoSphere Streams, a high-performance computing platform that allows user-developed applications to rapidly ingest, analyze, and correlate information as it arrives from thousands of real-time sources.
Also available in:
Chinese
|
Trial Downloads | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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).
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 25 Mar 2013 |
| IBM InfoSphere Optim Test Data Management Solution, Part
3: Masking a person's first name using a gender-specific lookup table
This demo is the third in a series about masking sensitive data to privatize that data.
Learn how mask a person’s first name in a table using a
gender-specific lookup table. The Optim random lookup data privacy provider is used in this column map procedure script.
|
Demos | 22 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.
|
Articles | 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.
|
Articles | 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
|
Articles | 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
|
Articles | 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.
|
Articles | 14 Mar 2013 |
| IBM DB2 Technology Preview
Welcome to the IBM DB2 Technology Preview. Here's a more active approach to explore the new technologies that are being
considered across IBM. We felt it was important to provide DB2 technologies that our clients can experiment with and have a forum
mechanism to get feedback from other customers and react to that feedback.
|
Trial Downloads | 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.
|
Articles | 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
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 28 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.
|
Articles | 21 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
Also available in:
Spanish
|
Articles | 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.
|
Articles | 04 Feb 2013 |
| DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611
prep, Part 2: Physical design
This tutorial discusses the creation of IBM DB2/reg> databases, as well as
various methods used for placing and storing objects within a database. The
focus is on partitioning, compression, and XML, which are all important performance and
application development concepts you need to store and access data quickly
and efficiently. This is second in a series of eight tutorials you can
use to help you prepare for the DB2 10.1 DBA for Linux,
UNIX, and Windows certification exam 611. The material in this tutorial
primarily covers the objectives in Section 2
of the exam.
|
Tutorial | 31 Jan 2013 |
| IBM Accelerator for Machine Data Analytics, Part
3: Speeding up machine data searching
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.
|
Tutorial | 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.
|
Articles | 31 Jan 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.
|
Articles | 31 Jan 2013 |
| IBM Data Studio: Available at no charge
Download IBM Data Studio, which provides database developers and DBAs with
the basic set of required tools for database development and administration for IBM
Data Servers.
|
Trial Downloads | 29 Jan 2013 |
| Evaluate: IBM Cognos Business Intelligence
Download IBM Cognos Business Intelligence Developer Edition V10.1. IBM Cognos BI
Developer Edition enables you to learn a rich set of business intelligence capabilities
without incurring any upfront costs. Access any and all data sources and use reporting and
analysis to experiment with how to deliver relevant information how, when and where it is
needed. Broaden your skills and learn how to build BI applications based on enterprise-class
SOA foundation. Expand your opportunities in BI and become a BI consultant or IBM
partner.
|
Trial Downloads | 28 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.
|
Articles | 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.
|
Articles | 24 Jan 2013 |
| Customize the InfoSphere Master Data Management classic party search
capability
In this tutorial, use the data extension and pre-written SQL capabilities
to create a custom search object and enable the use of the new party attributes
as part of a classic party search service. You will use a scenario in which the
search criteria to be added, as part of the pluggable SQL, are not available in
the out-of-the box party search object. Therefore, additional Java development
effort is required.
|
Tutorial | 24 Jan 2013 |
| Resource description framework application development in
DB2 10 for Linux, UNIX, and Windows, Part 1: RDF store creation and maintenance
The Resource Description Framework (RDF) is a family of W3 specification
standard that enables the exchange of data and metadata. Using DB2 10 for
Linux, UNIX, and Windows Enterprise Server Edition, applications can store and
query RDF data. This tutorial walks you through the steps of building and
maintaining a sample RDF application. During this process you will learn
hands-on how to use DB2 software in conjunction with RDF technology.
Also available in:
Chinese
|
Tutorial | 23 Jan 2013 |
| IBM Accelerator for Machine Data Analytics, Part 2: Speeding up analysis of new log types
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.
|
Tutorial | 17 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
|
Articles | 16 Jan 2013 |
| InfoSphere Optim Query Capture and Replay for DB2 on z/OS
Testing of enterprise changes are costly and difficult tasks for IT
organizations. See how an IT team at a fictional outdoor equipment retailer, the Sample Outdoor company, can reduce costs and mitigate risks with realistic testing by using IBM InfoSphere Optim Query Capture and Replay for DB2 on z/OS.
|
Demos | 11 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 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.
|
Articles | 03 Jan 2013 |
| IBM InfoSphere Optim Test Data Management solution, Part 2: Using a column map procedure
Learn how to pass parameters within a script to mask data, and how to modify the output process report to include
information about the masking process.
Specifying
parameters within a script gives you more flexibility in
determining what records are masked and how your data is masked.
The demo also shows how to view before and after images of the data you masked to
ensure that the data was masked, as requested.
|
Demos | 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
|
Articles | 03 Jan 2013 |
| InfoSphere Data Replication for DB2 for z/OS and WebSphere Message Queue for z/OS: Performance Lessons
This Redpaper reports results and lessons learned from performance testing at the IBM laboratories, and it provides configuration and tuning recommendations for DB2, Q Replication, and MQ. The application workload and database characteristics studied include transaction size, table schema complexity, and DB2 data type.
|
Redbooks | 02 Jan 2013 |
| DB2 for z/OS and List Prefetch Optimizer
In this IBM Redpaper publication, we show DB2 10 for z/OS performance measurements using DS8000 R6.2 and R6.3 with DS8800 and solid-state drives. The measurements highlight both the reduction gained in synchronous I/O and the reduced dependency on data reorganization. This combination offers the opportunity for better performance to critical SQL applications that access large fragments of disorganized data.
|
Redbooks | 02 Jan 2013 |
| IMS 12: The IMS Catalog
This IBM Redpaper publication describes the IMS catalog, a trusted online source for both IBM IMS database and application metadata information, and its use by IMS Open Database and IMS Explorer. This paper targets application developers who can benefit from these simplification and integration functions when they are facing any large-scale deployment of the IMS Open Database solution.
|
Redbooks | 02 Jan 2013 |
| High Availability and Disaster Recovery for Temenos T24 with IBM DB2 and AIX
This IBM Redpaper publication serves as a guide to help IT architects and other technical staff who are designing, configuring, and building the infrastructure to support Temenos T24. It shows how IBM software can deliver high availability and disaster recovery for Temenos T24 to meet a client's requirements. This software might run on IBM AIX, IBM WebSphere Application Server, WebSphere MQ Server, and IBM DB2. These IBM software components are typically used for a Temenos T24 deployment on an IBM middleware stack to ensure a highly available infrastructure for T24.
|
Redbooks | 02 Jan 2013 |
| Customizing and Extending IBM Content Navigator
This IBM Redbooks publication has an overview of the functions and features that IBM Content Navigator offers, and describes how you can configure and customize the user interface with the administration tools that are provided. This book also describes the extension points and customization options of IBM Content Navigator and how you can customize and extend it with sample code. Specifically, the book shows you how to set up a development environment, and develop plug-ins that add new actions and provide special production imaging layout to the user interface. Other customization topics include working with external data services, using IBM Content Navigator widgets externally in other applications, and wrapping the widgets as iWidgets to be used in other applications. In addition, this book describes how to reuse IBM Content Navigator components in mobile development, and how to work with existing viewer or incorporate third-party viewer into IBM Content Navigator.
|
Redbooks | 02 Jan 2013 |
| Powerful and Easy Content Management and Business Analytics with IBM Content Navigator
This IBM Redbooks Solution Guide provides an overview of the IBM Content Navigator, which is a ready-to-use, modern, standards-based user interface that supports Enterprise Content Management (ECM) use cases, including collaborative document management, production imaging, and report management. It is also a flexible and powerful user platform for building custom ECM applications by using open web-based standards.
|
Redbooks | 02 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
|
Articles | 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.
|
Articles | 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
|
Articles | 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.
|
Articles | 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.
|
Articles | 13 Dec 2012 |
| Manage spatial data with IBM DB2 Spatial Extender, Part
2: Implementing typical spatial use cases
This "Manage spatial data with IBM DB2 Spatial Extender" series of
tutorials takes you through common tasks that work with spatial data in the
DB2/reg> Spatial Extender. These tasks include importing and creating spatial
data, constructing and executing spatial queries, working with IBM spatial
tools, working with third-party and open source software, improving
application performance, and taking special considerations in a data warehouse
environment.
|
Tutorial | 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.
|
Articles | 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
|
Articles | 11 Dec 2012 |
| Information Server Deployment Architectures
This IBM Redbooks publication presents guidelines and criteria for the successful deployment of Information Server components in typical logical infrastructure topologies that use shared metadata capabilities of the platform, and support development lifecycle, data privacy, information security, high availability, and performance requirements. This book can help you evaluate information requirements to determine an appropriate deployment architecture, based on guidelines that are presented here, and that can fulfill specific use cases. It can also help you effectively use the functionality of your Information Server product modules and components to successfully achieve your business goals.
|
Redbooks | 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.
|
Articles | 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
|
Articles | 10 Dec 2012 |
| Free: IBM DB2 Express-C
Download DB2 Express-C 10.1.2, a fully licensed product available at no-charge for the
community. It does not have any time-based usage restrictions or database size limitations. Use this
data server for application development and deployment.
|
Trial Downloads | 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
|
Articles | 06 Dec 2012 |
| System Administration Certification exam 919 for Informix 11.70
prep, Part 7: Informix Data Warehousing
In this tutorial, you'll learn about IBM Informix Data
warehousing concepts and the tools that you can use to create data warehouses and
optimize your data warehouse queries. This tutorial prepares you for Part 7 of the
System Administration Certification exam 919 for Informix v11.70.
|
Tutorial | 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.
|
Articles | 06 Dec 2012 |
| DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611
prep, Part 7: Security
This tutorial introduces the concepts of authentication, authorities,
privileges, audit facility, trusted context, RCAC, and LBAC as they relate to DB2 10.
It is the seventh in a series of tutorials designed to help you prepare for the
DB2 10.1 for Linux, UNIX, and Windows Database Administration (exam 611). You should have basic knowledge
of database concepts and operating system security.
|
Tutorial | 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.
|
Articles | 04 Dec 2012 |
