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.
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.