Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

need help for mass insert in db2 for online system

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Avanti

New User


Joined: 11 Mar 2010
Posts: 12
Location: pune

PostPosted: Fri May 07, 2010 1:57 pm    Post subject: need help for mass insert in db2 for online system
Reply with quote

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
View user's profile Send private message

Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Fri May 07, 2010 6:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Avanti

New User


Joined: 11 Mar 2010
Posts: 12
Location: pune

PostPosted: Mon May 10, 2010 8:58 am    Post subject: need help for mass insert in db2 for online system
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon May 10, 2010 9:16 am    Post subject:
Reply with quote

Hello,

This is posted in the db2 part of the forum, but some of the dialog is about IMS.

If this is for db2, read about "multiple-row-insert". . .
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/5.74
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Wed May 12, 2010 1:46 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed May 12, 2010 1:59 am    Post subject:
Reply with quote

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 icon_smile.gif

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
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Thu May 13, 2010 2:00 am    Post subject:
Reply with quote

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. icon_smile.gif

Be sure to check with your database administrators for constraints before employing multi row inserts of larger volumes in application programs.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Overlay the system date Danielle.Filteau SYNCSORT 4 Fri Mar 03, 2017 1:16 am
No new posts Mass comment and edit elixir1986 IBM Tools 3 Thu Mar 02, 2017 10:09 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us