while i am configuring with (db2 9.7) data base configurator i am getting following error a

, ,
1

Error in retrieving installed component version [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.INSTALLED_COMPONENT IS AN UNDEFINED NAME

  • drop Database Component: Analysis ANL
  • Versions
  • Version: db2luw 55
  • Scripts drop

  •   Script(1): C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/db2_anl_d_dml_dtp_parameters.sql

  •   Script(2): C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/db2_anl_d_ddl.sql

  •   Script(3): C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/db2_anl_d_ddl_views.sql

  •   Script(4): C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/webm_drop_dynamic_tables.sql

  •   Script(5): C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/db2_anl_d_ddl_dynamic.sql

  •   Script(6): C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/db2_anl_d_dml_tracking.sql

  •   Script(7): C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/db2_opt_ae_anl_d_dml_tracking.sql

  • Executing script : C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/db2_anl_d_dml_dtp_parameters.sql

Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.OPERATION_PARAMETER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.OPERATION_PARAMETER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.OPERATION_PARAMETER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.OPERATION_PARAMETER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.OPERATION_PARAMETER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.OPERATION_PARAMETER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.OPERATION_PARAMETER IS AN UNDEFINED NAME

  • Executing script : C:\SoftwareAG82\common\db/scripts/db2/analysis/55/drop/db2_anl_d_ddl.sql

Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_DIM_JOIN_TMP IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_ATTR_BLK_READING IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_ATTR_BLOCK IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_BAYES_ROW IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_COLUMN IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_CONDITION IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_ATTR_INST IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_KPI IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_RC_TEMPLATE IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_ROOT_CAUSE IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_MONITOR_READING IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_AGG_FACT IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_AGG_DIM IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_AGGREGATION IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_DB_DEF IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_DISCOVERY IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_ASSET_TYPE IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_DATE_ATTR IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_DATE_COL IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_RULE_AUDIT IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_CUSTOM_TREE_ACCESS IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_DIMENSION_SUBSCRIBER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_JOB_AUDIT IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_CUSTOM_TREE_DIM_FILTER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_FILTER_TREE_NODE IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_MONITOR_PATH IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_CUSTOM_TREE_KWRD_FILTER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_CUSTOM_TREE_FILTER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_RCFP_CAUSE_DSC IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_RCFP_DETAIL IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_RCFP_TEMPLATE IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_KPI_TREE_NODE IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_ACTION_JMSVNT_PARAMS IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_ACTION_JMS_EVENT IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_EVENT IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_BAYES IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_WAREHOUSE_STATS_FACT IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_LP_MARK IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_ACTION_SNMPTRAP IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_CKPI_AGG_DIM IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_CKPI_AGG IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_ANALYSIS_RULE_HAS_ACTION IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_ACTION_WEBSVC_PARAMS IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_ACTION_WEBSVC IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PRED_ATTR IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_ACTION_NOTIF IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.DG_ANALYSIS_ACTION IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_FACT_COL IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_GENERIC_ATTR IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_GENERIC_ATTR_COL IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_MONITOR_DIM IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_METADATA_ATTR IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_METADATA_DISPLAY IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_METADATA IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_NEW_DIM IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_MONITOR_LAST_READING IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_OBJECT_HEAD IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_TMP_ATTR IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_EVENT_TMP IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_PROCESS_TREE_NODE IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_RLINST_TO_MNTR IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_FILTER_DIMENSION_IDS IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_FILTER_DIMENSION IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_FILTER IS AN UNDEFINED NAME
Ignoring Error[sag-cjdbc42-0011][DB2 JDBC Driver][DB2]MSSUSR24.BAM_FOLDER_TREE_NODE IS AN UNDEFINED NAME

2

Hi Ramanjaneyulu,

can you check in the DB if the user mssusr24 and the tablespaces WEBMDATA and WEBMINDX have been created?

Another question:
Why are you trying to drop the database components when your subject of the post talks about creating?

Please provide DB-Configurator version as well as the fix levels for DB-Configurator and DB-Scripts.

Regards,
Holger

3

thanks,actually i am using data base configurator 8.2

4

Hi Ramanjaneyulu,

please check for DC_8.2_DBS_Fix13 as well as for the latest SCG_8.2_DataDirect-Fix.

There is an option for creating the users and tablespaces automaticallly throgh db configurator.
You will need access to an account with admin rights (DBA) to do so.

Regards,
Holger