A fix is available
APAR status
Closed as new function.
Error description
SUPPORT FOR GEN TO TOLERATE OR SUPPORT CURRENT DB2 FUNCTION LEVE L.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool for z/OS * * and DB2 Object Comparison Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: For DB2 Administration Tool for z/OS, * * Version 12, Release 1 ONLY: * * * * 1- MIG line command ADDRI on panel ADB- * * 28S issues SQLCODE = -197 / SQLCODEN197.* * 2- Add Database to Migration issues * * SQLCODE=-203 / SQLCODEN203. * * 3- Continuous Delivery (CD) support for * * GEN * * 4 - This service enhances the Change * * Management batch interface and the * * Object Compare output. Prior to * * this enhancement, the jobs produced * * a variety of output files with error * * messages occurring in any of the files. * * When a problem occurs, it is difficult * * to determine what the problem is. * * * * For DB2 Administration Tool for z/OS, * * Version 11, Release 2, and Version 12, * * Release 1: * * * * 1 - Analyze process of a multi-target * * change type displays incorrect text * * for REPLICATE_ACCELERATED_TABLES * * parameter. * * 2- When BET line command is issued * * against packages with blank version, * * the generated output displays package * * details for versions with blank as * * well as non blank values. * * 3- Global change options panel ADB2PCO * * incorrectly displays "Invalid * * specification" error message, for * * valid combination of field values. * * 4- ADB2CMT detected an ONCODE condition * * 8094 in DETECT_COLMATCH at 23742. * * * * 5- VALIDATE_DDL option does not * * validate DDL that does not have * * SQL terminator. * **************************************************************** * RECOMMENDATION: * **************************************************************** For DB2 Administration Tool for z/OS, Version 12, Release 1 ONLY: 1- Recreate: a. On panel ADB21S 'Table Spaces', enter line command "MIG" on any object. b. On panel ADB28S 'Migrate Table Spaces', enter line command "ADDRI" on any object. SQLCODE=-197 / SQLCODEN197 results. 2- Recreate: a. On panel ADB21D 'Databases', enter line command "MIG" on any object. b. On panel ADB28S 'Migrate Table Spaces', enter primary command "ADD". c. On panel ADB28AD 'Add Database to migration', press the Enter key. d. On panel ADB28ADD 'Add Database to migration', select any object and press the Enter key. SQLCODE=-203 / SQLCODEN203 results. 3- A new Db2 function level check has been added to GEN so users are warned if GEN doesn't support or tolerate the current Db2 function level. In addition the following has been added: a- If a user has accepted using a function level that isn't supported or tolerated on the Admin prompt panel subsequent created GEN jobs will automatically include a new GEN option: ACCEPT_RISK_FOR_FL='nnn' , where 501<nnn<999 This option will allow GEN to continue running on a function level even if GEN doesn't support or tolerate the current function level. b- GEN will issue a message if the current function level doesn't support/tolerate a particular function level. However, as a temporary solution GEN will allow users to run on function level 502 although GEN currently does not support KEYLABELs. It is expected that GEN will be changed to only support function level 501 until full support for function level is provided. c- On the GEN panels a new field has been added to allow GEN to generate DDL for a particular function level - just like it today allows the user to generate DDL for a particular Db2 version. This field is not yet being used by GEN d- APPLCOMPAT, and CONCENTRATE STATEMENTS attributes will now be generated for functions and procedures when running on Db2 V12 FL 500 or above. 4- In this enhancement, warning and error messages are duplicated to a common output file, in addition to being written to their existing output file. Also, new messages indicating the start and end of the CM batch phases will also be written to the common output file. For DB2 Administration Tool for z/OS, Version 11, Release 2, and Version 12, Release 1: 1- When ANO line command is issued on panel ADB2C11 "CM - Changes" and "Generate ALL options" is set to YES on panel ADBPCMTA "Generate Multi-target Analyze Job", generated analyze job displays REPLICATE_ACCELERATED_TABLES parameter incorrectly, with first character "R" and remaining text "REPLICATE_ACCELERATED_TABLES" on separate lines. 2- When BET line command is issued against packages with blank version on panel ADB21K 'Packages', the generated output in REPORT DD displays details for additional packages with non blank versions as well. Blank value of version parameter is incorrectly treated as wild card. 3- Panel ADB2PCO "Options for Change Functions" does validation of field values and as soon as an invalid value is specified for a field resulting in "Invalid specification" error message, all subsequent correct values does not clear the error message. 4- The target catalog object created contains a LOB column and a DB2 generated ROWID column. While matching the compared source and target columns, Compare attempts to check the target's generated ROWID column match with a source column that does not exist. 5- VALIDATE_DDL option was used in CM batch to validate a SQL statement but the statement does not have SQL terminator. The statement should be validated.
Problem conclusion
Temporary fix
Comments
For DB2 Administration Tool for z/OS, Version 12, Release 1 ONLY: New functionality has been added to GEN Problems have been resolved. CM batch and Object Compare will support a new DD statement, ADBMSGS, and if this DD name is present it will duplicate all warning and error messages to this file. Those messages will continue to be written to their existing output file. Some examples of the DD statement: //ADBMSGS DD SYSOUT=* - //ADBMSGS DD DISP=(MOD,CATLG),DSN=USER1.ADBMSGS.OUTPUT1, // SPACE=(CYL,(2,1)), // DCB=(LRECL=137,RECFM=VBA,DSORG=PS) The format of messages in the ADBMSGS data set are in a tabular format and include the message number, the name of the issuing function, and the message text. The message Id, function name, and message text are aligned vertically. The last character of the message number will indicate the severity of the message. There are three severity types: I - Informational messages describe information or status for normal conditions and operations. W - Warning messages alert users to a condition that might cause subsequent problems. When a warning message is issued, the program can generally continue, but the function might not complete in a way that is expected. E - Error messages alert users to a problem that occurred. The programs cannot continue their tasks. With this change, the suffix of message ADB7705 is changed from an I to a W: ADB7705W ADBCDTS does not support xxx statement. Processing continues. Some adhoc messages previously written with no message number are written to the ADBMSGS output file with catchall message numbers: ADB7953I >informational text< ADB7954W >warning text< ADB7955E >error text< Also, new messages indicating the start and end of various CM batch phases will also be written to the ADBMSGS output file, for example: ADB7956I CM Batch: start of Compare phase. There are minor changes to some messages to improve alignment: ADB9901I Detailed change information ADB9945I Names of DB2 Admin data sets and PDS members associated with this change: ADB9946I Recover change: In Object Compare, some messages that were previously unnumbered are now displayed with a message number, for example, this message is now a warning message: ADB7954W ADBCCMM Foreign key FATHERPK dropped because all the columns were deleted from the primary/unique key Various 'dropped' and 'deleted' situations will be displayed with ADB7954W. Also, "empty file messages" are now displayed with ADB79543I: ADB7953I ADB2CMF Target: No records in target file. For DB2 Administration Tool for z/OS, Version 11, Release 2, and Version 12, Release 1: Problems have been resolved and SQL statement without terminator will be validated.
APAR Information
APAR number
PI96058
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
Reported release
B20
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-03
Closed date
2018-06-18
Last modified date
2018-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBALT ADBASW ADBCCM ADBCCME ADBCCMM ADBCDCH ADBCDTS ADBCDTW ADBCIMV ADBCMPDB ADBCMTP ADBCMTU ADBCP ADBCPRE ADBCPRT ADBCRCA ADBCRCC ADBCRCM ADBCRCR ADBCRSP ADBCSRV ADBCUPC ADBCVCT ADBCVEY ADBCVEZ ADBCVIC ADBCVIM ADBCVOB ADBCVOC ADBDAT ADBDET ADBEMTAR ADBGETM ADBHGEN ADBHJA1 ADBH6CFR ADBH6CFZ ADBH6CJ ADBH6COV ADBH6COW ADBH7O ADBLI ADBLIOB ADBMSG ADBPJA ADBPJA1 ADBPMSG ADBP6CFN ADBP6CFZ ADBP6CJW ADBP7F ADBP7FA0 ADBP7O ADBP7OA0 ADBRPTL ADBTEP2 ADBVERS ADBVFC ADBVFCA ADBVFCF ADB1000 ADB2CDC ADB2CHK ADB2CID ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2CM1 ADB2CM2 ADB2CM3 ADB2DEP ADB2GEN ADB2GENS ADB2GEN2 ADB2ISQ ADB2LCC ADB2MSK ADB2MSQ ADB2PA ADB2PA3 ADB2PCO ADB2PRP ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2RPT ADB2WCL ADB2WIN ADB2WVL ADB21F ADB21J ADB21O ADB26CF ADB26CFR ADB26CFS ADB26CFU ADB26CJ ADB26CO ADB26COU ADB26COV ADB26COW ADB27AC ADB28ADD ADB28MC ADB28S ADB7000 ADB9000 H0IHC10
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 July 2018