Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 11:08 on July 18, 2006


Connect the padding

Machines used in the original

Get db cfg for test1

GBK codeset database to be test1, the territory of CN.

Db2look-d-e-test1 with the database structure derived -o test1.sql

================================

Used in the new machines are creating a database language

Create db test1 on /home/path using codeset GBK torritory CN

Then

Haar -tvf test.sql create database structure, suggesting that the following errors :

-->

Used to connect test1, suggesting that the mistake

[code]SQL0332N There is no available source code page conversion for the "1114" to
The target code page "819." Reason Code "1." SQLSTATE=57017[/code]

Google had a solution as follows :

[code]db2set Db2codepage=819 -i db2inst1
Haar terminate[/code]

However, as done by, connect, it is still the same mistakes.


Alternative, it will delete test1 database with reconstruction following orders
Create db test on /home/path

Re-connect, success!

But with db2move test1 load, the problem out, it is estimated that Chinese Field, the data suggest there are hard to get.

You ask experts, what I do to resolve their problems? Thank you

Connect the padding

Check db cfg which is GBK and CN, reactivating some examples?



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com