DSXchange

Hi,
I wrote a sql in DB2 and saving the data to sequential file.
Allow multiple instance is also NOT checked.
I am getting 2 copies of same record, i used distinct also in the query but the problem continues, if i use PK like or PK= in the query then i am getting unique records. Please help me understand why i am getting multiple records.

Multiple instance has no bearing on getting multiple records. Your sql is not correct, not sure what else to say.

Hi Chulett,
I made the query pretty simple to check, direct select from a single table, if i run the query against the database directly i am getting unique records.

Is the table partitioned or copied on each DB2 node?

Check the configuration file you are using to see if it is referencing multiple nodes.

Table is not partitioned, though there are 8 nodes in configuration file, i guess DB2 runs sequentially.