i need to describe a scenario. i have files coming in from several lpars to my LPAR. what i need to do is take the file and design my process how to load the data in that file into several of my tables in the DB2 server.
in what way can i design my JCL and trigger programs so that it will be efficient enough to load files with a 8 secs SLA...?
Plese provide the below information and corret me if got u wrong.
U have can merge all the files comming from differt LPAR and then a cobol program finds the data specfic to different tables and call the table specfic reformate called module and write the data in fromated layout and then perform UPDATE/INSERT in valrious table with the formated layout.
Can u implement with the above approach or thr is more complexity
thanx for the approach...
let me tell you how are we doing it presently...
we have a run tash associated with each file that id ndmd to our lpar.
this run task then creates a jcl which executes a pgm that sorts my file based on 2 keys and creates 2 files.
after sorting this pgm again creates 5 jcls for loading my data into 5 db2 tables. each of the jcls then excutes one loading pgm for each table and based on the cruteria from the records, loads them..
the 2 files created in the previous step is fed as input to the 5 loading pgms...
what i want is i need to re engineer the entire process of loading the files...starting from the ndm step.
i am lacking in ideas as the exsisting process is on my mind.. i need new ways to implement this...
pls get back to me if u need furthur details or clarifications..
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
If you more completely describe the input(s) and what is needed after the ndm, we may be able to offer better suggestions.
Hopefully, your sla has wording that the process will run in 8 seconds as long as the volume is less than some benchmarked number. I suggest that if the volume continually increases, the 8 seconds will not be met.