Know What a Certain User is Doing
Database administrators spend a lot of time monitoring the database, looking for things that could cause problems. After a while, it is usually possible to identify several of your peers who need to be looked in upon occasionally. After about a thousand repetitions of "DBA, I've got a job I want to kill, would you do it?" I developed the following scripts:
The first is called seeuser and it tells you what a certain user is doing in the database. Since I get tired of deciphering the flag codes in the tbstat output, I also put a legend at the bottom of the output telling me what each code means:
JOE 71> cat seeuser #!/bin/csh if ( $#argv == 0 ) then echo -n "Enter the USER NAME you want to check on ( . for all) ...
Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
