LOL Luis - it is hard to be so powerful, isn't it? I see you with your red cape
and the big S for Superuser on your chest! Make that lowercase big s for
superuser.
-------------- Original message --------------
From: Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>
Vern,
You are right in stating that it is better to use the views
(either IBM's or defined by you).
AFAIK, the reason IBM tells you not to use the files
directly is not because of performance. If that would be
the case, the views would be off-limits too.
As I remember, the main reasons giving for not using these
files directly are:
1) The files are restricted (security privileges) for use
of the Security Officer only. The views don't have this
restriction.
2) The format of the files can (and do) change with each
release and/or DB2 update, so it is better to have a view
with a format that you know.
My problem is that I am the Sec officer for our 520, so I
tend to overlook this kind of things :-)
Regards,
Luis Rodriguez
--- midrange-l-request@xxxxxxxxxxxx wrote:
------------------------------
message: 6
date: Mon, 20 Nov 2006 17:31:06 +0000
from: vhamberg@xxxxxxxxxxx
subject: Re: Re: Saving multiple source files to a single
save
Well, first, because IBM says not to. They say to go
through the views in QSYS2. The QADB* files are used by
the system so much, I guess. And maybe it is OK to make
other views over these files. So if there are other ways
to get the same info, I go the other way.
Cheers
Vern
Luis Rodriguez
IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions
________________________________________________________________________________
____
Sponsored Link
Mortgage rates near 39yr lows.
$310k for $999/mo. Calculate new payment!
www.LowerMyBills.com/lre
--
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.
