Eric.Jones wrote:
What are the rules for the valid lifetime of this identifier? ie. when
would the same ID be
"reused" for a different client? I'm having a hard time grokking the
following statement from the infocenter:
"The value returned by this function is only unique for the period of time
during which the client can use the same value again."
Now that is a truly strange sentence. ;-)
The application ID contains the IP address of the client (or "*LOCAL" for
local connections), the instance name and the timestamp when the connection
was established. The timestamp uses only 2-digit years and no subseconds.
But if two connections from the same client come to the same instance, the
ID is made unique (I don't know exactly how).
So this will give you the amount of "uniqueness" that you get: you might
have recycled IDs after 100 years. Question is if you have to worry about
this or not.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany