step-by-step guide on configuring db2 hadr replication

Source: 192.168.91.59 Destination: 192.168.91.11 DB name: CMSDB DB2 version: 9.7.0.7 # as db2inst1 on primary, make sure LOGARCHMETH1 is set db2 get db cfg for cmsdb | grep LOGARCHMETH1 # Setting up HADR cfg parameters on Primary database. db2 update db cfg for CMSDB using HADR_LOCAL_HOST 192.168.91.59 db2 update db cfg for CMSDB using HADR_LOCAL_SVC… Continue reading step-by-step guide on configuring db2 hadr replication

Used undo block count is zero

When querying v$transaction, we can occasionally find that both UBAFIL and UBABLK are 0 for one particular transaction. Normally this would mean that the transaction need no undo information. Here is one test case to reproduce the issue. SQL> drop table t1 purge; Table dropped. SQL> create table t1(a int); Table created. SQL> savepoint a; Savepoint created.… Continue reading Used undo block count is zero

Useful resources about Table function

http://joze-senegacnik.blogspot.jp/2009/11/recently-i-was-involved-in-discussion.html Table Expressions, Cardinality, SYS_OP_ATG and KOKBF$ https://oracle-base.com/articles/misc/pipelined-table-functions Oracle Pipelined Table Functions http://stevenfeuersteinonplsql.blogspot.jp/2015/04/table-functions-introduction-and.html Table Functions, Part 1: Introduction and Exploration

Resolving Apply ASN1001E in DB2 SQL Replication

Error Message in Apply: 2016-09-08-10.51.37.843021 ASN1001E APPLY “YHDBSUB0” : “WorkerThread”. The Apply program encountered an SQL error. The ERRCODE is “B20101”. The SQLSTATE is “42601”. The SQLCODE is “-104”. The SQLERRM is “WHERE?BEGIN-OF-STATEMENT?<variable_set>”. The SQLERRP is “SQLNP01F”. The server name is “”. The table name is “CAS.FX_ACCNT_SERIAL_JPY”. Usually this error is seen if you have… Continue reading Resolving Apply ASN1001E in DB2 SQL Replication

Using RMAN Incremental Backups to Roll Forward a Physical Standby Database

We can use rman incremental backup to roll forward physical standby database. Nevertheless, there is one particular step which we might pay attention to. In general, physical standby database would have different datafile paths. Things could be even more complex when you are using OMF. The doc only states that we can manually edit the file… Continue reading Using RMAN Incremental Backups to Roll Forward a Physical Standby Database