sql1092n linux,DB2.9.7 SQL1092N

[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 ~]$

阅读(3908) | 评论(0) | 转发(0) |