Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Our IMS DB suddely became very slow.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
gpnavinkumar

New User


Joined: 03 Jul 2015
Posts: 2
Location: United States

PostPosted: Fri Apr 03, 2020 12:21 pm    Post subject: Our IMS DB suddely became very slow.
Reply with quote

Hi,
One of our IMS DB received so many records because of a business decision. So to be sure I ran a test run of monthend process and it ran for 2Hrs and it took ~10 checkpoints/second. But when the same job ran in production it was deadly slow 5Checkpoints/minute.. Please note its minute this time. its a HALDB.

What could be the issue, what all can be checked?

Any help would be greatly appreciated.
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2407
Location: Hampshire, UK

PostPosted: Fri Apr 03, 2020 3:35 pm    Post subject: Reply to: Our IMS DB suddely became very slow.
Reply with quote

Unless the load on the macine when doing your test was EXACTLY the same as when the production run was made why do you expect the timings to be the same?
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10700
Location: italy

PostPosted: Fri Apr 03, 2020 3:49 pm    Post subject: Reply to: Our IMS DB suddely became very slow.
Reply with quote

Quote:
So to be sure I ran a test run of monthend process and it ran for 2Hrs and it took ~10 checkpoints/second. But when the same job ran in production it was deadly slow 5 Checkpoints/minute.. Please note its minute this time.


it is wrong to take the checkpoint frequency as an indicator of the performance

so Your concern should be based on something else
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. CICS transaction slow response time vasanthz All Other Mainframe Topics 5 Thu Jan 19, 2017 1:31 am
No new posts W7 and slow writes to DVD-RAM prino PC Guides & IT News 5 Thu Mar 28, 2013 6:13 am
No new posts Slow Execution and Bad Performance of... kamran All Other Mainframe Topics 3 Sun Jun 17, 2012 8:59 pm
No new posts Resons for slow compilation jobs? Robert Sample JCL & VSAM 9 Mon Dec 12, 2011 5:44 pm
No new posts DB2 Database is getting slow Jeevankumar.Pochammala DB2 4 Sun Jun 12, 2011 1:08 pm

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