IC65930: DBIMPORT ABORTS WITH ERROR -19836 - EXTENT SIZE IS TOO LARGE - FOR HUGE TABLES

APAR status

• Closed as program error.

Error description

• The dbimport utility might return error -19836 Extent size is
  too large, when importing huge tables without explicit
  definitions
  for extent sizes.
  
  Example:
  
  { TABLE "marions".mytab row size = 1032 number of columns = 6
  index size = 0 }
  { unload file name = mytab00100.unl number of rows = 80000000 }
  
  create table "marions".mytab
    (
      id1 serial not null ,
      id2 integer not null ,
      c1 varchar(255),
      c2 varchar(255),
      c3 varchar(255),
      c4 varchar(255)
    );
  *** prepare sqlobj
  19836 - Extent size is too large.  Maximum size of an extent is
  67108860k.
  
  The extent size might be calculated too high when the table
  contains a lot of varchar columns
  

Local fix

• Include extent size/next size in create table statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * dbimport users                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * dbimport aborts with error -19836 - Extent size is too large *
  * - for huge tables                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * upgrade to 11.50.xC7  and above.                             *
  ****************************************************************
  

Problem conclusion

• Fix was checked into 11.50.xC7
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP