IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Split the file without key record separation


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
venkatatcts

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Sat Jul 03, 2010 1:02 am
Reply with quote

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

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Sat Jul 03, 2010 1:14 am
Reply with quote

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

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Sat Jul 03, 2010 1:25 am
Reply with quote

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

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Sat Jul 03, 2010 1:39 am
Reply with quote

Exactly what utility?
Back to top
View user's profile Send private message
venkatatcts

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Sat Jul 03, 2010 1:47 am
Reply with quote

Hi,

This is the utility used to unload IKJEFT01 the DB2 table

Thanks,
Venkat
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sat Jul 03, 2010 2:08 am
Reply with quote

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

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Sat Jul 03, 2010 2:35 am
Reply with quote

Sorry.. this is the utiltity DSNTIAUL
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Tue Jul 06, 2010 11:50 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
Search our Forums:

Back to Top