|
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.
midrange.com
* 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 thatresidesin an earlier library on the library list Alan Shore -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailinglistTo 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.
As an Amazon Associate we earn from qualifying purchases.
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.
