LOCALE TROUBLE Answered: amber (solid confidence) — Art Kagel's core fix (match DB_LOCALE to the database before dropping it) is sound, and Lester Knutsen later corrects Art's own tentative guess at the sysmaster table name (sysdbinfo) to the actual sysdbslocale, but the asker's thanks came before that correction and no final confirmation follows.

Advisory only.

Posted in 2015

Summary

A user on Informix 11.7.FC7 (HP-UX Itanium) couldn't access or drop databases created before DB_LOCALE/CLIENT_LOCALE were set, getting "Failed to rebuild node contents: Database locale information mismatch." Replies advised setting DB_LOCALE (and CLIENT_LOCALE) in the environment to match the database's locale before connecting. To find each database's locale without connecting, Art Kagel suggested the sysmaster catalog or his utils2_ak tool (listdb7 -d db -D), and Lester Knutsen pointed to 'select * from sysmaster:sysdbslocale'. The poster thanked them; no confirmation of the final outcome is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Internationalization & Character Sets

André Luiz Rufino — Mon, 26 Jan 2015 17:21:44 — source: IIUG Forums & Mailing Lists

Hi folks. It's me again. I'm trying to drop a database but I cant even access it. Everytime I try it the server gave me the message "Failed to rebuild node contents: Database locale information mismatch."I believe it is because some databases was created BEFORE the DB_LOCALE and CLIENT_LOCALE has been configured. And now I cant drop then.Informix 11.7 FC7 on HPUX Itanium 11.31 64 bit Is there a way to fix this problem ? Thanks a lot, André Luiz Rufino

↪ replying to André Luiz Rufino

Stefan Sammut — Mon, 26 Jan 2015 17:30:02 — source: IIUG Forums & Mailing Lists

Maybe you check db_locale value and export CLIENT_LOCALE to same value or a subset of it . Prior connecting to engine ? Sent from my iPhone > On 26 Jan 2015, at 18:22, André Luiz Rufino <andre_rufino@msn.com> wrote: > > Hi folks. It's me again. > I'm trying to drop a database but I cant even access it. Everytime I try it > the server gave me the message > "Failed to rebuild node contents: Database locale information mismatch."I > believe it is because some databases was created BEFORE the DB_LOCALE and > CLIENT_LOCALE has been configured. And now I cant drop then.Informix 11.7 FC7 > on HPUX Itanium 11.31 64 bit > Is there a way to fix this problem ? > Thanks a lot, > André Luiz Rufino > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > Stefan Sammut Manager - Solutions & Innovation [PTL Ltd] Nineteen Twenty Three, Valletta Road Marsa, MRS 3000, MT T +35621445566 +356 99405444 stefan.sammut@ptl.com.mt | www.ptl.com.mt<http://www.ptl.com.mt>; [Facebook]<https://www.facebook.com/PTLMalta/app_349313058487732>; [LinkedIn] <https://www.linkedin.com/company/ptl-ltd?trk=tyah&trkInfo=tarId%3A1401716999276 %2Ctas%3APTL%2Cidx%3A2-3-8> [Twitter] <https://twitter.com/PTL_Malta>; [Youtube] <https://www.youtube.com/channel/UCuXrJBO_54kd9HttG8S89iQ/feed?view_as =public> [Google Plus] <https://plus.google.com/+PTLMalta>;

↪ replying to André Luiz Rufino

Art Kagel — Mon, 26 Jan 2015 17:31:28 — source: IIUG Forums & Mailing Lists

Change your DB_LOCALE in your environment to match the database you are trying to drop. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jan 26, 2015 at 12:21 PM, André Luiz Rufino <andre_rufino@msn.com> wrote: > Hi folks. It's me again. > I'm trying to drop a database but I cant even access it. Everytime I try it > the server gave me the message > "Failed to rebuild node contents: Database locale information mismatch."I > believe it is because some databases was created BEFORE the DB_LOCALE and > CLIENT_LOCALE has been configured. And now I cant drop then.Informix 11.7 > FC7 > on HPUX Itanium 11.31 64 bit > Is there a way to fix this problem ? > Thanks a lot, > André Luiz Rufino > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0160bbf87d87db050d918118

