| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 |
- 데이터가드
- Opatch
- Installation
- oracle installation
- Oracle 19c
- 오라클설치
- 19c
- 오라클아키텍쳐
- SSH
- OracleGoldenGate
- 데이터베이스
- 오라클구조
- adg
- ORACLE19C
- SILENTMODE
- oracle recovery
- diskgroup
- DataGuard
- 디비투
- goldengate
- oracle goldengate
- linux
- 오지지
- Oracle
- 사일런트모드
- 티베로
- 오라클
- ActiveDataGuard
- Database
- ogg
- Today
- Total
DoubleDBDeep
[DB2] 설치 본문
OS
1. 패키지 다운
yum install -y glibc-common-2.17-260.el7.x86_64
yum install -y glibc-2.17-260.el7.x86_64
yum install -y libstdc++.so
yum install -y compat-libstdc++-33.x86_64
yum install -y ksh.x86_64
2. 유저, 그룹 생성
groupadd db2iadm1
groupadd db2fadm1
groupadd dasadm1
useradd -g db2iadm1 -m -d /opt/db2inst1 db2inst1
useradd -g db2fadm1 -m -d /opt/db2fenc1 db2fenc1
useradd -g dasadm1 -m -d /opt/dasusr1 dasusr1
passwd db2inst1
3. 압축 해제 및 설치
cp v11.5.7_linuxx64_server_dec.tar.gz /opt/db2inst1
tar -xzf v11.5.7_linuxx64_server_dec.tar.gz
[root:/opt/db2inst1]> cd server_dec/
[root:/opt/db2inst1/server_dec]> ls
db2 db2checkCOL.tar.gz db2_deinstall db2ls db2setup
db2checkCOL_readme.txt db2ckupgrade db2_install db2prereqcheck installFixPack
export LANG=C
./db2_install설치 log
[root:/opt/db2inst1/server_dec]> ./db2_install
Requirement not matched for DB2 database "Server" . Version: "11.5.7.0".
Summary of prerequisites that are not met on the current system:
DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*".
DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.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
Default directory for installation of products - /opt/ibm/db2/V11.5
***********************************************************
Install into default directory (/opt/ibm/db2/V11.5) ? [yes/no]
yes
Specify one of the following keywords to install DB2 products.
SERVER
CONSV
CLIENT
RTCL
Enter "help" to redisplay product names.
Enter "quit" to exit.
***********************************************************
server
***********************************************************
Do you want to install the DB2 pureScale Feature? [yes/no]
no
Requirement not matched for DB2 database "Server" . Version: "11.5.7.0".
Summary of prerequisites that are not met on the current system:
DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*".
DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6".
DB2 installation is being initialized.
Total number of tasks to be performed: 55
Total estimated time for all tasks to be performed: 2332 second(s)
Task #1 start
Description: Checking license agreement acceptance
Estimated time 1 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 360 second(s)
Task #4 end
Task #5 start
Description: Java Runtime Support
Estimated time 215 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 610 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 185 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 108 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: Starting DB2 Fault Monitor
Estimated time 10 second(s)
Task #50 end
Task #51 start
Description: Updating the db2ls and db2greg link
Estimated time 1 second(s)
Task #51 end
Task #52 start
Description: Registering DB2 licenses
Estimated time 5 second(s)
Task #52 end
Task #53 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #53 end
Task #54 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #54 end
Task #55 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #55 end
The execution completed with warnings.
For more information see the DB2 installation log at
"/tmp/db2_install.log.20919".
4. 환경 설정
# 환경설정
cd /opt/ibm/db2/V11.5/instance
# dascrt 설정
./dascrt -u dasusr1
DBI1070I Program dascrt completed successfully.
# instance 설정
./db2icrt -u db2fenc1 db2inst1
DBI1446I The db2icrt 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/db2icrt.log.26441".
DBI1070I Program db2icrt completed successfully.
5. 통신 방법 설정 및 시작
# DB2 통신방법 설정 및 DB2 시작
su - db2inst1
db2set DB2COMM=TCPIP
db2set DB2CODEPAGE=970
db2start
[db2inst1@db2 ~]$ db2set DB2COMM=TCPIP
[db2inst1@db2 ~]$ db2set DB2CODEPAGE=970
[db2inst1@db2 ~]$ db2start
03/04/2025 13:41:46 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
# 방화벽 오픈
root > iptables -I OUTPUT 1 -p tcp --dport 50000 -j ACCEPT
[root:/root]> systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2025-03-04 12:40:24 KST; 3h 47min ago
Docs: man:firewalld(1)
Main PID: 778 (firewalld)
Tasks: 2
CGroup: /system.slice/firewalld.service
└─778 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid
Mar 04 12:40:23 db2.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...
Mar 04 12:40:24 db2.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
Mar 04 12:40:24 db2.localdomain firewalld[778]: WARNING: AllowZoneDrifting is enabled. This is considered an insecu... now.
Hint: Some lines were ellipsized, use -l to show in full.
[root:/root]> systemctl stop firewalld
[root:/root]> systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
# 상태 확인
cd /opt/ibm/db2/V11.5/install
./db2ls -a -q
[db2inst1:/opt/ibm/db2/V11.5/install]> ./db2ls -a -q
Install Path : /opt/ibm/db2/V11.5
Feature Response File ID Level Fix Pack Feature Description
---------------------------------------------------------------------------------------------------------------------
BASE_CLIENT_R 11.5.7.0 0 Base Client Support for installation with root privileges
DB2_PRODUCT_MESSAGES_EN 11.5.7.0 0 Product Messages - English
BASE_CLIENT 11.5.7.0 0 Base client support
JAVA_RUNTIME_SUPPORT 11.5.7.0 0 Java Runtime Support
DB2_JAVA_HELP_EN 11.5.7.0 0 Java Help (HTML) - English
BASE_DB2_ENGINE_R 11.5.7.0 0 Base server support for installation with root privileges
GSK 11.5.7.0 0 Global Secure ToolKit
JAVA_SUPPORT 11.5.7.0 0 Java support
SQL_PROCEDURES 11.5.7.0 0 SQL procedures
ICU_SUP 11.5.7.0 0 ICU Utilities
JAVA_COMMON_FILES 11.5.7.0 0 Java Common files
BASE_DB2_ENGINE 11.5.7.0 0 Base server support
RELATIONAL_WRAPPERS_COMMON 11.5.7.0 0 Relational wrappers common
DB2_DATA_SOURCE_SUPPORT 11.5.7.0 0 DB2 data source support
ODBC_DATA_SOURCE_SUPPORT 11.5.7.0 0 ODBC data source support
TERADATA_DATA_SOURCE_SUPPORT 11.5.7.0 0 Teradata data source support
SPATIAL_EXTENDER_SERVER_SUPPORT 11.5.7.0 0 Spatial Extender server support
IINR_SCIENTIFIC_WRAPPER 11.5.7.0 0 Scientific Data Sources
JDBC_DATA_SOURCE_SUPPORT 11.5.7.0 0 JDBC data source support
JDK 11.5.7.0 0 IBM Software Development Kit (SDK) for Java(TM)
LDAP_EXPLOITATION 11.5.7.0 0 DB2 LDAP support
INSTANCE_SETUP_SUPPORT 11.5.7.0 0 DB2 Instance Setup wizard
IINR_STRUCTURED_FILES_WRAPPER 11.5.7.0 0 Structured file data sources
ACS 11.5.7.0 0 Integrated Flash Copy Support
ORACLE_DATA_SOURCE_SUPPORT 11.5.7.0 0 Oracle data source support
CONNECT_SUPPORT 11.5.7.0 0 Connect support
IINR_APPLICATIONS_WRAPPER 11.5.7.0 0 Application data sources
SPATIAL_EXTENDER_CLIENT_SUPPORT 11.5.7.0 0 Spatial Extender client
SQL_SERVER_DATA_SOURCE_SUPPORT 11.5.7.0 0 SQL Server data source support
COMMUNICATION_SUPPORT_TCPIP 11.5.7.0 0 Communication support - TCP/IP
APPLICATION_DEVELOPMENT_TOOLS 11.5.7.0 0 Base application development tools
DATABASE_PARTITIONING_SUPPORT 11.5.7.0 0 Parallel Extension
EDB 11.5.7.0 0 EnterpriseDB code
REPL_CLIENT 11.5.7.0 0 Replication tools
DB2_SAMPLE_DATABASE 11.5.7.0 0 Sample database source
ITLM 11.5.7.0 0 itlm
TEXT_SEARCH 11.5.7.0 0 DB2 Text Search
CLPPLUS 11.5.7.0 0 Command Line Processor Plus
SYBASE_DATA_SOURCE_SUPPORT 11.5.7.0 0 Sybase data source support
INFORMIX_DATA_SOURCE_SUPPORT 11.5.7.0 0 Informix data source support
FED_DATA_SOURCE_SUPPORT 11.5.7.0 0 Federated Data Access Support
FIRST_STEPS 11.5.7.0 0 First Steps
ESE_PRODUCT_SIGNATURE 11.5.7.0 0 Product Signature for DB2 Server Edition
GUARDIUM_INST_MNGR_CLIENT 11.5.7.0 0 Guardium Installation Manager Client
6. DB, TBS, User 생성 예시
# DB 생성
db2 +p -tv << !
CREATE DATABASE SRCDB
AUTOMATIC STORAGE YES
USING CODESET UTF-8 TERRITORY DEFAULT
COLLATE USING SYSTEM PAGESIZE 32768;
!
CREATE DATABASE SRCDB AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY DEFAULT COLLATE USING SYSTEM PAGESIZE 32768
DB20000I The CREATE DATABASE command completed successfully.
useradd -g db2iadm1 -m -d /home/dbmgr dbmgr
db2 connect to srcdb user dbmgr using welcome1
db2 grant connect on database to user dbmgr
db2 grant dbadm on database to user dbmgr
db2 GRANT DBADM, CREATETAB, BINDADD, CONNECT, CREATE_NOT_FENCED, IMPLICIT_SCHEMA, LOAD ON DATABASE TO USER dbmgr
[db2inst1:/opt/db2inst1]> db2 grant dbadm on database to user dbmgr
DB20000I The SQL command completed successfully.
[db2inst1:/opt/db2inst1]> db2 grant connect on database to user dbmgr
DB20000I The SQL command completed successfully.
[db2inst1:/opt/db2inst1]> db2 GRANT DBADM, CREATETAB, BINDADD, CONNECT, CREATE_NOT_FENCED, IMPLICIT_SCHEMA, LOAD ON DATABASE TO USER dbmgr
DB20000I The SQL command completed successfully.
# DB 생성 확인
cd /opt/db2inst1/db2inst1/NODE0000
[db2inst1:/opt/db2inst1/db2inst1/NODE0000]> ls -altr
total 0
drwxrwxr-x. 3 db2inst1 db2iadm1 22 Mar 4 13:45 ..
drwxrwxr-x. 2 db2inst1 db2iadm1 54 Mar 4 13:45 sqldbdir
drwxr-x---. 5 db2inst1 db2iadm1 226 Mar 4 13:45 SQL00001
drwxrwxr-x. 5 db2inst1 db2iadm1 51 Mar 4 13:45 .
drwx--x--x. 5 db2inst1 db2iadm1 73 Mar 4 13:49 SRCDB
# DB2 실행
db2
[db2inst1:/opt/db2inst1/db2inst1/NODE0000]> db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 11.5.7.0
You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd
For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.
To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
For more detailed help, refer to the Online Reference Manual.
db2 =>
connect to SRCDB
db2 => connect to SRCDB
Database Connection Information
Database server = DB2/LINUXX8664 11.5.7.0
SQL authorization ID = DB2INST1
Local database alias = SRCDB
db2 => get connection state
Database Connection State
Connection state = Connectable and Connected
Connection mode = SHARE
Local database alias = SRCDB
Database name = SRCDB
Hostname =
Service name =
db2 => get db cfg for SRCDB
Database Configuration for Database SRCDB
Database configuration release level = 0x1500
Database release level = 0x1500
Update to database level pending = NO (0x0)
Database territory = DEFAULT
Database code page = 1208
Database code set = UTF-8
Database country/region code = 61
Database collating sequence = IDENTITY
Alternate collating sequence (ALT_COLLATE) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Date compatibility = OFF
Database page size = 32768
Statement concentrator (STMT_CONC) = OFF
Discovery support for this database (DISCOVER_DB) = ENABLE
Restrict access = NO
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20
Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN
DECIMAL arithmetic mode (DEC_ARITHMETIC) =
Large aggregation (LARGE_AGGREGATION) = NO
Backup pending = NO
All committed transactions have been written to disk = NO
Rollforward pending = NO
Restore pending = NO
Upgrade pending = NO
Multi-page file allocation enabled = YES
Log retain for recovery status = NO
User exit for logging status = NO
Self tuning memory (SELF_TUNING_MEM) = ON
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(759306)
Database memory threshold (DB_MEM_THRESH) = 100
Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC(15360)
Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC(98)
Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC(3799)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(43527)
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(2176)
Database heap (4KB) (DBHEAP) = AUTOMATIC(4852)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = 300
Log buffer size (4KB) (LOGBUFSZ) = 2150
Utilities heap size (4KB) (UTIL_HEAP_SZ) = AUTOMATIC(41263)
SQL statement heap (4KB) (STMTHEAP) = AUTOMATIC(8192)
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(256)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(40000)
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1
Changed pages threshold (CHNGPGS_THRESH) = 80
Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(2)
Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(3)
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC
Track modified pages (TRACKMOD) = NO
Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32
Max number of active applications (MAXAPPLS) = AUTOMATIC(40)
Average number of active applications (AVG_APPLS) = AUTOMATIC(1)
Lifetime of cached credentials (AUTHN_CACHE_DURATION) = 3
Max number of users in the cache (AUTHN_CACHE_USERS) = 0
Max DB files open per database (MAXFILOP) = 61440
Active log space disk capacity (MB) (LOG_DISK_CAP) = 0
Log file size (4KB) (LOGFILSIZ) = 1024
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 12
Changed path to log files (NEWLOGPATH) =
Path to log files = /opt/db2inst1/db2inst1/NODE0000/SQL00001/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
Mirror log path (MIRRORLOGPATH) =
First active log file =
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0
Percent log file reclaimed before soft chckpt (SOFTMAX) = 0
Target for oldest page in LBP (PAGE_AGE_TRGT_MCR) = 240
HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) =
HADR remote host name (HADR_REMOTE_HOST) =
HADR remote service name (HADR_REMOTE_SVC) =
HADR instance name of remote server (HADR_REMOTE_INST) =
HADR timeout value (HADR_TIMEOUT) = 120
HADR target list (HADR_TARGET_LIST) =
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR spool log data limit (4KB) (HADR_SPOOL_LIMIT) = AUTOMATIC(0)
HADR log replay delay (seconds) (HADR_REPLAY_DELAY) = 0
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
First log archive method (LOGARCHMETH1) = OFF
Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =
Auto restart enabled (AUTORESTART) = ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = OFF
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days) (REC_HIS_RETENTN) = 90
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF
TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =
Automatic maintenance (AUTO_MAINT) = ON
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = ON
Automatic runstats (AUTO_RUNSTATS) = ON
Real-time statistics (AUTO_STMT_STATS) = ON
Statistical views (AUTO_STATS_VIEWS) = OFF
Automatic sampling (AUTO_SAMPLING) = ON
Automatic column group statistics (AUTO_CG_STATS) = OFF
Automatic reorganization (AUTO_REORG) = OFF
Auto-Revalidation (AUTO_REVAL) = DEFERRED
Currently Committed (CUR_COMMIT) = ON
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = NEW
Enable XML Character operations (ENABLE_XMLCHAR) = YES
Enforce Constraint (DDL_CONSTRAINT_DEF) = YES
Enable row compression by default (DDL_COMPRESSION_DEF) = NO
Replication site ID (REPL_SITE_ID) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = BASE
Activity metrics (MON_ACT_METRICS) = BASE
Object metrics (MON_OBJ_METRICS) = EXTENDED
Routine data (MON_RTN_DATA) = NONE
Routine executable list (MON_RTN_EXECLIST) = OFF
Unit of work events (MON_UOW_DATA) = NONE
UOW events with package list (MON_UOW_PKGLIST) = OFF
UOW events with executable list (MON_UOW_EXECLIST) = OFF
Lock timeout events (MON_LOCKTIMEOUT) = NONE
Deadlock events (MON_DEADLOCK) = WITHOUT_HIST
Lock wait events (MON_LOCKWAIT) = NONE
Lock wait event threshold (MON_LW_THRESH) = 5000000
Number of package list entries (MON_PKGLIST_SZ) = 32
Lock event notification level (MON_LCK_MSG_LVL) = 1
SMTP Server (SMTP_SERVER) =
SQL conditional compilation flags (SQL_CCFLAGS) =
Section actuals setting (SECTION_ACTUALS) = NONE
Connect procedure (CONNECT_PROC) =
Adjust temporal SYSTEM_TIME period (SYSTIME_PERIOD_ADJ) = NO
Log DDL Statements (LOG_DDL_STMTS) = NO
Log Application Information (LOG_APPL_INFO) = NO
Default data capture on new Schemas (DFT_SCHEMAS_DCC) = NO
Strict I/O for EXTBL_LOCATION (EXTBL_STRICT_IO) = NO
Allowed paths for external tables (EXTBL_LOCATION) = /opt/db2inst1
Default table organization (DFT_TABLE_ORG) = ROW
Default string units (STRING_UNITS) = SYSTEM
National character string mapping (NCHAR_MAPPING) = CHAR_CU32
Database is in write suspend state = NO
Extended row size support (EXTENDED_ROW_SZ) = ENABLE
Encryption Library for Backup (ENCRLIB) =
Encryption Options for Backup (ENCROPTS) =
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Target agent load per CPU core (WLM_AGENT_LOAD_TRGT) = AUTOMATIC(12)
WLM admission control enabled (WLM_ADMISSION_CTRL) = NO
Allocated share of CPU resources (WLM_CPU_SHARES) = 1000
CPU share behavior (hard/soft) (WLM_CPU_SHARE_MODE) = HARD
Maximum allowable CPU utilization (%) (WLM_CPU_LIMIT) = 0
Activity Sort Memory Limit (ACT_SORTMEM_LIMIT) = NONE
Control file recovery path (CTRL_FILE_RECOV_PATH) =
Encrypted database = NO
Procedural language stack trace (PL_STACK_TRACE) = NONE
HADR SSL certificate label (HADR_SSL_LABEL) =
HADR SSL Hostname Validation (HADR_SSL_HOST_VAL) = OFF
BUFFPAGE size to be used by optimizer (OPT_BUFFPAGE) = 0
LOCKLIST size to be used by optimizer (OPT_LOCKLIST) = 0
MAXLOCKS size to be used by optimizer (OPT_MAXLOCKS) = 0
SORTHEAP size to be used by optimizer (OPT_SORTHEAP) = 0
db2 => LIST TABLES
Table/View Schema Type Creation time
------------------------------- --------------- ----- --------------------------
0 record(s) selected.
# 버퍼 풀 생성
CREATE BUFFERPOOL USERSBP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL INDXBP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL BLOBBP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL TEMPUSRBP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL TEMPSYSBP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL TEMPUSRBP32 SIZE AUTOMATIC PAGESIZE 32K;
CREATE BUFFERPOOL TEMPSYSBP32 SIZE AUTOMATIC PAGESIZE 32K;
CREATE BUFFERPOOL XML_DATA_BP SIZE AUTOMATIC PAGESIZE 32K;
CREATE BUFFERPOOL XML_LARGE_BP SIZE AUTOMATIC PAGESIZE 32K;
CREATE BUFFERPOOL XML_INDX_BP SIZE AUTOMATIC PAGESIZE 32K;
CREATE BUFFERPOOL ITA_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL ITA_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL ITD_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL ITD_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL ITM_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL ITM_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL ICM_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL ICM_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL LCK_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
CREATE BUFFERPOOL LCK_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
# tbs 생성
CREATE LARGE TABLESPACE ITA_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ITA_DATA_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 => CREATE LARGE TABLESPACE ITA_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ITA_DATA_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
DB20000I The SQL command completed successfully.
# 임시 tbs
CREATE USER TEMPORARY TABLESPACE TEMP_USER PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL TEMPUSRBP;
CREATE USER DBMGR IDENTIFIED BY welcome1 DEFAULT TABLESPACE ITA_DATA ;
7. 샘플 DB 생성
db2set DB2_COMPATIBILITY_VECTOR=ORA
[db2inst1:/opt/ibm/db2/V11.5/install]> db2sampl
Creating database "SAMPLE"...
Connecting to database "SAMPLE"...
Creating tables and data in schema "DB2INST1"...
Creating tables with XML columns and XML data in schema "DB2INST1"...
'db2sampl' processing complete.
[db2inst1:/opt/ibm/db2/V11.5/install]> db2 connect to sample user db2inst1 using welcome1
Database Connection Information
Database server = DB2/LINUXX8664 11.5.7.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
[db2inst1:/opt/ibm/db2/V11.5/install]> db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 11.5.7.0
You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd
For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.
To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
For more detailed help, refer to the Online Reference Manual.
db2 => connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 11.5.7.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
db2 => list tables
Table/View Schema Type Creation time
------------------------------- --------------- ----- --------------------------
ACT DB2INST1 T 2025-03-04-17.20.26.294266
ADEFUSR DB2INST1 S 2025-03-04-17.20.34.159343
CATALOG DB2INST1 T 2025-03-04-17.20.47.761514
CL_SCHED DB2INST1 T 2025-03-04-17.20.17.981916
CUSTOMER DB2INST1 T 2025-03-04-17.20.45.401501
DEPARTMENT DB2INST1 T 2025-03-04-17.20.18.544555
DEPT DB2INST1 A 2025-03-04-17.20.20.827084
EMP DB2INST1 A 2025-03-04-17.20.21.902276
EMPACT DB2INST1 A 2025-03-04-17.20.26.291810
EMPLOYEE DB2INST1 T 2025-03-04-17.20.20.830251
EMPMDC DB2INST1 T 2025-03-04-17.20.35.702336
EMPPROJACT DB2INST1 T 2025-03-04-17.20.25.972896
EMP_ACT DB2INST1 A 2025-03-04-17.20.26.293231
EMP_PHOTO DB2INST1 T 2025-03-04-17.20.21.905244
EMP_RESUME DB2INST1 T 2025-03-04-17.20.23.193228
INVENTORY DB2INST1 T 2025-03-04-17.20.44.440118
IN_TRAY DB2INST1 T 2025-03-04-17.20.27.005843
ORG DB2INST1 T 2025-03-04-17.20.27.306456
PRODUCT DB2INST1 T 2025-03-04-17.20.42.131450
PRODUCTSUPPLIER DB2INST1 T 2025-03-04-17.20.49.915300
PROJ DB2INST1 A 2025-03-04-17.20.25.320661
PROJACT DB2INST1 T 2025-03-04-17.20.25.322738
PROJECT DB2INST1 T 2025-03-04-17.20.24.449825
PURCHASEORDER DB2INST1 T 2025-03-04-17.20.46.552810
SALES DB2INST1 T 2025-03-04-17.20.27.915768
STAFF DB2INST1 T 2025-03-04-17.20.27.612989
STAFFG DB2INST1 T 2025-03-04-17.20.32.895874
SUPPLIERS DB2INST1 T 2025-03-04-17.20.48.882892
VACT DB2INST1 V 2025-03-04-17.20.28.410055
VASTRDE1 DB2INST1 V 2025-03-04-17.20.28.541098
VASTRDE2 DB2INST1 V 2025-03-04-17.20.28.566740
VDEPMG1 DB2INST1 V 2025-03-04-17.20.28.483566
VDEPT DB2INST1 V 2025-03-04-17.20.28.238354
VEMP DB2INST1 V 2025-03-04-17.20.28.363848
VEMPDPT1 DB2INST1 V 2025-03-04-17.20.28.512475
VEMPLP DB2INST1 V 2025-03-04-17.20.28.796236
VEMPPROJACT DB2INST1 V 2025-03-04-17.20.28.457144
VFORPLA DB2INST1 V 2025-03-04-17.20.28.672176
VHDEPT DB2INST1 V 2025-03-04-17.20.28.346104
VPHONE DB2INST1 V 2025-03-04-17.20.28.767267
VPROJ DB2INST1 V 2025-03-04-17.20.28.386954
VPROJACT DB2INST1 V 2025-03-04-17.20.28.427312
VPROJRE1 DB2INST1 V 2025-03-04-17.20.28.587428
VPSTRDE1 DB2INST1 V 2025-03-04-17.20.28.617645
VPSTRDE2 DB2INST1 V 2025-03-04-17.20.28.651338
VSTAFAC1 DB2INST1 V 2025-03-04-17.20.28.703871
VSTAFAC2 DB2INST1 V 2025-03-04-17.20.28.740261
47 record(s) selected.
connect to sample user db2inst1 using welcome1
db2 => oracle 이관테스트할려구 샘플디비만 설치해보았다
디비버에서 접속은
이러케 했는데
노트북에 5만번 포트가 안뚫려있어서
인바운드 규칙에 임시포트 5만번 뚫었더니 됐다
끝~
'ETC > 도전' 카테고리의 다른 글
| Linux 64bit | Oracle database 19c Gateway for DRDA 설치 (DB2<-> ORACLE DBLINK 연결) (0) | 2025.03.20 |
|---|---|
| [Kafka] Mysql -> Oracle Apache Spark 통해 Data 이관 (0) | 2024.02.05 |
| [ORACLE] CRS-6705 | 업그레이드 시 grid Software 버전이 active 버전과 다른 오류 (0) | 2023.03.24 |
| 아크로니스 Cyber Protect Home Office 사용기 2 (복구.. 실패 .. ^^) (0) | 2023.02.28 |
| 아크로니스 Cyber Protect Home Office 사용기 (0) | 2022.11.30 |
