Re: Creating a physical AND Logical file

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Alan,

Is QTEMP lower in the library list than the Production library?  That's 
really a rhetorical question since the LF is being created over the 
Production file.

What Elvis was trying to say was, unless the library is specified in the 
LF's DDS (such as R HSTLINR                   PFILE(HISTORY/HSTLIN) ), 
the LF will be created over the first *File object by the name of the 
PFILE( ) that it finds.  If the library is coded in the PFILE( ) 
statement, the library list is irrelevant (i.e., will not be used).  So 
Elvis was suggesting putting QTEMP at the top of your system library 
list (which would have been the effect if it had not already existed in 
the library list somewhere - system or user portion).  I know this 
works; did it last week on a project and again this morning on another one.


So the issue, in brief, is to get QTEMP ahead of the Production 
library.  There are a myriad of ways to do this and things to consider, 
not least of which is the state of the library list when the process 
ends.  If you use RMVLIBLE QTEMP before doing a CHGSYSLIBL or an 
ADDLIBLE, you won't get the error you mentioned. 


Audit is audit and no getting around that, as you say.  I am curious, 
though, how one audits QTEMP regardless of the method used to create the 
table?  I was led to believe that even the NSA would have a fit 
retrieving stuff from there once the job ends.


        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Alan Shore wrote:
> Sorry Elvis  - this wont work
> with the command
> CHGSYSLIBL QTEMP *ADD
> the error message is
> Library QTEMP already exists in library list.
>
>
> Alan Shore
>
> NBTY, Inc
> (631) 244-2000 ext. 5019
> AShore@xxxxxxxx
>
>
> midrange-l-bounces@xxxxxxxxxxxx wrote on 01/11/2007 02:34:19 PM:
>
>   
> > CHGSYSLIBL QTEMP *ADD
> > ... create your LFs ....
> > CHGSYSLIBL QTEMP *REMOVE
> >
> > Celebrating 10-Years of SQL Performance Excellence
> >
> > -----Original Message-----
> > Subject: RE: Creating a physical AND Logical file
> >
> > Thanks Nick, but unfortunately that picks up the physical file that
> >     
> resides
>   
> > in an earlier library on the library list
> >
> > Alan Shore
> >
> >
> > --
> > 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.
> >
> >