× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 2018

RE: MIDRANGE-L Digest, Vol 17, Issue 1522

Jim,

Part of the problem with using IP addresses is that sometimes there are devices in the network that "hide" the true IP address from the system. Quite some time ago our company made the decision to install an Alteon traffic consolidation device (before I was here). It maps the system's IP address to a different IP address. Then if we have an outage they just change the system IP address the Alteon is pointing to and no clients need to be changed. That's what comes from having someone setup a network when they don't understand DNS. What it also does is make it look like every connection to my system looks like it is coming from a single IP address, that of the Alteon device.

I've been looking at setting up secure ODBC traffic also and can't because of this.

Respectfully,
Kendall Kinnear
System Analyst
Standard Motor Products, Inc.
Work: 972-316-8169
Mobile: 940-293-7541

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Oberholtzer
Sent: Monday, August 13, 2018 11:13 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: MIDRANGE-L Digest, Vol 17, Issue 1522

As Dawn pointed out, there is not a way to separate that traffic currently. You could use routing or exit programs If you have an idea what IP addresses might be used, I've done that, but you also indicate the inability or desire to use much in the way of work management

Your best bet is that RFE.

Jim Oberholtzer
Agile Technology Architects



On Aug 13, 2018, at 10:41 AM, Russell Kasbaum <rkasbaum@xxxxxxxxxxx> wrote:

Jim,

Your method looks to me like you're simply replacing QUSRWRK with a user defined subsystem is not the path I can go down. Maybe a clearer explanation is in order.

What happens

PC1 ---------------|
| -------(SSL/TLS
connection)----ODBC/JDBC---- iSeries1 ---- QUSRWRK / QRWTSRVTR (skips
the job queue and routing entries)
WebSpere1-------|

What I need to happen

PC1 ---------------|
| -------(SSL/TLS
connection)----ODBC/JDBC---- iSeries1 --- Route to(based on user
profile) to--- User defined subsystem / QRWTSRVTR
WebSpere1-------|



-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of
midrange-l-request@xxxxxxxxxxxx
Sent: Monday, August 13, 2018 8:03 AM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 17, Issue 1522

Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit

https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvd
pgSg2F5s_ItiizBDE&s=9SCVhHxHB41_mGFHeiqj2mpvteKCfScaxDk1NzcmfI0&e=
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than "Re: Contents of MIDRANGE-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

1. Re: SBS/CMN routing (Jim Oberholtzer)
2. RE: System Auto Reply List (Jim Hawkins)
3. Re: System Auto Reply List (Rich Loeber)
4. Re: System Auto Reply List (Rob Berendt)
5. RE: System Auto Reply List (Flensburg, Carsten)
6. Re: System Auto Reply List (Rich Loeber)
7. Re: SBS/CMN routing (Dawn May)


----------------------------------------------------------------------

message: 1
date: Sun, 12 Aug 2018 12:42:07 -0500
from: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
subject: Re: SBS/CMN routing

Russel:

