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: 447
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: 1316
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: 447
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

Senior Member


Joined: 14 Mar 2007
Posts: 10608
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: 2170
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 Sort records within a data block rajiv rengasamy DFSORT/ICETOOL 0 Fri Jul 12, 2019 3:25 pm
No new posts CICS transaction priority vasanthz CICS 6 Fri Jul 12, 2019 12:12 am
No new posts Having problem passing a variable to ... markzasz JCL & VSAM 12 Thu Jul 11, 2019 5:31 pm
No new posts Regarding mroe data to be processed i... vinu78 DB2 3 Mon May 27, 2019 7:31 pm
No new posts masking data with HPU jzhardy DB2 0 Tue May 14, 2019 2:43 pm

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