By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,352 Members | 1,593 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,352 IT Pros & Developers. It's quick & easy.

Help with cataloging databases.

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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