↪ replying to Art Kagel

André Luiz Rufino — Mon, 26 Jan 2015 17:45:58 — source: IIUG Forums & Mailing Lists

Ok, But how do I know the database locale if I cant access it ? > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: LOCALE TROUBLE [34518] > Date: Mon, 26 Jan 2015 12:31:29 -0500 > > Change your DB_LOCALE in your environment to match the database you are > trying to drop. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Mon, Jan 26, 2015 at 12:21 PM, André Luiz Rufino <andre_rufino@msn.com> > wrote: > > > Hi folks. It's me again. > > I'm trying to drop a database but I cant even access it. Everytime I try it > > the server gave me the message > > "Failed to rebuild node contents: Database locale information mismatch."I > > believe it is because some databases was created BEFORE the DB_LOCALE and > > CLIENT_LOCALE has been configured. And now I cant drop then.Informix 11.7 > > FC7 > > on HPUX Itanium 11.31 64 bit > > Is there a way to fix this problem ? > > Thanks a lot, > > André Luiz Rufino > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e0160bbf87d87db050d918118 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to André Luiz Rufino

Art Kagel — Mon, 26 Jan 2015 17:51:33 — source: IIUG Forums & Mailing Lists

There is a sysmaster table (sysdbinfo I think - no access to a server today) that has the locale info for every database. If you have my utils2_ak package, the listdb7.ec utility will report it if you use the -D option: listdb7 -d mydatabase -D Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jan 26, 2015 at 12:45 PM, André Luiz Rufino <andre_rufino@msn.com> wrote: > Ok, But how do I know the database locale if I cant access it ? > > > To: ids@iiug.org > > From: art.kagel@gmail.com > > Subject: Re: LOCALE TROUBLE [34518] > > Date: Mon, 26 Jan 2015 12:31:29 -0500 > > > > Change your DB_LOCALE in your environment to match the database you are > > trying to drop. > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.com > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on the IIUG, nor any other organization with which I > am > > associated either explicitly, implicitly, or by inference. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity with which I am affiliated nor those of the entities themselves. > > > > On Mon, Jan 26, 2015 at 12:21 PM, André Luiz Rufino < > andre_rufino@msn.com> > > wrote: > > > > > Hi folks. It's me again. > > > I'm trying to drop a database but I cant even access it. Everytime I > try > it > > > the server gave me the message > > > "Failed to rebuild node contents: Database locale information > mismatch."I > > > believe it is because some databases was created BEFORE the DB_LOCALE > and > > > CLIENT_LOCALE has been configured. And now I cant drop then.Informix > 11.7 > > > FC7 > > > on HPUX Itanium 11.31 64 bit > > > Is there a way to fix this problem ? > > > Thanks a lot, > > > André Luiz Rufino > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e0160bbf87d87db050d918118 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b3a8192510f0a050d91c9b0

↪ replying to Art Kagel

André Luiz Rufino — Mon, 26 Jan 2015 20:53:43 — source: IIUG Forums & Mailing Lists

