RE: snddst activity -- MIDRANGE-L

How do I monitor that snddst mail is actually successful?

Review the QZMF journal entries ...

DSPJRN JRN(QUSRSYS/QZMF) RCVRNG(*CURCHAIN) +
FROMTIME(070107 000000) TOTIME(073107 +
235959) JOB(CNNPBEMAIL) OUTPUT(*OUTFILE) +
OUTFILFMT(*TYPE1) OUTFILE(QTEMP/QZMF) +
OUTMBR(*FIRST *REPLACE)

Then query the file looking for "E2" entries:

Query . . . . . . . . . . . . . . . . . PAPERLESSD
Library . . . . . . . . . . . . . . . KENNETH
Query text . . . . . . . . . . . . . . COUNT the number of PAPERLESS
bill e-mails +detail
Query CCSID . . . . . . . . . . . . . . 37
Query language id . . . . . . . . . . . ENU
Query country or region id . . . . . . US

*** . is the decimal separator character for this query ***
Collating sequence . . . . . . . . . . Hexadecimal

Processing options
Use rounding . . . . . . . . . . . . Yes (default)
Ignore decimal data errors . . . . . No (default)
Ignore substitution warnings . . . . Yes
Use collating for all compares . . . Yes

Selected files

ID File Library Member Record Format

T01 QZMF QTEMP *FIRST QJORDJE

Result fields

Name Expression Column Heading
Len Dec

DATE SUBSTR(JODATE, 1, 2) || '/' ||
SUBSTR(JODATE, 3, 2) || '/' ||
SUBSTR(JODATE, 5, 2)
EMAILADDR substr(joesd, 75, 50)

Select record tests

AND/OR Field Test Value (Field, Numbers, or
'Characters')

JOESD LIKE '%E2 R%'

Ordering of selected fields

Field Sort Ascending/ Break Field
Name Priority Descending Level Text

DATE 10 A 1

Ordering of selected fields (continued)

Field Sort Ascending/ Break Field
Name Priority Descending Level Text

JOTIME 20 A Time of entry:
hour/minute/second
EMAILADDR

Report column formatting and summary functions
Summary functions: 1-Total, 2-Average, 3-Minimum, 4-Maximum, 5-Count
Overrides
Field Summary Column Dec
Null Dec Numeric
Name Functions Spacing Column Headings Len Pos
Cap Len Pos Editing

DATE 5 0 DATE 8
JOTIME 2 TIME 6 0
Yes
EMAILADDR 2 EMAILADDR 50

Report breaks

Break New Suppress Break
Level Page Summaries Text

0 No No Grand Total Sent:
1 No No Total Number of Paperless Bills sent:

Selected output attributes

Output type . . . . . . . . . . . . . . Printer
Form of output . . . . . . . . . . . . Detail
Line wrapping . . . . . . . . . . . . . No

Printer Output

Printer device . . . . . . . . . . . . *PRINT
Report size
Length . . . . . . . . . . . . . . . 66 (default)
Width . . . . . . . . . . . . . . . . 132
Report start line . . . . . . . . . . . 6
Report end line . . . . . . . . . . . . 60
Report line spacing . . . . . . . . . . Double space
Print definition . . . . . . . . . . . No

Printer Spooled Output

Spool the output . . . . . . . . . . . Yes
Form type . . . . . . . . . . . . . . . (Defaults to value in print
file, QPQUPRFIL)
Copies . . . . . . . . . . . . . . . . 1
Hold . . . . . . . . . . . . . . . . . (Defaults to value in print
file, QPQUPRFIL)

Cover Page

Print cover page . . . . . . . . . . . Yes
Cover page title
Paperless Billing E-mail ... Totals By Date

Page headings and footings

Print standard page heading . . . . . . Yes

Page heading
Paperless Billing E-mail ... Totals By Date

Page footing

* * * * * E N D O F Q U E R Y P R I N T * *
* * *

Example output showing to who and when e-mail was sent

DATE TIME EMAILADDR
09/21/06 13:00:58 e.buckshot@xxxxxxxxxxx
09/21/06 13:00:58 hughesl@xxxxxxxxxxx
09/21/06 13:00:58 sdcurtis5@xxxxxxxx
09/21/06 13:00:58 12deer@xxxxxxxxxxx
09/21/06 13:00:59 geoter@xxxxxxxxxxx
09/21/06 13:00:59 jennelle@xxxxxxxxxxxxxxxx
09/21/06 13:00:59 morrisjanet@xxxxxxxxxxx
09/21/06 13:00:59 the_ramers@xxxxxxxxxxx
09/21/06 13:00:59 tonyschm@xxxxxxxxx
09/21/06 13:00:59 JRG@xxxxxxxxxx
09/21/06 13:01:00 chezboesch@xxxxxxxxxxx
09/21/06 13:01:00 crazycarol@xxxxxxx
09/21/06 13:01:00 duckhoughs@xxxxxxxxxxx
09/21/06 13:01:00 jil.eta@xxxxxxxxxxx
09/21/06 13:01:00 linklein@xxxxxxx
09/21/06 13:01:00 sbaumgartner@xxxxxxxxxxxxx
09/21/06 13:01:00 vcain@xxxxxxxxxxxxxx
09/21/06 13:01:01 camp3@xxxxxxxxxxxxxx
09/21/06 13:01:01 carlariedlinger@xxxxxxxxxxx

Kenneth

****************************************
Kenneth E. Graap
IBM Certified Specialist
iSeries Multiple System Administrator
NW Natural (Gas Services)
keg@xxxxxxxxxxxxx
Phone: 503-226-4211 x5537
FAX: 503-721-2518
****************************************

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
franz400@xxxxxxxxxxxx
Sent: Monday, August 06, 2007 8:33 AM
To: midrange-l@xxxxxxxxxxxx
Subject: snddst activity

How do I monitor that snddst mail is actually successful?
This is an existing app sending mail, but operations doesn't know of a
problem till users complain of missing emails a day or so later.
All mail is forwarded to an exchange server offsite.
Network management is mostly outsourced and they make changes on their
own that have affected us.
This is a V4R5 system
Have ended smtp server and reset msf many times, but don't see how to
find what is waiting to go, or what failed to forward.
jim franz
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.