Extract data from Excel sources in IBM InfoSphere Information Server using DataStage Java Integration Stage and Java Pack
Explore the functions of the Java Integration Stage (DataStage Connector). Use the Java Pack Stages coupled with the Java Pack API and Apache POI API to fetch Excel data into DataStage in a cost-effective way. More >
Tabs showing featured content, developer and DBA links, and key topics
- Technical tip: Maintain high availability on DB2 for
z/OS on single LPAR systems
Use a method to map your test program onto production qualifiers and retrieve data directly from production to maintain high availability during the test, development, and production cycle.
- Performance characteristics of IBM InfoSphere
Information Server 8.7 running on VMware vSphere 5.0 on
Intel Xeon Processors
Get the results of a study showing how InfoSphere DataStage performs in a virtualized environment. Learn how you can take advantage of benefits and features that come with VMFS for provisioning storage for virtualized workloads.
- Schema Replication with IBM InfoSphere Data Replication,
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.
- 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.
Recognizing developerWorks Contributing Author: Raul
Raul F. Chong is a senior DB2 Program Manager at the IBM Information Management Cloud Computing Center of Competence in Toronto. He works as a technical evangelist, delivering presentations at educational institutions and conferences around the world showing the latest features of DB2, Data Studio, and related products, and how they work on the cloud. He is also the IBM liaison to the DB2 on Campus community program, which fosters collaboration with universities, professionals, and the DB2 community in general and delivers DB2 skills to the community through books, videos, and online courses, all with help from a growing DB2 community.
See all of Raul's developerWorks content.
See Raul's developerWorks profile.