Troubleshooting SQL code -430

Use this information if an administration stored procedure, such as SYSPROC.SYSTS_START, returns SQL code -430.

About this task

The message text reads as follows:

SQLCODE = -430, ERROR:  PROCEDURE SYSPROC.SYSTS_START 
(SPECIFIC NAME SYSPROC.SYSTS_START) HAS ABNORMALLY TERMINATED

Procedure

To resolve this problem:

Complete the appropriate actions based on the following information:
  • Start of changeDb2 12 requires the Db2 Accessories Suite for z/OS®, Version 2.1.0, or later.End of change
  • If you received Db2 message DSNX962I, you must install the component IBM® International Components for Unicode (ICU) for Db2 for z/OS, which is provided in the Db2 Accessories Suite for z/OS.
  • If the ICU component is installed, you can run stored procedures by using the following ICU program objects. These ICU program objects are in the same SDSNLOAD data set that is used in the WLM application environment:
    • DSN5ICDA
    • DSN5ICIN
    • DSN5ICIO
    • DSN5ICUC
    • DSN5IDA3
    • DSN5IIN3
    • DSN5IIO3
    • DSN5IUC3