linux服务器中通过ODBC连接DB2数据库操作步骤:
1. Create a directory for installation of the IBM Data Server Driver for ODBC and CLI software.
mkdir $HOME/db2_cli_odbc_driver
2. Copy the IBM Data Server Driver for ODBC and CLI software (vxx_xx_odbc_cli.tar.gz) into the above directory.
cp vxx_xx_odbc_cli.tar.gz $HOME/db2_cli_odbc_driver
3. Extract IBM Data Server Driver for ODBC and CLI.
gunzip vxx_xx_odbc_cli.tar.gz
tar -xvf vxx_xx_odbc_cli.tar
4. Export the following environment variables.
export DB2_CLI_DRIVER_INSTALL_PATH=$HOME/db2_cli_odbc_driver/odbc_cli/clidriver
export LD_LIBRARY_PATH=$HOME/db2_cli_odbc_driver/odbc_cli/clidriver/lib
export LIBPATH=$HOME/db2_cli_odbc_driver/odbc_cli/clidriver/lib
export PATH=$HOME/db2_cli_odbc_driver/odbc_cli/clidriver/bin:$PATH
export PATH=$HOME/db2_cli_odbc_driver/odbc_cli/clidriver/adm:$PATH
5. To connect to DB2 for z/OS Server download the license file db2consv_t.lic and copy to the license folder.
$HOME/db2_cli_odbc_driver/odbc_cli/clidriver/license
2022-03-21 11:57:45
30.92MB
ODBC
1