Vitor Rodrigues

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.