A fix is available
APAR status
Closed as program error.
Error description
DB2 ADMINISTRTION TOOL FOR Z/OS NEW FUNCTION FOR MIG option to include/exclude object types via GEN-like panel.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following enhancement is * * delivered: * * * * - A new option Generate 'GEN' is now * * available on panel ADB28M 'Migrate * * Parameters' and panel ADBP8MV * * 'Migrate Parameters for View only' * * that will display new panel ADBP8MG * * 'Generate SQL from DB2 catalog' * * with a provision to specify which * * object types to include/exclude from * * the Migrate (MIG) process. It provides * * the user the flexibility and * * convenience to quickly navigate, * * see, and/or change GEN settings * * without having to exit out of MIG to * * invoke the GEN line command on * * on panels ADB21D 'Databases', * * ADB21S 'Table Spaces', and ADB21T * * 'Tables, Views, and Aliases'. * * * * The following problems exists:: * * * * 1- A user can not migrate a table with * * access control when High Performance * * UNLOAD (HPU) is specified as an UNLOAD * * option. This problem is caused by an * * invalid DB2 mode option. * * * * 2- When a user migrates a table they * * may receive message ADBMI001 / * * msgadbmi001 on panel ADB28M: * * * * ADBMI001 'Scope of migrate * * DDL=YES' and 'Use customized * * utility options=YES' and 'RUNSTATS * * option USE PROFILE' is an invalid * * combination. Suggested action: set * * DDL=NO and use option UO option * * R to set USE PROFILE off and then * * set DDL back to YES. * * * * And selecting the 'UO- Customize * * utility options' option on panel * * ADB28M and the 'R - RUNSTATS' option * * on panel ADB2UOPS 'Change Utilities * * Options' to show panel ADB2USR * * 'Specify Utility Options - RUNSTATS' * * or panel ADB2USRA 'Specify Utility * * Options - RUNSTATS' does not show * * the PROFILE setting. * * * * 3- When a user migrates a table they * * may receive an error on panel ADB2ER: * * * * Function : ADB28M, LINE 5396: If * * (utc31 = '' & loaddef ¬= '') Then * * * * Retcode : 8 * * * * Zerrmsg : ISPT034 * * Zerrsm : Novalue condition raised * * for variable UTC31 * * Zerrlm : Error executing exec - * * now terminating * * * * 4- When a user migrates a table and * * selects UNLOAD method 'HPU' on * * panel ADB28M, the user may see * * these errors: * * * * DSNUGDFL -KEYWORD 'LOAD' * * REQUIRES KEYWORD 'INTO' * * DSNUGBAC -UTILITY EXECUTION * * TERMINATED, * * HIGHEST RETURN CODE=8 * * * * 5- When a user migrates a table and * * selects UNLOAD method 'HPU' on * * panel ADB28M, the user may see a * * number of these messages when * * the job is submitted to load on target * * system: * * * * DSNU345I >timestamp< DSNURBXD - * * UNIQUE INDEX KEY DUPLICATES * * KEY FROM INPUT RECORD * * '1' LOADED AT RID X'0000000201', * * INDEX = TEMPDB.IXTEMP01, * * TABLE = TEMPDB.TBTEMP01, * * RECNO = 5, * * RID = X'0000000203' * **************************************************************** * RECOMMENDATION: * **************************************************************** The following enhancement is delivered: - A new option Generate 'GEN' is now available on panel ADB28M 'Migrate Parameters' and panel ADBP8MV 'Migrate Parameters for View only' that will display new panel ADBP8MG 'Generate SQL from DB2 catalog' with a provision to specify which object types to include / exclude from the Migrate (MIG) process. It provides to the user the flexibility and convenience to quickly navigate, see, and/or change GEN settings without having to exit out of MIG to invoke the GEN line command on panels ADB21D 'Databases', ADB21S 'Table Spaces', and ADB21T 'Tables, Views, and Aliases'.Aliases'. The following problems exists: 1- A user can not migrate a table with access control when HPU is specified as an UNLOAD option. This problem is caused by an invalid DB2 mode option. The following error messages will be shown in the job output: NZU380I INFORMATION : DEFAULT OUTPUT FORMAT IS SET TO DSNTIAUL DUE TO PARMLIB PARAMETER VUU045/ULFORMAT INZU399E A TABLE WITH CONTROLLED ACCESS ON A ROW OR COLUMN CANNOT BE UNLOADED IN NATIVE MODE. THE TABLE NAME IS >hlq.table_name<, AND THE COLUMN NAME IS >column_name<. INZU398E DB2 YES CANNOT BE SPECIFIED FOR A TABLE WITH CONTROLLED ACCESS ON A ROW OR COLUMN. THE TABLE NAME IS >hlq.table_name<, AND THE COLUMN NAME IS >column_name<. INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x105a00a) 2- The user can not proceed with the MIG process until the PROFILE setting is removed from panel ADB2USR. 3- When a user migrates a table they may receive an error on panel ADB2ER: Function : ADB28M, LINE 5396: If (utc31 = '' & loaddef ¬= '') Then Retcode : 8 Zerrmsg : ISPT034 Zerrsm : Novalue condition raised for variable UTC31 Zerrlm : Error executing exec - now terminating 4- When a user migrates a table and selects UNLOAD method 'HPU' on panel ADB28M, the user may see these errors: DSNUGDFL -KEYWORD 'LOAD' REQUIRES KEYWORD 'INTO' DSNUGBAC -UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 5- When a user migrates a table and selects UNLOAD method 'HPU' on panel ADB28M, the user may see a number of these messages when the job is submitted to load on target system: . DSNU345I >timestamp< DSNURBXD - UNIQUE INDEX KEY DUPLICATES KEY FROM INPUT RECORD '1' LOADED AT RID X'0000000201', INDEX = TEMPDB.IXTEMP01, TABLE = TEMPDB.TBTEMP01, RECNO = 5, RID = X'0000000203'
Problem conclusion
Enhancement delivered. Problems have been resolved. 2 - The problem circumvention to not being able to proceed with the MIG process until the PROFILE setting is removed is as follows: a - Exit panels ADB28M and/or ADBP8MV and display table spaces on panel ADB21S. b - Select a table space with the 'UTIL- Utility Selection' line command. c - Select the R - Runstats option on panel ADB2USR. d - On panel ADB2USR, clear the PROFILE field and press Enter to save the settings. The user can then proceed with the MIG process. New panels ADBP8MG 'Generate SQL from DB2 catalog' and ADBH8MG 'HELP: Generate SQL from DB2 catalog' are added. The following techdoc will include updates to the DB2 Administration Tool for z/OS User's Guide and Reference, Version 11, Release 1: http://www-01.ibm.com/support/docview.wss?uid=swg27041314 4- If HPU UNLOAD fails during the MIG process, specify the Unload method as 'U-Unload' on panel ADB28M. 5- If the LOAD fails during the MIG process when HPU is used for UNLOAD, specify the Unload method as 'U-Unload' on panel ADB28M.
Temporary fix
Comments
APAR Information
APAR number
PI26668
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-09-29
Closed date
2014-12-12
Last modified date
2015-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI23845
Modules/Macros
ADBH8M ADBH8MG ADBH8MV ADBPCTS ADBPCTT ADBPCT0 ADBPUI ADBP8AVD ADBP8MG ADBP8MV ADB2GEN ADB21D ADB21S ADB21T ADB28ADD ADB28ASD ADB28ATD ADB28HPL ADB28HPU ADB28HPV ADB28M ADB28MC ADB28M2 ADB28S ADB28T ADB53 ADB90
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI23845
UP14/12/16 P F412
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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
30 April 2020