PROCESSMONITOR

 

Menu:	PROCESSMONITOR
Component:	PROCESSMONITOR
Page:	PMN_PRCSLIST

Component: PROCESSMONITOR 

Page: PMN_PRCSRQSTDETAIL

Menu: PROCESSMONITOR

Component: PROCESSMONITOR 

Page: PMN_PRCSRQSTPARMS

Menu: PROCESSMONITOR

SELECT PRCSINSTANCE, CMDLINE, PARMLIST, WORKINGDIR, OUTDEST, ORIGPARMLIST, ORIGOUTDEST, PRCSOUTPUTDIR, PRCSPARMEXTFLAG, PRCSFILENAME  FROM PSPRCSPARMS a 

 WHERE PRCSINSTANCE = 29596062;

Component: PROCESSMONITOR

Page: PMN_BAT_MSGLOG

Menu: PROCESSMONITOR

Component: PROCESSMONITOR 

Page: PMN_BAT_TIMINGS

Menu: PROCESSMONITOR

Component: PROCESSMONITOR 

Page: PMN_CDM_INDEX

Menu: PROCESSMONITOR

File List:

select PRCSINSTANCE, CONTENTID, FILENAME, CDM_FILE_TYPE, FILE_SIZE, DTTM_CREATED, CDM_ADMIN, CDM_BINARY_FILE, DESCR50, FLDNOTUSED from ps_CDM_FILELIST_VW where PRCSINSTANCE =29596062 ; 

Distribute to:

select CONTENTID, PRCSINSTANCE, DISTID, DISTIDTYPE from ps_CDM_AUTH where PRCSINSTANCE= 29596062;

Rec: PMN_PRCSLIST --> Fld: PRCSNAME

SEQUENCENO, PRCSINSTANCE, JOBINSTANCE, PRCSJOBSEQ, PRCSTYPE, PRCSNAME, RUNCNTLID, RUNLOCATION, RESTARTENABLED, SERVERNAMERUN, SERVERNAMERQST, RECURNAME, OPRID, RQSTDTTM, RUNDTTM, BEGINDTTM, ENDDTTM, RUNSTATUS, RUNSTATUSDESCR, DISTSTATUS, GENPRCSTYPE, OUTDESTTYPE, OUTDESTFORMAT, PRCSRTNCD, RQSTSTATUSUPD, RQSTSTATUSVIEW, MAINJOBINSTANCE, PRCSITEMLEVEL, SCHEDULENAME, JOBNAMESRC, RECURORIGPRCSINST, P_PRCSINSTANCE, PTNONUNPRCSID

Rec: PSPRCSPARMS --> Fld: PARMLIST, WORKINGDIR

PRCSINSTANCE, CMDLINE, PARMLIST, WORKINGDIR, OUTDEST, ORIGPARMLIST, ORIGOUTDEST, PRCSOUTPUTDIR, PRCSPARMEXTFLAG, PRCSFILENAME

Rec: PSPRCSRQSTTEXT --> Fld: RQST_TEXT 

PRCSINSTANCE, RQSTTEXTTYPE, RQST_TEXT

Rec: PMN_CDM_AUTH_VW --> Fld: DISTID

CONTENTID, PRCSINSTANCE, DISTIDTYPE (2 User, 3 Role, DISTIDDESCR, DISTID

Xlats

PMN_CDM_AUTH_VW,DISTIDTYPE,

2,User ID,User

3,Role Name,Role

PMN_PRCSLIST,DISTSTATUS,

0,None,None

1,Scheduled,N/A

2,Processing,Processing

3,Generated,Generated

4,Unable to Post,Not Posted

5,Posted to Web,Posted

6,Delete,Delete

7,Posting,Posting

9,Pending for Approval,Pending

PMN_PRCSLIST,GENPRCSTYPE,

0,Other,Other

1,SQR,SQR

2,PeopleSoft COBOL,COBOL

3,Crystal Report,Crystal

4,Winword Macro,Winword

5,Application Engine,AppEngine

6,Cube Builder,Cube

7,nVision,nVision

8,Data Mover,Data Mover

PMN_PRCSLIST,OUTDESTFORMAT,

0,Any,Any

1,(None),(None)

10,Postscript (*.lis),PS

11,Crystal Report (*.rpt),RPT

12,Rich Text File (*.rtf),RTF

13,SQR Portable Format (*.spf),SPF

14,Text Files (*.txt),TXT

15,Other,OTHER

16,Default,Default

17,XML Format(*.xml),XML

18,Data Mover Data File (*.dat),DAT

19,Crystal Report Explorer(*.rpt),CR RPT

2,Acrobat (*.pdf),PDF

20,XMLP,XMLP

21,Atom,ATOM

22,Transformation,XFORM

23,Printer Command Lang. (*.pcl),PCL

24,PostScript (*.ps),PS

3,Comma delimited (*.csv),CSV

4,HP Format (*.lis),HP

5,HTML Documents (*.htm),HTM

6,Line Printer Format (*.lis),LP

7,Lotus 1-2-3 Files (*.wks),WKS

8,Microsoft Excel Files (*.xls),XLS

9,Microsoft Word (*.doc),DOC

PMN_PRCSLIST,OUTDESTTYPE,

0,Any,Any

1,(None),NONE

2,File,FILE

3,Printer,PRINTER

4,Window,WINDOW

5,Email,EMAIL

6,Web,WEB

7,Default,DEFAULT

8,Feed,FEED

9,IB Node,IB Node

PMN_PRCSLIST,RUNLOCATION,

2,Server,Server

PMN_PRCSLIST,RUNSTATUS,

1,Cancel,Cancel

10,Not Successful,No Success

16,Pending,Pending

17,Success With Warning,Warning

18,Blocked,Blocked

19,Restart,Restart

2,Delete,Delete

3,Error,Error

4,Hold,Hold

5,Queued,Queued

6,Initiated,Initiated

7,Processing,Processing

8,Cancelled,Cancelled

9,Success,Success

PSPRCSRQSTTEXT,RQSTTEXTTYPE,

1,Email Address,Email Adr

2,Email Subject,Subject

3,Email Text,Text

4,Email Address Expanded List,Email Lst

5,Distribution List,Dist List

6,Original Extended Parameter,Orig Parm

7,Extended Parameter,Parameter

How to find a process which has trace and trace file? 

select PARMLIST,a.CONTENTID,RUNDTTM,

v.PRCSINSTANCE,  v.FILENAME, CDM_FILE_TYPE, FILE_SIZE, DTTM_CREATED, CDM_ADMIN, CDM_BINARY_FILE, DESCR50, FLDNOTUSED,--v.CONTENTID,

a.* from ps_PRCSDEFN p,  psprcsrqst a, ps_CDM_FILELIST_VW v where -- PARMLIST <> ' ' and 

p.prcstype like 'Ap%'

-- and   a.oprid = 'oprid'   

and a.prcsname = p.prcsname 

-- and a.prcsname  not in ('TL_TIMEADMIN') 

and upper(filename) like '%AET%' and a.PRCSINSTANCE = v.PRCSINSTANCE

order by a.PRCSINSTANCE desc;

find defn ref

 

SELECT

    a.fieldname,

    a.version,

    a.fieldtype,

    a.length,

    a.decimalpos,

    a.format,

    a.formatlength,

    a.image_fmt,

    a.formatfamily,

    a.dispfmtname,

    a.defcntryyr,

    a.imemode,

    a.kblayout,

    a.objectownerid,

    to_char(CAST((a.lastupddttm) AS TIMESTAMP),

            'YYYY-MM-DD-HH24.MI.SS.FF'),

    a.lastupdoprid,

    a.fldnotused,

    a.auxflagmask,

    a.descrlong,

    b.recname,

    b.fieldname,

    b.fieldnum,

    b.defrecname,

    b.deffieldname,

    b.curctlfieldname,

    b.edittable,

    b.useedit,

    b.useedit2,

    b.subrecord,

    b.subrecver,

    b.setcntrlfld,

    b.defguicontrol,

    b.label_id,

    to_char(CAST((b.lastupddttm) AS TIMESTAMP),

            'YYYY-MM-DD-HH24.MI.SS.FF'),

    b.lastupdoprid,

    b.timezoneuse,

    b.timezonefieldname,

    b.reltmdtfieldname,

    b.currctluse,

    c.recname,

    c.fieldcount,

    c.indexcount,

    c.ddlcount,

    c.version,

    c.auditrecname,

    c.recuse,

    c.rectype,

    c.setcntrlfld,

    c.rellangrecname,

    c.optdelrecname,

    c.recdescr,

    c.parentrecname,

    c.qrysecrecname,

    c.sqltablename,

    c.buildseqno,

    c.opttrigflag,

    c.objectownerid,

    to_char(CAST((c.lastupddttm) AS TIMESTAMP),

            'YYYY-MM-DD-HH24.MI.SS.FF'),

    c.lastupdoprid,

    c.systemidfieldname,

    c.timestampfieldname,

    c.auxflagmask,

    c.descrlong,

    d.pnlname,

    d.pnlfldid,

    d.fieldnum,

    d.pnlfieldname,

    d.fieldtype,

    d.editsize,

    d.dsplformat,

    d.fieldleft,

    d.fieldtop,

    d.fieldright,

    d.fieldbottom,

    d.editlblleft,

    d.editlbltop,

    d.editlblright,

    d.editlblbottom,

    d.dsplfill,

    d.lbltype,

    d.lblloc,

    d.lblpadsize,

    d.usedefaultlabel,

    d.label_id,

    d.lbltext,

    d.fielduse,

    d.fieldusetmp,

    d.deferproc,

    d.occurslevel,

    d.recname,

    d.fieldname,

    d.onvalue,

    d.offvalue,

    d.assocfieldnum,

    d.occurscount1,

    d.occursoffset1,

    d.occurscount2,

    d.occursoffset2,

    d.occurscount3,

    d.occursoffset3,

    d.subpnlname,

    d.subpnlver,

    d.fieldstyle,

    d.labelstyle,

    d.fieldsizetype,

    d.labelsizetype,

    d.prcstype,

    d.prcsname,

    d.promptfield,

    d.formatfamily,

    d.dispfmtname,

    d.popupmenu,

    d.treectrlid,

    d.treectrltype,

    d.multirectree,

    d.nodecount,

    d.grdcolumncount,

    d.grdshowcolhdg,

    d.grdshowrowhdg,

    d.grdoddrowstyle,

    d.grdevenrowstyle,

    d.grdactivetabstyle,

    d.grdinactivetabstyl,

    d.grdnavbarstyle,

    d.grdlabelstyle,

    d.grdlblmsgset,

    d.grdlblmsgnum,

    d.grdlblalign,

    d.grdacttype,

    d.grdallowcolsort,

    d.tabenable,

    d.pbdisplaytype,

    d.opennewwindow,

    d.urldynamic,

    d.url_id,

    d.gotoportalname,

    d.gotonodename,

    d.gotomenuname,

    d.gotopnlgrpname,

    d.gotomktname,

    d.gotopnlname,

    d.gotopnlaction,

    d.srchbypnldata,

    d.scrollaction,

    d.toolaction,

    d.contname,

    d.contnameover,

    d.contnamedisable,

    d.ptlblimgcollapse,

    d.ptlblimgexpand,

    d.ptadjhiddenfields,

    d.ptcollapsedataarea,

    d.ptdfltviewexpanded,

    d.pthidefields,

    d.showcolhiderows,

    d.ptlebexpandfield,

    d.showtabcntlbtn,

    d.selindicatortype,

    d.secureinvisible,

    d.enableasanchor,

    d.urlencodedbyapp,

    e.pnlname,

    e.pnlfldid,

    e.fieldnum,

    e.pnlfieldname,

    e.fieldtype,

    e.editsize,

    e.dsplformat,

    e.fieldleft,

    e.fieldtop,

    e.fieldright,

    e.fieldbottom,

    e.editlblleft,

    e.editlbltop,

    e.editlblright,

    e.editlblbottom,

    e.dsplfill,

    e.lbltype,

    e.lblloc,

    e.lblpadsize,

    e.usedefaultlabel,

    e.label_id,

    e.lbltext,

    e.fielduse,

    e.fieldusetmp,

    e.deferproc,

    e.occurslevel,

    e.recname,

    e.fieldname,

    e.onvalue,

    e.offvalue,

    e.assocfieldnum,

    e.occurscount1,

    e.occursoffset1,

    e.occurscount2,

    e.occursoffset2,

    e.occurscount3,

    e.occursoffset3,

    e.subpnlname,

    e.subpnlver,

    e.fieldstyle,

    e.labelstyle,

    e.fieldsizetype,

    e.labelsizetype,

    e.prcstype,

    e.prcsname,

    e.promptfield,

    e.formatfamily,

    e.dispfmtname,

    e.popupmenu,

    e.treectrlid,

    e.treectrltype,

    e.multirectree,

    e.nodecount,

    e.grdcolumncount,

    e.grdshowcolhdg,

    e.grdshowrowhdg,

    e.grdoddrowstyle,

    e.grdevenrowstyle,

    e.grdactivetabstyle,

    e.grdinactivetabstyl,

    e.grdnavbarstyle,

    e.grdlabelstyle,

    e.grdlblmsgset,

    e.grdlblmsgnum,

    e.grdlblalign,

    e.grdacttype,

    e.grdallowcolsort,

    e.tabenable,

    e.pbdisplaytype,

    e.opennewwindow,

    e.urldynamic,

    e.url_id,

    e.gotoportalname,

    e.gotonodename,

    e.gotomenuname,

    e.gotopnlgrpname,

    e.gotomktname,

    e.gotopnlname,

    e.gotopnlaction,

    e.srchbypnldata,

    e.scrollaction,

    e.toolaction,

    e.contname,

    e.contnameover,

    e.contnamedisable,

    e.ptlblimgcollapse,

    e.ptlblimgexpand,

    e.ptadjhiddenfields,

    e.ptcollapsedataarea,

    e.ptdfltviewexpanded,

    e.pthidefields,

    e.showcolhiderows,

    e.ptlebexpandfield,

    e.showtabcntlbtn,

    e.selindicatortype,

    e.secureinvisible,

    e.enableasanchor,

    e.urlencodedbyapp,

    f.pnlname,

    f.version,

    f.pnltype,

    f.fieldcount,

    f.maxpnlfldid,

    f.gridhorz,

    f.gridvert,

    f.helpcontextnum,

    f.paneltop,

    f.panelleft,

    f.panelright,

    f.panelbottom,

    f.pnlstyle,

    f.stylesheetname,

    f.ffstylesheetname,

    f.pnluse,

    f.deferproc,

    f.descr,

    f.popupmenu,

    f.license_code,

    to_char(CAST((f.lastupddttm) AS TIMESTAMP),

            'YYYY-MM-DD-HH24.MI.SS.FF'),

    f.lastupdoprid,

    f.objectownerid,

    f.ffstyledesktop,

    f.ffstylephone,

    f.ffstyletablet,

    f.pnlusetemp,

    f.ffstylemedium,

    f.ffstyleexlarge,

    f.descrlong,

    g.pnlname,

    g.version,

    g.pnltype,

    g.fieldcount,

    g.maxpnlfldid,

    g.gridhorz,

    g.gridvert,

    g.helpcontextnum,

    g.paneltop,

    g.panelleft,

    g.panelright,

    g.panelbottom,

    g.pnlstyle,

    g.stylesheetname,

    g.ffstylesheetname,

    g.pnluse,

    g.deferproc,

    g.descr,

    g.popupmenu,

    g.license_code,

    to_char(CAST((g.lastupddttm) AS TIMESTAMP),

            'YYYY-MM-DD-HH24.MI.SS.FF'),

    g.lastupdoprid,

    g.objectownerid,

    g.ffstyledesktop,

    g.ffstylephone,

    g.ffstyletablet,

    g.pnlusetemp,

    g.ffstylemedium,

    g.ffstyleexlarge,

    g.descrlong,

    h.pnlgrpname,

    h.market,

    h.pnlname,

    h.subitemnum,

    h.itemname,

    h.itemlabel,

    h.foldertablabel,

    h.hidden,

    i.pnlgrpname,

    i.market,

    i.pnlname,

    i.subitemnum,

    i.itemname,

    i.itemlabel,

    i.foldertablabel,

    i.hidden,

    j.pnlgrpname,

    j.market,

    j.version,

    j.actions,

    j.descr,

    j.addsrchrecname,

    j.searchrecname,

    j.searchpnlname,

    j.loadloc,

    j.saveloc,

    j.disablesave,

    j.objectownerid,

    to_char(CAST((j.lastupddttm) AS TIMESTAMP),

            'YYYY-MM-DD-HH24.MI.SS.FF'),

    j.lastupdoprid,

    j.primaryaction,

    j.dfltaction,

    j.dfltsrchtype,

    j.deferproc,

    j.expentryproc,

    j.reqsecuressl,

    j.inclnavigation,

    j.forcesearch,

    j.allowactmodesel,

    j.pnlnavflags,

    j.tbarbtns,

    j.showtbar,

    j.addlinkmsgset,

    j.addlinkmsgnum,

    j.srchlinkmsgset,

    j.srchlinkmsgnum,

    j.srchtextmsgset,

    j.srchtextmsgnum,

    j.wsrpcompliant,

    j.fluidmode,

    j.layoutmode,

    j.incfooter,

    j.incside,

    j.incheader,

    j.incsearch,

    j.smallffopt,

    j.comp_type,

    j.pnlgrpuse,

    j.descrlong,

    l.menuname,

    l.barname,

    l.itemname,

    l.itemnum,

    l.itemtype,

    l.pnlgrpname,

    l.market,

    l.barlabel,

    l.itemlabel,

    l.xfercount,

    l.searchrecname,

    m.menuname,

    m.barname,

    m.itemname,

    m.itemnum,

    m.itemtype,

    m.pnlgrpname,

    m.market,

    m.barlabel,

    m.itemlabel,

    m.xfercount,

    m.searchrecname,

    n.menuname,

    n.version,

    n.menugroup,

    n.installed,

    n.grouporder,

    n.menuorder,

    n.groupsep,

    n.menusep,

    n.menulabel,

    n.menutype,

    n.descr,

    n.objectownerid,

    to_char(CAST((n.lastupddttm) AS TIMESTAMP),

            'YYYY-MM-DD-HH24.MI.SS.FF'),

    n.lastupdoprid,

    n.descrlong,

    o.menuname,

    o.version,

    o.menugroup,

    o.installed,

    o.grouporder,

    o.menuorder,

    o.groupsep,

    o.menusep,

    o.menulabel,

    o.menutype,

    o.descr,

    o.objectownerid,

    to_char(CAST((o.lastupddttm) AS TIMESTAMP),

            'YYYY-MM-DD-HH24.MI.SS.FF'),

    o.lastupdoprid,

    o.descrlong,

    p.portal_name,

    p.portal_reftype,

    p.portal_objname,

    p.portal_urltext,

    q.portal_name,

    q.portal_reftype,

    q.portal_objname,

    q.portal_uri_seg1,

    q.portal_uri_seg2,

    q.portal_urltext

FROM

    (

        (

            (

                (

                    (

                        (

                            (

                                (

                                    (

                                        (

                                            (

                                                (

                                                    (

                                                        (

                                                            (

                                                                (

                                                                    psdbfield    a

                                                                    LEFT OUTER JOIN psrecfield   b ON a.fieldname = b.fieldname

                                                                )

                                                                LEFT OUTER JOIN psrecdefn    c ON b.recname = c.recname

                                                            )

                                                            LEFT OUTER JOIN pspnlfield   d ON b.recname = d.recname AND b.fieldname = d.fieldname

                                                        )

                                                        LEFT OUTER JOIN pspnldefn    f ON d.pnlname = f.pnlname

                                                    )

                                                    LEFT OUTER JOIN pspnlgroup   h ON f.pnlname = h.pnlname

                                                )

                                                LEFT OUTER JOIN pspnlgrpdefn j ON h.pnlgrpnamJt = j.market

                                            )

                                            LEFT OUTER JOIN psmenuitem   l ON j.pnlgrpname = l.pnlgrpname AND j.market = l.market

                                        )

                                        LEFT OUTER JOIN psmenudefn   n ON l.menuname = n.menuname

                                    )

                                    LEFT OUTER JOIN psprsmdefn   p ON p.portal_uri_seg2 = j.pnlgrpname

                                )

                                LEFT OUTER JOIN pspnlfield   e ON a.fieldname = e.fieldname 

                            )

                            LEFT OUTER JOIN pspnldefn    g ON e.pnlname = g.pnlname

                        )

                        LEFT OUTER JOIN pspnlgroup   i ON g.pnlname = i.pnlname

                    )

                    LEFT OUTER JOIN pspnlgrpdefn k ON i.pnlgrpname = k.pnlgrpname AND i.market = k.market

                )

                LEFT OUTER JOIN psmenuitem   m ON k.pnlgrpname = m.pnlgrpname AND k.market = m.market

            )

            LEFT OUTER JOIN psmenudefn   o ON m.menuname = o.menuname

        )

        LEFT OUTER JOIN psprsmdefn   q ON q.portal_uri_seg2 = k.pnlgrpname

    )

    

    

  

Portal and other records

 

NUI_STRUCTURE_CONTENT

Label	Edit	Sequence number
Fluid Homepages		0
Fluid Pages		0
Fluid PeopleTools		0
My Preferences		100

Homepage		0
Navigation Collections		0
Pagelets		0
Template Pagelets		0
Templates		0
WSRP Produced Portlets		0

Find Source

PSPNLGRPDEFN               ; --Panel Group Definition

PSPNLGDEFNLANG                        ; --Panel Group Related Lang

PSPNLGROUP                   ; --Panel Group

PSPNLGROUPLANG                       ; --Panel Group Related Language

PSPNLGRPDEL                  ; --Panel Group Definition

PSPNLGRPDEFNEXT

PSPNLGRPSCRIPTS

PSPNLDEFN                      ; --Panel Definition

PSPNLDEFNLANG                           ; --Panel Definition

PSPNLFIELD                      ; --Panel Field

PSPNLFIELDLANG                          ; --Panel Field

PSPNLHTMLAREA                          ; --Panel HTML Area

PSPNLHTMLLANG                          ; --Panel HTML Area

PSPNLBTNDATA

PSPNLBTNLANG

PSPNLACTIVEX

PSPNLTREECTRL                             ; --Panel Tree Control

PSPNLDEL                         ; --Panel Definition

PSPNLCNTRLDATA

PSPNLACEGRDDATA

PSPNLACEGRDAXIS

PSPNLCTLDATALNG

PSPTPNLRTEDITOR                        ; --Panel Rich Text Editor

PSPNLFIELDEXT

PSPTPNLRAWIDGET                      ; --Panel Related Action Widget

PSPRSMDEFN                   ; --Portal Structure Defn Tbl

PSPRSMATTR                   ; --Portal Attribute Table

PSPRSMATTRLANG                        ; --Portal Attribute Lang Table

PSPRSMATTRVAL                           ; --Portal Attr Value Tbl

PSPRSMATTRVALNG                      ; --Portal Attr Value Lang Tbl

PSPRSMCTRBEXCL

PSPRSMDEFNLANG                       ; --Portal Structure Defn Lang Tbl

PSPRSMDEL                      ; --Portal Structure Defn Del Tbl

PSPRSMHPASGPGLT                      ; --Portal Assigned Pagelets

PSPRSMPERM                  ; --Portal  Structure Permission

PSPRSMSYNC                   ; --Portal Registry Sync Id table

PSPRSMSYSATTR                            ; --Portal System Attribute Table

PSPRSMSYSATTRVL                       ; --Portal Sys Attr Value Tbl

PSPRSMWSRPCONS                      ; --Consumed Portlets

PSPRSMWSRPPROD                      ; --Produced Portlets

PSPRSMNUI

PSMSGCATDEFN                            ; --Message Catalog

PSMSGSETDEFN                             ; --Message Sets

PSMSGCATLANG                            ; --Message Catalog

PSMSGSETLANG                            ; --Message Sets

PSMGRSHADOW

 

PSSQLDEFN                      ; --SQL Object Defn

PSSQLDESCR                    ; --SQL Object Description

PSSQLTEXTDEFN                            ; --SQL Object Text

PSSQLLANG                      ; --SQL Object Defn (Rel Lang)

PSSQLDEL                         ; --SQL Object Defn