Sorry for the late response, as I was out last Friday. They are all
variable length ASCII files I.E.
FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP EOF LIMIT R/B SECTORS #X MX
DMEMBR01 8960B VA 1991 50000 1 2496 1 *
We are using Bridgeware and usually everything works fine, however that day
the job was just crawling. While I was trying to fix that specific problem
that day, I was mostly trying to add to my internal list of steps of how to
identify what resources a process is (or might be) waiting on. That is why
I was trying to get additional information on SHOT. It is a utility that I
don't have much experience with. I was hoping that by looking at the
process from a different angle (or with a different program) that I might
derive more information that might assist me in actually making a reasonable
(if not accurate) conclusion.
___
Tony Newton
> -----Original Message-----
> From: Jonathan M. Backus [mailto:[log in to unmask]]
> Sent: Thursday, August 09, 2001 4:29 PM
> To: 'Newton, Tony'
> Subject: RE: Question about SHOT output.
>
>
> Tony,
>
> Do you happen to be using BridgeWare? The product from
> Quest/Taurus that
> captures Image transactions in real time for shadowing to
> another database.
> When you say it is "reading an ASCII capture file", what type
> of file is it?
> Do a "listfile ,2" on it.
>
> Thanx,
> Jon
>
> -----Original Message-----
> From: Newton, Tony [mailto:[log in to unmask]]
> Sent: Thursday, August 09, 2001 5:21 PM
> To: [log in to unmask]
> Subject: RE: Question about SHOT output.
>
>
> I was told that the job is a script that is reading an ASCII
> capture file
> and loading that information into an SQL database on our ODS server.
> Apparently the script is also opening a "template" database
> to get table
> structure information so that it knows how to load the
> information into the
> SQL database.
>
> I really don't have any more information than that about what
> the script
> does. I just thought that I might be able to diagnose what
> resource the
> process was waiting on, even if I can't do anything about it.
> ___
> Tony "Never Stop Learning" Newton
>
>
>
>
> > -----Original Message-----
> > From: Jonathan M. Backus [mailto:[log in to unmask]]
> > Sent: Thursday, August 09, 2001 1:59 PM
> > To: 'Newton, Tony'; [log in to unmask]
> > Subject: RE: Question about SHOT output.
> >
> >
> > Tony,
> >
> > It appears your job is running a Warehouse (Taurus)
> > script or program.
> > What type of processing is it supposed to be doing and what
> > type of files is
> > it accessing?
> >
> > Thanx,
> > Jon
> >
> > -----Original Message-----
> > From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
> > Behalf Of Newton, Tony
> > Sent: Thursday, August 09, 2001 4:56 PM
> > To: [log in to unmask]
> > Subject: Question about SHOT output.
> >
> >
> > I have a job that is executing but is doing so VERY slowly.
> > I have looked
> > at it in SOS and it shows that it's primarily in either a CPU
> > wait or a MSG
> > wait. I recalled that Stan had provided some info awhile
> > back about using
> > SHOT to find out what a process was really waiting on. So I tried:
> >
> > SYS/PUB:shot.pub.lpstools
> > SHOT [2.32] - LPS Toolbox [A.07a] (c) 1995 Lund
> Performance
> > Solutions
> >
> > For Help at the SHOT prompt enter ?
> > My PIN is
> > 207
> > For NEWS, enter: HELP NEWS
> >
> > (starting child process to build SHOTPIDS.DATA)
> >
> > MPE/iX 6.5; System started @ 18:45 on 2001-07-20
> > Highest PIN in use = 320, max pin possible = 8190
> > HP3000: SERIES 996-800 (8 CPUs)
> >
> > SHOT @ THU, AUG 9, 2001, 1:42 PM
> >
> > ? PIN CPU Process Name Pri Q Delta % Ic
> Wait State
> >
> > - --- ------ -------------------------- --- - ----- --- --
> > --------------------
> > 4 s 188 Procedure @ $a.1b5b0c 13 A 1 nn PFP_PORT0
> > 5 s 1315 Procedure @ $a.1b5b0c 152 C 1 nn pfp_port1
> > 42 s 2729 LOG.PUB.SYS 50 B 31 1 Nn SYSLOG
> > 148 438 MAIN.PUB.VESOFT 202 D 341 20 Nn LONG:
> > CNTL_BLOCK_WAI
> > 181 627 SHOT.PUB.LPSTOOLS 200 C 303 17 Nn
> SHORT'WAIT
> > 192 m 414 NBSPOOL.PUB.NETBASE 253 E 582 34 On
> (executing)
> > 201 s 4426 WH.WHII.TAURUS 152 C 273 16 Nn
> (executing)
> > 207 730 SHOT.PUB.LPSTOOLS 200 C 59 3 Nn
> (executing)
> > 224 6733 VTSERVER.NET.SYS 152 C 2 Nn
> > TERMINAL_READ_WAIT
> > 317 s 384 CI.PUB.SYS 152 C 104 6 Nn TIMER
> >
> > Summary: Since SHOT start Since bootup
> > ---------------- ------------
> > CPU % busy - -
> > Code Page faults/sec 5.0 -
> > Data Page faults/sec 213.0 -
> > # Processes started 0 60,509
> > Process Creates/min .0 2.1
> >
> > (Warning: MI on)
> >
> > Popular wait reasons #PINs
> > ---------------------------- -----
> > PORT_WAIT 3
> > (not blocked) 3
> >
> > SHOT [Delta]: ADM +WAITSEMPIN
> > ADM (STATE, PIN, CPU, NAME, PRI, QUEUE, DELTA, PERCENT, EXECMODE,
> > WAITSEMPIN, &
> > WAIT)
> > SHOT [Delta]: all
> > SHOT @ THU, AUG 9, 2001, 1:43 PM
> >
> > ? PIN CPU Process Name Pri Q Delta % Ic
> > sPIN Wait State
> >
> > - --- ------ -------------------------- --- - ----- --- -- -----
> > --------------
> > 1 s 35 PROGEN.PUB.SYS 13 A Nn
> > PROGEN_GLOBAL_
> > 2 s 1599 LOAD.PUB.SYS 142 B 20 On
> JUNK
> > 3 s 1605 pm_cleanup 100 B 151 nn
> JUNK
> > 4 s 188 port_facility_process 13 A 4 nn
> > PFP_PORT0
> > 5 s 1315 port_facility_process 152 C 25 nn
> > pfp_port1
> > 6 s 38 port_facility_process 152 C nn
> > pfp_port2
> > 7 s 171 port_facility_process 152 C 2 nn
> > pfp_port3
> > .
> > .
> > .
> > .
> > .
> > 195 3141 QEDIT.PUB.ROBELLE 152 C Nn
> > TERMINAL_READ_
> > 196 3444 CI.PUB.SYS 152 C Nn
> > TERMINAL_READ_
> > 197 1207 CI.PUB.SYS 202 D Nn
> > SON, FATHER
> > 198 270 JSMAIN.PUB.SYS 152 B Nn
> > MsgPort#-33013
> > 201 s 4440 WH.WHII.TAURUS 152 C s 14 41 Nn
> READY
> > 202 s 1755 NBSPOOL.PUB.NETBASE 152 C 769 2 On
> > MESSAGE
> > 206 303 JSMAIN.PUB.SYS 152 B Nn
> > MsgPort#-33048
> > 207 852 SHOT.PUB.LPSTOOLS 152 C 122 Nn
> > (executing)
> >
> > The PIN for my job is 201, however I'm not sure how to
> > interpret what I've
> > found. I'm on 6.5 PP2 on a 996/800.
> >
> > ____
> > Tony Newton | [log in to unmask]
> > HP Systems Admin | (503) 574-5831
> > Providence Health Plan | www.providence.org
> >
> > <<All views are mine and probably only mine>>
> >
> >
> > This message is intended for the sole use of the individual
> > and entity to
> > whom it is addressed, and may contain information that is
> privileged,
> > confidential and exempt from disclosure under applicable law.
> > If you are
> > not the intended addressee, nor authorized to receive for
> the intended
> > addressee, you are hereby notified that you may not use,
> > copy, disclose or
> > distribute to anyone the message or any information contained in the
> > message. If you have received this message in error, please
> > immediately
> > advise the sender by reply email and delete the message.
> > Thank you very
> > much.
> >
> > * To join/leave the list, search archives, change list settings, *
> > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
> >
> >
>
> This message is intended for the sole use of the individual
> and entity to
> whom it is addressed, and may contain information that is privileged,
> confidential and exempt from disclosure under applicable law.
> If you are
> not the intended addressee, nor authorized to receive for the intended
> addressee, you are hereby notified that you may not use,
> copy, disclose or
> distribute to anyone the message or any information contained in the
> message. If you have received this message in error, please
> immediately
> advise the sender by reply email and delete the message.
> Thank you very
> much.
>
>
This message is intended for the sole use of the individual and entity to
whom it is addressed, and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If you are
not the intended addressee, nor authorized to receive for the intended
addressee, you are hereby notified that you may not use, copy, disclose or
distribute to anyone the message or any information contained in the
message. If you have received this message in error, please immediately
advise the sender by reply email and delete the message. Thank you very
much.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
