using sudo command to connect to Db2 database in AIX 7.3

--===============6423571756198651433==
Content-Language: ja-JP
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

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 t=
o test it out.
Then, we were told that the sudo command won't work as the current environm=
ent.
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).
=1B$B-5=1B(B.Current Server
IBM Power S922
IBM AIX Standard Edition=1B$B!!=1B(B7.2.4
IBM Db2 Standard Edition 11.5.4.0
Sudo 1.8 31p1

=1B$B-6=1B(B.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 databas=
e 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 sysc=
at.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 connec=
tion does not exist).

I asked this issue to the IBM Db2 software support, and I was told that it'=
s a known issue.
They said that sometimes when the version of AIX(or ksh inside AIX) is diff=
erent, it can affect how sudo works.
They also provide me a workaround.

But the other team I mentioned earlier want to know  if there's a specific =
way(like configuring sudo's setting files or other aix files) to make it wo=
rk like the current envrionment.

Thank you,

--===============6423571756198651433==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

____________________________________________________________
sudo-users mailing list <[email protected]>
For list information, options, or to unsubscribe, visit:
https://www.sudo.ws/mailman/listinfo/sudo-users

--===============6423571756198651433==--