PI95030: CUSTOMERS THAT UPGRADE FROM A VERSION OF UCD < 6.2.0 WILL BE MISSING INDICES

APAR status

• Closed as program error.

Error description

• Two indices were introduced in UCD 6.2.0, but were omitted from
  the database upgrade scripts - so servers installed before 6.2.0
  will be missing these
  
  the added indices:
  vc_persistent_rec_path_ver,
  vc_prm_gen_key
  
  indices removed:
  vc_persistent_record_path
  vc_prm_generator
  
  The newly added indices were created to be more performant with
  the vc_persistent_record and the vc_persistent_record metadata
  tables
  

Local fix

• The SQL can be ran outside of the UCD upgrade, here is the SQL
  that should have been ran:
  
  drop index vc_persistent_record_path;
  create index vc_persistent_rec_path_ver on
  vc_persistent_record(path, relative_version);
  drop index vc_prm_generator;
  create index vc_prm_gen_key on
  vc_persistent_record_metadata(metadata_generator, metadata_key);
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All end users on all supported browsers.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Two indices were introduced in UCD 6.2.0, but were omitted   *
  * from                                                         *
  * the database upgrade scripts - so servers installed before   *
  * 6.2.0                                                        *
  * will be missing these                                        *
  *                                                              *
  * the added indices:                                           *
  * vc_persistent_rec_path_ver,                                  *
  * vc_prm_gen_key                                               *
  *                                                              *
  * indices removed:                                             *
  * vc_persistent_record_path                                    *
  * vc_prm_generator                                             *
  *                                                              *
  * The newly added indices were created to be more performant   *
  * with                                                         *
  * the vc_persistent_record and the vc_persistent_record        *
  * metadata                                                     *
  * tables                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Fixed in version 7.0.1.2                                     *
  ****************************************************************
  

Problem conclusion

• Fix is provided in IBM UrbanCode Deploy 7.0.1.2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  UC DEPLOY

• Fixed component ID

  5725M5400

Applicable component levels