Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Exclamation Unanswered: foreign keys - application heap issue

    Hello all .
    I'm painfully dealing for a week with very strange problem of application heap size overflow.

    My system (linux/db2 8.1/512M RAM/1024 pages application heap size)
    has few tables, where two of them like folowing:

    T1
    ( id bigint primary key not null
    generated by default as identity
    ( start with 1, increment by 1 ),
    val bigint not null
    )

    T2
    ( id bigint primary key not null
    generated by default as identity
    ( start with 1, increment by 1 ),
    val bigint not null,
    CONSTRAINT t1_fk FOREIGN KEY ( val )
    REFERENCES T1 ( id )
    )

    T1 has about 500000 entries.

    When i inserting entries to T2 , application heap utilization becomes over 100% , and after few minutes application fails with "application heap size error).
    But , what is most important and STRANGE , when i removing constraint of T2,which is FOREIGN KEY to T1 EVERY THING WORK FINE !!!

    Is there any way to control application heap (flush)?

    Thanks everyone, Arik

  2. #2
    Join Date
    Feb 2004
    Posts
    24

    Re: foreign keys - application heap issue

    Hi,

    have you dedined an index on column id in t1 ?
    just an idea !

    regards

    marc

    Originally posted by arik.fish
    Hello all .
    I'm painfully dealing for a week with very strange problem of application heap size overflow.

    My system (linux/db2 8.1/512M RAM/1024 pages application heap size)
    has few tables, where two of them like folowing:

    T1
    ( id bigint primary key not null
    generated by default as identity
    ( start with 1, increment by 1 ),
    val bigint not null
    )

    T2
    ( id bigint primary key not null
    generated by default as identity
    ( start with 1, increment by 1 ),
    val bigint not null,
    CONSTRAINT t1_fk FOREIGN KEY ( val )
    REFERENCES T1 ( id )
    )

    T1 has about 500000 entries.

    When i inserting entries to T2 , application heap utilization becomes over 100% , and after few minutes application fails with "application heap size error).
    But , what is most important and STRANGE , when i removing constraint of T2,which is FOREIGN KEY to T1 EVERY THING WORK FINE !!!

    Is there any way to control application heap (flush)?

    Thanks everyone, Arik

  3. #3
    Join Date
    Feb 2004
    Posts
    4

    Re: foreign keys - application heap issue

    Originally posted by disaster
    Hi,

    have you dedined an index on column id in t1 ?
    just an idea !

    regards

    marc
    Yeah , and even ran runstats on it

  4. #4
    Join Date
    Feb 2004
    Posts
    4

    Re: foreign keys - application heap issue

    Originally posted by arik.fish
    Yeah , and even ran runstats on it
    ,except, id is primary key which indexed by default

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •