A fix is available
APAR status
Closed as new function.
Error description
Internal APAR PHnnnnn Allow specifying source/target objects from an SQL SELECT statement in Compare
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Only DDL, the Db2 catalog, or a version * * file can be used as a source for a * * comparison (GOC1 panel). Catalog * * objects can be obtained only with name * * patterns. * * * * This APAR allows the result of an SQL * * SELECT statement to be used as the * * objects to be compared. This source is * * more flexible than a name pattern and * * allows the user to filter objects by * * using a WHERE clause. * **************************************************************** This APAR updates the code for GEN, CMBATCH and Object Compare to process SQL SELECT statements. 1) A new type of GEN request has been added: TYPE='SQL', SQL='<SELECT statement>' The SELECT statement may return only the following columns: TYPE CHAR(2) QUAL VARCHAR(128) NAME VARCHAR(128) VERSION VARCHAR(122) - optional INCLUDE CHAR(8) - optional XDTYPE CHAR(8) - optional (exclude) The result of this SELECT statement should be a valid GEN request that is currently supported. 2) A new type of object specification using SQL SELECT for source and target for Object Compare has been added: The new option "Source/Target is the result of an SQL SELECT statement" has been added on GOC12 panel. New panel GOCSQ "Define SQL SELECT Statement For Source/Target" has been added. An Object Compare job can extract objects from Db2 by using the new SQL SELECT GEN request. 3) A new type of object specification using SQL SELECT for source and target for CM batch has been added: CM batch support for new request TYPE='SQL', SQL='<SELECT statement>'; as a quick scope in SRCIN DD and TGTIN DD.
Problem conclusion
The enhancement has been delivered.
Temporary fix
Comments
APAR Information
APAR number
PH57198
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2023-09-27
Closed date
2023-10-09
Last modified date
2023-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI93945
Modules/Macros
ADB1000 ADB2RE ADB2REE ADB2REZ ADBBIND ADBCCM ADBCVSE ADBGDDL
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI93945
UP23/10/14 P F310
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":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 November 2023