English

Error: S_insert_dbtuneTab_data(): Error insert data to DBTUNE table

Error Message

The following error may occur when running sdesetupdb2 on ArcSDE for DB2:

     S_insert_dbtuneTab_data(): Error insert data to DBTUNE table.

     ERROR in loading dbtune table. 
     Error: -51 
     DBMS error code: 0 

     Parameter UI_TEXT of keyword DATA_DICTIONARY failed to load. 
     Config Keyword: DATA_DICTIONARY 
     Parameter_name: UI_TEXT 
     Config_string :

     SDE schema object install not completed.

Full output when running sdesetupdb2:
------------------------

ESRI ArcSDE Server Setup Utility Wed Jul 13 12:53:19 2005
Instance initialized for SDE . . .

Install or update ArcSDE schema objects: Are you sure? (Y/N): Y VERSION table created...

SPATIAL_REFERENCES table being created...

SPATIAL_REFERENCES table created...

LAYERS table being created...

LAYERS table created...

RASTER_COLUMNS table being created...

RASTER_COLUMNS table created...

TABLE_REGISTRY table being created...

TABLE_REGISTRY table created...

STATES table being created...

STATES table created...

VERSIONS table being created...

VERSIONS table created...

CURRENT_STATE_LINEAGE table being created...

CURRENT_STATE_LINEAGE table created...

MVTABLES_MODIFIED table being created...

MVTABLES_MODIFIED table created...

METADATA table being created...

METADATA table created...

STATE_LINEAGES table being created...

STATE_LINEAGES table created...

LOCATORS table being created...

LOCATORS table created...

XML tables being created...

XML tables created...

COLUMN_REGISTRY table being created...

COLUMN_REGISTRY table created...

LOGFILE_POOL tables being created...
LOGFILE_POOL tables created...
DBMS functions being created...
DBMS functions created...
DBTUNE table being created...
DBTUNE table created...
SERVER_CONFIG tables being created...
SERVER_CONFIG tables created...
DBMS stored procedures being created or updated...
DBMS stored procedures created or updated...
Error inserting following data into DBTUNE table:

 Config keyword: DATA_DICTIONARY

 Parameter name: UI_TEXT

 Config String :

S_insert_dbtuneTab_data(): Error insert data to DBTUNE table.

ERROR in loading dbtune table.
Error: -51
DBMS error code: 0

 Parameter UI_TEXT of keyword DATA_DICTIONARY failed to load.
 Config Keyword: DATA_DICTIONARY
 Parameter_name: UI_TEXT
 Config_string :

SDE schema object install not completed.

Cause

The links to the sde stored procedures, sdesrvfn and sdesrvsp, are not set up correctly.

Solution or Workaround

On Windows:

  • Verify that the <db2 install>/sqllib/function directory contains the %SDEHOME%\lib\sdesrvfn.dll
  • Verify that the <db2 install>/sqllib/function/unfenced directory has the %SDEHOME%\lib\sdesrvsp.dll
On UNIX:
  • Create symbolic links in your <db2 install>/sqllib/function and <db2 install>/sqllib/function/unfenced directories.
    1. Login to the server as the DB2 instance owner.
    2. Change directories to your DB2 install's /sqllib/function directory.
    3. Create the link by issuing the following command:

      ln -s $SDEHOME/lib/sdesrvfn
       
    4. Change directories to your DB2 install's /sqllib/function/unfenced directory.
    5. Create the link by issuing the following command:

      ln -s $SDEHOME/lib/sdesrvsp