加载中…
个人资料
  • 博客等级:
  • 博客积分:
  • 博客访问:
  • 关注人气:
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

SQL1611W错误

(2009-08-17 18:27:24)
标签:

sql1611w

connect

to

sample

it

分类: DB2

注意:当执行一些操作后,所有连接本地的,远程的都将断开,如果需要连接数据,必须使用db2 connect to dbname 重新连接数据库

[db2inst1@fedora ~]$ db2 force application all

DB20000I  The FORCE APPLICATION command completed successfully.

DB21024I  This command is asynchronous and may not be effective immediately.

 

[db2inst1@fedora ~]$ db2 list application

SQL1611W No data was returned by Database System Monitor.  SQLSTATE=00000

 

[db2inst1@fedora ~]$ db2 list tables

SQL1224N  A database agent could not be started to service a request, or was

terminated as a result of a database system shutdown or a force command.

SQLSTATE=55032

[db2inst1@fedora ~]$ db2 connect to sample

 

   Database Connection Information

 

 Database server        = DB2/LINUX 8.2.0

 SQL authorization ID   = DB2INST1

 Local database alias   = SAMPLE

 

[db2inst1@fedora ~]$ db2 list application

 

Auth Id  Application    Appl.      Application Id                 DB       # of

         Name           Handle                                    Name    Agents

-------- -------------- ---------- ------------------------------ -------- -----

DB2INST1 db2bp          81         *LOCAL.db2inst1.060519054347   SAMPLE   1

0

阅读 收藏 喜欢 打印举报/Report
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有