IBM Support

SQLEXEC routine not found using RAA dmhRunstats.rexx

Troubleshooting


Problem

Attempts to run dmhRunstats.rexx from IBM Rational Asset Analyzer (RAA) 6.0 in a Microsoft Windows 64-bit environment results in the error "DB2 Error: RxFuncAdd of SQLEXEC, rc = 1".

Symptom

Running dmhRunstats.rexx from IBM Rational Asset Analyzer 6.0 in a Microsoft Windows 64-bit environment can produce an error indicating that the SQLEXEC routine cannot be found, even though the latest DB2 fixpack has been installed.

The error message is similar to:

DB2 Error: RxFuncAdd of SQLEXEC, rc = 1
Error 43 Running D:\Program Files\IBM\Rational Asset
Analyzer\bin\dmhRunstats.rexx line 173: Routine not found
Error 43.1: Could not find routine "SQLEXEC"

Cause

A a 64-bit ooREXX version was installed.

RAA 6.0 supports 32-bit Open Object REXX (ooREXX) version 3.2.0.

Diagnosing The Problem

To determine which level of ooREXX is installed:

  1. Open a Windows command prompt on the RAA server
  2. Type rexx -v

Resolving The Problem

Install 32-bit Open Object REXX (ooREXX) version 3.2.0 and rerun dmhRunstats.rexx.

[{"Product":{"code":"SS3JHP","label":"Rational Asset Analyzer"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"6.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
02 August 2018

UID

swg21622842

Page Feedback