Allright Art Thanks a lot... > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: LOCALE TROUBLE [34520] > Date: Mon, 26 Jan 2015 12:51:34 -0500 > > There is a sysmaster table (sysdbinfo I think - no access to a server > today) that has the locale info for every database. If you have my > utils2_ak package, the listdb7.ec utility will report it if you use the -D > option: > > listdb7 -d mydatabase -D > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Mon, Jan 26, 2015 at 12:45 PM, André Luiz Rufino <andre_rufino@msn.com> > wrote: > > > Ok, But how do I know the database locale if I cant access it ? > > > > > To: ids@iiug.org > > > From: art.kagel@gmail.com > > > Subject: Re: LOCALE TROUBLE [34518] > > > Date: Mon, 26 Jan 2015 12:31:29 -0500 > > > > > > Change your DB_LOCALE in your environment to match the database you are > > > trying to drop. > > > > > > Art > > > > > > Art S. Kagel, President and Principal Consultant > > > ASK Database Management > > > www.askdbmgt.com > > > > > > Blog: http://informix-myview.blogspot.com/ > > > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > > and do not reflect on the IIUG, nor any other organization with which I > > am > > > associated either explicitly, implicitly, or by inference. Neither do > > > those opinions reflect those of other individuals affiliated with any > > > entity with which I am affiliated nor those of the entities themselves. > > > > > > On Mon, Jan 26, 2015 at 12:21 PM, André Luiz Rufino < > > andre_rufino@msn.com> > > > wrote: > > > > > > > Hi folks. It's me again. > > > > I'm trying to drop a database but I cant even access it. Everytime I > > try > > it > > > > the server gave me the message > > > > "Failed to rebuild node contents: Database locale information > > mismatch."I > > > > believe it is because some databases was created BEFORE the DB_LOCALE > > and > > > > CLIENT_LOCALE has been configured. And now I cant drop then.Informix > > 11.7 > > > > FC7 > > > > on HPUX Itanium 11.31 64 bit > > > > Is there a way to fix this problem ? > > > > Thanks a lot, > > > > André Luiz Rufino > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --089e0160bbf87d87db050d918118 > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --047d7b3a8192510f0a050d91c9b0 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to Art Kagel

Lester Knutsen — Mon, 26 Jan 2015 22:01:39 — source: IIUG Forums & Mailing Lists

In the sysmaster database try select * from sysdbslocale Regards - Lester On 1/26/15 12:51 PM, Art Kagel wrote: > There is a sysmaster table (sysdbinfo I think - no access to a server > today) that has the locale info for every database. If you have my > utils2_ak package, the listdb7.ec utility will report it if you use the -D > option: > > listdb7 -d mydatabase -D > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Mon, Jan 26, 2015 at 12:45 PM, André Luiz Rufino <andre_rufino@msn.com> > wrote: > >> Ok, But how do I know the database locale if I cant access it ? >> >>> To: ids@iiug.org >>> From: art.kagel@gmail.com >>> Subject: Re: LOCALE TROUBLE [34518] >>> Date: Mon, 26 Jan 2015 12:31:29 -0500 >>> >>> Change your DB_LOCALE in your environment to match the database you are >>> trying to drop. >>> >>> Art >>> >>> Art S. Kagel, President and Principal Consultant >>> ASK Database Management >>> www.askdbmgt.com >>> >>> Blog: http://informix-myview.blogspot.com/ >>> >>> Disclaimer: Please keep in mind that my own opinions are my own opinions >>> and do not reflect on the IIUG, nor any other organization with which I >> am >>> associated either explicitly, implicitly, or by inference. Neither do >>> those opinions reflect those of other individuals affiliated with any >>> entity with which I am affiliated nor those of the entities themselves. >>> >>> On Mon, Jan 26, 2015 at 12:21 PM, André Luiz Rufino < >> andre_rufino@msn.com> >>> wrote: >>> >>>> Hi folks. It's me again. >>>> I'm trying to drop a database but I cant even access it. Everytime I >> try >> it >>>> the server gave me the message >>>> "Failed to rebuild node contents: Database locale information >> mismatch."I >>>> believe it is because some databases was created BEFORE the DB_LOCALE >> and >>>> CLIENT_LOCALE has been configured. And now I cant drop then.Informix >> 11.7 >>>> FC7 >>>> on HPUX Itanium 11.31 64 bit >>>> Is there a way to fix this problem ? >>>> Thanks a lot, >>>> André Luiz Rufino >>>> >>>> >>>> >>>> >> > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>>> >>>> >>> --089e0160bbf87d87db050d918118 >>> >>> >>> >> > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --047d7b3a8192510f0a050d91c9b0 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________