View previous topic :: View next topic
|
Author |
Message |
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Hi,
I am unloading a db2 table and running a cobol program to create three master files. Db2 table has around 2,00,000 records. This unload and creation of master file takes around 1 hour. But I have Class in which job will run for more than 1 hours. But I cannot run this after 4 EST.
Is there anyway to split this record from the unload file so that i can run with other class which will run 20 mins.
For example if there are 2,00,000 record i need to split the record to 5 files and run it separately.
In that Db2 table a key is there and it will have 10 or 15 or 12 record. But I need to split file such that key should not be spilt. For example,
40000 records after this
aass
aass
aass(12 records)
The split should not happen for a key. This aass should be in only one split file. Is there any possible to way split like that. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
How are you currently 'unloading' the table? Utility? COBOL program?
How big it the 'key' that you don't want to split?
The 'key' that you don't want to split is not a unique key, right?
What is its range? |
|
Back to top |
|
|
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Hi,
Thanks.
The Unload is a utility and if there is 200000 records. Key is not unique.
Code: |
Key other columns
AASSDDD 820 562 156
AASSDDD 758 623 125
AASSDDD 852 725 569
.....
AFTER 39996 RECORDS
KRTYIUOP 456 265 126
KRTYIUOP 456 265 127
KRTYIUOP 457 265 126
KRTYIUOP 476 265 126
KRTYIUOP 496 265 126
KRTYIUOP 456 285 126
AFTER 159997 RECORDS |
If i try to split the by equal amount of 40000 the KEY KRTYIUOP will splitted in two files. But in the cobol program the master file is created for all the rows of key. Key should not be splitted while file is splitted.
Thanks,
Venkatraman B. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
Exactly what utility? |
|
Back to top |
|
|
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Hi,
This is the utility used to unload IKJEFT01 the DB2 table
Thanks,
Venkat |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Quote: |
This is the utility used to unload IKJEFT01 the DB2 table |
the info given is completely useless and does not make any sense....
IKJEFT01 does nothing on itself...
sits there, reading and writing to the tso terminal/screen and executing the commands entered by the user
read
catb.org/~esr/faqs/smart-questions.html
on how to make the best out of Your asking questions |
|
Back to top |
|
|
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Sorry.. this is the utiltity DSNTIAUL |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
venkatatcts,
It's not clear what you're trying to do.
Quote: |
In that Db2 table a key is there and it will have 10 or 15 or 12 record |
What exactly did you mean by the above statement? Do you know beforehand how many distinct keys will be there in your input file? |
|
Back to top |
|
|
|