Symptom
While performing a migration using the SUM Data Migration Option (DMO) you encounter the following sql -471 error , REASON 00E79001 reported in tcode SM21 and dev_w Developer Traces.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(HYB) Info: Cannot get dbsl subfunction pointer. Using NEW dbsl support.
DB2 Call 'SQLExecute' Error: conHdl = 00 SQLCODE = -471 : [IBM][CLI Driver][DB2] INVOCATION OF FUNCTION OR PROCEDURE SYSPROC.DSNUTILS FAILED DUE TO REASON 00E79001
DB2Trc: CALL DSNUTILS (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
SQL Error: -471
Message: [IBM][CLI Driver][DB2] INVOCATION OF FUNCTION OR PROCEDURE SYSPROC.DSNUTILS FAILED DUE TO REASON 00E79001
ERROR: Executing RUNSTATS via stored procedures failed with error code 1.
db2radm finished (0008)
[INFO] [20200504093434][End] Return Code is: 8
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Further investigation and review of the z/OS syslog and DB2MSTR started task log reveal that sql error -805 , REASON 00E4E2D7 is reported on stored procedure SYSPROC.DSNUTILS.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20126 0120502 CP3U SAPWLMU DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME SAPA.DSNUTILS.DSNUTILS.0E4C9F3F00F9F3F8
20126 0120502 CP3U SAPWLMU NUTILS.0E4C9F3F00F9F3F8 NOT FOUND IN PLAN DISTSERV. REASON 0
20126 0120502 CP3U SAPWLMU DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
20126 0120502 CP3U SAPWLMU DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
20126 0120502 CP3U SAPWLMU DSNT416I SQLERRD = -251 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
20126 0120502 CP3U SAPWLMU DSNT416I SQLERRD = X'FFFFFF05' X'00000000' X'00000000'
20126 0120502 CP3U SAPWLMU X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
20126 0120502 CP3U SAPWLMU INFORMATION
20126 0120502 CP3U SAPAMSTR DSNX906I -SAPA DSNX9CAC PROCEDURE OR FUNCTION 747
20126 0120502 CP3U SAPAMSTR SYSPROC.DSNUTILS TERMINATED ABNORMALLY. THE PROCEDURE OR FUNCTION HAS
20126 0120502 CP3U SAPAMSTR BEEN STOPPED. ASID= 00F1 WLM_ENV= DB2SAP_UTILS
20126 0120502 CP3U SAPWLMU IEA995I SYMPTOM DUMP OUTPUT 748
20126 0120502 CP3U SAPWLMU SYSTEM COMPLETION CODE=04E REASON CODE=00E4E2D7
20126 0120502 CP3U SAPWLMU TIME=01.20.50 SEQ=38020 CPU=0000 ASID=00F1
20126 0120502 CP3U SAPWLMU PSW AT TIME OF ERROR 078D1000 8001AE7E ILC 2 INTC 0D
20126 0120502 CP3U SAPWLMU ACTIVE MODULE ADDRESS=00000000_00018000 OFFSET=00002E7E
20126 0120502 CP3U SAPWLMU NAME=DSNUTILS
20126 0120502 CP3U SAPWLMU DATA AT PSW 0001AE78 - 581087E8 0A0DA7F4 FFF6EBEC
20126 0120502 CP3U SAPWLMU GR 0: 00000048 1: 8404E000
20126 0120502 CP3U SAPWLMU 2: FFFFFCDB 3: 00000000
20126 0120502 CP3U SAPWLMU 4: 00000046 5: 8001ADA4
20126 0120502 CP3U SAPWLMU 6: 000266F8 7: 0003368C
20126 0120502 CP3U SAPWLMU 8: 0001B630 9: 00000288
20126 0120502 CP3U SAPWLMU A: 00033A66 B: 80018000
20126 0120502 CP3U SAPWLMU C: FFFFFCDB D: 00033220
20126 0120502 CP3U SAPWLMU E: 00000001 F: 00E4E2D7
20126 0120502 CP3U SAPWLMU END OF SYMPTOM DUMP
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Read more...
Environment
- Db2 z/OS any version
- Netweaver AS ABAP & JAVA any version
Product
Keywords
DSNUTILU SQL0805N SQL0471N db2binder dbrm , KBA , BC-DB-DB2-UPG , DB2 for z/OS - Upgrade , BC-UPG-RDM , README: Upgrade Supplements , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.