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
 

 

Query on DB2 WLM stored procedures

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

New User


Joined: 20 Oct 2015
Posts: 34
Location: USA

PostPosted: Sun Feb 12, 2017 11:13 pm    Post subject: Query on DB2 WLM stored procedures
Reply with quote

Hi All

Can someone pls advise whose responsibility is to maintain(stop/start etc) the WLM address spaces which are used to run DB2 stored procedures? Is it done by Physical DBAs or Systems DBA or Systems Programmer?

Regards
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8057
Location: East Dubuque, Illinois, USA

PostPosted: Sun Feb 12, 2017 11:36 pm    Post subject: Reply to: Query on DB2 WLM stored procedures
Reply with quote

Quote:
Is it done by Physical DBAs or Systems DBA or Systems Programmer?
The answer is ... Yes! The responsibility depends upon the site; one site may have them started during IPL, another site by the system programmer upon request, another site by automation at a certain time each day, another site .... In other words, your question makes no sense as posted since you are asking about site-specific things and you need to go to your site and ask your site support group or team leader or manager.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 34
Location: USA

PostPosted: Mon Feb 13, 2017 8:06 am    Post subject: Reply to: Query on DB2 WLM stored procedures
Reply with quote

Thanks Rob for reply. Just to clarify my question is more about whose actually own the responsibility to issue below wlm commands should a dispute occur the same between different teams regarding the same. My understanding is it's system programmer's responsibility and surely not application dba's responsibility as evident from your reply also. Also, pls advise if quiescing wlm address space can impact anything on databases or applications side? Thanks

/VARY WLM QUIESCE/RESUME
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 34
Location: USA

PostPosted: Mon Feb 13, 2017 8:15 am    Post subject: Reply to: Query on DB2 WLM stored procedures
Reply with quote

Sorry for typo above. Imeant to say who should own the responsibility for wlm address space stop/start using '/vary wlm' in case there arise dispute regarding the same between different teams like system programmer , application dba etc. Also what's the command impact on applications? Can it do any damage?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8057
Location: East Dubuque, Illinois, USA

PostPosted: Mon Feb 13, 2017 6:28 pm    Post subject:
Reply with quote

Again, you are asking things that are site-specific. There is no general answer saying team X is responsible for such and such a command -- I've worked at sites where operators had to issue all console commands; the site I'm working at now I can issue console commands if needed.

Talk to your site support group -- if there are issues with who should issue certain commands, your company management should be the ones to resolve the issue.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Mon Feb 13, 2017 8:46 pm    Post subject:
Reply with quote

As Robert Said, it is purely site specific but most of the times it is done by DBA's.
In your case, as a programmer you should not make the decision or try to find who does what, delegate it to you Manager for the decision.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 34
Location: USA

PostPosted: Tue Feb 14, 2017 5:05 am    Post subject: Reply to: Query on DB2 WLM stored procedures
Reply with quote

Thanks guys for your inputs. Can you also suggest what might be the impact of 'quiescing' and then subsequently 'restarting' DB2 WLM address spaces? can it impact/damage anything on application side?

Thanks
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


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

PostPosted: Tue Feb 14, 2017 5:10 am    Post subject:
Reply with quote

This command puts the WLM application environment in QUIESCED state. When the WLM application environment is in QUIESCED state, the stored procedure requests are queued. If the WLM application environment is restarted within a certain time, the stored procedures are executed. If a stored procedure cannot be executed, the CALL statement returns SQL code -471 with reason code 00E79002.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 34
Location: USA

PostPosted: Tue Feb 14, 2017 9:15 am    Post subject: Reply to: Query on DB2 WLM stored procedures
Reply with quote

Many thanks Rohit
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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am
No new posts GETMAIN/FREEMAIN query Suja.Sai CICS 9 Tue Jan 31, 2017 12:01 pm
No new posts Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am


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