Loading data and keep available

[Steven]

I am new to DB2 databases in general and I can't be the only one with
this problem and was looking for a best practice.
I need to make nightly data feeds from another system. I was using an
import statement but that was taking a long time so I switched to a
load statement. The only problem is that the tables are unavailable
for both solutions.
What is the best way to load data into a table and keep the
information available for the longest amount of time.
We are in the need to be 24 7 but I have to spend 30 40 minutes
loading this data.
Is there something you can do with temporary tables, views, or
aliases. Any thoughts would be appreciated.

Thank you.

Steven

[Blair Adamache]

Re: Loading data and keep available

If you're using DB2 v8, load can be an online operation. With v7, wiews
won't help.

Steven wrote:
[color=blue]
> I am new to DB2 databases in general and I can't be the only one with
> this problem and was looking for a best practice.
> I need to make nightly data feeds from another system. I was using an
> import statement but that was taking a long time so I switched to a
> load statement. The only problem is that the tables are unavailable
> for both solutions.
> What is the best way to load data into a table and keep the
> information available for the longest amount of time.
> We are in the need to be 24 7 but I have to spend 30 40 minutes
> loading this data.
> Is there something you can do with temporary tables, views, or
> aliases. Any thoughts would be appreciated.
>
> Thank you.
>
> Steven[/color]

[Anton Versteeg]

Re: Loading data and keep available

Perhaps you can load the data into a new table, drop tha alias of the
old table and create that alias on the new table?

Blair Adamache wrote:
[color=blue]
> If you're using DB2 v8, load can be an online operation. With v7,
> wiews won't help.
>
> Steven wrote:
>[color=green]
>> I am new to DB2 databases in general and I can't be the only one with
>> this problem and was looking for a best practice.
>> I need to make nightly data feeds from another system. I was using an
>> import statement but that was taking a long time so I switched to a
>> load statement. The only problem is that the tables are unavailable
>> for both solutions.
>> What is the best way to load data into a table and keep the
>> information available for the longest amount of time.
>> We are in the need to be 24 7 but I have to spend 30 40 minutes
>> loading this data.
>> Is there something you can do with temporary tables, views, or
>> aliases. Any thoughts would be appreciated.
>>
>> Thank you.
>>
>> Steven[/color]
>
>[/color]

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

[Blair Adamache]

Re: Loading data and keep available

Or even use rename table if not referential integrity is involved.

Anton Versteeg wrote:[color=blue]
> Perhaps you can load the data into a new table, drop tha alias of the
> old table and create that alias on the new table?
>
> Blair Adamache wrote:
>[color=green]
>> If you're using DB2 v8, load can be an online operation. With v7,
>> wiews won't help.
>>
>> Steven wrote:
>>[color=darkred]
>>> I am new to DB2 databases in general and I can't be the only one with
>>> this problem and was looking for a best practice.
>>> I need to make nightly data feeds from another system. I was using an
>>> import statement but that was taking a long time so I switched to a
>>> load statement. The only problem is that the tables are unavailable
>>> for both solutions.
>>> What is the best way to load data into a table and keep the
>>> information available for the longest amount of time.
>>> We are in the need to be 24 7 but I have to spend 30 40 minutes
>>> loading this data.
>>> Is there something you can do with temporary tables, views, or
>>> aliases. Any thoughts would be appreciated.
>>>
>>> Thank you.
>>>
>>> Steven[/color]
>>
>>
>>[/color]
>[/color]