Information Systems:Low Order Volume
There is a job that runs once an hour, all day every day (except when end of day job is running), to monitor orders input via email, FTP, and the web.
Work with Active Jobs BART
10/21/14 11:41:18
CPU %: .0 Elapsed time: 00:00:00 Active jobs: 549
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
8=Work with spooled files 13=Disconnect ...
Current
Opt Subsystem/Job User Type CPU % Function Status
__ EMASUBPRD QSYS SBS .0 DEQW
__ EMAIOPPRD EODJOB BCH .0 DLY-11:59:50 DLYW
Parameters or command
===> ________________________________________________________
F3=Exit F5=Refresh F7=Find F10=Restart statistics
F11=Display elapsed data F12=Cancel F23=More options F24=More keys
Program IOPMSG01 looks in the IOP files to see how many orders were received in the last hour, for each method, and compares the count to a value in file IOPTIMP for the same month, day of the week, and time. If less, an email is sent to all addresses in the data area(s) MSGREC*.
File IOPTIMP was created based on actual order history. But the program doesn’t compare the actual orders received to the historic average, but to an ‘alert count’; which is always one. So an alert is actually sent if no orders were received at a time when we expected some. So really, it is less a check for low volume, than a check to see if the services are functioning.
FTP Orders Low
Make sure the import job is running by keying in WRKACTJOB and pressing enter. Page down until you see ‘FTP_ORDERS’, in subsystem MONITOR2.
Work with Active Jobs BART
10/21/14 12:51:37
CPU %: 31.4 Elapsed time: 01:10:44 Active jobs: 543
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
8=Work with spooled files 13=Disconnect ...
Current
Opt Subsystem/Job User Type CPU % Function Status
__ MONITOR QSYS SBS .0 DEQW
__ MSGMONITOR EODJOB BCH .0 PGM-OPMESSAGES MSGW
__ MONITOR2 QSYS SBS .0 DEQW
__ ATLAS_INT ATLAS BCH .0 PGM-ATCUP010 MSGW
__ EDIMON_PRD EDIUSER BCH .0 PGM-EDCUP040 MSGW
__ FTP_ORDERS EODJOB BCH .7 PGM-AICUP010 MSGW
Parameters or command
===> _________________________________________________
F3=Exit F5=Refresh F7=Find F10=Restart statistics
F11=Display elapsed data F12=Cancel F23=More options F24=More keys
The status ‘MSGW’ (message waiting) is misleading, as in the case of these monitors, it usually isn’t waiting for a message to be answered, but for a message to be received. To make sure the monitor is waiting for a message to be received; not to be answered, use option 7=Display Message. If the response is ‘Display message option not allowed’, the monitor is in the correct state.
Look at the status of the FTP sales order interface.
Unity / Start uniPharm Extensions / VA Company / UWD Extensions / EDI – IMS, IMP, etc / FTP – FTP Order Retrieval
10/21/14 12:26:37 AIP Orders Status AIRIU010/CTL
uniPHARM -- PRODUCTION
Monitor status: Running Waiting for next poll
Last activity: 10/21/14 12:25:55 Poll interval: 3 minutes
<-- Order type - CAN/DAT/KRL
Date Time Type File Renamed Recs
10/21/14 12:20 PM KRO 1836091.kro FTP0071732 99
10/21/14 11:55 AM KRO 466970928.kro FTP0071731 9
10/21/14 11:46 AM KRO 618124209.kro FTP0071730 56
10/21/14 11:37 AM KRO 891up00173.kro FTP0071729 1
10/21/14 11:33 AM KRO 891up00172.kro FTP0071728 56
10/21/14 11:29 AM KRO 117063152.kro FTP0071727 2
10/21/14 11:04 AM KRO 1205510577.kro FTP0071726 3
10/20/14 9:14 PM KRO 11366280.kro FTP0071725 41
10/20/14 8:57 PM KRO 891up00171.kro FTP0071724 1
10/20/14 7:59 PM KRO 891up00170.kro FTP0071723 34
10/20/14 7:54 PM KRO 618124208.kro FTP0071722
F3=Exit F5=Refresh F8=End Mon F9=Poll Now
F13=Config F14=Interfaces F15=AIP Messages F16=W/W Mon Job F12=Exit
If this shows no FTP orders received, the easiest way to check the status of the service is to see if we are receiving transaction files from Atlas. Sign onto the FTP server, go into FTP root / Atlas / Archive, and look at the latest date and time a file was received.
Email Orders Low
Email orders go through three subsystems; IMS, IMP, and IOP. So check the state of each of these. Key in WRKACTJOB press enter, then page down until you see –
Work with Active Jobs BART
10/21/14 12:40:42
CPU %: .0 Elapsed time: 00:00:00 Active jobs: 542
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
8=Work with spooled files 13=Disconnect ...
Current
Opt Subsystem/Job User Type CPU % Function Status
IMPSUBPRD QSYS SBS .0 DEQW
IMPPOSTPRD EODJOB BCH .0 DLY-120 DLYW
IMSSUBPRD QSYS SBS .0 DEQW
IMSPOSTPRD EODJOB BCH .0 DLY-120 DLYW
IOPSUBPRD QSYS SBS .0 DEQW
IOPPOSTPRD EODJOB BCH .0 DLY-120 DLYW
More...
Parameters or command
===> _______________________________________________________
F3=Exit F5=Refresh F7=Find F10=Restart statistics
F11=Display elapsed data F12=Cancel F23=More options F24=More keys
These three jobs are all waiting for two minutes, after which they will process any orders coming in via email.
Look at IMS to see status of email orders received.
Unity / Start uniPharm Extensions / VA Company / UWD Extensions / EDI – IMS, IMP, etc / IMS – Inbound Message FNS / Show messages
10/21/14 12:48:22 uniPHARM -- PRODUCTION IMRIQ050/LISTCTL
Show IMS Messages Received PRODUCTION 1.00
Display Order Field Test Values
ADDDA By date added (desc)
IMS RUNNING AND
Limit to AND
Status Search for Message # Date Type and Range
ALL AD
HD=Message Header LI=Message Lines HO=Hold RL=Release XH=Extended Header
SENT DATE SENT TIME SUBJECT Cust Id MESSAGE #
OCT 21 14 12:37 PM FI INPHARM PO (RX#143481) 568241
OCT 21 14 12:21 PM FI INPHARM PO (RX#141103) 568240
OCT 21 14 12:22 PM FI X12 PO 568239
OCT 21 14 12:19 PM FI INPHARM PO (RX#143480) 568238
OCT 21 14 12:19 PM FI X12 PO 568237
OCT 21 14 12:17 PM FI X12 PO 568236
OCT 21 14 12:09 PM FI INPHARM PO (RX#148824) 568235
OCT 21 14 12:12 PM FI X12 PO 568234
OCT 21 14 11:59 AM FI INPHARM PO (RX#144666) 56823 +
F21=Scrn Reset
F3=Exit F5=Refresh F12=Previous F24=Scrn Save
All the statuses should be FI for finished. Press F12 twice, then –
IMP – Message Parsing Fns / Show messages
10/21/14 14:11:31 uniPHARM -- PRODUCTION INRIQ100/LISTCTL
Show IMP Orders List PRODUCTION 1.00
Display Order Field Test Values
ORDDE By IMP order # descending
Limit to IMP RUNNING AND
Status Search for AND
ALL IMP Ord# Date Type and Range Source
EOB# Customer Code With Item CR
Message #
HD=Order Header LI=Order Lines HO=Hold HX=Extended Order
MH=Msg Header ML=Msg Lines RL=Release MX=Extended Msg
Crt Date IMP ORDER# SOURCE CUST PO #
OCT 21 14 13:58 PO 410 10441 566181 TRI-RX RX140769
OCT 21 14 13:58 PO 410 10441 566180 TRI-RX RX140768
OCT 21 14 13:34 PO 232 10074 566179 ARI 756384
OCT 21 14 13:22 PO 435 10541 566178 ARI 460101
OCT 21 14 13:18 PO 387 10353 566177 ARI 19335500
OCT 21 14 13:14 PO 788 10711 566176 ARI 19335497
OCT 21 14 12:58 PO 408 10436 566175 TRI-RX RX148749
OCT 21 14 12:40 PO 898 11044 566174 TRI-RX RX143481
OCT 21 14 12:26 PO 134 10684 566173 TRI-RX RX141103 +
F21=Scrn Reset
F3=Exit F5=Refresh F12=Previous F24=Scrn Save
All the statuses should be PO for posted. Press F12 twice, then –
IOP – ASW Order Posting Fns / IOP – List of Order Headers
10/21/14 14:21:41 uniPHARM -- PRODUCTION IORIQ100/LISTCTL
IOP RUNNING IOP - Show IOP Orders PRODUCTION 1.00
Display Order SH/NS Categ 1 Field Test Values
IOP#D IOP Order # des
Date Range EOB# With Item
AD 00 00 00 00 AND
IOP Ord Customer Cd Customer PO # Skip ASW Order Sts Codes IOP Error Types
AU=Audit HD=Header LI=Lines PO=Edit+Post CA=Cancel CM=Conf Msgs
EM=Email IH=IMP Header IL=IMP Lines ED=Edit Only RE=Undo CA ER=Errors
RS=Reset CP=Copy PU=Purge TC=Test Copy
CRDATE St Customer CRT TIME SOURCE IOP ORDER#
OCT 21 14 60 11903 JOSHUA LAU (STAFF) 2:00 PM WEB 1800973
OCT 21 14 60 11266 FORT ST.JOHN PHARMAC 1:59 PM WEB 1800972
OCT 21 14 60 10441 LAKESIDE MEDICINE CE 1:59 PM TRI-RX 1800971
OCT 21 14 60 10441 LAKESIDE MEDICINE CE 1:59 PM TRI-RX 1800970
OCT 21 14 60 12125 AGASSIZ PHARMACY 1:57 PM WEB 1800969
OCT 21 14 60 10672 PEOPLES DRUG MART #1 1:53 PM WEB 1800968
OCT 21 14 60 10752 PHARMASAVE #154 1:52 PM WEB 1800967
OCT 21 14 60 12166 REMEDY'S RX #298 1:51 PM WEB 1800966
OCT 21 14 60 11934 20/20 PHARMACY 1:45 PM WEB 180096 +
F21=Scrn Reset
F3=Exit F5=Refresh F9=Show EMS Alerts F12=Previous F24=Scrn Save
These show all electronic orders; FTP, Email, and Web. So you will have to determine by customer number and time which are email orders. (Or you can change a flex column to ‘CUST PO#’ and match them to the IMS screen.)
Web Orders Low
Check to see that the Apache server is running on the i. Key in WRKACTJOB press enter, then page down until –
Work with Active Jobs BART
10/21/14 15:22:31
CPU %: 28.0 Elapsed time: 02:30:32 Active jobs: 541
Type options, press Enter.
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
8=Work with spooled files 13=Disconnect ...
Current
Opt Subsystem/Job User Type CPU % Function Status
QHTTPSVR QSYS SBS .0 DEQW
ADMIN QLWISVR BCI .0 JVM-com.ibm.lw THDW
ADMIN QTMHHTTP BCH .0 PGM-QZHBMAIN SELW
ADMIN QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
ADMIN QTMHHTTP BCI .0 PGM-QZSRHTTP SIGW
ADMIN2 QLWISVR BCI .0 JVM-com.ibm.lw THDW
ADMIN3 QLWISVR BCI .0 JVM-com.ibm.lw THDW
ADMIN4 QWEBADMIN BCI .4 JVM-/qibm/prod THDW
WEBINTER QTMHHTTP BCH .0 PGM-QZHBMAIN SIGW
WEBINTER QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
WEBINTER QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
WEBINTER QTMHHTTP BCI .0 PGM-QZSRHTTP SIGW
WEBINTER QTMHHTTP BCI .0 PGM-QZSRHTTP DEQW
WEBINTER QTMHHTP1 BCI .0 PGM-QZSRCGI TIMW
WEBINTER QTMHHTP1 BCI .0 PGM-QZSRCGI TIMW
WEBSMART QTMHHTTP BCH .0 PGM-QZHBMAIN SIGW
WEBSMART QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
WEBSMART QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
WEBSMART QTMHHTTP BCI .3 PGM-QZSRHTTP SIGW
WEBSMART QTMHHTTP BCI .0 PGM-QZSRHTTP DEQW
WEBSMART QTMHHTP1 BCI 7.2 PGM-QZSRCGI TIMW
WEBSMART QTMHHTP1 BCI 2.0 PGM-QZSRCGI TIMW
WEBTEST QTMHHTTP BCH .0 PGM-QZHBMAIN SIGW
WEBTEST QTMHHTTP BCI .0 PGM-QZSRLOG SIGW
WEBTEST QTMHHTTP BCI .0 PGM-QZSRHTTP SIGW
WEBTEST QTMHHTTP BCI .0 PGM-QZSRHTTP DEQW
WEBTEST QTMHHTP1 BCI .0 PGM-QZSRCGI TIMW
WEBTEST QTMHHTP1 BCI .0 PGM-QZSRCGI TIMW
WEBTEST QTMHHTP1 BCI .0 PGM-QZSRCGI TIMW
Parameters or command ===> ___________________________________________________ F3=Exit F5=Refresh F7=Find F10=Restart statistics F11=Display elapsed data F12=Cancel F23=More options F24=More keys
This shows four Apache servers – ADMIN (administration), WEBINTER (InfoNet), WEBSMART (web orders), and WEBTEST (development). Make sure none of these jobs is in MSGW, and that there are CGI (Common Gateway Interface) jobs running. These are the jobs that actually perform the users’ requests; which is to run the selected programs. More and more iterations are called up if required to answer all the requests.