ls -al /home/dmsinst1/sqllib/adm/db2start
-r-sr-sr-x 1 root dmsiadm1 93613 Jun 26 14:14 /home/dmsinst1/sqllib/adm/db2start
ls -al /home/bpminst1/sqllib/adm/db2start
-r-sr-sr-x 1 root bpmiadm1 93613 Jun 26 14:15 /home/bpminst1/sqllib/adm/db2start
groups dmsinst1
dmsinst1 : dmsiadm1
groups bpminst1
bpminst1 : bpmiadm1
따라서 다음 스크립트를 루트로 실행할 때:
#!/bin/bash
su bpminst1 -c "/home/bpminst1/sqllib/adm/db2start"
su dmsinst1 -c "/home/dmsinst1/sqllib/adm/db2start"
나는 얻다:
[root@dmsnl857-vm ~]# ./startAll.sh
SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: "BPMINST1".
06/29/2017 09:16:03 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
두 번째 명령은 분명히 오류 없이 실행됩니다.
고쳐 쓰다: 그리고set -x
[root@dmsnl857-vm ~]# ./startAll.sh
+ echo 'Starting BPM DB2 instance ... '
Starting BPM DB2 instance ...
+ su bpminst1 -c /home/bpminst1/sqllib/adm/db2start
SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: "BPMINST1".
+ echo 'Starting DMS DB2 instance ... '
Starting DMS DB2 instance ...
+ su dmsinst1 -c /home/dmsinst1/sqllib/adm/db2start
06/29/2017 09:44:13 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.