紀錄工作上的點點滴滴

Install DB2 9.7 in CentOS6

2024-11-13 DB2 db2

install-DB2-9.7-in-CentOS6 yum install -y libaio ksh rsh-server pam-devel nfs-utils compat-libstdc++-33 libstdc++.i686 pam-devel.i686 ... Read More

Install DB2 9.7 in CentOS7

2024-11-13 DB2 db2

安裝順序 scp ./v9.7fp7_linuxx64_server.tar.gz [email protected]:/tmp/ # 創建需要的目錄 mkdir -p /db2 mkdir /source # 複製安裝包到映像內 mv ... Read More

DB2 Audit Rc Table

2024-07-12 DB2 db2

db2diag -l Warning | db2diag -g "comp^=bsu security" DB2 稽核 失敗 rc 對照表 # rc Corresponding SQL30082N rc Explanation 1 -2146500508 1 Password has ... Read More

Restoring DB2 Database

2024-06-26 DB2 DB2

還原 Online Backup db2 terminate db2 deactivate db TEMADB db2 restore database TEMADB from <location> taken at <timestamp> replace existing ... Read More

DB2 維護相關 SQL

2024-05-13 DB2 db2

查詢目前資料庫哪些帳號 SELECT * FROM SYSIBM.SYSDBAUTH GRANTOR |GRANTEE ... Read More

DB2 切 db2diag.log

2024-03-25 DB2

今天在工作時碰到 db2diag.log 膨脹到把硬碟塞滿，在這邊分享一下處理過程 db2diag -A 可以很放心去執行，執行過程中不會對現形資料庫運作產生任何影響 操作資料庫環境 OS: RedHat 6 DB2 Version: 9.7 ... Read More