DataBase | 溫室小花.技術.博客

Posted on 18 9 月, 202128 9 月, 2021 by Evan

db2與oracle的全面對比6

db2star2 真正的 db2start 程序。所有 db2stop 停止 DB2 引擎的用戶命令。所有
Continue reading db2與oracle的全面對比6

Posted on 16 9 月, 202128 9 月, 2021 by Evan

ETL DataStage實現V15

與DB2相關的Stage在Parallel Job中也有三個: DB2/UDB Enterprise, DB2
Continue reading ETL DataStage實現V15

Posted on 10 9 月, 202113 9 月, 2021 by Evan

db2與oracle的全面對比5

db2event 事件監視器進程。每個活動的事件監視器，每個活動的數據庫就會有一個 db2event 進程。這
Continue reading db2與oracle的全面對比5

Posted on 8 9 月, 202113 9 月, 2021 by Evan

ETL DataStage實現V14

and parallel oriented functions. 7) DataStage server ex
Continue reading ETL DataStage實現V14

Posted on 2 9 月, 20211 9 月, 2021 by Evan

ETL DataStage實現V13

數據合併，相當於數據庫中的merge 行列轉換，需要將某些數據轉換成行，或者是將行轉換成列參照完整性檢查，對
Continue reading ETL DataStage實現V13

Posted on 16 8 月, 202122 8 月, 2021 by Evan

ETL DataStage實現V12

3、添加、刪除、修改JOB的調度，對，這裡就是大名鼎鼎的調度，可以在這裡實現，可以按照不同時間調度。對了，本人
Continue reading ETL DataStage實現V12

Posted on 8 8 月, 202122 8 月, 2021 by Evan

DB2 pureScale 軟件安裝配置及常見問題解決5

圖 17. 高可用性及負載均衡 -5 故障服務器 p5502 恢復後，我們觀察 WAS 應用，沒有出現報錯的情
Continue reading DB2 pureScale 軟件安裝配置及常見問題解決5

Posted on 6 8 月, 20217 8 月, 2021 by Evan

ETL DataStage實現V11

ETL DataStage實現前言自開始知道數據庫，就知道有數據倉庫這個東西，數據倉庫中一關鍵環節就是ET
Continue reading ETL DataStage實現V11

Posted on 4 8 月, 20217 8 月, 2021 by Evan

DB2 pureScale 軟件安裝配置及常見問題解決4

172.16.24.122 p5502 172.16.24.123 p5503 然後，我們需要配置客戶端 db
Continue reading DB2 pureScale 軟件安裝配置及常見問題解決4

Posted on 20 7 月, 202128 7 月, 2021 by Evan

DB2 pureScale 軟件安裝配置及常見問題解決3

如上問題是由於在目標服務器上已經安裝了 pureScale 軟件，為避免版本差異導致問題，我們需要手工卸載目標
Continue reading DB2 pureScale 軟件安裝配置及常見問題解決3

Posted on 18 7 月, 202128 7 月, 2021 by Evan

Configuring XA Transaction Managers to Use DB2 UDB5

COM2 is invoked in the same transaction, a separate con
Continue reading Configuring XA Transaction Managers to Use DB2 UDB5

Posted on 12 7 月, 202118 7 月, 2021 by Evan

DB2 pureScale 軟件安裝配置及常見問題解決2

172.16.24.121 p5501 172.16.24.122 p5502 172.16.24.123 p
Continue reading DB2 pureScale 軟件安裝配置及常見問題解決2

Posted on 10 7 月, 202118 7 月, 2021 by Evan

DB2 pureScale 軟件安裝配置及常見問題解決1

DB2 pureScale 軟件安裝配置及常見問題解決硬件環境要求 DB2 pureScale 採用了和業界
Continue reading DB2 pureScale 軟件安裝配置及常見問題解決1

Posted on 8 7 月, 202122 8 月, 2021 by Evan

Configuring XA Transaction Managers to Use DB2 UDB4

The following servers are supported for multi-site upda
Continue reading Configuring XA Transaction Managers to Use DB2 UDB4

