DB2 HADR+TSA在SAP系统的应用

April 26th, 2010 by admin No comments »

最近开始将DB2数据库从单纯的Hacmp的模式切换到HADR+TSA+HACMP模式。

原理感觉和Oracled的DG一样,但是功能还是偏弱,目前有一些限制的地方需要注意:

1.HADR is not supported in a partitioned database environment.
2.The primary and standby databases must have the same operating system version and the same version of the DB2 database system, except for a short time during a rolling upgrade.
3.The DB2 database system release on the primary and standby databases must be of the same bit size (32 or 64 bit).
4. Reads on the standby database are not supported. Clients cannot connect to the standby database.
5. Log archiving can only be performed by the current primary database.
6. You can use Self Tuning Memory Manager (STMM) only on the current primary database.
7. Backup operations are not supported on the standby database.
8. Non-logged operations, such as changes to database configuration parameters and to the recovery history file, are not replicated to the standby database.
9. Load operations with the COPY NO option specified are not supported.
10. HADR does not support the use of raw I/O (direct disk access) for database log files. If HADR is started via the START HADR command, or the database is activated(restarted) with HADR configured and raw logs are detected, the associated command will fail.

早春二月.云

March 25th, 2010 by admin 6 comments »

这组相片的主题,可以套用最近比较火的一部美国电影的名字<<Up the Air>>,找个蓝天,抬头看云….

» Read more: 早春二月.云

早春二月.芽

March 25th, 2010 by admin No comments »

似乎闻到春天的味道…

» Read more: 早春二月.芽

南锣鼓巷

March 23rd, 2010 by admin No comments »

逛南锣鼓巷的乐趣在于巷子两边很有特色的小小的店铺和双皮奶…

» Read more: 南锣鼓巷

恭王府.猫

March 23rd, 2010 by admin No comments »

某天下午实在无聊,带着相机跑到恭王府逛逛。王府当然很有范,金碧辉煌。但是令我觉得有点诡异的是,俺在王府后花园的一个僻静的地方竟然看到一只猫在晒太阳,呵呵。既然大家这么有缘,我也在它对面坐了下来,大家四目相对,惺惺相惜。过了一会,猫盯不住了,跑到假山里面躲了起来,偶尔探出头看看我。见它实在不想出来了,我也拍拍屁股走了。呵呵,真是无聊的下午。

» Read more: 恭王府.猫

DB2 CLI Migration

February 22nd, 2010 by admin No comments »

在 SAP 系统中,DB2 CLI Driver 被保存在共享目录中,它可以通过 NFS 共享被系统中的其他主机加载。

DB2 CLI更加易于维护。如可以将 DB2 CLI Driver 驻留在一个 NFS 文件系统中供多个系统共同使用,使多个应用在分布式环境中可以共享同一个 DB2 CLI Driver,从而降低了维护的成本。同时,当 DB2 CLI Driver 需要升级时,只需要升级一份 DB2 CLI Driver 即可。

最近陆陆续续完成了CLI Driver的迁移,感觉作为轻量级的客户端,在维护和部署都非常方便。

奇妙的移轴镜效果

February 17th, 2010 by admin 1 comment »

移轴镜效果就是类似那种小人国风格的相片。最近这种风格的图片和摄影效果在很多杂志和电视上面出现的比较多,很感兴趣。自己尝试PS了一下,蛮有意思的。

» Read more: 奇妙的移轴镜效果

邮票

February 15th, 2010 by admin 2 comments »

这次回家,终于看到小时候经常摆弄的邮册。虽然现在不集邮好久了,但是翻看已经发黄的邮册和里面一张张邮票,真的是感慨万千。当年集邮给我带来了莫大的乐趣。现在看来我好像还有一些精品:

开国一周年

» Read more: 邮票

珠海的花花草草-花市

February 11th, 2010 by admin 2 comments »

接着来..

» Read more: 珠海的花花草草-花市

珠海的花花草草-街拍

February 9th, 2010 by admin No comments »

过年了,放朵大红花这里,喜庆一下哈…

» Read more: 珠海的花花草草-街拍

8毫米咖啡吧的小物件

February 9th, 2010 by admin No comments »

» Read more: 8毫米咖啡吧的小物件

暴雨前的大海

February 9th, 2010 by admin 1 comment »

在暴雨前跑到海边逛,顺手拍的,真是黑云压城城欲摧啊…