db2 SQL1032N 错误,请求高手帮助

本人从来没用过db2 这次开发要求用db2数据库 ,刚好有个机器装了db2,就想简单操练下,执行个简单的建表语句,机器是linux主机结果就出了这个SQL1032N错误,查了网上的相关资料,说执行db2start就可以了,结果执行这个命令还是这个错误,请高手指点下如何处理,或者从什么方面着手查找原因...显示全部


本人从来没用过db2 这次开发要求用db2数据库 ,刚好有个机器装了db2,就想简单操练下,执行个简单的建表语句,机器是linux主机结果就出了这个SQL1032N错误,查了网上的相关资料,说执行db2start就可以了,结果执行这个命令还是这个错误,请高手指点下如何处理,或者从什么方面着手查找原因,严重谢谢!!补充一下,由于是服务器,我是通过ssh连接上去的,所以不能开图形界面,只能命令行操作

[db2inst1@xdnode3 ~]$ db2
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 ADCL 9.1.3
You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd
For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG          for help on all of the CATALOG commands.
To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
For more detailed help, refer to the Online Reference Manual.
db2 => CREATE DATABASE zxgtest
SQL1032N  No start database manager command was issued.  SQLSTATE=57019
db2 => db2start
SQL1032N  No start database manager command was issued.  SQLSTATE=57019
db2 => db2stop force
SQL6033W  Stop command processing was attempted on "1" node(s).  "0" node(s)
were successfully stopped.  "0" node(s) were already stopped.  "0" node(s)
could not be stopped.
db2 => db2start
SQL1032N  No start database manager command was issued.  SQLSTATE=57019
db2 =>
收起
参与26

查看其它 23 个回答daijiangbo的回答

daijiangbodaijiangbo项目经理山东众阳软件有限公司
db2admin start 在执行db2start
软件开发 · 2010-09-20
浏览1252

回答者

daijiangbo
项目经理山东众阳软件有限公司
擅长领域: AIX服务器Unix

daijiangbo 最近回答过的问题

回答状态

  • 发布时间:2010-09-20
  • 关注会员:1 人
  • 回答浏览:1252
  • X社区推广