Foreign key not shown in Data perspective

Technote (troubleshooting)


Problem(Abstract)

Attempts to create a connection to an IBM DB2 7.2 database and import the schema in the DBExplorer tab of the Data perspective to a folder results in the foreign keys not appearing.

Symptom

This problem can also occur with stored procedures and user-defined functions (UDFs).


Cause

Insufficient heap size.

Resolving the problem

Increase the application heap size on the database by doing the following:

  1. Open the DB2 Control Center > right-click the database and select Configure.
  2. Click the Performance tab.
  3. Scroll down the Parameter list and find Application heap size field and change the value to a higher heap size in the Value field. For example, if the value is the default 128, try increasing it to 512.
  4. Click OK.
  5. In WebSphere Studio, import the schema again and the foreign keys should appear. See help contents topic: "Importing DB2 database definitions to your project"

If the data definitions do not appear, continue this process until you find the optimal application heap size.


Cross reference information
Segment Product Component Platform Version Edition
Business Integration WebSphere Studio Site Developer Relational database tools Windows 5.0, 5.0.1 All Editions
Business Integration WebSphere Studio Enterprise Developer Relational database tools Windows 5.0, 5.0.1 All Editions
Business Integration WebSphere Development Studio Client for iSeries Relational database tools Windows 2000, Windows NT, Windows XP 5.0 All Editions
Business Integration WebSphere Studio Application Developer Integration Edition Relational database tools Windows 5.0, 5.0.1 All Editions
Data & Information Management DB2 Universal Database Application Programming - JDBC Windows 7 All Editions

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Studio Application Developer
Relational database tools

Software version:

5.0, 5.0.1

Operating system(s):

Windows

Reference #:

1080538

Modified date:

2014-08-19

Translate my page

Machine Translation

Content navigation