f



SQL1326N The file or directory cannot be accessed

Hello,

using 9.1 I'm trying to create a database in the instance 'bruno' but
receive following error code :

SQL1326N  The file or directory "/home/bruno/" cannot be accessed

Platform is Linux and I tried :
chmod 777 /home/bruno 
chmod -R 777 /home/bruno/sqllib/

but without success.
Thanks for any clue.

Bye,
Bruno

0
Bruno
10/9/2006 5:50:49 AM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

2 Replies
10691 Views

Similar Articles

[PageSpeed] 49

Bruno Costacurta wrote:
> Hello,
> 
> using 9.1 I'm trying to create a database in the instance 'bruno' but
> receive following error code :
> 
> SQL1326N  The file or directory "/home/bruno/" cannot be accessed

It would be helpful if you gave the actual command that you tried.

> Platform is Linux and I tried :
> chmod 777 /home/bruno 
> chmod -R 777 /home/bruno/sqllib/
> 
> but without success.


Certainly without success.  That also hosed your instance by messing up
all of the permissions.  To fix, stop any processes running as bruno,
and then, as root, you can run 'db2iupdt bruno' (db2iupdt is in the 
<install>/instance directory).


Then post the create database command you ran again.

0
Ian
10/9/2006 2:51:40 PM
Ian wrote:

> Bruno Costacurta wrote:
>> Hello,
>> 
>> using 9.1 I'm trying to create a database in the instance 'bruno' but
>> receive following error code :
>> 
>> SQL1326N  The file or directory "/home/bruno/" cannot be accessed
> 
> It would be helpful if you gave the actual command that you tried.
> 
>> Platform is Linux and I tried :
>> chmod 777 /home/bruno
>> chmod -R 777 /home/bruno/sqllib/
>> 
>> but without success.
> 
> 
> Certainly without success.  That also hosed your instance by messing up
> all of the permissions.  To fix, stop any processes running as bruno,
> and then, as root, you can run 'db2iupdt bruno' (db2iupdt is in the
> <install>/instance directory).
> 
> 
> Then post the create database command you ran again.
> 

I solved this by creating a new user and a related instance.
I suppose this design is better.

Bye,
Bruno
 
0
Bruno
10/10/2006 5:47:06 AM
Reply:

Similar Artilces:

SQL1326N : file or directory cannot be accessed
Hello, using 10g I'm trying to create a database in the instance 'bruno' but receive error code : SQL1326N The file or directory "/home/bruno/" cannot be accessed Platform is Linux and I tried : chmod 777 /home/bruno chmod -R 777 /home/bruno/sqllib/ but without success. Thanks for any clue. Bye, Bruno Bruno Costacurta wrote: > Hello, > > using 10g I'm trying to create a database in the instance 'bruno' but > receive error code : > > SQL1326N The file or directory "/home/bruno/" cannot be accessed > > Platform is Lin...

Accessing Access database files
Is there a JDBC driver or non-JDBC class library that would give a Java program read/write access to the tables and schema in a MS Access database? I don't need to update the database, just examine the schema and table contents. I don't have a copy od the Access software and nowhere to run it because all my computers run Linux. -- martin@ | Martin Gregorie gregorie. | Essex, UK org | On 7/1/2014 9:28 AM, Martin Gregorie wrote: > Is there a JDBC driver or non-JDBC class library that would give a Java > program read/write access to the tables and sc...

Using .NET to access to a IBM DB2 database
Hello I'm trying to connect to a IBM DB2 database with IBMDA400 Provider. I cannot choose the provider, this is the only one I can use. The tables in AS/400 don't have journal and I cannot change this. When I define an ODBC and link tables in ACCESS I can perform every actions. I change the ODBC options to commit data immediately. Using the same ODBC and the same insert statement, when I connect in my C# application using ODBCConnection, I get this error: ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2 UDB]SQL0206 - Column N not in specified tables. What I want is to use a DNS Less situation, and I want to enter in the connection string all the parameters to connect to the AS/400 database. This is my connection string:Provider=IBMDA400;Data Source=999.999.999.999; When I put the AutoCommit option in the connection string I get this error: No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21). I get this message even when the autocommit is 1, 0, true or false and this is the connection string: Provider=IBMDA400;Data Source=192.168.192.12;autocommit=0 right now I can perform all the operation with Access database but I can't with my .NET application in C#. anyone can assist me? tkx in advance Paulo Aboim Pinto Esqueleto wrote: > ERROR [42S22] [IBM][Controlador ODBC do iSeries Access][DB2 > UDB]SQL0206 - Column N not in specified tables. Are you submitting a query with a VARIA...

