Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Generating report with DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Wed Apr 17, 2013 8:36 am    Post subject: Generating report with DFSORT
Reply with quote

Hi,

I have a requirement where in I need to find the list of all predecessors of a job. Could some one guide me in this if this can be done using DFSORT.

I have two seperate files

File 1 - FB 80 (List of jobs for which the predecessort list needs to be identified.

Code:
Jobname1
Jobname2

File 2 - FB 80

Original Job - Pred Job (Immediate)
Code:
Jobname1|Jobname2
Jobname1|Jobname3
Jobname2|Jobname4
Jobname2|Dummyjob
Jobname3|finaljob

My output should be

Code:
Jobname1|Jobname2|Level 1
Jobname1|Jobname3|Level 1
Jobname1|Jobname4|Level 2
Jobname1|Dummyjob|Level 2
Jobname1|finaljob|Level 2
Jobname2|Jobname4|Level 1
Jobname2|Dummyjob|Level 1


In my site, we are using OPC scheduler, in which there are options to view the above output information for a particular job operation in online, but I need them in an output file format for analysis which couldn't be generated. There are option only for reporting the immediate predecessor list for the jobs but not beyond that.

Thanks
Bharath
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1712
Location: UK

PostPosted: Wed Apr 17, 2013 12:29 pm    Post subject:
Reply with quote

OPc will tell you that with one of its basic reports.
Back to top
View user's profile Send private message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Wed Apr 17, 2013 12:34 pm    Post subject: Generating report with DFSORT
Reply with quote

Hi Nic,

OPC gives only a report "Internal and External Dependancies' which gives the immediate pred and successor details as denoted in File 2 of my requirement ( I produced the File 2 using Rexx on top of the OPC report) and not to the levels after that.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Apr 17, 2013 12:57 pm    Post subject:
Reply with quote

Original Job - Pred Job (Immediate)
Code:
Code:

Jobname1|Jobname2
Jobname1|Jobname3
Jobname2|Jobname4
Jobname2|Dummyjob
Jobname3|finaljob


Jobname2, Jobname3 etc. are NOT pred jobs but successor jobs.

And how about external dependencies?
Back to top
View user's profile Send private message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Thu Apr 18, 2013 5:46 am    Post subject: Generating report with DFSORT
Reply with quote

Hi Peter,

I would explain my file 2 in the requirement in detail again for better understanding.

My File 2 contains the predecessort job of all the jobs in column 2 (after the seperator '|')

Job 1 has a predecessor of Job 2 and 3
Job 2 has a predecessor of Job 4 and Dummyjob
Job 3 has a predecessor of finaljob

If I want the complete list of predecessors of Job 1, then the output would be

Job1 - Job2
Job1 - Job3

The above records are level 1 because they are immediate.

Also Job 1 has the following level 2 predecessors because of Job2 and Job3

Job1 - Job4 (Pred of Job2)
Job1 - dummyjob (Pred of Job2)
Job1 - final job (Pred of Job3)

Say suppose, in case there is a predecessor for Job 4 in file 2 as Job5, then it will be a Level 3 pred of Job1. So, my output file should contain the following line as well

Job1|Job5|Level 3

While I generate the report of file 2 for all the immediate predecessors of the jobs in my schedule, I have taken care of both Internal and external predecessor as well.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Thu Apr 18, 2013 12:19 pm    Post subject:
Reply with quote

This is what you say :


Code:

job 2      job 3
    |          |
    -------------
           |
        job 1
Back to top
View user's profile Send private message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Thu Apr 18, 2013 12:30 pm    Post subject: Generating report with DFSORT
Reply with quote

Yes Peter. You got it right!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts DFSORT sorting only specific records akodakka DFSORT/ICETOOL 4 Thu Aug 04, 2016 11:24 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us