Linux下DB2的问题总结

  1. 使用db2cc命令启动db2 control center时出现 – Error: Can’t connect to X11 window server using ‘0.0’ as the value of the DISPLAY
  2. 解决方法:

    1
    2
    - su root
    - xhost +

    关于xhost: http://linux.about.com/library/cmd/blcmdl_xhost.htm

  3. 使用control center操控数据库时抛出SQL4414N错误
  4. 解决方法:

    1
    2
    - su dasusr1
    - db2admin start

  5. 在用db2move导出数据库时出现如下的错误
    Application code page not determined, using ANSI codepage 1208
    Error opening list file. Terminating …
    **Error occured while opening a file.
  6. 解决方法:
    db2的用户对于当前文件夹没有写权限,使用chown改变owner或者chmod改变权限。

    1
    chown db2inst1:db2iadm1 $directory_name -R

  7. 如何卸载db2
    1. 删除所有关联的instance
    2. $DB2DIR/instance/db2idrop InstName

    3. 删除db2
    4. $DB2DIR/install/db2_deinstall -a

  8. $DB2DIR的include目录下为何只有一个asn.h
  9. 原因是在安装db2的时候,可能选用了typical模式,则不会安装这些头文件。使用custom 模式,并在select features to install中选中SDK

  10. 如何查看db2的版本
  11. db2level

    This entry was written by Benny Chen , posted on Monday May 03 2010at 06:05 pm , filed under DB2 and tagged , . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

    One Response to “Linux下DB2的问题总结”

    • links says:

      13000K FF14 Gil in amfrit [US/NA Server] Sold, Customer Left the Review: I have placed my order on your site many times. The delivery is very fast and the gil is really cheap. I will definitely recommend your site to my friends. Thanks again.

    Leave a Reply

    XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>