IV68941: DWB TABLES NEED TO BE ADDED TO THE DBREORG SCRIPT

8.6.0-TIV-TWS-WINDOWS-FP0004
8.6.0-TIV-TWS-WINDOWS_X86_64-FP0004
8.6.0-TIV-TWS-SOLARIS-FP0004
8.6.0-TIV-TWS-SOLARIS_I386-FP0004
8.6.0-TIV-TWS-LINUX_X86_64-FP0004
8.6.0-TIV-TWS-LINUX_S390-FP0004
8.6.0-TIV-TWS-LINUX_PPC-FP0004
8.6.0-TIV-TWS-LINUX_I386-FP0004
8.6.0-TIV-TWS-IBM_I-Fp0004
8.6.0-TIV-TWS-HPUX-FP0004
8.6.0-TIV-TWS-HPIA64-FP0004
8.6.0-TIV-TWS-AIX-FP0004

APAR status

• Closed as program error.

Error description

• The DWB schema tables are not in the
  TWSHome/dbtools/sql/reorganize_database.sql  provided with TWS.
  Thus, these tables can grow, uncontrolled.
  

Local fix

• The following SQL can be run manually. This is what should be
  added to the sql script above:
  
  REORG TABLE DWB.ALL_ALLOCATIONS;
  REORG TABLE DWB.ALR_ALLOCATION_RESOURCES;
  REORG TABLE DWB.ARE_ABSTRACT_RESOURCES;
  REORG TABLE DWB.CSR_COMPUTER_SYSTEM_RESOURCES;
  REORG TABLE DWB.EPR_ENDPOINT_REFS;
  REORG TABLE DWB.FSR_FILE_SYSTEM_RESOURCES;
  REORG TABLE DWB.JBN_JOB_BROKER_NOTIFICATIONS;
  REORG TABLE DWB.JOA_JOB_ARCHIVES;
  REORG TABLE DWB.JOB_BROKER_JOBS;
  REORG TABLE DWB.JOD_BROKER_JOB_DEFINITIONS;
  REORG TABLE DWB.JOR_JOB_RESOURCES;
  REORG TABLE DWB.JPR_JOB_PROPERTIES;
  REORG TABLE DWB.JRA_JOB_RESOURCE_ARCHIVES;
  REORG TABLE DWB.LGR_LOGICAL_RESOURCES;
  REORG TABLE DWB.MEA_METRIC_ARCHIVES;
  REORG TABLE DWB.MET_METRICS;
  REORG TABLE DWB.NSR_NETWORK_SYSTEM_RESOURCES;
  REORG TABLE DWB.NSS_NOTIFICATION_STATES;
  REORG TABLE DWB.OSR_OPERATING_SYSTEM_RESOURCES;
  REORG TABLE DWB.PPS_PRODUCT_PROPERTIES;
  REORG TABLE DWB.RAA_RESOURCE_ADVISORY_AGENTS;
  REORG TABLE DWB.REL_RESOURCE_DEPS;
  REORG TABLE DWB.RER_RESOURCE_REQUIREMENTS;
  REORG TABLE DWB.RGS_RESOURCE_GROUPS;
  REORG TABLE DWB.SRV_SERVERS;
  REORG TABLE DWB.TAJ_TWS_AGENT_JOBS;
  REORG TABLE DWB.ZAE_ZAGENT_EVENTS;
  REORG TABLE DWB.ZAN_ZAGENT_NOTIFICATIONS;
  
  REORG INDEXES ALL FOR TABLE DWB.ALL_ALLOCATIONS;
  REORG INDEXES ALL FOR TABLE DWB.ALR_ALLOCATION_RESOURCES;
  REORG INDEXES ALL FOR TABLE DWB.ARE_ABSTRACT_RESOURCES;
  REORG INDEXES ALL FOR TABLE DWB.CSR_COMPUTER_SYSTEM_RESOURCES;
  REORG INDEXES ALL FOR TABLE DWB.EPR_ENDPOINT_REFS;
  REORG INDEXES ALL FOR TABLE DWB.FSR_FILE_SYSTEM_RESOURCES;
  REORG INDEXES ALL FOR TABLE DWB.JBN_JOB_BROKER_NOTIFICATIONS;
  REORG INDEXES ALL FOR TABLE DWB.JOA_JOB_ARCHIVES;
  REORG INDEXES ALL FOR TABLE DWB.JOB_BROKER_JOBS;
  REORG INDEXES ALL FOR TABLE DWB.JOD_BROKER_JOB_DEFINITIONS;
  REORG INDEXES ALL FOR TABLE DWB.JOR_JOB_RESOURCES;
  REORG INDEXES ALL FOR TABLE DWB.JPR_JOB_PROPERTIES;
  REORG INDEXES ALL FOR TABLE DWB.JRA_JOB_RESOURCE_ARCHIVES;
  REORG INDEXES ALL FOR TABLE DWB.LGR_LOGICAL_RESOURCES;
  REORG INDEXES ALL FOR TABLE DWB.MEA_METRIC_ARCHIVES;
  REORG INDEXES ALL FOR TABLE DWB.MET_METRICS;
  REORG INDEXES ALL FOR TABLE DWB.NSR_NETWORK_SYSTEM_RESOURCES;
  REORG INDEXES ALL FOR TABLE DWB.NSS_NOTIFICATION_STATES;
  REORG INDEXES ALL FOR TABLE DWB.OSR_OPERATING_SYSTEM_RESOURCES;
  REORG INDEXES ALL FOR TABLE DWB.PPS_PRODUCT_PROPERTIES;
  REORG INDEXES ALL FOR TABLE DWB.RAA_RESOURCE_ADVISORY_AGENTS;
  REORG INDEXES ALL FOR TABLE DWB.REL_RESOURCE_DEPS;
  REORG INDEXES ALL FOR TABLE DWB.RER_RESOURCE_REQUIREMENTS;
  REORG INDEXES ALL FOR TABLE DWB.RGS_RESOURCE_GROUPS;
  REORG INDEXES ALL FOR TABLE DWB.SRV_SERVERS;
  REORG INDEXES ALL FOR TABLE DWB.TAJ_TWS_AGENT_JOBS;
  REORG INDEXES ALL FOR TABLE DWB.ZAE_ZAGENT_EVENTS;
  REORG INDEXES ALL FOR TABLE DWB.ZAN_ZAGENT_NOTIFICATIONS;
  

Problem summary

• The mentioned script needs to be modified to include the
  misszing tables
  

Problem conclusion

• The APAR will be fixed in 91FP3, 92FP2 and 86FP4
  

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

  TIV WKLD SCHDL

• Fixed component ID

  5698WKB86

Applicable component levels

• R8L6 PSY

     UP