7.5 problem

dstage2006 · Post by **dstage2006** » Tue Sep 12, 2006 7:55 am

Hi all,

I got a problem with 7.5 version. the parallel job is simple like

db2-api---------> file or dataset

and the query is like this (select col1,col2,col3 from table1). if the table1 has 10 rows i am getting only 1 row in out put file. but in table1 view data tab is showing 10 rows. I have tried all partitions. please help me out..

Thanks in advance.
Dstage2006

thumsup9 · Post by **thumsup9** » Tue Sep 12, 2006 8:13 am

Is the metadata same on both source and target and what properties did you set in the flat file.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 12, 2006 3:59 pm

From the log, how many rows were sent to the target? Insert a Peek stage between them to determine whether the 10 rows made it into the job.

Xpert · Post by **Xpert** » Tue Sep 12, 2006 10:09 pm

Hi,

First of all, which version u r using and in which platform, because i was confused on seeing ur version and platform. Because here people told that 7.5.2 only runs on windows platform.... pls clarify this.....

ray.wurlod · Post by **ray.wurlod** » Wed Sep 13, 2006 12:58 am

Xpert, you really are confused. The original poster did specify Windows, but it's 7.5x2 (not 7.5.2) that supports parallel job compilation and execution on Windows. And please don't use SMS-style abbreviations here; English is not everyone's first language, so good English is difficult enough.

dstage2006, we await your response to the requests for diagnostic information.

dstage2006 · Post by **dstage2006** » Wed Sep 13, 2006 7:31 am

Is the metadata same on both source and target and what properties did you set in the flat file.?

Hey Thumsup9 The metadata both source and target are same and the properties are set according to the variable declaration.

From the log, how many rows were sent to the target? Insert a Peek stage between them to determine whether the 10 rows made it into the job.

Hi Ray.

Even i tried with Peek stage alos.... the 10 rows are going through db2 to peek but not from peek to file.the log is showing that peek is passing the 10 rows from it.

DB2---> peek----> file

Even i tried all the partitions we have in DATASTAGE parallel jobs. alternatively i tried with different table also (select col1,col2 from table2) like that.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 13, 2006 2:25 pm

Does the one row in the output file contain all the data from the ten source rows? That is, have you misconfigured the record terminator character?

dstage2006 · Post by **dstage2006** » Wed Sep 13, 2006 2:56 pm

Hi Ray,

Thanks for your Quick Response.

Does the one row in the output file contain all the data from the ten source rows? That is, have you misconfigured the record terminator character?

Nope, I am getting only one rows with exact information and other 9 rows are missing. and i cheked my record termination characted it is also Correct.

Still its a mistery for me..........

Thanks
Dstage2006.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 13, 2006 3:14 pm

Can't reproduce it. Can you generate a job report (click the "Internet Explorer" icon second from the right in the Designer toolbar) and publish this on a web site somewhere so we can look at it? At worst, publish all but the bitmap here.
If you could also provide the 10 rows of data that would also be useful. Obfuscate any sensitive information.

Xpert · Post by **Xpert** » Wed Sep 13, 2006 10:07 pm

ray.wurlod wrote:Xpert, you really are confused. The original poster did specify Windows, but it's 7.5x2 (not 7.5.2) that supports parallel job compilation and execution on Windows. And please don't use SMS- ...

Hi ray,

Please see the original poster's version he mentioned and in which OS, he is using. Thats why I asked him to clarify. Its not a wrong thing to clarify doubts, because this area where we can clarify all our doubts. I thought 7.5.2 and 7.5x2 are same. But I refered only 7.5x2.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 13, 2006 10:37 pm

Re-read your post! I will concede, however, that the OP did not mention 7.5x2.