Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us