DB Query Analyzer, a Chinese version of query analyzer, is a tool to access a remote DB2 database server based on Windows2000 Server operating system through a configured ODBC data source.
This article also applies to configuring remote DB2 for other operating systems on the client, such as Aix, Linux, Solaris and so on.
1. Get the DB2 port number.
First, get the port number of remote DB2 based on Winows2000 server operating system. Run the DB2 command line processor on the remote Winows host, then enter the command "DB2 get DBM CFG | find”SVCENAME, and find" SVCENAME "after execution to get the TCP/IP service name of DB2, db2c_DB2.
Click the start menu, enter "Driver" at "Run", find the subdirectory etc (c:\winnt\system32\drivers\etc in the general directory Winows2000 or C: \ Windows \ System32 \ Drivers \ etc in Win7) in the open resource manager, and you can find the file service and open it.
Find the port number 50000 corresponding to the TCP/IP service name db2c_DB2 in the file service.
2 Configure ODBC data sources on the client
Open DB2' s Configuration Assistant on the client, and then follow the steps below to build an ODBC data source.
Select the operating system of the remote DB2 database host, such as Windows, Aix, Linux or Solaris.
Finally, click the "Finish" button to complete the whole configuration work.
3 DB query analyzer accesses DB2 database through ODBC.
Ma Genfeng, a native programmer in China, introduced his personal works-general database query analyzer, Chinese version DB query analyzer and English version DB query analyzer. It has powerful functions, friendly operation interface and good operability, and spans various database platforms and even EXCEL and text files.
It can be used to query the data of ODBC data sources (including all databases, TXT/CSV files and EXCEL files in the world). You can execute multiple DML statements or even stored procedures at the same time, and the results will be returned in the form, text box and file you set. When exporting thousands of pieces of data from a database, the efficiency is the same as that of DBMS.
"Programmer" 2007 second issue "New products &; In the tool comment section, the editor "specially recommended" to publish "General Database Query Analyzer".
Download and install DB Query Analyzer, run it, and enter the established ODBC data source name "MGF_DB 1", user name and password.
Remarks:
If the previous version of Universal Database Query Analyzer is installed on your computer, please uninstall the old version before installing the new version.