IBM Mainframe Forum

Hi All,

I have two batch jobs executing Db2 queries

1. The first query:

Select * from TABLE where COLUMN_NAME IN (value1,value2,value3,.....valueN)

2. The Second query:

Select * from TABLE where COLUMN_NAME = value1.

Now am running the First query using normal batch job.

The second query am running through java invoked by batch job, where am executing the second query by passing the COLUMN_NAME value and executes the query N times to get the same output as the First query.

Now here i want to know which one performs better ? The normal batch job or the java job executing the Db2 query N times.

Thanks In advance.
Proud z/OS USER

Leaving aside for the moment the question of what "performance" means to you, you could begin by comparing the service units used by each.

Hello,

Now here i want to know which one performs better ?

You are in a far better position that we to determine which "performs" better.
You need to run multiple tests and analyze the results.
Suggest you involve your dba and/or performance monitoring people.

If you get results that do not make sense, post what you tried and the results and we may be able to offer a suggestion.