It failed because me… bill don’t have write permissions on /home/bill/sqllib/
I even manually created the directory… same error!
Here are those permissions
I always wanted to play with IBMs DB2 to see how similar or dissimilar it is to the SQLs I know. My IBM mainframe database experience is with ADABAS. In hindsight I wish my company chose DB2 because it’s more of an industry standard. I assume ADABAS is a very nice database. I became the DBA, but I honestly can’t answer that question. The company chose it, for whatever reason… and I learned it. It had this funky language and GUI interface called NATURAL. I wasn’t good with it, then again I wasn’t on the programming side at that point. In fairness there were a couple programmers that created some nice customer service GUI applications with it.
WTH? Why?
Of course I could use sudo but I wanted to install locally. I probably will use sudo but I ‘d like this to make sense.
In running ./db2setup
bill@bill-MS-7B79:~/Downloads/Computers/Database/IBM/server_dec$ whoami
bill
bill@bill-MS-7B79:~/Downloads/Computers/Database/IBM/server_dec$ ./db2setup
DBI1288E The execution of the program failed. This
program failed because you do not have write permission on the
directory or file /home/bill/sqllib/.
Explanation:
Reasons for this error include:
* The given directory or file is on a local file system of the current
machine, but the user id running the program does not have write
permission for that directory or file.
* The given directory or file is on an NFS mounted file system mounted
on the current machine, but the current user id does not have write
permission for that directory or file.
* The current user id does not have write permission for the given
directory or file located at the target partition. This can happen
when the current machine's operating system is IBM AIX Version 6.1 or
later and a Workload Partition root user id is attempting to write to
a Global Partition.
* The current user id does not have write permission for the directory
or file located at the target zone. This can happen when the current
machine's operating system is Sun Solaris 10 or later and a local
zone root user id is attempting to write to a global zone.
* The current machine is running the Sun Solaris Operating System in a
local zone which does not have the write permission for the directory
or file located on the global zone.
User response:
There are several ways to respond to this message:
* Run the program with a user id that has write permission for the
given directory or file.
* Modify the permissions of the directory or file to allow the user id
to write to that directory or file, and rerun the program.
* Modify the authority of the user id to allow that user id to write to
the given directory or file, and rerun the program.
Create the cli way… clearly I have permission
bill@bill-MS-7B79:~$ ls -dla sql*
ls: cannot access 'sql*': No such file or directory
bill@bill-MS-7B79:~$ pwd
/home/bill
bill@bill-MS-7B79:~$ mkdir sqllib
bill@bill-MS-7B79:~$ ls -dla sql*
drwxrwxr-x 2 bill bill 4096 Dec 28 15:04 sqllib
bill@bill-MS-7B79:~$
Required steps:
There were some errors detected during DB2 installation. To collect the information files from the system, run the "db2support -install" command with the proper options before reporting the problem to IBM service. For information regarding the usage of the db2support tool, check the DB2 Information Center.
In order to start using DB2 you need to logon using a valid user ID such as the DB2 instance owner's ID "db2inst1".
You can connect to the DB2 instance "db2inst1" using the port number "25000". Record it for future reference.
Optional steps:
To validate your installation files, instance, and database functionality, run the Validation Tool, /opt/ibm/db2/V12.1/bin/db2val. For more information, see "db2val" in the DB2 Information Center.
Open First Steps by running "db2fs" using a valid user ID such as the DB2 instance owner's ID. You will need to have DISPLAY set and a supported web browser in the path of this user ID.
You should ensure that you have the correct license entitlements for DB2 products and features installed on this machine. Each DB2 product or feature comes with a license certificate file (also referred to as a license key) that is distributed on an Activation CD, which also includes instructions for applying the license file. If you purchased a base DB2 product, as well as, separately priced features, you might need to install more than one license certificate. The Activation CD for your product or feature can be downloaded from Passport Advantage if it is not part of the physical media pack you received from IBM. For more information about licensing, search the Information Center (http://publib.boulder.ibm.com/infocenter/db2luw/v10r5/index.jsp) using terms such as "license compliance", "licensing" or "db2licm".
To use your DB2 database product, you must have a valid license. For information about obtaining and applying DB2 license files, see http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.qb.server.doc/doc/c0061199.html.
Refer to "What's New" http://publib.boulder.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.wn.doc/doc/c0052035.html in the DB2 Information Center to learn about the new functions for DB2 12.1.0.0.
Verify that you have access to the DB2 Information Center based on the choices you made during this installation. If you performed a typical or a compact installation, verify that you can access the IBM Web site using the internet. If you performed a custom installation, verify that you can access the DB2 Information Center location specified during the installation.
Review the response file created at /root/db2server.rsp. Additional information about response file installation is available in the DB2 documentation under "Installing DB2 using a response file".