Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Not under consideration
Workspace Db2 for z/OS
Created by Guest
Created on Mar 6, 2017

DSNRXXXX tables userID case sensitive problem

Hello,
This enhancement request is referenced to PMR 17878,001,862 . Please review PMR 17878,001,862 .

We are using db2 10 for z/OS and external security -RACF- on this system .
DB2 user's distributed connection type is JDBC / ODBC.
They reach db2 from a lot of different product platforms using JDBC/ ODBC connection profiles.
But how do users write their userids, racf allows them to login DB2 and submit queries.
It does not matter how userids is written upper/lower(except password) .

Our main purpose is only to restrict user_ids on our hand with a
specific asu_time(for example 1000) value not to kill their connections.
Yet we are trying different cases to be sure whether using true
parameter on RLMT table. Then we try Asu time :0

The following sql was run :
----------------------------------
DELETE FROM SYSIBM.DSNRLMT01; -- All the table content were delete.
INSERT INTO SYSIBM.DSNRLMT01 -- Just only one test userid was add
into the table.
(RLFFUNC,RLFEUAN,RLFEUID,RLFEUWN,RLFIP,ASUTIME, --ASUTIME was given zero
RLFASUERR,RLFASUWARN,RLF_CATEGORY_B)
VALUES('8',' ','B1UESYP','',' ',0,NULL,NULL,' '); -- User id was typed
upper case into the table.
SELECT RLFFUNC,RLFEUID,ASUTIME
FROM SYSIBM.DSNRLMT01;

B1UESYP tried to work a query using distributed connection for
us;

If test user type the userid with low letter,'b1uesyp', on connection
profile to distributed environment
we are getting her connection information as the following :

Workstation Workstation
Workstation LUW Client
User ID Transaction Name Name
Token /Product
------------------------------------------------------------------------
----------------
b1uesyp db2jcc_application 10.24.xxx.
xxx 1330 JCC

And if send the query on the system , test user can get the result
set normally.

But if type using upper letter as it is written into the DSNRLMT01
table ,'B1UESYP', the user can not get any result set .
The user met -905 error as we expected.


"RLF searches RLF tables based on DB2's string evaluation, which is case
sensitive. If customer is using the same string value but with the
different lower/upper case value, and they need to apply the same rule
for RLF function, they can have two or multiple rows with different case
values in the RLF tables."

May be this is a code defect on DB2 ,what do you think about these ?

How can we manage to control all of the users connected to the system
though case sensitive function of DSNRLMT01 and case sensitive DB2's string evaluation?
Because these users can type their user id 's very different possible
forms and connect on system.
for example : EliF/elif/ELIF/ eliF/.... Probability calculation is
required for all users . it is impossible. :)

We decided to need an enhencement about this issue.
Best regards.
Elif .
  • Admin
    Janet Figone
    Reply
    |
    Feb 13, 2020

    Will Not Implement. Db2 table is case sensitive. We also do not think we should fold the client info because it's just a string passed to Db2.