About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
You may require to run asntdiff and asntrep utilities. If the Replication scenario is Update Anywhere, and the target data is constantly changing, you will need to take precautions, especially when running asntrep utility. You may also run into errors such as ASN4004E, SQL0805N, indicating the utility needs packages bound.
Cause
CREATE TABLE "SCHEMA"."DIFF_TABLENAME-" (
"DIFF " CHAR(4),
"MSG_ID" CHAR(12) FOR BIT DATA
) IN USERSPACE1 ;2006-01-27-21.41.44.282257 ASN4004E "AsnTDiff" : "SCHEMA" :
"Initial" : The program encountered an SQL error at line "2060". The function name is "asntdiff::xcopy". The SQLCODE is "-805". The SQLSTATE is "51002".
Answer
Before running asntdiff and asntrep utilities, please do the following:
- Make sure the applications are quiesced, and the activity is halted
- Make sure db2levels on source and target are the same
- Run bind on both source and target as follows:
- db2 bind asntdiff.bnd blocking all grant public
- db2 bind asntdapi.bnd blocking all grant public
If the tables are small and if the target data is constantly changing, then just run asntdiff and compare the rows and update the changes manually.
If the tables are large, run asntdiff and run asntrep.
Examples of asntdiff and asntrep:
asntdiff DB=Control DB SCHEMA=schema DIFF_SCHEMA=DIFF_TABLE schema DIFF=DIFF_TABLE DIFF_TABLESPACE=difftable-tablespace WHERE " TARGET_TABLE='TABLE' AND APPLY_QUAL = 'Apply qualifier' AND SET_NAME='SET name' AND WHOS_ON_FIRST = 'S' "
asntrep DB=Control DB SCHEMA=schema DIFF_SCHEMA=DIFF_TABLE schema DIFF=DIFF_TABLE DIFF_TABLESPACE=difftable-tablespace WHERE " TARGET_TABLE='TABLE' AND APPLY_QUAL = 'Apply qualifier' AND SET_NAME='SET name' AND WHOS_ON_FIRST = 'S' "
[{"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Misc","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"8.2;9.1","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
More support for:
InfoSphere Replication Server
Software version:
8.2, 9.1
Operating system(s):
AIX, Linux, Solaris, Windows
Document number:
346255
Modified date:
16 June 2018
UID
swg21229502