A fix is available
APAR status
Closed as program error.
Error description
Altering a LOB Tablespace specifying Reorg options generates msg DSNU049I INVALID OPERAND 'NO' FOR KEYWORD 'REPORT' ADBT015I Failure attempting to execute ADB2UTIL with parm ADB5184E The run is ending due to an error with a non-SQL command. when Reorg options STATISTICS has been previously set.
Local fix
Panel ADB2USO change option STATISTICS YES to NO for the Reorg options
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who specify the STATISTICS options * * for REORG utilities during the ALT * * function's change process. * **************************************************************** * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS, * * when altering a LOB table space to * * trigger a REORG and specifying the * * STATISTICS options like REPORT NO, * * these options will be generated in * * the REORG statements which causes * * REORG to fail with the following * * error message: * * * * DSNU049I INVALID OPERAND 'NO' * * FOR KEYWORD 'REPORT' * * ADBT015I Failure attempting to * * execute ADB2UTIL with parm * * ADB5184E The run is ending due * * to an error with a non-SQL * * command. * **************************************************************** * RECOMMENDATION: * **************************************************************** In DB2 Administration Tool for z/OS, when altering a LOB table space to trigger a REORG and specifying the STATISTICS options like REPORT NO, these options will be generated in the REORG statements which causes REORG to fail with the following error message: DSNU049I INVALID OPERAND 'NO' FOR KEYWORD 'REPORT' ADBT015I Failure attempting to execute ADB2UTIL with parm ADB5184E The run is ending due to an error with a non-SQL command.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM96080
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-29
Closed date
2013-11-13
Last modified date
2013-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI12477 UI12478
Modules/Macros
ADBGAJOB ADB2USO
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":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 December 2013