DataStudio holds connections to DB2 database

Question

I run my queries on DB2 Datastudio. I start with "connect"ing to the database... and over a period of time.. say, I run 100+ queries on the same connection over multiple days.

On the database side, we see 100+ connections coming from me. I don't understand how 1 connection on my side can become 100+ connections on the database side? I use DataStudio v4.1.0.1. Please help..

Each SQL Editor window opens its own connection to the database and holds it until the window is closed. — mustaccio, Jan 08 '16 at 18:48
I have a few sql editor windows open.. like 5 or 6. nothing more than that.. — Aravind Datta, Jan 08 '16 at 19:14

score 0 · Answer 1 · answered Mar 29 '17 at 15:02

0

In your SQL editor, head to configuration and pick "Use the existing connection". That should help fix it.

answered Mar 29 '17 at 15:02

Manu Andrei

62
1
15

DataStudio holds connections to DB2 database

1 Answers1