Anyone have a WLM address space with MNSPAS specified?

Raymond Bell

Anyone have a WLM address space with MNSPAS specified?
All,

Just curious to know if anyone has any of their WLM-managed DB2 stored procedure address space JCLs specified with the MNSPAS parm, new in DB2 V10 apparently. The default is 0, so STC JCL tends not to have it coded. I'm wondering if anyone has, say, MNSPAS=1 (or more) coded and, if so, why and did it work for them.

Cheers,


Raymond

Raymond Bell
Db2
Hosting Services, Technology
Royal Bank of Scotland Group
3rd Floor Regents House
40-42 Islington High Street
London N1 8XL
Mob: +44 (0) 7894 608214
Email: [login to unmask email]<mailto:[login to unmask email]>

The content of this email is confidential unless stated otherwise.
[cid:[login to unmask email]

The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com
Attachments

  • image001.png (6.7k)

Sam Baugh

Anyone have a WLM address space with MNSPAS specified?
(in response to Raymond Bell)
We have 2 Application WLM Environments, each with highly active external
stored procedures, one environment has MNSPAS=10, another has MNSPAS=12. I
believe we have more than we need, but the desire was to not have to wait
for a new workload environment to start.



On Thu, Feb 8, 2018 at 6:11 AM, Bell, Raymond (Hosting Services,
Technology) <[login to unmask email]> wrote:

> All,
>
>
>
> Just curious to know if anyone has any of their WLM-managed DB2 stored
> procedure address space JCLs specified with the MNSPAS parm, new in DB2 V10
> apparently. The default is 0, so STC JCL tends not to have it coded. I’m
> wondering if anyone has, say, MNSPAS=1 (or more) coded and, if so, why and
> did it work for them.
>
>
>
> Cheers,
>
>
>
>
>
> Raymond
>
>
>
> Raymond Bell
>
> Db2
>
> Hosting Services, Technology
>
> Royal Bank of Scotland Group
>
> 3rd Floor Regents House
>
> 40-42 Islington High Street
> https://maps.google.com/?q=40-42+Islington+High+Street%0D+London+N1&entry=gmail&source=g
>
> London N1
> https://maps.google.com/?q=40-42+Islington+High+Street%0D+London+N1&entry=gmail&source=g
> 8XL
>
> Mob: +44 (0) 7894 608214
>
> Email: [login to unmask email]
>
>
>
> The content of this email is confidential unless stated otherwise.
>
> [image: cid:[login to unmask email]
>
>
>
> The Royal Bank of Scotland plc. Registered in Scotland No 90312.
> Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank
> of Scotland is authorised by the Prudential Regulation Authority, and
> regulated by the Financial Conduct Authority and Prudential Regulation
> Authority. The Royal Bank of Scotland N.V. is authorised and regulated by
> the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands,
> and is registered in the Commercial Register under number 33002587.
> Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The
> Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are
> authorised to act as agent for each other in certain jurisdictions.
>
>
>
> National Westminster Bank Plc. Registered in England No. 929027.
> Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster
> Bank Plc is authorised by the Prudential Regulation Authority, and
> regulated by the Financial Conduct Authority and the Prudential Regulation
> Authority.
>
>
>
> The Royal Bank of Scotland plc and National Westminster Bank Plc are
> authorised to act as agent for each other.
>
>
>
> This e-mail message is confidential and for use by the addressee only. If
> the message is received by anyone other than the addressee, please return
> the message to the sender by replying to it and then delete the message
> from your computer. Internet e-mails are not necessarily secure. The
> Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National
> Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not
> accept responsibility for changes made to this message after it was sent.
> RBS may monitor e-mails for business and operational purposes. By replying
> to this message you give your consent to the monitoring of your e-mail
> communications with us.
>
>
>
> Whilst all reasonable care has been taken to avoid the transmission of
> viruses, it is the responsibility of the recipient to ensure that the
> onward transmission, opening or use of this message and any attachments
> will not adversely affect its systems or data. No responsibility is
> accepted by RBS in this regard and the recipient should carry out such
> virus and other checks as it considers appropriate.
>
>
> Visit our website at www.rbs.com
> -----End Original Message-----
>

Raymond Bell

Anyone have a WLM address space with MNSPAS specified?
(in response to Sam Baugh)
Thanks Sam. Just thinking of solutions to a wee problem we have here. Having an SP sitting around ready to rock, rather than wait for WLM to start one – or not – seems an obviously simple win to me.

Cheers,


Raymond

Raymond Bell
Db2
Hosting Services, Technology
Royal Bank of Scotland Group
3rd Floor Regents House
40-42 Islington High Street
London N1 8XL
Mob: +44 (0) 7894 608214
Email: [login to unmask email]<mailto:[login to unmask email]>

The content of this email is confidential unless stated otherwise.
[cid:[login to unmask email]

From: Sam Baugh [mailto:[login to unmask email]
Sent: 08 February 2018 14:12
To: [login to unmask email]
Subject: [DB2-L] - RE: Anyone have a WLM address space with MNSPAS specified?


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

We have 2 Application WLM Environments, each with highly active external stored procedures, one environment has MNSPAS=10, another has MNSPAS=12. I believe we have more than we need, but the desire was to not have to wait for a new workload environment to start.


On Thu, Feb 8, 2018 at 6:11 AM, Bell, Raymond (Hosting Services, Technology) <[login to unmask email]<mailto:[login to unmask email]>> wrote:
All,

Just curious to know if anyone has any of their WLM-managed DB2 stored procedure address space JCLs specified with the MNSPAS parm, new in DB2 V10 apparently. The default is 0, so STC JCL tends not to have it coded. I’m wondering if anyone has, say, MNSPAS=1 (or more) coded and, if so, why and did it work for them.

Cheers,


Raymond

Raymond Bell
Db2
Hosting Services, Technology
Royal Bank of Scotland Group
3rd Floor Regents House
40-42 Islington High Street https://maps.google.com/?q=40-42+Islington+High+Street%0D+London+N1&entry=gmail&source=g
London N1 https://maps.google.com/?q=40-42+Islington+High+Street%0D+London+N1&entry=gmail&source=g 8XL
Mob: +44 (0) 7894 608214
Email: [login to unmask email]<mailto:[login to unmask email]>

The content of this email is confidential unless stated otherwise.

The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


Visit our website at www.rbs.com http://www.rbs.com
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com
Attachments

  • image001.png (6.7k)