Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2794748
  • 博文数量: 423
  • 博客积分: 7770
  • 博客等级: 少将
  • 技术积分: 4766
  • 用 户 组: 普通用户
  • 注册时间: 2006-11-09 11:58
个人简介

Oracle/DB2/Postgresql/Mysql/Hadoop/Greenplum/Postgres-xl/Mongodb

文章分类

全部博文(423)

文章存档

2019年(3)

2018年(6)

2017年(27)

2016年(23)

2015年(30)

2014年(16)

2013年(31)

2012年(73)

2011年(45)

2010年(14)

2009年(30)

2008年(30)

2007年(63)

2006年(32)

分类: DB2/Informix

2011-11-15 13:27:49



[root@node3 ~]# /opt/ibm/db2/V9.7/instance/db2icrt  -a server -u db2fenc1 pts
DBI1768W  Unable to add /pts//sqllib/db2profile to the .profile file or
      /pts//sqllib/db2cshrc to the .login file of user pts.

Explanation:

DB2 has failed to modify the .profile file or the .login file of this
user. These files may not exist, or you may not have write permission to
them. Without the modification you need to set your environment manually
each time when you log in as this user to use DB2.

User response:

Respond in one of the following ways:

*  Add the profile to the .profile file
*  Add the location of db2cshrc to the .profile file


   Related information
   UNIX environment variable settings
   Setting up the application development environment (Linux and UNIX)


DBI1070I  Program db2icrt completed successfully.





[root@node3 pts]# su - pts
[pts@node3 ~]$ db2start
SQL1092N  "PTS" does not have the authority to perform the requested command or operation.
[pts@node3 ~]$





[root@node3 ~]# /opt/ibm/db2/V9.7/instance/db2idrop  -f pts
DBI1324W  Support of the -f command is deprecated. For
      more information, see the DB2 Information Center.


DBI1070I  Program db2idrop completed successfully.


[root@node3 ~]userdel pts
[root@node3 ~]useradd -d /pts/pts

[root@node3 ~]# cd /pts/
[root@node3 pts]# ll
total 16
drwx------ 2 root root 16384 Nov 15 11:13 lost+found
[root@node3 pts]# /opt/ibm/db2/V9.7/instance/db2icrt  -a server -u db2fenc1 pts
DBI1070I  Program db2icrt completed successfully.


[root@node3 pts]#
[root@node3 pts]#
[root@node3 pts]# su - pts
[pts@node3 ~]$ db2start
SQL1063N  DB2START processing was successful.
[pts@node3 ~]$
阅读(4746) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~