Senin, 21 Januari 2019

Some useful DB2 command

  Tidak ada komentar
Some useful DB2 command

CommandDescription
db2cmdOpen DB2 Command line Tool
db2ccOpen DB2 Control Centre
db2startStart Database Normaly
db2stopStop Database Normaly
db2stop forceStop Database forcely
db2 force application allClose all applications that uses DB2 Database.
db2levelDisplay DB2 version and fix pack level
db6levelDisplay DB2 Client Version
db2 terminateClose the database connection
db2_kill -allKill a hanged instance
db2licm -lView license information
db2 connect to <db2sid>Establish connection to an instance
db2 list tablespaces show detailDisplays table space information
db2 get dbm cfgDisplay configuration parameter of database manager.
db2 get db cfg for <db2 sid>Display configuration parameter of an instance
db2 update dbm cfg using <parameter_name> <new value>Change value of a database manager configuration parameter.
db2 update db cfg for <db2 sid> using <parameter_name> <new value>Change value of a instance configuration parameter.
db2 drop database <target db2sid>Delete and instance
db2 activate db <dbsid>Activate Database
db2 deactivate <dbsid>Deactivate an active database
db2 rollforward db <SID> to end of logsApply all pending logs
db2 rollforward db <db2sid> query statusDisplay rollforward status
db2 backup database <sid> to “disk:\location”Take an offline backup to specified location
db2 list utilities show detailDisplay Database backup status
db2 restore db <sid> from “disk:\path” replace history fileRestore database from a backup image
db2topMonitor DB2 like active session, primary logs etc.

Sabtu, 19 Januari 2019

Deploy Web Administration Tool and Starting embedded WebSphere Application Server

  Tidak ada komentar

root@jasmine21> # cp -r /opt/ibm/WebSphere/AppServer/profiles/TDSWebAdminProfile /opt/IBM/ldap/V6.3/appsrv/profiles/
root@jasmine21> #
root@jasmine21> # ls
DSML.zip             TDSWEBPortDef.props  bin                  idsdefinst           idswmigr             setLogging.jacl
IDSWebApp.war        adsynch              deploy_IDSWebApp     idslogmgmt           nossl                snmp
root@jasmine21> #
root@jasmine21> # ./deploy_IDSWebApp

mkdir -p /opt/IBM/ldap/V6.3/appsrv/temp/deploy_IDSWebApp.tmp/WEB-INF/classes/security

cp /opt/IBM/ldap/V6.3/appsrv/profiles/TDSWebAdminProfile/installedApps/DefaultNode/IDSWebApp.war.ear/IDSWebApp.war/WEB-INF/classes/security/console_passwd /opt/IBM/ldap/V6.3/appsrv/temp/deploy_IDSWebApp.tmp/WEB-INF/classes/security/console_passwd

mkdir -p /opt/IBM/ldap/V6.3/appsrv/temp/deploy_IDSWebApp.tmp/WEB-INF/classes/IDSConfig/IDSServersConfig

cp /opt/IBM/ldap/V6.3/appsrv/profiles/TDSWebAdminProfile/installedApps/DefaultNode/IDSWebApp.war.ear/IDSWebApp.war/WEB-INF/classes/IDSConfig/IDSServersConfig/IDSServersInfo.xml /opt/IBM/ldap/V6.3/appsrv/temp/deploy_IDSWebApp.tmp/WEB-INF/classes/IDSConfig/IDSServersConfig/IDSServersInfo.xml

mkdir -p /opt/IBM/ldap/V6.3/appsrv/temp/deploy_IDSWebApp.tmp/WEB-INF/classes/IDSConfig/IDSAppReg

cp /opt/IBM/ldap/V6.3/appsrv/profiles/TDSWebAdminProfile/installedApps/DefaultNode/IDSWebApp.war.ear/IDSWebApp.war/WEB-INF/classes/IDSConfig/IDSAppReg/IDSAppReg.xml /opt/IBM/ldap/V6.3/appsrv/temp/deploy_IDSWebApp.tmp/WEB-INF/classes/IDSConfig/IDSAppReg/IDSAppReg.xml

mkdir -p /opt/IBM/ldap/V6.3/appsrv/temp/deploy_IDSWebApp.tmp/WEB-INF/classes/IDSConfig/IDSSessionConfig

cp /opt/IBM/ldap/V6.3/appsrv/profiles/TDSWebAdminProfile/installedApps/DefaultNode/IDSWebApp.war.ear/IDSWebApp.war/WEB-INF/classes/IDSConfig/IDSSessionConfig/IDSSessionMgmt.xml /opt/IBM/ldap/V6.3/appsrv/temp/deploy_IDSWebApp.tmp/WEB-INF/classes/IDSConfig/IDSSessionConfig/IDSSessionMgmt.xml

