search
HomeDatabaseMysql TutorialDB2日志(2) 用C语言扩展实现DB2日志管理及主备同步

还好DB2提供了相关的USEREXIT程序(又名用户出口程序)可以使我们管理日志文件并有了扩展功能的可能性.在这一点上DB2明显要比Orac

还好DB2提供了相关的USEREXIT程序(又名用户出口程序)可以使我们管理日志文件并有了扩展功能的可能性.在这一点上DB2明显要比Oracle开放些.


实现
1.首先将USEREXIT接口打开,让数据库支持USEREXIT程序
--查看当前状态(Windows环境下)
db2 get db cfg for XCLDB2 |find /I "userexit"
--打开userexit
db2 update db cfg for XCLDB2 using userexit on
--查看当前状态(Windows环境下)
db2 get db cfg for XCLDB2 |find /I "userexit"

2. 去DB2安装目录下找到例子程序
Unix下: sqllib/samples/c
Windows下: C:\Program Files\IBM\SQLLIB\samples\c

例子文件:
Db2uext2.cadsm — 对 Tivoli Storage Manager 的支持,也称为 ADSM
Db2uext2.cdisk — 对磁盘的支持
Db2uext2.ctape — 对本地磁带的支持,仅可用于 UNIX 系统

Db2uext2.cxbsa — 对 XBSA Draft 0.8 客户机的支持
这些样本程序中的每个都只需要稍作修改(如 buffer_size 、 audit_log_activation 、 audit_log_path 、 error_log_activation 和 error_log_path )
除了上面这些,还可以用db2uext2.ctsm来实现.它是新的替代版.

3.以Windows环境为例演示如何编译扩展.
3.1 用Visual Studio新建一个属性为空项目的控制台应用程序工程.注意,工程名为"Db2uext2",
工程目录为"c:\DB2C"
3.2 将 Db2uext2.cdisk 复制到 C:\DB2C\db2uext2 目录下,将其更名为Db2uext2.c.
然后在Visual Studio工程中将文件导入.
导入成功后打开文件. 查找并替换 "c:\\mylogs\\" 为自己所要的目录如 "c:\\xcllogs\\"

其实主要是更改的这几个参数,具体含义在C程序的代码注释中很详细:
#define ARCHIVE_PATH "c:\\xcllogs\\"
#define RETRIEVE_PATH "c:\\xcllogs\\"
#define AUDIT_ACTIVE 1 /* enable audit trail logging */
#define ERROR_ACTIVE 1 /* enable error trail logging */
#define AUDIT_ERROR_PATH "c:\\xcllogs\\" /* path must end with a slash */
#define AUDIT_ERROR_ATTR "a" /* append to text file */
#define BUFFER_SIZE 32 /* # of 4K pages for output buffer */

3.3将编译好的Reselse版本的db2uext2.exe文件放在DB2管理程序能找到的目录下.
编译后的db2uext2.exe文件存放目录:
Windows下:
C:\Program Files\IBM\SQLLIB\BIN
Unix下:
/sqllib/adm
3.4 测试扩展程序是否生效
3.4.1 在DB2 CLP下手工强制归档一份日志

db2 archive log for db XCLDB2

 

3.4.2 应当可以在"C:\xcllogs\XCLDB2\NODE0000"目录下查到新产生的日志
C:\>tree C:\xcllogs
卷 WINXP 的文件夹 PATH 列表
卷序列号为 88F1-6579
C:\XCLLOGS
└─XCLDB2
└─NODE0000
c:\>dir C:\xcllogs\XCLDB2\NODE0000

上面举的是Windows下的,在Unix下时,一定要注意,需先mkdir目录并授权(如777),
并chown -R 目录给DB2的用户.


引申:
上面只是举了个最简单的例子,但如果把这个例子扩展下.甚至可以通过日志文件的同步
或异步复制到异机或远程存储来实现数据库的容灾.
简单的说一个主备数据库同步的实现方法 :
1. 首先在备份数据库服务器上,用主库的备份恢复出一个完整的DB2数据库.
这个备份服务器硬件什么的可以不一致,就是文件系统划分不一样时,需要用重定向恢复来生成备库.
2. 将备份服务器的活动日志目录,设为主库服务器有读写权限.
3. 参考上面的例子,实现一个扩展.用于将日志传一份至备份服务器的活动日志目录.
4. 在备份服务器上弄一个定时作业,定时前滚 "db2 rollforward to end of logs"

