DB2-z/OS: PLAN_TABLE & DSN_STATEMNT_TABLE for v9.1

July 30, 2009 at 6:55 am

[] [] [] [] [] [] [] []

Related:

  1. DB2-z/OS: Seamless JDBC Database Failover for SAP Java stackSymptom This SAP Note describes how to enable high availability...
  2. DB2-z/OS: DB2 Connect 9.1 JDBC Failover for SAP Java stackSymptom This SAP Note describes how to enable high availability...
  3. DB2-z/OS: Inconsistent fields with DDIC type RAW/LRAW/VARCSymptom You are requested by a SAP tool or documentation...
  4. DB2-z/OS: Distribution of Java instances to DB2 membersSymptom If you have configured more than one SAP JAVA...
  5. DB6 and DB2/390: Java Database Connectivity (JDBC) traceSymptom A problem occurs in the SAP J2EE Engine. SAP...
  6. DB2-z/OS: Encrypt Data between Client and ServerSymptom You want to encrypt data between the application server...
  7. 640PC Edition May 2008:Installation IBM DB2 on z/OSSymptom This SAP Note is valid for the following releases:...
  8. DB2-z/OS: Upgrade to SAP NW AS 7.1 and higher – free spaceSymptom Disk space required for an upgrade to SAP Basis...

Symptom

The note describes a fix that allows to create PLAN_TABLE and DSN_STATEMNT_TABLE according to the IBM DB2 v9.1 documentation.

Other terms

DB2, MVS, OS390, z/OS

Reason and Prerequisites

-

Solution

Please proceed as follows:
1. Download the latest lib_dbsl patch (dbdb2slib.o/so/dll) from Software Marketplace. It should contain the patch text:
DB2-z/OS: PLAN_TABLE & DSN_STATEMNT_TABLE for v9.12. Exchange lib_dbsl and re-start the SAP system.3. Manually drop the following tables (with database means):
.”PLAN_TABLE”
.”DSN_STATEMNT_TABLE”4. The tables are re-created automatically when performing the first EXPLAIN within transaction ST05.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment