DB2 Multiple records

KPReddy · Post by **KPReddy** » Tue Dec 11, 2007 3:29 pm

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.

chulett · Post by **chulett** » Tue Dec 11, 2007 3:58 pm

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

KPReddy · Post by **KPReddy** » Tue Dec 11, 2007 4:19 pm

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.

gpatton · Post by **gpatton** » Tue Dec 11, 2007 5:10 pm

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.

KPReddy · Post by **KPReddy** » Wed Dec 12, 2007 12:03 pm

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