× 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

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://lists.midrange.com/mailman/listinfo/midrange-l
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD



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

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]http://www.kisco.com




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

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]http://www.kisco.com

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

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

Looks like there is a DB2 service for it...
[2]https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqviewreplylistinfo.htm


-----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]http://www.kisco.com

References

Visible links
1. [5]http://www.kisco.com/

References

Visible links
1. http://www.kisco.com/
2. https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqviewreplylistinfo.htm
3. mailto:midrange-l-bounces@xxxxxxxxxxxx
4. http://www.kisco.com/
5. http://www.kisco.com/


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

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
http://www.dekko.com





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]http://www.kisco.com


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

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

Looks like there is a DB2 service for it...
[2]
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqviewreplylistinfo.htm



-----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]http://www.kisco.com

References

Visible links
1. [5]http://www.kisco.com/

References

Visible links
1. http://www.kisco.com/
2.
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqviewreplylistinfo.htm

3. mailto:midrange-l-bounces@xxxxxxxxxxxx
4. http://www.kisco.com/
5. http://www.kisco.com/
--
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD




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

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://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=97989

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

I just wrote a blog this topic -
http://ibmsystemsmag.com/blogs/i-can/august-2018/subsystem-configuration-for-prestart-jobs/



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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD


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

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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD

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

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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD

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.