on 04-24-2014 8:07 AM
Hello everybody,
I am really new to DB2 and actually I am facing a problem to it concerning the connection to the database.
When I try to connect to the SAP DB system I receive the following error:
SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031
But, nothing has been changed in the file system.
db2 list db directory
Local database directory = L:\db2\db2wd1
db2ilist
DB2WD1
Unfortunately since I have noticed this problem no current backup of the DB system exists.
We are using WIN2K8R2 with DB2 Version 9.7 FP5.
This problem seems to appear from nowhere.
Please assist.
Best regards
Henning
Hi,
as far as I can see the following patches have been installed:
- KB2936068
- KB2928562
- KB2922229
- KB2908783
- KB2800095
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please close thread if resolved...
Cheers
Pranjal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Today we have installed new Microsoft patches for our servers.
Don't know why but the connection problem has been disappeared.
Thanks to all for your Support.
Best regards
Henning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I have just run the command db2 catalog database WD1 on L:/db2/db2wd1
I haven't received any message back from db2cmd yet.
What happens now? What causes this command?
Regards
Henning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Henning,
CATALOG DATABASE automatically creates a system database directory if one does not exist. The system database directory is stored on the path that contains the database manager instance that is being used, and is maintained outside of the database.
It may take some time. Monitor logs in db2diag.log
Regards,
Deepak Kori
Hi.
Please check the user also from which you trying to connect try with db2sid user also ifyou want first your database in Console or control central its easy ur issue wil get resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello everybody,
the following system variables are set:
DB2DBDFT WD1
DB2INSTANCE db2wd1
DBMS_TYPE db6
DBS_DB6_SCHEMA sapwd1
DBS_DB6_USER sapwd1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Henning,
Please check whether you have all the folders intact under L:\db2\db2wd1
Just to ensure nothing has got deleted
Refer similar solution in thread http://scn.sap.com/thread/3469409
Hope this helps.
Regards,
Deepak Kori
Hi Henning,
Have you set the DB2 instance environment variable. can you paste the output of
db2 connect to DB2WD1
regards
kartik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Henning,
It looks to be problem with environment variables.
Could you follow the solution in the link below .
http://www-01.ibm.com/support/docview.wss?uid=swg21587816
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.