A fix is available
APAR status
Closed as program error.
Error description
In DB2 Administration Tool for z/OS certain DROP / CREATE change jobs from ALT ( ALTER ), or other operations, can cause CHECK PENDING states for tables. When ADBTEP2 schedules an auto CHECK utility to resolve the CHECK PENDING state, the HLQ (High Level Qualifier) of dataset names are being passed to DB2 via TEMPLATE statement as &USERID instead of using the prefix provided by the user in panel input. . For example, in ALT scenario, panel ADBPALT prompt for prefix: Prefix for data sets . . . <== prefix value entered here . Failure to use this prefix value from panel input results in DB2 resolving &USERID to SQLID during execution of CHECK utility. In many shops the HLQ for the DSN is not allowed, resulting in allocation errors. . TEMPLATES for ADBWORK1 ADBWORK2 AND ADBERROR appear succussful, as seen in TEMPLATE statement processing: . DSNU050I 248 13:44:20.96 DSNUGUTC - TEMPLATE ADBWORK1 DSN &USERID..ADBWORK1.&DB..&SN..&UNIQ. DISP(MOD, CATLG, CATLG) DSNU1035I 248 13:44:20.96 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY . but, subsequent dataset allocation fails due to invalid HLQ in DSNs with messages similar to the following: . DSNU1015I 248 13:44:21.29 DSNUGDYN - ERROR ALLOCATING DATASET DSN=<sqlid>.ADBWORK1.<dbname>.<unique value> CODE=X'970C0000' DSNU1042I 248 13:44:21.29 DSNUGDYN - START OF IDCAMS MESSAGES IKJ56893I DATA SET <sqlid>.ADBWORK1.<dbname>.<unique value> NOT ALLOCATED+ IGD17012I USER NOT AUTHORIZED TO DEFINE DATA SET <sqlid>.ADBWORK1.<dbname>.<unique value> . Additional keywords: rc8 rc08 msgikj56893i msgigd17012i
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS who specify AutoCheck field 'Yes' on * * panel ADB2UPA 'Batch Job Utility * * Parameters' and run Work List Statement * * (WSL). * **************************************************************** * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS * * certain DROP / CREATE change jobs * * from ALT 'ALT Alter Table', or other * * operations, can cause tables to be set * * to CHECK PENDING. When ADBTEP2 * * schedules an auto CHECK utility to * * resolve the CHECK PENDING state, the * * High Level Qualifier (HLQ) of dataset * * names are being passed to DB2 via a * * TEMPLATE statement. If the user does * * not define a user-defined template * * for the CHECK utility, ADBTEP2 * * uses the default definition for * * WORKDDN and ERRDDN templates. * * However, the &USERID is replaced * * by the SQLID during execution of * * CHECK utility. * * * * The following message is observed: * * * * ADB5217I Performing auto-check * * processing after the provided CHECK * * utility * * ADB5219I for the following object: * * ADB5220I XXXXX.XXXXXX * * * * DSNU000I * * DSNUGUTC - OUTPUT START * * FOR UTILITY, UTILID = >utilid< * * DSNU1044I * * DSNUGTIS - PROCESSING SYSIN * * AS EBCDIC * * DSNU050I * * DSNUGUTC - TEMPLATE ADBWORK1 * * DSN &USERID..ADBWORK1.&DB..&SN..&UNIQ. * * DISP(MOD, CATLG, * * CATLG) * * DSNU1035I * * DSNUJTDR - * * TEMPLATE STATEMENT PROCESSED * * SUCCESSFULLY * * DSNU050I * * DSNUGUTC - TEMPLATE ADBWORK2 * * DSN &USERID..ADBWORK2.&DB..&SN..&UNIQ. * * DISP(MOD, CATLG, CATLG) * * DSNU1035I * * DSNUJTDR - TEMPLATE STATEMENT * * PROCESSED SUCCESSFULLY * * DSNU050I * * DSNUGUTC - TEMPLATE ADBERROR * * DSN &USERID..ADBERROR.&DB..&SN..&UNIQ. * * DISP(MOD, CATLG, CATLG) * * DSNU1035I * * DSNUJTDR - TEMPLATE STATEMENT * * PROCESSED SUCCESSFULLY * * DSNU050I * * DSNUGUTC - CHECK DATA TABLESPACE * * XXXXX.XXXXXX SCOPE ALL * * WORKDDN(ADBWORK1, ADBWORK2) * * SORTDEVT SYSALLDA SORTNUM 4 * * ERRDDN(ADBERROR) * * DSNU1015I * * DSNUGDYN - ERROR ALLOCATING * * DATA SET DSN= * * AAAAA.ADBWORK1.&DB..&SN..&UNIQ * * CODE=X'970C0000' * * DSNU1042I * * DSNUGDYN - START OF IDCAMS MESSAGES * * IKJ56893I DATA SET * * AAAAA.ADBWORK1.&DB..&SN..&UNIQ * * NOT ALLOCATED+ * * IGD17012I USER NOT * * AUTHORIZED TO DEFINE DATA SET * * AAAAA.ADBWORK1.&DB..&SN..&UNIQ * * DADSM HISTORIC RETURN CODE IS * * 172 DADSM DIAGNOSTIC INFORMATION * * IS 040E0804 * * DSNU1043I * * DSNUGDYN - END OF IDCAMS MESSAGES * **************************************************************** * RECOMMENDATION: * **************************************************************** The &USERID that is used for templates ADBWORK1, ADBWORK2 and ADBERROR is replaced by the SQLID for the auto CHECK utility.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PM73284
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-09-19
Closed date
2013-05-14
Last modified date
2013-06-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK94268 UK94269
Modules/Macros
ADBTEP2
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.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 June 2013