Re: Login greater than 8 Characters

On 23 Oct 2003, at 9:03, Art S. Kagel wrote: > First Please do no post HTML, etc., many, like me, do not use a > browser to read the news group or mail gateways for that matter. Thank you for pointing that out. I fiddled around with some settings (Pegasus WinPmail V3.12c). Please rsvp if they didn't help. > The solution is to upgrade to 9.xx where database identifiers (ie > database, table, and column names) were increased from 18 characters > to 128 characters and usernames and other external identifiers were > increased from 8 chars to 32 characters. That seems like a good solution for a new instance. How can this help for an upgrade, where there is no root initialization taking place? How would the sysmaster database get modified? Regards, Zev Berezin B&H Photo Informix DBA sending to informix-list

On Thu, 23 Oct 2003 10:52:47 -0400, "Zev Berezin" <zevb@bhphotovideo.com> wrote: > >On 23 Oct 2003, at 9:03, Art S. Kagel wrote: > >> First Please do no post HTML, etc., many, like me, do not use a >> browser to read the news group or mail gateways for that matter. > >Thank you for pointing that out. >I fiddled around with some settings (Pegasus WinPmail V3.12c). >Please rsvp if they didn't help. > >> The solution is to upgrade to 9.xx where database identifiers (ie >> database, table, and column names) were increased from 18 characters >> to 128 characters and usernames and other external identifiers were >> increased from 8 chars to 32 characters. > >That seems like a good solution for a new instance. How can this >help for an upgrade, where there is no root initialization taking place? >How would the sysmaster database get modified? > The upgrade to 9.xx from 7.xx does convert pages in the root dbspace. Sysmaster would get modified as part of the upgrade process, as sysmaster just points to shared memory, etc...