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
 

 

Load Job - Time issue

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

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Sat Jun 21, 2008 2:22 am    Post subject: Load Job - Time issue
Reply with quote

Hi,

I have a job which tries to load 2.5 million records in to UDB DB2 data base. From long time the job used to take 2 to 3 hours for completion.

But all of suddent JCL is taking 11 to 12 hours for completion. I am trying to find out what could be the possible reason.

Data Flow

connection
Mainframes -->TCP/IP----> UDB DB2

We have no recent program changes.

Updates from network support and reports from DBA states that there is no issue from their side.

We tried to recreate the issue in test region and it is working fine with which it proves that it is not a network issue.

Please let me know of some had faced this type of issue and what was the solution used.

Thanks and Regards,
Rajkumar Nerella
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 Jun 21, 2008 4:12 am    Post subject:
Reply with quote

Hello,

Quote:
We have no recent program changes.
What about other changes in the environment? Is the database more full now than when this ran acceptably?

Do both the test and production databases have the same size and volume of content?

Quote:
We tried to recreate the issue in test region and it is working fine with which it proves that it is not a network issue
Proves? Maybe. . . Is the test environment on the same server as production or is on a different server? Is the routing nearly the same or the servers on different parts of the lan?

Does the process download the file and then run the load locally or does the process try to send individual inserts?

Is there a record of the timings going back to when the process ran acceptably? Did the run-time spike or did it gradually get worse?
Back to top
View user's profile Send private message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Sat Jun 21, 2008 4:46 am    Post subject: Load Job - Time issue
Reply with quote

Hi,

Thanks a lot for your response.

There are no environmental changes. I am not sure whether the test and production tables are residing on the same server.

The process was going fine all days but this issue occured all of sudden.


[quote]Do both the test and production databases have the same size and volume of content?
Yes we tried to load same number of records in both test and production, end result was the same, Job took long time than regular

We tried send the extract file to the destimation where we are trying to load and the FTP process took 15 minutes only, this confirms that there are no connection issues.

Coming to the important point, on daily basis we are cleaning up the data and loading it again.

DBA has done his job executing reorg utility,runstat utility etc but not able to figure out the issue.

Thanks and Regards,
Rajkumar Nerella
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 Jun 21, 2008 7:40 am    Post subject:
Reply with quote

Hello,

Quote:
Yes we tried to load same number of records in both test and production, end result was the same,Job took long time than regular
If i understand, both test and production now take a very long time?

Quote:
There are no environmental changes.
Something surely has changed somewhere. . . One of the biggest obstacles to trouble shooting is prematurely eliminating something from consideration.

Does your dba control the server(s) or is there a system administration group who may make system level changes?

Is it possible that previously a significantly smaller volume was loaded rather than the current volume? Do you have load statistics going back from now to when the process ran in less time?
Back to top
View user's profile Send private message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Wed Jul 02, 2008 7:32 pm    Post subject: Reply to: Load Job - Time issue
Reply with quote

The issue was resolved.

To resolve this issue a static route(with fibre optic cable line) was added to the mainframe connection box(LPAR) though the OSA connection.

This used the optimal path the transactions went very fast.

Generally the job used to take 2.5 hours but after this change we save 40 minutes.

Thanks for all your support.

Thanks and Regards,
Rajkumar Nerella
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: Thu Jul 03, 2008 12:29 am    Post subject: Reply to: Load Job - Time issue
Reply with quote

Quote:
The issue was resolved.
Good to hear - thank you for letting us know icon_smile.gif

d
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 DSNACCOX (can it be run on 1 db/ts, t... SRICOBSAS DB2 3 Sat May 06, 2017 12:59 am
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am


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