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 :-) 


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 

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. 


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! 
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 

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page