Archives of the TeradataForum
Message Posted: Sat, 09 Mar 2002 @ 15:23:00 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|