问题一:SQL1047N The application is already connected to another database.
db2 => create database smart_crud
SQL1001N "smart_crud" is not a valid database name. SQLSTATE=2E000
db2 => create database smartcru (MB的,db2数据库名的长度只能是8位?)
SQL1047N The application is already connected to another database.
db2 => connect reset
DB20000I The SQL command completed successfully.
db2 => create database smartcru
DB20000I The CREATE DATABASE command completed successfully.
问题二:数据库的大小
db2 "CALL GET_DBSIZE_INFO(?, ?, ?, -1)"
问题三:
Application code page not determined, using ANSI codepage 1208
Error opening list file. Terminating …
**Error occured while opening a file.
1,db2 变量查看
db2set -all
(connect to dbanme ) get db cfg
db2pd -osinfo
2、db2c变量的设置用命令
db2set 变量=value
可以参考一下:
客户端:
db2codepage=1386(简体中文)
db2country=86(中国)
db2comm=tcpip
服务器端:
db2codepage=1386(简体中文)
db2country=86(中国)
db2comm=tcpip
一定要把缺省的db2codepage=819改为数据库的代码页设置
DB2 CODEPAGE --代码页查询列表
Try the following:
export DB2CODEPAGE=819
do the export
on the other mashine do export DB2CODEPAGE=819
do the import
export and import utilities use the codepage that is set on the client
machine.
(我直接改的客户端1208,你懂的)
db2的用户对于当前文件夹没有写权限,使用chown改变owner或者chmod改变权限。
chown db2inst1:db2iadm1 $directory_name -R
chown db2inst1:db2iadm1 $directory_name -R