Start Free Trial

asked on

I would like to have this error log -- In some sort of readable report on screen - to look through and format.. Need the best way to perform this.

This is 1 process generated in large Log -- The common part of each line is the "PNUM=####"

==========LOG============================
STAR=20060330 14:00:06|PNAM=mvs|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=QCEX|RECC=CAEV|PNUM=1220|STAT=PE|MSGT=TCQ queue change from WAIT to EXEC, status PE.
STAR=20060330 14:00:06|PNUM=1220|SSTA=20060330 14:00:06|STRT=20060330 14:00:06|STOP=20060330 14:00:06|STPT=20060330 14:00:06|SELA=00:00:00|SNOD=A14CON00|RECI=SSTR|RECC=CAEV|LNOD=P|PNOD=ceftp5|MSGT=Session started, SNODE:A14CON00 |LCLP=172.22.45.174, PORT=37944|RMTP=167.113.72.1, PORT=1364|FRWL=N
STAR=20060330 14:00:06|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:06|STRT=20060330 14:00:06|STOP=20060330 14:00:06|STPT=20060330 14:00:06|SELA=00:00:00|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=PSTR|RECC=CAPR|LNOD=P|PNOD=ceftp5|MSGI=XSMG200I|MSST=Process started, process:1220 name:mvs SNODE:A14CON00|CLAS=1|PRTY=10
STAR=20060330 14:00:06|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:06|STRT=20060330 14:00:06|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.|FROM=P|RSTR=N|SFIL=/data/cdadmin/ceunix/ndmfiles/pipasi01/P.TPSP02TR.SORTIN.PIP02.NDMFILE|DFIL=P.TPSP02TR.SORTIN.PIP02.NDMFILE|SNAM=step01
STAR=20060330 14:00:06|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:06|STRT=20060330 14:00:06|STOP=20060330 14:00:06|STPT=20060330 14:00:06|SELA=00:00:00|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=CTRC|RECC=CAPR|MSGI=SCPA000I|MSST=Copy step successful.|STDL=Thu Mar 30 14:00:06 2006|CSDS=Thu Mar 30 14:00:06 2006|LCCD=0|LMSG=SCPA000I|OCCD=0|OMSG=SCPA000I|PNAM=mvs|PNUM=1220|SNAM=step01|SBND=ceftp5|SBID=cdadmin|PNOD=ceftp5|SNOD=A14CON00|LNOD=P|FROM=P|XLAT=Y|SCMP=N|ECMP=Y|ECPR=42.42|ECTP=ECZ|ZLVL=1|ZWIN=13|ZMEM=4|OERR=N|CKPT=Y|LKFL=N|RSTR=N|RUSZ=16000|PACC=|SACC=|PPMN=|SFIL=/data/cdadmin/ceunix/ndmfiles/pipasi01/P.TPSP02TR.SORTIN.PIP02.NDMFILE|SDS1= |SDS2= |SDS3= |SBYR=132|SFSZ=162|SRCR=2|SBYX=56|SRUX=1|SVSQ=0|SVCN=0|SVOL=|DFIL=P.TPSP02TR.SORTIN.PIP02.NDMFILE|PPMN=|DDS1=R|DDS2= |DDS3= |DBYW=160|DRCW=2|DBYX=56|DRUX=0|DVSQ=0|DVCN=0|DVOL=|ICRC=N|PCRC=N
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:06|STRT=20060330 14:00:06|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.|SNAM=step02
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:06|STRT=20060330 14:00:06|STOP=20060330 14:00:07|STPT=20060330 14:00:07|SELA=00:00:01|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=IFED|RECC=CAPR|LNOD=P|PNOD=ceftp5|MSGI=XSMG409I|MSGT=If step condition met.|SNAM=step02|MSST=An if condition statement tested true.
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.|SNAM=step03
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|STOP=20060330 14:00:07|STPT=20060330 14:00:07|SELA=00:00:00|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=RJED|RECC=CAPR|LNOD=P|PNOD=A14CON00|MSGI=XSMG400I|MSGT=RUNJOB step ended. REMOTE NODE:A14CON00 RC :0 Child pid:13343 |SOPT=/data/cdadmin/ceunix/local/bin/eob_thirdlevel_scripts/ndmstatus.sh P.TPSP02TR.SORTIN.PIP02.NDMFILE pipasi01 SUCCESSFUL COPY|PACC=|SACC=|PNAM=mvs|PNUM=1220|FROM=P|LNOD=P|SNAM=step03|SBND=ceftp5|SBID=cdadmin|MSST=A user run job step completed successfully.0
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.|SNAM=step05
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|STOP=20060330 14:00:07|STPT=20060330 14:00:07|SELA=00:00:00|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=IFED|RECC=CAPR|LNOD=P|PNOD=ceftp5|MSGI=XSMG409I|MSGT=If step condition met.|SNAM=step05|MSST=An if condition statement tested true.
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.|SNAM=step06
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|STOP=20060330 14:00:07|STPT=20060330 14:00:07|SELA=00:00:00|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=RJED|RECC=CAPR|LNOD=P|PNOD=A14CON00|MSGI=SRJA000I|MSGT=RUNJOB step ended. REMOTE NODE:A14CON00 RC :0 Child pid:0 |PACC=|SACC=|PNAM=mvs|PNUM=1220|FROM=S|LNOD=P|SNAM=step06|SBND=ceftp5|SBID=cdadmin|MSST=C->D RUN JOB function completed successfully.0
STAR=20060330 14:00:07|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.|SNAM=step07
STAR=20060330 14:00:08|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:07|STRT=20060330 14:00:07|STOP=20060330 14:00:08|STPT=20060330 14:00:08|SELA=00:00:01|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=IFED|RECC=CAPR|LNOD=P|PNOD=ceftp5|MSGI=XSMG409I|MSGT=If step condition met.|SNAM=step07|MSST=An if condition statement tested true.
STAR=20060330 14:00:08|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:08|STRT=20060330 14:00:08|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.|SNAM=step08
STAR=20060330 14:00:08|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:08|STRT=20060330 14:00:08|STOP=20060330 14:00:08|STPT=20060330 14:00:08|SELA=00:00:00|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=RJED|RECC=CAPR|LNOD=P|PNOD=A14CON00|MSGI=XSMG400I|MSGT=RUNJOB step ended. REMOTE NODE:A14CON00 RC :0 Child pid:13420 |SOPT=/data/cdadmin/ceunix/local/bin/eob_thirdlevel_scripts/ndmstatus.sh TPSP02NR pipasi01 SUCCESSFUL JOBRUN|PACC=|SACC=|PNAM=mvs|PNUM=1220|FROM=P|LNOD=P|SNAM=step08|SBND=ceftp5|SBID=cdadmin|MSST=A user run job step completed successfully.0
STAR=20060330 14:00:08|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:08|STRT=20060330 14:00:08|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.
STAR=20060330 14:00:08|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:08|STRT=20060330 14:00:08|SUBM=cdadmin@ceftp5|SNOD=A14CON00|RECI=LSST|RECC=CAEV|MSGT=Local Step started.|SNAM=step10
STAR=20060330 14:00:08|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:08|STRT=20060330 14:00:08|STOP=20060330 14:00:08|STPT=20060330 14:00:08|SELA=00:00:00|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=RJED|RECC=CAPR|LNOD=P|PNOD=A14CON00|MSGI=XSMG400I|MSGT=RUNJOB step ended. REMOTE NODE:A14CON00 RC :0 Child pid:13422 |SOPT=rm /data/cdadmin/ceunix/ndmfiles/pipasi01/P.TPSP02TR.SORTIN.PIP02.NDMFILE|PACC=|SACC=|PNAM=mvs|PNUM=1220|FROM=P|LNOD=P|SNAM=step10|SBND=ceftp5|SBID=cdadmin|MSST=A user run job step completed successfully.0
STAR=20060330 14:00:08|PNAM=mvs|PNUM=1220|SSTA=20060330 14:00:06|STRT=20060330 14:00:06|STOP=20060330 14:00:08|STPT=20060330 14:00:08|SELA=00:00:02|SUBM=cdadmin@ceftp5|SNOD=A14CON00|CCOD=0|RECI=PRED|RECC=CAPR|LNOD=P|PNOD=ceftp5|MSGI=XSMG252I|MSST=Process completed, SNODE:A14CON00
STAR=20060330 14:00:08|PNUM=1220|SSTA=20060330 14:00:06|STRT=20060330 14:00:06|STOP=20060330 14:00:08|STPT=20060330 14:00:08|SELA=00:00:02|SNOD=A14CON00|RECI=SEND|RECC=CAEV|LNOD=P|PNOD=ceftp5|MSGT=Session ended, Session Manager shutting down SNODE:A14CON00
============End of log============================