/opt/IBM/ldap/V6.3/appsrv/bin/wsadmin.sh -conntype NONE -profileName ${PROFILE_NAME} -c "\$AdminApp uninstall ${IDSWebApp_Name}"
root@jasmine21> #
root@jasmine21> #
root@jasmine21> # ls
DSML.zip             TDSWEBPortDef.props  bin                  idsdefinst           idswmigr             setLogging.jacl
IDSWebApp.war        adsynch              deploy_IDSWebApp     idslogmgmt           nossl                snmp
root@jasmine21> #
root@jasmine21> # cd bin/
root@jasmine21> #
root@jasmine21> # ls
idswebadmin.html     idswebadminssl.html  startWebadminApp
root@jasmine21> #
root@jasmine21> # ./startWebadminApp
/opt/IBM/ldap/V6.3/appsrv/profiles/TDSWebAdminProfile/bin/startServer.sh server1
ADMU0116I: Tool information is being logged in file
           /opt/ibm/WebSphere/AppServer/profiles/TDSWebAdminProfile/logs/server1/startServer.log
ADMU0128I: Starting tool with the TDSWebAdminProfile profile
ADMU3100I: Reading configuration for server: server1
ADMU3200I: Server launched. Waiting for initialization status.
ADMU3000I: Server server1 open for e-business; process id is 4456876
0
root@jasmine21> #

Change directory to install

How to fix error The deinstallation process cannot continue while there are DB2 instances

  Tidak ada komentar
Someday when i perform db2 unistallation, i got following error : the deinstallation process cannot continue while there are DB2 instances related to the current DB2 copy.

If you need to move up or down a level from this DB2 level, use the installFixPack command from the DB2 image for the level you desire to move to, which will update this copy.

If you are only trying to uninstall this DB2 copy, you must either drop the related instances first, or you can update the instances to another DB2 copy which is at the same version as this DB2 copy, then restart the db2_deinstall command.

A major error occurred during the execution that caused this program to
terminate prematurely. If the problem persists, contact your technical service
representative.

For more information see the DB2 uninstallation log at
"/tmp/db2_deinstall.log.4522420".
root@jasmine21> # tail -n 100 /tmp/db2_deinstall.log.4522420

DB2 Setup log file started at:  Sat Jan 19 22:37:55 2019 WIB
============================================================

Operating system information: AIX 6.1

Previously Installed Products:
    DB2 Enterprise Server Edition
Selected Products:
    DB2 Enterprise Server Edition

Previously Installed Components:
    Base client support
    Java support
    SQL procedures
    Base server support
    IBM Software Development Kit (SDK) for Java(TM)
    Connect support
    Communication support - TCP/IP
    Replication tools
    DB2 data source support
    DB2 LDAP support
    DB2 Instance Setup wizard
    Integrated Flash Copy Support
    DB2 Update Service
    First Steps
    Sample database source
Selected Components:
    Base client support
    Java support
    SQL procedures
    Base server support
    IBM Software Development Kit (SDK) for Java(TM)
    Connect support
    Communication support - TCP/IP
    Replication tools
    DB2 data source support
    DB2 LDAP support
    DB2 Instance Setup wizard
    Integrated Flash Copy Support
    DB2 Update Service
    First Steps
    Sample database source

Previously Installed Languages:
    English
Selected Languages:
    English

Target directory:                          /opt/IBM/tdsV6.3db2




ERROR: The deinstallation process cannot continue while there are DB2 instances
related to the current DB2 copy. If you need to move up or down a level from
this DB2 level, use the installFixPack command from the DB2 image for the level
you desire to move to, which will update this copy. If you are only trying to
uninstall this DB2 copy, you must either drop the related instances first, or
you can update the instances to another DB2 copy which is at the same version
as this DB2 copy, then restart the db2_deinstall command.

Preparing the system :.......Failure

DB2 Uninstall log file finished at:  Sat Jan 19 22:37:59 WIB 2019 WIB
============================================================

root@jasmine21> #
Locate db2greg tool by cd to the install directory under bin by root.

Enter to bin directory on db2 installation direcory
root@jasmine21> # cd bin/
root@jasmine21> # ls
.db2insto               db2IdentifyType1_v8_64  db2disable_soap_udf     db2imdbm                db2tdbmgr
ASNDONE                 db2IdentifyType1_v9_32  db2drdat                db2imnod                db2top
ASNLOAD                 db2IdentifyType1_v9_64  db2dsdcfgfill           db2imsslcfg             db2ucsmi
MQLInstall.sql          db2PArcmd               db2egcf                 db2inspf                db2uext2.pe
asnacmd                 db2_all                 db2empfa                db2javit                db2uext2.v2
asnadmt                 db2_aram                db2enable_soap_udf      db2jdbcbind             db2untag
asnadmtora              db2_call_stack          db2evmon                db2jdkp                 db2updserv
asnanalyze              db2_kill                db2evtbl                db2langdir              db2updv97
asnapply                db2_local_ps            db2exfmt                db2ldcfg                db2usrinf
asncap                  db2_ps                  db2exmig                db2lddrg                db2val
asnccmd                 db2acsutil              db2expln                db2level                db2vend
asnclp                  db2adutl                db2fedgentf             db2logsForRfwd          db2xdbmig
asnmail                 db2advis                db2flsn                 db2look                 db2xdbsg
asnmcmd                 db2batch                db2fm                   db2lspwd                ddcspkgn
asnmig4c                db2bfd                  db2fmcd                 db2lueff                ddcstrc
asnmig8                 db2bp                   db2fmcu                 db2move                 disable_MQFunctions
asnmigpw                db2bpq                  db2fmd                  db2mqCheck              dynexpln
asnmon                  db2cat                  db2fodc                 db2mqlsn                enable_MQFunctions
asnoqcap                db2cfexp                db2fopt                 db2mtrk                 hostlookup
asnoqccmd               db2cfimp                db2fs                   db2ncstk                ipclean
asnpwd                  db2chglibpath           db2ftok                 db2nkill                ipquery
asnqacmd                db2ckbkp                db2fupdt                db2nps                  ktdscvr
asnqanalyze             db2ckmig                db2gcf                  db2palog                pctt
asnqapp                 db2ckrst                db2gdeps                db2pdraw                profdb
asnqcap                 db2ckupgrade            db2genseed              db2pmove                rah
asnqccmd                db2ckupgrade32_exe      db2gpinf                db2pread                rahemacs.el
asnqmfmt                db2ckupgrade64_exe      db2gpmap                db2rbind                rahemruninshell.el
asntdiff                db2cmnclp               db2greg                 db2rcmd                 rahhost
asntrc                  db2cos                  db2haicu                db2recri                rahwaitfor
asntrcbp                db2cos_datacorruption   db2hareg                db2refs.ndx             rahwrite
asntrep                 db2cos_hang             db2has                  db2relocatedb           readme.pct
clpplus                 db2cos_lib              db2help                 db2rspgn                routine
dart_all                db2cos_perf             db2iauto                db2sampl                sdscvr
db2                     db2cos_trap             db2icdocs               db2scont                tbscont
db2IdentifyType1        db2dasstm               db2ilist                db2support
db2IdentifyType1_exe    db2demigdbd             db2imaudcfg             db2tapemgr
db2IdentifyType1_v8_32  db2diag                 db2imdbd                db2tbst
root@jasmine21> #
root@jasmine21> # db2ilist
dsrdbm01
root@jasmine21> #

Run db2greg -dump to find instance entries which should have been removed from db2idrop. 

db2greg -dump |grep <dropped-instance name>

root@jasmine21> # db2greg -dump
V,DB2GPRF,DB2SYSTEM,jasmine21,/opt/IBM/tdsV6.3db2,
S,DB2,9.7.0.2,/opt/IBM/tdsV6.3db2,,,2,0,,1547904405,0
I,DB2,9.7.0.2,dsrdbm01,/home/dsrdbm01/sqllib,,1,0,/opt/IBM/tdsV6.3db2,,
root@jasmine21> #
dsrdbm01 is the instance name which was not removed from global.reg by db2idrop.


Use db2greg to delete the dropped instance entry.

db2greg -delinstrec instancename=<instance-name>


root@jasmine21> # db2greg -delinstrec instancename=dsrdbm01
root@jasmine21> #
root@jasmine21> # cd ../
.metadata/  adsm/       conv/       dsdriver/   include/    java/       logs/       properties/ tivready/
Readme/     bin/        das/        function/   infopop/    lib32/      map/        samples/    tools/
acs/        bnd/        dasfcn/     gskit/      install/    lib64/      misc/       security32/
adm/        cfg/        doc/        ha/         instance/   license/    msg/        security64/
root@jasmine21> # 
Change directory to install
root@jasmine21> # cd ../install
root@jasmine21> # ls
db2_deinstall       db2chgpath          db2ls_exec          logs
db2_deinstall_exec  db2ls               db2un.rsp           tsamp
root@jasmine21> #

root@jasmine21> # ./db2_deinstall -a
DBI1016I  Program db2_deinstall is performing uninstallation. Please
      wait.

The execution completed successfully.

For more information see the DB2 uninstallation log at
"/tmp/db2_deinstall.log.5636232".
root@jasmine21> #



Read the result log
root@jasmine21> # tail -n 100 /tmp/db2_deinstall.log.5636232
    DB2 Instance Setup wizard
    Integrated Flash Copy Support
    DB2 Update Service
    First Steps
    Sample database source

Previously Installed Languages:
    English
Selected Languages:
    English

Target directory:                          /opt/IBM/tdsV6.3db2




Preparing the system :.......Success
Stopping DB2 Fault Monitor :.......Success
Updating global registry :.......Success
Updating the db2ls link :.......Success
Executing control tasks :.......Success
WARNING: "IBM Tivoli Monitoring for Databases: DB2 Agent " was not be removed
because it was not installed.

Uninstalling IBM Tivoli Monitoring for Databases :.......Success
Removing files for "DB2_SAMPLE_DATABASE : Sample database source ".

Removing files for "ESE_PRODUCT_SIGNATURE : Product Signature for DB2
Enterprise Server Edition ".

Removing files for "FIRST_STEPS : First Steps ".

Removing files for "DB2_UPDATE_SERVICE : DB2 Update Service ".

Removing files for "ACS : Integrated Flash Copy Support ".

Removing files for "INSTANCE_SETUP_SUPPORT : DB2 Instance Setup wizard ".

Removing files for "LDAP_EXPLOITATION : DB2 LDAP support ".

Removing files for "DB2_DATA_SOURCE_SUPPORT : DB2 data source support ".

Removing files for "CLPPLUS : Command Line Processor Plus ".

Removing files for "REPL_CLIENT : Replication tools ".

Removing files for "EDB : EnterpriseDB code ".

Removing files for "DATABASE_PARTITIONING_SUPPORT : Parallel Extension ".

Removing files for "COMMUNICATION_SUPPORT_TCPIP : Communication support -
TCP/IP ".

Removing files for "CONNECT_SUPPORT : Connect support ".

Removing files for "JDK : IBM Software Development Kit (SDK) for Java(TM) ".

Removing files for "BASE_DB2_ENGINE : Base server support ".

Removing files for "JAVA_COMMON_FILES : Java Common files ".

Removing files for "ICU_SUP : ICU Utilities ".

Removing files for "SQL_PROCEDURES : SQL procedures ".

Removing files for "JAVA_SUPPORT : Java support ".

Removing files for "GSK : Global Secure ToolKit ".

Removing files for "BASE_DB2_ENGINE_R : Base server support for installation
with root privileges ".

Removing files for "DB2_JAVA_HELP_EN : Java Help (HTML) - English ".

Removing files for "JAVA_RUNTIME_SUPPORT : Java Runtime Support ".

Removing files for "BASE_CLIENT : Base client support ".

Removing files for "DB2_PRODUCT_MESSAGES_EN : Product Messages - English ".

Removing files for "BASE_CLIENT_R : Base Client Support for installation with
root privileges ".

Deleting DB2 file sets :.......Success

Post Uninstall Recommendations
-------------------------------

Required steps:
Manually remove the files that are not removed successfully if there is any in this log file.

Optional steps:
Some features, such as OS-based authentication, DB2 High Availability, and configuring the DB2 Advanced Copy Services (ACS) directory are available only in root installations. Also, reserving service names for TCP/IP remote connection or DB2 Text Search is available only in root installations. To enable these features and abilities in non-root installations, run the db2rfe script as the root user with a configuration file. See /opt/IBM/tdsV6.3db2/instance/db2rfe.cfg for an example of the configuration file.

To start using the DB2 instance "root", you must set up the DB2 instance environment by sourcing db2profile (for Bourne or Korn shell) or db2cshrc (for C shell) in the sqllib directory with the command ".  $HOME/sqllib/db2profile" or "source   $HOME/sqllib/db2cshrc". $HOME represents the home directory of the DB2 instance. You can also open a new login window of the DB2 instance user.


DB2 Uninstall log file finished at:  Sat Jan 19 22:47:54 WIB 2019 WIB
============================================================

root@jasmine21> #

How to unistall

  Tidak ada komentar
Enter to DB2 installation directory 
root@jasmine21> # installp -u -g GSKit8.gskcrypt64.ppc.rte
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

SUCCESSES
---------
  Filesets listed in this section passed pre-deinstall verification
  and will be removed.

  Selected Filesets
  -----------------
  GSKit8.gskcrypt64.ppc.rte 8.0.50.66         # IBM GSKit Cryptography Runtime

  << End of Success Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  Passed pre-deinstall verification
  ----
    1  Total to be deinstalled

+-----------------------------------------------------------------------------+
                           Deinstalling Software...
+-----------------------------------------------------------------------------+

installp:  DEINSTALLING software for:
        GSKit8.gskcrypt64.ppc.rte 8.0.50.66

--- postuninstall ---
Finished processing all filesets.  (Total time:  0 secs).

+-----------------------------------------------------------------------------+
                                Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name                        Level           Part        Event       Result
-------------------------------------------------------------------------------
GSKit8.gskcrypt64.ppc.rte   8.0.50.66       USR         DEINSTALL   SUCCESS
root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.cltbase63
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

SUCCESSES
---------
  Filesets listed in this section passed pre-deinstall verification
  and will be removed.

  Selected Filesets
  -----------------
  idsldap.cltbase63.adt 6.3.0.0               # Directory Server - Base Client
  idsldap.cltbase63.rte 6.3.0.0               # Directory Server - Base Client

  Dependents
  ----------
  Filesets listed in this section depend on one or more of the selected
  filesets (listed above) and, therefore, must also be removed.
  idsldap.clt64bit63.rte 6.3.0.0              # Directory Server - 64 bit Cl...
  idsldap.msg63.en_US 6.3.0.0                 # Directory Server - Messages ...
  idsldap.srv64bit63.rte 6.3.0.0              # Directory Server - 64 bit Se...
  idsldap.srvbase64bit63.rte 6.3.0.0          # Directory Server - Base Server
  idsldap.srvproxy64bit63.rte 6.3.0.0         # Directory Server - 64 bit Pr...

  << End of Success Section >>

FILESET STATISTICS
------------------
    2  Selected to be deinstalled, of which:
        2  Passed pre-deinstall verification
    5  Additional dependents to be automatically deinstalled
  ----
    7  Total to be deinstalled

+-----------------------------------------------------------------------------+
                           Deinstalling Software...
+-----------------------------------------------------------------------------+

installp:  DEINSTALLING software for:
        idsldap.msg63.en_US 6.3.0.0

Filesets processed:  1 of 7  (Total time:  1 secs).

installp:  DEINSTALLING software for:
        idsldap.srv64bit63.rte 6.3.0.0

Filesets processed:  2 of 7  (Total time:  2 secs).

installp:  DEINSTALLING software for:
        idsldap.srvproxy64bit63.rte 6.3.0.0

Filesets processed:  3 of 7  (Total time:  3 secs).

installp:  DEINSTALLING software for:
        idsldap.srvbase64bit63.rte 6.3.0.0

Filesets processed:  4 of 7  (Total time:  6 secs).

installp:  DEINSTALLING software for:
        idsldap.clt64bit63.rte 6.3.0.0

Filesets processed:  5 of 7  (Total time:  7 secs).

installp:  DEINSTALLING software for:
        idsldap.cltbase63.adt 6.3.0.0

Filesets processed:  6 of 7  (Total time:  8 secs).

installp:  DEINSTALLING software for:
        idsldap.cltbase63.rte 6.3.0.0

Finished processing all filesets.  (Total time:  9 secs).

+-----------------------------------------------------------------------------+
                                Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name                        Level           Part        Event       Result
-------------------------------------------------------------------------------
idsldap.msg63.en_US         6.3.0.0         USR         DEINSTALL   SUCCESS
idsldap.srv64bit63.rte      6.3.0.0         USR         DEINSTALL   SUCCESS
idsldap.srvproxy64bit63.rte 6.3.0.0         ROOT        DEINSTALL   SUCCESS
idsldap.srvproxy64bit63.rte 6.3.0.0         USR         DEINSTALL   SUCCESS
idsldap.srvbase64bit63.rte  6.3.0.0         ROOT        DEINSTALL   SUCCESS
idsldap.srvbase64bit63.rte  6.3.0.0         USR         DEINSTALL   SUCCESS
idsldap.clt64bit63.rte      6.3.0.0         ROOT        DEINSTALL   SUCCESS
idsldap.clt64bit63.rte      6.3.0.0         USR         DEINSTALL   SUCCESS
idsldap.cltbase63.adt       6.3.0.0         USR         DEINSTALL   SUCCESS
idsldap.cltbase63.rte       6.3.0.0         ROOT        DEINSTALL   SUCCESS
idsldap.cltbase63.rte       6.3.0.0         USR         DEINSTALL   SUCCESS
root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.clt64bit63
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

WARNINGS
--------
  Problems described in this section are not likely to be the source of any
  immediate or serious failures, but further actions may be necessary or
  desired.

  Not Installed
  -------------
  No software could be found on the system that could be deinstalled for the
  following requests:

    idsldap.clt64bit63

  (The fileset may not be currently installed, or you may have made a
   typographical error.)

  << End of Warning Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  FAILED pre-deinstall verification
  ----
    0  Total to be deinstalled


Pre-installation Failure/Warning Summary
----------------------------------------
Name                      Level           Pre-installation Failure/Warning
-------------------------------------------------------------------------------
idsldap.clt64bit63                        Nothing by this name to deinstall

root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.clt_max_crypto64bit63
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

WARNINGS
--------
  Problems described in this section are not likely to be the source of any
  immediate or serious failures, but further actions may be necessary or
  desired.

  Not Installed
  -------------
  No software could be found on the system that could be deinstalled for the
  following requests:

    idsldap.clt_max_crypto64bit63

  (The fileset may not be currently installed, or you may have made a
   typographical error.)

  << End of Warning Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  FAILED pre-deinstall verification
  ----
    0  Total to be deinstalled


Pre-installation Failure/Warning Summary
----------------------------------------
Name                      Level           Pre-installation Failure/Warning
-------------------------------------------------------------------------------
idsldap.clt_max_crypto64b                 Nothing by this name to deinstall

root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.cltjava63
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

SUCCESSES
---------
  Filesets listed in this section passed pre-deinstall verification
  and will be removed.

  Selected Filesets
  -----------------
  idsldap.cltjava63.rte 6.3.0.0               # Directory Server - Java Client

  << End of Success Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  Passed pre-deinstall verification
  ----
    1  Total to be deinstalled

+-----------------------------------------------------------------------------+
                           Deinstalling Software...
+-----------------------------------------------------------------------------+

installp:  DEINSTALLING software for:
        idsldap.cltjava63.rte 6.3.0.0

Finished processing all filesets.  (Total time:  1 secs).

+-----------------------------------------------------------------------------+
                                Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name                        Level           Part        Event       Result
-------------------------------------------------------------------------------
idsldap.cltjava63.rte       6.3.0.0         USR         DEINSTALL   SUCCESS
root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.srv64bit63
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

WARNINGS
--------
  Problems described in this section are not likely to be the source of any
  immediate or serious failures, but further actions may be necessary or
  desired.

  Not Installed
  -------------
  No software could be found on the system that could be deinstalled for the
  following requests:

    idsldap.srv64bit63

  (The fileset may not be currently installed, or you may have made a
   typographical error.)

  << End of Warning Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  FAILED pre-deinstall verification
  ----
    0  Total to be deinstalled


Pre-installation Failure/Warning Summary
----------------------------------------
Name                      Level           Pre-installation Failure/Warning
-------------------------------------------------------------------------------
idsldap.srv64bit63                        Nothing by this name to deinstall

root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.srvproxy64bit63
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

WARNINGS
--------
  Problems described in this section are not likely to be the source of any
  immediate or serious failures, but further actions may be necessary or
  desired.

  Not Installed
  -------------
  No software could be found on the system that could be deinstalled for the
  following requests:

    idsldap.srvproxy64bit63

  (The fileset may not be currently installed, or you may have made a
   typographical error.)

  << End of Warning Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  FAILED pre-deinstall verification
  ----
    0  Total to be deinstalled


Pre-installation Failure/Warning Summary
----------------------------------------
Name                      Level           Pre-installation Failure/Warning
-------------------------------------------------------------------------------
idsldap.srvproxy64bit63                   Nothing by this name to deinstall

root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.srv_max_crypto64bit63
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

WARNINGS
--------
  Problems described in this section are not likely to be the source of any
  immediate or serious failures, but further actions may be necessary or
  desired.

  Not Installed
  -------------
  No software could be found on the system that could be deinstalled for the
  following requests:

    idsldap.srv_max_crypto64bit63

  (The fileset may not be currently installed, or you may have made a
   typographical error.)

  << End of Warning Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  FAILED pre-deinstall verification
  ----
    0  Total to be deinstalled


Pre-installation Failure/Warning Summary
----------------------------------------
Name                      Level           Pre-installation Failure/Warning
-------------------------------------------------------------------------------
idsldap.srv_max_crypto64b                 Nothing by this name to deinstall

root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.srv_max_cryptoproxy64bit63
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

WARNINGS
--------
  Problems described in this section are not likely to be the source of any
  immediate or serious failures, but further actions may be necessary or
  desired.

  Not Installed
  -------------
  No software could be found on the system that could be deinstalled for the
  following requests:

    idsldap.srv_max_cryptoproxy64bit63

  (The fileset may not be currently installed, or you may have made a
   typographical error.)

  << End of Warning Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  FAILED pre-deinstall verification
  ----
    0  Total to be deinstalled


Pre-installation Failure/Warning Summary
----------------------------------------
Name                      Level           Pre-installation Failure/Warning
-------------------------------------------------------------------------------
idsldap.srv_max_cryptopro                 Nothing by this name to deinstall

root@jasmine21> #
root@jasmine21> # installp -u -g idsldap.msg63.en_US
+-----------------------------------------------------------------------------+
                    Pre-deinstall Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

WARNINGS
--------
  Problems described in this section are not likely to be the source of any
  immediate or serious failures, but further actions may be necessary or
  desired.

  Not Installed
  -------------
  No software could be found on the system that could be deinstalled for the
  following requests:

    idsldap.msg63.en_US

  (The fileset may not be currently installed, or you may have made a
   typographical error.)

  << End of Warning Section >>

FILESET STATISTICS
------------------
    1  Selected to be deinstalled, of which:
        1  FAILED pre-deinstall verification
  ----
    0  Total to be deinstalled


Pre-installation Failure/Warning Summary
----------------------------------------
Name                      Level           Pre-installation Failure/Warning
-------------------------------------------------------------------------------
idsldap.msg63.en_US                       Nothing by this name to deinstall

root@jasmine21> #



Check the directory

How to unistall tivoli Directory Server 6.3 Aix

  Tidak ada komentar
Enter to DB2 installation directory 
root@jasmine21> # cd /opt/IBM/
root@jasmine21> # ls
CPITDB                 FNCS                   NEXUSDB2               ldap                   tdsV6.3db2
ContentSearchServices  FN_CMIS                P8eF                   ltpakeys.txt           tsamp
ECMClient              FileNet                cpit                   sysmgtlib
root@jasmine21> # cd tdsV6.3db2/
root@jasmine21> # ls
.metadata   adsm        conv        dsdriver    include     java        logs        properties  tivready
Readme      bin         das         function    infopop     lib32       map         samples     tools
acs         bnd         dasfcn      gskit       install     lib64       misc        security32
adm         cfg         doc         ha          instance    license     msg         security64


Check the directory
root@jasmine21> # cd /opt/IBM
root@jasmine21> # ls
CPITDB                 FN_CMIS                cpit                   tsamp
ContentSearchServices  FileNet                ldap
ECMClient              NEXUSDB2               ltpakeys.txt
FNCS                   P8eF                   sysmgtlib
root@jasmine21> #
root@jasmine21> # cd ldap/
root@jasmine21> # ls
V6.3
root@jasmine21> # cd V6.3/
root@jasmine21> # ls
deinstl   idstools  var
root@jasmine21> #
root@jasmine21> # cd deinstl/
root@jasmine21> # ls
030cd98e4ccb0bf12b5ee8f56cdf9ef8.inventory
root@jasmine21> #
root@jasmine21> # cd ../idstools/
root@jasmine21> # ls
root@jasmine21> #
root@jasmine21> # cd ../var/
root@jasmine21> # ls
ldapinst.log
root@jasmine21> #
Remove the directory
root@jasmine21> # cd /opt/IBM
root@jasmine21> # ls
CPITDB                 FN_CMIS                cpit                   tsamp
ContentSearchServices  FileNet                ldap
ECMClient              NEXUSDB2               ltpakeys.txt
FNCS                   P8eF                   sysmgtlib
root@jasmine21> #
root@jasmine21> # rm -r ldap/
root@jasmine21> #
root@jasmine21> # ls
CPITDB                 FNCS                   NEXUSDB2               ltpakeys.txt
ContentSearchServices  FN_CMIS                P8eF                   sysmgtlib
ECMClient              FileNet                cpit                   tsamp
root@jasmine21> #

