SQL1224N ... SQLSTATE=55032-worknotes
问题 一 tcp 1 在db2cmd中执行db2 get dbm cfg |find "SVCENAME"没有设定
#设定
$ db2 update dbm cfg using SVCENAME db2inst
#用命令查看
$ db2set -all
问题 二
db2 => connect to platform
SQL1224NThe database manager is not able to accept new requests, has
terminated all requests in progress, or has terminated the specified request
because of an error or a forced interrupt.SQLSTATE=55032
从新建实例
1 删除现有实例
#停掉实例
$ db2stop
#使用root用户登录,进入到DB2安装目录
# pwd
/opt/ibm/db2/V10.1/instance
#执行db2idrop命令删除
# ./db2ilist
db2inst
# ./db2idrop -f db2inst
DBI1006IAn invalid argument was entered for the db2idrop command.
Explanation:
The syntax for the db2idrop command is:
db2idrop [-h|-?]
[-d]
[-g]
[-f]
InstName
Valid arguments for this command are:
-h|-?
Display the usage information.
-d
Turn debug mode on.
-g
This parameter is required when db2idrop is used with a DB2
pureScale instance. Specifies that you want to drop the DB2
pureScale instance on all hosts. This parameter requires all
DB2 members and all cluster caching facilities (CFs) are
stopped on all the hosts in the DB2 pureScale instance.
-f
This parameter is deprecated. This parameter flags
applications. If this flag is specified all applications using
the instance will be forced to terminate. This parameter is not
supported on a DB2 pureScale environment.
InstName
Specifies the name of the instance.
User response:
Enter the command again using valid parameters.
> db2idrop - Remove instance command
换个思路,不删除实例,改配置
db2 update dbm cfg using SVCENAME db2c_db2inst
vi services
不是这个问题
ok 解决了,在本机建数据库,不用catalog
db2 "CREATE DB platform using codeset UTF-8 territory us COLLATE USING UCA400_NO PAGESIZE 32768"
总结:
DB2安装
1, 修改服务器设置
$ db2set -all
DB2COMM=TCPIP
DB2AUTOSTART=YES
DB2SYSTEM=dnode
DB2INSTDEF=db2inst
2,在客户端建立服务器端数据库的节点
Db2 catalog tcpip node test remote host/ip server 50000
注:test为在客户端定义的节点,名字可以任意
查找/设置服务器端DB2使用的端口,
如果服务器端为linux,可以访问/etc/services文件,如果你的实例名为db2inst1,找到如下行
db2inst1 50000/tcp
3, 在db2cmd中执行db2 get dbm cfg |find "SVCENAME"
没有设定
#设定
$ db2 update dbm cfg using SVCENAME db2inst
#用命令查看
$ db2set -all
catalog 节点
页:
[1]