|
View previous topic :: View next topic
|
| Author |
Message |
Avanti
New User
Joined: 11 Mar 2010
Posts: 12
Location: pune
|
|
|
|
Hi,
As a part of CPU reduction,we are planning to have mass insert into DB2 tables. I analyzed for Batch programs.
Now,we have one online program in which user is entering the data through screen.The sama data is received through MQ.The message is processed and tables are updated.Now,the second data is entered and processed and so on. No file is involved. Is it possible to apply mass insert for these kind of system.
Thanks
Avanti |
|
| Back to top |
|
 |
Kjeld
Active User
Joined: 15 Dec 2009
Posts: 365
Location: Denmark
|
|
|
|
| I will suggest that you use IMS BMP (Batch Message Partition) programs/jobs for this. Be sure to issue checkpoints with high frequency to free up any locks held on database updates. |
|
| Back to top |
|
|
Avanti
New User
Joined: 11 Mar 2010
Posts: 12
Location: pune
|
|
|
|
Hi Kjeld,
Thanks for your reply.I tried searching for IMS BMP for mass insert as you have suggested.But I did not get from where exactly I should start since I am completely new to this thing.Can you please give me some hint from where and which direction I should begin?
Regards,
Avanti |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
| Back to top |
|
|
Kjeld
Active User
Joined: 15 Dec 2009
Posts: 365
Location: Denmark
|
|
|
|
I gave this advice because in my experience, mass inserts have a tendency to create locking problems when used in concurrency with online applications. The larger units of work you create the higher the risk.
So I would suggest a solution that would allow dividing the LUW into smaller units.
If IMS is not employed on OP's site, then just forget it. And I am not able to supply a crash course in IMS application design and programming within the forum constraints. If IMS is available, internal advice and tutoring should be tried first. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Kjeld,
| Quote: |
| And I am not able to supply a crash course in IMS application design and programming within the forum constraints. |
If you were to post this, we could surely make it a "Sticky" in the IMS part of the forum 
Avanti - i may have misunderstood what you meant by mass insert. How many is a mass? If you mean adding several rows in one db2 insert instead of several inserts, this will work well. I'd be wary of adding (inserting) very high volume - this would be better served in batch (IMHO). |
|
| Back to top |
|
|
Kjeld
Active User
Joined: 15 Dec 2009
Posts: 365
Location: Denmark
|
|
|
|
Incidentally there are stickys in the IMS DB/DC forum with links to some IMS documentation, though the documentation is not offered this site's IBM manual collection from the top menu.
Be sure to check with your database administrators for constraints before employing multi row inserts of larger volumes in application programs. |
|
| Back to top |
|
|
|
|
