Cannot drop access_nethod

Hi experts, we have got a weird situation here. For some reason some time in the past somebody accidentally initiated a bts datablade installation in a database. Since this was not used anywhere, it did not cause any issues. On upgrade of the server to IDS14.10, an error was thrown when the upgrade mechanism tried to upgrade the datablade, which was not successful. We tried to remove all of the datablade stuff manually and t he upgrade was done despite of the problematic datablade. This was mainly successful, but there are two relicts: create secondary access_method "informix".bts ( am_create = \\ufffd)\\ufffd!\\ufffd^?, am_drop = \\ufffd)\\ufffd!\\ufffd^?, am_open = \\ufffd)\\ufffd!\\ufffd^?, am_close = \\ufffd)\\ufffd!\\ufffd^?, am_insert = \\ufffd)\\ufffd!\\ufffd^?, am_delete = \\ufffd)\\ufffd!\\ufffd^?, am_update = \\ufffd)\\ufffd!\\ufffd^?, am_stats = \\ufffd)\\ufffd!\\ufffd^?, am_scancost = \\ufffd)\\ufffd!\\ufffd^?, am_check = \\ufffd)\\ufffd!\\ufffd^?, am_beginscan = \\ufffd)\\ufffd!\\ufffd^?, am_endscan = \\ufffd)\\ufffd!\\ufffd^?, am_rescan = \\ufffd)\\ufffd!\\ufffd^?, am_getnext = \\ufffd)\\ufffd!\\ufffd^?, am_truncate = \\ufffd)\\ufffd!\\ufffd^? ); create primary access_method "informix".bts_info ( am_sptype = 'x', am_create = \\ufffd)\\ufffd!\\ufffd^?, am_drop = \\ufffd)\\ufffd!\\ufffd^?, am_open = \\ufffd)\\ufffd!\\ufffd^?, am_close = \\ufffd)\\ufffd!\\ufffd^?, am_scancost = \\ufffd)\\ufffd!\\ufffd^?, am_beginscan = \\ufffd)\\ufffd!\\ufffd^?, am_endscan = \\ufffd)\\ufffd!\\ufffd^?, am_getnext = \\ufffd)\\ufffd!\\ufffd^? ); The reason for this stuff is unknown to us and we just want to remove the access method, because the dbexport is not good to be automatically restored without errors when this code is in the sql file. The fragments seem to be in UTF-8 encoding, but the database has ISO-8859-15 encoding. According to the documentation, the following should work: drop access_method bts restrict; This results in error 9867 -> Access method (bts) not found So is there a trick how to drop this relicts ? Or would it be a call to tech support to handle this ? Thank you for your input.

If you can dbexport/myexport the dbimport/myimport the database, just do the export then edit the .sql file to remove the references to the access method drop and reload the database using the modified .sql file. If no, yes, I would create a PMR and have support patch it up. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------