How to unistall IBM db2 database on aix

  Tidak ada komentar
Enter to DB2 installation directory 
root@jasmine21> # cd /opt/IBM/
root@jasmine21> # ls
CPITDB                 FNCS                   NEXUSDB2               ldap                   tdsV6.3db2
ContentSearchServices  FN_CMIS                P8eF                   ltpakeys.txt           tsamp
ECMClient              FileNet                cpit                   sysmgtlib
root@jasmine21> # cd tdsV6.3db2/
root@jasmine21> # ls
.metadata   adsm        conv        dsdriver    include     java        logs        properties  tivready
Readme      bin         das         function    infopop     lib32       map         samples     tools
acs         bnd         dasfcn      gskit       install     lib64       misc        security32
adm         cfg         doc         ha          instance    license     msg         security64
Change to install directory
root@jasmine21> # cd install/
root@jasmine21> # ls
db2_deinstall       db2chgpath          db2ls_exec          logs
db2_deinstall_exec  db2ls               db2un.rsp           tsamp
root@jasmine21> #
Running the following command

root@jasmine21> # ./db2_deinstall -a
DBI1016I  Program db2_deinstall is performing uninstallation. Please
      wait.

The execution completed successfully.

For more information see the DB2 uninstallation log at
"/tmp/db2_deinstall.log.5374140".
root@jasmine21> #

Read the log result file


root@jasmine21> # tail -n 100 /tmp/db2_deinstall.log.5374140
    DB2 Instance Setup wizard
    Integrated Flash Copy Support
    DB2 Update Service
    First Steps
    Sample database source

Previously Installed Languages:
    English
Selected Languages:
    English

Target directory:                          /opt/IBM/tdsV6.3db2




Preparing the system :.......Success
Stopping DB2 Fault Monitor :.......Success
Updating global registry :.......Success
Updating the db2ls link :.......Success
Executing control tasks :.......Success
WARNING: "IBM Tivoli Monitoring for Databases: DB2 Agent " was not be removed
because it was not installed.

Uninstalling IBM Tivoli Monitoring for Databases :.......Success
Removing files for "DB2_SAMPLE_DATABASE : Sample database source ".

Removing files for "ESE_PRODUCT_SIGNATURE : Product Signature for DB2
Enterprise Server Edition ".

Removing files for "FIRST_STEPS : First Steps ".

Removing files for "DB2_UPDATE_SERVICE : DB2 Update Service ".

Removing files for "ACS : Integrated Flash Copy Support ".

Removing files for "INSTANCE_SETUP_SUPPORT : DB2 Instance Setup wizard ".

Removing files for "LDAP_EXPLOITATION : DB2 LDAP support ".

Removing files for "DB2_DATA_SOURCE_SUPPORT : DB2 data source support ".

Removing files for "CLPPLUS : Command Line Processor Plus ".

Removing files for "REPL_CLIENT : Replication tools ".

Removing files for "EDB : EnterpriseDB code ".

Removing files for "DATABASE_PARTITIONING_SUPPORT : Parallel Extension ".

Removing files for "COMMUNICATION_SUPPORT_TCPIP : Communication support -
TCP/IP ".

Removing files for "CONNECT_SUPPORT : Connect support ".

Removing files for "JDK : IBM Software Development Kit (SDK) for Java(TM) ".

Removing files for "BASE_DB2_ENGINE : Base server support ".

Removing files for "JAVA_COMMON_FILES : Java Common files ".

Removing files for "ICU_SUP : ICU Utilities ".

Removing files for "SQL_PROCEDURES : SQL procedures ".

Removing files for "JAVA_SUPPORT : Java support ".

Removing files for "GSK : Global Secure ToolKit ".

Removing files for "BASE_DB2_ENGINE_R : Base server support for installation
with root privileges ".

Removing files for "DB2_JAVA_HELP_EN : Java Help (HTML) - English ".

Removing files for "JAVA_RUNTIME_SUPPORT : Java Runtime Support ".

Removing files for "BASE_CLIENT : Base client support ".

Removing files for "DB2_PRODUCT_MESSAGES_EN : Product Messages - English ".

Removing files for "BASE_CLIENT_R : Base Client Support for installation with
root privileges ".

Deleting DB2 file sets :.......Success

Post Uninstall Recommendations
-------------------------------

Required steps:
Manually remove the files that are not removed successfully if there is any in this log file.

Optional steps:
Some features, such as OS-based authentication, DB2 High Availability, and configuring the DB2 Advanced Copy Services (ACS) directory are available only in root installations. Also, reserving service names for TCP/IP remote connection or DB2 Text Search is available only in root installations. To enable these features and abilities in non-root installations, run the db2rfe script as the root user with a configuration file. See /opt/IBM/tdsV6.3db2/instance/db2rfe.cfg for an example of the configuration file.

To start using the DB2 instance "root", you must set up the DB2 instance environment by sourcing db2profile (for Bourne or Korn shell) or db2cshrc (for C shell) in the sqllib directory with the command ".  $HOME/sqllib/db2profile" or "source   $HOME/sqllib/db2cshrc". $HOME represents the home directory of the DB2 instance. You can also open a new login window of the DB2 instance user.


DB2 Uninstall log file finished at:  Sat Jan 19 18:34:40 WIB 2019 WIB
============================================================

root@jasmine21> #
Check the DB2 directory


root@jasmine21> # cd /opt/IBM
root@jasmine21> # ls
CPITDB                 FNCS                   NEXUSDB2               ldap                   tsamp
ContentSearchServices  FN_CMIS                P8eF                   ltpakeys.txt
ECMClient              FileNet                cpit                   sysmgtlib
root@jasmine21> #

Jumat, 18 Januari 2019

How to check DB2 installation validation

  Tidak ada komentar
Run db2val command
root@mydb2> # /opt/IBM/tdsV6.3db2/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/tdsV6.3db2 was successful.


DBI1343I  The db2val command completed successfully. For details, see
      the log file /tmp/db2val-01_19_14:29:54.log.

root@mydb2> #
Read the log result file
root@mydb2> # tail -n 100 /tmp/db2val-01_19_14:29:54.log
Installation file validation for the DB2 copy installed at "/opt/IBM/tdsV6.3db2" starts.

Task 1: Validating Installation file sets.
Status 1: Success

Task 2: Validating embedded runtime path for DB2 executables and libraries.
Status 2: Success

Task 3: Validating the accessibility to the installation path.
Status 3: Success

Task 4: Validating the accessibility to the /etc/services file.
Status 4: Success

DBI1335I  Installation file validation for the DB2 copy installed at
      /opt/IBM/tdsV6.3db2 was successful.

Installation file validation for the DB2 copy installed at "/opt/IBM/tdsV6.3db2" ends.


DBI1343I  The db2val command completed successfully. For details, see
      the log file /tmp/db2val-01_19_14:29:54.log.

root@mydb2> #



How to fix This broker is running; the command you issued cannot be processed

  Tidak ada komentar
Someday i need to start the IBM MQ broker
[user@soadev ~]$ mqsistart TEST_DEV
BIP8018E: Broker 'TEST_DEV' running.
This broker is running; the command you issued cannot be processed when a broker is running.
Stop the broker and reissue the command.
[user@soadev ~]$
Check the broker PID and kill the PID
[user@soadev ~]$ ps aux | grep bip
user      1708  0.0  0.0 178616  3508 ?        Ssl   2018   1:56 bipservice HUB_DEV
user      1713  0.0  0.4 2734036 54744 ?       Sl    2018  49:31 bipbroker HUB_DEV
user      1776  0.0  0.3 1560696 42576 ?       Sl    2018   9:21 biphttplistener HUB_DEV
user      3522  0.0  0.0 178616  3508 ?        Ssl  Jan06   0:02 bipservice TEST_DEV
user      3527  0.0  1.2 3083236 155368 ?      Sl   Jan06   1:19 bipbroker TEST_DEV
user      3593  0.0  0.3 1561584 39452 ?       Sl   Jan06   0:13 biphttplistener TEST_DEV
user     20180  0.0  0.0 103336   860 pts/0    S+   15:36   0:00 grep bip
[user@soadev ~]$
[user@soadev ~]$ sudo kill -9 3527
[sudo] password for user:
[user@soadev ~]$ sudo kill -9 3522
[user@soadev ~]$ sudo kill -9 3593
[user@soadev ~]$
Start the IBM MQ broker again
[user@soadev ~]$ mqsilist
BIP1285I: Broker 'HUB_DEV' on queue manager 'HUBQ_DEV' is stopped.
BIP1285I: Broker 'TEST_DEV' on queue manager 'TESTQ_DEV' is stopped.
BIP8071I: Successful command completion.
[user@soadev ~]$
[user@soadev ~]$ mqsistart TEST_DEV
BIP8096I: Successful command initiation, check the system log to ensure that the component started without problem and that it continues to run without problem.
[user@soadev ~]$
[user@soadev ~]$  runmqlsr -t tcp -p 1551 -m TESTQ_DEV&
[1] 21767
[user@soadev ~]$ 5724-H72 (C) Copyright IBM Corp. 1994, 2014.

[user@soadev ~]$



Download VMware vSphere Client

  Tidak ada komentar
The question of where to download the vSphere client, including previous versions, comes up now and again. All links from vSphere 4.1 through to vSphere 6.x listed below:
vSphere 4.1
vSphere 5.0
vSphere 5.1
vSphere 5.5
vSphere 6

Download VMWare vSphere Client 5.5 and 5.5 update 1

  Tidak ada komentar
VMWare vSphere 5.5 can be adminstered remotely using VMWare vSphere Client 5.5.  Once you install vSphere, you can connect to it remotely using vSphere Client.
You can download it directly from the following location:
Download VMWare vSphere Client
1.VMWare vSphere Cient 5.5.0
2.VMWare vSphere Client 5.5 Update 1
After downloading it, install it.  The installation is a series of dialog boxes and is quite straight forward.  Once installation is done, to connect to the remote host, enter the hostname or the IP address of the server followed by username and password.
This connects you to the remote vSphere server.  Now you can adminster this Server and Virtual machines running on it using this client interface.