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
 
Table un-load JCL

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

New User


Joined: 10 Mar 2009
Posts: 16
Location: Hyderabad

PostPosted: Mon May 31, 2010 3:53 pm    Post subject: Table un-load JCL
Reply with quote

Hello All,

I have a job which unloads a table from production region monthly once

But in one month it will run fast and in another month it will run very slow

The elapsed time for this job varies in hours from one month to another

Please give the list of factors that affect the performance of this job while unloading the table

Thank you

Regards
Maddipatla
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon May 31, 2010 4:30 pm    Post subject:
Reply with quote

It would be best if you spoke to your capacity & performance management team at your site.

They, and only they, will have all of the information of exactly what else was happening at the times of the job processes which may affect the timings of each run.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon May 31, 2010 5:27 pm    Post subject:
Reply with quote

Quote:
list of factors that affect the performance


these sort of discussions are carried on in journals, papers, etc...

if there is a specific factor of which you have observed,
and you have questions about that specific factor,
I am sure someone here can help.

but none of us want to summarize for you
an article,
discussion,
tech manual definition
or
anything else.
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 May 31, 2010 9:29 pm    Post subject:
Reply with quote

Hello,

As this all happens on your system, all the general answers are there. . . If you have a specific observation, possibly someone here can offer a suggestion as DBZ mentions.

You need to isolate what is different between a "good" run and a "bad" run.

This may be caused by the query(ies) of the unload, the state of the data, or the competition for resources at that time.

You should consider working with your performance people as Expat suggested and also your database support.
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 Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

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