Hi All,
First of all, thanks to the many who contributed valuable suggestions
(sometimes several times!).
Here is my last pass at formats for LISTF,ACCESS. Yes I am still doing
command formats. The code will be structured so that an intrinsic can
be added, but the intention of the Interex voters was to have easy
command access. For those of you that really need programmatic access
please raise this issue at your next RUG meeting.
There will be 2 formats: verbose output similar to what you've seen before,
and a condensed version. Thus, there will be 2 format numbers (8 and 9) and
2 mnemonics ("access", "accdetail").
You are presented with 2 flavors of these 2 formats. The 1st flavor is
basically not sorted at all, so the output is in the same order that the
file is opened. This means that the same job/session id can appear several
times if it has several processes that have opened the file in question. The
2nd flavor is sorted by job/sess id, and thus the same job/sess id always only
appears once per file.
------------
New Choice 1 format 9 (in file-open order)
------------
********************
FILE: LOGFILE9.LOGGING1.SYSTEM12
NO ACCESSORS
********************
FILE: LOGFILE8.LOGGING1.SYSTEM12
NO ACCESSORS
********************
FILE: LOGFILE1.LOGGING1.SYSTEM12
5 ACCESSORS,SHARED,3 R,2 W,LOCKED,REMOTE
#S12345 JOBNAME8,USER5678.ACCT5678 -lock- LDEV: 12345
PIN: 12345 (MYPROG78.MYGRP678.MYACCT78)
ACC: Read REC#: 1234567890 LOCKS: FLOCK-Shr, OPEN-Shr, GUFD-No
#S12345 JOBNAME8,USER5678.ACCT5678 -lock- LDEV: 12345
PIN: 104 (RSPOOL.RSPOOL.SYS)
ACC: Write REC#: 54321 LOCKS: FLOCK-No, OPEN-Shr, GUFD-Wait
#S40 FRED,MGR.PAYROLL,PUB -lock- REM: clientmpe.cup.hp.com
PIN: 244 (/usr/local/bin/bsd/tools/some_program.exe)
ACC: Read REC#: 379 LOCKS: FLOCK-No, OPEN-No, GUFD-Wait
#J15 JSPOOL,RSPOOL.SYS,RSPOOL SPID: O7654321
PIN: 244 (RSPOOL.RSPOOL.SYS)
ACC: Read REC#: 756 LOCKS: FLOCK-No, OPEN-No, GUFD-No
#S12345 JOBNAME8,USER5678.ACCT5678 -lock- LDEV: 12345
PIN: 407 (MYPROG78.MYGRP678.MYACCT78)
ACC: Update REC#: 1005 LOCKS: FLOCK-No, OPEN-Shr, GUFD-Excl
********************
FILE: /bin/awk
2 ACCESSORS,SHARED,2 R,LOCKED
#S12 CATHY.DEVELOP,CI LDEV: 228
PIN: 209 (/bin/awk)
ACC: Read REC#: 1234567890 LOCKS: FLOCK-No, OPEN-No, GUFD-No
#J8 JCOMP,MBETOOLS.BUILD,PUB -lock- SPID: O369
PIN: 81 (/bin/awk)
ACC: Read REC#: 0 LOCKS: FLOCK-Wait, OPEN-Excl, GUFD-No
Note: as before, #S12345 appears 3 times because it has 3 processes that
have opened LOGFILE1. Also the same PIN can open the same file
many times (up to 1024).
Changes from previous Choice 1:
1) ACCESSOR line:
- accessors info moved to below the FILE: line so that long filenames
are less likely to wrap around, and so accessor info is in a fixed location.
- ",LOCKED" is displayed if any accessor has any of the 3 locks locked. If
no locks are held the nothing extra is displayed (this is consistent with
how no readers or no writers or not being accessed by STORE, etc. is
handled).
- ",REMOTE" is displayed if any accessor is remotely connected to the 3000. If
all accessors are local then nothing extra is displayed.
- The longest accessor line is:
nnnnn ACCESSORS,SHARED,nnnnn R,nnnnn W,CONCURRENT-BACKUP,LOCKED,REMOTE
2) USER: line no longer shows ",GROUP" name to make room for remote node name,
if present. The job/sess name, if present, or the user name always begins
in col 16. The LDEV: label begins in col 44. The LDEV: label will not
always be shown (see below), but whatever is seen in this space begins in
the same column.
- All job accessors will show the output spool file id following the SPID:
label. The format is Onnnn which which corresponds to the file in
OUT.HPSPOOL. This replaces the LDEV field.
- For remote accessors the LDEV: label is replaced with REM: followed by the
domain name for the incoming connection. If the domain name cannot be
**quickly** obtained then the IP address is used instead. If the domain
name is too long it wraps around. If the process is not remote then nothing
is shown. A job streamed by a remote session is seen as a local job.
3) The PIN: line has PIN followed by the program name starting in col 16. The
name is encloded in parenthesis (like in SHOWPROC). If the name is too
long it wraps to the next line.
4) The wait order for file locks is not available.
- "Yes-share" was replaced with "-Shr". "Yes-excl" was replaced with "-Excl".
"Yes-wait[n]" was replaced with "-Wait".
- The position of the lock labels FLOCK-, OPEN- and GUFD- is fixed.
- An asterisk is not displayed for exclusive locks.
------------
New Choice 1 format 8 (file-open order still)
------------
********************
FILE: LOGFILE9.LOGGING1.SYSTEM12
NO ACCESSORS
********************
FILE: LOGFILE8.LOGGING1.SYSTEM12
NO ACCESSORS
********************
FILE: LOGFILE1.LOGGING1.SYSTEM12
5 ACCESSORS,SHARED,3 R,2 W,LOCKED,REMOTE
#S12345 JOBNAME8,USER5678.ACCT5678 -lock- LDEV: 12345
#S12345 JOBNAME8,USER5678.ACCT5678 -lock- LDEV: 12345
#S40 FRED,MGR.PAYROLL,PUB -lock- REM: clientmpe.cup.hp.com
#J15 JSPOOL,RSPOOL.SYS,RSPOOL SPID: O7654321
#S12345 JOBNAME8,USER5678.ACCT5678 -lock- LDEV: 12345
********************
FILE: /bin/awk
2 ACCESSORS,SHARED,2 R,LOCKED
#S12 CATHY.DEVELOP,CI LDEV: 228
#J8 JCOMP,MBETOOLS.BUILD,PUB -lock- SPID: O369
Note: #S12345 appears 3 times, once for each process.
Features:
1) one line per job/session accessor.
2) shows remote accessor
3) indicates which job/sess have the file locked.
------------------------------------------
New Choice 2 format 9 (sort by j/s number)
------------------------------------------
********************
FILE: LOGFILE9.LOGGING1.SYSTEM12
NO ACCESSORS
********************
FILE: LOGFILE8.LOGGING1.SYSTEM12
NO ACCESSORS
********************
FILE: LOGFILE1.LOGGING1.SYSTEM12
5 ACCESSORS,SHARED,3 R,2 W,LOCKED,REMOTE
#S12345 JOBNAME8,USER5678.ACCT5678 -lock- LDEV: 12345
PIN: 12345 (MYPROG78.MYGRP678.MYACCT78)
ACC: Read REC#: 1234567890 LOCKS: FLOCK-Shr, OPEN-Shr, GUFD-No
PIN: 104 (RSPOOL.RSPOOL.SYS)
ACC: Write REC#: 54321 LOCKS: FLOCK-No, OPEN-Shr, GUFD-Wait
PIN: 407 (MYPROG78.MYGRP678.MYACCT78)
ACC: Update REC#: 1005 LOCKS: FLOCK-No, OPEN-Shr, GUFD-Excl
#S40 FRED,MGR.PAYROLL,PUB -lock- REM: clientmpe.cup.hp.com
PIN: 244 (/usr/local/bin/bsd/tools/some_program.exe)
ACC: Read REC#: 379 LOCKS: FLOCK-No, OPEN-No, GUFD-Wait
#J15 JSPOOL,RSPOOL.SYS,RSPOOL SPID: O7654321
PIN: 244 (RSPOOL.RSPOOL.SYS)
ACC: Read REC#: 756 LOCKS: FLOCK-No, OPEN-No, GUFD-No
********************
FILE: /bin/awk
2 ACCESSORS,SHARED,2 R,LOCKED
#S12 CATHY.DEVELOP,CI LDEV: 228
PIN: 209 (/bin/awk)
ACC: Read REC#: 1234567890 LOCKS: FLOCK-No, OPEN-No, GUFD-No
#J8 JCOMP,MBETOOLS.BUILD,PUB -lock- SPID: O369
PIN: 81 (/bin/awk)
ACC: Read REC#: 0 LOCKS: FLOCK-Wait, OPEN-Excl, GUFD-No
------------------------------------------
New Choice 2 format 8 (sort by j/s number)
------------------------------------------
********************
FILE: LOGFILE9.LOGGING1.SYSTEM12
NO ACCESSORS
********************
FILE: LOGFILE8.LOGGING1.SYSTEM12
NO ACCESSORS
********************
FILE: LOGFILE1.LOGGING1.SYSTEM12
5 ACCESSORS,SHARED,3 R,2 W,LOCKED,REMOTE
#S12345 JOBNAME8,USER5678.ACCT5678 -lock- LDEV: 12345
#S40 FRED,MGR.PAYROLL,PUB -lock- REM: clientmpe.cup.hp.com
#J15 JSPOOL,RSPOOL.SYS,RSPOOL SPID: O7654321
********************
FILE: /bin/awk
2 ACCESSORS,SHARED,2 R,LOCKED
#S12 CATHY.DEVELOP,CI LDEV: 228
#J8 JCOMP,MBETOOLS.BUILD,PUB -lock- SPID: O369
Note: #S12345 only appears once now.
Please let me know what you think. Thanks for all of your great input!
regards,
Jeff Vance, MPE Lab
--
Jeff Vance
|