Visual Studio Freezes while generating Entity Data Model with IBM Entity Framework Provider.

Technote (troubleshooting)


Problem(Abstract)

Visual Studio Freezes while generating Entity Data Model (EDM) with IBM Entity Framework Provider.

Cause

IBM Entity Framework provider queries system tables (system catalog) to gather all the necessary metadata information to generate EDM.

If data distribution statistics of system tables are not collected or stale, the optimizer may select a plan that is not optimal, resulting in poor query execution performance that leads freezing Visual Studio.


Resolving the problem

Contact your DBA to run update statistics commands that update and stores the data distribution statistics of system tables (system catalog).

It is highly recommended to keep all the table's statistics frequently updated to achieve the optimal performance.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows
DB2 Programming Interfaces - .NET

Software version:

9.5, 9.7, 9.8, 10.1, 10.5

Operating system(s):

Windows

Reference #:

1647429

Modified date:

2013-08-26

Translate my page

Machine Translation

Content navigation