Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can I access table spaces from another DB2 in the same CPU?

Learn two approaches to access tables from another DB2 subsystem.

I need to access tables (only SELECT) in my production DB2 but I don't want to run long queries in it. Can I access...

tablespaces from another DB2 in the same CPU (in read only mode)?

The short answer to your question, is "no you cannot, not without some additional configuration and/or programming." The long answer to you question is that there are two ways to access tables from another DB2 subsystem. One method is to use distributed access. With distributed access you will need to code your programs to connect to the other subsystem and then access the data. Before attempting to do this, make sure you talk to your systems programmer or DBA to verify that your shop is set up to enable distributed data.

The second approach is to use DB2 data sharing. This requires a parallel sysplex and a significant amount of configuration of your system as well. So, please talk to your systems programmer or DBA to see if data sharing is a possibility. With data sharing, you will not need to code extra logic to access data across the DB2 subsystems participating in the data sharing group.

If neither of these approaches are viable at your shop, consider setting up duplicate tables on the DB2 subsystem you do have access to, and then use an extract and load process to synchronize data between the source tables and your target tables. To elegantly accomplish this, though, you might need to purchase ETL (Extract Transform Load) software - although you can set up a rudimentary version using the DB2 UNLOAD and LOAD utilities.

Good luck.

This was last published in January 2003

Dig Deeper on IBM DB2 management

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close