MVSFORUMS.com

rayala_uday · Beginner Joined: 15 Sep 2005 Posts: 9 Topics: 4

Hi,

I have a falt file having millions of records,whenever i am finding for particular contract is present or not in flat file,its taking long time to find that contract(Nearly taking 15 min).
Can you tell me how to findout particular contract in short time?

Thanks
Uday

Dibakar · Posted: Wed Jan 25, 2006 2:59 am Post subject:

Uday,

Have you tried following -

1) Use "find" instead of "find all".

2) Use quick search in file-aid.

3) Searching in batch using file-aid or sort.

Regards,
Diba.

rayala_uday · Beginner Joined: 15 Sep 2005 Posts: 9 Topics: 4

Thankq for ur suggestions.

I tried in second way,Now ist finding out in less time compared first method(Find and Find All) and third method(Fileaid-Batch).

In this method also,its taking some time to read all the input dataset.Is there any other metod to find out in very short time

Thanks
Uday

Phantom · Posted: Wed Jan 25, 2006 4:05 am Post subject:

rayala,

As far as I know, Sort does I/O much faster than other utilities. Did you try using SORT (INCLUDE COND=) ??? And, what sort product do you use ? If you are having latest version of syncsort then you can probably try PARASORT or PIPESORT which virtually splits the datasets into multiple chunks and thus the execution time is much faster.

Thanks,
Phantom

ofer71 · Posted: Wed Jan 25, 2006 4:05 am Post subject:

Batch SUPERC

O.
________
medical marijuana strains

rayala_uday · Beginner Joined: 15 Sep 2005 Posts: 9 Topics: 4

Thankq for ur valuable suggestions.

I tried thru sort,Its working fine now.

Thanks
Uday