new feature in 11.50 to kill a particular userid,
HAPPY HOLLIDAYS!!
The old days, we revoke connect from that userid, the capture all session ids
from that user, then run onmode -z, do we now have a new feature or command to
do this?
Thanks
No... But the old method still works... It becomes easier if you have a
script... I don't because it's not a frequent situation... But it should be
easy to create...
On Dec 21, 2012 8:49 PM, "Kern Doe" <kern_doe@yahoo.com> wrote:
> HAPPY HOLLIDAYS!!
>
> The old days, we revoke connect from that userid, the capture all session
> ids
> from that user, then run onmode -z, do we now have a new feature or
> command to
> do this?
>
> Thanks
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7bdc0e7e4c99e604d1675066
You can user the SQL admin api and sysmaster to complete this task in a
single sql or put this
in a stored procedure if you intend to reuse this.
select sysadmin:task('onmode','z', sid) from sysmaster:sysrstcb where
username = '<<username>>';
John F. Miller III
STSM, Embedability Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 12/21/2012 12:48:53 PM:
> From: "Kern Doe" <kern_doe@yahoo.com>
> To: ids@iiug.org,
> Date: 12/21/2012 12:49 PM
> Subject: new feature in 11.50 to kill a particular user.... [29127]
> Sent by: ids-bounces@iiug.org
>
> HAPPY HOLLIDAYS!!
>
> The old days, we revoke connect from that userid, the capture all session
ids
> from that user, then run onmode -z, do we now have a new feature or
> command to
> do this?
>
> Thanks
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>