Driven by each PNUM=#### in the log - which is on Multiple lines.
Report should look like this:
====
PNUM=1220
LCCD=0
LMSG=SCPA000I
OCCD=0
OMSG=SCPA000I
PNAM=mvs
SFIL=/data/cdadmin/ceunix/ndmfiles/pipasi01/P.TPSP02TR.SORTIN.PIP02.NDMFILE
DFIL=P.TPSP02TR.SORTIN.PIP02.NDMFILE
STRT=20060330 14:00:06
STOP=20060330 14:00:06
=====

ASKER

This is on Unix(solaris)

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Keep in mind that thing command ozo gave you outputs only what you have listed.
It will drop lines like RECI= and what not. In any case, to make it throw in the =====
that you show to differentiate the record groups, you might want to throw in another tr
command:

tr '\n' '\n=====' < logfile | tr '|' '\n' | egrep '(^PNUM|LCCD|LMSG|OCCD|OMSG|PNAM|SFIL|DFIL|START|STOP)='

If you want all of the tokens, just drop the egrep.
--brian

I guess you simply want:
tr '|' '\n' < logfile

or you could open it up in excel as a CSV file (and specifying | as the seperator)

ozo answered the question first and his answer was complete enough to warrant all of the points.
--brian

ASKER

Thanks for all of your help -- not abondoned.. I have been just very busy.. Thanks!!! galger66