PI24764: DATABASE ERROR ON DB2 ON STARTUP

IBM UrbanCode Release Fix Pack 2 (6.1.0.2) for 6.1
IBM UrbanCode Release Fix Pack 3 (6.1.0.3) for 6.1
IBM UrbanCode Release Fix Pack 4 (6.1.0.4) for 6.1
IBM UrbanCode Release Fix Pack 5 (6.1.0.5) for 6.1
IBM UrbanCode Release Fix Pack 6 (6.1.0.6) for 6.1
IBM UrbanCode Release Fix Pack 7 (6.1.0.7) for 6.1
IBM UrbanCode Release Fix Pack 8 (6.1.0.8) for 6.1
IBM UrbanCode Release Interim Fix 1 for 6.1.0.3

APAR status

• Closed as program error.

Error description

• When running on a DB2 database, there
  is an error in one of the database upgrade scripts that is
  applied on startup.  This will cause the product to fail to
  start correctly.
  

Local fix

• As a workaround, a corrected upgrade may be applied to the
  database manually by a user with permission to execute DDL
  statements.
  
  
           alter table tsk_task add column version2 numeric(22,0)
  default 0 not null;
           UPDATE tsk_task SET version2 = version;
           alter table tsk_task drop column version;
           alter table tsk_task rename column version2 to version;
           update ur_db_version set ver = 31 where  release_name =
  '4.3';
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Issues with DB2 on startup                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix is provided in IBM UrbanCode Release 6.1.0.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 RELEASE

• Fixed component ID

  5725M5500

Applicable component levels

• R600 PSN

     UP

• R600 PSY

     UP

• R601 PSN

     UP

• R601 PSY

     UP

• R610 PSN

     UP

• R610 PSY

     UP