哈哈,这样两边就同步了.
这个扩展还可以加上自动定期整理日志的功能.也可以利用Db2uext2.ctape做些磁带库方面的扩展.
总之,看个人的创意了. ,
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How does MySQL's licensing compare to other database systems?How does MySQL's licensing compare to other database systems?Apr 25, 2025 am 12:26 AM

MySQL uses a GPL license. 1) The GPL license allows the free use, modification and distribution of MySQL, but the modified distribution must comply with GPL. 2) Commercial licenses can avoid public modifications and are suitable for commercial applications that require confidentiality.

When would you choose InnoDB over MyISAM, and vice versa?When would you choose InnoDB over MyISAM, and vice versa?Apr 25, 2025 am 12:22 AM

The situations when choosing InnoDB instead of MyISAM include: 1) transaction support, 2) high concurrency environment, 3) high data consistency; conversely, the situation when choosing MyISAM includes: 1) mainly read operations, 2) no transaction support is required. InnoDB is suitable for applications that require high data consistency and transaction processing, such as e-commerce platforms, while MyISAM is suitable for read-intensive and transaction-free applications such as blog systems.

Explain the purpose of foreign keys in MySQL.Explain the purpose of foreign keys in MySQL.Apr 25, 2025 am 12:17 AM

In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

What are the different types of indexes in MySQL?What are the different types of indexes in MySQL?Apr 25, 2025 am 12:12 AM

There are four main index types in MySQL: B-Tree index, hash index, full-text index and spatial index. 1.B-Tree index is suitable for range query, sorting and grouping, and is suitable for creation on the name column of the employees table. 2. Hash index is suitable for equivalent queries and is suitable for creation on the id column of the hash_table table of the MEMORY storage engine. 3. Full text index is used for text search, suitable for creation on the content column of the articles table. 4. Spatial index is used for geospatial query, suitable for creation on geom columns of locations table.

How do you create an index in MySQL?How do you create an index in MySQL?Apr 25, 2025 am 12:06 AM

TocreateanindexinMySQL,usetheCREATEINDEXstatement.1)Forasinglecolumn,use"CREATEINDEXidx_lastnameONemployees(lastname);"2)Foracompositeindex,use"CREATEINDEXidx_nameONemployees(lastname,firstname);"3)Forauniqueindex,use"CREATEU

How does MySQL differ from SQLite?How does MySQL differ from SQLite?Apr 24, 2025 am 12:12 AM

The main difference between MySQL and SQLite is the design concept and usage scenarios: 1. MySQL is suitable for large applications and enterprise-level solutions, supporting high performance and high concurrency; 2. SQLite is suitable for mobile applications and desktop software, lightweight and easy to embed.

What are indexes in MySQL, and how do they improve performance?What are indexes in MySQL, and how do they improve performance?Apr 24, 2025 am 12:09 AM

Indexes in MySQL are an ordered structure of one or more columns in a database table, used to speed up data retrieval. 1) Indexes improve query speed by reducing the amount of scanned data. 2) B-Tree index uses a balanced tree structure, which is suitable for range query and sorting. 3) Use CREATEINDEX statements to create indexes, such as CREATEINDEXidx_customer_idONorders(customer_id). 4) Composite indexes can optimize multi-column queries, such as CREATEINDEXidx_customer_orderONorders(customer_id,order_date). 5) Use EXPLAIN to analyze query plans and avoid

Explain how to use transactions in MySQL to ensure data consistency.Explain how to use transactions in MySQL to ensure data consistency.Apr 24, 2025 am 12:09 AM

Using transactions in MySQL ensures data consistency. 1) Start the transaction through STARTTRANSACTION, and then execute SQL operations and submit it with COMMIT or ROLLBACK. 2) Use SAVEPOINT to set a save point to allow partial rollback. 3) Performance optimization suggestions include shortening transaction time, avoiding large-scale queries and using isolation levels reasonably.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software