IBM.Data.DB2.iSeries database access problem
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error: IBM.Data.DB2.iSeries.iDB2ConnectionFailedException "The connection cannot be opened because an error ocurred." I'm running IBM iSeries Acc...

IBM.Data.DB2.iSeries database access problem
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error: IBM.Data.DB2.iSeries.iDB2ConnectionFailedException "The connection cannot be opened because an error ocurred." I'm runn...

files, directories, files, directories
Hi folks, I've been trying to make a decision and it's driving me crazy. Is a directory a file or is a directory NOT a file but a node? Should I have A) public interface IFile { IFileName FileName; IContent GetContent(); } public interface IDirectory extends IFile { } or B) public interface INode { INodeName NodeName; } public interface IFile extends INode { IContent GetContent(); } public interface IDirectory extends INode { } Method A is nice cause IFile becomes the base "Node" type and you can use names like "IFileName" which sound...

How do I redirect ouptut from the List Database Directory command from DB2 CLP on AIX to a file?
What I want to do is take that output, use the data within it to put into a shell script as input to another installation of DB2 Connect on another AIX box. Any ideas about how to do this? Mary Jane Pronio wrote: > What I want to do is take that output, use the data within it to put > into a shell script as input to another installation of DB2 Connect on > another AIX box. Any ideas about how to do this? The usual way? db2 list db directory > db.list It works fine on Linux. -- Knut Stolze Information Integration IBM Germany / University of Jena Mary J...

