DSXchange

I did a search with term 'Error: suffix or operands invalid for `push' ' and received zero posts.

Can you please elaborate your requirement. Do you need information about number of partitions or partition number etc.. in your job?. Try exploring System Variable in a transformer stage and see if that helps.

I am trying to install IBM Information Server 8.0.1 on Red Hat Enterprise Linux Advanced Server 4 Intel 86. As part of installation testing, i get the following error while compiling a job with transfomer stage: Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 10:40:08(000) <main...

Ray,

Thanks a lot for your reply.

I double checked my jobs again after reading your post.The issue is with the datatype of partition key column in one of the datasets. Dataset is loaded with key column as integer but when joined in job8 it was decimal, due to which join failed.

Hash partition guarantees records with similar keys to be in same partition within a dataset. But, does this hold true across datasets? Problem: I have to join 7 datasets using Join stage. So, i did the following: 1.Created 7 datasets in 7 seperate jobs.In Jobs 1-6 i hash partitioned the records usi...

Interesting Post. What does modify_1 do? Does it drops certain columns or renames column name? If it only drop columns we can use sequential file property "Drop on Input" instead of modify stage modify_1. Setting Env variable APT_TSORT_STRESS_BLOCKSIZE variable to an appropriate value will...

and there are some environment variables that need to be set. I can not remember off the top of my head which ones they are.

APT_GRID_COMPUTENODES?

Thanks Vincent for the information.

I read that Tivoli workload scheduler does load balancing and failover mechanism between the blades. Does this means that EE configuration file is generated dynamically for each job invocation by the Tivoli Workload scheduler?

Suppose a project has server jobs only, is there any benefit implementing the same in Information Server Blade? Is there any manuals or documentation available for the same? I could not find any in the IBM website except for a single page. If possible, please share your experiences if you had implem...

Or If the output is a single line then
You need to remove field characters when setting job parameters.

You will not be able to view chinese characters using view data. That's how it works.

Welcome to DSXChange.

There is a search link at top of this page. Use this and you will get more information than you actually need. :D

In one of your sort stages you have a decimal field whose precision is 0. But precision should be > 0. Give appropriate precision values for the decimal field.

You can find osh code in your "Generated OSH" tab of job parameters. If you do not find this tab enable it using administrator.

kksr wrote:Mesage Handler is not enabled for me , is there any othe ralternative , pls suggest

Thanks in advance

I guess i had given an alternative in my previous post.

You can configure DB2 to supress this warning. Contact your DBA.