Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 21 Jul 2000 @ 21:57:10 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Aborting sessions
From:   Mike Vanole

I set up a script that logons and selects the commands for xgtwglobal: select host, a list of users I want to kill as kill commands, and the quit; then I use the commands as input to xgtwglobal -nw. Your criteria will differ. You might join dbc.sessioninfo with dbc.ampusage.

     @prog = split(/\//, $0);
     $prog = $prog[$#prog];
     @usage_tab = (

       #     opt     arg             action              descrip
       #     ---     ---             ------              -------
             'h',    '',          '&Usage(1)',      'Display Usage Information',
             'u',    'user',     '$user=$arg',     'Specify the database logon id',
             'v',    '',          '$verbose++',     'Verbose',

     $usage_notes = <> 8;
     print "@output";

     `find /tmp -name "kill_users*" -mtime +2 -exec rm {} \\;`;

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023