| View previous topic :: View next topic |
| Author |
Message |
arshadh
Beginner
Joined: 10 Jan 2007
Posts: 33
Topics: 12
|
 Posted: Tue Jun 12, 2007 2:07 am Post subject: Table loading... Unable to meet Requirement |
 |
|
Dear All,
We have got a (new proj) DB2 stored procedure which will be invoked by online applications 24/7 .The Stor.Proc accesses few tables which will be loaded on daily basis.
Now our clients want the database to be availble even when the table is being loaded.They dont want the application down even for 5-10 seconds. Some of our team members suggest to load the table in share mode, so that even while loading it will be available. But it seems the replace option will not work while loading in share mode... (Note: we load tables using DB2UTLTM utility)
what is the best and cost effective way to meet the requirement?
(Requirement: Table shud always be available ) |
|
| Back to top |
|
 |
CICS Guy
Intermediate
Joined: 30 Apr 2007
Posts: 292
Topics: 3
|
| Posted: Tue Jun 12, 2007 3:47 am Post subject: |
|
|
| Quote: |
what is the best and cost effective way to meet the requirement?
(Requirement: Table shud always be available )
|
They want it to be available to read only, they are not updating it, are they? |
|
| Back to top |
|
|
arshadh
Beginner
Joined: 10 Jan 2007
Posts: 33
Topics: 12
|
| Posted: Tue Jun 12, 2007 4:13 am Post subject: |
|
|
| yes they want it to be read only... |
|
| Back to top |
|
|
CICS Guy
Intermediate
Joined: 30 Apr 2007
Posts: 292
Topics: 3
|
| Posted: Tue Jun 12, 2007 4:55 am Post subject: |
|
|
| There might be a way to load the table under an alternate name and dynamically swap the newly loaded table for the current old one....... |
|
| Back to top |
|
|
videlord
Beginner
Joined: 09 Dec 2004
Posts: 147
Topics: 19
|
| Posted: Tue Jun 12, 2007 10:01 am Post subject: |
|
|
Currently i don't think there is a way from DB2 system level.
But you can consider in application level, e.g. using shadow table, swith the table after load completed |
|
| Back to top |
|
|
arshadh
Beginner
Joined: 10 Jan 2007
Posts: 33
Topics: 12
|
| Posted: Wed Jul 11, 2007 11:45 pm Post subject: |
|
|
The problem is soved by going for insert update delete logic . The yesterdays and current days file are compared based on sorted primary keys.
The following logic was used to solve this... Here TODAY-RRS and YESTERDAY-RRS means thge primary key of the files to be inserted into the table.
a. We have two inputs, today |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
