View previous topic :: View next topic
|
Author |
Message |
Madhusmita Patnaik
New User
Joined: 18 Dec 2006 Posts: 14 Location: bangalore
|
|
|
|
hi all...
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...? |
|
Back to top |
|
|
sandeep1dimri
New User
Joined: 30 Oct 2006 Posts: 76
|
|
|
|
Hi,
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
sandeep |
|
Back to top |
|
|
Madhusmita Patnaik
New User
Joined: 18 Dec 2006 Posts: 14 Location: bangalore
|
|
|
|
hi,
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..
thanks, |
|
Back to top |
|
|
sandeep1dimri
New User
Joined: 30 Oct 2006 Posts: 76
|
|
|
|
Hi
As the files are megerd into one dataset
Quote: |
pgm that sorts my file based on 2 keys and creates 2 files. |
??==> Pgm u mean sort? is these sort keys changes or are constant?
create two files based on which creteria?
2. plse tell us wht means by loading? I means ur merging the records or refreshing the tables.
It seems that the above post idea will works fine if ur using Cobol-dB2 program to load data in to tables
sandeep
[/quote] |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
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. |
|
Back to top |
|
|
|