Product Database Release Enhancements

This page has not been liked. Updated 12/12/14, 6:27 PM by Fidelma_FrahillTags: None

Product Database Release Enhancements

The structure and format of the IBM Control Desk database changes slightly between releases as new features and enhancements are added to the product.

To plan an upgrade or migration, it can be useful to review and analyze the changes to database tables and columns when moving from one release to another.

The following files contain details about the  changes implemented between releases for IBM Control Desk Service Provider edition.

  • DatabaseDiffReportColumns-SP_enabled-721vs751.csv
  • DatabaseDiffReportColumns-SP_enabled-7500vs751.csv
  • DatabaseDiffReportTables-SP_enabled-721vs751.csv
  • DatabaseDiffReportTables-SP_enabled-7500vs751.csv

This archive containing these files can be found here.

This table contains a DatabaseDiffReportTables results example. This table shows an example table report.

OBJECTNAME CHANGED HASROWSTAMP KEYCOLUMN
ACCOUNTDEFAULTS C 1 ACCOUNTDEFAULTSID
ACTCI C 1 ACTCIID
ACTCIRELATION C 1 ACTCIRELATIONID
ACTCISPEC C 1 ACTCISPECID
ACTION C 1 ACTIONID
ACTIONGROUP C 1 ACTIONGROUPID

 

This table explains the results for each table record found in the DatabaseDiffReportTables file.

Column name Summary
OBJECTNAME Name of the database table that differs between databases.
CHANGED

Change type describing the difference found between a source environment database table and an upgraded target environment database table.

Values are:

  • N

NEW

New table that only exists in the target environment database.

  • S

SAME

Table is the same in both the source environment and the target environment databases.

  • C

CHANGED

Table exists in both the source environment and the target environment databases, but there are differences between them.

  • D

DELETED

Column exists in the source environment database only. This column is obsolete in the target environment database.

HASROWSTAMP

Indicates if the table includes a rowstamp column.

The rowstamp column is used to determine if a record has been updated by a user.

Values are:

  • 0

The table does not have a rowstamp.

  • 1

The table has a rowstamp.

KEYCOLUMN Name of the column serving as the primary key of the table.

 

This table contains a DatabaseDiffReportColumns results example. This table shows an example table column report.

CHANGETYPE TABLENAME COLUMNNAME TYPE LENGTH SCALE REQUIRED DEFVALUE
P ACTCI ACTCIID INTEGER 4 0 1  
C ACTCI ACTCIID BIGINT 8 0 1  
S ACTCI ACTCINAME VARGRAPHIC 192 0 0 null
S ACTCI ACTCINUM VARGRAPHIC 150 0 1  
N ACTCI CCIDISGUID VARGRAPHIC 192 0 0 null
S ACTCI CHANGEBY VARGRAPHIC 30 0 0 null

 

This table explains the results for each column record found in the DatabaseDiffReportColumns file.

Column name Summary
CHANGETYPE

Type of change for a particular database table column.

Change type indicates the difference found for a column between the source database and the upgraded database.

Values are:

  • N

NEW

Column exists in the upgraded database only

  • S

SAME

Column exists in both the source environment and target environment databases and is unchanged.

  • D

DELETED

Column exists in the source environment database only. This column is obsolete in the target environment database.

  • P

PREVIOUS

Column exists in both the source environment and target environment databases, but changes have been identified.

  • C

CHANGED

Column is defined on the target environment database.

TABLENAME Name of the table where the column appears.
COLUMNNAME Name of the column.
TYPE Datatype of the column.
LENGTH Datatype length of the column.
SCALE Used to define decimal point placement for data types like DECIMAL.
REQUIRED

Determines whether the column is required for an insertion or update table action.

Valid values are 1 for required and 0 for not required.

DEFVALUE

Default value for the column.

DEFVALUE is determined for a column in the following order of preference:

  1. Default value for column found in the maxattribute table.
  2. Default value for column found in the database table definition.
  3. Default value for column assigned by data type:
  • String: X
  • Number: 0
  • Date: CURRENT TIMESTAMP
  • YORN: 0