Correct Solution for incompatible DB2 code pages

Source: Internet
Author: User
Tags db2 connect db2 connect command db2 connect to

This article mainly describes the correct solution to the incompatibility of the DB2 code page. If you are interested in the correct solution to the incompatibility of the DB2 code page, you can click to view the following articles. The following is a detailed description of the relevant content.

When a command is issued: DB2 connect to db_name, the system returns SQL0332N There is no available conversion for the source code page "819" to the target code page "1386 ". reason Code "1 ". SQLSTATE = 57017

For example:

When the command: DB2 connect to db_name is issued, the system returns

 
 
  1. SQL0332N There is no available conversion for the source code page "819" to the target code page "1386". Reason Code "1". SQLSTATE=57017 

DB2 requires that the source code page and the target code page be compatible with each other. In the preceding example, the database connection fails because the source code page is 819 incompatible with the target code page 1386.

The solution is as follows:

On the machine that fails to issue the db2 connect command, execute the following command in the DB2 command window and re-connect:

 
 
  1. -> 
  2. db2set db2codepage=1386 –I instance_name  
  3. db2 terminate  

The above content is a description of the solution to the incompatibility of the DB2 code page. I hope it will help you in this regard.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.