Page History
...
| Anchor | ||||
|---|---|---|---|---|
|
| Task | Permissions for Own Objects | Permissions for All Objects |
|---|---|---|
| Archive and Compare Schemas | No special privileges required. | SELECT_CATALOG_ROLE |
| Alter Schema Object | No special privileges required. | DBA role to alter system objects |
| Configuration Settings | Not applicable | DBA role |
| Compare Data | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. |
| Synchronize/Mask/Move Data | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. |
| Anchor | ||||
|---|---|---|---|---|
|
...
The following subtopics describe the version information used when comparing, archiving, or creating a configuration standard:
- Version information Information for DB2 for LUW
- Version information Information for Oracle
IBM DB2 for LUW Version Information
...
Oracle Version Information
...
SQL Server Version Information
...
...
| Anchor | ||||
|---|---|---|---|---|
|
| Parameter | Description |
|---|---|
| INST_NAME | Name of the current instance. |
| IS_INST_PARTITIONABLE | Indicates whether the current instance is a partitionable database server instance. Possible return values are 0, if it is NOT a partitionable database server instance, and 1if it IS a partitionable database server instance. |
| NUM_DBPARTITIONS | The number of database partitions. If it is NOT a partitioned database environment, this value is 1. |
| INST_PTR_SIZE | The bit size of the current instance. Values are 32 or 64. |
| RELEASE_NUM | The internal release number as returned by the db2level command. For example, 03030106. |
| SERVICE_LEVEL | The service level as returned by the db2level command. For example, DB2 v8.1.80. |
| BLD_LEVEL | The build level as returned by the db2level command. For example, n041021. |
| PTF | The program temporary fix (PTF) identifier as returned by the db2level command. For example, U498350. |
| FIXPACK_NUM | The FixPak number as returned by the db2level command. For example, 9. |
| Anchor | ||||
|---|---|---|---|---|
|
...
| Anchor | ||||
|---|---|---|---|---|
|
...
| Anchor | ||||
|---|---|---|---|---|
|
...