Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2006
    Posts
    14

    Unanswered: Changing the Statment Heap Size for DB2 on Z/OS

    Hi,

    I simply got stuck here. When I try to compile the source, I get an Error that the Statement is too complex or too long. Now I've compiled the source against a DB2 on Windows and it worked perfectly fine. Against the Z/OS I get that error. Now I did a bit research and found out that I should raise the STMTHEAP, but how? On Windows it's nor problem, but i hardly think it will work the same on Z/OS.

    DB2 Version is btw. 8.1.5 ...

  2. #2
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    The problem is that in DB2 for z/OS there are some limit, such as:

    Maximum number of tables in a FROM clause: 225
    Maximum number of subqueries in a statement: 14
    Longest SQL statement: 32767 bytes
    Maximum number of elements in a select list: 750
    Maximum number of predicates in a WHERE or HAVING clause: 750
    Maximum total length of columns of a query operation
    requiring a sort key (SELECT DISTINCT, ORDER BY,
    GROUP BY, UNION without the ALL keyword, and the
    DISTINCT column function): 4000 bytes

    I hope this may be useful.

  3. #3
    Join Date
    Mar 2006
    Posts
    14
    Quote Originally Posted by tibullo
    The problem is that in DB2 for z/OS there are some limit, such as:

    Maximum number of tables in a FROM clause: 225
    Maximum number of subqueries in a statement: 14
    Longest SQL statement: 32767 bytes
    Maximum number of elements in a select list: 750
    Maximum number of predicates in a WHERE or HAVING clause: 750
    Maximum total length of columns of a query operation
    requiring a sort key (SELECT DISTINCT, ORDER BY,
    GROUP BY, UNION without the ALL keyword, and the
    DISTINCT column function): 4000 bytes

    I hope this may be useful.
    Definitly it is, especially the part with the longest statement. I took a look, and one of my statements is 38925 bytes long...

    And...I guess...there is no way raising that limit?

  4. #4
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    No, unfortunately.

  5. #5
    Join Date
    Mar 2006
    Posts
    14
    Well.....hmpf.....thanks anyway

Posting Permissions

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