IDM 8.0 Schema Error

[Former Member]

Greetings,

I am noticing the following error when executing mxmc-update.sh to install IDM schema. Is this something that someone has seen before and is there a workaround?

mxmc-update.log:

*** Creating views

idmv_value_basic

idmv_value_basic_active

idmv_value_basic_all

idmv_value_ext

idmv_value_ext_active

idmv_value_ext_inactive

idmv_value_simple_all

idmv_value_ext2

idmv_link_ext

idmv_link_ext2

idmv_link_ext_active

idmv_entry_simple

idmv_entry_simple_inactive

idmv_entry_simple_all

idmv_link_simple_active

idmv_link_simple_inactive

idmv_link_simple_all

idmv_link_basic_active

idmv_vallink_simple

idmv_vallink_basic

idmv_vallink_basic_active

idmv_vallink_ext

idmv_vallink_ext_active

idmv_vallink_ext2

idmv_ovalue_simple_all

idmv_ovalue_basic_all

idmv_linkaudit_basic

idmv_linkaudit_simple

DB250101E: The command syntax is invalid. An unexpected token '' was found following '&'. Expected values include: '<variable>'.

DB250101E: The command syntax is invalid. An unexpected token '' was found following '&'. Expected values include: '<variable>'.

ERROR near line 3:

SQL0204N  "IC_OPER.IDMV_LINKAUDIT_SIMPLE" is an undefined name.

Failed to update ic_oper schema

removing temporary files

Thanks,

Travis

[krzysztof_kalinowski2 · Accepted solution]

Travis

What version of DB2 are you using? Some time ago I had a similar problem with 10.5 fix pack 7.

As a workaround I'm using version 10.5 fix pack 5.

Can you provide a link where you must use update script during new installation?

Regards,

Kris

[Former Member · Accepted solution]

Kris,

I am using DB2 10.5 fix pack 7. Just to be clear, I can install IDM8.0 DB2 runtime environment using DB2 10.5 fix pack 5 to get past this issue, right?

Page 39 of the installation guides states, " 4.Run the mxmc-update.sh script to reload the language file."

After you set export NLS_LANG=.AL32UTF8 --Unless I am interpreting this wrong.

I will let you know if DB2 10.5 fix pack 5 resolves my issue. Thanks

-Travis

[krzysztof_kalinowski2 · Accepted solution]

Travis

I think this chapter is about using Oracle db not DB2. You should start from page 43.

Regards,

Kris

[Former Member · Accepted solution]

Kris,

I was able to install the IDM schema using 10.5 fix pack 5 as you suggested. Thanks everyone for their immediate responses on this issue.

-Travus