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
-------------- Original message --------------
From: Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>
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
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 :-)
--- midrange-l-request@xxxxxxxxxxxx wrote:
date: Mon, 20 Nov 2006 17:31:06 +0000
subject: Re: Re: Saving multiple source files to a single
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.
IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions
Mortgage rates near 39yr lows.
$310k for $999/mo. Calculate new payment!
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives