Error Message - 111 "The file name is too long."

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric Davidson - 02 May 2007 15:49 GMT

I keep getting the folowing error message in my db2diag.log every
couple of seconds, and I can not find any information on this on the
DB2 website or in the apr's

Can anyone give me a pointer why this is happening.

PS I only noticed this once I had migrated to v9

db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release
"SQL09012" with level identifier "01030107". Informational tokens are
"DB2 v9.1.200.98", "s070210", "WR21380", and Fix Pack "2".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name
"DB2V9".

2007-05-02-10.41.54.798000-240 E573804H450 LEVEL: Error (OS)
PID : 368 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-579 APPID: *LOCAL.DB2.070502144154
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, oper system services, sqloGroupHasSID, probe:10
MESSAGE : ZRC=0x8300006F=-2097151889
CALLED : OS, -, GetComputerName
OSERR : 111 "The file name is too long."

2007-05-02-10.41.54.818000-240 I574256H372 LEVEL: Severe
PID : 368 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-579 APPID: *LOCAL.DB2.070502144154
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization,
probe:30
RETCODE : ZRC=0xFFFFEC55=-5035

2007-05-02-10.41.54.818000-240 I574630H353 LEVEL: Severe
PID : 368 TID : 2388 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-579 APPID: *LOCAL.DB2.070502144154
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, base sys utilities, sqleserl, probe:10
RETCODE : ZRC=0xFFFFEC55=-5035

Reply to this Message

Jan M. Nelken - 02 May 2007 15:54 GMT

> I keep getting the folowing error message in my db2diag.log every
> couple of seconds, and I can not find any information on this on the
[quoted text clipped - 37 lines]
> FUNCTION: DB2 UDB, base sys utilities, sqleserl, probe:10
> RETCODE : ZRC=0xFFFFEC55=-5035

Whot is your host name length?

(My Computer -> Properties -> Computer name)

Jan M. Nelken

Reply to this Message

Eric Davidson - 02 May 2007 16:21 GMT

On May 2, 10:54 am, "Jan M. Nelken" <Unknown.U...@Invalid.Domain>
wrote:

> > I keep getting the folowing error message in my db2diag.log every
> > couple of seconds, and I can not find any information on this on the
[quoted text clipped - 45 lines]
>
> - Show quoted text -

Computer Name
Edavidsonlaptop

Full computer name
Edavidsonlaptop.CompanyX.com

Reply to this Message

Jan M. Nelken - 02 May 2007 16:53 GMT

> Computer Name
> Edavidsonlaptop
>
> Full computer name
> Edavidsonlaptop.CompanyX.com

Computer name has 15 characters in length; I think limit is 14
characters - or even 8.

Change computer name no 14 characters and try again.

Jan M. Nelken

Reply to this Message

Eric Davidson - 02 May 2007 18:31 GMT

On May 2, 11:53 am, "Jan M. Nelken" <Unknown.U...@Invalid.Domain>
wrote:

> > Computer Name
> > Edavidsonlaptop
[quoted text clipped - 8 lines]
>
> Jan M. Nelken

Hi Jan,

Thanks for the feedback.

I dont have the option to change my machine name.
Also I only started seeing this once I had upgraded to V9.
Are there any other work rounds or options.

Regards
Eric

Reply to this Message

Jan M. Nelken - 02 May 2007 21:24 GMT

> I dont have the option to change my machine name.
> Also I only started seeing this once I had upgraded to V9.
> Are there any other work rounds or options.

Failing API call is MS GetComputerName(). Reported error 111 simply
means "Name too long".

You either change your machine name (try EricLaptop for example) or open
a PMR with Db2 service.

MAX_COMPUTERNAME_LENGTH is defined as 31 in winbase.h (so assuming worst
case scenario - 14 char name + terminating NULL converted to Unicode
should fit into it - while 15 char name + terminating NULL will not
.

Jan M. Nelken

Reply to this Message