Page History
...
| 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 | ||||
|---|---|---|---|---|
|
...On Oracle platforms, DB Change Manager provides a list of all products installed on the Oracle instance and their versions.
| Anchor | ||||
|---|---|---|---|---|
|
On SQL Server, the following parameters are included:
- Product Version (e.g. 9.00.3042.00)
- Platform (e.g. NT INTEL X86)
- Language
- Physical Memory
- Processor Count
- Processor Type
- Windows Version
| Info |
|---|
For entries that contain internal values, the numeric attribute is also available for standard comparisons. For example, the Product Version attribute has a character and an internal value of “8.00.2039” and 524288, respectively. DB Change Manager supplies the Product Version as “8.00.2039,” and the Product Version Internal Value as 524288. |
| Anchor | ||||
|---|---|---|---|---|
|
On Sybase platforms, two groups of configuration parameters are supplied:...
- The Server Information group displays the results of executing sp_server_info, where the attribute name is the configuration parameter and the value is its value.
- The Version Information group, which contains the following parameters:
- Build Number
- Build Type
- Compilation Date & Time
- Compilation Kernel
- Compilation OS Bit Size
- Compilation OS Platform
- EBF Version
- Post Build Type
- Product
- Product Code
- Version