IBM DB2 database user experience

Source: Internet
Author: User
Tags db2 client db2 odbc driver dsn ibm db2 ibm db2 database ibm db2 odbc driver sql server query

Padding-left: 3px; padding-Right: 5px; "class =" noprint ">

1. When the DB2 client opens the control center, an error occurs: [IBM] [JDBC driver] cli0622e accessing the JDBC management service extension.
Solution: Enter the DB2 command window and enter db2cc 6789.
--------------------------
2. DB2 client garbled characters in the XP System
Solution: C: \ Program Files \ sqllib \ Java \ java12 \ JDK \ JRE \ Lib \ font. properties. ZH
Change filename. \ u5b8b \ u4f53 = simsun. TTF to filename. \ u5b8b \ u4f53 = simsun. TTC
--------------------------------------------------------
3. Implementation of connecting SQL Server to DB2 Server

The interconnection of different database platforms is generally called the heterogeneous service of databases. Currently, all major databases can achieve such Heterogeneous Interconnection, but the specific implementation technologies of different vendors are different, such: in SQL server, it is called linked server, and ODBC is used to interconnect with other databases.
 
The test environment in this article is:

Operating System: Windows2000 Server (Traditional Chinese System)

Install the database: sqlserver2000 (English version) and DB2 7.2 client (English version)

Specific steps:
1. Install the DB2 client software and sqlserver2000 software on the PC.
2. Configure the ODBC data source for Windows:
Choose "start"> "program set"> "System Management Tools"> "Data Source"> "ODBC" to configure the user DSN or system DSN: add-select IBM DB2 ODBC driver-> Custom Data Source Name (for example, db2test)-> Database Name (required !) -"OK.

3. Select the name of the data source you Just configured, and then select Configuration to jump out of DB2 messages:

The data source is not connected. Connecting to the data source will provide useful information during configuration. wocould you like to connect to the data source?

Select Yes (OK or OK ).

Go to the connect to DB2 database screen:

User ID: user who entered the DB2 database

Password: enter the password of the DB2 database user.

Connection Mode: You can select the default share mode.

Select OK!

ODBC configuration and test completed!

4. Configure the connection server in sqlserver2000:
Enterprise Manager-security-connection server-right-click Create connection server-define the connection name; select another data source; SpecifyProgramThe name is ibm ole db provider for DB2 servers. The product name is optional. The data source specifies the name of the data source defined in ODBC. The provider string is in the following format: User ID = username; password = userpasswd (or in the following format: uid = username; Pwd = userpasswd). the user name and password here correspond to the user name and password in the DB2 database to be connected-Security Tab: set the security context and enter the database user name and password of DB2. The "server option" tab is displayed by default.

5. All preparations have been completed! In sqlserver Enterprise Manager-security-connection server open the newly established connection server-click the table, you can see all the table names owned by the DB2 database user in the right window, however, the table records cannot be viewed here. You need to use specific SQL statements in the SQL Server Query analyzer! When accessing a table, the format is [connection server name]... [DB2 user]. [Table name]. For more details, I will not go into details here.

Padding-left: 3px; padding-Right: 5px; "class =" noprint ">

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.