Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 09 Mar 2002 @ 15:23:00 GMT

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

Subj:   Re: Blocking problems
From:   Warren Gilbert

We archive some user databases every evening and to ensure that no tables in these databases are being updated, an Abort Session job is scheduled to run beforehand.

The program, written in COBOL was based on 'PM3', supplied by NCR with the MVS client software.

PM3 was written to abort sessions exceeding set limits of cpu or I/O usage. I modified it to abort any session except for those in an exclusion list (DBC, dbcmanager, etc.) and produce a report of all active sessions indicating which were aborted.


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