pankaj_wolfhunter@yahoo.co.in wrote:

> Thanks for the reply Serge. yes, we are trying to overcome the problem
> that we are facing when migrating
> from Sybase to DB2.
>
> I dont know about the FP cause this is what these people are using. I
> would surely recommend to go
> go for higher FP.

If you look at the information center, you will see a small "9" on the left
side for the function description. That indicates that something changed
in the description in the respective FixPak, i.e. FP9. Given the amount of
changes, one could deduct that the logic is completely new in FP9.

> I am still not able to find anything for retrieving hostid.

What is the host-id supposed to be? DB2 doesn't have the concept of
host-ids as a database server is identified by its name or IP address (in
conjunction with the port number).

> Also, is there any concept of server user id(suserid) in DB2? If yes,
> would like to know how to get this?

Again, what is a user-id supposed to be? If you don't use specific user
exits (security plugins) for authorization, DB2 falls back to authenticate
users based on the operating system. But if you have a security plugin,
the plugin could do whatever it likes to authenticate users and then there
might not even be the uids that you have in the OS. The same
considerations apply to the handling of groups (aka roles).

In short, DB2 identifies users by their name.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany