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
 

 

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: 6966
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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


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