Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Posts
    8

    Unanswered: Stored procedure

    hi All
    i m not able to open the Automatic wizard in db2cc
    i can open reset of the wizard.

    as requested by IBM i ran the following call fuction

    but its ended with

    "S1042C unexpected system error."

    function

    db2 "call sysinstallobjects('policy','c',",")



    this is the error message logged in diaglog


    Insufficient memory available for IPC communication with the db2fmp
    process. Use the DB2_FMP_COMM_HEAPSZ registry variable to adjust the
    amount of memory available for fenced routines.

    DB2 UDB, routine_infrastructure, sqlerGetFMPIPC, probe:60
    ZRC=0x8B0F003B=-1961951173=SQLO_NOMEM_UND
    "No memory available in 'Undefined Heap'"
    DIA8300C A memory heap error has occurred.


    plz help me

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Please post DB2 version and platform and the complete and exact error message - what you have shown is not a DB2 error message.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jan 2009
    Posts
    8
    hi fellows

    i forgot to mention that its only Automatic maintenance wizard

    hi Stolze

    its DB2 v8.1.1.97 fp 10

    we are running db2 in AIX 5300-06

    this is the error msg which is being logged when ever i call this call fuction

Posting Permissions

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