How can I resolve a "SQL1326N: The file or directory cannot be accessed" restore problem?
Hi all, I am having problem completing this restore operation. "db2 restore database AAMI01 from /pap/data/backups taken at 20071002130554 to /pap/data/db01 into AAMI01 NEWLOGPATH /pap/data/new/ log WITH 2 BUFFERS BUFFER 1024" SQL1326N The file or directory "/pap/data/db01/" cannot be accessed. The file, directory and path all exist. I created them. I just can't understand why I can't tell restore where I want to put down the database. If I remove the " to /pap/data/db01", restore will try to put the DB in a directory that I want to avoid. I want to restore to "/pap/data/ db01" specifically. Can someone tell me what I am doing wrong here? Or what I need to do? My ID have all the permission that I need to write to the path. Thanks On 7 Okt., 22:41, Okon...@gmail.com wrote: > SQL1326N The file or directory "/pap/data/db01/" cannot be accessed. > My ID have all the permission that I need to write to the path. > > Thanks the instance-owner (not your ID, suppose they are different) must have the right to write to this directory On 8 Okt., 07:47, jammann...@gmail.com wrote: > On 7 Okt., 22:41, Okon...@gmail.com wrote: > > > SQL1326N The file or directory "/pap/data/db01/" cannot be accessed. > > My ID have all the permission that I need to write to the path. > > > Thanks > > the instance-owner (not your ID, sup...

Identifying Access Databases with tables linked from other Databases/Files
Hi, Have a number of Access Databases that I inherited and want to zip a few of them. My concern is that other active Microsoft Applications may be linking to the database or its tables. Is there a method of searching that will allow me to identify those MS Access files that are linked to. I am not really concerned with itemizing the which files link to which, but just that a link exists. Thanks in advance for any help. Bill It is easy to find the files which it links to but I don't know of any way to find the files which link to it. If you want to find the ones it links to look ...

How to access file last modified dates on each file in a directory
Greetings, I am attempting to view all files in a directory and if those files have not been modified within the last couple days I will remove them. In order to do this I need to look at the file date modied and check the date. I know how to look at each file name and I know how to remove the file. I just can't figure out how to get access to the date last modifed filed. Below is how I intend to access the file names in the directory. >>> import os,time,sys >>> cachedirectory="c:\\informatica\\cache\\" >>> v_filename_array=os.listdir(cachedirectory) ...

Convert SAP Oracle Database to IBM DB2 Database??
Hello, I would like to hear from anyone here who has converted their SAP Oracle database to IBM DB2 database? Did you realize greater disk saving via DB2 compression? Did you run the latest version of DB2 rather than allow SAP to keep your Oracle version back-leveled? Please, DB2 Bashers need not apply, looking for the business case anyone used to convert to DB2. Thank you. Charles On 6 Feb, 01:52, "Charles Davis" <cdavis10...@comcast.net> wrote: > Hello, > > I would like to hear from anyone here who has converted their SAP Oracle > database to IBM DB2 d...

how to copy files from ftp directory to web-accessible directory?
I need to copy files from an ftp directory to a web-accessible directory and then delete the files in the ftp directory. (I am doing it this way because web-based form upload can not exceed 2MB and I can't change that) Any ideas are much appreicated! Paul wrote: > I need to copy files from an ftp directory to a web-accessible directory and > then delete the files in the ftp directory. (I am doing it this way because > web-based form upload can not exceed 2MB and I can't change that) > > Any ideas are much appreicated! You can put a script like this on your webs...

File access vs Directory access control Apache2
I have got the directory access to work where it requires a user and password to access the files in that directory, but I have yet to figure out how to do this at the file level and not directory. Anyone here have any ideas? Here is the directory commands that work: <Directory "F:\inetpub\wwwroot\secure"> AuthType Basic AuthName "Email request for access to: me@domain.mine, or enter user name and password provided to you" AuthUserFile "d:/program files/apache group/apache2/bin/passwords" Require user user </Directory> Thanks Dan ...

Convert Access 2003 database file to Access 2010
How do you convert a Access 2002-2003 database file to a Access 2010 file format? According to Microsoft (http://office.microsoft.com/en-us/access-help/ convert-a-database-to-the-accdb-file-format-HA010341552.aspx? queryid=34ea405f95aa4cb8b8ffb2764afb4993&respos=0&CTT=1) it is possible. When I tried this on the file tab it only displays the print options only. How can I get the save, save & publish, and other commands to display? My 2002-2003 Access database file has 3 tables, 19 queries, 5 forms, and 16 reports. After I open the file up it gives the "Security Warning: Soam...

MS Access database with a file extension of .mde
Good day: Can you kindly assist me in opening a MS Access database with a file extension of .mde? I get an error message stating "This database is in an unrecognized format". Any help is greatfull. TIA This usually indicates an attempt to open an Access 2000 database in an earlier version. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no rights. "mary" <chloemelmom@yahoo.com> wrote in message news:a0a64947.0311151242.4df0c...

Connect to IBM DB2 database without installing the DB2 client.
Hi, To connect to the DB2 Driver, from a remote machine. Do we requier DB2 client. Can't we connect by just having IBM DB2 driver which is just a single file (db2cli.dll). I am using vb application from Windows platform to connect to DB2 on Linux machine. Regards, Santosh SB wrote: > Hi, > > To connect to the DB2 Driver, from a remote machine. Do we requier DB2 > client. > Can't we connect by just having IBM DB2 driver which is just a single > file (db2cli.dll). > I am using vb application from Windows platform to connect to DB2 on > Linux machine. > It's imposiblle. The IBM DB2 ODBC Driver is not only db2cli.dll. Try to install DB2 Run Time Client Lite merge modules with your VB application under client workstation. Direct connecting to DB2 databases supported JDBC Type 4 Driver only. P.S. Sorry for my bad english :( With best regards, Dmitry. FYI: On Windows DB2 comes with db2iprune tool. With this utility you can reduce size of installation binaries, for example you can reduce your DB2 runtime client to include only the interfaces you need. The db2iprune tool is located in the \db2\windows\utilities\db2iprune directory on DB2 product installation image. So, if you are planning install DB2 client with/within your application you can combine the tool with the response file and perform quick batch installation. -- Artur Wronski ...

Warning: Identity file ~/.ssh/id_rsa not accessible: No such file or directory
I install rwsync server on xp, and on fedora tried to ssh as follows; 1) on fedora ssh-keygen -P "" -f ~/.ssh/id_rsa chmod 700 ~/.ssh chmod 600 ~/.ssh/id_rsa ftp id_rsa.pub to xp 2) on xp append id_rsa.pub to /cwRsyncServer/var/SvcwRsync/.ssh/ authorized_keys2 3) and on fedora ssh -i ~/.ssh/id_rsa id@192.168.0.3 then I got this error message. "Warning: Identity file ~/.ssh/id_rsa not accessible: No such file or directory." My sshd_config on xp is as follows:: #Port 22 Protocol 2,1 #Protocol 2 #ListenAddress 0.0.0.0 #ListenAddress :: # HostKey for protocol versio...

Directory/File Access
Question about directories/files, ownerships and permissions..... Example Directory Structure: /dir1/dir2/dir3/dir4/dir5/dir6/dir7/dir8/file Vital Data: DIRECTORY PERMS OWNERSHIP /dir1 555 root:root ....dir2 775 root:root ....dir3 775 per1:grp1 ....dir4 775 per2:grp1 ....dir5 775 per2:grp2 ....dir6 775 per1:grp3 ....dir7 555 per1:grp3 ....dir8 775 per1:grp3 Person3 ("per3") has a primary group of "staff" and also belongs to secondary groups of "grp2" and "grp3" but is NOT a member of "grp1". Person3 ("per3") is able to &...

