Sabtu, 19 Januari 2019

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".
[email protected]> # 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
============================================================

[email protected]> #
Locate db2greg tool by cd to the install directory under bin by root.

Enter to bin directory on db2 installation direcory
[email protected]> # cd bin/
[email protected]> # 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
[email protected]> #
[email protected]> # db2ilist
dsrdbm01
[email protected]> #

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

db2greg -dump |grep <dropped-instance name>

[email protected]> # 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,,
[email protected]> #
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>


[email protected]> # db2greg -delinstrec instancename=dsrdbm01
[email protected]> #
[email protected]> # 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/
[email protected]> # 
Change directory to install
[email protected]> # cd ../install
[email protected]> # ls
db2_deinstall       db2chgpath          db2ls_exec          logs
db2_deinstall_exec  db2ls               db2un.rsp           tsamp
[email protected]> #

[email protected]> # ./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".
[email protected]> #



Read the result log
[email protected]> # 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
============================================================

[email protected]> #

Tidak ada komentar :

Posting Komentar