A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' GEN command issues a message: ADB1924E No statement text record(s) found for Create view when executed on a DB2 10 subsystem in ENFM9 mode.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who use the Generate (GEN) function on * * a View, Materialized Query Table (MQT), * * Trigger in DB2 10 Enabling-New-Function * * mode (ENFM9). * * * * Users of the DB2 Administration Tool for * * z/OS who use the Alter Table (ALT) function * * to alter a table that has a Trigger on it in * * DB2 10 ENFM9 mode. * * * * Users of the DB2 Object Comparison Tool * * for z/OS who compare tables that have a * * view, the source is from DDL and target is * * from the catalog in DB2 10 ENFM9 mode. * * * * Users of the DB2 Object Comparison Tool * * for z/OS who compare schemas, source is * * from DDL and target is from the catalog in * * DB2 10 ENFM9 mode. * * * * Users of the DB2 Object Comparison Tool * * for z/OS who compare databases with a * * view, the source is from DDL and target * * is from the catalog in DB2 10 ENFM9 mode. * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS * * GEN command issues a message: * * * * ADB1924E No statement text * * record(s) found for Create view * * when executed on a DB2 10 * * subsystem in ENFM9 mode. * * * * The DB2 Administration Tool for z/OS, * * ALT on a table which has a trigger * * and after submitting the alter job, * * the following error message is * * displayed: * * * * Compare Trigger source * * (source_object) and * * target(target_object) * * ADB0380E Module ADB2CMP - * * Severe error Alter terminates * * * * The DB2 Object Comparison Tool for * * z/OS compares the tables that have a * * view, source is from DDL and target * * is from the catalog, after submitting * * the compare job, the following error * * message is displayed: * * * * ADB1843E No sysviews row found * * for 'Create view' * * * * ADBC026E Severe Error when * * generating DDL * * * * The DB2 Object Comparison Tool for * * z/OS compares schemas, the source * * is from DDL and target is from the * * catalog, after submitting the compare * * job, the following error message is * * displayed: * * * * ADB1649E ADB2REY: Unexpected * * sqlcode in : GEN_UDF Select Max * * seqno * * * * and an SQLCODE=-305 / SQLCODEN305 * * is displayed: * * * * DSNT408I SQLCODE = -305, ERROR: * * THE NULL VALUE CANNOT BE ASSIGNED * * TO OUTPUT HOST VARIABLE NUMBER 1 * * BECAUSE NO INDICATOR VARIABLE IS * * SPECIFIED * * DSNT418I SQLSTATE = 22002 * * SQLSTATE RETURN CODE * * * * The DB2 Object Comparison Tool for * * z/OS, compares the database with a * * view, the source is from DDL and * * target is from the catalog, after * * submitting the job, an ONCODE520 / * * ONCODE=520 is displayed: * * * * IBM0421S ONCODE=520 The * * SUBSCRIPTRANGE condition * * was raised. * * From entry point * * MODIFY_TOKENS at statement * * >stmtnumber< at compile unit * * offset >offsetaddress< at * * entry offset >offsetaddress< * * at address >address< * **************************************************************** * RECOMMENDATION: * **************************************************************** The GEN function can't create a version file record for the View, MQT, or Trigger when executed on a DB2 10 subsystem in DB2 10 ENFM9 mode.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM61947
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-05
Closed date
2012-04-26
Last modified date
2012-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2REH ADB2REM ADB2REP ADB2RET ADB2REY
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK78293
UP12/04/28 P F204
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 May 2012