DB2-z/OS: DDIC problems with Basis Release 7.10

July 20, 2009 at 4:39 am

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

  1. DB2-z/OS: Partition-by-growth with Basis SP13-SP15Symptom The note covers the following fixes/enhancements: The conversion of a table that is located in a partition-by-growth universal tablespace (uts) fails with SQLCODE -104. The attached correction fixes this problem.The new...
  2. DB2-z/OS:CCMS: DB13: DB2 Utilities SHRLEVEL SyntaxSymptom The DB13 job templates to call DB2 Utilities contain a wrong syntax for SHRLEVEL. The value of SHRLEVEL is accidentally enclosed in brackets. This prevents the fix from IBM APAR PK87122...
  3. DB2-z/OS:CCMS: DB2 Utility job changesSymptom REORG jobs in transaction DB13 alter the primary and secondary space allocation, if the number of extents is greater than four. In addition, REORG and COPY jobs in DB13 are not...
  4. DB2-z/OS: CCMS corrections (6.10, 6.20, 6.40, 7.x)Symptom This note describes DB2 for z/OS-specific corrections and advance developments for the CCMS for R/3 Releases 6.10, 6.20, 6.40 and 7.00. Other terms DB2, z/OS, ABAP, transport, correction, fix, advance development,...
  5. DB2-z/OS: Service SQLSymptom You want to create the service SQL to extract the current SQL query scenario. Other terms DB2, OS/390, z/OS, PLI8, DSNPLI8 Reason and Prerequisites To reproduce problems in the area of...
  6. DB2-z/OS: Requirements – EhP installerSymptom The note lists corrections that need to be applied to your system before you start the EhP installer to the following target release(s): NW 7.02NW 7.20 Other terms DB2 z/OS DDIC...
  7. DB2-z/OS:CCMS: Enabling Sysplex MonitorSymptom The new OS07(n) needs to query the connected SAP system via RFC to find out details about the associated DB host. Other terms DB2, z/OS, CCMS, Sysplex Monitor, OS07, Configuration, DB...
  8. DB2-z/OS:CCMS: DSNACCOR RUNSTATS recommendationsSymptom When computing RUNSTATS recommendations, the stored procedure DSNACCOR does not take into account, if last RUNSTATS time is older than last REORG time. Other terms DB2, CCMS, DB13, z/OS, OS/390, RUNSTATS,...

Symptom

The following symptoms are observed:
Table PRTTEST cannot be created or altered in unicode systems. The procedure fails with SQLCODE -670.Runtime error PERFORM_NOT_FOUND. The form SPECIAL_TOLERANCE is missing in report SDB8FDB2.Partitioning ranges specified with transaction SE14 are cut off. Conversion or re-creation of the table fails with SQLCODE -110. The error only occurs with DB2 v9.1.RBCA_PARTITION_TABLES sets the storage attributes MEMBER CLUSTER and SEGSIZE 36. Instead it should be SEGSIZE 0.

Other terms

DB2, z/OS,
PRTTEST, SQLCODE -670, SQLCODE -110

Reason and Prerequisites

Program error

Solution

To fix the problem with table PRTTEST proceed as follows:
1. Apply the attached correction instruction.2. Call transaction SE14 with table PRTTEST3. Choose Edit –> Extras –> Force conversion –> Yes.

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

Leave a Comment