The IBM® InfoSphere® Optim™ product family of data lifecycle management tools and solutions help you design, develop, deploy, and manage database applications throughout the data lifecycle, from requirements to retirement.
In Part 2 of this article series, use InfoSphere Data Architect 8.5 to modify an existing data model to incorporate changes in requirements for the created global temporary table. More >
- Modeling created global temporary tables for DB2 with
InfoSphere Data Architect 8.5, Part 1: Getting Started
Leverage InfoSphere Data Architect to create a physical data model with CGTT (created global temporary tables) and then generate a DDL with CGTT-specific syntax that you can run on a database server.
- IBM InfoSphere Optim Test Data Management Solution, Part 3:
Masking a person's first name using a gender-specific lookup
In this third part in the series about masking sensitive data, learn how to mask a person's first name in a table using a gender-specific lookup table.
- IBM InfoSphere DataStage job validation steps using IBM
Optim Test Data Management Solution
Follow a step-by-step example on how to use DataStage to validate ETL job results when moving jobs from development to production environments.
- Use the InfoSphere Optim 9.1 Test Data Management and Data
Masking solution for Netezza Data Warehouse
Move a subset of data from a Netezza production database to a test database. Using this article, learn how to extract a subset of data, mask sensitive data, audit the masked data, and create a Netezza test database.
- Mask archived and extracted data directly into CSV, XML, and
ECM formats using InfoSphere Optim Data Masking
Increase the interoperability of your data and support data privacy and security requirements using newly supported file format types in InfoSphere Optim Data Masking Solution.
- Compare IBM's data masking solutions: InfoSphere Optim and
Learn the similarities and differences between two IBM solutions for masking and depersonalizing data while maintaining its realism, to help you choose the product that meets your needs.
- Use IBM InfoSphere Optim Query Workload Tuner 3.1.1 to tune
statements in DB2 Linux, UNIX, and Windows, and DB2 for z/OS
that reference session tables
Using example scripts, learn how to set up a database environment that lets you tune statements from an SQL script editor or from the Query Tuner Workflow Assistant.
- Optim Teradata load techniques and performance tips
Learn the fundamental load techniques for implementing InfoSphere Optim for Teradata to get the best performance optimization when managing bulk data.
- IBM InfoSphere Optim Query Capture and Replay 1.1 for Linux,
UNIX, and Windows, Part 1: Introduction to OQCR
Create a production-like data application test environment where you can test and tune changes before deploying them to ensure that you do not disrupt your production.