Questions regarding userids for those connecting from mainframe t o UDB

Lynne Flatley

Questions regarding userids for those connecting from mainframe t o UDB
Our shop is beginning to get into connecting to UDB and DataJoiner (NT)
databases from OS/390. The last place I was at we were doing the same
thing.

My question is, when going from the mainframe DB2 to the server UDB, do
other shops map/translate all outgoing IDs to a single one (via the
SYSIBM.USERNAMES) (what we've started doing here) or adding the mainframe
IDs to the server security facility (what we did at the last place)?

There are minuses to both including the storing of userids and unencrypted
passwords in a table and the dual maintenance of userids on 2 platforms.

What are other folks doing?

Thanks!

"A foolish consistency is the hobgoblin of small minds" - Ralph Waldo
Emerson

Lynne A. Flatley
New England Financial
(617) 578-4079
[login to unmask email]