routing db2 commands in batch

william giannelli

routing db2 commands in batch

I want to route a series of DB2 commands in batch:

/-DB2A ARCHIVE LOG SCOPE(GROUP)

/-DB2A SET LOG LOGLOAD(0)

/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)

How can I run this in batch?

thanks

Bill

Lizette Koehler

routing db2 commands in batch
(in response to william giannelli)
This is not really a DB2 issue.


However in JCL you can use the JES2 JCL card that issues MVS Commands.



You can find it documented in the MVS JCL manuals.



Lizette





From: william giannelli [mailto:[login to unmask email]
Sent: Saturday, September 09, 2017 6:28 PM
To: [login to unmask email]
Subject: [DB2-L] - routing db2 commands in batch



I want to route a series of DB2 commands in batch:

/-DB2A ARCHIVE LOG SCOPE(GROUP)

/-DB2A SET LOG LOGLOAD(0)

/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)

How can I run this in batch?

thanks

Bill



-----End Original Message-----

Jim Tonchick

routing db2 commands in batch
(in response to Lizette Koehler)
There is also a user supplied assembler program that can issue MVS and JES commands available free for download. Search Google for the CBT MVSCMD program. It honors RACF rules for allowing users to issue commands. In our shop, we add an additional level of security by placing the program in a loadlib that only the sysprogs and production batch operations ids can access.


-----Original Message-----
From: Lizette Koehler <[login to unmask email]>
To: db2-l <[login to unmask email]>
Sent: Sat, Sep 9, 2017 09:45 PM
Subject: [DB2-L] - RE: routing db2 commands in batch



<div id="AOLMsgPart_2_d870ff89-8b74-4fe1-9142-f64060d79d6e">
<style scoped="">#AOLMsgPart_2_d870ff89-8b74-4fe1-9142-f64060d79d6e td{color: black;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face {font-family:"Comic Sans MS"; panose-1:3 15 7 2 3 3 2 2 2 4;}.aolReplacedBody p.aolmail_MsoNormal,.aolReplacedBody li.aolmail_MsoNormal,.aolReplacedBody div.aolmail_MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif;}.aolReplacedBody a:link,.aolReplacedBody span.aolmail_MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;}.aolReplacedBody a:visited,.aolReplacedBody span.aolmail_MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;}.aolReplacedBody p.aolmail_msonormal0,.aolReplacedBody li.aolmail_msonormal0,.aolReplacedBody div.aolmail_msonormal0 {mso-style-name:msonormal; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:11.0pt; font-family:"Calibri",sans-serif;}.aolReplacedBody span.aolmail_EmailStyle20 {mso-style-type:personal; font-family:"Arial",sans-serif; color:#1F497D;}.aolReplacedBody span.aolmail_EmailStyle21 {mso-style-type:personal-compose; font-family:"Comic Sans MS"; color:windowtext;}.aolReplacedBody .aolmail_MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif;}@page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;}.aolReplacedBody div.aolmail_WordSection1 {page:WordSection1;}</style><div lang="EN-US" class="aolReplacedBody"><div class="aolmail_WordSection1"><p class="aolmail_MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">This is not really a DB2 issue. </span></p><p class="aolmail_MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">
However in JCL you can use the JES2 JCL card that issues MVS Commands.</span></p><p class="aolmail_MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"> </span></p><p class="aolmail_MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">You can find it documented in the MVS JCL manuals.</span></p><p class="aolmail_MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"> </span></p><p class="aolmail_MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D">Lizette</span></p><p class="aolmail_MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"> </span></p><p class="aolmail_MsoNormal"><span style="font-family:"Arial",sans-serif;color:#1F497D"> </span></p><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="aolmail_MsoNormal"><b>From:</b> william giannelli [<a href="mailto:[login to unmask email]?">mailto:[login to unmask email]</a>]
<b>Sent:</b> Saturday, September 09, 2017 6:28 PM
<b>To:</b> DB2-<a href="mailto:[login to unmask email]">[login to unmask email]</a>
<b>Subject:</b> [DB2-L] - routing db2 commands in batch</p></div><p class="aolmail_MsoNormal"> </p><p>I want to route a series of DB2 commands in batch:</p><p>/-DB2A ARCHIVE LOG SCOPE(GROUP)</p><p>/-DB2A SET LOG LOGLOAD(0)</p><p>/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)</p><p>How can I run this in batch?</p><p>thanks</p><p>Bill</p><p class="aolmail_MsoNormal"> </p><div class="aolmail_MsoNormal" align="center" style="text-align:center"><div align="left">-----End Original Message-----</div></div></div></div>
<hr size="1" style="color:#ccc"><div id="aolmail_socfooter" style="font-size:80%"><span style="font-weight:bold">Site Links: </span>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/st/?post=182843&anc=p182843#p182843">View post online</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/si/?topic=19">View mailing list online</a>
<a target="_blank" rel="noopener noreferrer" href="mailto:[login to unmask email]">Start new thread via email</a>
<a target="_blank" rel="noopener noreferrer" href="mailto:[login to unmask email]?Subject=Unsubscribe">Unsubscribe from this mailing list</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/us/to/">Manage your subscription</a>


