Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 How to insert a value on specific pos... Poha Eater DFSORT/ICETOOL 9 Sun Oct 01, 2017 3:04 am
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts How system know which REXX to excute? jackzhang75 CLIST & REXX 14 Thu Jul 06, 2017 1:09 am
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts Overlay the system date Danielle.Filteau SYNCSORT 4 Fri Mar 03, 2017 1:16 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us