Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Question Unanswered: How to get the session id and kill ;

    Hi all,


    I'm invoking Informix Stored Procedure from Java(using JDBC); I want to kill/stop the Stored Procedure and rollback the data; My Environment is: Informix 9.4 , java 1.4.1(JDBC) ;

    How to kill the Stored Procedure and roll back the data;
    (how to get the session id ,pid and which command/sql command i've to use to kill the informix session programmaticly -->using Stored procedure/sql/esql)


    Thanks
    om
    Last edited by om_kash; 02-15-04 at 05:44.

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: How to get the session id and kill ;

    Hi Om,

    You can run the below commands from unix command prompt, i am not too sure how you would do it in stored procedure.

    To view all the active sessions

    onstat -g ses

    To kill a particular session

    onmode -z <sessionid>


    Regards,

    lloyd

    Originally posted by om_kash
    Hi all,


    I'm invoking Informix Stored Procedure from Java(using JDBC); I want to kill/stop the Stored Procedure and rollback the data; My Environment is: Informix 9.4 , java 1.4.1(JDBC) ;

    How to kill the Stored Procedure and roll back the data;
    (how to get the session id ,pid and which command/sql command i've to use to kill the informix session programmaticly -->using Stored procedure/sql/esql)


    Thanks
    om

  3. #3
    Join Date
    Feb 2004
    Posts
    2

    Re: How to get the session id and kill ;

    Originally posted by lloydnwo
    Hi Om,

    You can run the below commands from unix command prompt, i am not too sure how you would do it in stored procedure.

    To view all the active sessions

    onstat -g ses

    To kill a particular session

    onmode -z <sessionid>


    Regards,

    lloyd
    Hi lloyd,

    Any way thanks , but i'm looking for programmtically;
    i thing with dbinfo('sessionid") , i can do that;
    then execute onmode -z sessionid;



    thanks
    om

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •