IJ03139: FIXPACK UPDATEDB VERY SLOW IN SCRIPT V7608_12

APAR status

• Closed as program error.

Error description

• Installing fispack 7608, the updatedb is very slow in script
  V7608_12
  
  The statement that appears to be slow is
  /*
  * freeform: Fill PMGROUP field with appropriate values
  */
  update workview wv set pmgroup = coalesce ((select wo.pmnum from
  workorder wo where wo.workorderid=ownerid and
  wo.siteid=wv.siteid),
  (select p.pmnum from workorder c, workorder p where
  c.workorderid=ownerid and c.parent=p.wonum and
  c.siteid=p.siteid and
  p.siteid=wv.siteid) ) where class in (select value from
  synonymdomain
  where domainid='WOCLASS' and maxvalue in ('ACTIVITY',
  'WORKORDER'))
  ;
  
  The workview ad workorder tables are large (many millions of
  records)
  
  ENVIRONMENT:
  IBM WebSphere Application Server 8.5.5.3
  
  Tivoli's process automation engine 7.6.0.5-IFIX20160714-2200
  Build 20160611-0100 DB Build V7605-45 HFDB Build HF7605-02
  IBM TPAE Integration Framework 7.6.0.5 Build 20160610-2330 DB
  Build
  V7605-50
  GiS Insight 2.0.0.0 Build 20170725-0000 DB Build V2000-02
  IBM Maximo Asset Management Work Centers 7.6.0.0 Build
  20160610-1318 DB
  Build V7600-38
  IBM Maximo Asset Management 7.6.0.5 Build 20160611-0100 DB Build
  V7604-01
  
  
  
  Windows 6.3
  DB2/NT64 10.5 (SQL10058)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users applying Fixpack 7608 or beyond.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When applying Fixpack 7608, V7608_12.dbc may be slow to      *
  * execute if the user has large Workorder or Workview tables.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is included in the following package:
                          | Release 7.6.1.0 of Base Services.
  

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

  SYSTEM PERFORMA

• Fixed component ID

  5724R46PF

Applicable component levels

• R760 PSY

     UP