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
 

 

Performace in Extracting & Loading the Data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Sat Aug 09, 2008 3:48 am    Post subject: Performace in Extracting & Loading the Data
Reply with quote

Hi all,

At our shop, we need to extract(Unload) the data from production need to load in the test environment. (refreshment process). The thing is to unload few tables have abundant data about 760 million of rows and they are taking lot of time to extract or unload the data. Thats the reason, production services asks us to cancel or insists not to run the jobs in production. Had it been individual table we would have taken from the latest imagecopies, but sometimes we use joins or subqueries to unload the data. My question is, Is there any suggestions from your side to unload the data as fast as we can, like using the CLASS parameters TIME parameters or any other suggestions, so that the job should go fine without abending and should complete with in 1-3 hrs.

Thanks in advance to all.

***If you feel my question is not appropriate pls excuse me**
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: Sat Aug 09, 2008 8:50 am    Post subject:
Reply with quote

Hello,

This a decision for your management. If your process is one they choose to support, they will make additonal resources available or remove the time constraint because it is inconvenient to other processes.

The CLASS and TIME parameters almost certainly will not provide what you need. Actually, processing 700million+ rows with joins and subqueries may not be reasonable in a 1-3 hour window. How was this time figured?

You may need a production-size copy to work with for some amount of time. Then you could restore an image copy and not interfere with the production system.

As i mentoned before, this is a decison for your management.
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Mon Aug 11, 2008 9:08 pm    Post subject: Reply to: Performace in Extracting & Loading the Data
Reply with quote

Thanks dick scherrer a lot for ur suggestions.
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 Aug 11, 2008 9:40 pm    Post subject: Reply to: Performace in Extracting & Loading the Data
Reply with quote

You're welcome - good luck icon_smile.gif

We would be interested to hear the outcome.

d
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Mon Aug 11, 2008 11:52 pm    Post subject:
Reply with quote

sure..I am working on that only.
I will update once i come out with an answer. icon_smile.gif
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts loading a Modified Mapset Susanta CICS 2 Tue Mar 14, 2017 5:43 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm


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