Whether the DB2 performace of the two jobs equal



IBM's flagship relational database management system

Whether the DB2 performace of the two jobs equal

Postby Nara_513 » Fri Sep 13, 2013 2:18 am

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
Nara_513
 
Posts: 44
Joined: Fri Dec 02, 2011 1:11 am
Has thanked: 0 time
Been thanked: 0 time

Re: Whether the DB2 performace of the two jobs equal

 

Re: Whether the DB2 performace of the two jobs equal

Postby Akatsukami » Fri Sep 13, 2013 2:47 am

Leaving aside for the moment the question of what "performance" means to you, you could begin by comparing the service units used by each.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Whether the DB2 performace of the two jobs equal

Postby dick scherrer » Fri Sep 13, 2013 6:28 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post