Posted on 7 7 月, 202112 7 月, 2021 by Evan

Configuring XA Transaction Managers to Use DB2 UDB3

o ${TUXDIR}/bin/buildserver -r UDB_XA -f svcfile.o
Continue reading Configuring XA Transaction Managers to Use DB2 UDB3

Posted on 4 7 月, 20216 7 月, 2021 by Evan

Configuring XA Transaction Managers to Use DB2 UDB2

1. Use the Encina Scheduling Policy API to specify h
Continue reading Configuring XA Transaction Managers to Use DB2 UDB2

Posted on 2 7 月, 20213 7 月, 2021 by Evan

DB2 HADR 監控詳解2

心跳丟失數量（HeartBeatMissed）：主機會不斷地向備機發送心跳，以確認仍然可以和對方通信。這個值表
Continue reading DB2 HADR 監控詳解2

Posted on 1 7 月, 20213 7 月, 2021 by Evan

DB2 HADR 監控詳解1

HADR 簡介 HADR( 高可用性災難恢復 ) 是 DB2 數據庫的一個組件，是 DB2 提供給用戶的一種高
Continue reading DB2 HADR 監控詳解1

Posted on 26 6 月, 202127 6 月, 2021 by Evan

MySQL5.6 數據庫主從同步安裝與配置詳解（Master/Slave）03

在主庫中新增數據庫表，user，觀察從庫變化如下：創建數據庫的時候：新增數據的時候：刪除Mast
Continue reading MySQL5.6 數據庫主從同步安裝與配置詳解（Master/Slave）03

Posted on 22 6 月, 202125 6 月, 2021 by Evan

MySQL5.6 數據庫主從同步安裝與配置詳解（Master/Slave）02

此時，查看數據庫的報錯信息（數據庫的目錄, /data/mysqldb/VM_128_194_centos
Continue reading MySQL5.6 數據庫主從同步安裝與配置詳解（Master/Slave）02

Posted on 20 6 月, 202125 6 月, 2021 by Evan

MySQL5.6 數據庫主從同步安裝與配置詳解（Master/Slave）01

MySQL5.6 數據庫主從同步安裝與配置詳解（Master/Slave）本篇文章主要介紹了MyS
Continue reading MySQL5.6 數據庫主從同步安裝與配置詳解（Master/Slave）01

Posted on 18 6 月, 202119 6 月, 2021 by Evan

Configuring XA Transaction Managers to Use DB2 UDB1

Administration Guide Configuring XA Transaction Man
Continue reading Configuring XA Transaction Managers to Use DB2 UDB1

Posted on 28 5 月, 202130 5 月, 2021 by Evan

Centos6.8下Oracle12C超詳細安裝8

[18] After completing to create a database, Click &#822
Continue reading Centos6.8下Oracle12C超詳細安裝8

Posted on 8 5 月, 202111 5 月, 2021 by Evan

CICS + Linux + Oracle 環境搭建4

CICS + Linux + Oracle 環境搭建 oracle1pc.c:521: warning: in
Continue reading CICS + Linux + Oracle 環境搭建4

Posted on 6 5 月, 202111 5 月, 2021 by Evan

Centos6.8下Oracle12C超詳細安裝6

[7] Set passwords. Please set a password for a user for
Continue reading Centos6.8下Oracle12C超詳細安裝6

Posted on 2 5 月, 20215 5 月, 2021 by Evan

CICS + Linux + Oracle 環境搭建3

CICS + Linux + Oracle 環境搭建 -r–r–r– 1
Continue reading CICS + Linux + Oracle 環境搭建3

Posted on 1 5 月, 20215 5 月, 2021 by Evan

Centos6.8下Oracle12C超詳細安裝5

[9] Click “Finish” to quit. After finishing
Continue reading Centos6.8下Oracle12C超詳細安裝5

Posted on 22 4 月, 202125 4 月, 2021 by Evan

Centos6.8下Oracle12C超詳細安裝4

Copying dbhome to /usr/local/bin … Copying oraenv
Continue reading Centos6.8下Oracle12C超詳細安裝4