Have a look at these special registers in the SQL Reference:
CLIENT ACCTNG
CLIENT APPLNAME
CLIENT USERID
CLIENT WRKSTNNAME
i.e.
"The value of the accounting string can be changed by using the Set
Client Information (sqleseti) API.
Note that the value provided via the sqleseti API is in the application
code page, and the special register value is stored in the database code
page. Depending on the data values used when setting the client
information, truncation of the data value stored in the special register
may occur during code page conversion.
Example: Get the current value of the accounting string for this connection.
VALUES (CLIENT ACCTNG)
INTO :ACCT_STRING"
af*****@cio.sc.gov wrote:
I am running DB2 Version 8.1 fixpak 5 on Linux Red Hat Version 2.1.
Is there any way to change back for CPU usage for DB2 by Authorization
ID?
Thanks.