IC65524: SCANS OF DB2 DATABASES WITH NULL TABLESPACE CONFIGURATION FAILS GIVING NULL POINTER EXCEPTIONS.

4.2.1 Interim Fix 1 (November 2011) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• TPC 4.1 and 3.3.2 database scans will fail when the database has
  a null tablespace configuration.  The scan job log will show the
  following exception:
  12/14/09 9:59:25 AM DBA0038I: Scanning tablespace xxx.yyyyy on
  db2inst(x)
  java.lang.NullPointerException
   at com.tivoli.itsrm.Db.agent.udb.Scan.scan(Scan.java(Compiled
  Code))
   at
  com.tivoli.itsrm.Db.agent.common.ExecDbScan.scan(ExecDbScan.java
  :424)
   at
  com.tivoli.itsrm.Db.agent.common.ExecDbScan.main(ExecDbScan.java
  :155)
   at
  com.tivoli.itsrm.agent.svp.JavaJobHandler$Executor.execute(JavaJ
  obHandler.java:102)
   at com.tivoli.itsrm.agent.svp.worker.Worker.run(Worker.java:63)
   at java.lang.Thread.run(Thread.java:570)
  The scan code is not sufficiently robust to handle this type of
  configuration, and this APAR fixes that part of
  the code.
  RECREATE STEPS:
  Run a scan against a DB2 database with a null tablespace
  configuration, observe errors.
  ________________________________________________________________
  DB2 Version used for Server:  N/A
  The defect is against component:  5608TC300
  Server/Manager build/release (TPC):  4.1.0.97
  Agent build/release (TPC):  4.1.0.97
  Server/Manager (OS):  N/A
  Agent (OS):   N/A
  ________________________________________________________________
  Problem as described by customer:  TPC scan job failed
  Initial customer impact (low/med/high):  med
  

Local fix

• None known
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: TPC 3.3.2, 4.1.0 and 4.1.1 users with a      *
  *                 null tablespace in the database.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The database scan from TPC will fail    *
  *                      when the database has a null            *
  *                      tablespace configuration.               *
  *                                                              *
  *                      The following error is seen in the      *
  *                      scan job log:                           *
  *                                                              *
  *                      DBA0038I: Scanning tablespace           *
  *                      xxx.yyyyy on db2inst(x)                 *
  *                      java.lang.NullPointerException          *
  *                      at com.tivoli.itsrm.Db.agent.udb.Scan.  *
  *                      scan(Scan.java(Compiled Code)) at       *
  *                      com.tivoli.itsrm.Db.agent.common.       *
  *                      ExecDbScan.scan(ExecDbScan.java:424)    *
  *                      at com.tivoli.itsrm.Db.agent.common.    *
  *                      ExecDbScan.main(ExecDbScan.java:155)    *
  *                      at com.tivoli.itsrm.agent.svp.          *
  *                      JavaJobHandler$Executor.                *
  *                      execute(JavaJobHandler.java:102) at     *
  *                      com.tivoli.itsrm.agent.svp.worker.      *
  *                      Worker.run(Worker.java:63) at java.     *
  *                      lang.Thread.run(Thread.java:570)        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  -
  

Problem conclusion

• A code change has been made to allow the database scan to run
  successfully in this case.  The fix for this APAR is targeted
  for the following maintenance packages:
  
      | fix pack | 3.3.2-TIV-TPC-FP0008 - target February 2010
    | fix pack | 4.1.1-TIV-TPC-FP0003 - target May 2010
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  

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

  TPC FOR DATA

• Fixed component ID

  5608TC300

Applicable component levels

• R33A PSY

     UP

• R33L PSY

     UP

• R33W PSY

     UP

• R41A PSY

     UP

• R41L PSY

     UP

• R41W PSY

     UP