![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
Title
|
Type
|
Date
|
|---|---|---|
| IBM Cognos Proven Practices: Dynamic Sorting of a List within IBM Cognos Report Studio
A technique which applies dynamic column sorting on a list using custom IBM Cognos Report Studio toolbox items.
|
Articles | 10 Feb 2012 |
| Restricting database connections using trusted contexts in DB2 for Linux,
UNIX, and Windows
Security 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 -- which 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 trusted context feature of DB2 for Linux, UNIX, and Windows.
|
Articles | 09 Feb 2012 |
| De-identify flat files and delimited files using InfoSphere Optim Data
Privacy Solution and InfoSphere Federation Server
With the current environment of data sensitivity, there is a need to
mask data not only in the traditional relational databases, but also in flat
files that could be part of a testing scenario. Customers continue to need to
send files to vendors, off-shore testers, and even internal testers, and the
data in those files could be subject to regulations. In this article, learn
how to de-identify private data in flat files by using IBM InfoSphere(TM)
Federation Server to create a relational table (nickname) for data in flat
files and then apply data privacy algorithms using IBM Optim(TM) Data Privacy
Solution. [2012 Feb 9 update: This
article has been updated for the most recent versions of Optim. You
can now de-identify flat positional files, and you can use several new masking
functions for columns. --Ed.]
|
Articles | 09 Feb 2012 |
| IBM Cognos Framework Manager, Part 1: Import metadata from a SAP BW
IBM Cognos Framework Manager is
the metadata modeling tool used for importing metadata and preparing it for
reporting needs. This demo series shows you how to get the model ready for the content
authors to use. Part 1 of this series shows how to import the relevant SAP Business
Warehouse (BW) metadata related to your reporting requirements.
|
Demos | 08 Feb 2012 |
| IBM Cognos Framework Manager, Part 3: Publish the data in reports for end users
IBM Cognos Framework Manager is
the metadata modeling tool used for importing metadata and preparing it for
reporting needs. This demo series shows you how to get the model ready for the content
authors to use. Part 3 of this series shows how to prepare a model package and then
publish it.
|
Demos | 08 Feb 2012 |
| IBM Cognos Framework Manager, Part 2: Use Framework Manager to explore imported data
IBM Cognos Framework Manager is
the metadata modeling tool used for importing metadata and preparing it for
reporting needs. This demo series shows you how to get the model ready for the content
authors to use. Part 2 of this series shows how to use Framework Manager to explore an imported model.
|
Demos | 08 Feb 2012 |
| IBM Cognos Proven Practices: IBM Cognos BI – Create a Custom Schedule Using Calculations and Parameters in Event Studio
An approach to scheduling a report which can be delivered to users on multiple, non-recurring dates using an IBM Cognos Event Studio agent.
|
Articles | 06 Feb 2012 |
| 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 | 06 Feb 2012 |
| Designing an integration landscape with IBM InfoSphere
Foundation Tools and Information Server, Part 1: Planning an integration landscape
This tutorial is an introduction to the use of IBM InfoSphere Blueprint
Director, in the context of a project, to depict the target vision (or
landscape) for the final solution and to provide guidance for subsequent
project tasks. It is the first of a series of tutorials focused on a specific,
common information integration scenario: the update of a Data
Warehouse-Business Intelligence (DW-BI) information process.
|
Tutorial | 02 Feb 2012 |
| Developing heterogeneous database applications
using the IBM Data Server Provider for .NET
Transactional logic that works across heterogeneous databases needs to
use global transactions. The IBM Data Server Provider for .NET supports the
distributed transaction model from the System.Transactions namespace, which has
the capability to create and manage global transactions. The code examples in this article show how
to use the IBM Data Server Provider for .NET to create
and manage global transactions on the IBM data servers.
|
Articles | 02 Feb 2012 |
| Mainframe code page conversion customization in an IBM z/OS system
Encoding in mainframes is EBCDIC, and encoding in distributed system is ASCII.
Mainframe computers need to communicate with distributed systems that include Microsoft
Windows, UNIX, and other platforms. The EBCDIC and ASCII code page conversion happens
in each communication between the IBM z/OS operating system and the distributed system.
However, some characters cannot go round trip between EBCDIC and ASCII in some non-English
languages. As a result, the application doesn't work correctly. One solution is to modify
application code, but that is often complicated and time consuming. This article presents
a light-weight solution as an alternative. No application code change is needed, and you
can resolve the issue quickly.
|
Articles | 02 Feb 2012 |
| Optimize InfoSphere DataStage jobs with Netezza Connector using InfoSphere
DataStage Balanced Optimization
In this article, learn how to use a DatgaStage extension called
InfoSphere DataStage Balanced Optimization to rewrite a DataStage job to enhance performance by sharing or
redistributing the processing load among Infosphere DataStage and the source and target
databases. Special emphasis has been given to features unique to Netezza Connector, including
Action Column, Unique Key Column for update support, and Temporary Work Table. The article
also discusses additional features available in the InfoSphere Information Server V8.7 release,
including the Filter stage, and multiple output links of Copy, Filter, and Transformer stages.
|
Articles | 26 Jan 2012 |
| Designing a database for multi-tenancy on the cloud
Learn some considerations that new software as a service
(SaaS) vendors need to take into account when developing applications or
modifying existing ones to enable them for multi-tenancy on the cloud. The article
discusses the considerations only from a database perspective --
specifically, from an IBM DB2 perspective. Six cases or methods are described.
|
Articles | 26 Jan 2012 |
| Leveraging pureXML in a Flex microblogging application, Part 1: Enabling Web services with DB2 pureXML
The pureXML capabilities of IBM DB2 allow you to store XML natively in a database without modification, while Adobe Flex applications can read XML directly and populate Flex user interfaces. In this three-part article series, you will create a microblogging application that takes advantage of pureXML, Web services, and Adobe Flex; and even allows you to publish your microblogging updates on Twitter.
|
Articles | 24 Jan 2012 |
| System versus SQL name - Part 1
When executing SQL statements you can run them either using System or SQL Naming. The System Naming conventions follow the traditional methods used on IBM i systems such as library support. The SQL Naming mode on the other hand is defined in the SQL Standard and used by all other databases. When asking what is the difference between SQL and System Naming, you will normally get the answer, schema and object are either separated with a slash or a period. However there are many more differences especially with regard to the access authority and ownership of database objects created either using SQL or System Naming.
This article will show the differences between SQL and System Naming primarily focusing on
how the ownerships and access authorities vary when creating DB2 for i database objects (such as tables, stored procedures or triggers) with the two naming conventions.
|
Articles | 23 Jan 2012 |
| Security and deployment best practices for InfoSphere
Information Server Packs for SAP applications, Part 1: A security primer
This article shows you how to deploy the SAP side components of the IBM InfoSphere Information Server DataStage Packs for SAP
Applications. It explains the various stage types and gives an overview of the relevant installation and security administration concepts.
|
Articles | 19 Jan 2012 |
| Migrating from DB2 Control Center to IBM Data Studio
Since the DB2 Control Center tools have been deprecated in DB2 9.7,
users have been encouraged to adopt IBM Data Studio and IBM InfoSphere Optim
tools for managing DB2 databases. IBM Data Studio 3.1 was released in
October/2011 with several enhancements over previous versions that make it an
excellent replacement for Control Center. This article aims to help DB2 users
who are familiar with Control Center tools to quickly transition to IBM Data Studio.
Also available in:
Portuguese
|
Articles | 19 Jan 2012 |
| IBM InfoSphere Optim Performance Manager 5.1, Part 1: Install
Learn about IBM InfoSphere Optim
Performance Manager 5.1 architecture and packaging, and how to install the product.
|
Demos | 17 Jan 2012 |
| IBM InfoSphere Optim Performance Manager 5.1, Part 2: Install and configure the Extended Insight feature
Learn about the Extended Insight architecture for InfoSphere Optim Performance Manager 5.1. This demo shows how to activate, install, and configure the
Extended Insight client to
monitor DB2 Call Level Interface, JDBC, and WebSphere applications all in
command line mode.
|
Demos | 17 Jan 2012 |
| Data normalization reconsidered, Part 2: Business records in the 21st century
The second part of this 2-part series discusses alternative data representations like XML, JSON, and RDF to overcome normalization issues or
to introduce schema flexibility. In the 21st century, digitized business records are often created in XML to begin with. This paper compares XML to
normalized relational structures and explains when and why XML enables easier
and faster data access. After a discussion of JSON and RDF, it concludes
with a summary and suggestions for reconsidering normalization.
|
Articles | 12 Jan 2012 |
| Managing and scheduling database jobs with the Data Studio Web
Console
As the number of databases increase in many organizations, many DBAs are
facing a major challenge in automating and scheduling their database
operations. The new job management capability in IBM Data Studio provide DBAs
with a simple and flexible way to create and manage database jobs and to
schedule command scripts to run automatically.
Also available in:
Portuguese
|
Tutorial | 12 Jan 2012 |
| IBM Cognos Proven Practices: IBM Cognos Express 9.5 Troubleshooting
This document is aimed to provide understanding on what IBM Cognos Express is, how it works and where to find troubleshooting information.
|
Articles | 11 Jan 2012 |
| Compare the Informix Version 11 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 | 06 Jan 2012 |
| System Administration Certification exam 919 for Informix 11.70 prep, Part 3: System activity monitoring
In this tutorial, you'll learn about IBM Informix(R) database tools, the
utilities to monitor the database, and how to diagnose problems.
Learn how to use the system-monitoring interface (SMI) and the SQL administration API.
This tutorial prepares you for Part 3 of the System Administration Certification exam 919 for Informix v11.70.
Also available in:
Portuguese
|
Tutorial | 28 Dec 2011 |
| DB2 best practices: Expanding an IBM Smart Analytics System
Data warehouse environments continue to experience an explosion in data growth. As a result, you might find yourself in a situation where you need added capacity to cope with increased enterprise demands. To help you meet these demands, the IBM Smart Analytics System is a flexible data warehousing solution that supports a building block approach to expansion. This document discusses how to identify, plan and prepare for an expansion of your system and discusses the milestones and options involved in an expansion project.
|
Articles | 20 Dec 2011 |
| DB2 best practices: Frequently asked questions about database administration for an IBM Smart
Analytics System
This paper explores some of the frequently asked questions about
database administration on an IBM Smart Analytics System data warehouse database.
|
Articles | 20 Dec 2011 |
| DB2 best practices: Deploying IBM DB2 Express-C with PHP on Ubuntu Linux
This best practice article provides a step-by-step approach to installing
and configuring IBM DB2 Express-C software, PHP Hypertext Preprocessor, and
Apache HTTP Server on a system running the Ubuntu Linux operating system. After
completing the installation and configuration steps in this paper, you will have
a fully functioning PHP web application server with DB2 Express-C as the back-end
data server.
|
Articles | 20 Dec 2011 |
| DB2 best practices: Implementing DB2 workload management in a data warehouse
This article describes the best ways to implement a successful workload management solution using DB2 for Linux, UNIX, and Windows,
Version 9.7.4 or higher. The information in the article reflects the latest experiences of IBM field personnel and customers within the data
warehouse arena.
|
Articles | 20 Dec 2011 |
| IBM Cognos Proven Practices: Securing the IBM Cognos 10 BI Environment
A set of proven practices and guidelines to be taken into consideration when securing the IBM Cognos 10 BI environment.
Also available in:
Portuguese
|
Articles | 16 Dec 2011 |
| Real-time monitoring and more cool features in the new InfoSphere Optim
Performance Manager V5.1 for DB2 for Linux, UNIX, and Windows
IBM InfoSphere Optim Performance Manager V5.1 for Linux, UNIX, and Windows is a major step forward in bringing the ability to monitor very large
workloads spanning 100 plus partitions. Key to these enhancements are architectural changes including collecting state-of-the-art in-memory metrics for
DB2 V9.7 or higher databases instead of relying on snapshots. Additionally InfoSphere Optim Performance Manager V5.1 provides a rich set of new monitoring
features that are surfaced in the Web-based user interface like real-time monitoring, in-depth connection analysis and enhanced SQL analysis including
time. Enriched reporting on detailed recent performance data or on aggregated long-term historical data provide the capabilities you need for proactive
tuning and capacity planning. For pureScale or DPF performance analysis all dashboards now facilitate partition-level or member-level drill downs enabling
easy viewing and comparing. Optim Performance Manager provides easy configuration of DB2 Workload Manager by deploying the newest best practices template to get up and running
quickly with DB2 Workload Manager.
Also available in:
Portuguese
|
Articles | 15 Dec 2011 |
| Data normalization reconsidered, Part 1: The history of business records
Normalization is a methodology devised in the 1970s to minimize data duplication to safeguard
databases against logical and structural problems. Times have changed, and assumptions about computer systems have changed with the times.
This two-part series examines the problems associated with data normalization, such as complexity and the difficulty of mapping business records to normalized
data in a changing world. The first part then discusses cases for denormalization and explains how the World Wide Web has impacted the creation and
exchange of non-normalized business records.
|
Articles | 15 Dec 2011 |
| DB2 Tools corner: DB2 Utilities Suite for z/OS enhancements
Recent new features and functions of the DB2 Utilities Suite for z/OS help this set of tools better meet your needs and improve your
return on your investment in DB2. In this article, get details about new LOAD parameters, new REPAIR options, and new flexibility for REORG.
|
Articles | 15 Dec 2011 |
| Using pre-built rule definitions with IBM InfoSphere Information
Analyzer
A key challenge in assessing and monitoring information quality is
starting the process to validate key business requirements. Rather than start
off with a blank slate, this article includes and shows how to use pre-built
rule definitions to get under way.
Also available in:
Portuguese
|
Articles | 15 Dec 2011 |
| IBM Cognos Proven Practices: Enabling Browsing for Images in IBM Cognos Express Report Studio
The goal of this document is to outline the different ways in which the WebDAV HTTP extension can be enabled for use with the “Browsing for Images” feature in IBM Cognos Express Report Studio.
|
Articles | 08 Dec 2011 |
| Creating scripts more efficiently in the SQL and XQuery editor
The SQL and XQuery editor has been enhanced with new features that can
help you develop your SQL scripts more efficiently. Features such as the
Command pane and the editor toolbar put the controls, options, and buttons
that you need just a mouse-click away. This article describes these new
features and how to use them effectively.
Also available in:
Chinese
|
Articles | 08 Dec 2011 |
| Back up, restore, and roll forward in an InfoSphere Warehouse data
partitioning environment
Knowing how to back up and restore your database is a fundamental skill
for every database administrator. In a partitioned database environment, where your
database is split across multiple partitions or nodes, there are special
considerations. This article introduces the basics and demonstrates
step-by-step the process
of backup, recovery, and rollforward in the IBM InfoSphere Warehouse partitioned environment.
Also available in:
Chinese
|
Articles | 08 Dec 2011 |
| Dimensional modeling with IBM InfoSphere Data Architect, Part
2: Reverse engineering
Learn how to build a dimensional data model IBM InfoSphere Data Architect that efficiently captures analytical requirements at the
logical and physical levels of detail.
IBM InfoSphere Data Architect is a collaborative data design solution that helps you discover, model, relate, and standardize diverse and distributed data
assets.
It is a pivotal component of the IBM Integrated Data Management (IDM) initiative to enable an integrated data management environment throughout the entire
data management lifecyle.
Also available in:
Portuguese
|
Articles | 08 Dec 2011 |
| Extended Insight in WebSphere Application Server environments
IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS V5.1.0 allows
end-to-end database transaction response time monitoring for WebSphere
Application Server applications with its Extended Insight feature. This
capability provides insight into the transaction and SQL statement
response-time metrics of a database application throughout all layers of the software
stack; from the time that the SQL is issued in the application and through
the network and database server. Support is available for WebSphere
Application database applications in the form of additional time-spent metrics
for the WebSphere Application Server layer and by recognizing transactions
and SQL statements from WebSphere Application Server automatically. This
article provides detailed information for installing, configuring, and
validating the OMPE Extended Insight feature for WebSphere Application Server
applications.
Also available in:
Portuguese
|
Articles | 08 Dec 2011 |
| Finding and resolving IMS database exceptions using the Tools Base
Administration Console for z/OS
The IBM Tools Base Administration Console for z/OS displays exceptions
and statistical information in a graphical web interface. Because
Administration Console provides access to database reports, historical trends,
and displays exception messages, you can easily manage the overall health of
your resources on a z/OS system. The following tutorial focuses on how you can
manage a group of IMS databases and how to troubleshoot a problem when one of
those databases has an exception.
|
Articles | 08 Dec 2011 |
| Creating BIRT report templates with InfoSphere Data Architect
Create report templates for data models using the New Report Template wizard, then generate a report that is based on that template.
|
Demos | 07 Dec 2011 |
| Optimize data availability and resource utilization with InfoSphere Optim Configuration Manager
Learn how InfoSphere Optim Configuration Manager provides you with the necessary tools to improve
system availability, optimize resource utilization, and increase productivity.
|
Demos | 06 Dec 2011 |
| IBM Cognos Proven Practices: Understanding the IBM Cognos Adaptive Warehouse Log files
This document describes the numerous log files that are produced by IBM Cognos Adaptive Warehouse, detailing when these files are produced the information they contain.
Also available in:
Portuguese
|
Articles | 06 Dec 2011 |
| IBM Cognos Proven Practices: Configure Microsoft Internet Information Services 7.x for IBM Cognos 10
How to configure Microsoft IIS 7 and 7.5 on Win2008 or Win2008R2 to host an IBM Cognos 10 gateway. This document provides comprehensive details on the steps and various best practices and is a must-read for anyone configuring IIS7 for Cognos 10.
Also available in:
Portuguese
|
Articles | 02 Dec 2011 |
| Scaling of DB2 for Linux, UNIX, and Windows memory-related configuration
parameters on a test system
This article describes the scaling of the number of users, DB2 instance memory, and memory-related configuration parameters on a test system,
based on configuration of a production system for DB2 for Linux, UNIX, and Windows.
The article includes a sample script automating the scaling process. This helps in a
realistic simulation of workloads on a test system (captured on a production system).
Also available in:
Chinese
Portuguese
|
Articles | 01 Dec 2011 |
| DB2 9.7: Run Oracle applications on DB2 9.7 for Linux, UNIX, and Windows
IBM DB2(R) 9.7 for Linux(R), UNIX(R), and Windows(R) 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. [2011 Dec 01: This article has been updated to include new features added in
DB2 9.7 Fixpacks 1-5, such as support for OCI, Pro*C, and NCHAR support.]
|
Articles | 01 Dec 2011 |
| IBM Cognos 8 Failover and Load Balancing
This paper talks about the implementation of failover through load balancing within the IBM Cognos 8 Application tier.
Also available in:
Portuguese
|
Articles | 23 Nov 2011 |
| Bitemporal modeling with InfoSphere Data Architect, Part
2: Modeling system period temporal requirement
Industry regulations and competitive pressures are prompting IT departments to maintain more data for longer periods of time and to provide
better ways for business users to analyze past, current, and future events. In order to achieve these goals, firms are developing time-aware applications
and queries with temporal databases. Beginning with InfoSphere Data Architect version 7.6, you can model relational databases as well as temporal
relational databases. This two-part series will demonstrate how you can accelerate temporal data modeling with a DB2 for z/OS version 10
database by adopting InfoSphere Data Architect 7.6.
Also available in:
Portuguese
|
Articles | 23 Nov 2011 |
| Customizing InfoSphere MDM Server using pluggable business object query and
pluggable SQL framework
InfoSphere Master Data Management Server is a highly customizable
product that can meet stringent performance and scalability requirements. To
meet specific performance requirements of clients, the product offers a
pluggable business object query and pluggable SQL framework. These features
help in modifying an existing query used by the MDM server, thus helping in
optimizing the application. These are important customization options provided
with MDM Server. This article focuses on the recommended practices for
implementing InfoSphere MDM Server pluggable business object queries and
pluggable SQL.
Also available in:
Chinese
|
Articles | 23 Nov 2011 |
| Value Realization from Efficient Software Deployment
Several issues call for a structured approach that gets the most business value out of software already purchased. The objectives of this approach are to:
* Create maximum awareness throughout the organization of the software purchased.
* Track software use in IT projects and act if products are not used at all, used improperly, or insufficiently used.
* Facilitate use of software products in projects, especially when software products are complex and require a lot of integration.
We can summarize the overall objective of this approach as ensuring that the business units in an organization obtain the maximum possible value of software products purchased, which is also the scope of this IBM® Redbooks publication.
|
Redbooks | 21 Nov 2011 |
| Implementing an InfoSphere Optim Data Growth Solution
In this IBM Redbooks publication, we describe the IBM InfoSphere Optim Data Growth solutions and a methodology that provides implementation guidance from requirements analysis through deployment and administration planning. We also discuss various implementation topics including system architecture design, sizing, scalability, security, performance, and automation.
|
Redbooks | 21 Nov 2011 |
| IBM IMS Version 12 Technical Overview
This IBM Redbooks publication explores the new features of IMS 12 and Enterprise Suite 2.1 and provides an overview of the IMS tools. In addition, this book highlights the major new functions and facilitates database administrators in their planning for installation and migration.
|
Redbooks | 21 Nov 2011 |
| Metadata Management with IBM InfoSphere Information Server
This IBM Redbooks publication introduces the information governance initiative and highlights the immediate needs for metadata management. It explains how IBM InfoSphere Information Server provides a single unified platform and a collection of product modules and components so that organizations can understand, cleanse, transform, and deliver trustworthy and context-rich information. It describes a typical implementation process. It explains how InfoSphere Information Server provides the functions that are required to implement such a solution and, more importantly, to achieve metadata management.
|
Redbooks | 21 Nov 2011 |
| Designing a Successful Performance and Scalability Test for IBM Cognos BI
The purpose of this document is to help guide people with designing a successful Performance and Scalability test with Cognos 8.
|
Articles | 17 Nov 2011 |
| Bitemporal modeling with InfoSphere Data Architect, Part
1: Modeling application period temporal requirement
Industry regulations and competitive pressures are prompting IT departments to maintain more data for longer periods of time and to provide
better ways for business users to analyze past, current, and future events. In order to achieve these goals, firms are developing time-aware applications
and queries with temporal databases. Beginning with InfoSphere Data Architect version 7.6, you can model relational databases as well as temporal
relational databases. This two-part series will demonstrate how you can accelerate temporal data modeling with a DB2 for z/OS version 10
database by adopting InfoSphere Data Architect 7.6.
Also available in:
Portuguese
|
Articles | 17 Nov 2011 |
| IBM Cognos Proven Practices: Designing a Successful Performance and Scalability Test for IBM Cognos BI
High level guidance for designing a successful performance and scalability test with IBM Cognos BI.
|
Articles | 17 Nov 2011 |
| Effectively use DB2 data movement utilities in a data warehouse environment
Choosing proper data movement utilities and methodologies is key to efficiently moving data between different systems in a large data
warehouse environment. To help you with your data movement tasks, this article provides insight on the pros and cons of each method with
IBM InfoSphere Warehouse, and includes a
comparative study of the various methods using actual DB2 code for the data movement.
Also available in:
Chinese
|
Articles | 17 Nov 2011 |
| IBM InfoSphere Streams: Assembling Continuous Insight in the Information Revolution
In this IBM Redbooks publication, we discuss and describe the positioning, functions, capabilities, and advanced programming techniques for IBM InfoSphere™ Streams (V2), a new paradigm and key component of IBM Big Data platform. Data has traditionally been stored in files or databases, and then analyzed by queries and applications. With stream computing, analysis is performed moment by moment as the data is in motion. In fact, the data might never be stored (perhaps only the analytic results). The ability to analyze data in motion is called real-time analytic processing (RTAP).
|
Redbooks | 17 Nov 2011 |
| Implementing Imaging Solutions with IBM Production Imaging Edition and IBM Datacap Taskmaster Capture
This IBM Redbooks publication introduces Production Imaging Edition, its components, the system architecture, its functions, and its capabilities. It primarily focuses on IBM Datacap Taskmaster Capture V8.0, including how it works, how to design a document image capture solution, and how to implement the solution using Datacap Studio. Datacap Studio is a development tool that designers use to create rules and rule sets, configure a document hierarchy and task profiles, and set up a verification panel for image verification.
This book highlights the advanced technologies that are used to create dynamic applications, such as IBM Taskmaster Accounts Payable Capture. It includes an in-depth walkthrough of the dynamic application, Taskmaster Accounts Payable Capture, which provides invaluable insight to designers in developing and customizing their applications.
In addition, this book includes information about high availability, scalability, performance, and backup and recovery options for the document imaging solution. It provides known best practices and recommendations for designing and implementing such a solution.
|
Redbooks | 17 Nov 2011 |
| Security Functions of IBM DB2 10 for z/OS
This IBM Redbooks publication provides a detailed description of DB2 10 security functions from the implementation and usage point of view. It is intended to be used by database, audit, and security administrators.
|
Redbooks | 17 Nov 2011 |
| Creating comparison and synchronization reports with InfoSphere Data Architect
See how Tom, a data modeler for the Sample Outdoors company, uses comparison and synchronization reports to distribute information about proposed, upcoming, and implemented changes to data models.
|
Demos | 17 Nov 2011 |
| Implement custom query transactions for IBM InfoSphere Master Data
Management Server
Learn how to extend IBM InfoSphere Master Data Management Server by
implementing new query transactions using the MDM Server Workbench.
Also available in:
Chinese
Portuguese
|
Tutorial | 17 Nov 2011 |
| Migrate OpenMRS to DB2 and WebSphere Application Server
Learn how to migrate OpenMRS
into IBM DB2 and IBM WebSphere Application Server. This article shows you how
to prepare the database, import the source code, and modify the project for WebSphere
Application Server.
Also available in:
Portuguese
|
Articles | 15 Nov 2011 |
| Install and configure DB2 on UNIX to support change and configuration
management
You can use several relational database management system (RDBMS) with IBM
Rational ClearQuest versions 7.1.2 and higher, including Oracle, Microsoft SQL Server,
Microsoft Access, and DB2. Unlike the other systems, DB2 is bundled with Rational
ClearQuest. The benefit to using DB2 as a backend database can be realized in the costs
you save, but installing and configuring it can be challenging especially if you are not
familiar with DB2. In this article, we provide instructions to help you install and
configure DB2 on UNIX operating systems to use as a backend database with Rational
ClearQuest.
Also available in:
Portuguese
|
Articles | 15 Nov 2011 |
| How to use Google Chart Tools with IBM Mashup Center
Google Chart Tools provide a rich set of visualization capabilities, such as
scatter chart and gauge, that complement the chart types available with the
IBM Mashup Center charting widget. You will see how Google Chart Images can be
used with IBM Mashup Center to generate markers on the Navteq mapping widget.
In addition, the article describes the building of a custom widget that uses
Google Chart Tools API to visualize data from enterprise data feeds.
Also available in:
Portuguese
|
Articles | 10 Nov 2011 |
| Managing database connections with the IBM Data Studio web console
Learn how you can use the web console of IBM Data Studio to manage and
share database connection information. This feature helps to increase
productivity among Data Studio users and reduces the overhead of tooling
configuration.
|
Articles | 10 Nov 2011 |
| IBM Cognos Proven Practices: IBM Cognos BI – Active Report Tree Control
A brief video illustrating how to create a tree control using IBM Cognos Active Report.
|
Articles | 09 Nov 2011 |
| Introduction to IBM i OmniFind Health Checker
This article describes a set of DB2 stored procedures that can be used by administrators to identify common problems related to OmniFind Text Search server for DB2 for i, so that issues with text search servers and text search indexes can be resolved quickly without the need for advanced support.
Also available in:
Chinese
|
Articles | 07 Nov 2011 |
| Integrate InfoSphere Guardium Data Redaction with IBM Classification Module
InfoSphere Guardium Data Redaction is capable of finding and concealing sensitive text within a document.
Within an organization, not all documents contain sensitive data.
For the data redaction to be effective, it is critical that relevant documents be identified.
The sensitivity of the entities is often dependent on context. InfoSphere Classification Module
is capable of identifying sensitive documents containing data that require redaction. This
article explains how to integrate Guardium Data Redaction and Classification Module to achieve the goal
of redacting only relevant documents.
Also available in:
Portuguese
|
Articles | 03 Nov 2011 |
| Protect your sensitive data using InfoSphere Optim Designer
IBM InfoSphere Optim Data Masking Solution V2.2 is a solution to protect
sensitive data in data sources with data privacy functions. IBM InfoSphere
Optim Data Masking Solution V2.2 provides various features for data masking as
"data privacy policies". Optim Designer is a component of IBM InfoSphere Optim
Data Masking Solution V2.2 that allows defining and designing "data management
services" to mask sensitive data. This article explains how to protect
sensitive data using Optim Designer and provides examples.
Also available in:
Portuguese
|
Articles | 03 Nov 2011 |
| Transform and model your DB2 data using WebSphere Transformation
Extender
An application takes data as input for business logic processing in a specific format, such as text, XML,
EDIFACT, X12, flat file, and so on. The database contains the raw data that needs to be modelled and converted in a specific data format so
that the application can use it. For example, a web services-based application requires data in XML format for processing. To achieve this business
requirement, you can use WebSphere Transformation Extender with an IBM DB2 database for data modeling and data transformation. This article explains
how to use IBM WebSphere Transformation Extender with a DB2 database. This allows you to create, modify and interpret the data present at
the database layer and change this data to a specific data format using WebSphere Transformation Extender.
Also available in:
Portuguese
|
Articles | 03 Nov 2011 |
| IBM Cognos Proven Practices: IBM Cognos BI - Create Side-by-Side Chart Comparisons with IBM Cognos Active Report
A brief video illustrating how to create two side-by-side charts that allow you to compare data from various cities in an IBM Cognos Active Report.
|
Articles | 03 Nov 2011 |
| IBM Cognos Proven Practices: IBM Cognos BI - Working with Tab Controls in IBM Cognos Active Report
A brief video illustrating how to use tab controls in an IBM Cognos Active Report.
|
Articles | 03 Nov 2011 |
| IBM Cognos Proven Practices: IBM Cognos BI - Create a Dynamically Exploding Pie Chart with IBM Cognos Active Report
A brief video illustrating how to create a dynamically exploding pie chart in an IBM Cognos Active Report.
|
Articles | 03 Nov 2011 |
| Introduction to IBM Cognos Business Intelligence V10.01
IBM Cognos Business Intelligence (BI) helps organizations meet strategic
objectives and provides real value for the business by delivering the information
everyone needs while also reducing the burden on IT. This Knowledge path is focused
on the Core Business Intelligence products such as metadata design, ad-query,
reporting and dashboards.
Also available in:
Portuguese
|
Knowledge paths | 01 Nov 2011 |
| Spark, an alternative for fast data analytics
Although Hadoop captures the most attention for distributed data analytics, there are alternatives that provide some interesting advantages to the typical Hadoop platform. Spark is a scalable data analytics platform that incorporates primitives for in-memory computing and therefore exercises some performance advantages over Hadoop's cluster storage approach. Spark is implemented in and exploits the Scala language, which provides a unique environment for data processing. Get to know the Spark approach for cluster computing and its differences from Hadoop.
|
Articles | 01 Nov 2011 |
| IOD 2011: Day Three - Conversation with Inhi Cho Suh, Vice President, Product Management and Strategy for IBM IM
Inhi Cho Suh, Vice President, Product Management and Strategy for IBM IM, talks about how data finds data and about how relevance finds you.
|
Presentations | 28 Oct 2011 |
| Online roll-out with table partitioning in InfoSphere Warehouse
Starting with DB2 9.7.1, the table partitioning feature is enhanced with
support for online roll-out using detach. With online roll-out, queries
continue to access the partitioned table while one or more partitions of the
table are being detached using the ALTER TABLE DETACH PARTITION command. This
article discusses how online detach improves the availability of the warehouse
and describes some best practices to leverage and monitor the new behavior. A
stored procedure is provided to help database administrators to script the
post-detach processing on the target table, that is, the new table created as
a result of the detach operation. The article also demonstrates how the same
procedure can be used to simulate synchronous detach behavior in certain
application scenarios. We conclude with frequently asked questions related to
detach.
|
Articles | 27 Oct 2011 |
| IBM Cognos 10 Report Studio: Practical Examples
Using practical examples based on years of teaching experiences as IBM Cognos instructors, the authors provide you with examples of typical advanced reporting designs and complex queries in reports. The reporting solutions in this book can be directly used in a variety of real-world scenarios to provide answers to your business problems today. The complexity of the queries and the application of design principles go well beyond basic course content or introductory books. IBM Cognos 10 Report Studio: Practical Examples will help you find the answers to specific questions based on your data and your business model.
|
Books | 25 Oct 2011 |
| Build lightweight OSGi applications with Eclipse
OSGi has been acting as a de facto industry standard to build dynamic
modular systems in the Java world and many other fields. Using a series of
correlative examples, this article demonstrates the processes, scenarios,
solutions and practices to develop an OSGi application in Eclipse. Read
further to gain a systematic understanding of the OSGi framework and core services.
|
Articles | 25 Oct 2011 |
| Beyond MySQL
Although MySQL is one of the most popular programs, many developers have
felt the need to branch it into other projects, each offering their own
speciality. Many interesting sub-projects and branches now exist.
|
Articles | 25 Oct 2011 |
| DB2 Basics: Demystifying table and table space states
The DB2 database manager uses table and table space states to control access to data or to help
protect the integrity of the database. This article describes these states and shows you, by way of working
examples, typical conditions under which they appear, and how to respond to them.
|
Articles | 21 Oct 2011 |
| Accelerate Hibernate and iBATIS applications using pureQuery,
Part 1: Enable static SQL and heterogeneous batching for Hibernate
applications
When extended with the downloadable IBM Integration Module, the IBM
Optim pureQuery Runtime simplifies the process of generating DB2 static SQL
for Hibernate and iBATIS applications. It does this without requiring changes
to your application code or gathering SQL from production
workloads. The Optim pureQuery Runtime also enables Hibernate and iBATIS
applications that access DB2 or Informix to benefit from the heterogeneous
batching feature in pureQuery. This
article is part one of a four-part series about using the IBM
Integration Module with Hibernate applications. This article includes a
downloadable sample application that illustrates how you can easily enable
static SQL and heterogeneous batch functions with Hibernate applications. The
article also provides informal elapsed time performance measurements. Part 2
focuses on iBATIS applications.
|
Articles | 21 Oct 2011 |
| Accelerate Hibernate and iBATIS applications using pureQuery,
Part 3: Auto-tune data fetch strategies in Hibernate applications with
pureQuery
Development teams that build applications using Hibernate as the Object Relational
Mapper (ORM) or persistence mechanism spend significant time tuning the amount of data that
Hibernate fetches from the database, and the number of SQL queries that Hibernate uses in each
business use-case of the application. In this article, learn how the IBM InfoSphere Optim pureQuery auto-tuning feature for
Hibernate automates the process of determining these problems and automatically fixing them without
intervention. Both the application development team and DBAs benefit from the solution.
Also available in:
Portuguese
|
Articles | 21 Oct 2011 |
| Creating an active-active data warehouse topology using IBM InfoSphere Warehouse
This article explains how you can create an active-active environment for IBM InfoSphere Warehouse to meet the highest availability requirements using DB2 for Linux, UNIX, and Windows, WebSphere Edge Components, and Q Replication.
|
Articles | 21 Oct 2011 |
| IBM Cognos Proven Practices: IBM Cognos Active Report 10.1.1 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.
|
Articles | 21 Oct 2011 |
| Distributed DBA: Table movement made easy
With the help of DB2 9.7, learn how to move
tables, indexes, long data, and large object (LOB) data from one table space to another
using the ADMIN_MOVE_TABLE() procedure. This article also demonstrates how to use the
ADMIN_MOVE_TABLE() procedure to alter the structure of an existing table during a move
operation.
|
Articles | 21 Oct 2011 |
| Does REORG Matter?
With new technology like solid-state drives, can you eliminate the need for REORG with your DB2 for z/OS data? In this article, take a look at the pros and cons, and examine the reasons why you will probably need to still have a plan for regular reorganizations.
|
Articles | 21 Oct 2011 |
| Smarter is: Putting renewable energy on the map
Vestas Wind Systems of Aarhus, Denmark uses IBM InfoSphere
BigInsights to analyze location-specific data, such as wind speed, temperature,
humidity, atmospheric pressure, and precipitation, in order to predict wind farm
performance. This helps them to install wind turbines at optimal locations, converting
energy at a modest price, while leaving a minimal carbon footprint.
|
Articles | 21 Oct 2011 |
| Programmers only: Utilities for developers
Bonnie Baker talks about some of the DB2 utilities such as REORG
and LOAD that can save you time. Using them instead of program code can help you to
improve system availability and performance.
|
Articles | 21 Oct 2011 |
| Newsbytes: IBM Data Management magazine, Issue 4, 2011
Get the latest IBM database news in this wide-ranging summary of
topics, including a new version of IMS, IBM Netezza High Capacity Appliance, new
Infosphere releases, business partner new, certifications, and much more.
|
Articles | 21 Oct 2011 |
| Informix DBA: Every last drop
Getting the best performance out of limited resources was the theme of
the recent Fastest Informix DBA contest, held at the 2011 IIUG Informix Conference. In this article, see
how the contestants answered the challenge.
|
Articles | 21 Oct 2011 |
| Know Before You Go
Bringing in a new application or a new piece of code can raise a
question: will it work the way it's supposed to? In this article, Hans Kamman and his
team offer advice on benchmarking and the basics of efficient, effective
testing to minimize risk and turn you into a change champion without
gambling.
|
Articles | 21 Oct 2011 |
| IIUG user view: News you can use
IIUG president Stuart Litel talks about how Informix is used in
mission-critical applications and how social media is connecting the IIUG community in new ways.
|
Articles | 21 Oct 2011 |
| Data Architect: Applied intelligence
Robert Catterall talks about how doing the wrong kind of work can reduce
the value that your programmers deliver to the organization.This article showcases the
sophisticated SQL optimization technology built into DB2 and illustrates how DB2 can simplify
complex work for you.
|
Articles | 21 Oct 2011 |
| Early Warnings, Fast Fixes
Mission-critical databases require tools to increase your database
monitoring strategy with an early warning system that's flexible, lightweight, and
affordable. In this article, learn how to maximize mission-critical
uptime with existing tools.
Also available in:
Chinese
|
Articles | 21 Oct 2011 |
| Migration: One year later
Data Management magazine published a special report on migration from Oracle to DB2 9.7
environments last year. After the publication of this story, many
organizations performed their own migrations and reported their experiences to IBM, to
industry analysts, and to the trade press. In this article, we will take a look at how
we did. Where did our coverage meet expectations, where did we fall short, and what's
changed since then?
|
Articles | 21 Oct 2011 |
| IBM Cognos Proven Practices: IBM Cognos 8 Audit Extension
An IBM Cognos 8 SDK application that provides enhanced auditing for IBM Cognos 8 BI, including Role auditing. The version of the application is 1.5.08 and it can be installed on IBM Cognos 8 BI versions 8.3 and 8.4.x.
Also available in:
Spanish
|
Articles | 20 Oct 2011 |
| Using IBM DB2 pureScale Feature with application cluster transparency in IBM
BladeCenter
This article provides a validated, end-to-end hardware and software reference
architecture for running IBM DB2 pureScale Feature on IBM BladeCenter. The reference architecture offers
four solution templates intended to streamline production implementations. The article ties the ease of
deployment, simplicity and reliability of DB2 application cluster transparency to cost-effective
BladeCenter servers — resulting in a solution that has the scalability and high availability needed for
online transaction processing (OLTP) workloads.
|
Articles | 20 Oct 2011 |
| Using the script option to rename PDF files to the Burst Key value
Burst output can be directed to a file system rather than being stored within the Content Store. This process produces uniquely named output files created with a generated key. A script can be used to rename these files according to the burst key value.
|
Articles | 19 Oct 2011 |
| 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 | 19 Oct 2011 |
The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.
All information submitted is secure.
The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.
Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.
All information submitted is secure.