Cannot run db2sampl, Errored on 'DB2INSTANCE' not set or set incorrectly.
Posted on 2003-03-24
I just installed DB2 Personal Edition Version 8.1 on a Linux machine. I was following the instruction and got to the step on 'Verifying the installation using the command line processor (CLP)', i.e., enter the db2sampl command to create the SAMPLE database. But I got the following error:
'SQL10007N Message "-1390" could not be retrieved'.
I checked the meaning of SQL10007N message, and it says:
'The environment variable “DB2INSTANCE” is either not set, or is set to an invalid instance. Correct it and try again.'
I did the following to setup DB2INSTANCE:
set DB2INSTANCE=TEST db2inst1
(I had created db2inst1 after having installed DB2 PE). The set command went through without error. But running 'db2sampl' again got me the same error. Then I tried
set DB2INSTANCE db2inst1
and ran 'db2sampl' again but got the same error still.
Note: I have setup the following after having installed DB2:
groupadd id=999 dbiadm1
groupadd id=998 db2fadm1
groupadd id=997 db2asgrp
useradd -u 1004 -g db2iadm1 -G db2iadm1 -m -d /home/db2inst1 db2inst1 -p mypasswrd
useradd -u 1003 -g db2fadm1 -G dbfadm1 -m -d /home/db2fenc1 db2fenc1 -p mypasswrd
useradd -u 1002 -g db2asgrp -G db2asgrp -m -d /home/db2as db2as -p mypasswrd
Do I need to set up anything else before running db2sampl? Or should I not set up the above before I run db2sampl?