Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Split the file without key record separation

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Split the file without key record separation
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: 2150
Location: At my coffee table

PostPosted: Sat Jul 03, 2010 1:14 am    Post subject:
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    Post subject: Reply to: Split the file without key record separation
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: 2150
Location: At my coffee table

PostPosted: Sat Jul 03, 2010 1:39 am    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Sat Jul 03, 2010 2:08 am    Post subject: Reply to: Split the file without key record separation
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
http://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    Post subject: Reply to: Split the file without key record separation
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: 2284
Location: @my desk

PostPosted: Tue Jul 06, 2010 11:50 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us