Apply Subscription (KUD_DB2_Apply_Subscription) attributes

The Apply Subscription attributes provide information about Apply Program subscription sets that are configured to run on a database manager server.

To collect Apply Program attributes successfully, the Apply Program must be configured. The DB2® agent must be located on the control server to collect Apply Program attributes. The control server is often the same as the target database server in an Apply subscription set.

Apply ID Subscriber user ID that started the Apply Program.

Apply Num Reqs Refresh Indicates the number of subscriptions the Apply Program failed to replicate because refresh copying was disabled. While attempting to perform a full refresh, the Apply Program encountered a DISABLE_REFRESH column in the register table, which was set to On. You can either turn off the DISABLE_REFRESH column or bypass the Apply Program and perform a manual refresh. The following value is valid:

External value	Internal value
Value_Exceeds_Maximum	9223372036854775807

Apply Num Reqs Refresh (Superseded) Indicates the number of subscriptions the Apply Program failed to replicate because refresh copying was disabled. While attempting to perform a full refresh, the Apply Program encountered a DISABLE_REFRESH column in the register table, which was set to On. You can either turn off the DISABLE_REFRESH column or bypass the Apply Program and perform a manual refresh.

Apply Sub Lag Time The difference (in number of minutes) between how much time has elapsed since the last run of the Apply Program and the expected sleep interval between executions of the Apply Program for the target table. The following value is valid:

External value	Internal value
Value_Exceeds_Maximum	9223372036854775807

Apply Sub Lag Time (Superseded) The difference (in number of minutes) between how much time has elapsed since the last run of the Apply Program and the expected sleep interval between executions of the Apply Program for the target table.

Apply Sub Status The Apply Program subscription status. The following values are valid:

External value	Internal value	Description
No Errors	0	No errors
Replication failed	-1	Replication failed
Successful single set processing multiple cycles	2	Successful single set processing multiple cycles
Some errors	16	Some errors
Some errors processing multiple cycles	18	Some errors processing multiple cycles

DB Name Target Database name.

Instance Name The name of the monitored DB2 instance. The valid format is a text string with a maximum of 60 bytes.

Node Name For new installations of version 6, release 2, the format is instanceid:hostname:UD for all operating systems. The format for version 6, release 1 of the DB2 agent on Windows systems is instanceid:hostname:UD; on UNIX and Linux® systems, the format is instanceid:hostname.

Snapshot Timestamp The date and time when the database system monitor information was collected. Use this attribute to help relate data chronologically if you are saving the results in a file or database for ongoing analysis.

Target Owner The name of the target owner for this member.

Target Table The name of the target table or view for this member.