Hi all,
I wonder if anybody can help with a problem I have accessing (caaloging) databases on my network (drive V)
I have installed DB2 V8 on Windows XP: -
=============== =============== =============== ============
About DB2 Administration Tools Environment
=============== =============== =============== ============
DB2 administration tools level:
Product identifier SQL08020
Level identifier 03010106
Level DB2 v8.1.7.445
Build level s040812
PTF WR21342
=============== =============== =============== ============
Java development kit (JDK):
Level IBM Corporation 1.4.1
=============== =============== =============== ============
I have no databases on my system, they are on my V drive. If I use the CLP, and do a
LIST DB DIRECTORY ON V
I get the following: -
db2 => list database directory on v:
Local Database Directory on v:
Number of entries in the directory = 4
Database 1 entry:
Database alias = TEMP
Database name = TEMP
Database directory = SQL00004
Database release level = a.00
Comment =
Directory entry type = Home
Catalog database partition number = 0
Database partition number = 0
Database 2 entry:
Database alias = VANTIVE
Database name = VANTIVE
Database directory = SQL00002
Database release level = a.00
Comment = The Vantive database
Directory entry type = Home
Catalog database partition number = 0
Database partition number = 0
Database 3 entry:
Database alias = WEBLIC
Database name = WEBLIC
Database directory = SQL00003
Database release level = a.00
Comment = The WEBLIC database
Directory entry type = Home
Catalog database partition number = 0
Database partition number = 0
Database 4 entry:
Database alias = TRACKER
Database name = TRACKER
Database directory = SQL00001
Database release level = a.00
Comment = The Tracker database
Directory entry type = Home
Catalog database partition number = 0
Database partition number = 0
If I try
catalog db TRACKER as TRACKER on V
I get the following: -
SQL0005N The message file name is not valid.
If I try to use the DB2 Control Centre (tools, configuration assistant, select advanced view, click on the databases tab, click selected, add databases)
When I select the V drive, I get the message: -
SQL1039C An I/O error occurred while accessing the database directory. SQLSTATE=58031
Explanation:
Either the system database directory or the local database
directory cannot be accessed. 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.
The command cannot be processed.
User Response:
Possible solutions include:
o If the error occurred on a diskette system, verify that the
correct diskette is in the drive and ready to use. Verify
that it is not write-protected.
o If the database directory is damaged, restore the databases
that were cataloged there from backup versions and catalog
them.
If installing the sample database, drop it and install the
sample database again.
sqlcode : -1039
sqlstate : 58031
Can anybody help please?
Thanks in advance.
0 1527 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Matthew K Jensen |
last post by:
I've just come up with an idea to make a small-time record of web
pages linking to other web pages. I don't want to download every page
on the internet (I'll leave google to do that). I just want to know if
anyone has any suggestions on how to acquire just the links from a web
page using python. This is for a cataloging purpose. Is there some
library or script out there that I haven't heard of?
|
by: Sandie Towers |
last post by:
We use a number of similar databases and frequently create a new
database using a backup restore of another similar database. We try to
keep changes between databases in _Additional tables - like Account
Additional, Sale_Additional so most tables stay the same. The latest
restored database (I'll call it DBaseA) is behaving differently in VB6
code and I need help trying to make it work.
I have been using use an ADODB.Command to execute...
|
by: Stephen |
last post by:
I have to write a .Net application which can compare SQL Databases including
things like: -
DB structure, PK's, FK's,
indexes and types of indexes i.e. should be able to detect if the same index
has cascade set on one db and not on another, or unique on one and not the
other,
Constraints, Triggers, Stored procs, Users, Roles.
I downloaded the SQL Data Compare 3.0 application 14 day trial and it seemed
really good however does a bit more...
|
by: Henry Reardon |
last post by:
I just installed DB2 Personal Developer's Edition V8.2 (FP7) over my old
DB2 V7.2 instance but I'm having some problems. Can anyone help?
The first problem is that my migration didn't go too well. I got this
during the setup wizard:
The migration of the instance "DB2" has failed. The return value is "-2".
When I looked at the databases in the Control Center, they all seemed to be
there, including the ones created during the install...
|
by: kenfar |
last post by:
I've got a set of redundant marts that I'm trying to catalog on the
client side to allow us to do two things:
1. manually recatalog to point at either of the two fast marts
2. automatically failover to a third slow mart
The data marts are on db2 8.2.1, the client on db2 8.2.?
But I'm hitting a few roadblocks here - all suggestions are
appreciated. So, I've given our portal team (runs actuate) a pair of
scripts to switch the catalog...
| |
by: robert d via AccessMonster.com |
last post by:
I'm looking at converting DAO to ADO in my app. All of my DAO connections
are of the following structure:
Dim wsName As DAO.Workspace
Dim dbName As DAO.Database
Dim rsName As DAO.Recordset
Set wsName = DBEngine.Workspaces(0)
Set dbName = wsName.OpenDatabase(CurrentProject.FullName)
Set rsName = dbName.OpenRecordset("SQL Statement")
|
by: cryon.b |
last post by:
Hi To All,
I took up the IBM sample testfor Exam 700 today and I have the test
tomorrow,I have some questions for which Iam not sure about the right
answer,can anyone please guide me as to what is the right answer for
these questions are.This would mean a lot to me.
1..A developer is building an embedded SQL application on AIX that will
access DB2 UDB for OS/390 or OS/400 servers. Which of the following
products is required to be...
|
by: rfranzl |
last post by:
Hello,
I need some help, I have about 200 databases that are copies of an original database that has a similiar table in all of the databases, called "tblCodebook".
What I am trying to do is to create a macro that will go into each of the 200 databases, run an identical "unmatched query" to find any records that might be in one of the copies of the "tblCodebook". There is a shared primary key in the "tblCodebook" which is a StoryID and...
|
by: bomahony |
last post by:
Im runnign various versions of DB2 on various UNIX platforms
(Solaris / AIX).
DB2 is generally eating up about 30% of memory on these systems (4Gb
of RAM, which equates to over a gig). i want to limit DB2s memory
usage to a couple of hundred meg in total for the entire application,
but cannot seem to find out how to do this.
When i check the instance memory usage with db2mtrk, it says its only
using a few Megs. I cannot find out how...
|
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,...
|
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...
| |
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...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |