Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 338693

Summary:	BIRT leaves behind db2fmp.exe for DB2 data source
Product:	z_Archived	Reporter:	NL <nli>
Component:	BIRT	Assignee:	Birt-ReportDesigner <Birt-ReportDesigner-inbox>
Status:	RESOLVED WORKSFORME	QA Contact:
Severity:	normal
Priority:	P3	CC:	bluesoldier, lchan
Version:	2.6.1
Target Milestone:	3.7.0
Hardware:	PC
OS:	Windows XP
Whiteboard:

Description NL

2011-03-02 10:54:03 EST

I'm using BIRT with DB2 as my data source on Windows. While I was playing with data set, I noticed many db2fmp.exe processes being left behind. db2fmp is used by DB2 to run external routines. It looks like BIRT is not closing or cleaning up database connections properly.

Also, when I'm running the report that accesses the database, the mouse pointer constantly flickers between the normal select and busy icons.  This seems to be related to opening and closing connections as well.  

BIRT version:
Business Intelligence and Reporting Tools

Version: 2.6.1.v20100709a-9iF7A8FGLY4z0pxX3ORrsdrp6JXb
Build id: v20100915-1750

Comment 1 Xiaoying Gu

2011-03-07 03:33:32 EST

Hi,

I can not reproduce this issue with the BIRT 2.6.1 designer.

My steps:
1. Create a dataset using db2 datasource in the 2.6.1 report designer.
2. Do some db related operation, including: 
 a) dataset preview
 b) drag the dataset to layout and preview reports.
 c) create parameters using the db2 dataset and preview reports

I did not found the db2fmp.exe process in my taskmgr.

Comment 2 NL

2011-03-07 11:01:31 EST

I noticed the problem occurs with JDBC Database Connection for Query Builder.  It doesn't happen with JDBC Data Source.  

Your steps are correct to reproduce the leaking connection.  I see around two db2fmp.exe created after previewing the reports each time.

Comment 3 Xiaoying Gu

2011-03-09 00:46:29 EST

(In reply to comment #2)
> I noticed the problem occurs with JDBC Database Connection for Query Builder. 
> It doesn't happen with JDBC Data Source.  
> 
> Your steps are correct to reproduce the leaking connection.  I see around two
> db2fmp.exe created after previewing the reports each time.

Comment 4 Xiaoying Gu

2011-03-09 00:49:26 EST

(In reply to comment #2)
> I noticed the problem occurs with JDBC Database Connection for Query Builder. 
> It doesn't happen with JDBC Data Source.  
> 
> Your steps are correct to reproduce the leaking connection.  I see around two
> db2fmp.exe created after previewing the reports each time.

I tried creating a datasource using JDBC Database Connection for Query Builder, but still can not reproduce this issue. There is no db2fmp.exe detected in the taskmgr. I was using the 2.6.1 release.

Comment 5 Xiaoying Gu

2011-03-15 22:06:41 EDT

Can not reproduce on windows xp + 2.6.1 release + jdk 1.6 + sql query builder.
DB2 driver: com.ibm.db2.jcc.DB2Driver, (db2jcc.jar)

Set as worksforme.