Re: SYSLIBL for a SUB System

Mohammad:

I sent a note about using a routing program a moment ago. Now you're
adding
the need to use it for JDBC/ODBC. (That information would have been nice
to
have up front)

Now the best option for a systemic fix is to use the same technique I
explained in my earlier post, but rather use an exit program on the
supplied
exit points for starting the connection. In that exit program use the
CHGSYSLIBL command as discussed earlier and the job should have the correct
library list.

That program could even choose which users or connections to make the
change
in the job so some users would get the change and others would not.


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Mohammad Tanveer
Sent: Friday, August 24, 2018 9:53 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: SYSLIBL for a SUB System

CHGSYSLIBL .. Yeah it looks like we could have used it too for current
thread. But my issue .right now is to for JDBC/ODBC jobs.

On Fri, Aug 24, 2018 at 9:48 AM Mohammad Tanveer <surgum@xxxxxxxxx> wrote:

I thought CHGSYSLIBL will change it for the entire system? We only
needed to add/remove for a job.

On Fri, Aug 24, 2018 at 9:42 AM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

You don't need a TAA Tool...

Change System Library List - Help

The Change System Library List (CHGSYSLIBL) command changes the
system portion of the library list for the current thread. You can
specify if the library is added to the beginning of the system
portion of the library list, or removed from the system portion of
the library list.

Charles


On Fri, Aug 24, 2018 at 8:38 AM Mohammad Tanveer <surgum@xxxxxxxxx>
wrote:

Issue is SYSLIBL was setup by native people ages ago and they added
some libraries in it which were not supposed to be in it. Now we
cannot

change

it but there is a need to remove them; for setting up a new
environment (without creating a new partition)

We took care of it for green screen sessions by using TAATOOL
command to remove libraries from SYSLIBL.

For JDBC/ODBC connections we are thinking to write some database
exit programs to do the same but was wondering if there is a
better/easy way

at

SBS level, meaning whenever a user makes a connection they will be

assigned

a different SBS and in that subsystem we can have a different SYSLIBL.

Regards






On Fri, Aug 24, 2018 at 9:26 AM Rob Berendt <rob@xxxxxxxxx> wrote:

SYSLIBL is system wide.
USRLIBL is what you'll have to use. Or set up a job description
for

jobs

in that subsystem.

Now, if you want to spin up a new partition of IBM i and have the

whole

subsystem run in that, that is a different story.


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: "Mohammad Tanveer" <surgum@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <

midrange-l@xxxxxxxxxxxx

Date: 08/24/2018 10:09 AM
Subject: SYSLIBL for a SUB System
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Can we have a different SYSLIBL for a SBS? We are creating a new
SBS

and

wondering if we can specify a different SYSLIBL for its jobs.

Regards
--
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


--
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

--
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

--
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

--
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

--
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