Archives of the TeradataForum
Message Posted: Sat, 09 Mar 2002 @ 15:23:00 GMT
| 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.
--
Warren GILBERT
| 
