DBI1082E error message when creating new DB2 instance
I recently spent a few hours at work trying to understand why I was receiving the DB2 error message with code DBI1082E.
After
I installed DB2 on an AIX machine, I needed to create an instance. When
running "db2icrt vrodrig", I got this error. The error message was:
DBI1082E
The file or directory /home/vrodrig/sqllib already exists.
At
the first time I hit the error, the solution was obvious: just go and
delete the folder, that existed because of a previous DB2 installation.
However, the error persisted. And even more funny, there was a new
/home/vrodrig/sqllib folder being created every time I ran "db2icrt
vrodrig". This was strange. I deleted the folder before running
db2icrt, but when running the command, it would always fail, and there
would be a new
/home/vrodrig/sqllib folder there. So, the symptom was something like:
sqllib folder is only created when db2icrt is ran, but db2icrt fails
because sqllib already exists.
After searching on google, only one link revealed itself of some interest and usefullness. It was this post at developerWorks.
Although
the post didn’t had the solution for my problem, it had some ideas that
led me to fix the problem. And the problem was that because I was
logging in to the system with the user id vrodrig, there was already a
db2profile file from the previous installation being sourced at login
time. This would cause the actual db2 installation to write some stuff
to
/home/vrodrig/sqllib even before creating the instance. To fix the
problem, just login to the system with a different user, then "su" to
root, delete the folder /home/vrodrig/sqllib, run "db2icrt vrodrig" and voila, you are done! (Note: replace vrodrig and /home/vrodrig/sqllib with your user id and sqllib folder).
Just
as a side note, either this is not a very common error, or there isn’t
that many information about DB2 out there. I found just one link
talking about the same problem.
Popularity: 22% [?]
Related Entries:
January 12th, 2007 at 9:53 am
Thanks, only hit i found. You saved my weekend
January 14th, 2007 at 9:50 pm
You are welcome!
It was exactly because there was nothing on the web that I decided to post this. I spent a few hours with it and I just hope this post helps other people facing the problem.
March 8th, 2007 at 4:44 am
I also had the same problem. And after I read your post I really got a good idea about that problem and fixed it. Thank you very much. Keep on good work.
May 24th, 2007 at 12:53 pm
Thanks a lot this information saves my day, I read your reply that really helps me in understanding Keep up the good work
September 6th, 2008 at 1:46 pm
ghjsfl gbnslkrp fzvxpbm eijltdhb oijlzta qgcyik mcyzn
September 16th, 2009 at 8:41 am
thx, that was the hint i needed
December 23rd, 2009 at 7:55 pm
Thank you, thank you, thank you!