COMPLEX FLAT FILE STAGE IN GRID

santoshkumar · Post by **santoshkumar** » Wed Dec 06, 2006 4:21 pm

Hi,

I am reading an EBCIDIC file and loading to a dataset.I tested the job on SMP system it is takeing one minute but when i do the same on DS 7.5.1A GRID box job takes 10 minutes.

how can i improve the performance.It is fixed width file.

Any help is appreciated.

ArndW · Post by **ArndW** » Wed Dec 06, 2006 5:10 pm

Does the file have 10 records? What is your grid configuration - how many nodes and how are they interconnected?

lstsaur · Post by **lstsaur** » Wed Dec 06, 2006 5:32 pm

Santosh,
The best person to answer your problem is the person who sets up the GRID in your shop. Also, when you said that the job ran on the GRID took 10 minutes to finish, did you get that information from the GRID Resouce Manager?

ray.wurlod · Post by **ray.wurlod** » Wed Dec 06, 2006 8:02 pm

What speed do you get if you run on a one-node configuration on the conductor node?

santoshkumar · Post by **santoshkumar** » Wed Dec 06, 2006 11:00 pm

How can i make the job to run on the conductor node i.e any environment variable value to be added or any variable to be added to job

ray.wurlod · Post by **ray.wurlod** » Thu Dec 07, 2006 2:54 am

You use a configuration file that makes reference to this node (as a fastname) and puts it in the conductor node pool. You set APT_CONFIG_FILE to point to this configuration file. Then you visit the Advanced tab in the stage and select the conductor node pool.