Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Posts
    9

    Unanswered: Sqlcode -973 sqlstate 57011 drda_heap_sz cobol-db2 error

    Hi all, i get the error written in the subject. I run, on a AIX platform, some cobol batches that go on a remote OS/390 Db2 v7, via Db2 connect v7.
    The problem arises obviously on AIX, in which runs the cobol batch, and the message, besides the error codes, tells the tokens:
    SQL ERROR MESSAGE DRDA_HEAP_SZ
    SQL ERROR MESSAGE TOKEN SQLJMRFD

    In order not to get the error, how can i do?
    Thanks in advance

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Sqlcode -973 sqlstate 57011 drda_heap_sz cobol-db2 error

    Have you checked the message

    $>db2 ? sql0973n

    SQL0973N Not enough storage is available in the "<heap-name>"
    heap to process the statement.

    Explanation: All available memory for this heap has been used.
    The statement cannot be processed.

    User Response: Terminate the application on receipt of this
    message (SQLCODE). Increase the configuration parameter for
    "<heap-name>" to increase the heap size.

    sqlcode: -973

    sqlstate: 57011


    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Dec 2002
    Posts
    9

    Re: Sqlcode -973 sqlstate 57011 drda_heap_sz cobol-db2 error

    Hi Sathyaram
    the problem is that, in my environment (AIX 4.3.3 with Db2 connect v7) i have not clear which parameter change, in order to increase "heap" for the batch.

    Originally posted by sathyaram_s
    Have you checked the message

    $>db2 ? sql0973n

    SQL0973N Not enough storage is available in the "<heap-name>"
    heap to process the statement.

    Explanation: All available memory for this heap has been used.
    The statement cannot be processed.

    User Response: Terminate the application on receipt of this
    message (SQLCODE). Increase the configuration parameter for
    "<heap-name>" to increase the heap size.

    sqlcode: -973

    sqlstate: 57011


    Cheers
    Sathyaram

  4. #4
    Join Date
    Dec 2002
    Posts
    9

    Re: Sqlcode -973 sqlstate 57011 drda_heap_sz cobol-db2 error

    Hi all
    i have solved the problem by increasing the value of DRDA_HEAP_SZ in my DB2 UDB AIX environment.
    Originally it was a default value of 128; after some tests, i set a value of 6144, and it works fine.
    Thanks to all!




    Originally posted by marcog1956
    Hi Sathyaram
    the problem is that, in my environment (AIX 4.3.3 with Db2 connect v7) i have not clear which parameter change, in order to increase "heap" for the batch.

  5. #5
    Join Date
    Dec 2004
    Posts
    1

    SQL0973N Not enough storage is available in the DRDA_HEAP_SZ

    Could anyone know command for changing the DRDA_HEAP_SZ in DB2 sits in AIX .

    Thanks

Posting Permissions

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