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
 

 

How to load the data from file to several DB2 Tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Madhusmita Patnaik

New User


Joined: 18 Dec 2006
Posts: 14
Location: bangalore

PostPosted: Mon Jul 16, 2007 11:18 am    Post subject: How to load the data from file to several DB2 Tables
Reply with quote

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
View user's profile Send private message

sandeep1dimri

New User


Joined: 30 Oct 2006
Posts: 76

PostPosted: Mon Jul 16, 2007 1:30 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Madhusmita Patnaik

New User


Joined: 18 Dec 2006
Posts: 14
Location: bangalore

PostPosted: Mon Jul 16, 2007 1:44 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sandeep1dimri

New User


Joined: 30 Oct 2006
Posts: 76

PostPosted: Mon Jul 16, 2007 2:51 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jul 16, 2007 8:39 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 0 Mon Jan 02, 2017 11:16 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm


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