fateame 发表于 2016-11-15 08:51:35

DB2 V9.7 SQL10007N错误解决。

  redhat Linux Enterprice Edtion x86-32bit环境下的DB2 V9.7 express-c在运行启动过程中报错:
  -sh-3.1$ ./db2start
SQL10007N Message "-1390" could not be retrieved. Reason code: "3".
  经过分析,是shell文件配置项有问题,没有export环境变量导致。使用了不正确的shell。解决办法如下:
  sudo usermod -s /bin/bash db2inst1

sudo gedit /home/db2inst1/.profile

添加以下内容

export PATH=$PATH:/home/db2inst1/sqllib/adm:/home/db2inst1/bin

重新尝试以db2inst1用户登录,发现shell已经变了。try!:

$ db2start
SQL1026N The database manager is already active.
$ db2stop
SQL1064N DB2STOP processing was successful.
$
页: [1]
查看完整版本: DB2 V9.7 SQL10007N错误解决。