IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Our IMS DB suddely became very slow.


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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: 2455
Location: Hampshire, UK

PostPosted: Fri Apr 03, 2020 3:35 pm
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 Moderator


Joined: 14 Mar 2007
Posts: 10727
Location: italy

PostPosted: Fri Apr 03, 2020 3:49 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. CICS transaction slow response time All Other Mainframe Topics 5
No new posts W7 and slow writes to DVD-RAM PC Guides & IT News 5
No new posts Slow Execution and Bad Performance of... All Other Mainframe Topics 3
No new posts Resons for slow compilation jobs? JCL & VSAM 9
No new posts DB2 Database is getting slow DB2 4
Search our Forums:

Back to Top