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
 
Large number of data causes problem with online transaction

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

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Tue Apr 21, 2015 10:53 am    Post subject: Large number of data causes problem with online transaction
Reply with quote

I've a table which has got "record length=200". It has 100 partitions based on the last 2 digits of some account. This table gets updated on a daily basis based with two types of data - say R and C. The C & R are moved to a archival table on a daily basis. Daily around 5 M of data gets processed (C + R) while on Monthends the same count goes to 20 M. Anf some times, before specific month end the table gets populated with the heavy payments to reach 30 M records.

Due to this, the online screens are not able to retrieve data from table on a given due date (special day or month end) with high amount of data when the primary has close to 30 M records - what can be the possible solution?
Back to top
View user's profile Send private message

RahulG31

Active User


Joined: 20 Dec 2014
Posts: 401
Location: USA

PostPosted: Tue Apr 21, 2015 11:27 am    Post subject: Reply to: Large number of data causes problem with online transaction
Reply with quote

My initial thoughts are that if you could split the data in different files/tables and then have your online programs access that data based on certain conditions (may be use date as a criteria). So, rather than having all the programs accessing same file/table, we can have different programs accessing different files/tables.

If you could explain the issue a little more then it would be better for me to understand
.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1243
Location: Israel

PostPosted: Tue Apr 21, 2015 2:32 pm    Post subject:
Reply with quote

Is the Index partitioned as well ?
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Tue Apr 21, 2015 2:36 pm    Post subject: Re: Reply to: Large number of data causes problem with online transaction
Reply with quote

RahulG31 wrote:
My initial thoughts are that if you could split the data in different files/tables and then have your online programs access that data based on certain conditions (may be use date as a criteria). So, rather than having all the programs accessing same file/table, we can have different programs accessing different files/tables.

If you could explain the issue a little more then it would be better for me to understand
.
Table is already partitioned on the last 2 digits of "account number" and have 100 partitions.
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Tue Apr 21, 2015 2:36 pm    Post subject:
Reply with quote

Marso wrote:
Is the Index partitioned as well ?
Yes, it is.
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 401
Location: USA

PostPosted: Tue Apr 21, 2015 8:47 pm    Post subject: Reply to: Large number of data causes problem with online transaction
Reply with quote

Could you tell us how much data is being added daily and how much is being archived?

Are you saying that 20M and 30M records are being added in a single day on special days?

What is your selection criteria in the program?

And I hope that you are doing a Reorg when large amount of data is being added in the table.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Tue Apr 21, 2015 9:00 pm    Post subject: Reply to: Large number of data causes problem with online transaction
Reply with quote

define the
Quote:
the online screens are not able to retrieve data from table on a given due date


abend, slow response times,

please be more specific
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1806
Location: NY,USA

PostPosted: Tue Apr 21, 2015 11:34 pm    Post subject:
Reply with quote

You should partition on due date and improve the cardinality of the SQL. Also make a use of TSQ's if you are not using it.
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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm

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