File/directory access
Hello all, I'm running perforce on an NetBSD system, and I was wondering about a few things.. I have created a 'p4admin' group, and a 'perforce' user. The directory where perforce's files reside belongs to group 'p4admin' and has the owner 'perforce'. The owner has full rwx right, but the group only has r-- rights. This will allow me to add my user to the 'p4admin' group, and use it to backup the perforce files. This works great apart from one little detail.. The perforce daemon files are located in: /var/perforce/s...

Access Security
Hello, What is the best way (if it can be done) to Access a Microsoft Access 2002 database using VB? I can connect to one no problem until I set up security and have a workgroup file. I can't find any kind of connection that lets you change which workgroup information to use. At the moment I get kicked out because I am an unknown user (which is true in the default system.mdw file...). Anyone got any ideas? TIA, Neil. ...

Open Access Database Form from within Access database
I have included the following code to open an Access database form from within an exsisting Access database. But when I run the code, it appears that it opens the database because in windows explorer I can see the database has the .ldb file extension. So it appears that it's open, but I can't see the database or the form that I've tried to open. What am I doing wrong. The following is the code: 'This is in the declaration part of the module Dim appAccess As Access.Application ' Initialize string to database path. Const strConPathToSamples = "C:\Documents a...

java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSource
Hi, I want to get connection to a DB2 database using the driver COM.ibm.db2.jdbc.DB2XADataSource. I have also included 'db2java.zip' in the classpath. However I am getting the exception java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Conn.main(Conn.java:44) The code that I am using (with try/catch removed) is as follows: String url = "jdbc:db2:sample"; String driver = "COM.ibm.db2.jdbc.DB2XADataSource"; String dbuser = "db2u...

oct 24 DB2 for LUW Tech Talk: What's Hot from IOD for PureData Systems, IBM Mobile Database and DB2 for LUW
Now we can tell you more! IBM announced PureData Systems on October 9th --= a series of expert integrated solutions for your transactional and analyti= c workloads.=20 In the next DB2 Tech Talk, we'll come to you from Las Vegas with hot news f= rom the conference from a DB2 for LUW, PureData Systems perspective! We'll= also cover a new free software download called IBM Mobile Database, which = helps you enable your DB2 data apps for Android mobile users. And then we = will bring you the best of the presentations from the conference, including= an IBM Champion and other interesting perspectives on DB2. =20 Register: bit.ly/tt2012oct ...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

Web resources about - SQL1326N The file or directory cannot be accessed - comp.databases.ibm-db2

Wikipedia:Quick directory - Wikipedia, the free encyclopedia
This page is a handy directory to various locations of interest in Wikipedia. Only dynamic pages should be listed here, no policy pages etc. ...

Telephone directory - Wikipedia, the free encyclopedia
"Phone book" and "White pages" redirect here. For a contact list, see Contact list . For other uses, see White pages (disambiguation) . Subscriber ...

Business Directory Listings: Eight Smart Tips for You to Get Started
If you are considering a business directory listing for your small business, congratulations – you are on the right track. Local SEO, local customers, ...

Atlas Partner Directory Launched
... just for Facebook and Instagram –advertising platform Atlas has one, as well. On that note, Atlas Tuesday introduced the Atlas Partner Directory ...

Slack announces App Directory store
... create more apps for the store, and a new framework called Botkit which should simplify the process of creating apps. The Slack App Directory, ...

Amazon brings Microsoft users into AWS with Active Directory service
Amazon has launched an AWS Directory Service for Active Directory , a fully managed implementation of Microsoft's authentication and user management ...

Hackers leak DHS staff directory, claim DOJ is next
On Sunday, an account on Twitter posted a Department of Homeland Security staff directory with 9,355 names. Shortly after the DHS data was posted, ...

'Twitch Plays' directory makes it easy to find new games
The huge success that is TwitchPlaysPokemon gave rise to a number of other Twitch Plays games, and the video platform wants to make sure you ...

Slack's New Directory And Venture Fund Aim To Make The Service Even More Indispensable
The workgroup wunderkind is helping users find useful tools within the service—and giving startups money to create new ones. Two key facts about ...

LDAP Directory Metadata ETL
WhereHows - Data Discovery and Lineage for Big Data Ecosystem

Resources last updated: 3/7/2016 3:05:25 AM