Home > Error Occurred > An I/o Error Occurred While Accessing The Node Directory

An I/o Error Occurred While Accessing The Node Directory

Contents

SQLSTATE=42601 > > which is correct drive for sample? Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit If installing the sample database, drop it and install the sample database again. db2 => drop database sample SQL1039C An I/O error occurred while accessing the database directory. http://svbuckeye.com/error-occurred/an-error-occurred-while-accessing-the-directory.php

Liao -- Posted via [url]http://dbforums.com[/url] Liao Guest July 18th,01:39 PM #14 Re: SQL1039C Error while creating a DB on 7.1 - Win2k Ah, OK now we're getting somewhere. I have the same error message. User Response: Resubmit the command. RE: SQL1039C lucky888 (Programmer) (OP) 27 Jul 05 14:19 I tried those 3 steps but still got:SQL1039CAn I/O error occurred while accessing the database directory. http://www.dbforums.com/showthread.php?1636869-SQL1038C-An-I-O-error-occurred-while-accessing-the-node-directory-SQLSTATE-58031

Sql1038c An I/o Error Occurred While Accessing The Node Directory. Sqlstate=58031

To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (972)766-6900 in Texas; or (800)835-8699 in New Mexico. ********** --------------------------------------------------------------------------------- Welcome to the IDUG Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode June 29th,05:12 PM #1 Re: SQL1039C Error while I'm quite sure now that this is *exactly* the problem.

Are you able to connect to the SATCTLDB database from the command line? -- Larry Menard IBM Workstation Database (DB2) Performance Team Defender of Geese and of All Things Natural "Pierre The solution you mentioned: 1. Otherwise, try doing as Pierre says. An Unknown Error Occurred While Accessing Solidworks Sheet Format db2 => catalog database c:\sqllib\sample SQL1000N "\sample" is not a valid database alias name.

Our only resolution to this has been to recycle the server, but that's not a great option for a production server. Db21019e An Error Occurred While Accessing The Directory Here's what I seem to recall... I happen to do the same thing as Hu song and get the same result. http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql01039c.html The DSN tests out fine under Client Configuration Assistant.

The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm Randy Martin Re: DB2 connect error SQL1038C June 18, 2004 An Unknown Error Occurred While Accessing The Upgrade File RE: SQL1039C lucky888 (Programmer) (OP) 27 Jul 05 11:47 I got following error when i uncatalog and drop database again.SQL1013N The database alias name or database name "abc" could not be Have you solved your problem? See if you can find the name of the database in there and get the associated SQL0000n. [n is a number] Then check if SQL0000n directory got deleted under C:\DB2\NODE0000.When you

Db21019e An Error Occurred While Accessing The Directory

Basically I need to be a DB2 Administrator in order to create a new connection. http://www.idug.org/p/fo/et/thread=18523 Now I have removed the db2 by windows remove software and delete c:\SQLLIB. Sql1038c An I/o Error Occurred While Accessing The Node Directory. Sqlstate=58031 Mark wrote: The user that I use is the instance administrator user, so that user has the necessarie permissions. Db21019e An Error Occurred While Accessing The Directory /root Now I can see sample database from control center, when I clicked sample, it prompted: [IBM][CLI Driver] SQL1039C An I/O error occurred while accessing the database directory.

The IDUG DB2-L FAQ is at http://www.idugdb2-l.org . http://svbuckeye.com/error-occurred/an-error-occurred-while-adding-node-access-denied.php Other wise you can not resolve this error. Copyright 2006 - 2014, JustSkins.com 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Thanks in advance for your help, Randy --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. An Unknown Error Occurred While Accessing

This error may occur not only when the system is cataloging or uncataloging a database but also when the system is accessing a database that is cataloged in the directory. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. SQL10004C An I/O error occurred while accessing the database directory. check over here Juliane RE: SQL1039C rbod (Programmer) 28 Jul 05 09:49 There is a file "SQLDBDIR" under C:\DB2\NODE0000\SQLDBDIR, that lists the databases.

Randy --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. An Unknown Error Occurred While Accessing An Unnamed File SQLSTATE=08003 I try to drop the sample in control center, it prompts SQL1039C An I/O error occurred while accessing the database directory. Sitting on the Connect server do you get the I/O error when you enter either of these commands?

I am sorry I have not written clearly in my previous post.

The user you logged in has permission problem to access db2 data The user that I use is the instance administrator user, so that user has the necessarie permissions. Verify that it is not write-protected. -If the database directory is damaged, restore the databases that were cataloged there from backup versions and catalog them. I have done nothing to SATCTLDB. An Unknown Error Occurred While Accessing Revit Expected tokens may include: "".

Thanks in advance for your help, Randy ---------------------------------------------------------------------------- ----- Welcome to the IDUG DB2-L list. Kitts & Nevis St. I suggest you do the following: 1) Remove any "sample" database if it does already exist 1a) catalog the database in case it exists but is not currently cataloged ("db2 catalog http://svbuckeye.com/error-occurred/an-error-occurred-while-accessing-the-directory-root.php Because even I have uninstalled db2 7.2(the db2 director dispeared), reinstalled db2 7.2, I got the same result.

From that page select "Join or Leave the list". Thank you. -R- Oct 23 '06 #2 This discussion thread is closed Start new discussion Replies have been disabled for this discussion. Home Blog About Subscribe Admin Contact Me Powered by WordPress 418,420 Members | 1,770 Online Join Now login Ask Question Home Questions Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum!

This is due to i used to drop a database called "abc".SQL1039CAn I/O error occurred while accessing the database directory. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. db2 => uncatalog db c:\db2\sample SQL0104N An unexpected token "c:\db2\sample" was found following "DB". Have you solved your problem?

Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Where is the Directory Cache Support setting? If I run the command : db2 list db directory on I can see the information of my databse directory. Other wise you can not resolve this error.

should be: Please post here the results of a "db2 list db directory" on your system. -- Larry Menard IBM Workstation Database (DB2) Performance Team Defender of Geese and of All I am also supprised to see the result you mentioned. being dense again. Fortunately I have backup of database 'abc'.

Any time I personally have seen a SQL1039C it is because the database directory on the target drive is down-level from the actual version of DB2 installed, but I have no The err is still there when I create sample database. -- Posted via [url]http://dbforums.com[/url] Liao Guest June 29th,06:12 PM #2 Re: SQL1039C Error while creating a DB on 7.1 - Win2k When I said that I didn't know you had removed V8 and installed V7. I installed FP7a, but for some reason when I do a "db2 list db directory" on the server as the instance id, I am getting the following error for all the

Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. SQL1038C SQL1038C An I/O error occurred while accessing the node directory. OK × Welcome to Dell Software Support You can find online support help for Dell *product* on an affiliate support site.