Is This Content Helpful?
We're glad to know this article was helpful.
The following error may occur when creating the ArcSDE repository for DB2:
"SDE_Database Error: -1
ODBC Error: HY000
Database Error: -1109
Error Message: [IBM][CLI Driver][DB2/NT] SQL1109N The specified DLL "sdesrvsp"
could not be loaded.
SDE_Database Error: -1
Database Error: 0
ERROR in loading dbtune table.
DBMS error code: 0
SDE schema object install not completed."
This error is caused when the sdesrvsp.dll file fails to get copied from the %SDEHOME%\bin directory to the %DB2PATH%\SQLLIB\function directory during the installation of ArcSDE for DB2.
To resolve this problem the ArcSDE database in DB2 needs to be cleaned. Use the Control Center to perform steps 2-5 before re-creating the ArcSDE repository manually. If you run the postinstallation again after copying the .dll file, the error will still occur.
Dropping the tables should remove all associated indexes automatically.
This cannot be accomplished using the Control Center.
drop package sdesrvsp