IC87867: DB2LOOK FAILS IF THE DATABASE HAS LARGE NUMBER OF LBAC SECURITY LABEL COMPONENTS

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• db2look fails if the database has large number of LBAC security
  label components.
  
  $ db2look -d DBname -e -z schema -o db2look.out
  -- No userid was specified, db2look tries to use Environment
  variable USER
  -- USER is: DB2INST1
  -- Specified SCHEMA is: schema
  -- Creating DDL for table(s)
  
  -- Schema name is ignored for the Federated Section
  -- Output is sent to file: db2look.out
  Segmentation Violation (core dumped)
  
  In some cases, Memory fault may occur.
  

Local fix

• Not Available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Version 10.1 FixPack 2                            *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in DB2 UDB Version 10.1 FixPack 2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC81134

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RA10 PSN

     UP