连接数据库xf报错:
$ db2 connect to xf user db2inst3 using db2inst3
SQL0332N Character conversion from the source code page "1392" to the target
code page "UNKNOWN" is not supported. SQLSTATE=57017
$ db2set DB2CODEPAGE=1386
$ db2set DB2TERRITORY=86
$ db2 terminate
DB20000I The TERMINATE command completed successfully.
$ db2stop
2013-06-06 12:56:59 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
$ db2start
2013-06-06 12:57:15 0 0 SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.
SQL1063N DB2START processing was successful.
$ db2 connect to xf user db2inst3 using db2inst3
Database Connection Information
Database server = DB2/LINUXX8664 9.7.7 SQL authorization ID = DB2INST3 Local database alias = XF
上述问题解决。
查看设置:
$db2 get db cfg for xf|more
$db2set -all