This section describes the relational database tables in the migration database.
This table contains the timestamp history of when BUILDDB data was
collected, and when it was last updated by the PREPARE action.
Table 22. Version Control Table (VERSION_CONTROL)
| Column Name | Type | Length | Nulls? | Description |
|---|---|---|---|---|
| VERSION | SMALLINT | 2 | No | Version of the migration data. |
| COLLECT_TIME | TIMESTAMP | 10 | No | The COLLECT_TIME timestamp is assigned by the BUILDDB action when it is gathering the data. |
| PREPARE_TIME | TIMESTAMP | 10 | Yes | The PREPARE_TIME timestamp indicates the last time that a particular version of the BUILDDB action data was analyzed by the PREPARE action. If the PREPARE action with the 'O' option is used a second time against the same copy of the BUILDDB data, you will be warned that the previous analysis and any overrides will be lost. |
This table contains all Version 1 registration information.
Table 23. Global Change Data Control Table (GLOBAL_CD_CNTL)
| Column Name | Type | Length | Nulls? | Description |
|---|---|---|---|---|
| VERSION | SMALLINT | 2 | No | Version of the migration data. |
| DATA_ALIAS | CHAR | 8 | No | Column data is from the current BUILDDB action. |
| DATA_SERVER | CHAR | 18 | No | Column data is from the current BUILDDB action. |
| BASE_OWNER | CHAR | 18 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| BASE_TABLE | CHAR | 18 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CONTAINS_COMMITSEQ | CHAR | 1 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CD_OWNER | CHAR | 18 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CD_TABLE | CHAR | 18 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| PRUNE_CNTL_OWNER | CHAR | 18 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| PRUNE_CNTL_TABLE | CHAR | 18 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| FULLREFRESHENABLE | SMALLINT | 2 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CCD_OWNER | CHAR | 18 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CCD_TABLE | CHAR | 18 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CD_CONDENSED | CHAR | 1 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CD_CONSISTENT | CHAR | 1 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CD_COMPLETE | CHAR | 1 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CCD_CONDENSED | CHAR | 1 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CCD_CONSISTENT | CHAR | 1 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| CCD_COMPLETE | CHAR | 1 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| BASE_STRUCTURE | SMALLINT | 2 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| BASE_CONDENSED | CHAR | 1 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| BASE_CONSISTENT | CHAR | 1 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| BASE_COMPLETE | CHAR | 1 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| REGISTRAR | CHAR | 18 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| ARCH_LEVEL | CHAR | 4 | No | Column data is from ASN.IBMSNAP_CD_CNTL. |
| DESCRIPTION | CHAR | 254 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| PREFIX_CHAR | VARCHAR | 4 | Yes | Column data is from ASN.IBMSNAP_CD_CNTL. |
| BASE_TYPE | CHAR | 1 | Yes | Indicates the type of the BASE_TABLE. |
| REMOTE_SERVER | CHAR | 18 | Yes | Used for the DataJoiner server name. |
| CD_CNTL_TYPE | CHAR | 1 | No | Indicates the type of the ASN.IBMSNAP_CD_CNTL table. The data value can be either 'T' or 'V'. |
| SOURCE_OWNER | CHAR | 18 | Yes | Source owner in Version 5. |
| SOURCE_TABLE | CHAR | 18 | Yes | Source table in Version 5. |
| SOURCE_VIEW_QUAL | SMALLINT | 2 | Yes | Source view qualifier in Version 5. |
| NEW_BASE_STRUCTURE | SMALLINT | 2 | Yes | Source structure in Version 5. |
| OMIT | CHAR | 1 | Yes | Indicates whether a registration is to be migrated to Version 5. If the data value is 'Y', the registration is not migrated. |
This table contains all view dependencies in a server. For every
registered source table that is a view, the dependent tables will be fetched
from SYSVIEWDEP.
Table 24. Global View Dependencies Table (GLOBAL_VIEWDEP)
| Column Name | Type | Length | Nulls? | Description |
|---|---|---|---|---|
| VERSION | SMALLINT | 2 | No | Version of the migration data. |
| DATA_ALIAS | CHAR | 8 | No | Column data to be provided by the BUILDDB action; data server alias in Version 1. |
| DATA_SERVER | CHAR | 18 | No | Column data to be provided by the BUILDDB action; data server in Version 1. |
| BASE_OWNER | CHAR | 18 | No | Column data to be provided by the BUILDDB action; owner of the base table. |
| BASE_TABLE | CHAR | 18 | No | Column data to be provided by the BUILDDB action; name of the base table. |
| PHYS_TABLE_OWNER | CHAR | 18 | No | Column data to be provided by the BUILDDB action; owner of the physical table if the BASE_TABLE is a view. |
| PHYS_TABLE | CHAR | 18 | No | Column data to be provided by the BUILDDB action; name of the physical table if the BASE_TABLE is a view. |
This table contains all the CREATE VIEW statements for registered copy
table views on a copy server.
Table 25. Global View Text Table (GLOBAL_VIEW_TEXT)
| Column Name | Type | Length | Nulls? | Description |
|---|---|---|---|---|
| VERSION | SMALLINT | 2 | No | Version of the migration data. |
| COPY_ALIAS | CHAR | 8 | No | Column data to be provided by the BUILDDB action; copy server alias in Version 1. |
| COPY_SERVER | CHAR | 18 | No | Column data to be provided by the BUILDDB action; copy server in Version 1. |
| COPY_OWNER | CHAR | 18 | No | Column data to be provided by the BUILDDB action; owner of the copy table in Version 1. |
| COPY_TABLE | CHAR | 18 | No | Column data to be provided by the BUILDDB action; name of the copy table in Version 1. |
| SEQNO | SMALLINT | 2 | No | Column data is copied from SYSIBM.SYSVIEWS. |
| TEXT | VARCHAR | 3900 | No | Column data is copied from SYSIBM.SYSVIEWS. |
This table contains all Version 1 subscription information.
Table 26. Global Refresh Control Table (GLOBAL_REF_CNTL)
| Column Name | Type | Length | Nulls? | Description |
|---|---|---|---|---|
| VERSION | SMALLINT | 2 | No | Version of the migration data. |
| LOCAL_ALIAS | CHAR | 8 | Yes | Column from the current BUILDDB action; local server alias in Version 1. |
| LOCAL_SERVER | CHAR | 18 | Yes | Column from the current BUILDDB action; server which has the subscriber's routing table. |
| CNTL_ALIAS | CHAR | 8 | No | Column from the current BUILDDB action; control server alias in Version 1. |
| CNTL_SERVER | CHAR | 18 | No | Column from the current BUILDDB action; control server in Version 1. |
| DATA_ALIAS | CHAR | 8 | Yes | Column from the current BUILDDB action; data server alias in Version 1. |
| COPY_ALIAS | CHAR | 8 | Yes | Column from the current BUILDDB action; copy server alias in Version 1. |
| SUBSCRIBER | CHAR | 18 | No | Column from the current BUILDDB action; the Apply ID of the subscriber. |
| COPY_TYPE | CHAR | 1 | No | Column from the current BUILDDB action; the data indicates the type of COPY_TABLE. |
| ENABLE | SMALLINT | 2 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| DATA_SERVER | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| BASE_OWNER | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| BASE_TABLE | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| STMT_NUMBER | SMALLINT | 2 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| PRIORITY | SMALLINT | 2 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_OWNER | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_TABLE | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| RUNMODE | CHAR | 2 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| STATUS | SMALLINT | 2 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| INTERVAL_MINUTES | INTEGER | 4 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_CONDENSED | CHAR | 1 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_COMPLETE | CHAR | 1 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_CONSISTENT | CHAR | 1 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_STRUCTURE | SMALLINT | 2 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| ARCH_LEVEL | CHAR | 4 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_SERVER | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| PREDICATES | VARCHAR | 512 | Yes | Column from ASN.IBMSNAP_REF_CNTL. |
| SQL_STMT | VARCHAR | 1024 | Yes | Column from ASN.IBMSNAP_REF_CNTL. |
| PHYS_COPY_OWNER | CHAR | 18 | No | Column from the current BUILDDB action; owner of the physical table if COPY_TABLE is a view. |
| PHYS_COPY_TABLE | CHAR | 18 | No | Column from the current BUILDDB action; name of the physical table if COPY_TABLE is a view. |
| COUNT_NEG_ENABLES | INTEGER | 4 | No | The number of negative ENABLEs in the subscriber.IBMSNAP_TRAIL table. |
| DEFAULT_SET_NAME | CHAR | 18 | Yes | The default subscription set name assignment. |
| BEFORE_OR_AFTER | CHAR | 1 | Yes | Used to indicate if an SQL statement is to be removed (when the value is 'R' or 'X') or assigned (when the value is 'A', 'B', or 'S'). |
| DATA_LIMITING_PRED | CHAR | 1 | Yes | Used to indicate if any predicates would limit the scope of data fetched. |
| RELEASE_SQL_STMT | CHAR | 1 | Yes | Used to indicate if any SQL statements are used to release other substitutions. |
| OTHER_V1_PRED_REF | CHAR | 1 | Yes | Used to indicate any other access to a Version 1 control table in a predicate. |
| OTHER_V1_STMT_REF | CHAR | 1 | Yes | Used to indicate any other access to a Version 1 control table in an SQL statement. |
| ACTION_ON_PRED | CHAR | 1 | Yes | Used to indicate that a predicate is to be removed ('R') or substituted ('S'). |
| SUBSTITUTE_PRED | VARCHAR | 512 | Yes | Used to store the substituted predicate. |
| ACTION_ON_SQLSTMT | CHAR | 1 | Yes | Used to indicate that an SQL statement is to be removed ('R') or substituted ('S'). |
| SUBSTITUTE_SQLSTMT | VARCHAR | 1024 | Yes | Used to store the substituted SQL statement. |
| JOINVIEW_SET_NAME | CHAR | 18 | Yes | The set name for the join view subscriptions. |
| DLP_PRED_SET_NAME | CHAR | 18 | Yes | The set name for the subscriptions that have data limiting predicates. |
| SAME_DSCS_SET_NAME | CHAR | 18 | Yes | The set name for subscriptions having the same data server or copy server; used for candidate subscription sets. |
| FINAL_SET_NAME | CHAR | 18 | Yes | Used to indicate the final assignment of the subscription sets. |
| OMIT | CHAR | 1 | Yes | Used to indicate whether a subscription or EI statement is to be migrated to Version 5. If the data value is 'Y', it is not migrated. |
| NEW_APPLY_QUAL | CHAR | 18 | Yes | Option to supply a new Apply ID for execution of the Apply program, allowing exploitation of secondary AUTHIDs. |
| REFRESH_TIMING | CHAR | 1 | Yes | Option to specify event refresh timing in Version 5. |
| EVENT_NAME | CHAR | 18 | Yes | Option to specify the event name in Version 5. |
| SOURCE_OWNER | CHAR | 18 | Yes | The source owner in Version 5. |
| SOURCE_TABLE | CHAR | 18 | Yes | The source table name in Version 5. |
| SOURCE_VIEW_QUAL | SMALLINT | 2 | Yes | The view qualifier in Version 5. |
This table contains the contents of the Version 1 REF_COLS
tables.
Table 27. Global Refresh Columns Table (GLOBAL_REF_COLS)
| Column Name | Type | Length | Nulls? | Description |
|---|---|---|---|---|
| VERSION | SMALLINT | 2 | No | Version of the migration data. |
| CNTL_ALIAS | CHAR | 8 | No | Column from the current BUILDDB action; the control server alias in Version 1. |
| CNTL_SERVER | CHAR | 18 | No | Column from the current BUILDDB action; the control server in Version 1. |
| SUBSCRIBER | CHAR | 18 | No | Column from the current BUILDDB action; the Apply ID of the subscriber. |
| COPY_SERVER | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_OWNER | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COPY_TABLE | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| STMT_NUMBER | SMALLINT | 2 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COL_TYPE | CHAR | 1 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| TARGET_NAME | CHAR | 18 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| IS_KEY | CHAR | 1 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| COLNO | SMALLINT | 2 | No | Column from ASN.IBMSNAP_REF_CNTL. |
| EXPRESSION | VARCHAR | 254 | No | Column from ASN.IBMSNAP_REF_CNTL. |
This table is not initialized by BUILDDB. It is used by the
PREPARE action to identify Registration Migration Units (RMUs) and to assess
and store RMU migration dependencies.
Table 28. Registration Migration Units Table (RMU_LIST)
| Column Name | Type | Length | Nulls? |
|---|---|---|---|
| VERSION | SMALLINT | 2 | No |
| RMU_NUMBER | SMALLINT | 2 | Yes |
| DATA_ALIAS | CHAR | 8 | No |
| DATA_SERVER | CHAR | 18 | No |
| INDEPENDENT | CHAR | 1 | Yes |
| SEQUENCE_NUMBER | SMALLINT | 2 | Yes |
This table is not initialized by BUILDDB. It is used by the
PREPARE action to identify Subscription Migration Units (SMUs) and to assess
and store SMU migration dependencies.
Table 29. Subscription Migration Units Table (SMU_LIST)
| Column Name | Type | Length | Nulls? |
|---|---|---|---|
| VERSION | SMALLINT | 2 | No |
| SMU_NUMBER | SMALLINT | 2 | Yes |
| SUBSCRIBER | CHAR | 18 | No |
| CNTL_ALIAS | CHAR | 8 | No |
| CNTL_SERVER | CHAR | 18 | No |
| INDEPENDENT | CHAR | 1 | Yes |
| SEQUENCE_NUMBER | SMALLINT | 2 | Yes |
| SUB_FROM_BASE_VIEW | CHAR | 1 | Yes |
| LOCAL_ALIAS | CHAR | 8 | No |
This table lists all occurrences of Apply programs maintaining a CCD on
a copy server. In the case of dependencies, the Apply programs must be
migrated at the same time as the registrations.
Table 30. RMU Dependencies on SMU Table (RMU_DEPENDS_ON_SMU)
| Column Name | Type | Length | Nulls? |
|---|---|---|---|
| VERSION | SMALLINT | 2 | No |
| RMU_NUMBER | SMALLINT | 2 | Yes |
| MIGRATE_RMU_ALIAS | CHAR | 8 | No |
| MIGRATE_RMU | CHAR | 18 | No |
| SMU_NUMBER | SMALLINT | 2 | Yes |
| DEPENDS_SMU_SUBSCR | CHAR | 18 | No |
| DEPENDS_SMU_CTLALS | CHAR | 8 | No |
| DEPENDS_SMU_CTLSVR | CHAR | 18 | No |
| DEPENDS_SMU_LCLALS | CHAR | 8 | No |
This table lists all occurrences of Apply programs maintaining a CCD on
a copy server. In the case of dependencies, the Apply programs must be
migrated at the same time as the registrations.
Table 31. SMU Dependencies on RMU Table (SMU_DEPENDS_ON_RMU)
| Column Name | Type | Length | Nulls? |
|---|---|---|---|
| VERSION | SMALLINT | 2 | No |
| SMU_NUMBER | SMALLINT | 2 | Yes |
| MIGRATE_SMU_SUBSCR | CHAR | 18 | No |
| MIGRATE_SMU_CTLALS | CHAR | 8 | No |
| MIGRATE_SMU_CTLSVR | CHAR | 18 | No |
| MIGRATE_SMU_CPYSVR | CHAR | 18 | No |
| RMU_NUMBER | SMALLINT | 2 | Yes |
| DEPENDS_RMU_ALIAS | CHAR | 8 | No |
| DEPENDS_RMU | CHAR | 18 | No |
| MIGRATE_SMU_LCLALS | CHAR | 8 | No |