APAR status
Closed as suggestion for future release.
Error description
When you connect to an Informix instance with a mapped user that has a non-OS surrogate ID an explain file will be written to the directory $INFORMIXDIR/users/server_SERVERNUM/uid_UID USERNAME_sqexplain.out (if no location for it is specified). The SERVERNUM will be the servernum of the instance, the UID the uid of the mapped user and the USERNAME the name of the mapped user. From the documentation you would expect to find the debug file in the same directory with the user name of the mapped user pre-pended to it. As example if you would name the debug file "mydebug.out" then you would expect it to be written to $INFORMIXDIR/users/server_SERVERNUM/uid_UID/USERNAME_mydebug.out . However, currently it will be written to $INFORMIXDIR/users/server_SERVERNUM/uid_UID/mydebug.out. If several mapped users would run an SPL with active tracing then all would use the same file. If the debug file is having a relative pathname it would not be the filename we would expect. For a non-mapped user the relative path would turn out to be starting with the user's home directory. In this case the debug files for different users would be in different locations and hence different files. One could circumvent this to a degree by adding HOME 'MAPPED_USER_HOME_DIRECTORY' to the user creation, but this would mean additional administrative overhead and the create user statement would then have to include the UID/USER and GROUP properties as well (just trying to specify HOME in the PROPERTIES of CREATE USER would result in a syntax error).
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
version 12.10.xC6 will have this fix for mapped users.
APAR Information
APAR number
IC99525
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED SUG
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-02-20
Closed date
2015-12-30
Last modified date
2024-09-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 September 2024