Установка и настройка DB2 под Windows для работы с 1С:Предприятием 8.1

Краткое содержание:

Установка и настройка DB2 под Windows для работы с 1С:Предприятием 8.1 Начните установку с запуска файла setup.exe. В открывшейся панели запуска установки DB2 перейдите на закладку «Установить продукт» и для установки DB2 нажмите «Установить новый».

В открывшейся панели запуска установки DB 2 перейдите на закладку «Установить продукт» и для установки DB 2 нажмите «Установить новый».

Дождитесь появления приглашающего окна мастера установки и нажмите «далее».

Далее необходимо принять лицензионное соглашение.

Выбирайте пользовательский тип установки для управления устанавливаемыми компонентами. У Вас будет возможность убедиться, что процесс установки прост.

Уточните, что вы выполняете только установку.

Если вы сомневаетесь, какие компоненты надо установить, то можно установить все компоненты. Но основными для работы 1С:Предприятие будут разделы «поддержка сервера» и «поддержка клиента».

Следует отметить, что имеется возможность выбора одного или нескольких языков пользовательских интерфейсов.

Имя экземпляра DB 2 оставьте по умолчанию.

Далее укажите использование справки по DB 2 на сайте IBM .

Укажите учетную запись Windows , которая будет использована для службы DB 2.

Параметры подключения можно оставить по умолчанию.

Включите пункт «подготовка каталога инструментов DB 2».

Администрирование уведомлений по почте можно отложить «на потом».

Для защиты от несанкционированного доступа включайте защиту данных средствами операционной системы.

Следующее окно показывает выбранные настройки и кнопка «Установить» выполняет установку DB 2.

Завершение установки обозначается соответствующим диалоговым окном.

Первым делом после установки сконфигурируйте параметр DB 2_ WORKLOAD .

Для этого откройте Пуск-Все программы- IBM DB 2- DB 2 COPY 1(по умолчанию)-Инструменты командной строки- командное окно.

Выполните следующие команды:

db 2 stop
db 2 set DB 2_ WORKLOAD =1 C
db 2 start

Чтобы корректно отображался русский шрифт, используйте шрифты как на рисунке.

Учтите, что если кластер серверов не расположен на сервере СУБД, то на нем также должна быть установлена клиентская часть СУБД. Если вы забудете это сделать, то при работе с 1С:Предприятия 8.1 c IBM DB2 может возникать ошибка.

Необходимо разместить учетную запись USR 1 CV 8 в группе DB 2 ADMINS .

При создании информационной базы в 1С:Предприятие 8.1 необходимо выбрать в качестве типа СУБД — IBM DB2.

Имя базы данных в IBM DB2 должно содержать только английские буквы и цифры и не должно быть длиннее 8 символов.

В качестве имени сервера баз данных необходимо указать имя компьютера, а если на нем имеются экземпляры сервера баз данных, отличные от установленного по умолчанию, то и имя установленного экземпляра IBM DB2, заданное при его установке через «/». Например, computer/db2name.

Не используйте IP -адресацию для сервера СУБД IBM DB2.

Длина имени пользователя базы данных не должна превышать 8 символов.

В остальном, администрирование работы 1С:Предприятия 8.1 с IBM DB2 не отличается от работы с другими СУБД.

DB2 Version 10.5 Fix Pack 10 for Linux, UNIX, and Windows

Download

Abstract

Contains links to download DB2 10.5 Fix Pack 10, servers, extenders, clients and drivers from Fix Central for Linux, Unix and Windows

Download Description

Signature: 10.5.0.10	Build level: s180615	Release Date: 10.Jul.2018

Download fix pack images per operating system

• AIX 64-bit on Power System

AIX
(10.5.0.10, AIX 64-bit, pSeries)
PTF IP24050
Download FP10 for AIX from Fix Central.

HP-UX
(10.5.0.10, HPUX 64-bit, IA64) Integrity Series systems
PTF IP24051
Download FP10 for HP-UX from Fix Central.

View all Fix Pack 10, DB2 fix packs for HP-UX in Fix Central View all Fix Pack 10, Client & Driver fix packs for HP-UX in Fix Central
Fix Pack description information.
Servers
DB2 Universal Fix Pack DB2 Server Fix Pack

Linux 32-bit
(10.5.0.10, Linux 32-bit,x86)
PTF IP24054
Download FP10 for Linux from Fix Central.

Linux 64-bit
(10.5.0.10, Linux 64-bit,x86-64) on AMD64 and Intel EM64T
PTF IP24053
Download FP10 for Linux 64-bit from Fix Central.

