A fix is available
APAR status
Closed as program error.
Error description
After a successful installation of TDS ( V8R1M0 ) a collect job fails with messages: DRL0068E The values specified for different cases are of different types. DRL0051E The preceding 1 message(s) refer to the expression for          ASYN_READ_RETURN. DRL0331E An error was found in update DB2_BP_SHARING. DRL0330E The collect initialization failed. . The DB2 migration jobs DRLJDB3, DRLJDB08 and DRLJDB09 were executed but this did not help.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: TDSz customers who are migrating any of * * the following components to TDSz v 181: * * 1. the MVSPERF component from TDS 170, and * * who have not previously installed the * * PTFs for APAR PK11283, or * * 2. the DB2 component from TDS 170 or 171, * * and who have not previously installed * * the PTFs for APAR PK61570, or * * 3. the IMS Version 7 components (which * * are no longer supported in TDS 181) * * to a higher level of IMS CSQ components. * **************************************************************** * PROBLEM DESCRIPTION: 1. MVSPERF component: * * Job DRLJMPL2 migrates table * * MVSPM_LPAR_H to a new structure. The * * new table is created from member * * DRLTMPLP. This could cause SQL errors * * in the migration when the 'old' and * * 'new' table do not have the same number * * of columns. * * * * 2. DB2 component: * * Job DRLJDB08 migrates DB2 component * * data tables. It drops the indexes for * * these tables, without recreating * * them. * * * * 3. IMS Version 7 components: * * These components are no longer * * supported in TDS 181. However, if * * customers have installed these * * components previously, these component * * objects would still exist in the system * * tables. * **************************************************************** * RECOMMENDATION: APPLY THE PTF FIXING THIS APAR * **************************************************************** 1. MVSPERF component: Job DRLJMPL2 migrates table MVSPM_LPAR_H to a new structure. The new table is created from member DRLTMPLP. This could cause SQL errors in the migration when the 'old' and 'new' table do not have the same number of columns. 2. DB2 component: Job DRLJDB08 migrates DB2 component data tables. It drops the indexes for these tables, without recreating them. 3. IMS Version 7 components: These components are no longer supported in TDS 181. However, if customers have installed these components previously, these component objects would still exist in the system tables.
Problem conclusion
1. MVSPERF component: Job DRLJMPL2 changed to create 'new' table as at PK11283 level. 2. DB2 component: Job DRLJDB08 changed to recreate indexes. 3. IMS Version 7 components: New job DRLJMIC2 created to remove IMS v 7 objects from the system tables. Job DRLJMIC2 should only be executed if you are no longer collecting data for IMS v 7. This job is optional. 810Y DRLJDB08 DRLJMIC2 DRLJMPL2
Temporary fix
Comments
APAR Information
APAR number
PM07912
Reported component name
TDS FOR Z/OS
Reported component ID
569510100
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-02-18
Closed date
2010-03-22
Last modified date
2010-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK55072
Modules/Macros
DRLJDB08 DRLJMIC2 DRLJMPL2
| SH19681612 |
Fix information
Fixed component name
TDS FOR Z/OS
Fixed component ID
569510100
Applicable component levels
R810 PSY UK55072
UP10/03/25 P F003
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS2DUM","label":"IBM Z Decision Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEQQC","label":"IBM Z Decision Support for Capacity Planning"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
03 April 2010