473,839 Members | 1,398 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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\IB M\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.0705 02144154
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.0705 02144154
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForS erialization,
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.0705 02144154
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, base sys utilities, sqleserl, probe:10
RETCODE : ZRC=0xFFFFEC55=-5035

May 2 '07 #1
5 6165
Eric Davidson 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
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\IB M\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.0705 02144154
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.0705 02144154
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForS erialization,
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.0705 02144154
AUTHID : DB2ADMIN
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
May 2 '07 #2
On May 2, 10:54 am, "Jan M. Nelken" <Unknown.U...@I nvalid.Domain>
wrote:
Eric Davidson 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
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\IB M\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.0705 02144154
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.0705 02144154
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForS erialization,
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.0705 02144154
AUTHID : DB2ADMIN
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- Hide quoted text -

- Show quoted text -
Computer Name
Edavidsonlaptop

Full computer name
Edavidsonlaptop .CompanyX.com
May 2 '07 #3
Eric Davidson wrote:

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
May 2 '07 #4
On May 2, 11:53 am, "Jan M. Nelken" <Unknown.U...@I nvalid.Domain>
wrote:
Eric Davidson wrote:
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
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

May 2 '07 #5
Eric Davidson wrote:
>
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_COMPUTERNAM E_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
May 2 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2649
by: Rob R. Ainscough | last post by:
I keep getting this error message when I build my solution: Error: The dependency 'xxx.xx.xx, Version=1.0.2067.27633, Culture=neutral' in project 'xxx.xx.xx' cannot be copied to the run directory because it would conflict with dependency 'xxx.xx.xx, Version=1.0.2068.11260, Culture=neutral'. I have a solution that contains 10 class library projects, some of these projects require references to other projects within the solution....
0
2143
by: antsays | last post by:
I am trying to serialize a collection to disk using the code provided. This works just fine but when I try do copy and past the xml file to another location or sometimes even just click on the file it gives me the error: The instruction at "0x635e0719" referenced memory at "0x00000000". The momory could not be "read. Could anyone please help out with this
2
2916
by: lucy | last post by:
Hi, I use ADOX to create a Access database programmatically from my asp.net application and save ".mdb" file to a temp folder under my project foler on the web server. After database is created successfuly, I saw two files ".mdb" and ".ldb" in my temp folder. I have no problem to open the database manually. But when I'm tring to use Response.WriteFile() to download database file to end user's local machine, I kept getting the following
0
2634
by: lpinho | last post by:
Hi There, I've generated a C# file from a wsdl file using wsdl.exe utility. Then I created a console application and made a call to the method generated, first I got the error: "The request failed with HTTP status 407: Proxy Access Denied." Then I added a proxy validating and proxy credentials and got this:
1
3977
by: BillAtWork | last post by:
Hi, I'm trying to validate an XML document against an XSD schema and I receive the following error: ---------- MyCode.CreateValidRequest : System.Web.Services.Protocols.SoapException : Validation error: The element 'http://xmlns.somewhere.com/something:rDetail' cannot contain text. Expected 'http://xmlns.somewhere.com/something:AList'. An error occurred at , (1, 533). ----------
1
2587
by: BillAtWork | last post by:
Hi, I'm trying to validate an XML document against an XSD schema and I receive the following error: ---------- MyCode.CreateValidRequest : System.Web.Services.Protocols.SoapException : Validation error: The element 'http://xmlns.somewhere.com/something:rDetail' cannot contain text. Expected 'http://xmlns.somewhere.com/something:AList'. An error occurred at , (1, 533). ----------
1
5889
by: William Cruz | last post by:
Can anyone help me with this piece of code. - I keep on getting the error message "The object exporter specified was not found" If i change it to run on my local machine it works fine, the problem occurs when trying to connect to a remote pc. Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try
0
3398
by: Curious | last post by:
Hi, I'm not sure if this is the right place to post such command issues. If you know a better forum where people respond to messages fairly often, please let me know! Anyway, would appreciate your help! --------------------------------------------------------------------------------------------------------------- Hi, I've created a scheduler job with FORFILES command to delete files
3
7090
by: cmk817 | last post by:
Hi All, I'm just starting out (sort of)... and i can't even get connected to a database. We have an intranet server running CF... I'm trying to connect using dreamweaver... something funky is happening when i define a testing server (I'm wanting to use the same directory - so nothing is stored on my localmachine) I have tried everything and i keep gettig the same message when i click on specifiy the RDS login (i know that it is enabled with a...
1
3762
by: kamcap | last post by:
I have referenced a COM dll (unmanagged code) in a C# console application and this DLL is referenced in C# program using Interop facility in .NET. This dll actually a dataset/table which is written in Borland Delphi. static int Main(string args) { ClientVarDataSet vds = new ClientVarDataSet(); vds.XML = ""; vds.AddField("x", 3); //"x" field name and 3 field type
0
9855
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9697
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10586
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10293
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7828
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5682
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4484
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4064
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3133
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.