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
 

 

A generic thought in my mind

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Thu Sep 20, 2012 6:58 pm    Post subject: A generic thought in my mind
Reply with quote

Hello Team,

Could you please let me know your experiences on below process if anyone has this in place.


Existing process:


I would take ABC app infront of me, here lets talk on the screen 'A11' here if user ‘A’ is logged in for the day on ABC app then for that entire day(before our night batch) the data on the screen going to remain same. So if user ‘A’ is hitting the screen 'A11' 100 times a day ( may be hypothetical but time being) then the corresponding SPs have to work for getting the same data 100 times. And if there are 100 users doing the access to screen 'A11' 100 times then 10000 hits to the SPs can be expected; and of course consuming CPU and DB2 resources too.


Idea:


As soon as the batch finishes, and users starts coming to the ABC app and specifically go over screen 'A11' then for every unique users first hit is to be given to the SP and pull out all the result sets and save it on sever cache, and hence forth if the same user tries to access the same page then no need to call SP but get the data from last saved cache and show it. This way a big hits at DB2 side can be reduced and considerable amount of saving can be achieved.



Don’t know:



As far as infrastructural/memory capacity to store the cache are concerned , I am really not having the current stats but I am sure that can be configured accordingly if needed.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Sep 20, 2012 7:17 pm    Post subject: Reply to: A generic thought in my mind
Reply with quote

Quote:
This way a big hits at DB2 side can be reduced and considerable amount of saving can be achieved.


no reason to reinvent the wheel,
DB2 caching once the buffer pools are< tuned> is pretty smart on its own
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Sep 20, 2012 7:18 pm    Post subject:
Reply with quote

is this a cics application?

why can't the program that RECEIVEs the screen,
check the MDT to determine if there has been any data sent?

Yep, many of us have been there and a little knowledge of BMS
saves the day.
KEYWORD: MDT
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Thu Sep 20, 2012 8:10 pm    Post subject:
Reply with quote

Dick,


No there is no CICS.
Its JAVA/DB2 Stored Procedures.

Quote:
DB2 caching once the buffer pools are< tuned> is pretty smart on its own


How can we assure this, is there any way I can find it out without reaching out to DBAs?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Sep 20, 2012 8:15 pm    Post subject:
Reply with quote

well,
all i can say is you are at the mercy of your poorly designed JAVA application.

with MDT (CICS ...) the CICS module can determine very easily,
what, if anything, has changed.

Since you have a JAVA app sucking in the input and not having anything to which to compare,
better started tuning db2........
so that the potential for unnecessary processing is done at the least expense.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Thu Sep 20, 2012 8:20 pm    Post subject:
Reply with quote

Very true, currently we are working more on DB2 tuning itself.

But is the cache limit concerns to implement my question? or why is there a BIG NO to it?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Sep 20, 2012 8:27 pm    Post subject: Reply to: A generic thought in my mind
Reply with quote

to check that the DB2 environment is properly tuned is not Your concern
so why do You want to meddle ? icon_cool.gif
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Thu Sep 20, 2012 8:32 pm    Post subject:
Reply with quote

Quote:
to check that the DB2 environment is properly tuned is not Your concern
so why do You want to meddle ?


Ypu.....icon_smile.gif
But being a production support person, we always have asked to give the ideas towards performace tuning/anything which reduces the manual efforts, so I am in da meddle icon_razz.gif
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Sep 20, 2012 8:57 pm    Post subject:
Reply with quote

i could not fix your brakes, so i made your horn louder

i really enjoy that phrase and I thank Mc for bringing it to me.

your problem is that crap java application.
it should know not to request an update if there has been not change to the input.

why don't you suggest that?

fix the problem at its source.

i really chuckle when i hear that db2 needs to be tuned
in order to fix a crap application.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Tue Sep 25, 2012 11:41 pm    Post subject:
Reply with quote

Quote:
your problem is that crap java application.
it should know not to request an update if there has been not change to the input.
why don't you suggest that?


Yup, all our screens are read only screens and already I suggested this to them so the question here is if they got the data from a SP for XYZ input then where to store that data ? as for the same input they can utilize the last saved data instead of calling the same SP again.
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Generic rename by pattern‏ Steve Coalbran CLIST & REXX 6 Mon May 30, 2016 9:34 pm
No new posts Issue in transfering control when Del... thesumitk CICS 10 Wed Apr 01, 2015 6:45 pm
No new posts Need Inputs: for generic program(s) rocky_balboa COBOL Programming 2 Tue Feb 04, 2014 1:43 pm
No new posts Can We use generic Variables in Scrol... thesumitk TSO/ISPF 8 Fri Sep 06, 2013 5:32 pm
No new posts Generic way to fetch any combinations... genesis786 COBOL Programming 7 Tue Sep 18, 2012 11:21 am


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