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
| 
