All Products

Infosphere Data Replication for IMS provides data replication capabilities for IMS databases on z/OS. The architecture consists of the Replication Engine, Capture, and Apply components. The Capture component extracts data changes, the Replication Engine manages the replication process, and the Apply component applies changes to the target. It supports RACF for authentication. Key configuration parameters include source and target database...

Infosphere Discovery, developed by Exeros and later integrated into IBM's Infosphere Information Server, is designed for discovering and analyzing relationships between databases. It supports various database systems, including mainframe databases such as DB2 and IMS. The primary function is to identify data connections, potential data duplication, and sensitive data across different platforms. The architecture includes components like the Data Source...

Infosphere Guardium Central Manager and Aggregator was designed to centralize the management of Guardium collectors, providing a unified view of database activity. Key components included the Central Manager, Aggregator, and data collectors. These components communicated using proprietary protocols. The system used a relational database for storing data and generating reports. The product supported RBAC for access control and provided audit...

IBM InfoSphere Guardium Data Encryption for DB2 and IMS Databases enhances data security and compliance on z/OS. The product uses hardware-assisted AES encryption to protect sensitive data at rest within DB2 and IMS databases. Key components include the Encryption Engine, Key Manager, and Audit Logger. The product supports authentication via RACF and offers role-based access control (RBAC). Administrative interfaces include...

Infosphere Guardium Database Activity Monitor provided database activity monitoring and auditing. It captured database access by monitoring network traffic and integrating with S-TAP collectors. The main components included network sniffers, data collectors, and a central management console. The central management console was used for configuration, monitoring, and reporting. The product offered audit trails, helping organizations meet compliance requirements. It also...

InfoSphere Guardium Database Vulnerability Assessment provides automated security assessments for databases. Key components include the Guardium appliance, the central manager, and the database agents. The appliance communicates with database servers to collect data and perform scans. The central manager provides a web-based GUI for configuration, monitoring, and reporting. The product supports DB2, IMS, and VSAM data. Common operations include scheduling...

InfoSphere Information Server is a comprehensive data integration platform designed to address complex data challenges. It offers robust ETL capabilities through DataStage, enabling efficient data extraction, transformation, and loading. QualityStage provides advanced data quality features, including data profiling, cleansing, and matching. The platform supports REST and SOAP APIs for integration with other systems. Key architectural components include the Information Server...

The InfoSphere Optim Application Retirement Solution is designed to help organizations streamline their IT infrastructure by identifying and retiring obsolete applications. Key features include application analysis, data archiving, and secure data deletion. The solution uses a multi-tiered architecture with the Optim Directory, Optim Server, and Optim Client. It supports DB2 and offers Java APIs for integration. Compared to manual processes,...

IBM InfoSphere Optim Data Growth Solution is a comprehensive data archiving and management tool designed to address database growth challenges. Key components include the Optim Directory for metadata, the Optim Server for processing, and Optim Clients for user interaction. The solution supports databases such as ADABAS, Db2, and IMS. It offers a GUI and CLI for administration, with commands like...

InfoSphere Optim Data Masking Solution for DB2 was designed to mask sensitive data in Db2 databases on z/OS. The core components include the Masking Engine, Metadata Repository, and Data Connector. The Masking Engine applies masking rules defined in XML configuration files. The product supports compliance with standards like PCI DSS. Key commands include `MASK`, `UNMASK`, and `DEFINE`. Authentication relies on...

Infosphere Optim Move for DB2 is a critical tool for creating realistic test environments and managing data in Db2 databases. The product's architecture includes the Optim Move Engine, Data Masking Engine, and Metadata Repository. These components work together to facilitate data movement, masking, and subsetting. The CLI and GUI provide administrative interfaces for configuration and monitoring. Authentication is handled through...

Optim Move for IMS/VSAM/SEQ is a data management tool designed to create test data from Db2 databases for IMS, VSAM, and Sequential datasets on z/OS. It enables data extraction, transformation, and loading, supporting various data masking techniques. The tool's architecture comprises components for data extraction, transformation, and loading, which communicate through z/OS. Key commands include `EXTRACT`, `TRANSFORM`, and `LOAD`. Configuration...

pureQuery Runtime provides a robust solution for accessing databases from Java and .NET applications, particularly in environments with Db2 and Oracle databases. Key components include the pureQuery engine, which optimizes SQL queries, and the data access API. The API supports executing SQL statements and stored procedures. Configuration involves setting up data sources and defining connection properties. Monitoring and logging capabilities...

The Infosphere Optim Query Tuner for DB2 was a tool designed to enhance the performance of SQL queries within a DB2 environment. Key features included the ability to analyze query execution plans, identify performance bottlenecks, and generate recommendations for query optimization. The tool integrated with DB2 on z/OS, providing a GUI for users to analyze and improve their SQL queries....

Infosphere Optim System Analyzer for SAP was a web-based application designed to monitor SAP ERP systems. It provided detailed insights into system performance and resource utilization. The architecture comprised data collection agents and a central analysis engine. The agents gathered data from SAP systems, and the engine processed this data to generate reports and alerts. The product offered performance monitoring,...

Infosphere Optim Test Data Management Solution provides comprehensive test data management capabilities. Key components include the Optim Directory for central management, Optim Designer for defining data transformations, and Optim Data Privacy Provider for data masking. It supports various databases, including Db2, Oracle, and IMS. The solution offers data subsetting to create smaller test datasets, improving testing efficiency. Data masking features...

Infosphere Replication Server facilitated data replication between DB2 databases. The architecture comprised Capture, Apply, and Control Center components. The Capture program tracked changes in the source database, while the Apply program applied those changes to the target. The Control Center provided a GUI for configuration, monitoring, and management. Key configuration parameters included database connections, replication definitions, and subscription settings. The...

InfoSphere System z Connector for Hadoop addressed the need to access z/OS data from Hadoop environments. It enabled organizations to leverage mainframe-based data, including DB2, IMS, VSAM, and z/OS system logs, within their big data analytics initiatives. The connector's architecture involved a mainframe component for data extraction and a Hadoop component for data processing. Configuration files defined data mappings and...

Infosphere Warehouse provided a comprehensive environment for data warehousing on DB2. Key components included the SQL Warehousing Tool (SQW) for data integration and transformation, Cubing Services for building and deploying multidimensional models, an Eclipse-based design studio for model design, and a browser-based administration console for management. The product supported user authentication through DB2 and access control via DB2's security features....

InfoTrace is a tool designed to trace DB2 queries on z/OS systems, providing detailed insights into SQL statement execution. As part of the INFO-OPTIMIZER suite, it helps identify performance bottlenecks and optimize SQL code. The architecture includes components for data capture, storage (DB2 tables or sequential datasets), and analysis. Communication between components is typically through z/OS system services. Key commands...