IBM Support

RC=-3, 806-04 abend, and SQL error SQLCODE executing DSNREXX during installation of Optim for DB2 for z/OS

Troubleshooting


Problem

During the early stages of an install or upgrade, a user may see a rc=-3 and an 806-04 abend: CSV003I REQUESTED MODULE DSNTZANB NOT FOUND CSV028I ABEND806-04 JOBNAME=TECA796 STEPNAME=SPFTECH System abend code 806, reason code 00000004. Abend in external function RXSUBCOM. IEA995I SYMPTOM DUMP OUTPUT SYSTEM COMPLETION CODE=806 REASON CODE=00000004 TIME=10.16.43 SEQ=47732 CPU=0000 ASID=00B0 PSW AT TIME OF ERROR 070C1000 8140C6A8 ILC 2 INTC 0D NO ACTIVE MODULE FOUND NAME=UNKNOWN DATA AT PSW 0140C6A2 - 8400181E 0A0D18FB 180C181D GR 0: 00001F00 1: 84806000 2: 00000000 3: 00000000 4: 00000000 5: 009FD450 6: 000000FF 7: 00000000 8: 7F4A5168 9: 0140CBD0 A: 00000000 B: 00000000 C: 00000000 D: 7F4A5168 E: 84806000 F: 00000004 END OF SYMPTOM DUMP 33 +++ xRC = RXSUBCOM('ADD','DSNREXX','DSNREXX') Error running FOPCDBRL, line 33: Incorrect call to routine 37 *-* "CONNECT " SSID *** +++ RC(-3) +++ *** The user then sees a panel indicating that a SQL error occurred executing DSNREXX. The panel explains that Optim cannot use DSNREXX, and that instead it will use DSNHDECP in order to determine the release of DB2 that the user is running.

Symptom

An 806-04 abend and/or RC=-3 will appear on the user's console, and the user will then see a panel indicating that a SQL error occurred while executing DSNREXX.

Cause

The Optim installation process uses DSNREXX to obtain the current DB2 release. The error occurs either because the DSNREXX plan is not bound, or because the DSNREXX module is not available by the TSO logon procedure (STEPLIB or ISPLLIB), the system link list, or the link pack area. A DB2 limitation prevents DSNREXX being called via DB2 libraries that are LIBDEF'ed.

Diagnosing The Problem

Check to see if the DSNREXX plan is bound and accessible to the Optim user. If it is, check to see if the DB2 library containing DSNREXX is available via the TSO logon procedure or is globally available.

Resolving The Problem

Bind the DSNREXX plan if required, and make sure that the library containing the DSNREXX load module is available by the TSO logon procedure, system link list, or link pack area. Alternatively, follow the directions on the panel to hit 'END' and allow Optim to continue the installation and determine the release of DB2 from DSNHDECP.

[{"Product":{"code":"SSMQW5","label":"Optim z\/OS"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"7.1.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

More support for:
Optim z/OS

Software version:
7.1.0

Operating system(s):
z/OS

Document number:
464943

Modified date:
03 June 2019

UID

swg21572827

Manage My Notification Subscriptions