Re: DB2 table vs Physical files

[Loyd Goodbar <loyd@xxxxxxxxxxxxxx>]

One thing to keep in mind is that SQL defined tables (create collection and
create table) get "automatic" journaling for transaction integrity. If you
define your own physical files (crtpf), you must journal them if you wish to
perform true transactions against them (begin/end transaction, commit,
rollback).

Loyd

On Wed, 12 May 2004 09:19:56 -0400, "Lokesh Gupta" <Lokesh.Gupta@xxxxxxxxxx>
wrote:

>Hi,
>I used to work with Physical Files (PF)  and this is first time when I may 
>have to work
>with DB2 tables. I need to pull data from As400 to windows environment (this 
>could be
>.net or Java) over ODBC and I have an option to use physical files or DB2 
>tables. 
>My question is (1) which option would be better for performance pov PF or DB2 
>tables. 
>I do not need to join lot of tables, it is just couple of tables and a simple 
>query. 
>I do not see any difference from windows side to access the data.
>
>Secondly, Is there any data conversion involved (db2 or PF) as I am pulling 
>data 
>from AS400 to Windows, if yes, how will that affect the performance.
>
>
>regards,
>Lokesh

--  
"Don't need therpay, all better now!" --Jaye, Wonderfalls
loyd@xxxxxxxxxxxxxx  ICQ#504581  http://www.blackrobes.net/