JR33387: INFORMATION SERVER 8.1 - DB2 ENTERPRISE STAGE HAS ISSUE WITH RANGE PARTITION TABLES

APAR status

• Closed as program error.

Error description

• Information Server 8.1 - DB2 Enterprise Stage has issue with
  range partition tables.
  
  Following error message is received:
  Fatal error when processing DB2 range partitioned tables
     Item #: 2973
     Event ID: 18332
     Timestamp:: 2009-06-03 18:45:27
     Type: Fatal
     User Name: iceetl
     Message:: main_program: Fatal Error: Table `JDE_AB_STG' must
  exist
  before querying the node group.
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  The issue is seen when using the DB2 EE stage in IS 801 FP1 to
  read/write from range partitioned tables.
  ****************************************************************
  PROBLEM DESCRIPTION:
  DB2EE fails to read/write from range partitioned tables.
  ****************************************************************
  RECOMMENDATION:
  Install patch_JR33387
  ****************************************************************
  

Problem conclusion

• Issue is fixed in patch_JR33387
  

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:

Modules/Macros

• DB2EE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP