How do I get to the db2cli.ini file? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

How do I get to the db2cli.ini file?

Author

Topic

JJ297
Aged Yak Warrior

940 Posts

Posted - 2011-09-26 : 09:39:16

I need to get to the db2cli.ini file and increase the QUERYTIMEOUT INTERVAL. Where do I find it on my machine. My SSIS package is not running because the query is taking too long to come up.

JJ297
Aged Yak Warrior

940 Posts

Posted - 2011-09-26 : 10:31:02

Okay I found the db2cli.ini file

This is what it's set to:

[COMMON]
QUERYTIMEOUTINTERVAL=0

Do I increase it to 30 instead?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 11:42:16

why are you tweaking SSIS parameters? why not try to optimise the query so as to execute faster.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

JJ297
Aged Yak Warrior

940 Posts

Posted - 2011-09-26 : 14:23:26

Because I sent this one to you last week because I didn't think it had a join clause but you told me it did in the where:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=165843

SELECT DISTINCT AL1.CLMS,
AL1.COS,
AL2.JURIS_MVT_SEQ_NUM,
RIGHT(AL2.ORG_ID,3)AS ORG_ID,
AL2.JURIS_MVT_TYP

FROM MT2.CLAIM AL1, MT2.JURISMVT AL2

WHERE (AL1.CLMS=AL2.CLMS AND AL1.BICNUM=AL2.BICNUM
AND AL1.REF_NUM=AL2.REF_NUM AND
AL1.TYP_OF_ACTN=AL2.TYP_OF_ACTN AND
AL1.APP_STDT=AL2.APP_STDT AND
AL1.ACTV_IND_CD=AL2.ACTV_IND_CD)
AND ((AL1.ACTV_IND_CD='A' AND AL1.ADJU_LVL='I' AND AL1.WKLD='04' AND
(NOT AL1.APP_RCPDT IS NULL)))

Is there anyway I can tweak this to run faster?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 14:27:58

yep. you can. did you see execution plan for the above query and see what are time taking steps. Also look if there is any table scans indicating absence of index

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

JJ297
Aged Yak Warrior

940 Posts

Posted - 2011-09-26 : 15:09:54

How do I do that (see Execution Plan)? Please advise.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 15:11:55

you've an icon on top of management studio hovering over which will display option display actual execution plan. select it and run your query

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

JJ297
Aged Yak Warrior

940 Posts

Posted - 2011-09-26 : 15:19:57

Okay I found it but this query is going against a DB2 table. How do I check that?

When I got it I got invlaid object name MT2.Claim

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 15:24:14

what? are you using db2? if yes,post in some db2 forums. this is ms sql forum

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

JJ297
Aged Yak Warrior

940 Posts

Posted - 2011-09-26 : 15:30:20

My query runs and gets the correct results I posted here because I get an error when trying to run it in a job in sql. So it told me to change this in the SSIS package. I did but it still didn't work.

[COMMON]
QUERYTIMEOUTINTERVAL=0

I will go to a DB2 forum instead. thanks for pointing me there.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources