My guess is that your environment is not set up.
I use this in my .profile (provided by DB2 install, assuming your instance owner had a .profile when the instance is created)
- The following three lines have been added by UDB DB2.
if
-f <instance owner home dir>/sqllib/db2profile ; then
. <instance owner home dir>/sqllib/db2profile
fi
If for some reason, you don't want it in the .profile you can source the db2profile which will set it up.
I think the "1390" message is:
SQL1390C The environment variable DB2INSTANCE is not defined or is
invalid.
Explanation:
The environment variable DB2INSTANCE is not defined or is not set to a
valid instance owner.
User response:
Set the DB2INSTANCE environment variable to the name of the instance to
use. If you do not know the name of the instance to use or how to set
the DB2INSTANCE environment variable to the instance name, refer to the
Administration Guide.
Federated system users: refer to the Federated Systems Guide for
DB2INSTANCE information.
Ensure your PATH environment variable contains the sqllib/adm path in
the home directory of the instance you want to use (for example,
/u/instance/sqllib/adm, where /u/instance is the home directory of the
instance owner on a UNIX system).