RE: Library List used by FTP job -- MIDRANGE-L

Doug,

INLLIBL list is a snap, initially, but it is going to cause you (and
potentially others) lots of grief in the long run.  

An FTP server program by default is re-used 200 times by up to 200
different users.  The chances of all 200 uses needing the same library
list for each ftp is pretty slim, and the chances of you stepping on
someone else is pretty high.  

If you were to change QTCP's JOBD (QDFTJOBD) to include your library,
you will be affecting hundreds of IBM initiated jobs on the system.  Now
all of these jobs (and all of their user's) are going to have to have at
least *USE authority to your application library in order to even start.
If anyone ever secures your library, or accidentally deletes it, or
takes an exclusive lock out on it during a Save operation, you break all
kinds of system stuff and potentially prevent access to the system
(because QDFTJOBD is QSECOFR's JOBD too).

You're far better off to write a little code to manage the library list
on your own.  If you need some tips, I'd be happy to have someone send
you some code snippets.

(Not that this scares me - we've already shielded ourselves from these
kinds of things - it's just the right thing to do).

jte


--
John Earl | Chief Technology Officer
The PowerTech Group
19426 68th Ave. S
Seattle, WA 98032
(253) 872-7788 ext. 302
john.earl@xxxxxxxxxxxxx
www.powertech.com 
 

 
This email message and any attachments are intended only for the use of
the intended recipients and may contain information that is privileged
and confidential. If you are not the intended recipient, any
dissemination, distribution, or copying is strictly prohibited. If you
received this email message in error, please immediately notify the
sender by replying to this email message, or by telephone, and delete
the message from your email system.
--

> -----Original Message-----
> From: midrange-l-
> bounces+john.earl=powertech.com@xxxxxxxxxxxx
> [mailto:midrange-l-
> bounces+john.earl=powertech.com@xxxxxxxxxxxx] On Behalf Of
> Doug_McLauchlan@xxxxxxxxxx
> Sent: Thursday, November 03, 2005 3:18 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Library List used by FTP job
> 
> Thanks for this.
> 
> It looks from the replies here and elsewhere that there is
> no fix for this
> problem, only many different workarounds !
> 
> I have used this idea since it involved the least amount
> of coding and is
> adaptable to use in other situations - we do have BPCS
> here, so using
> INLIBL to set the library list is a snap.
> 
> Thanks again.
> 
> 
> Doug McLauchlan
> Planar Systems, Inc.
> 
> 
> 
> 
> rob@xxxxxxxxx
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 11/03/2005 08:00 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-
> l@xxxxxxxxxxxx>
> 
> 
> To
> Midrange Systems Technical Discussion <midrange-
> l@xxxxxxxxxxxx>
> cc
> 
> Subject
> Re: Library List used by FTP job
> 
> 
> 
> 
> 
> 
> Modify the trigger to set up it's library list.
> Traditionally that is
> done by analyzing the trigger buffer to determine what
> library the file is
> 
> in that is triggered.  Then adding that library to the
> library list.  Some
> 
> applications will have a file or dataarea in that file
> library that
> contains other libraries to add (like BPCS INLIBL data
> area).  You may
> need to add these also if the trigger is dependent on it.
> 
> Many analysts design triggers "assuming" that they'll only
> be called from
> existing 5250 programs that have the library list already
> set up.  This is
> 
> called stepping on your winkie.
> 
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> Doug_McLauchlan@xxxxxxxxxx
> Sent by: midrange-l-bounces+rob=dekko.com@xxxxxxxxxxxx
> 11/02/2005 06:59 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-
> l@xxxxxxxxxxxx>
> 
> 
> To
> midrange-l@xxxxxxxxxxxx
> cc
> 
> Fax to
> 
> Subject
> Library List used by FTP job
> 
> 
> 
> 
> 
> 
> I am attempting to FTP some data to a table on our iSeries
> using a
> specific USERID to make the connection.
> 
> The table has an *AFTER *INSERT trigger which calls a
> series of programs
> to process the data.
> 
> I keep getting an error that the programs called by the
> trigger program
> cannot be found in the library list of the FTP job.
> 
> USERID has a specific JOBD that includes all the necessary
> libraries, but
> the FTP job seems determined not to look at that, but use
> the library list
> 
> 
> from the QTCP user.
> 
> I don't want to change the QTCP JOBD as this is not
> environment specific -
> 
> 
> I need to be able to send the data to TEST / PROD etc.
> 
> 
> How do I make the FTP job use the libraries specified for
> my USERID rather
> 
> 
> than QTCP ?
> 
> 
> Thanks.
> 
> 
> Doug McLauchlan
> 
> Planar Systems, Inc.
> 
> 
> __________________________________________________________
> ____________
> This e-mail has been scanned by MCI Managed Email Content
> Service, using
> Skeptic(tm) technology powered by MessageLabs. For more
> information on
> MCI's Managed Email  Content Service, visit
> http://www.mci.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:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> --
> 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:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> __________________________________________________________
> ____________
> This e-mail has been scanned by MCI Managed Email Content
> Service, using
> Skeptic(tm) technology powered by MessageLabs. For more
> information on
> MCI's Managed Email Content Service, visit
> http://www.mci.com.
> __________________________________________________________
> ____________
> 
> 
> 
> __________________________________________________________
> ____________
> This e-mail has been scanned by MCI Managed Email Content
> Service, using Skeptic(tm) technology powered by
> MessageLabs. For more information on MCI's Managed Email
> Content Service, visit http://www.mci.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:
> http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
>