Linux 64-bit
(10.5.0.10, Linux 64-bit,pSeries) POWER® (IBM® eServer™ OpenPower®, System i® or pSeries® systems that support Linux)
PTF IP24055
Download FP10 for Linux 64-bit from Fix Central.

Linux 64-bit
(10.5.0.10, Linux 64-bit,zSeries) eServer System z® or System z9®
PTF IP24052
Download FP10 for Linux 64-bit from Fix Central.

Solaris 64-bit
(10.5.0.10, Solaris 64-bit,SPARC)
PTF IP24059
Download FP10 for Solaris 64-bit from Fix Central.

Solaris 64-bit
(10.5.0.10, Solaris 64-bit,x86)
PTF IP24060
Download FP10 for Solaris 64-bit from Fix Central.

Windows 32-bit
(10.5.1000.898 Windows 32-bit, x86)
PTF IP24057
Download FP10 for Windows 32-bit from Fix Central.

Windows 64-bit
(10.5.1000.898 Windows 64-bit, x86)
PTF IP24058
Download FP10 for Windows 64-bit from Fix Central.

Linux 64-bit
(10.5.0.10, Linux 64-bit, little endian pSeries) POWER® (Linux 64-bit, POWER™ little endian on Power System)
PTF IP24056
Download FP10 for Linux 64-bit from Fix Central.

Inspur K-UX
(10.5.0.10, Inspur K-UX)
PTF IP24061
Download FP10 for Inspur Itanium K1 running Inspur K-UX from Fix Central.

Installation Instructions

Download Package

Download other DB2 fix packs using the DB2 Fix Packs page.
Download the Clients and Drivers using the IBM Data Server Client Packages page.

Technical Support

In the United States and Canada dial 1-800-IBM-SERV
View support contacts for other countries
Open a Service Request with DB2 Technical Support

DB2 ODBC CLI driver Download and Installation information

Preventive Service Planning

Abstract

This document contains information about the stand alone IBM Data server driver for ODBC and CLI Versions 9.1, 9.5, 9.7, 10.1, 10.5 and 11.1. Briefly described below are the following topics: Overview, License, Download, Installation, and Related Information.

Content

Overview

What is it?
Starting from DB2 Version 9.1, there is a separate stand alone CLI and ODBC driver called the IBM® Data Server Driver for ODBC and CLI. This driver is installed and configured separately and supports a subset of the functionality of the IBM® Data Server Clients. It Provides runtime support for applications using CLI APIs, or ODBC APIs without the need of installing the Data Server Client or the Data Server Runtime Client. This driver is available only as a compressed file, not as an installable image. Messages are reported only in English.

The IBM Data Server Driver for ODBC and CLI provides runtime support for:

• the DB2® CLI application programming interface (API)
• the ODBC API
• the XA API
• database connectivity
• the DB2 Interactive Call Level Interface (db2cli)
• LDAP support (but LDAP cache is not saved to disk)
• tracing, logging, and diagnostic support.

Who Uses it?
The IBM Data Server Driver for ODBC and CLI is a lightweight deployment solution designed for independent software vendors (ISV) deployments.

Why use it?

• The driver has a much smaller footprint than the IBM Data Server Client and the IBM Data Server Runtime Client.
• You can have multiple installations of the driver on a single machine.
• You can install the driver on a machine that already has an IBM Data Server Client installed.
• You can include the driver in your database application installation package, and redistribute the driver with your applications. Under certain conditions, you can redistribute the driver with your database applications royalty-free.
• The driver can reside on an NFS mounted file system.

When was it introduced?
The ODBC CLI driver is available starting from DB2 version 9.1.

License

The IBM Data Server Driver for ODBC and CLI can be used to connect only to one of the following properly licensed servers:

• DB2® Database for Linux®, UNIX®, and Windows®
• DB2® Connect™ Server
• InfoSphere™ Federation Server
• IBM Informix® Dynamic Server
• DB2 for z/OS®
• DB2 for IBM i
• DB2 Server for VM and VSE

The IBM Data Server Driver for ODBC and CLI can be used to connect to DB2 for z/OS, DB2 for IBM i, and DB2 Server for VM and VSE servers only if:

