If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Cant reate a Database.. URGENT

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-23-04, 08:40
anwyuta anwyuta is offline
Registered User
 
Join Date: Sep 2004
Posts: 24
Unhappy Cant reate a Database.. URGENT

hi,

i had a problem with a stackoverflow (maybe unlucky FixPack installed) and uninstalled the hole DB2.

I installed the DB2 with another FixPack and tryed to create a
Database but i got the Error:

E/A-Fehler während des Zugriffs auf das Datenbankverzeichnis.
SQLSTATE=58031

SQL1039C

Can anyone help please?


Thanks in advance.

Anwy
Reply With Quote
  #2 (permalink)  
Old 11-23-04, 08:44
J Petruk J Petruk is offline
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Check your db2diag.log, it will probably have the path that's failing.

Do a "db2 list database directory" - what's the output?
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #3 (permalink)  
Old 11-24-04, 03:45
anwyuta anwyuta is offline
Registered User
 
Join Date: Sep 2004
Posts: 24
thanks for your answer.

it was a problem with the installation.

i create a new instance as a repository and the application works.

unfortunately all the (user) data is in the other instance where
i get the STACKOVERFLOW...

is it possible to ovoid this error (overflow) ?
Reply With Quote
  #4 (permalink)  
Old 11-24-04, 08:26
J Petruk J Petruk is offline
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Quote:
Originally Posted by anwyuta
thanks for your answer.

it was a problem with the installation.

i create a new instance as a repository and the application works.

unfortunately all the (user) data is in the other instance where
i get the STACKOVERFLOW...

is it possible to ovoid this error (overflow) ?
When you create a new instance the database directory is reset.

Can you post the full error you're getting? Is it a db2 error?? I would - as root - run "db2iupdt" on the instance to start, just to make sure everything is clean.
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On