Kbase 20823: Error 24501 occurs wehn migrating Progress db to DB2 6.1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/8/2002 |
|
Status: Verified
FACT(s) (Environment):
ODBC DataServer
DB2 UDB version 6.1
SYMPTOM(s):
Error 24501 is encountered when migrating a Progress database to DB2 UDB version 6.1
24501: [IBM][CLI Driver][DB2/NT]SQL0501N The cursor specified in a FETCH or CLOSE statement is not open. SQLSTATE=24501
CAUSE:
This is an DB2 UDB 6.1 issue. User should apply a FIXPACK for DB2 version 6.1 available on the IBM Support website. The fixpack level is FP6 WR21223 fixpack or later
FIX:
Apply the fixpatch FP6 WR21223, thus make sure to follow all the steps required by the patch installation, thus all instructions are within the readme file.
There is a file named FixpackReadme.txt in the same directory as the fixpack executable explaining in detail the steps to install the fix.
After applying the fixes:
db2 terminate
db2 CONNECT TO ,dbname.
db2 BIND C:\SQLLIB\BND\@db2ubind.lst GRANT PUBLIC
db2 BIND C:\SQLLIB\BIND\@db2cli.lst GRANT PUBLIC
db2 terminate