Use a disaster recovery scenario and the included sample scripts with Q Replication to set up schema-level subscriptions to maintain and manage data replication for your database system. More >
Tabs showing featured content, developer and DBA links, and key topics
- Online DB2 for z/OS migration
Get hints and tips to make your online migration successful. Discover how the DB2 migration process has been designed specifically to allow the business application set to continue to run while you migrate.
- Integrating InfoSphere Streams 3.0 applications with
InfoSphere Information Server 9.1 DataStage jobs, Part
Get the technical details for creating an end-to-end integration scenario between InfoSphere Streams applications and DataStage jobs, including exporting modified Streams application metadata and importing into the Information Server environment.
- Optim Query Tuner: Capture and tune DB2 z/OS SQL
statements using a user-defined SQL repository
Create query workloads directly from your own SQL repository, without the overhead of archiving or staging your workload data. Leverage the Query Tuner user interface to define dynamic and static SQL statement filters, and tune the saved workload without implementing your own client.
- DB2 10: Run Oracle applications on DB2 10 for Linux,
UNIX, and Windows
Get the latest DB2 10.5 capabilities in this article update, including a high-level overview of what Oracle compatibility means in DB2, and whether to switch your custom application to DB2 or extend your DBMS vendor support to DB2.
- Modeling created global temporary tables for DB2 with
InfoSphere Data Architect 8.5, Part 2: Modifying an
existing data model
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.
- Get the most out of DB2 optimizer: Leveraging
statistical views to improve query execution
Leverage statistical views to provide DB2 optimizer with information to accurately model complex relationships to choose an optimal query access plan. Use examples to identify complex relationships and create statistical views to compute more accurate cardinality estimates.
- Restrict database connections using the CONNECT_PROC
database configuration parameter in DB2
Protect data access using this simple technique that allows end users in DB2 for Linux, UNIX, and Windows to connect to the database only from a specific set of hosts or IP addresses. This article gives a practical example.
- Integrate PureData system for Analytics and InfoSphere
BigInsights for email analysis
Use BigInsights to store and analyze text files, and PureData System for Analytics as a warehouse and base platform for running Cognos BI reports. The authors use an email analysis example, storing and analyzing email data in BigInsights and the structured employee data in PureData System for Analytics.
- What's new in DB2 10.5 for Linux, UNIX, and
Get the key features and enhancements in IBM DB2 10.5 for Linux, UNIX, and Windows releasing in June. The new features address business needs like cost reduction, application performance, productivity, and reliability.
Recognizing developerWorks Contributing Author: Martin
Martin Oberhofer joined IBM at the IBM Silicon Valley Lab at the beginning of 2002 as a software engineer. In an architect role for Enterprise Information Integration and Master Data Management, he works with large enterprises around the globe, solving information-intensive business problems. His special area of expertise is to create information-centric solutions in SAP application environments. Martin has co-authored several books and has written or co-authored many articles and tutorials for developerWorks.
See all of Martin's developerWorks content.
See Martin's developerWorks profile.