A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' MIG function fails with a message: ADB280J - Getting space information INVALID KEYWORD, <string> REENTER THIS OPERAND - PROC 2 PLAN PGM DEBUG RUNPARMS() PGMPARMS() CPSPLAN() ADBDIAG() DB2SYS() ADBTEST FUNCTION = ADB2C21, LINE 288: SELECT CMD(%ADBRPGM ADB ADBCIMU FRED PGMPARMS(VGET)) RC = 20 ZERRMSG = ZERRSM = ZERRLM = ? FUNCTION = ADB28M2, LINE 773: SELECT PGM(ADB28MM) PARM(/TSTABLE RC = 12 ZERRMSG = ISPT034 ZERRSM = Table is not open ZERRLM = TBQUERY issued for table ADB28XCL that is not open. FILE MASKS NOT FREED, IS NOT ALLOCATED ISPD117 The initially invoked CLIST ended with a return code = 12 READY END ADB28MM error : ADB2MSK INIT call failed, ADBM001 MASKS DD statement missing ADB28MM Return code : 12 when the DB2 table based MASK contains spaces eg IVP ADB NEW would cause the error message to say: INVALID KEYWORD, NEW
Local fix
Change the name of the MASK used to exclude spaces.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS and DB2 Object Comparison * * Tool for z/OS who use the Migrate (MIG) * * function with MASK. * **************************************************************** * PROBLEM DESCRIPTION: The MIG function fails with the * * following message and Return Code * * 20 / RC=20: * * * * ADB280J - Getting space information * * * * INVALID KEYWORD, >string< * * REENTER THIS OPERAND - * * PROC 2 PLAN PGM DEBUG * * RUNPARMS() * * PGMPARMS() CPSPLAN() * * ADBDIAG() * * DB2SYS() ADBTEST * * * * FUNCTION = ADB2C21, LINE * * 288: * * SELECT CMD(%ADBRPGM * * ADB ADBCIMU * * FRED PGMPARMS(VGET)) * * RC = 20 * * * * ZERRMSG = * * ZERRSM = * * ZERRLM = ? * * * * FUNCTION = ADB28M2, LINE 773: * * SELECT PGM(ADB28MM) * * PARM(/TSTABLE) * * RC = 12 * * * * ZERRMSG = ISPT034 * * ZERRSM = Table is not open * * ZERRLM = TBQUERY issued * * for table >table_name< that is * * not open. * * * * FILE MASKS NOT FREED, IS * * NOT ALLOCATED * * ISPD117 * * The initially invoked CLIST * * ended with a return code = 12 * * READY * * END * * ADB28MM error : ADB2MSK INIT * * call failed, ADBM001 MASKS * * DD statement missing * * ADB28MM Return code : 12 * * * * when the DB2 table based MASK * * contains spaces, e.g. 'IVP ADB * * NEW' would cause the error * * message: * * * * INVALID KEYWORD, NEW * **************************************************************** * RECOMMENDATION: * **************************************************************** Program does not support blanks in the MASK OWNER and MASK NAME.
Problem conclusion
Program has been updated to support blanks in the MASK OWNER and MASK NAME. APAR PI23026 has been opened to address the ONCODE150 / Oncode 150 issue encountered when using blanks in the MASK OWNER and MASK NAME, and selecting an 'Unload method' of 'H - HPU' ( High Performance Unload ) on panel ADB28M 'Migrate Parameters'.
Temporary fix
Comments
APAR Information
APAR number
PI17408
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-05-06
Closed date
2014-08-14
Last modified date
2014-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI20546 UI20547
Modules/Macros
ADB2CIMP ADB2C21 ADB2GEN ADB2W1Q ADB28M2
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.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 September 2014