![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
Title
|
Type
|
Date
|
|---|---|---|
| Implementing Database Security and Auditing - Authentication and Password Security
This book is the definitive guide for information security professionals, DBAs, and auditors. Authored by database security expert, IBM Gold Consultant, and Guardium CTO Ron Ben-Natan, this paper contains hundreds of practical tips and examples for protecting sensitive information and passing audits smoothly. In Chapter 4, you learn best practices and techniques involving authentication and user account management, password strength and password profiles, as well as user account/password maintenance
|
Books | 24 May 2012 |
| IBM InfoSphere Guardium Information Center
Includes product documentation for installation and other key tasks.
|
Product documentation | 24 May 2012 |
| Implementing Database Security and Auditing - Auditing Categories
This is the definitive guide for information security professionals, DBAs, and auditors. Authored by database security expert, IBM Gold Consultant, and Guardium CTO Ron Ben-Natan, this paper contains hundreds of practical tips and examples for protecting sensitive information and passing audits smoothly. In Chapter 12, you learn which audit logging trails you need in order to address key security and compliance requirements.
|
Books | 24 May 2012 |
| 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.
|
Tutorial | 24 May 2012 |
| IBM Cognos Proven Practices: Enhanced Search Options in IBM Cognos 10 BI
The purpose of this document is to provide an overview/best practice on how consumers of IBM Cognos Business Intelligence (BI) can optimally search for content (reports, metrics, analysis, data) using IBM Cognos Enhanced Search.
|
Articles | 24 May 2012 |
| Which distributed edition of DB2 10.1 is right for you?
Learn the details of what makes each edition of DB2 10.1 for Linux, UNIX,
and Windows unique. The authors lay out the specifications for each edition,
licensing considerations, historical changes throughout the DB2 release
cycle, and references to some interesting things customers are doing with DB2.
This popular article will be updated during the release for any intra-version
licensing changes announced in future Fix Packs.
|
Articles | 24 May 2012 |
| Compare the distributed DB2 10.1 database servers
In a side-by-side comparison table, the authors make it
easy to understand the basic licensing rules, functions, and feature
differences between the members of the distributed DB2 10.1 for Linux, UNIX,
and Windows server family as of April 30, 2012.
|
Articles | 24 May 2012 |
| Licensing distributed DB2 10.1 servers in a high availability (HA)
environment
Are you trying to license your IBM
DB2 Version 10.1 for Linux, UNIX, and Windows servers correctly in a high availability environment?
Do you need help interpreting the announcement letters and licenses?
This article explains it all in plain
English for the DB2 10.1 release that became
generally available on April 30, 2012.
|
Articles | 24 May 2012 |
| Starting your education in big data
Learn about current free, online courses that are available at
BigDataUniversity.com. Follow the suggested path to get started and grow your
knowledge on big data, and get ready to implement it to meet your own business needs.
|
Articles | 24 May 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 | 24 May 2012 |
| IBM Cognos Proven Practices: Using the periodsToDate function within IBM Cognos 10 Report Studio to Calculate an OLAP Running-Total
A description of how the dimensional function periodsToDate can be used outside of a time dimension to calculate a running total against on online analytical processing (OLAP) data source.
Also available in:
Portuguese
|
Articles | 24 May 2012 |
| Improve performance and reduce costs for DB2 for Linux, UNIX, and Windows with
IBM InfoSphere Optim
Learn how the staff at a fictional
organization uses various InfoSphere Optim tools included in DB2 Advanced Enterprise Server Edtion to improve performance and reduce costs.
|
Demos | 24 May 2012 |
| HOWTO Secure and Audit Oracle 10g and 11g - Database Activity Monitoring
This guide provides authoritative and succinct instructions highlighted by examples. In this chapter, you learn best practices and techniques for monitoring and analyzing database activity from your Oracle system.
|
Books | 23 May 2012 |
| Implementing database security and auditing: Getting started
Written by security expert Ron Ben Natan, Ph.D., this book provides valuable information for protecting sensitive information and passing audits smoothly. In Chapter 1, Getting Started, you will learn the first steps and best practices for effectively securing Oracle, SQL Server, DB2, MySQL, and Sybase environments.
|
Books | 23 May 2012 |
| HOWTO Secure and Audit Oracle 10g and 11g - Standard auditing
This guide provides authoritative and succinct instructions highlighted by examples.This chapter explores the reasons why your auditors and multiple regulations, such as Sarbanes Oxley and PCI, require database auditing to provide records of what was done in your database, what certain users did, what privileges were used, and so on. An audit trail is one of the most effective ways to combat wrongdoing and detect suspicious activity.
|
Books | 23 May 2012 |
| HOWTO Secure and Audit Oracle 10g and 11g - Mandatory and administrator auditing
This guide provides authoritative and succinct instructions highlighted by examples. Administrative and mandatory auditing are separate mechanisms that provide capabilities to tighten controls and access, monitor business operations, and find any activities that may deviate from company policy. In this chapter, learn how to audit SYS activities and SYSDBA privileges, use mandatory auditing, enable administrator auditing, and use Syslog auditing.
|
Books | 23 May 2012 |
| HOWTO Secure and Audit Oracle 10g and 11g - Fine-Grained Auditing
This guide provides authoritative and succinct instructions highlighted by examples. In this chapter, you learn how to define and manage fine-grained audting (FGA) policies, read FGA tables and views, and evaluate FGA performance.
|
Books | 23 May 2012 |
| HOWTO Secure and Audit Oracle 10g and 11g - Authentication
This guide provides authoritative and succinct instructions highlighted by examples. In this chapter, you learn best practices and techniques for securing your Oracle database environments, including how to enforce complex passwords, how to check for weak passwords, how to define how many failed logins are allowed before locking accounts, and how to limit system resource usage to prevent denial-of-service attacks.
|
Books | 23 May 2012 |
| HOWTO Secure and Audit Oracle 10g and 11g - Account Security
This guide provides authoritative and succinct instructions highlighted by examples. Account security is one of the fundamental building blocks of ensuring a secure Oracle environment. In this chapter, you learn how to create users, manage passwords, limit accounts, and review which limits are assigned to accounts.
|
Books | 23 May 2012 |
| HOWTO Secure and Audit Oracle 10g and 11g - Hardening the database
This guide provides authoritative and succinct instructions highlighted by examples. In this chapter, you learn how to choose a hardening guideline, use a vulnerability assessment tool, and create and maintain a secure configuration baseline.
|
Books | 22 May 2012 |
| 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 | 18 May 2012 |
| Get started with the IBM InfoSphere DataStage and QualityStage
Operations Console Database, Part 1: An introduction
This article is a deep dive into the schema of the IBM InfoSphere
DataStage and QualityStage Operations
Database, and in particular the tables and columns that make
up its key relationships. Specimen SQL queries are included
to demonstrate how data can be read from these tables to
answer specific operational questions.
You can adapt these to build, for example,
custom reports based on the operational data collected at your particular
DataStage and QualityStage installation.
|
Articles | 17 May 2012 |
| IBM Cognos Proven Practices: Monitoring IBM Cognos 8 BI in the z/OS Environment – An Introduction
Using various z/OS tools to monitor IBM Cognos 8 BI and supporting applications such as WebSphere and DB2.
|
Articles | 17 May 2012 |
| Optimize storage with deep compression in DB2 10
Organizations are generating more data now than at any other time in history. And the need to comply with legal and governmental
regulations means that they're keeping that data around for longer periods of time. As a result, databases are growing at an astonishing
rate. In fact, according to industry analysts, enterprise databases are growing at the rate of 125 percent annually. This explosion in
data volume places tremendous pressure on enterprises to store, protect, distribute, and derive value from all the data being generated.
In 2007, IBM responded to this pressure by introducing new compression technology, known as Deep Compression, in DB2 Version 9. Since then,
IBM has improved this technology in subsequent releases of DB2. This article describes the various compression methods that are available
in DB2 Version 10.1, as well as provides recommended "best practices" that will help you achieve maximum storage space savings when you
adopt any of the compression techniques available.
|
Articles | 17 May 2012 |
| Get the most from the DB2 HADR standby database
DB2 High Availability Disaster Recovery (HADR) is an easy-to-use
data replication feature that provides a high availability (HA)
solution for both partial and complete site failures. Beginning with DB2 V9.7
Fix Pack 1, the standby database permits read access from user applications.
This article explains how this capability can be used for read applications,
and what the current limitations are. In addition, it includes suggestions
for how you can utilize the potential of the standby database.
|
Articles | 17 May 2012 |
| Optim Open Data Manager and Optim Connect thin clients for Linux and UNIX
environments
Legal compliance and business requirements often require organizations to retain data for certain period of time.
IBM InfoSphere Optim offers a database archive solution for archiving data from either production databases (to control data growth)
or from legacy applications (for application retirement purposes). Through Optim Open Data Manager, Optim can provide continuous access to archived data using
open standards such as ODBC, JDBC, or XML.
This article explains the difference between the available methods for accessing Optim
archived data on Linux/UNIX environments and shows how to configure ODBC access to
Optim archived data using reporting tools such as IBM Cognos on a Linux environment.
|
Articles | 10 May 2012 |
| System Administration Certification exam 919 for Informix 11.70
prep, Part 2: Informix space management
In this tutorial, you'll learn how to configure and manage storage spaces on
IBM Informix(R) database, the utilities to create those storage
spaces, and how to use
fragmentation and features to optimize the storage in the database. This tutorial prepares you
for Part 2 of the System Administration Certification exam 919 for Informix
v11.70.
|
Tutorial | 10 May 2012 |
| DB2 Tools corner: Introducing the IBM-supported batch interface for change management in DB2 Administration Tool for z/OS V10.1 and DB2 Object Comparison Tool for z/OS V10.1
Now you can use the new batch interface enhancement for managing changes to DB2 for z/OS objects
and authorizations with DB2 Administration Tool for z/OS and DB2 Object Comparison Tool for z/OS.
This enhancement lets you create, customize, and reuse batch jobs to match how you manage changes to DB2 for z/OS.
|
Articles | 10 May 2012 |
| Understand the trusted context feature in Informix
The use of connection pooling to data sources can lead to role-based
security breaches. Support for trusted connections and trusted contexts
in Informix server gives the flexibility of connection reuse, granting of
controlled privileges to the middle tier, and enhanced user accountability
in a three-tier application without compromising database security, all while
improving system performance. This article discusses trusted connections and
trusted contexts, and shows how to manage trusted contexts using JDBC, ESQL/C
and ODBC drivers.
|
Articles | 10 May 2012 |
| Exploring IMS disaster recovery solutions, Part 4: Coordinated IMS and DB2 solutions
Every customer needs a disaster recovery (DR) plan. The strategy will differ from one
customer to the next. For IMS, there are two types of DR solutions: 1) IMS specific, and
2) Storage Mirroring. In this tutorial, we explore the IMS specific DR solutions.
There are solutions that use only the IMS base product and solutions that use the IBM IMS
Tools products. For each DR solution, there will be a discussion of the key concepts related
to that solution.
|
Tutorial | 03 May 2012 |
| Test drive DB2 10.1 using a virtual appliance
IBM virtual appliances allow you to easily experience
the power of IBM software, such as
DB2 for Linux, UNIX, and Windows, without having to go through the
setup process for either the operating system or IBM software. The virtual
appliances are provided with pre-installed operating systems, and
additionally, they deeply integrate IBM software in VMware virtual machines.
Also available in:
Portuguese
|
Articles | 03 May 2012 |
| DB2 best practices: Multi-temperature data management
Data in a data warehouse can be classified according to its temperature. The temperature
of data is based on how often it is accessed, how volatile it is, and how important the
performance of the queries that access the data is. Hot data is frequently accessed and
updated, and users expect optimal performance when accessing this data. Cold data is
rarely accessed and updated, and the performance of the queries that access this data is
not essential. Using faster, more expensive storage devices for hot data and slower, less
expensive storage devices for cold data optimizes the performance of the queries that
matter most while helping to reduce overall cost.
Also available in:
Chinese
|
Articles | 01 May 2012 |
| DB2 Express-C 10: Even more value
In our industry, six years is forever. By this measure DB2 Express-C has
been around for an eternity.
Introduced in 2008 as a free version of the IBM's DB2 DBMS, DB2 Express-C quickly became very popular
with DBAs, application developers, students and ISVs. On April 30, 2012 after
6 years in the market with numerous updates, DB2 Express-C 10 was released for anyone to download
or to use on the cloud free of charge. We would not have it any other way.
Also available in:
Portuguese
|
Articles | 30 Apr 2012 |
| DB2 V10.1 Query performance enhancements
A number of performance improvements have been included in DB2 Version 10.1
to improve the speed of many queries. These improvements are automatic; there are
no configuration settings or changes to the SQL statements required.
|
Articles | 30 Apr 2012 |
| Best practices: Temporal data management with DB2
The DB2 for Linux, UNIX, and Windows Version 10 software ("DB2") supports time-based data
management that allows you to insert, update, delete, and query data in the past, the present,
and the future while keeping a complete history of "what you knew" and "when you knew it".
|
Articles | 30 Apr 2012 |
| Best practices: Storage optimization with deep compression
This document communicates best practices for using the DB2
Storage Optimization Feature with the DB2 for Linux, UNIX, and Windows
product.
|
Articles | 30 Apr 2012 |
| DB2 V10.1 Multi-temperature data management
recommendations
Data in a data warehouse can be classified according to its temperature.
The temperature of data is based on how old it is, how often it is accessed,
how volatile it is, and how important the performance of the queries that access
the data is. Hot data is frequently accessed and updated, and users expect optimal
performance when they access this data. Cold data is rarely accessed and updated,
and the performance of the queries that access this data is not essential.
|
Articles | 30 Apr 2012 |
| Free: IBM DB2 Express-C
Download DB2 Express-C 10.1, a fully licensed product available at no-charge for the
community. It does not have any time-based usage restrictions or database size limitations. Use this
data server for application development and deployment.
|
Trial Downloads | 30 Apr 2012 |
| Create an ER diagram for an Informix database
Understanding the structure of a database is important to administrators as well as to developers.
An image illustrates more details within seconds than any textual listing can deliver.
This tutorial demonstrates how to use a tool that can deliver an entity-relationship
graphical overview of an existing Informix relational database and the contained objects.
|
Tutorial | 26 Apr 2012 |
| Data transformation with IBM Netezza appliance using IBM InfoSphere Data
Masking solution
Learn about using the IBM InfoSphere Optim Data Masking solution with
IBM InfoSphere Federation Server to de-identify data residing in an IBM Netezza
Data Warehouse appliance. In this article, you will follow a series of detailed
steps to configure InfoSphere Federation Server and InfoSphere Optim, establish
a connection to a Netezza appliance, extract and de-identify data from Netezza
appliance using InfoSphere Optim, and upload the masked data back to the Netezza
appliance.
|
Articles | 26 Apr 2012 |
| IBM Cognos on SAP overview for report consumers, Part 2: Adhoc querys
See how casual report authors and consumers (i.e. non-power users) have a self-service way to do an adhoc query and get simple or highly complex reports over the web.
|
Demos | 26 Apr 2012 |
| IBM Cognos on SAP overview for report consumers, Part 1: Portlets
Walk through the various portlets that are available with Cognos Business Intelligence.
|
Demos | 26 Apr 2012 |
| Create and customize virtual application patterns
Platform as a Service virtual application patterns are realized by supporting a
combination of application-centric deployment models, virtual applications (consisting
of individual components and policies), the infrastructure and middleware they employ,
and workload-specific content -- extensions or "plug-ins" that define components,
links, and policies used to describe and deploy virtual application patterns, such as
those usable on both the IBM SmartCloud Enterprise cloud and IBM PureSystems. This
article explains how to get started with the IBM Workload Plug-in Development Kit and
on your way to creating and customizing virtual application patterns.
|
Articles | 24 Apr 2012 |
| Implementing IBM DB2 9.7 Enterprise Server edition with Microsoft Failover
Clustering
Configuring a high availability solution with DB2 and Microsoft Failover
Clustering is much easier with the sample configurations provided in this detailed paper.
|
Articles | 24 Apr 2012 |
| Evaluate: IBM InfoSphere Warehouse 10.1 Enterprise Edition
Download a free trial version of IBM InfoSphere Warehouse V10.1 Enterprise Edition,
which makes it easier to discover hidden business opportunities. It provides a comprehensive
platform to design, optimize, discover and grow departmental data marts and enterprise data
warehouses.
|
Trial Downloads | 23 Apr 2012 |
| Exploring IMS disaster recovery solutions, Part 3: IMS Recovery Expert solutions
Every customer needs a Disaster Recovery (DR) plan. The strategies used differ from one customer to another and they differ in time to recovery and loss of data. For IMS, there are five types of DR solutions: restart, recovery, recovery and restart, coordinated IMS and DB2 restart, and coordinated IMS and DB2 disaster recovery and restart. Here in Part 3, we explore both the recovery and recovery and restart solutions provided by the IMS Recovery Expert product.
|
Tutorial | 19 Apr 2012 |
| IBM Cognos Proven Practices: Adaptive Warehouse Target Model Guidelines: Building Custom Calculations
Learn about target model calculations, their purposes and results, and how to use them in Cognos Adaptive Warehouse.
|
Articles | 18 Apr 2012 |
| Use SQL-like languages for the MapReduce framework
Select the most suitable MapReduce implementation for large scale data analysis jobs based on your skills, preferences, and requirements. MapReduce is a simple and powerful programming model that enables the easy development of scalable parallel applications to process vast amounts of data on large clusters of commodity machines. It isolates the application from the details of running a distributed program. But many programmers are unfamiliar with the MapReduce programming style and prefer to use a SQL-like language to perform their tasks. In this article, read an overview of high-level languages and systems designed to tackle these problems and add declarative interfaces on top of the MapReduce framework.
Also available in:
Portuguese
|
Articles | 17 Apr 2012 |
| IBM Cognos Proven Practices: Auto Cascading Prompts without Page Refresh in IBM Cognos Report Studio
This document provides technique to implement auto-cascading of Value prompts without having to do a page refresh.
Also available in:
Chinese
|
Articles | 16 Apr 2012 |
| Use concurrent I/O to improve DB2 database performance
Concurrent I/O is a feature that was introduced in UNIX/Linux platforms mainly for the
benefit of relational database systems. This article explains the difference between the I/O
mechanisms available with UNIX/Linux file systems, and shows how concurrent I/O technology
can be leveraged in a DB2 environment to improve database performance.
|
Articles | 12 Apr 2012 |
| Exploring your InfoSphere BigInsights cluster and sample applications
If you're looking to get off to a quick start with "big data" projects involving IBM's
InfoSphere BigInsights, you'll want to become familiar with its integrated
web console. Through this tool, you can explore the health of your
cluster, navigate your distributed file system, launch IBM-supplied
sample applications, monitor the status of jobs and workflows, and
analyze data using a spreadsheet-style tool. This article takes you on a
tour of the web console, highlighting key capabilities that can help you get up to speed quickly.
Also available in:
Chinese
Portuguese
|
Articles | 12 Apr 2012 |
| Exploring IMS disaster recovery solutions, Part 2: IMS Base and IMS Tools recovery solutions
Every customer needs a Disaster Recovery (DR) plan. The strategies used differ from one customer to another and they differ in time to recovery and loss of data. For IMS, there are five types of DR solutions: restart, recovery, recovery and restart, coordinated IMS and DB2 restart, and coordinated IMS and DB2 disaster recovery and restart. Here in Part 2, we explore the recovery solutions that use only the IMS base functions and some of the functions in the IMS Tools.
|
Tutorial | 12 Apr 2012 |
| Automate your virtual cloud appliance onto IBM PureFlex System
IBM PureFlex System is a cloud-ready, expert, integrated system that brings
together the infrastructure and application layer with proven patterns. PureFlex
System can be specifically optimized to meet specific needs, providing all of the
infrastructure elements required to run your workloads in a single system. To further the IBM PureFlex System advantage with a speedy time-to-deployment, there is the IBM Virtual Appliance Factory toolkit that automates the deployment of your cloud appliance -- your application along with the appropriately configured operating system and middleware -- onto KVM and PowerVM cloud environments. Take a tour of the toolkit.
Also available in:
Japanese
Portuguese
|
Articles | 11 Apr 2012 |
| Using the IBM Workload Plug-in Development Kit
Learn to set up the samples environment in Eclipse, create new projects from the command line, build a single plug-in and pattern type with command-line tools, and develop a plug-in with the Eclipse framework.
Also available in:
Japanese
Portuguese
|
Articles | 11 Apr 2012 |
| Deploy new applications on IBM PureSystems with plug-ins, Part 1
The introduction of IBM PureSystems takes cloud computing to new
heights. One way to prepare an application to leverage IBM PureSystems is to craft a
plug-in, a bridge between the application package and the system. In this article, the authors, IBM Cloud labs team experts, describe the development efforts to enable SugarCRM on IBM PureSystems.
|
Articles | 11 Apr 2012 |
| Manage the topology with virtual system patterns
In the IBM PureApplication System environment, a virtual system pattern is the critical element that allows a user to rapidly set up and manage the cloud middleware topology; a virtual system pattern describes a middleware topology and employs the tools to automatically build that topology in the cloud. IBM PureApplication System virtual system patterns are the captured essence of years of infrastructure-management experience and best practices. Virtual system patterns encapsulate repeatable topology definitions based on various middleware images and runtime configurations; they give you control over the middleware landscape being deployed. In this article, the authors introduce you to virtual system patterns and their place in the ecosystem, describe their components and functions, and provide a basic look at how to create and use a virtual system pattern.
Also available in:
Japanese
Portuguese
|
Articles | 11 Apr 2012 |
| Deploy new applications on IBM PureSystems with plug-ins, Part 2
The introduction of IBM PureSystems takes cloud computing to new
heights. One way to prepare an application to leverage IBM PureSystems is to craft a
plug-in, a bridge between the application package and the system. Part 1 describes the development efforts to enable SugarCRM on IBM PureSystems. SugarCRM is a PHP application that requires the LAMP stack (Linux, Apache, MySQL, PHP). LAMP is not supported by IBM PureSystems out of the box, so the team developed a new pattern type and a set of plug-ins that support the modeling, deployment, and operation of the application atop the base Linux and IBM AIX image.
This article addresses the lessons learned
from their development efforts.
Also available in:
Chinese
Portuguese
|
Articles | 11 Apr 2012 |
| Manage application services with virtual application patterns
In the IBM PureApplication System environment, a virtual
application pattern is the critical element that allows a user to rapidly set up and manage cloud application infrastructure; a virtual application pattern describes an application, and employs the tools to build the appropriate infrastructure for the application and then deploys the application to that infrastructure. IBM PureApplication System virtual application patterns are the captured essence of years of application-infrastructure-deployment experience and best practices. Virtual application patterns encapsulate optimized solutions of multiple middleware elements to host specific types of application workloads. In this article, the authors introduce you to virtual application patterns and their place in the ecosystem, describe their components and functions, and provide a basic look at how to create and use a virtual application pattern.
Also available in:
Japanese
Portuguese
|
Articles | 11 Apr 2012 |
| Preparing for IBM
PureApplication System, Part 3: Choosing a database option
Part 3 of the article series
introduces the integrated DB2 database formats that are found in IBM
PureApplication System. It describes the different forms of DB2 found in
PureApplication System, helps you decide which forms to choose in
different situations, and covers some of the recommended best practices
using DB2 inside PureApplication System.
|
Articles | 11 Apr 2012 |
| IBM Cognos Diagnostics: Use Case: Diagnosing a Series 7 Installation Issue with the IBM Cognos Series 7 Diagnostic Tool
A user is attempting to upgrade from IBM Cognos Series 7 version 7.3 to 7.4, the new installation fails to configure properly and will not start.
|
Articles | 10 Apr 2012 |
| DB2 10: What's new in DB2 10 for Linux, UNIX, and Windows
This article outlines the key features and enhancements in IBM DB2 10 for Linux, UNIX, and Windows. To be released in June,
this latest version delivers new functionality that directly addresses your business needs in the areas of cost reduction,
application performance, productivity, and reliability.
Also available in:
Chinese
Portuguese
|
Articles | 03 Apr 2012 |
| A matter of time: Temporal data management in DB2 10
You could say it was just a matter of time.
Industry regulations and competitive pressures are prompting IT managers to maintain more data for longer periods of time and to provide better ways for business users to analyze past, current, and future events.
To help organizations achieve these goals, IBM has built greater awareness of time into DB2.
Also available in:
Chinese
|
Articles | 03 Apr 2012 |
| Cognos Diagnostic Usability Matrix
The following diagnostic matrix is to help provide assistance in choosing an appropriate diagnostic utility that can help in overall resolution of an issue.
|
Articles | 02 Apr 2012 |
| Introducing InfoSphere Streams 2.0 features, Part
2: Using collections
With the introduction of IBM InfoSphere(R) Streams 2.0 and the Streams
processing language (SPL),
developers gained access to two new collection types: set and map.
This article describes these three collection types and how to exploit them as
part of a native SPL application. You will also learn how to access
collections using a primitive C++ Streams operator.
|
Articles | 02 Apr 2012 |
| Configure automatic maintenance in DB2 for Linux, UNIX, and Windows using
IBM Data Studio
The automatic maintenance capabilities of IBM DB2 for Linux, UNIX, and Windows
relieves DBAs so that they can focus on other vital tasks such as maximizing performance.
This article demonstrate how to configure the automatic maintenance capabilities in DB2 for performing database backups, keeping
statistics current,
and reorganizing tables and indexes as necessary, using IBM Data Studio.
|
Articles | 29 Mar 2012 |
| Exploring IMS disaster recovery solutions, Part 1: Overview
Every customer needs a Disaster Recovery (DR) plan. The strategies used
differ from one customer to another and they differ in time to recovery and
loss of data. For IMS, there are five types of disaster recovery solutions:
restart, recovery, recovery and restart, coordinated IMS and DB2 restart, and
coordinated IMS and DB2 disaster recovery and restart. While the Storage
Mirroring recovery solutions are classified as restart solutions, we will
focus only on the non-Storage Mirroring IMS disaster recovery solutions in
this series.
|
Articles | 29 Mar 2012 |
| Get started now with the Informix TimeSeries solution
IBM Informix provides native support for handling time series data.
The TimeSeries data type present in IBM Informix helps to
reduce the cost of storage as well as helping to increase performance when you select
and load large amounts of time series data. In this article, learn how you can start
creating and loading the time series data. Also, the Virtual Table Interface makes
time series look like the normal tables. This article also describes general architecture
of IBM Informix time series components, steps for creating and loading a time series,
and administering a time series using the Open Admin tool.
|
Articles | 29 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Data Retrieval
This document describe troubleshooting method of an issue connecting to Teradata.
|
Articles | 28 Mar 2012 |
| Best practices: Physical database design for online transaction processing (OLTP)
environments
Understanding the basic concepts, the stages of physical database design, and the
advanced aspects that affect the structure of databases is key for a successful database design.
|
Articles | 28 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Diagnosing an IBM Cognos TM1 Server Problem With the IBM Cognos TM1 Diagnostic Tool
A scenario where the user tries to log on to a TM1 server, enters thier username and password, and receives an error message.
|
Articles | 28 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Diagnosing a Planning Problem with the IBM Cognos Planning Diagnostic Tool
Installing a new version of IBM Cognos Planning, the component Planning Analyst produces an error when launching.
|
Articles | 28 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Content Store Database Growing Significantly Every Day
In this particular scenario, the administrator notices that the IBM Cognos BI Content Store is growing in size significantly day after day in a way that he cannot explain.
|
Articles | 28 Mar 2012 |
| Configure a complex cloud app test system
Cloud applications continue to grow more complex, making the task of rapidly
delivering a cloud solution, whether it is just a production-level application or an
intricate virtual application or system pattern, more difficult. To answer this challenge, the author examines the complexity involved in attempting to establish a working, easily repeatable Collaborative Lifecycle Management system (CLM) running on a WebSphere Application Server using DB2 as the database.
Also available in:
Japanese
Portuguese
|
Articles | 22 Mar 2012 |
| System Administration Certification exam 919 for Informix 11.70
prep, Part 5: Informix backup and restore
In this tutorial, you'll learn about IBM Informix(R) database
backup and restore concepts and strategies, and you'll learn about utilities and commands
for managing your database backup and restore processes. In addition, learn
how to monitor your backups and perform problem determination when necessary.
This tutorial prepares you for Part 5 of the System Administration
Certification exam 919 for Informix v11.70.
|
Tutorial | 22 Mar 2012 |
| Dimensional modeling with IBM InfoSphere Data Architect,
Part 3: Transformations
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 an IBM
initiative to enable an integrated data management
environment throughout the entire data management life cycle.
Also available in:
Portuguese
|
Articles | 22 Mar 2012 |
| Optimizing Informix database access
Normally access to an Informix database can take from less than a second up to some expected period of time, depending on the
database operation. Sometimes it can take much longer than you expected due to many reasons, such as the network speed, system
performance, system load, and so on. In the worst scenario, the Informix client may be blocked forever for the expected server
response that never comes. This article explains how to interrupt an SQL or
connection request that is requiring more time than expected in order to improve the
performance of your Informix database application.
|
Articles | 22 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Diagnosing a Server Startup Issue with the IBM Cognos Diagnostic Tool
A client calls IBM Cognos support and indicates one of their IBM Cognos BI servers in a multi-server environment will not start. The support analysts leverages the IBM Cognos BI Diagnostic Tool to gather information to solve the case.
|
Articles | 20 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Tracking Down an Intermittent IBM Cognos Report Not Returning any Data
|
Articles | 20 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Tracking Down an IBM Cognos Content Manager Initialization Failure
This document is intended to provide a troubleshooting methodology which incorporates publically available utilities to diagnose and resolve an issue identified within a specific use case.
|
Articles | 20 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Batch Updating Image URL in Reports
In this scenario, a support analyst is asked by a customer how to easily and quickly update an image path found in several reports. This scenario is resolved by using the Dynamic Report Specification Updater Diagnostic utility.
|
Articles | 20 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Tracking Down a CSV Export Delimiter Difference Between a Development and Production System
In this scenario, a support analyst is presented with a situation where the delimiter of a Comma Separated Value (CSV) report output format is different between an IBM Cognos production and development system.
|
Articles | 20 Mar 2012 |
| IBM Cognos Diagnostics: Use Case: Tracking Down an IBM Cognos Power Cube Connection Issue
In this particular scenario, a support analyst is presented with a situation where all IBM Cognos Power cube data sources are failing after the IBM Cognos BI application was migrated from one physical server to another.
|
Articles | 20 Mar 2012 |
| Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC
In this IBM Redbooks publication, we show you examples of how InfoSphere CDC can be used to implement integrated systems, to keep those systems updated immediately as changes occur, and to use your existing infrastructure and scale up as your workload grows. InfoSphere CDC can also enhance your investment in other software, such as IBM DataStage and IBM QualityStage, IBM InfoSphere Warehouse, and IBM InfoSphere Master Data Management Server, enabling real-time and event-driven processes. Enable the integration of your critical data and make it immediately available as your business needs it.
|
Redbooks | 20 Mar 2012 |
| Introducing InfoSphere Streams 2.0 features, Part
1: Application monitoring with metrics
New to InfoSphere Streams 2.0, the introduction of the metrics component provides
runtime access to both system and user-defined statistics than can be used to monitor the inner
workings of your Streams application. This article outlines the new metrics system and describes
how to access and use both system and user-defined metrics as part of your Streams application.
Also available in:
Chinese
Portuguese
|
Articles | 15 Mar 2012 |
| Technical tip: Automate IBM InfoSphere DataStage jobs using CLI options in shell/batch scripts
IBM InfoSphere DataStage integrates data across multiple high volume data sources
and target applications. It integrates data on demand across many systems via a high performance parallel
framework, extended metadata management, and enterprise connectivity.
This technical tip introduces the dsjob command provided by IBM InfoSphere DataStage to invoke and
monitor jobs manually and shows how to use it in automation scripts. A sample automation script will
help you to use the dsjob command to run a job, view or reset job status,
stop the job, and also retrieve the log for the latest job run.
|
Tips | 15 Mar 2012 |
| Virtualizing InfoSphere Optim database tools with Citrix XenApp
XenApp Citrix is becoming a common environment for delivering virtual IBM
Eclipse-based tools, including IBM Data Studio full client for Windows, as an on-demand
service to any user, anywhere in the industry. There are a few challenges
using XenApp.
This article walks you through the common problems using XenApp, and provides solutions to overcome
those issues. It also provides step-by-step solutions for installing and using
InfoSphere Optim database tools on Citrix as client using IBM Data Studio Version 3.1 as
an example. Citrix load balancing issues are addressed, along with default Workspace usage issues and
debugging stored procedures.
|
Articles | 15 Mar 2012 |
| Use industry templates for advanced case management, Part
1: Introducing the Credit Card Dispute Management sample solution template for
IBM Case Manager
IBM Case Manager provides the platform and tools for a business analyst to define and implement a new generation of case
management solutions. To accelerate the development of solutions in particular industries, IBM Case Manager supports the notion of a
solution template, which is a collection of case management assets that can be customized and extended to build a complete solution. To
illustrate the value of solution templates and the features of IBM Case Manager, IBM has provided two sample solution templates
that can be used as learning tools for users new to the platform. This tutorial
introduces one of those templates: Credit Card
Dispute Management from the financial services industry. This sample template can serve
as a foundation for clients who want to
build a similar solution. The template can also serve as a learning tool and reference
for clients to build other solutions in other industries.
Also available in:
Spanish
|
Tutorial | 15 Mar 2012 |
| Ensuring data quality for multilingual data using IBM InfoSphere
Information Server
With ever-growing importance for data quality in growth markets, many companies have an immediate need to cleanse data
that is dirty and unstructured. However, one of the challenges during this exercise is language. Countries such as India where there are
multiple languages encounter a challenge of effectively handling linguistic data. In India, the official language of each state is
different, and data is available in both English and local languages. This article describes clearly a methodology and steps
for cleansing the multilingual data using IBM InfoSphere Information Server components,
InfoSphere DataStage and InfoSphere QualityStage.
|
Articles | 08 Mar 2012 |
| Moving a PHP application to DB2 from MySQL, Part
4: Deploy your application
Learn why you should move a PHP application to DB2(R), how to plan
the migration, how to execute it, how to support it, and how to
handle
potential risks based on the experience of an IBM Intranet
application case
study. This four-part series shares lessons from a
successful
MySQL-to-DB2
migration for a mission-critical PHP Intranet
application used by 4,000 global
users within IBM to support content
production for ibm.com. Part 4 describes the
steps taken to deploy and support the application.
Also available in:
Portuguese
|
Articles | 08 Mar 2012 |
| Migrate DB2 Net Search Extender indexes to DB2 Text Search
In order to leverage the latest capabilities in DB2 for Linux, UNIX, and
Windows for full text search, users of DB2 Net Search Extended should migrate
to DB2 Text Search. This article explains how to migrate from Net Search
Extender to DB2 Text Search indexes, and what to consider when
planning your migration.
|
Articles | 08 Mar 2012 |
| IBM Cognos Proven Practices: IBM Cognos BI - Unexpected Results When Performing Multi-Fact Queries (Stitch Queries)
This document discusses a number of issues that advanced report authors may encounter when they create reports that generate a stitch query (queries that include facts from multiple fact tables).
|
Articles | 07 Mar 2012 |
| Configure InfoSphere CDC with InfoSphere DataStage for real-time
ETL
In this article, learn to configure IBM's data replication product called IBM InfoSphere Change Data Capture (CDC)
with the extract, transform, and load (ETL) tool InfoSphere DataStage, a component of IBM InfoSphere Information
Server. Full integration of these two products makes real-time ETL possible.
|
Articles | 01 Mar 2012 |
| System Administration Certification exam 919 for Informix 11.70
prep, Part 4: Performance tuning
Tune IBM Informix(R) database server and its different subsystems
for optimum performance. After an overview, follow along with examples on
how to look at the database server and its subsystems. Learn about important database optimization
elements, including checkpoints, recovery, physical
logging, logical logging, asynchronous I/O VP, network parameters, disk
resources, CPU VP resources, PDQ, memory grant manager, scan threads,
index creation, statistics maintenance, and self tuning. Use this tutorial, the fourth in a series of
eight tutorials, to help prepare for Part 4 of the Informix 11.70 exam 919.
Also available in:
Portuguese
|
Tutorial | 01 Mar 2012 |
| DB2 Text Search, Part 4: High-availability setups with DB2 Text Search
DB2 Text Search enables creating full-text search applications in a DB2 Database for Linux, UNIX, and Windows. For
scenarios where a high availability of the full-text search applications is
required, a fail-over strategy must take into account
that a DB2 Text Search setup involves two components, the DB2 database server and the text search server. Text search index catalog
data and text search index administration data are stored in the database and included in the DB2 High Availability Disaster Recovery
(HADR) strategy. However, the text search index collections are managed by the text search server and are located on the file system.
An extension of the database HADR strategy is therefore required to include the objects managed by the text search server.
|
Articles | 01 Mar 2012 |
| Use industry templates for advanced case management, Part
2: Introducing the Auto Claims Management sample solution template for IBM
Case Manager
IBM Case Manager provides the platform and tools for the business
analyst to define and implement a new generation of case management solutions.
To accelerate the development of solutions in particular industries, IBM Case
Manager supports the notion of a solution template--a collection of case
management assets that can be customized and extended to build a complete
solution. To help illustrate the value of solution templates and the abilities
of IBM Case Manager, IBM has provided two sample solution templates that can
be used as learning tools for new users of the platform. This tutorial
introduces one of those templates--Auto Claims Management--from the insurance
services industry. Gain an understanding of what a template is, and learn
about the assets delivered in this sample template and how they were built.
(This tutorial includes the code for this sample template as well as
instructions on how to deploy it.)
Also available in:
Portuguese
|
Tutorial | 01 Mar 2012 |
| IBM Cognos Proven Practices: IBM Cognos 8 BI Dispatcher Routing Explained
A short document to explain the main concepts of IBM Cognos 8 Dispatchers when routing requests.
|
Articles | 29 Feb 2012 |
| Data.gov for government agencies
Because people are more aware of the value of open data,
entire new economies have sprung up around its use and management. In
2009, the U.S. Federal Government launched Data.gov, a site to aggregate
feeds of government data. Pressure on agencies to publish information at
Data.gov has been steady. The Open Government Directive of 2009 requires
all Federal agencies to post at least three high-value data sets online
and register them on Data.gov. Learn about Data.gov, the basic information
your agency needs to know to participate in this revolution in government,
and ideas for doing so efficiently.
Also available in:
Portuguese
|
Articles | 28 Feb 2012 |
| Evaluate: IBM InfoSphere BigInsights
IBM InfoSphere BigInsights Basic Edition is an integrated, tested and pre-configured, no-charge download for anyone who wants to experiment with Hadoop. BigInsights enables new solutions that cost effectively turn large, complex volumes of data into insight by combining Apache Hadoop, (including the MapReduce framework and the Hadoop Distributed File Systems), with unique technologies and capabilities from across IBM. Solutions developed using InfoSphere BigInsights Basic Edition can be deployed using BigInsights Enterprise Edition.
Also available in:
Chinese
Portuguese
|
Trial Downloads | 24 Feb 2012 |
| 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 | 24 Feb 2012 |
| DB2 Text Search, Part 3: What to consider when planning text index backups
IBM DB2 Text Search enables users to create
full-text search applications in a DB2 for Linux, UNIX, and
Windows database. Full-text search is fully integrated into database
query processing, but text-search indices are file system-based, and backup
requires synchronization with DB2 backup and recovery facilities. It is
necessary to combine database backups and text-search index backups to prepare
for recovery scenarios. This article provides information about how database
objects and text-search indices relate and provides recommendations for backup
and recovery procedures.
|
Articles | 23 Feb 2012 |
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.