I have a question about how sudo works in the AIX 7.3
We are currently trying to upgrade the system.
After Installing AIX and couple other softwares, We gave it to other team to test it out.
Then, we were told that the sudo command won't work as the current environment.
I'll write the details below.
First, here are the sever's version (and Db2's version as well, since it is related to this problem).
Ⅰ.Current Server
IBM Power S922
IBM AIX Standard Edition 7.2.4
IBM Db2 Standard Edition 11.5.4.0
Sudo 1.8 31p1
Ⅱ.Upgraded Server
IBM Power S1022s
IBM AIX 7 Standard Edition 7.3.2
IBM Db2 Standard Edition 11.5.9.0
Sudo 1.9.15p5
In each envirionments, we executed the following command to connect database using sudo.
(I have to make few things(i.e. user name) vague due to security issue.)
$ . /db2/insthome/[INSTANCE]/sqllib/db2profile
Command Purpose:export db2profile settings to a current user.
Command result in
Current Server: export succeed without any errors
Upgraded Server: export succeed without any errors
sudo -u [USER] db2 connect to [DB]
Command Purpose: connect to DB as a [USER] using sudo
Command result in
Current Server: Succeed to Connect to the DB without any errors.
Upgraded Server: Succeed to Connect to the DB without any errors.
sudo -u [USER] db2 "export to /tmp/packages.txt of del select * from syscat.packages"
Command Purpose: export the table info to a txt file from the DB.
Command result in
Current Server: Succeed to Connect to the DB without any errors.
Upgraded Server: An error occured. Return with SQL1024N(A database connection does not exist).
I look up at the sudo manual and its release note, but I coudln't find anything related.
I also asked this problem to the IBM Db2 software support, and I was told that it's an already known issue.
They said that sometimes when the version of AIX(or ksh inside AIX) is different, it can affect how sudo works.
They also provide me how to avoid this happen.
I was wondering if there's a specific way(like configuring sudo setting files or other aix files) to make it work like the current envrionment.
Sorry for my poor English. Thank you.