A fix is available
APAR status
Closed as new function.
Error description
new function for premigration DB2MIGV10/K DB2COEXIST/K
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: DB2 UDB for z/OS Version 8 and DB2 Version * * 9.1 for z/OS System Administrators are * * affected by this change. * **************************************************************** * PROBLEM DESCRIPTION: Provide a DB2 Version 10 for z/OS * * premigration checkout job in DB2 UDB * * for z/OS Version 8 and DB2 Version 9.1 * * for z/OS. * **************************************************************** * RECOMMENDATION: * **************************************************************** Beginning with DB2 V6, each release of DB2 provides a job called DSNTIJPM that can be run on the prior release to help identify conditions that can impede migration to the new release. To allow customers maximum time to prepare for migration to a new release, the DSNTIJPM job is shipped under a different name in the previous release. For example: - the V8 DSNTIJPM is shipped as DSNTIJP8 in V7 - the V9 DSNTIJPM is shipped as DSNTIJP9 in V8 This arrangement permits customers to begin preparing for migration in advance of buying and SMP/E-installing the new version. This APAR adds the V10 DSNTIJPM job to DB2 V8 and V9 under the name DSNTIJPA. DSNTIJPA generates the following reports: (1) Check for previous-release sample database (2) User-defined indexes that reside on user-managed storage and are defined on DB2 catalog tables that are processed during enabling-new-function mode (3) User-defined indexes that reside on DB2-managed storage and are defined on DB2 catalog tables that are processed during enabling-new-function mode (4) Stored procedures that use the DB2 SPAS (5) Plans that are autobind candidates in V10 (6) Packages that are autobind candidates in V10 (7) Use of external module DSNWZPR (8) Incomplete table definitions (9) Incomplete column definitions (10) Occurences of the DSN_PTASK_TABLE explain table with one or more column names that contain a hashmark character (11) Plans that contain DBRMs (12) Plans bound with ACQUIRE(ALLOCATE) (13) Static queries bound with query parallelism (14) EBDDIC explain tables (15) Explain tables that are not in current-release format (16) MQTs on the DB2 catalog that are affected by CATMAINT (17) MQTs on the DB2 catalog that are affected by CATENFM (18) Plans bound with DBPROTOCOL(PRIVATE) that can be converted to DRDA via REBIND PLAN (19) Plans bound with DBPROTOCOL(PRIVATE) that can be converted to DRDA via DSNTIJPD (20) Packages bound with DBPROTOCOL(PRIVATE) that can be converted to DRDA via REBIND PLAN (21) Packages bound with DBPROTOCOL(PRIVATE) that can be converted to DRDA via DSNTIJPD (22) Authorization IDs and roles that use EBCDIC-encoded routines for DBMD (23) Obsolete DB2-supplied objects (24) Packages that use UDF SYSFUN.DSN_XMLVALIDATE (25) Existence of inconsistent UTF-8 encoding of the collection IDs and the package names that were bound by a remote client system. Run DSNTIJPA as soon as possible on your DB2 V8 or V9 system in order to evaluate it for readiness for migration to DB2 Version 10. DSNTIJPA uses DB2 REXX Language Support. If you have not bound the packages and plans for DB2 REXX Language Support, use job DSNTIJRX to do so before running DSNTIJPA. Attention: Certain processing performed by this job requires use of a special package for DB2 REXX in collection id DSNREXX_500. Use DSNTIJPA job step DSNTIRX5 to bind this package and include it in the DSNREXX plan. Before running this job step, ensure that you are authorized to create packages in the DSNREXX_500 collection id and to bind the DSNREXX plan.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PM04968
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-01-12
Closed date
2010-04-22
Last modified date
2011-02-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK56305 UK56306
Modules/Macros
DSNTIJPA DSNTINS1
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
19 February 2011