Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

     #!/usr/bin/perl
     @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	Next>	Last>>