DB2 Server Silent Installation (DB2 )

DB2 Server Silent Installation


CHANGE SYSTEM NAME!!


First change localhost name too test.domain.net

open terminal >> hostname test.domain.net

to verify, open terminal >> vim /etc/hostname

test.domain.net

AND

vim /etc/hosts/

192.168.1.1   test.domain.net



Create WCSADMIN user

groupadd wcsadmin

useradd -g wcsadmin -G nobody -d /home/wcsadmin wcsadmin

passwd wcsadmin



subscription-manager register --username admin --password pwd --auto-attach



yum repolist all

yum-config-manager --enable rhel-7-server-optional-rpms





#subscription-manager repos --enable rhel-server-rhscl-7-eus-rpms

#subscription-manager repos --enable rhel-server-rhscl-7-eus-source-rpms

#subscription-manager repos --enable rhel-server-rhscl-7-eus-debug-rpms

#yum-config-manager --enable redhat.repo

#yum update

#https://access.redhat.com/management/consumers?type=system





yum install libXau libXau.i686 libxcb libxcb.i686 libX11 libX11.i686 libXext libXext.i686 libXp libXp.i686 libICE libICE.i686 libuuid libuuid.i686 libSM libSM.i686 libXt libXt.i686 libXmu libXmu.i686 libXi libXi.i686 libXtst libXtst.i686 libXrender libXrender.i686 freetype freetype.i686 expat expat.i686 fontconfig fontconfig.i686 ksh ksh.i686 libXft libXft.i686 compat-libstdc++-33 compat-libstdc++-33.i686 compat-libstdc++-296.i686 rpm-build rpm-build.i686 compat-db compat-db.i686 elfutils elfutils.i686 elfutils-libs elfutils-libs.i686 cracklib cracklib.i686 db4 db4.i686 libselinux libselinux.i686 pam pam.i686 xorg-x11-apps xorg-x11-xauth xterm libstdc++.so.5





groupadd -g 70000 dasadm1

groupadd -g 70001 db2iadm1

groupadd -g 70002 db2fadm1



useradd -u 70003 -g dasadm1 -m -d /home/dasusr1 dasusr1

useradd -u 70004 -g db2iadm1 -m -d /home/db2inst1 db2inst1

useradd -u 70005 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1



passwd dasusr1



passwd db2inst1



passwd db2fenc1



open terminal >> location at DB2_ESE_97.... >> run ./db2prereqcheck

                            ./db2_install

                            /opt/IBM/db2/

                             ESE



then run from terminal >>>



[root@localhost ese]# cd /opt/IBM/db2/bin/

[root@localhost bin]# ./db2val

DBI1379I  The db2val command is running. This can take several minutes.

DBI1335I  Installation file validation for the DB2 copy installed at

      /opt/IBM/db2 was successful.

DBI1343I  The db2val command completed successfully. For details, see

      the log file /tmp/db2val-06_08_04:00:36.log.









[root@localhost instance]# vim /etc/services



db2c_db2inst1   50000/tcp   # Connection port for DB2 instance db2inst1

db2idb2inst1    50001/tcp   # Interrupt  port for DB2 instance db2inst1



creating INSTANCE >>>>>



[root@localhost bin]# cd ../instance/

[root@localhost instance]# ./db2icrt -u db2fenc1 db2inst1

DBI1070I  Program db2icrt completed successfully.



[root@localhost instance]# su db2inst1

[db2inst1@localhost instance]$ cd /

[db2inst1@localhost /]$ db2 get dbm cfg | grep -i SVCE



 TCP/IP Service name                          (SVCENAME) =

 SSL service name                         (SSL_SVCENAME) =



[db2inst1@localhost /]$ db2 update dbm cfg using SVCENAME db2c_db2inst1



DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed

successfully.



[db2inst1@localhost /]$ db2set DB2COMM=tcpip

[db2inst1@localhost /]$ db2set -all

[db2inst1@localhost /]$ db2stop



06/08/2015 04:06:35     0   0   SQL1032N  No start database manager command was issued.

SQL1032N  No start database manager command was issued.  SQLSTATE=57019



[db2inst1@localhost /]$ db2start



06/08/2015 04:06:40     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.



[db2inst1@localhost /]$ exit



exit



[root@localhost instance]# netstat -ano | grep -i 50000



tcp        0      0 :::50000                    :::*                        LISTEN      off (0.00/0/0)

Comments

Post a Comment

Popular posts from this blog

Docker build

 The `docker build` command is used to build Docker images from a `Dockerfile`. This command automates the process of creating a Docker image by executing the instructions defined in the Dockerfile. Let’s break down the internal workings of `docker build` step by step: --- ### 1. **What is `docker build`?** The `docker build` command creates a Docker image from a **Dockerfile**, which is a text file that contains a series of instructions on how to assemble the image. The process takes the base image, applies modifications step-by-step (such as adding files, installing packages, or setting environment variables), and creates a final image that can be used to run containers. ### 2. **Command Syntax** ```bash docker build [OPTIONS] PATH | URL | - ``` - **PATH**: This is the path to the directory containing the `Dockerfile`. It can also be a URL or `-` (for reading from stdin). - **OPTIONS**: There are several options available, like `-t` for tagging, `--file` for specifying a differen...
Read more

Create Oracle users with correct permissions in wcs commerce

      Create Oracle users with correct permissions ·        Login to Oracle SQL developer as a master user ·        Run the following scripts to create a database user and DBA user. Make sure you change username according to the environment. If createInstance fails and you need to drop and recreate users, you don’t need to run the “create tablespace” command again.   # Install/Configure Oracle database # Configure the oracle database # Change the user and passwords according to the environment create tablespace WCTBLSPC datafile size 100M autoextend on next 2M maxsize unlimited; CREATE USER jbdev2user IDENTIFIED BY jbdev2user DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; CREATE USER jbdev2dba IDENTIFIED BY jbdev2dba DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; grant create procedure, create sequence, create session, create synonym, create table,cre...
Read more

Create wcs instance

      Create WCS instance ·        Log in to WCS server as wcsadmin. ·        Open the following file /opt/IBM/WebSphere/CommmerceServer80/schema/oracle/wcs.data.sql ·        Replace INSERT INTO dmelementnvp (dmelement_id, name, value) select i,n,v from (SELECT dmelement_id, 'socialActivityType', '*' FROM dmelement WHERE dmeletemplate_id IN (160, 215) UNION ALL SELECT dmelement_id, 'comparison', 'any' FROM dmelement WHERE dmeletemplate_id IN (160, 215)) s (i,n,v) where not exists (select 1 from dmelementnvp where dmelement_id = i and name = n and value = v);   With: INSERT INTO dmelementnvp (dmelement_id, name, value) select i,n,v from (SELECT dmelement_id i, 'socialActivityType' n, '*' v FROM dmelement WHERE dmeletemplate_id IN (160, 215)                    UNION...
Read more