• a connection is established through a properly licensed DB2 Connect server; or
• a properly formatted authentic DB2 Connect license file is present for directly connecting to the server. The license file is distributed as part of the DB2 Connect products, so the only way to obtain this license key file is to purchase one of the following DB2 Connect products:
  • DB2 Connect Personal Edition
  • DB2 Connect Enterprise Edition
  • DB2 Connect Application Server Edition
  • DB2 Connect Unlimited Edition for System z®
  • DB2 Connect Unlimited Edition for System i®

  The relevant license file can be located on the DB2 Connect install image in the /db2/license directory

Download

To install the IBM Data Server Driver for ODBC and CLI, you need to obtain the compressed file that contains the driver. It is available to download from the internet, and it is on the DB2® Version 9 install CD.

You can obtain the IBM Data Server Driver for ODBC and CLI by doing either of the following:

• Go to the IBM Support Fix Central Web site: http://www.ibm.com/support/fixcentral/. Data Server client and driver packages are found under the Information Management Product Group and IBM Data Server Client Packages Product selection. Select the appropriate Installed Version and Platform and click Continue. Check the Browse for fixes radio button and click continue. You will be presented with a list of all client and driver packages available for your platform, including IBM Data Server Driver for ODBC and CLI.

or

• Copy the driver from the DB2 install CD.

or

• You can also download from Fix Packs by version for IBM Data Server Client Packages. Select the Fix pack under the version column, then select the platform/OS from IBM Data Server Driver for ODBC and CLI product section. From the available downloads, select the appropriate driver. Then check the needed fix packs and click continue and download using any method of your choice. If the needed fix pack is not available in the above link then you could obtain it from http://www-01.ibm.com/support/docview.wss?uid=swg27016878
  by following the same steps as described above.

The driver is also available to download at :
IBM Data Server Client Packages (10.5.*, All platforms)
IBM Data Server Client Packages (10.1.*, All platforms)
IBM Data Server Client Packages (9.7.*, All platforms)
IBM Data Server Client Packages (9.5.*, All platforms)

The driver is in a compressed file called “ibm_data_server_driver_for_odbc_cli.zip” on Windows® operating systems, and “ibm_data_server_driver_for_odbc_cli.tar.Z” on other operating systems.

Installation

There is no installation program for the stand alone IBM Data Server Driver for ODBC and CLI. You must install the driver manually:

1. Copy the compressed file that contains the driver onto the target machine from the internet or a DB2 Version 9 installation CD.
2. Uncompress that file into your chosen install directory on the target machine.
3. Optional: remove the compressed file.

If you are installing the IBM Data Server Driver for ODBC and CLI under the following conditions:

• the operating systems on the target machine is AIX®; and
• the DB2 Version 9 CD is mounted on the target machine.

the steps you would follow are:

1. Create the directory $HOME/db2_cli_odbc_driver, where you will install the driver.
2. Locate the compressed file ibm_data_server_driver_for_odbc_cli.tar.Z on the install CD.
3. Copy the tar file ibm_data_server_driver_for_odbc_cli.tar.Z to the install directory, $HOME/db2cli_odbc_driver.
4. Uncompress ibm_data_server_driver_for_odbc_cli.tar.Z:

• cd $HOME/db2_cli_odbc_driver
• tar -xvf ibm_data_server_driver_for_odbc_cli.tar

1. Delete ibm_data_server_driver_for_odbc_cli.tar.Z.
2. Ensure the following if you installed the driver on a NFS file system:
3. On UNIX® or Linux® platforms the db2dump and the db2 directory need to be writable. Alternatively, the path you have referenced in the diagpath parameter must be writable.
4. If host or i5/OS® data servers are being accessed directly ensure the license directory is writable.

If you are installing the IBM Data Server Driver for ODBC and CLI on Windows Platform, then you could copy the compressed folder under C:\Program Files\IBM and uncompress it. If you want to register the newly installed driver into the ODBC Administrator tool, then run the exe db2cli.exe located under the bin directory of the uncompressed driver(e.g: /bin/db2cli.exe) from the Admin Command Prompt (right click on the command prompt and choose «Run as administrator») as:

cd /bin
db2cli install -setup

( Note: If you are installing the IBM Data Server Driver for ODBC and CLI version 9.7 GA, FP1, FP2 or FP3 then use ‘db2oreg1.exe’ instead: db2oreg1 -i

After the above command is run to complete, you could see the driver registered in the ODBC Data source Administrator’s Driver panel.

If you are installing 32-bit ODBC Driver on 64-bit Windows Operating System then you might hit the error «Data source name not found and no default driver specified«.
Please follow the guidelines from the below link to resolve the issue:
Pointing to 32 bit ODBC driver on 64 bit Microsoft system