This email has been sent to: <a href="mailto:[login to unmask email]">[login to unmask email]</a>
<p>
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU

ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See

<a target="_blank" rel="noopener noreferrer" href="http://www.ESAIGroup.com/idug">http://www.ESAIGroup.com/idug </a>

</p>
<p>
Use of this email content is governed by the terms of service at:
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/cm/ld/fid=2">http://www.idug.org/p/cm/ld/fid=2</a></p>

</div><hr size="1" style="color:#ccc"></div>
</div>

william giannelli

RE: routing db2 commands in batch
(in response to Jim Tonchick)

I was able to route a db2 command to another LPAR, but now I get an authorization error:

TSOIDXXX 00000290 -DB2A ARC LOG
00000090 DSN3107I -DB2A DSN3EC0X - COMMAND REJECTED. REQUESTOR NOT AUTHORIZED

I have Install Sysadm.

thanks

Bill

Lizette Koehler

routing db2 commands in batch
(in response to william giannelli)
You will need your Security Admin and z/OS Sysprog to allow you to do this.



Lizette





From: william giannelli [mailto:[login to unmask email]
Sent: Sunday, September 10, 2017 12:13 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: routing db2 commands in batch



I was able to route a db2 command to another LPAR, but now I get an authorization error:

TSOIDXXX 00000290 -DB2A ARC LOG
00000090 DSN3107I -DB2A DSN3EC0X - COMMAND REJECTED. REQUESTOR NOT AUTHORIZED

I have Install Sysadm.

thanks

Bill



-----End Original Message-----

Charles Mills

routing db2 commands in batch
(in response to william giannelli)
Instal sysadmin should of course do it. What about on the target LPAR DB2? 

CharlesSent from a mobile; please excuse the brevity.
-------- Original message --------From: Lizette Koehler <[login to unmask email]> Date: 9/10/17 3:00 PM (GMT-08:00) To: [login to unmask email] Subject: [DB2-L] - RE: routing db2 commands in batch
You will need your Security Admin and z/OS Sysprog to allow you to do this. Lizette  From: william giannelli [mailto:[login to unmask email]
Sent: Sunday, September 10, 2017 12:13 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: routing db2 commands in batch I was able to route a db2 command to another LPAR, but now I get an authorization error:TSOIDXXX 00000290 -DB2A ARC LOG
00000090 DSN3107I -DB2A DSN3EC0X - COMMAND REJECTED. REQUESTOR NOT AUTHORIZEDI have Install Sysadm.thanksBill -----End Original Message-----
Site Links:
View post online  
View mailing list online  
Start new thread via email  
Unsubscribe from this mailing list  
Manage your subscription  


This email has been sent to: [login to unmask email]

Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU

ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See

http://www.ESAIGroup.com/idug



Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

william giannelli

routing db2 commands in batch
(in response to Charles Mills)
I have install sysadm on both systems
Thanks
Bill

On Sep 10, 2017 6:05 PM, "Charles Mills" <[login to unmask email]> wrote:

> Instal sysadmin should of course do it. What about on the target LPAR DB2?
>
>
> *Charles*
> Sent from a mobile; please excuse the brevity.
>
> -------- Original message --------
> From: Lizette Koehler <[login to unmask email]>
> Date: 9/10/17 3:00 PM (GMT-08:00)
> To: [login to unmask email]
> Subject: [DB2-L] - RE: routing db2 commands in batch
>
> You will need your Security Admin and z/OS Sysprog to allow you to do this.
>
>
>
> Lizette
>
>
>
>
>
> *From:* william giannelli [mailto:[login to unmask email]
> *Sent:* Sunday, September 10, 2017 12:13 PM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - RE: routing db2 commands in batch
>
>
>
> I was able to route a db2 command to another LPAR, but now I get an
> authorization error:
>
> TSOIDXXX 00000290 -DB2A ARC LOG
> 00000090 DSN3107I -DB2A DSN3EC0X - COMMAND REJECTED. REQUESTOR NOT
> AUTHORIZED
>
> I have Install Sysadm.
>
> thanks
>
> Bill
>
>
> -----End Original Message-----
>
> -----End Original Message-----
>
> -----End Original Message-----
>

Lizette Koehler

routing db2 commands in batch
(in response to william giannelli)
In some shops the JES2 INIT deck will deny the ability to send commands in through JCL.


So if you talk to your z/OS Sysprog and Security Person, they can let you know if you are allowed to send in commands through JCL.



You may be able to do the command through SDSF but may be not JCL.



Lizette





From: william giannelli [mailto:[login to unmask email]
Sent: Sunday, September 10, 2017 4:34 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: routing db2 commands in batch



I have install sysadm on both systems

Thanks

Bill



On Sep 10, 2017 6:05 PM, "Charles Mills" <[login to unmask email] <mailto:[login to unmask email]> > wrote:

Instal sysadmin should of course do it. What about on the target LPAR DB2?





Charles

Sent from a mobile; please excuse the brevity.



-------- Original message --------

From: Lizette Koehler <[login to unmask email] <mailto:[login to unmask email]> >

Date: 9/10/17 3:00 PM (GMT-08:00)

To: [login to unmask email] <mailto:[login to unmask email]>

Subject: [DB2-L] - RE: routing db2 commands in batch



You will need your Security Admin and z/OS Sysprog to allow you to do this.



Lizette





From: william giannelli [mailto:[login to unmask email] <mailto:[login to unmask email]> ]
Sent: Sunday, September 10, 2017 12:13 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: routing db2 commands in batch



I was able to route a db2 command to another LPAR, but now I get an authorization error:

TSOIDXXX 00000290 -DB2A ARC LOG
00000090 DSN3107I -DB2A DSN3EC0X - COMMAND REJECTED. REQUESTOR NOT AUTHORIZED

I have Install Sysadm.

thanks

Bill



-----End Original Message-----



-----End Original Message-----



-----End Original Message-----



-----End Original Message-----

Peter Hunkeler

AW: routing db2 commands in batch
(in response to william giannelli)
The FM (which should always be consulted before posting) says:
DSN3107I csect-name COMMAND REJECTED. REQUESTER NOT AUTHORIZED Explanation: CSECT DSN3EC0X has discovered that the source of the command was a console that does not have 'system' authority.
System action: The command is not processed. This message is sent to the console that entered the command. Operator response: Enter the command from another console that has 'system' authority.
System programmer response: Verify that this console should be used for entering DB2 commands. If so, authorize it for 'system' commands by using MVS services.


It's not a question about your DB2 authority. I'm far from being a DB2 person, but it seems DB2 is very restrictive where its commands come from.

- How did you issue the command in batch?- Were you able to have the same command processed by the local DB2?

--
Peter Hunkeler


Von: william giannelli <[login to unmask email]> An: [login to unmask email] Betreff: [DB2-L] - RE: routing db2 commands in batch Datum: 10.09.17, 21:12


I was able to route a db2 command to another LPAR, but now I get an authorization error:
TSOIDXXX 00000290 -DB2A ARC LOG
00000090 DSN3107I -DB2A DSN3EC0X - COMMAND REJECTED. REQUESTOR NOT AUTHORIZED
I have Install Sysadm.
thanks
Bill
Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription

This email has been sent to: [login to unmask email]
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
http://www.ESAIGroup.com/idug


Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Olle Brostrom

routing db2 commands in batch
(in response to william giannelli)
Hello,
This is not an issue!
All DB2 commands except –START DB2 are sysplexed! This mean that an active DB2 system recognize the command entered from any LPAR in your sysplex.
You do not have to route the command to the LPAR for the specific DB2 ☺

Best Regards

Olle Broström

From: william giannelli [mailto:[login to unmask email]
Sent: den 10 september 2017 03:28
To: [login to unmask email]
Subject: [DB2-L] - routing db2 commands in batch


I want to route a series of DB2 commands in batch:

/-DB2A ARCHIVE LOG SCOPE(GROUP)

/-DB2A SET LOG LOGLOAD(0)

/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)

How can I run this in batch?

thanks

Bill

-----End Original Message-----

Olle Brostrom

routing db2 commands in batch
(in response to Olle Brostrom)
To be true the DB2 system in context has to be defined on all LPARs in SYS1.PARMLIB(IEFSSNxx)

Best Regards

Olle Broström

From: Olle Brostrom [mailto:[login to unmask email]
Sent: den 11 september 2017 08:57
To: [login to unmask email]
Subject: [DB2-L] - RE: routing db2 commands in batch

Hello,
This is not an issue!
All DB2 commands except –START DB2 are sysplexed! This mean that an active DB2 system recognize the command entered from any LPAR in your sysplex.
You do not have to route the command to the LPAR for the specific DB2 ☺

Best Regards

Olle Broström

From: william giannelli [mailto:[login to unmask email]
Sent: den 10 september 2017 03:28
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - routing db2 commands in batch


I want to route a series of DB2 commands in batch:

/-DB2A ARCHIVE LOG SCOPE(GROUP)

/-DB2A SET LOG LOGLOAD(0)

/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)

How can I run this in batch?

thanks

Bill

-----End Original Message-----

-----End Original Message-----

Jim Tonchick

routing db2 commands in batch
(in response to william giannelli)
Does id TSOIDXXX exist on the remote system? Is it in the target DB2 subsystem Zparms as install SYSADM?
<span style="font-size: 16px;">
</span>
<span style="font-size: 16px;">You also neglected to state if both DB2 subsystems use internal DB2 security, or if the use RACF, ACF2, or another security package.
</span>

-----Original Message-----
From: william giannelli <[login to unmask email]>
To: DB2-L <[login to unmask email]>
Sent: Sun, Sep 10, 2017 02:13 PM
Subject: [DB2-L] - RE: routing db2 commands in batch



<div id="AOLMsgPart_2_28ad61f2-7e89-4aab-b4ac-a143fc92977d">
<div class="aolReplacedBody"><p>I was able to route a db2 command to another LPAR, but now I get an authorization error:</p>
<p>TSOIDXXX 00000290 -DB2A ARC LOG
00000090 DSN3107I -DB2A DSN3EC0X - COMMAND REJECTED. REQUESTOR NOT AUTHORIZED</p>
<p>I have Install Sysadm.</p>
<p>thanks</p>
<p>Bill</p>
<hr size="1" style="color:#ccc"><div id="aolmail_socfooter" style="font-size:80%"><span style="font-weight:bold">Site Links: </span>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/st/?post=182848&anc=p182848#p182848">View post online</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/fo/si/?topic=19">View mailing list online</a>
<a target="_blank" rel="noopener noreferrer" href="mailto:[login to unmask email]">Start new thread via email</a>
<a target="_blank" rel="noopener noreferrer" href="mailto:[login to unmask email]?Subject=Unsubscribe">Unsubscribe from this mailing list</a>
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/us/to/">Manage your subscription</a>


This email has been sent to: <a href="mailto:[login to unmask email]">[login to unmask email]</a>
<p>
Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU

ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See

<a target="_blank" rel="noopener noreferrer" href="http://www.ESAIGroup.com/idug">http://www.ESAIGroup.com/idug</a>

</p>
<p>
Use of this email content is governed by the terms of service at:
<a target="_blank" rel="noopener noreferrer" href="http://www.idug.org/p/cm/ld/fid=2">http://www.idug.org/p/cm/ld/fid=2</a></p>

<hr size="1" style="color:#ccc"></div>
</div>
</div>

Myron Miller

routing db2 commands in batch
(in response to Olle Brostrom)
Actually -ter utility is NOT sysplexed. Tried to ter a utility from TSO SPUFI on a sysplex and got the message i had to route the command to the specific db2 lpar. V12 NFM mode. And if i remember correctly, I've run into a few others with the same limitation.


Thanks Myron W. Miller


________________________________
From: Olle Brostrom <[login to unmask email]>
Sent: Monday, September 11, 2017 2:56 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: routing db2 commands in batch


Hello,

This is not an issue!

All DB2 commands except –START DB2 are sysplexed! This mean that an active DB2 system recognize the command entered from any LPAR in your sysplex.

You do not have to route the command to the LPAR for the specific DB2 :)



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 10 september 2017 03:28
To: [login to unmask email]
Subject: [DB2-L] - routing db2 commands in batch



I want to route a series of DB2 commands in batch:

/-DB2A ARCHIVE LOG SCOPE(GROUP)

/-DB2A SET LOG LOGLOAD(0)

/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)

How can I run this in batch?

thanks

Bill



-----End Original Message-----

-----End Original Message-----

Ruediger Kurtz

AW: routing db2 commands in batch
(in response to Myron Miller)
Myron,

I might be wrong here, but as long as the utility is active, you have to issue the TERM-command on the lpar the utility is running on; if the utility is stopped and inactive, however, the TERM command is accepted, on whatever lpar in that sysplex it is issued.
I’ve never bothered to investigate that matter, though.

Regards

Rüdiger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Myron Miller [mailto:[login to unmask email]
Gesendet: Dienstag, 12. September 2017 21:06
An: [login to unmask email]
Betreff: [DB2-L] - RE: routing db2 commands in batch


Actually -ter utility is NOT sysplexed. Tried to ter a utility from TSO SPUFI on a sysplex and got the message i had to route the command to the specific db2 lpar. V12 NFM mode. And if i remember correctly, I've run into a few others with the same limitation.


Thanks Myron W. Miller

________________________________
From: Olle Brostrom <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, September 11, 2017 2:56 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: routing db2 commands in batch


Hello,

This is not an issue!

All DB2 commands except –START DB2 are sysplexed! This mean that an active DB2 system recognize the command entered from any LPAR in your sysplex.

You do not have to route the command to the LPAR for the specific DB2 ☺



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 10 september 2017 03:28
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - routing db2 commands in batch



I want to route a series of DB2 commands in batch:

/-DB2A ARCHIVE LOG SCOPE(GROUP)

/-DB2A SET LOG LOGLOAD(0)

/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)

How can I run this in batch?

thanks

Bill


-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

Olle Brostrom

routing db2 commands in batch
(in response to Ruediger Kurtz)
Hello,
Sorry for being unclear. The DB2 command must be entered as an MVS command, either from a console like ULOG I SDSF or in a batch job which sends the command to the internal reader.
An example of the latter case where 4 DB2 commands are sent to 4 different DB2 members on different PLARs in one job step executed on any LPAR in the SYSPLEX :

/*JOBPARM SYSAFF=ANY
//SETPROG EXEC PGM=IEBGENER
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY
//SYSUT1 DD DATA,DLM=ÅÅ
/*ÅVS,'*DB01ALTER BPOOL=BP8K2,VPSIZE=10000’
/*ÅVS,'*DB02ALTER BPOOL=BP8K2,VPSIZE=10000’
/*ÅVS,'*DB03ALTER BPOOL=BP8K2,VPSIZE=10000’
/*ÅVS,'*DB04ALTER BPOOL=BP8K2,VPSIZE=10000’
ÅÅ
//SYSUT2 DD SYSOUT=(U,INTRDR)

Best Regards

Olle Broström

From: Kurtz, Rüdiger [mailto:[login to unmask email]
Sent: den 13 september 2017 07:08
To: '[login to unmask email]'
Subject: [DB2-L] - AW: routing db2 commands in batch

Myron,

I might be wrong here, but as long as the utility is active, you have to issue the TERM-command on the lpar the utility is running on; if the utility is stopped and inactive, however, the TERM command is accepted, on whatever lpar in that sysplex it is issued.
I’ve never bothered to investigate that matter, though.

Regards

Rüdiger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon:

09561 96-44148

Telefax:

09561 96-44104

E-Mail:

[login to unmask email]<mailto:[login to unmask email]>

Internet:

www.huk.de http://www.huk.de

________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Myron Miller [mailto:[login to unmask email]
Gesendet: Dienstag, 12. September 2017 21:06
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: routing db2 commands in batch


Actually -ter utility is NOT sysplexed. Tried to ter a utility from TSO SPUFI on a sysplex and got the message i had to route the command to the specific db2 lpar. V12 NFM mode. And if i remember correctly, I've run into a few others with the same limitation.


Thanks Myron W. Miller

________________________________
From: Olle Brostrom <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, September 11, 2017 2:56 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: routing db2 commands in batch


Hello,

This is not an issue!

All DB2 commands except –START DB2 are sysplexed! This mean that an active DB2 system recognize the command entered from any LPAR in your sysplex.

You do not have to route the command to the LPAR for the specific DB2 ☺



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 10 september 2017 03:28
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - routing db2 commands in batch



I want to route a series of DB2 commands in batch:

/-DB2A ARCHIVE LOG SCOPE(GROUP)

/-DB2A SET LOG LOGLOAD(0)

/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)

How can I run this in batch?

thanks

Bill


-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

Ermanno Bertolotti

R: routing db2 commands in batch
(in response to Olle Brostrom)
In our site, we use the COMMAND statement

//* COMMAND JCL:
//* COLUMN 72 - CONTINUATION CHARACTER (ES. X)
//* COLUMN 16 - CONTINUATION IN THE NEXT LINE
//*
//CMD1 COMMAND '*DB01ALTER BPOOL=BP8K2,VPSIZE=10000’
//CMD2 COMMAND '*DB02ALTER BPOOL=BP8K2,VPSIZE=10000’
//CMD3 COMMAND '*DB03ALTER BPOOL=BP8K2,VPSIZE=10000’
//CMD4 COMMAND '*DB04ALTER BPOOL=BP8K2,VPSIZE=10000’
//*
//NULLDD EXEC PGM=IEFBR14

Another example
----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
//DB01LPR1 COMMAND 'RO LPR1,-DB01 START DB2 MSTR(''MSGCLASS=Y'') X
// DBM1(''MSGCLASS=Y'') DIST(''MSGCLASS=Y'')'
//DB02LPR2 COMMAND 'RO LPR2,-DB02 START DB2 MSTR(''MSGCLASS=Y'') X
// DBM1(''MSGCLASS=Y'') DIST(''MSGCLASS=Y'')'
//*
//NULLDD EXEC PGM=IEFBR14

From the “MVS JCL User's Guide zOS 2.1”
// COMMAND
Specifies an MVS or JES command that the system issues when the JCL is converted. Use the COMMAND statement instead of the JCL command statement

In a JES2 system,
– The JCL COMMAND statement to enter any MVS and JES commands that can be issued from the operator's console

Ermanno Bertolotti
INTESA SANPAOLO GROUP SERVICES
Direzione Sistemi Informativi – Servizio Sistemi e Infrastrutture Tecnologiche
Ufficio Progettazione e Sviluppo Infrastrutture Elaborative – Competence Center Database
Via Langhirano 1, 43125 Parma (PR)
• Phone: +39 0521 916946
• Mobile: +39 348 6723316
• Fax: +39 0521 918337
• E-mail: [login to unmask email]<mailto:[login to unmask email]> - [login to unmask email]<mailto:[login to unmask email]>
NUMERO VERDE SIT 800020202
Segui Intesa Sanpaolo su:
[ico_facebook] https://www.facebook.com/intesasanpaolo>[ico_twitter]<https://twitter.com/intesasanpaolo>[ico_youtube]<https://www.youtube.com/user/intesasanpaolo>[ico_linkeding]<https://www.linkedin.com/company/intesa-sanpaolo>[ico_instagram]<https://www.instagram.com/gallerieditalia
www.intesasanpaolo.com http://www.intesasanpaolo.com

Da: Olle Brostrom [mailto:[login to unmask email]
Inviato: mercoledì 13 settembre 2017 09:01
A: [login to unmask email]
Oggetto: [DB2-L] - RE: routing db2 commands in batch

Hello,
Sorry for being unclear. The DB2 command must be entered as an MVS command, either from a console like ULOG I SDSF or in a batch job which sends the command to the internal reader.
An example of the latter case where 4 DB2 commands are sent to 4 different DB2 members on different PLARs in one job step executed on any LPAR in the SYSPLEX :

/*JOBPARM SYSAFF=ANY
//SETPROG EXEC PGM=IEBGENER
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY
//SYSUT1 DD DATA,DLM=ÅÅ
/*ÅVS,'*DB01ALTER BPOOL=BP8K2,VPSIZE=10000’
/*ÅVS,'*DB02ALTER BPOOL=BP8K2,VPSIZE=10000’
/*ÅVS,'*DB03ALTER BPOOL=BP8K2,VPSIZE=10000’
/*ÅVS,'*DB04ALTER BPOOL=BP8K2,VPSIZE=10000’
ÅÅ
//SYSUT2 DD SYSOUT=(U,INTRDR)

Best Regards

Olle Broström

From: Kurtz, Rüdiger [mailto:[login to unmask email]
Sent: den 13 september 2017 07:08
To: '[login to unmask email]'
Subject: [DB2-L] - AW: routing db2 commands in batch

Myron,

I might be wrong here, but as long as the utility is active, you have to issue the TERM-command on the lpar the utility is running on; if the utility is stopped and inactive, however, the TERM command is accepted, on whatever lpar in that sysplex it is issued.
I’ve never bothered to investigate that matter, though.

Regards

Rüdiger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon:

09561 96-44148

Telefax:

09561 96-44104

E-Mail:

[login to unmask email]<mailto:[login to unmask email]>

Internet:

www.huk.de http://www.huk.de

________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Myron Miller [mailto:[login to unmask email]
Gesendet: Dienstag, 12. September 2017 21:06
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: routing db2 commands in batch


Actually -ter utility is NOT sysplexed. Tried to ter a utility from TSO SPUFI on a sysplex and got the message i had to route the command to the specific db2 lpar. V12 NFM mode. And if i remember correctly, I've run into a few others with the same limitation.


Thanks Myron W. Miller

________________________________
From: Olle Brostrom <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Monday, September 11, 2017 2:56 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: routing db2 commands in batch


Hello,

This is not an issue!

All DB2 commands except –START DB2 are sysplexed! This mean that an active DB2 system recognize the command entered from any LPAR in your sysplex.

You do not have to route the command to the LPAR for the specific DB2 ☺



Best Regards



Olle Broström



From: william giannelli [mailto:[login to unmask email]
Sent: den 10 september 2017 03:28
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - routing db2 commands in batch



I want to route a series of DB2 commands in batch:

/-DB2A ARCHIVE LOG SCOPE(GROUP)

/-DB2A SET LOG LOGLOAD(0)

/ROUTE SYS2,-DB2B SET LOG LOGLOAD(0)

How can I run this in batch?

thanks

Bill


-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----

-----End Original Message-----


Prima di stampare, pensa all'ambiente ** Think about the environment before printing

________________________________

Il presente messaggio, inclusi gli eventuali allegati, ha natura aziendale e potrebbe contenere informazioni confidenziali e/o riservate. Chiunque lo ricevesse per errore, è pregato di avvisare tempestivamente il mittente e di cancellarlo.
E’ strettamente vietata qualsiasi forma di utilizzo, riproduzione o diffusione non autorizzata del contenuto di questo messaggio o di parte di esso.
Pur essendo state assunte le dovute precauzioni per ridurre al minimo il rischio di trasmissione di virus, si suggerisce di effettuare gli opportuni controlli sui documenti allegati al presente messaggio. Non si assume alcuna responsabilità per eventuali danni o perdite derivanti dalla presenza di virus.

Per lo svolgimento delle attività di investimento nel Regno Unito, la società è autorizzata da Banca d'Italia ed è soggetta alla vigilanza limitata della Financial Conduct Authority ( FCA ) e della Prudential Regulation Authority ( PRA ) . Maggiori informazioni in merito ai poteri di vigilanza della Financial Conduct Authority ( FCA ) e della Prudential Regulation Authority ( PRA ) sono a disposizione previa richiesta.

Nel Regno Unito Intesa Sanpaolo S.p.A. opera attraverso la filiale di Londra, sita in 90 Queen Street, London EC4N 1SA, registrata in Inghilterra & Galles sotto No.FC016201, Branch No.BR000036

In osservanza dei requisito imposti dal Internal Revenue Service (Agenzia delle Entrate degli Stati Uniti), qualunque discussione relativa a temi di natura fiscale contenuta in questo messaggio o nei suoi allegati non e’ intesa ne’ e’ stata scritta per essere utilizzata, ne’ puo’ essere utilizata per (i) evitare l’imposizione di gravami fiscali secondo il codice tributario vigente negli Stati Uniti o (ii) per promuovere, sollecitare o raccomandare una operazione finanziaria o altra transazione indirizzata ad un altro destinatario.

Nella Repubblica d’Irlanda, Intesa Sanpaolo Bank Ireland plc è regolamentata dalla Banca Centrale d’Irlanda ed è parte del Gruppo Bancario Intesa Sanpaolo S.p.A. Registrata in Irlanda come società numero 125216 – IVA Reg. IE4817418C IE, sita in 2nd Floor, International House, 3 Harbourmaster Place, IFSC, Dublino 1, D01 K8F1, Irlanda.

***

________________________________

This email (including any attachment) is a corporate message and may contain confidential and/or privileged and/or proprietary information. If you have received this email in error, please notify the sender immediately, do not use or share it and destroy this email. Any unauthorised use, copying or disclosure of the material in this email or of parts hereof (including reliance thereon) is strictly forbidden.
We have taken precautions to minimize the risk of transmitting software viruses but nevertheless advise you to carry out your own virus checks on any attachment of this message. We accept no liability for loss or damage caused by software viruses.

For the conduct of investment business in the UK, the Company is authorised by Banca d’Italia and subject to limited regulation in the UK by the Financial Conduct Authority ( FCA ) and the Prudential Regulation Authority ( PRA ). Details about the extent of our regulation by the Financial Conduct Authority ( FCA ) and the Prudential Regulation Authority ( PRA ) are available from us on request.

In the UK Intesa Sanpaolo S.p.A. operates through its London Branch, located at 90 Queen Street, London EC4N 1SA. Registered in England & Wales under No.FC016201, Branch No.BR000036

To comply with requirements imposed by the IRS, we inform you that any discussion of U.S. federal tax issues contained herein (including any attachments) was not intended or written to be used, and cannot be used by you, for the purpose of (i) avoiding penalties under the Internal Revenue Code or (ii) promoting, marketing or recommending any transaction or matter addressed herein to another party.

In the Republic of Ireland, Intesa Sanpaolo Bank Ireland plc is regulated by the Central Bank of Ireland and is a member of the Intesa Sanpaolo Group. It is registered in Ireland as company no.125216 – VAT Reg. No. IE 4817418C and located at 2nd Floor, International House, 3 Harbourmaster Place, IFSC, Dublin 1, D01 K8F1, Ireland.
Attachments

  • image001.gif (<1k)
  • image002.gif (<1k)
  • image003.gif (<1k)
  • image004.gif (<1k)
  • image005.gif (1k)