SQLEXEC routine not found using RAA dmhRunstats.rexx

Technote (troubleshooting)


Problem(Abstract)

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.

Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Asset Analyzer
General Information

Software version:

6.0

Operating system(s):

Windows

Reference #:

1622842

Modified date:

2013-01-24

Translate my page

Machine Translation

Content navigation