473,785 Members | 2,919 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem connecting to database directory after installing fixpack 7a

I have a DB2 v8.1 FP4 instances that have been running fine on an AIX server
for quite some time. 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 FP4a instances.

SQL10004C An I/O error occurred while accessing the database directory.
SQLSTATE=58031

Can anyone give me a clue about what's going on?
Nov 12 '05 #1
5 5408
c9******@dcc.on line.pt (Ricardo Silva) wrote in message news:<c7******* *************** ****@posting.go ogle.com>...
I have a DB2 v8.1 FP4 instances that have been running fine on an AIX server
for quite some time. 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 FP4a instances.

SQL10004C An I/O error occurred while accessing the database directory.
SQLSTATE=58031

Can anyone give me a clue about what's going on?


The user you logged in has permission problem to access db2 data.
Nov 12 '05 #2
sh*******@gmail .com (richard) wrote in message news:<ca******* *************** ****@posting.go ogle.com>...
c9******@dcc.on line.pt (Ricardo Silva) wrote in message news:<c7******* *************** ****@posting.go ogle.com>...
I have a DB2 v8.1 FP4 instances that have been running fine on an AIX server
for quite some time. 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 FP4a instances.

SQL10004C An I/O error occurred while accessing the database directory.
SQLSTATE=58031

Can anyone give me a clue about what's going on?


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.
If I run the command :
db2 list db directory on <database filsesystem>
I can see the information of my databse directory.
thank's
Nov 12 '05 #3
> The user that I use is the instance administrator user, so that user
has the necessarie permissions.
If I run the command :
db2 list db directory on <database filsesystem>
I can see the information of my databse directory.
thank's

I have the exact same problem with FP7a and FP6a instances on Linux 32
bit. I can see the FP7a instance, but get the I/O error for the FP6a
instance.
Nov 12 '05 #4
Did anyone found a way to fix this problem?

Mark wrote:
The user that I use is the instance administrator user, so that user has the necessarie permissions.
If I run the command :
db2 list db directory on <database filsesystem>
I can see the information of my databse directory.
thank's

I have the exact same problem with FP7a and FP6a instances on Linux

32 bit. I can see the FP7a instance, but get the I/O error for the FP6a
instance.


Nov 12 '05 #5
This is what i did to resolve the issue.

http://db2dba.blogspot.com/2005/02/s...red-while.html

Nov 12 '05 #6

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

Similar topics

3
15640
by: Jagdip Singh | last post by:
Hi, We are facing problem accessing to DB2. Seems like database manager is down I tried starting it using db2start but it was neither showing any messages nor returning to command prompt after finishing start. I do not know actually if it was trying to start database or hanging somewhere
2
7843
by: Pascal Deparis | last post by:
Hi, I've got a problem with the DB2 Command Line Processor, in V8, FP1. The databases have been created on an AIX server (version 4.3.3). Have a look at this: >db2 ? list DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1024N A database connection does not exist. SQLSTATE=08003
4
2066
by: Mark A | last post by:
Trying to upgrade alternate FP9 to alternate FP9a on Red Hat Linux. After running the following command: ../installAltFixPak -y it says it was successful, but no new directory is created in /opt/IBM/db2 Assuming that maybe fixpack 9a updates the existing /opt/IBM/db2/V8.FP9 directory, I ran db2iupdt on the instance (using root), but db2level still shows the signature for fixpack 9 (not 9a). "DB2 v8.1.0.88", "s050422"
6
3249
by: Mark A | last post by:
On the forum at ibm.software.db2.udb it was mentioned that one should run db2updv8 after installing fixpack 9 (or 9a). But there is no mention of db2updv8 in FP9a installation readme file. Anyone know what is going on?
1
1900
by: Chris Love | last post by:
I have already asked this, but no one seems to know the answer. Here is the timeline. I wanted to use the membership/roles functionality in a site. I got all sorts of errors trying to get this setup on the site through the admin interface. So I yanked it out of the application since it did not work. Now everytime I load the site after changing the application I get this error message. If I simply refresh the page, everything works...
2
4126
by: Patrick F | last post by:
Hi, i have SQL Server 2005 and a database set that is called, myCompany the problem is that i cant connect from my page to it, here is from the web.config: ( i have got this connectionstring from my sqldataobject on my page) <add name="ConStr" connectionString="Data Source=localhost;Initial Catalog=myCompany;Integrated Security=True" providerName="System.Data.SqlClient" /> the strange part is that its trying to connect to a SQL express...
2
1888
by: itfetish | last post by:
I've just upgraded our WIndows 2003 (with SBS server) web server to .Net framework 2.0 (it had 1.1 before) As I have been working on a web parts page on my laptop, hosting it there, working perfectly. I want to transfer it now, so I upgraded it. Created a new application pool for .net2.0 stuff, then used Visual Studio 2005 from my laptop to connect to Http://Bw-online/ProjectPoint and make a new website. Bw-online is our intranet at...
1
2480
by: sureshbup | last post by:
Hi to all, I am trying to install CPAN modules using the command perl -MCPAN -e 'install qw (Text::CSV_XS)' but i get the problem like this even i changed the working proxies but none is working. i have tried different mirrors also. I tried different modules also. ===========================================================
1
2531
by: john20 | last post by:
Hi All, I am trying to use webpart in my page for that i am putting webpartmanager and webpartzone. but as soon as i am putting webpartmanger in the page it is giving me below error, let me tell you i have installed Sql server 2005 on my machine. after installing the Sql server 2005 it has started giving me this error. if i remove webpartmanage from the page then it works fine. and i am not making any database connection then also it...
0
10319
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10147
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...
1
10087
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9947
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...
0
8971
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7496
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
6737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5380
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...
0
5511
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.