Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Stockholm, Sweden
    Posts
    3

    Unhappy Unanswered: Stored Procedure DSNUTILS (DB2 os390 V7)

    Hi
    I have a problem with DSNUTILS. (DB2 for os390 V7)

    This is the Result from DSNTEJ6V step PH06VS04:

    --> Enter SqlException()
    Unexpected SQLCODE returned by CALL SYSPROC.DSNUTILS in class::method DsnUtils
    DSNT408I SQLCODE = -430, ERROR: PROCEDURE SYSPROC .DSNUTILS (SPECIFIC NAME
    SYSPROC .DSNUTILS) HAS ABNORMALLY TERMINATED
    DSNT418I SQLSTATE = 38503 SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
    DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
    X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

    Leave SqlException()
    DSN8EE2: DB2 for OS/390 Sample C++ Caller of DSNUTILS
    Begin CHECKINDEX
    ** Error: SqlException caught by dsnutils::checkIndex.
    ** See SYSOUT for details.
    End CHECKINDEX
    DSN8EE2: EOJ - Highest return code is 12




    And the result in the WLM Started Task:


    16.35.56 STC06083 IEC130I SYSIN DD STATEMENT MISSING
    16.35.56 STC06083 IEA995I SYMPTOM DUMP OUTPUT
    SYSTEM COMPLETION CODE=0C1 REASON CODE=00000001
    TIME=16.35.56 SEQ=01028 CPU=0000 ASID=00C4
    PSW AT TIME OF ERROR 078D2000 80000052 ILC 2 INTC 01
    NO ACTIVE MODULE FOUND
    NAME=UNKNOWN
    DATA AT PSW 0000004C - 00FD1018 00000000 00000000
    AR/GR 0: 00000000/00006DD0 1: 00000000/00006D6C
    2: 00000000/0D524038 3: 00000000/00006D6C
    4: 00000000/00006DD0 5: 00000000/00027F50
    6: 00000000/0D33AC80 7: 00000000/0002C51C
    8: 00000000/0000002D 9: 00000000/00027136
    A: 00000000/00026137 B: 00000000/80025138
    C: 00000000/00000001 D: 00000000/0002C160
    E: 0D312040/80026932 F: 00000000/00000050
    END OF SYMPTOM DUMP


    Is this familiar to anyone ??

    Regards
    Peter
    Last edited by VPXPEBA; 04-01-04 at 07:01.

  2. #2
    Join Date
    Nov 2012
    Location
    Zagreb, Croatia
    Posts
    11
    Hello, do you maybe remember what was the solution of this question, we now have similar problem?

    Thanks
    Ivana

    Quote Originally Posted by VPXPEBA View Post
    Hi
    I have a problem with DSNUTILS. (DB2 for os390 V7)

    This is the Result from DSNTEJ6V step PH06VS04:

    --> Enter SqlException()
    Unexpected SQLCODE returned by CALL SYSPROC.DSNUTILS in class::method DsnUtils
    DSNT408I SQLCODE = -430, ERROR: PROCEDURE SYSPROC .DSNUTILS (SPECIFIC NAME
    SYSPROC .DSNUTILS) HAS ABNORMALLY TERMINATED
    DSNT418I SQLSTATE = 38503 SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
    DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
    X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

    Leave SqlException()
    DSN8EE2: DB2 for OS/390 Sample C++ Caller of DSNUTILS
    Begin CHECKINDEX
    ** Error: SqlException caught by dsnutils::checkIndex.
    ** See SYSOUT for details.
    End CHECKINDEX
    DSN8EE2: EOJ - Highest return code is 12




    And the result in the WLM Started Task:


    16.35.56 STC06083 IEC130I SYSIN DD STATEMENT MISSING
    16.35.56 STC06083 IEA995I SYMPTOM DUMP OUTPUT
    SYSTEM COMPLETION CODE=0C1 REASON CODE=00000001
    TIME=16.35.56 SEQ=01028 CPU=0000 ASID=00C4
    PSW AT TIME OF ERROR 078D2000 80000052 ILC 2 INTC 01
    NO ACTIVE MODULE FOUND
    NAME=UNKNOWN
    DATA AT PSW 0000004C - 00FD1018 00000000 00000000
    AR/GR 0: 00000000/00006DD0 1: 00000000/00006D6C
    2: 00000000/0D524038 3: 00000000/00006D6C
    4: 00000000/00006DD0 5: 00000000/00027F50
    6: 00000000/0D33AC80 7: 00000000/0002C51C
    8: 00000000/0000002D 9: 00000000/00027136
    A: 00000000/00026137 B: 00000000/80025138
    C: 00000000/00000001 D: 00000000/0002C160
    E: 0D312040/80026932 F: 00000000/00000050
    END OF SYMPTOM DUMP


    Is this familiar to anyone ??

    Regards
    Peter

  3. #3
    Join Date
    Mar 2004
    Location
    Stockholm, Sweden
    Posts
    3
    Hi Ivana

    Are you still running V7 ??

    I can't remember what the problem was, but probably it was just the SYSIN DD missing in the WLM-proc.


    Try adding this

    //SYSIN DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)

    Br
    Peter

  4. #4
    Join Date
    Nov 2012
    Location
    Zagreb, Croatia
    Posts
    11
    Hello,
    thank you for your answer.

    No, we are running v10

    Today we have managed to solve this problem.
    We had problem with invocation of web service from DB2 by running system functions.
    We have been trying to invoke web service by invoking it through function DB2XML.SOAPHTTPV but then we've been gotting this error sqlcode -430.
    Now we are invoking web service by system function DB2XML.SOAPHTTPNV (which seems to be newer version of SOAPHTTPV, which is deprecated) and everything is fine now.

    Once more, thank you for your help.

    Ivana

    Quote Originally Posted by VPXPEBA View Post
    Hi Ivana

    Are you still running V7 ??

    I can't remember what the problem was, but probably it was just the SYSIN DD missing in the WLM-proc.


    Try adding this

    //SYSIN DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)

    Br
    Peter

Posting Permissions

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