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:
- Open a Windows command prompt on the RAA server
- Type rexx -v
Resolving the problem
Install 32-bit Open Object REXX (ooREXX) version 3.2.0 and rerun dmhRunstats.rexx.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.