Help-Sybase to DB2 migration

[pankaj_wolfhunter]

Greetings,
Sybase authentication is managed by the database
manager
whereas DB2 relies on OS userid and password.
when we migrate from sybase, there are certain applications that are
using userid and password stored in sybase system tables. of course
these are not OS based userid/password.

now when we migrate to DB2 it checks for these userid/passwords as OS
related. but these are stored in Sybase system tables.
how should we overcome this problem when we migrate to DB2.
do we have to remove the user/password out of the code?

Any help would be appreciated

TIA

[Bernd Hohmann]

pa***************@yahoo.co.in wrote:

now when we migrate to DB2 it checks for these userid/passwords as OS
related. but these are stored in Sybase system tables.
how should we overcome this problem when we migrate to DB2.
do we have to remove the user/password out of the code?

The easiest way is to create all users in the operating system and read
the users with the user privileges from the DB2 system tables.

For JDBC sessions its enough to create one user for DB2 and manage the
application users by yourself.

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin

[pankaj_wolfhunter]

thanx