Related links:
Title
|
Type
|
Date
|
|---|---|---|
| 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 | 14 Jun 2013 |
| Evaluate: IBM InfoSphere BigInsights Quick Start Edition
IBM InfoSphere Quick Start Edition is a no-charge download with no data or time limitations. Quick Start is designed for anyone who wants to get their hands on the enterprise features of BigInsights to experiment with Hadoop and explore different use cases.
|
Trial Downloads | 14 Jun 2013 |
| Get started with BigInsights
Learn how to manage your big data environment, import data for analysis, analyze data with BigSheets, develop your first big data application, develop Big SQL queries to analyze big data, and create an extractor to derive insights from text documents in this comprehensive set of learning guides.
|
Articles | 14 Jun 2013 |
| What's the big deal about Big SQL?
If you specialize in relational database management technology, you've
probably heard a lot about "big data" and the open source Apache Hadoop
project. Perhaps you've also heard about IBM's new Big SQL technology, which
enables InfoSphere BigInsights users to query Hadoop data using
industry-standard SQL. Curious? This article introduces you to Big SQL,
answering many of the common questions that relational DBMS users have about
this IBM technology.
|
Articles | 14 Jun 2013 |
| Secure Sockets Layer (SSL) support in DB2 for Linux, UNIX, and
Windows
Using Secure Sockets Layer (SSL) with IBM DB2 means your data can be sent securely
over the network. In this article, learn how to configure this protocol for DB2 V9.7 and
newer releases.
|
Articles | 13 Jun 2013 |
| InfoSphere Guardium data security and protection for MongoDB Part
2: Configuration and policies
This article series describes how to monitor and protect MongoDB data
using IBM InfoSphere Guardium, including the configuration of the solution,
sample monitoring use cases, and additional capabilities such as quick search of audit
data and building a compliance workflow using an audit process. Part 2 describes how to
configure InfoSphere Guardium to collect MongoDB traffic and describes how to create
security policy rules for a variety of typical data protection use cases, such as
alerting on excessive failed logins, monitoring privileged users, and alerting on
unauthorized access to sensitive data. Many organizations are just getting started with
MongoDB, and now is the time to build security into the environment to save time,
prevent breaches, and avoid compliance violations.
|
Articles | 13 Jun 2013 |
| Snapshot monitoring administrative views on DB2 version 10.1 for Linux,
UNIX, and Windows
This article demonstrates some of the important and frequently used DB2
snapshot monitoring administrative views in version 10.1. This article is for DB2
database administrators tasked with DB2 monitoring.
Snapshot monitoring views are now the preferred means of accessing snapshot data,
which represents a huge leap forward by giving administrator access
to snapshot data via SQL. All of the information that database administrators have
been used to getting from snapshots can be selected from the administrative views.
|
Articles | 13 Jun 2013 |
| Synchronize data with control signals in the InfoSphere Streams Time
Series Toolkit
InfoSphere Streams is the real-time component of the IBM big data
platform. It provides the platform and toolkits for building
real-time analytical solutions. The Time Series Toolkit included with
Streams includes operators for preprocessing,
analyzing, and modeling time series data in real time. Modeling operators in the toolkit use
incoming time series data to build an internal model for forecasting or
tracking. In real-world scenarios, the incoming data used for model building
might become noisy and should be discarded from
the model-building process. Also, once the incoming data is clean, the model
might have to be retrained. This article provides a solution for
this and describes how to synchronize and calibrate the process of
model building and operator functions with the quality of incoming data using
the control port feature.
|
Articles | 11 Jun 2013 |
| Best practices for IBM InfoSphere Blueprint Director, Part
3: Sharing Information Architectures through InfoSphere Blueprint Director
This article provides best practices on publishing information
architecture blueprints using IBM InfoSphere Blueprint Director. Publishing architecture
blueprints enables sharing of the most current solution architecture with all team
members allowing everyone to experience the same project vision.
|
Tutorial | 06 Jun 2013 |
| Backup and restore procedures for the DB2 instance shared directory in a DB2
pureScale environment
In this article, learn about the recovery procedure for a
DB2 pureScale
instance shared directory (sqllib_shared). By following the procedures
described here, you should be able to restore a
pureScale instance to its last backup state in the case where some or all
files or directories within it become unavailable or unusable.
|
Articles | 06 Jun 2013 |
| InfoSphere Guardium data security and protection for MongoDB,
Part 1: Overview of the solution and data security recommendations
This article series describes how to monitor and protect MongoDB data
using IBM InfoSphere Guardium. Part 1 describes an overview of the
solution, the architecture, and the benefits of using InfoSphere Guardium with MongoDB.
The value of the fast growing class of NoSQL databases such as MongoDB is the ability to
handle high velocity and volumes of data while enabling greater agility with dynamic
schemas. Many organizations are just getting started with MongoDB, and now is the time
to build security into the environment to save time, prevent breaches, and avoid
compliance violations. This article series describes configuration of the solution,
sample monitoring use cases, and additional capabilities such as quick search of audit
data and building a compliance workflow using an audit process.
|
Articles | 06 Jun 2013 |
| Integrating PureData System for Analytics with InfoSphere Streams
This article describes how to perform bulk load from
InfoSphere Streams 2.0 to PureData System for Analytics N1001-010 using Netezza
technology. The example InfoSphere Streams application demonstrates how Netezza enables a
high-throughput connection and allows both systems working together to reach
the high throughput that they can offer separately.
|
Articles | 04 Jun 2013 |
| e-Learning Course for InfoSphere Optim Query Capture and Replay
Get an overview of IBM InfoSphere Optim Query
Capture and Replay, its architecture, and the capture and replay workflow in this interactive tutorial that shows you how to complete the basic capture and replay workflow in a DB2 for z/OS environment.
|
Demos | 03 Jun 2013 |
| Schema replication with IBM InfoSphere Data Replication, Part
2: Bi-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
second in a series which uses a disaster recovery use case to explain how to set up
schema-level subscriptions for bi-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 the user to replay the scenario. To make this
as convenient as possible, we provide various scripts in the Download section of the
article. Watch out for more articles in this series that cover schema-level
subscriptions for uni-directional topologies and more.
|
Articles | 30 May 2013 |
| A complete connectivity guide from InfoSphere Information Server to DB2 for i
IBM Information Server supports extracting from and writing to DB2 for
System i. To help you overcome any challenges in setting up the connection
from Information Server to DB2 for i, this article provides clear,
step-by-step instructions,
from checking prerequisite information and components to connecting to DB2
for i and defining DataStage jobs.
|
Articles | 30 May 2013 |
| DB2 10.x certification: Everything you need to know
Certification has long been a popular trend in the Information Technology (IT) industry. Consequently, many hardware and
software vendors, including IBM, now have certification programs in place that are designed to evaluate and validate an individual's
proficiency with their product offerings. But as a DB2 professional, should you become certified? Will being certified increase your
ability to administer DB2 databases? Or advance your career? This article is designed to answer these and other questions; it can
help you decide if DB2 certification is right for you, and it will show you the path to follow should you decide to acquire one or
more of the DB2 certifications that are currently available.
|
Articles | 30 May 2013 |
| Introduction to IBM Datacap Taskmaster Capture Development Kit
Learn about the cross-industry and
industry-specific sample applications and tools available in the IBM Datacap Taskmaster
Capture Development Kit (DDK), and find links to each of the components.
Also available in:
Russian
Portuguese
|
Articles | 28 May 2013 |
| IBM Accelerator for Machine Data Analytics, Part
5: Speeding up analysis of structured data together with unstructured data
Previously in this series, you created a searchable repository of
semi-structured and unstructured data -- namely, Apache web access logs,
WebSphere logs, Oracle logs, and email data.
In this tutorial, you will enrich the repository with structured data exported from a customer database.
Specifically, you will search across structured customer information and semi-structured
and unstructured logs and emails, and perform analysis using BigSheets to identify which customers who emailed
Sample Outdoors Company during the July 14th outage were more loyal than others.
|
Tutorial | 28 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
|
Articles | 23 May 2013 |
| 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.
|
Articles | 23 May 2013 |
| Technical tip: High availability on DB2 for z/OS on single LPAR systems
This article introduces a high data availability solution on DB2 for z/OS
using DB2 BINDs for shops having their test, development and production environments on
a single LPAR. Using this method, it is possible to map the test program onto
production qualifiers and retrieve data directly from production without the need of
data refresh.
|
Tips | 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.
|
Articles | 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.
|
Articles | 17 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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.
|
Articles | 07 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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.
Also available in:
Chinese
|
Articles | 04 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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.
Also available in:
Russian
|
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 |
| 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.
|
Articles | 07 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 |
| 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
|
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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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.
Also available in:
Chinese
|
Articles | 10 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.
|
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 |
| 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 |
| 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 |