You'll have to create your subsystem, and include in it all the prestart jobs you need in the new subsystem. You'll have to remove the prestart jobs from the old subsystem. (presumably QUSRWRK and QSYSWRK.

Make sure to assign new memory (don't use *BASE) to them and on the class entry specify that new memory pool.

In the archives somewhere I have listed all the steps needed to do
this, (perhaps I should put them in the Wiki too)

I'm working today so I should see email to the list .

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects

On Sun, Aug 12, 2018 at 9:44 AM, Russell Kasbaum
<rkasbaum@xxxxxxxxxxx>
wrote:

I need to route my incoming ODBC/JDBC traffic to a specific subsystem
and that subsystems QRWTSRVR jobs. I tried
QSYS2.SET_SERVER_SBS_ROUTING but that only works on non-secure
traffic and I need a solution that works for secure traffic (SSL/TLS) can anyone help me?


Regards,



Russell Kasbaum
Mobile: (206) 859-7906
Email: rkasbaum@xxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.c
om_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=
pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANc
mvdpgSg2F5s_ItiizBDE&s=9SCVhHxHB41_mGFHeiqj2mpvteKCfScaxDk1NzcmfI0&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=RWGzJdoxqBuuRH9XyxMIWoxC-LP8pDui5tMhW9LEtZ4&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d
=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92e
fsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=riBJLGQUs9r
r5mg2Jpe6a9FbicwQAmtyn_IBWskRIb0&e=



------------------------------

message: 2
date: Mon, 13 Aug 2018 08:15:38 -0400
from: "Jim Hawkins" <jhawkins@xxxxxxxxxxxx>
subject: RE: System Auto Reply List

WRKRPYLE output(*print) Then convert the spool file to a physical file.
Process the physical file. Not elegant, but it should work.

Regards,

Jim Hawkins
Programmer Analyst
Interkal LLC
Kalamazoo, MI
Subject: System Auto Reply List

Does anyone know how to programmatically retrieve the current contents of
the system reply list? Where is it stored? Is there an API that will
retrieve it? I know I can generate a listing and then read the spool file
but that's a bit too old school for me now.

Rich Loeber
Kisco Information Systems

[1]https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com&d
=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92ef
sKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=_QfxpHv3wet_O
5sX0rqMpc7ddteVcHtkQtmrXwwJJ7M&e=




------------------------------

message: 3
date: Mon, 13 Aug 2018 09:29:09 -0400
from: Rich Loeber <rich@xxxxxxxxx>
subject: Re: System Auto Reply List

Thanks Roger - This pointed me to the fact that there is an LF in QSYS2
named REPYLIST that I can either read or, more safely, CPYF to my own PF
and then read. More elegant that reading a spool file. Thanks for the
pointer.

Rich Loeber - @richloeber
Kisco Information Systems

[1]https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com&d
=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92ef
sKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=_QfxpHv3wet_O
5sX0rqMpc7ddteVcHtkQtmrXwwJJ7M&e=


----------------------------------------------------------------------
----

On 8/11/2018 5:11 PM, Roger Harman wrote:

Looks like there is a DB2 service for it...
[2]https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_su
pport_knowledgecenter_en_ssw-5Fibm-5Fi-5F72_rzajq_rzajqviewreplylistin
fo.htm&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zL
gOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=BEHDy
ZX0_y2BAUYY-4P7swqTSibHg-4iFBuT614Qc7o&e=


-----Original Message-----
From: MIDRANGE-L [[3]mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
Of Rich Loeber
Sent: Saturday, August 11, 2018 9:15 AM
To: Midrange Systems Technical Discussion
Subject: System Auto Reply List

Does anyone know how to programmatically retrieve the current contents of
the system reply list? Where is it stored? Is there an API that will
retrieve it? I know I can generate a listing and then read the spool file
but that's a bit too old school for me now.

Rich Loeber
Kisco Information Systems

[1][4]https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.co
m&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ9
2efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=_QfxpHv3we
t_O5sX0rqMpc7ddteVcHtkQtmrXwwJJ7M&e=

References

Visible links
1.
[5]https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com_&;
d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92e
fsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=Jd-VaI5rJRIL
dZPmo6i8O0_mEuzegShwDSJ5JnFAQsM&e=

References

Visible links
1. https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com_&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=Jd-VaI5rJRILdZPmo6i8O0_mEuzegShwDSJ5JnFAQsM&e=
2. https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_knowledgecenter_en_ssw-5Fibm-5Fi-5F72_rzajq_rzajqviewreplylistinfo.htm&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=BEHDyZX0_y2BAUYY-4P7swqTSibHg-4iFBuT614Qc7o&e=
3. mailto:midrange-l-bounces@xxxxxxxxxxxx
4. https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com_&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=Jd-VaI5rJRILdZPmo6i8O0_mEuzegShwDSJ5JnFAQsM&e=
5.
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com_&d=D
wICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsK
AWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=Jd-VaI5rJRILdZP
mo6i8O0_mEuzegShwDSJ5JnFAQsM&e=


------------------------------

message: 4
date: Mon, 13 Aug 2018 09:46:12 -0400
from: Rob Berendt <rob@xxxxxxxxx>
subject: Re: System Auto Reply List

Let me guess, the point of copying it to your own PF is to avoid coding SQL in your programs and, if one just has to stick with RLA, avoid level checks?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dekko.com&d=Dw
ICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKA
WQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=AgGvtK6A7FTLQZqP
lKuI2eymagYIw6TobeWPRDFYTpQ&e=





From: "Rich Loeber" <rich@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 08/13/2018 09:29 AM
Subject: Re: System Auto Reply List
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Thanks Roger - This pointed me to the fact that there is an LF in QSYS2
named REPYLIST that I can either read or, more safely, CPYF to my
own PF
and then read. More elegant that reading a spool file. Thanks for the
pointer.

Rich Loeber - @richloeber
Kisco Information Systems

[1]https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com&d
=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92ef
sKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=_QfxpHv3wet_O
5sX0rqMpc7ddteVcHtkQtmrXwwJJ7M&e=


----------------------------------------------------------------------
----

On 8/11/2018 5:11 PM, Roger Harman wrote:

Looks like there is a DB2 service for it...
[2]
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_suppo
rt_knowledgecenter_en_ssw-5Fibm-5Fi-5F72_rzajq_rzajqviewreplylistinfo.
htm&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOp
Z92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=BEHDyZX0
_y2BAUYY-4P7swqTSibHg-4iFBuT614Qc7o&e=



-----Original Message-----
From: MIDRANGE-L [[3]mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
Of Rich Loeber
Sent: Saturday, August 11, 2018 9:15 AM
To: Midrange Systems Technical Discussion
Subject: System Auto Reply List

Does anyone know how to programmatically retrieve the current
contents of
the system reply list? Where is it stored? Is there an API that will
retrieve it? I know I can generate a listing and then read the
spool file
but that's a bit too old school for me now.

Rich Loeber
Kisco Information Systems

[1][4]https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.co
m&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ9
2efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=_QfxpHv3we
t_O5sX0rqMpc7ddteVcHtkQtmrXwwJJ7M&e=

References

Visible links
1.
[5]https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com_&;
d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92e
fsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=Jd-VaI5rJRIL
dZPmo6i8O0_mEuzegShwDSJ5JnFAQsM&e=

References

Visible links
1. https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com_&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=Jd-VaI5rJRILdZPmo6i8O0_mEuzegShwDSJ5JnFAQsM&e=
2.
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_suppo
rt_knowledgecenter_en_ssw-5Fibm-5Fi-5F72_rzajq_rzajqviewreplylistinfo.
htm&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOp
Z92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=BEHDyZX0
_y2BAUYY-4P7swqTSibHg-4iFBuT614Qc7o&e=

3. mailto:midrange-l-bounces@xxxxxxxxxxxx
4. https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com_&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=Jd-VaI5rJRILdZPmo6i8O0_mEuzegShwDSJ5JnFAQsM&e=
5.
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.kisco.com_&d=D
wICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsK
AWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=Jd-VaI5rJRILdZP
mo6i8O0_mEuzegShwDSJ5JnFAQsM&e=
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvd
pgSg2F5s_ItiizBDE&s=9SCVhHxHB41_mGFHeiqj2mpvteKCfScaxDk1NzcmfI0&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=RWGzJdoxqBuuRH9XyxMIWoxC-LP8pDui5tMhW9LEtZ4&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efs
KAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=riBJLGQUs9rr5m
g2Jpe6a9FbicwQAmtyn_IBWskRIb0&e=




------------------------------

message: 5
date: Mon, 13 Aug 2018 13:52:10 +0000
from: "Flensburg, Carsten" <Flensburg@xxxxxxxxxx>
subject: RE: System Auto Reply List

Hello Rich,

You could also use the SQL CLI APIs to retrieve the system reply list info - the CLI APIs do not require the SQL Development Kit licensed product. I've written an RPG/IV wrapper that does just that an then return the system reply list information as a simple data structure array. If you want a copy, please let me know.

Cheers,
Carsten

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Rich Loeber
Sent: 13. august 2018 15:29
To: Midrange Systems Technical Discussion
Subject: Re: System Auto Reply List

Thanks Roger - This pointed me to the fact that there is an LF in QSYS2
named REPYLIST that I can either read or, more safely, CPYF to my own PF
and then read. More elegant that reading a spool file. Thanks for the
pointer.


------------------------------

message: 6
date: Mon, 13 Aug 2018 11:02:02 -0400
from: Rich Loeber <rich@xxxxxxxxx>
subject: Re: System Auto Reply List

Rob,

That is the thinking although there is a text field in the file that is
coded in UCS2 or Unicode that could end up presenting a complication to my
"simple" solution.

Rich


----------------------------------------------------------------------
----

On 8/13/2018 9:46 AM, Rob Berendt wrote:

Let me guess, the point of copying it to your own PF is to avoid
coding SQL in your programs and, if one just has to stick with RLA,
avoid level checks?


Rob Berendt


------------------------------

message: 7
date: Mon, 13 Aug 2018 15:02:25 +0000
from: Dawn May <DawnMayiCan@xxxxxxxxxxx>
subject: Re: SBS/CMN routing

IBM does not support the ability to route work by user profile for secure connections.

There is an open RFE requesting SSL/TLS support for SET_SERVER_SBS_ROUTING.
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_devel
operworks_rfe_execute-3Fuse-5Fcase-3DviewRfe-26CR-5FID-3D97989&d=DwICA
g&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQM
BM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=rJVLuoLHRnj4UpwCFMO
iZhDF6hmFS2FkTbreg3IYuUY&e=

You can also route work for ODBC/JDBC traffic (including secure connections) by IP address.

I just wrote a blog this topic -
https://urldefense.proofpoint.com/v2/url?u=http-3A__ibmsystemsmag.com_
blogs_i-2Dcan_august-2D2018_subsystem-2Dconfiguration-2Dfor-2Dprestart
-2Djobs_&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-
zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=OGT
xWchr3Du638PQMZzpls55GHK6LmfbgyuKn-lPAqk&e=



Dawn

Dawn May Consulting, LLC

________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of
Russell Kasbaum <rkasbaum@xxxxxxxxxxx>
Sent: Sunday, August 12, 2018 10:44 AM
To: Midrange-L (midrange-l@xxxxxxxxxxxx)
Subject: SBS/CMN routing

I need to route my incoming ODBC/JDBC traffic to a specific subsystem and that subsystems QRWTSRVR jobs. I tried QSYS2.SET_SERVER_SBS_ROUTING but that only works on non-secure traffic and I need a solution that works for secure traffic (SSL/TLS) can anyone help me?


Regards,



Russell Kasbaum
Mobile: (206) 859-7906
Email: rkasbaum@xxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvd
pgSg2F5s_ItiizBDE&s=9SCVhHxHB41_mGFHeiqj2mpvteKCfScaxDk1NzcmfI0&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=RWGzJdoxqBuuRH9XyxMIWoxC-LP8pDui5tMhW9LEtZ4&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efs
KAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=riBJLGQUs9rr5m
g2Jpe6a9FbicwQAmtyn_IBWskRIb0&e=


------------------------------

Subject: Digest Footer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvd
pgSg2F5s_ItiizBDE&s=9SCVhHxHB41_mGFHeiqj2mpvteKCfScaxDk1NzcmfI0&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=RWGzJdoxqBuuRH9XyxMIWoxC-LP8pDui5tMhW9LEtZ4&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efs
KAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=riBJLGQUs9rr5m
g2Jpe6a9FbicwQAmtyn_IBWskRIb0&e=

------------------------------

End of MIDRANGE-L Digest, Vol 17, Issue 1522
********************************************
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pO
vNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvd
pgSg2F5s_ItiizBDE&s=9SCVhHxHB41_mGFHeiqj2mpvteKCfScaxDk1NzcmfI0&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=RWGzJdoxqBuuRH9XyxMIWoxC-LP8pDui5tMhW9LEtZ4&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efs
KAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=riBJLGQUs9rr5m
g2Jpe6a9FbicwQAmtyn_IBWskRIb0&e=
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=9SCVhHxHB41_mGFHeiqj2mpvteKCfScaxDk1NzcmfI0&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=RWGzJdoxqBuuRH9XyxMIWoxC-LP8pDui5tMhW9LEtZ4&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwICAg&c=CBjl-DmyMmSeXzqzAOY98w&r=pOvNBD1fQ8EIsnWxCJIvLGGO-zLgOpZ92efsKAWQMBM&m=CIe0O-rx5yISwdAyA5rmANcmvdpgSg2F5s_ItiizBDE&s=riBJLGQUs9rr5mg2Jpe6a9FbicwQAmtyn_IBWskRIb0&e=
________________________________

Please consider the environment before printing this email.

The content of this e-mail (including any attached files) is confidential and may be privileged and protected by law. It is intended solely for the purpose of the person to whom it is addressed. If you are not the intended recipient of this message, please notify the sender immediately and delete the message (inclusive of any attached files). In addition, if you are not the intended recipient of this message, any disclosure, copying, distribution or taking any action in reliance of the contents of this email is strictly prohibited.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.