环境信息
操作系统:OEL 8
数据库版本：11.5.4.0
配置信息：虚拟机 4G内存
补丁包解压
[root@fwl-node01 stage]# tar -zxvf v11.5.6_linuxx64_server_dec.tar.gz
[root@fwl-node01 stage]# chmod 777 server_dec
[root@fwl-node01 stage]# mv server_dec db2-11.5.6
[root@fwl-node01 stage]# ll
total 3960148
drwxrwxrwx 3 root root 206 Jun 12 01:50 db2-11.5.6
drwxrwxrwx 3 root root 206 Jun 17 2020 ibm-db2
-rw-r--r-- 1 root root 1971729433 Jun 29 23:38 v11.5.4_linuxx64_server_dec.tar.gz
-rw-r--r-- 1 root root 2083458415 Jun 30 15:26 v11.5.6_linuxx64_server_dec.tar.gz
[root@fwl-node01 stage]#
Note：补丁包分两种，universal包和server包，前者单独用来升级，后者可以升级和安装独立
停止数据库实例
[db2fwl1@fwl-node01 ~]$ db2 force application all;
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.
[db2fwl1@fwl-node01 ~]$
Note：强制杀掉会话。
[db2fwl1@fwl-node01 ~]$ db2stop
06/30/2021 23:22:22 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
[db2fwl1@fwl-node01 ~]$ db2_ps
Node 0
UID PID PPID C STIME TTY TIME CMD
[db2fwl1@fwl-node01 ~]$
升级包预检查
[root@fwl-node01 ~]# cd /stage/db2-11.5.6
[root@fwl-node01 db2-11.5.6]# ll
total 84
drwxr-xr-x 6 bin bin 134 Jun 12 01:50 db2
-r--r--r-- 1 bin bin 4987 Jun 12 01:50 db2checkCOL_readme.txt
-r--r--r-- 1 bin bin 16808 Jun 12 01:50 db2checkCOL.tar.gz
-r-xr-xr-x 1 bin bin 5254 Jun 12 01:50 db2ckupgrade
-r-xr-xr-x 1 bin bin 5207 Jun 12 01:50 db2_deinstall
-r-xr-xr-x 1 bin bin 5077 Jun 12 01:50 db2_install
-r-xr-xr-x 1 bin bin 5041 Jun 12 01:50 db2ls
-r-xr-xr-x 1 bin bin 5059 Jun 12 01:50 db2prereqcheck
-r-xr-xr-x 1 bin bin 5059 Jun 12 01:50 db2setup
-r-xr-xr-x 1 bin bin 5095 Jun 12 01:50 installFixPack
[root@fwl-node01 db2-11.5.6]# ./db2prereqcheck -i -v 11.5.6.0
==========================================================================
Wed Jun 30 23:53:01 2021
Checking prerequisites for DB2 installation. Version "11.5.6.0". Operating system "Linux"
Validating "Linux distribution " ...
Required minimum operating system distribution: "RHEL"; Version: "8"; Service pack: "1".
Actual operating system distribution Version: "8"; Service pack: "4".
Requirement matched.
Validating "kernel level " ...
Required minimum operating system kernel level: "3.10.0".
Actual operating system kernel level: "5.4.17".
Requirement matched.
Validating "ipcmni_extend kernel parameter " ...
WARNING : Requirement not matched.
Validating "C++ Library version " ...
Required minimum C++ library: "libstdc++.so.6"
Standard C++ library is located in the following directory: "/usr/lib64/libstdc++.so.6.0.25".
Actual C++ library: "CXXABI_1.3.1"
Requirement matched.
Validating "32 bit version of "libstdc++.so.6" " ...
Found the 32 bit "/lib/libstdc++.so.6" in the following directory "/lib".
Requirement matched.
Validating "libaio.so version " ...
DBT3553I The db2prereqcheck utility successfully loaded the libaio.so.1 file.
Requirement matched.
Validating "libnuma.so version " ...
DBT3610I The db2prereqcheck utility successfully loaded the libnuma.so.1 file.
Requirement matched.
Validating "/lib/libpam.so*" ...
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites were met.
[root@fwl-node01 db2-11.5.6]#
Note：有个内核参数警告，因为虚拟机环境内存比较小，不影响。
安装补丁升级包
Note：-b原来的家目录，-p新的家目录，建议安装在新的目录
[root@fwl-node01 db2-11.5.6]# ./installFixPack -b /opt/ibm/db2/V11.5 -p /opt/ibm/db2/V11.5.6
Read the license agreement file in the db2/license directory.
***********************************************************
To accept those terms, enter "yes". Otherwise, enter "no" to cancel the install process. [yes/no]
yes
DBI1017I installFixPack is updating the database products installed in
location /opt/ibm/db2/V11.5.
DB2 installation is being initialized.
Total number of tasks to be performed: 51
Total estimated time for all tasks to be performed: 2415 second(s)
Task #1 start
Description: Preparing the system
Estimated time 120 second(s)
Task #1 end
Task #2 start
Description: Base Client Support for installation with root privileges
Estimated time 3 second(s)
Task #2 end
Task #3 start
Description: Product Messages - English
Estimated time 14 second(s)
Task #3 end
Task #4 start
Description: Base client support
Estimated time 355 second(s)
Task #4 end
Task #5 start
Description: Java Runtime Support
Estimated time 217 second(s)
Task #5 end
Task #6 start
Description: Java Help (HTML) - English
Estimated time 7 second(s)
Task #6 end
Task #7 start
Description: Base server support for installation with root privileges
Estimated time 6 second(s)
Task #7 end
Task #8 start
Description: Global Secure ToolKit
Estimated time 76 second(s)
Task #8 end
Task #9 start
Description: Java support
Estimated time 11 second(s)
Task #9 end
Task #10 start
Description: SQL procedures
Estimated time 3 second(s)
Task #10 end
Task #11 start
Description: ICU Utilities
Estimated time 59 second(s)
Task #11 end
Task #12 start
Description: Java Common files
Estimated time 18 second(s)
Task #12 end
Task #13 start
Description: Base server support
Estimated time 582 second(s)
Task #13 end
Task #14 start
Description: Control Center Help (HTML) - English
Estimated time 13 second(s)
Task #14 end
Task #15 start
Description: Relational wrappers common
Estimated time 3 second(s)
Task #15 end
Task #16 start
Description: DB2 data source support
Estimated time 6 second(s)
Task #16 end
Task #17 start
Description: ODBC data source support
Estimated time 260 second(s)
Task #17 end
Task #18 start
Description: Teradata data source support
Estimated time 3 second(s)
Task #18 end
Task #19 start
Description: Spatial Extender server support
Estimated time 21 second(s)
Task #19 end
Task #20 start
Description: Scientific Data Sources
Estimated time 5 second(s)
Task #20 end
Task #21 start
Description: JDBC data source support
Estimated time 200 second(s)
Task #21 end
Task #22 start
Description: IBM Software Development Kit (SDK) for Java(TM)
Estimated time 49 second(s)
Task #22 end
Task #23 start
Description: DB2 LDAP support
Estimated time 4 second(s)
Task #23 end
Task #24 start
Description: DB2 Instance Setup wizard
Estimated time 23 second(s)
Task #24 end
Task #25 start
Description: Structured file data sources
Estimated time 5 second(s)
Task #25 end
Task #26 start
Description: Integrated Flash Copy Support
Estimated time 3 second(s)
Task #26 end
Task #27 start
Description: Oracle data source support
Estimated time 4 second(s)
Task #27 end
Task #28 start
Description: Connect support
Estimated time 3 second(s)
Task #28 end
Task #29 start
Description: Application data sources
Estimated time 4 second(s)
Task #29 end
Task #30 start
Description: Spatial Extender client
Estimated time 3 second(s)
Task #30 end
Task #31 start
Description: SQL Server data source support
Estimated time 4 second(s)
Task #31 end
Task #32 start
Description: Communication support - TCP/IP
Estimated time 3 second(s)
Task #32 end
Task #33 start
Description: Base application development tools
Estimated time 36 second(s)
Task #33 end
Task #34 start
Description: Parallel Extension
Estimated time 3 second(s)
Task #34 end
Task #35 start
Description: EnterpriseDB code
Estimated time 3 second(s)
Task #35 end
Task #36 start
Description: Replication tools
Estimated time 60 second(s)
Task #36 end
Task #37 start
Description: Sample database source
Estimated time 4 second(s)
Task #37 end
Task #38 start
Description: itlm
Estimated time 3 second(s)
Task #38 end
Task #39 start
Description: DB2 Text Search
Estimated time 107 second(s)
Task #39 end
Task #40 start
Description: Command Line Processor Plus
Estimated time 8 second(s)
Task #40 end
Task #41 start
Description: Sybase data source support
Estimated time 3 second(s)
Task #41 end
Task #42 start
Description: Informix data source support
Estimated time 4 second(s)
Task #42 end
Task #43 start
Description: Federated Data Access Support
Estimated time 3 second(s)
Task #43 end
Task #44 start
Description: First Steps
Estimated time 3 second(s)
Task #44 end
Task #45 start
Description: Product Signature for DB2 Server Edition
Estimated time 6 second(s)
Task #45 end
Task #46 start
Description: Guardium Installation Manager Client
Estimated time 36 second(s)
Task #46 end
Task #47 start
Description: Setting DB2 library path
Estimated time 180 second(s)
Task #47 end
Task #48 start
Description: Executing control tasks
Estimated time 20 second(s)
Task #48 end
Task #49 start
Description: Updating global registry
Estimated time 20 second(s)
Task #49 end
Task #50 start
Description: Updating the db2ls and db2greg link
Estimated time 1 second(s)
Task #50 end
Task #51 start
Description: Registering DB2 licenses
Estimated time 5 second(s)
Task #51 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/installFixPack.log.224475".
[root@fwl-node01 db2-11.5.6]#
安装日志
[root@fwl-node01 db2-11.5.6]# cat /tmp/installFixPack.log.224475
DB2 Fix Pack Update log file started at: Wed Jun 30 11:55:33 PM 2021 CST
============================================================
Operating system information: Linux 5.4.17-2102.201.3.el8uek.x86_64.#2 SMP Fri Apr 23 09:05:57 PDT 2021 x86_64
Previously Installed Components:
Base client support
Java support
SQL procedures
Base server support
DB2 data source support
ODBC data source support
Teradata data source support
Spatial Extender server support
Scientific Data Sources
JDBC data source support
IBM Software Development Kit (SDK) for Java(TM)
DB2 LDAP support
DB2 Instance Setup wizard
Structured file data sources
Integrated Flash Copy Support
Oracle data source support
Connect support
Application data sources
Spatial Extender client
SQL Server data source support
Communication support - TCP/IP
Base application development tools
Replication tools
Sample database source
DB2 Text Search
Sybase data source support
Informix data source support
Federated Data Access Support
First Steps
Guardium Installation Manager Client
Selected Components:
Base client support
Java support
SQL procedures
Base server support
DB2 data source support
ODBC data source support
Teradata data source support
Spatial Extender server support
Scientific Data Sources
JDBC data source support
IBM Software Development Kit (SDK) for Java(TM)
DB2 LDAP support
DB2 Instance Setup wizard
Structured file data sources
Integrated Flash Copy Support
Oracle data source support
Connect support
Application data sources
Spatial Extender client
SQL Server data source support
Communication support - TCP/IP
Base application development tools
Replication tools
Sample database source
DB2 Text Search
Sybase data source support
Informix data source support
Federated Data Access Support
First Steps
Guardium Installation Manager Client
Languages:
English (already installed )
Target directory: /opt/ibm/db2/V11.5.6
Space required: 1873 MB
Preparing the system :.......Success
Installing: BASE_CLIENT_R
Installing: DB2_PRODUCT_MESSAGES_EN
Installing: BASE_CLIENT
Installing: JAVA_RUNTIME_SUPPORT
Installing: DB2_JAVA_HELP_EN
Installing: BASE_DB2_ENGINE_R
Installing: GSK
Installing: JAVA_SUPPORT
Installing: SQL_PROCEDURES
Installing: ICU_SUP
Installing: JAVA_COMMON_FILES
Installing: BASE_DB2_ENGINE
Installing: DB2_CONTROL_CENTER_HELP_EN
Installing: RELATIONAL_WRAPPERS_COMMON
Installing: DB2_DATA_SOURCE_SUPPORT
Installing: ODBC_DATA_SOURCE_SUPPORT
Installing: TERADATA_DATA_SOURCE_SUPPORT
Installing: SPATIAL_EXTENDER_SERVER_SUPPORT
Installing: IINR_SCIENTIFIC_WRAPPER
Installing: JDBC_DATA_SOURCE_SUPPORT
Installing: JDK
Installing: LDAP_EXPLOITATION
Installing: INSTANCE_SETUP_SUPPORT
Installing: IINR_STRUCTURED_FILES_WRAPPER
Installing: ACS
Installing: ORACLE_DATA_SOURCE_SUPPORT
Installing: CONNECT_SUPPORT
Installing: IINR_APPLICATIONS_WRAPPER
Installing: SPATIAL_EXTENDER_CLIENT_SUPPORT
Installing: SQL_SERVER_DATA_SOURCE_SUPPORT
Installing: COMMUNICATION_SUPPORT_TCPIP
Installing: APPLICATION_DEVELOPMENT_TOOLS
Installing: DATABASE_PARTITIONING_SUPPORT
Installing: EDB
Installing: REPL_CLIENT
Installing: DB2_SAMPLE_DATABASE
Installing: ITLM
Installing: TEXT_SEARCH
Installing: CLPPLUS
Installing: SYBASE_DATA_SOURCE_SUPPORT
Installing: INFORMIX_DATA_SOURCE_SUPPORT
Installing: FED_DATA_SOURCE_SUPPORT
Installing: FIRST_STEPS
Installing: ESE_PRODUCT_SIGNATURE
Installing: GUARDIUM_INST_MNGR_CLIENT
Updating DB2 file sets :.......Success
Executing control tasks :.......Success
Updating global registry :.......Success
Updating the db2ls and db2greg link :.......Success
Registering DB2 licenses :.......Success
Post Fix Pack Update Recommendations
-------------------------------------
Required steps:
Perform the post-installation tasks specified in the fix pack Readme.
Optional steps:
To validate your installation files, instance, and database functionality, run the Validation Tool, /opt/ibm/db2/V11.5/bin/db2val. For more information, see "db2val" in the DB2 Information Center.
DBI20050I When the installFixPack command is run with the -p parameter, instances are not updated automatically. You must manually update the instances using the db2iupdt command. In addition, in a DB2 pureScale environment, if the fix pack is applied on multiple hosts, you must run the db2iupdt command on all hosts.
DB2 Fix Pack Update log file finished at: Wed Jun 30 11:57:25 PM 2021 CST
============================================================
[root@fwl-node01 db2-11.5.6]#
数据库实例升级
Note：-u 为指定受保护的用户。
[root@fwl-node01 instance]# ./db2iupdt -u db2fen1 db2fwl1
DBI1446I The db2iupdt command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 4
Total estimated time for all tasks to be performed: 309 second(s)
Task #1 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #1 end
Task #2 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #2 end
Task #3 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #3 end
Task #4 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #4 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2iupdt.log.262479".
DBI1070I Program db2iupdt completed successfully.
[root@fwl-node01 instance]#
升级日志
[root@fwl-node01 instance]# cat /tmp/db2iupdt.log.262479
DB2 Setup log file started at: Wed Jun 30 11:59:41 PM 2021 CST
============================================================
Operating system information: Linux 5.4.17-2102.201.3.el8uek.x86_64.#2 SMP Fri Apr 23 09:05:57 PDT 2021 x86_64
Existing instances to configure:
Instance name: db2fwl1
Instance user information:
User name: db2fwl1
Fenced user information:
User name: db2fen1
Setting default global profile registry variables :.......Success
Initializing instance list :.......Success
The instance "db2fwl1" has been updated successfully.
Configuring DB2 instances :.......Success
Updating global profile registry :.......Success
Post-installation instructions
-------------------------------
Required steps:
DB2 Text Search has not been configured for the instance "db2fwl1".To automatically configure DB2 text search services, run the db2iupdt command (or the db2nrupdt command for non-root installations) specifying the -j "TEXT_SEARCH" option.Manual configuration steps can be found in the DB2 Text Search documentation "https://www-01.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.ts.doc/doc/c0051296.html".
Start using the DB2 product using a valid user ID such as the DB2 instance owner's ID "db2fwl1".
Optional steps:
To validate your installation files, instance, and database functionality, run the Validation Tool, /opt/ibm/db2/V11.5.6/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.
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.
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 (https://www-01.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.kc.doc/welcome.html) 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://www-01.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.qb.server.doc/doc/c0061199.html.
DB2 Setup log file finished at: Thu Jul 01 12:00:05 AM 2021 CST
============================================================
升级数据库
Note：需要升级所有的数据库。
[root@fwl-node01 instance]# su - db2fwl1
[db2fwl1@fwl-node01 ~]$ db2updv115 -d fwldb
_________________________________________________________________________
_____ DB2 Service Tools _____
I B M
db2updv115
This tool is a service utility designed to update a DB2 Version 11.5
database to the current fix pack level.
_________________________________________________________________________
DB2 Universal Database Version 11.5, 5622-044 (c) Copyright IBM Corp. 2017
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool
db2updv115 completed successfully for database 'fwldb'.
[db2fwl1@fwl-node01 ~]$
启动实例
[db2fwl1@fwl-node01 ~]$ db2start
07/01/2021 00:03:17 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[db2fwl1@fwl-node01 ~]$
[db2fwl1@fwl-node01 ~]$ db2_ps
Node 0
UID PID PPID C STIME TTY TIME CMD
root 274651 1 0 00:03 pts/2 00:00:00 db2wdog 0 [db2fwl1]
db2fwl1 274653 274651 1 00:03 pts/2 00:00:27 db2sysc 0
root 274659 274651 0 00:03 pts/2 00:00:00 db2ckpwd 0
root 274660 274651 0 00:03 pts/2 00:00:00 db2ckpwd 0
root 274661 274651 0 00:03 pts/2 00:00:00 db2ckpwd 0
db2fwl1 274663 274651 0 00:03 pts/2 00:00:00 db2vend (PD Vendor Process - 1) 0
db2fwl1 274675 274651 0 00:03 pts/2 00:00:00 db2acd 0 ,0,0,0,1,0,0,00000000,0,0,0000000000000000,0000000000000000,00000000,00000000,00000000,00000000,00000000,00000000,0000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,000000019b5f2000,0000000000000000,0000000000000000,1,0,0,,,,,a89e68,14,1e014,2,0,1,0000000000041fc0,0x240000000,0x240000000,1600000,50007,2,c800c
db2fen1 275702 274651 0 00:08 pts/2 00:00:00 db2fmp ( ,0,0,0,0,0,0,00000000,0,0,0000000000000000,0000000000000000,00000000,00000000,00000000,00000000,00000000,00000000,0000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,000000019b5f2000,0000000000000000,0000000000000000,1,0,0,,,,,a89e68,14,1e014,2,0,1,0000000000061fc0,0x240000000,0x240000000,1600000,50007,2,c8030
db2fen1 275718 274651 0 00:08 pts/2 00:00:00 db2fmp ( ,1,0,0,0,0,0,00000000,0,0,0000000000000000,0000000000000000,00000000,00000000,00000000,00000000,00000000,00000000,0000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,000000019b5f2000,0000000000000000,0000000000000000,1,0,0,,,,,a89e68,14,1e014,2,0,1,0000000000081fc0,0x240000000,0x240000000,1600000,50007,2,c8037
[db2fwl1@fwl-node01 ~]$
跑SQL脚步
Note：所有数据库均需要运行。
[db2fwl1@fwl-node01 ~]$ cd /home/db2fwl1/sqllib/bnd
[db2fwl1@fwl-node01 bnd]$ db2 connect to fwldb
Database Connection Information
Database server = DB2/LINUXX8664 11.5.6.0
SQL authorization ID = DB2FWL1
Local database alias = FWLDB
[db2fwl1@fwl-node01 bnd]$ db2 "BIND db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE"
LINE MESSAGES FOR db2schema.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.
[db2fwl1@fwl-node01 bnd]$
[db2fwl1@fwl-node01 bnd]$ db2 "BIND @db2ubind.lst BLOCKING ALL GRANT PUBLIC"
LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
LINE MESSAGES FOR db2clpnc.bnd
------ --------------------------------------------------------------------
SQL0595W Isolation level "NC" has been escalated to "UR".
SQLSTATE=01526
LINE MESSAGES FOR db2arxnc.bnd
------ --------------------------------------------------------------------
SQL0595W Isolation level "NC" has been escalated to "UR".
SQLSTATE=01526
LINE MESSAGES FOR db2_adminotm.bnd
------ --------------------------------------------------------------------
242 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
456 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
483 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
562 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
632 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
658 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
674 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
744 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
828 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
1199 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
1298 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0091N Binding was ended with "0" errors and "13"
warnings.
[db2fwl1@fwl-node01 bnd]$
Note：SYSTOOLS.ADMIN_MOVE_TABLE不存在，无需理会。
[db2fwl1@fwl-node01 bnd]$ db2 "BIND @db2cli.lst BLOCKING ALL GRANT PUBLIC"
LINE MESSAGES FOR db2cli.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.
[db2fwl1@fwl-node01 bnd]$
校验
[db2fwl1@fwl-node01 bnd]$ db2level
DB21085I This instance or install (instance name, where applicable: "db2fwl1")
uses "64" bits and DB2 code release "SQL11056" with level identifier
"0607010F".
Informational tokens are "DB2 v11.5.6.0", "s2106111000", "DYN2106111000AMD64",
and Fix Pack "0".
Product is installed at "/opt/ibm/db2/V11.5.6".
Note：可以看到db2的版本变为11.5.6了。
[db2fwl1@fwl-node01 bnd]$ db2ls
Install Path Level Fix Pack Special Install Number Install Date Installer UID
---------------------------------------------------------------------------------------------------------------------
/opt/ibm/db2/V11.5 11.5.4.0 0 Wed Jun 30 13:35:33 2021 CST 0
/opt/ibm/db2/V11.5.6 11.5.6.0 0 Wed Jun 30 23:57:23 2021 CST 0
Note：旧了安装目录我们保存下来了
[db2fwl1@fwl-node01 ~]$ db2 "select INST_NAME,SERVICE_LEVEL from sysibmadm.env_inst_info"
INST_NAME SERVICE_LEVEL
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
db2fwl1 DB2 v11.5.6.0
1 record(s) selected.
[db2fwl1@fwl-node01 bnd]$
Note：数据库的版本也更新了。
最后致敬下Monna!
最后修改时间：2021-07-01 00:55:54
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
