On Friday, 21 July 2017 12:32:02 UTC+3, Dmitry Bond. wrote:

On Friday, 12 March 2004 18:23:29 UTC+2, Sherman Lau wrote:

From the code page conversion support viewpoint, code page 1251 and code page 1252 are not compatible. 1251 is a Cyrillic code page. 1252 is a Latin 1 code page. Because a lot of meaningful characters will be lost after conversion, DB2 does not support the conversion.

Is it possible to change the 1252 (e.g. English Windows machine) to a 1251 machine? You can change it by selecting Russia in the Select System Locale in Regional Options, Control Panel, Setting.

DB2 documentation can be found in the following link: http://www-306.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main

Sherman

"Dmitry Bond" <dima_ben@mail.ru> wrote in message news:1078656659.997714@moxa.united.net.ua...

Hi All.

I'm trying to connect DB2 8.1 server remotely via DB2 7.2 Client Configuration Assistant.
But is displays the following error message:
===error===
The search for databases on the network failed.
SQL0332N There is no available conversion for the source code page "1252"
to the target code page "1251". Reason Code "3". SQLSTATE=57017
For additional information, press the help button. Correct the problem described in the help message and retry.
===error===

"get database config" (for that DB2 8.1 server) gives me the:
Database territory = US
Database code page = 1208
Database code set = UTF-8
Database country/region code = 1

on the other servers the databases with exactly the same code page

settings

(but under DB2 7.2) connected without any problems.
The documentation recommends me to read the "DB2 Connect Quick

Beginnings".

But IT IS REALLY DIFFICULT to find the "DB2 Connect Quick Beginnings" on

the

WWW.IBM.COM :-)
or somewhere also (including DB2 on-line documentation installed on my computer).

Two questions:
1) Is is possible to connect DB2 8.1 server with DB2 7.2 client? What

should

I do to achieve this?
2) Where I can found that "DB2 Connect Quick Beginnings"?

With regards,
Dmitry.

Just for a reference.

We absolutely DO NOT CARE about meaningful charcters lost!
The only thing we need is - to import data from site and reproduce the bug test case on our local VMs.
And the "meaningful charcters" do not play any role in that! We only need all other data, so - numeric values and latin names of objects. National characters in object descriptions - that is a kind of "useless data" is our case.

But the problem is - DB2 seems does not allow to impor data at all. :-(

In our case it is DB2 9.7.11.

Hm...

I just found that it is able to load data after I set

db2set DB2CODEPAGE=1208

Now data imported. It seems all is ok now.

However, it might report -956 error on a way. In such case need to issue "db2stop force" and then "db2start" commands. And then data was successfully imported, in my case.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Friday, 12 March 2004 18:23:29 UTC+2, Sherman Lau wrote:

From the code page conversion support viewpoint, code page 1251 and code
page 1252 are not compatible. 1251 is a Cyrillic code page. 1252 is a Latin
1 code page. Because a lot of meaningful characters will be lost after conversion, DB2 does not support the conversion.

Is it possible to change the 1252 (e.g. English Windows machine) to a 1251 machine? You can change it by selecting Russia in the Select System Locale
in Regional Options, Control Panel, Setting.

DB2 documentation can be found in the following link: http://www-306.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main

Sherman

"Dmitry Bond" <dima_ben@mail.ru> wrote in message news:1078656659.997714@moxa.united.net.ua...

Hi All.

I'm trying to connect DB2 8.1 server remotely via DB2 7.2 Client Configuration Assistant.
But is displays the following error message:
===error===
The search for databases on the network failed.
SQL0332N There is no available conversion for the source code page "1252" to the target code page "1251". Reason Code "3". SQLSTATE=57017
For additional information, press the help button. Correct the problem described in the help message and retry.
===error===

"get database config" (for that DB2 8.1 server) gives me the:
Database territory = US
Database code page = 1208
Database code set = UTF-8
Database country/region code = 1

on the other servers the databases with exactly the same code page

settings

(but under DB2 7.2) connected without any problems.
The documentation recommends me to read the "DB2 Connect Quick

Beginnings".

But IT IS REALLY DIFFICULT to find the "DB2 Connect Quick Beginnings" on

the

WWW.IBM.COM :-)
or somewhere also (including DB2 on-line documentation installed on my computer).

Two questions:
1) Is is possible to connect DB2 8.1 server with DB2 7.2 client? What

should

I do to achieve this?
2) Where I can found that "DB2 Connect Quick Beginnings"?

With regards,
Dmitry.

Just for a reference.

We absolutely DO NOT CARE about meaningful charcters lost!
The only thing we need is - to import data from site and reproduce the bug test case on our local VMs.
And the "meaningful charcters" do not play any role in that! We only need all other data, so - numeric values and latin names of objects. National characters in object descriptions - that is a kind of "useless data" is our case.

But the problem is - DB2 seems does not allow to impor data at all. :-(

In our case it is DB2 9.7.11.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

If your database with 1208, your Windows OS with 1251 and your data with 1252, and you IMPORT or LOAD data, try set "codepage=1252" in MODIFIED BY clause.

Another solution is .bat-file with
SET DB2CODEPAGE=1252
DB2 IMPORT ...

I think using db2set is over-measure.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)