APAR status
Closed as program error.
Error description
The blademanager fails to register datablades into databases with DB_LOCALE=<lang>_<terr>.utf8 when SQL_LOGICAL_CHAR is set to ON, 1, 2, 3 or 4. > blademgr on1150>list utf8_db blademgr: ERROR: Prepare failed in current database. EXECUTE FUNCTION sysbldprepare ('bts.2.00', 'create'); (U0001) - registerBlade - Unable to register bts.2.00 - unknown error - check online log and sysblderrorlog table for more information select * from sysblderrorlog; order 91 bld_id bts.2.00 err_operation SYSBldRegister err_expected unexpected err_sql_stmt delete from sysbldobjects where not state = 'R'; err_sql_state X42000:-206 : The specified table (sysbldobjects) is not in the database.XIX000:-111 : : ISAM error: no record found. ...
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of IDS 11.50 and above. * **************************************************************** * PROBLEM DESCRIPTION: * * When SQL_LOGICAL_CHAR is set in the onconfig file, blade * * registration would fail. * **************************************************************** * RECOMMENDATION: * * Either request a patch or wait until IDS 11.50.xC10 or * * 11.70.xC5 or later is released. * ****************************************************************
Problem conclusion
When SQL_LOGICAL_CHAR feature was added to server, it did not make it compatible to the existing blade registration. Now the new code is added to make blade registration working with SQL_LOGICAL_CHAR feature. Fixed in IDS 11.50.xC10 and 11.70.xC5.
Temporary fix
Comments
APAR Information
APAR number
IC76197
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-05-05
Closed date
2017-06-15
Last modified date
2024-09-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 September 2024