473,387 Members | 1,485 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Help with cataloging databases.

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.
Mar 25 '08 #1
0 1503

Sign in to post your reply or Sign up for a free account.

Similar topics

2
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...
1
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...
3
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...
0
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...
1
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...
32
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 ...
2
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...
1
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...
12
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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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...

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.