If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Stored Procedure DSNUTILS (DB2 os390 V7)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-30-04, 09:59
VPXPEBA VPXPEBA is offline
Registered User
 
Join Date: Mar 2004
Location: Stockholm, Sweden
Posts: 2
Unhappy 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 06:01.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On