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

Query on DB2 WLM stored procedures


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ashek15

New User


Joined: 20 Oct 2015
Posts: 48
Location: USA

PostPosted: Sun Feb 12, 2017 11:13 pm
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: 8569
Location: Dubuque, Iowa, USA

PostPosted: Sun Feb 12, 2017 11:36 pm
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: 48
Location: USA

PostPosted: Mon Feb 13, 2017 8:06 am
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: 48
Location: USA

PostPosted: Mon Feb 13, 2017 8:15 am
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: 8569
Location: Dubuque, Iowa, USA

PostPosted: Mon Feb 13, 2017 6:28 pm
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

Global Moderator


Joined: 21 Sep 2010
Posts: 2632
Location: NYC,USA

PostPosted: Mon Feb 13, 2017 8:46 pm
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: 48
Location: USA

PostPosted: Tue Feb 14, 2017 5:05 am
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

Global Moderator


Joined: 21 Sep 2010
Posts: 2632
Location: NYC,USA

PostPosted: Tue Feb 14, 2017 5:10 am
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: 48
Location: USA

PostPosted: Tue Feb 14, 2017 9:15 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Cobol-db2 : SQL query is running for ... DB2 4
No new posts Reading subsequent rows in a query. DB2 12
No new posts SYSIBM Tables Query DB2 8
No new posts Need Help with on of the coalesce query DB2 4
No new posts Mainframe ISPREDIT Macro query TSO/ISPF 3
Search our Forums:

Back to Top