A fix is available
APAR status
Closed as new function.
Error description
NFDB210 DB2 ADMINISTRATION TOOL FOR Z/OS VERSION 10 ENHANCEMENTS.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: New DB2 10 support added and other * * functions improved. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following functions has been improved - Option 2.1, panel ADBPMESQ 'Edit/Run SQL Statement' will now place the user in an ISPF edit session and allow the user to use the full ISPF Edit capabilities for editing the SQL statement. The SQL statement will be run when the user issues the EXEC command. When END is entered or pressed, the user will be prompted to perform the SQL statement. The PANEL command can be used to set the result panel name. Use the PANEL name command to set the Admin display panel for an SQL SELECT statement. The name is the name of the panel and should match the expected result set. For example, PANEL ADB21T may be used to display the results of an SQL SELECT * FROM SYSIBM.SYSTABLES query on panel ADB21T. If no panel has been specified the default panel will be used. Use the PANEL command without a panel name to reset it to the default panel. - Line command DIST and DISRT has been added to panels ADB21D 'Databases', ADB21X 'Indexes'. Panel ADB21DI2 'Status' and improved to allow users to manage table spaces and index spaces by name and by status. DIST will display objects in ISPF table format. DISRT will display objects in a restricted use state in ISPF table format. -New masks and overwrites have been added to the product. The new masks are CONSNAME, SEQNAME, SYNNAME, ALNAME, VWNAME, TGSCHEMA, UDTSCHEMA, SEQSCHEMA,STPSCHEMA, UDFSCHEMA,SETPATHSC,ALSCHEMA, VWSCHEMA, SYNOWNER, WLMENV, and LOCATION. The new overwrite masks are CLOSE, IXCLOSE, TSCLOSE and AUDIT. - Improved Run Work Statement List usability/interface by consolidating several pop-up panels: ADB2WHPU 'HPU Unload Prompt' and ADB2W1R 'Specify Job Parameters' into one new OPTIONS panel: ADBPWLO 'Work Statement List Options'. - The "O" line command option to run the Work Statement List online has been removed from panel ADB2W1 'Work Statement List Library'. The Online option is now integrated into line command option "R" where Run execution mode Batch/Online can be managed by the new OPTIONS setup panel. An option to prompt the OPTIONS panel upon RUN has also been provided. - A new option has been added to the Work Statement List tool to backup DDL for objects being dropped in the Work Statement List. This 'Backup DDL' option can be enabled on the OPTIONS setup panel ADBPWLO 'Work Statement List Options' and is invoked when the Run WSL line command option 'R' is used. - Allow all line commands for all ISPF table display panels to be specified on any position within it's associated input field. - A new option 'Line command field behavior' on panel ADB2P2 'Change DB2 Admin Defaults' has been added to allow users to specify what residual content the line command input field should have after the line command has been processed. - Add the ability to run DDL only (i.e. do not unload and load existing data). This can be done in Alter ( ALT ) and Change Management ( CM ) functions. If a Work Statement List ( WSL ) is generated with DDL only it will be marked so that when the user runs a WSL that was generated with DDL only, they will be warned. NOTE: If utilities are requested for ALT or CM, they will not be generated with the exception of the REBIND utility. This note does not apply to background utilities run by ADBTEP2 to remove restrictive states on objects.
Problem conclusion
Temporary fix
********* * HIPER * ********* THIS IS A NEW FUNCTION APAR.
Comments
New DB2 10 support and improved functions has been added. The SAMP library member ADBCHG02 will need to be run to add column APPCONT to the ADBCHG table.
APAR Information
APAR number
PM36028
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2011-03-31
Closed date
2011-07-30
Last modified date
2011-09-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK70330
Modules/Macros
ADBALT ADBASW ADBCCMM ADBCDTS ADBCDTW ADBCEST ADBCHANG ADBCHG02 ADBCIMV ADBCP ADBCRCM ADBCRCP ADBCRCR ADBCSPG ADBCUPD ADBCVCT ADBCVEX ADBCVIM ADBCVOC ADBCVSE ADBC12 ADBDMT ADBDMTT ADBEALT ADBEDIAG ADBEMSQA ADBEMSQM ADBEMSQP ADBGAJOB ADBHALT ADBHC11A ADBHC2L ADBHMESQ ADBHP2 ADBHWLB ADBHWLO ADBHW1 ADBH1X ADBMAIN ADBNSPB ADBPALT ADBPMESQ ADBPMSPO ADBPPDC ADBPPDCC ADBPQTAB ADBPWLB ADBPWLO ADBPZAP ADBP6CTH ADBSALT ADBSRL ADBTEPI ADBTEPR ADBTEPU ADBTEP2 ADBV99 ADB2AC ADB2AD ADB2AG ADB2AH ADB2AK ADB2AL ADB2AN ADB2ANAT ADB2ANID ADB2AO ADB2AP ADB2AQ ADB2AR ADB2ARL ADB2ARLO ADB2AS ADB2AT ADB2AUD ADB2AUS ADB2AZ ADB2AZ1 ADB2CC ADB2CCD ADB2CCR ADB2CCS ADB2CCT ADB2CEX1 ADB2CID ADB2CMF ADB2CMM ADB2CMP ADB2CMPC ADB2CMR ADB2CMS ADB2CMT ADB2CON ADB2C1P ADB2C1S ADB2C11 ADB2C11A ADB2C11R ADB2C14 ADB2C2L ADB2C21 ADB2C31 ADB2C4O ADB2C41 ADB2C42 ADB2C5 ADB2C62 ADB2DDF ADB2DEP ADB2DPRT ADB2DROW ADB2EL ADB2ELF ADB2ELS ADB2EQ ADB2FMT ADB2GEN ADB2GEN2 ADB2LCC ADB2MSK ADB2M1MG ADB2M1S ADB2OVW ADB2PA ADB2PARM ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2P2 ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2REU ADB2REZ ADB2RGC ADB2RIP ADB2SARG ADB2SDM ADB2SORT ADB2SYS ADB2S1 ADB2UP0 ADB2USO ADB2USOT ADB2US0 ADB2UTCH ADB2WCL ADB2WIN ADB2WLDA ADB2WVL ADB2W1 ADB2W1B ADB2W1D ADB2W1I ADB2W1S ADB2W10 ADB2ZBA2 ADB2ZBH2 ADB2ZDC2 ADB2ZDL2 ADB2ZD1 ADB2ZD2 ADB2ZD3 ADB2ZD4 ADB2ZD5 ADB2ZD6 ADB2ZP ADB2ZP1 ADB2ZP1P ADB2Z2B1 ADB2Z2D2 ADB2Z2RD ADB2Z2RM ADB2Z2RS ADB2Z2T2 ADB2Z2U2 ADB2Z5L ADB2Z51 ADB2Z52 ADB2Z53 ADB2Z54 ADB2Z55 ADB2Z56 ADB2Z57 ADB20@ ADB21A ADB21C ADB21CDA ADB21CDC ADB21CDF ADB21CDG ADB21CDH ADB21CDI ADB21CDS ADB21CDT ADB21CPS ADB21CRH ADB21D ADB21DC ADB21DI ADB21DI2 ADB21DR ADB21DS ADB21DSN ADB21E ADB21ENV ADB21F ADB21G ADB21GA ADB21H ADB21I ADB21J ADB21K ADB21KD ADB21KE ADB21KSQ ADB21L ADB21M ADB21N ADB21O ADB21OJ ADB21OO1 ADB21OP ADB21P ADB21PD ADB21PE ADB21PL ADB21PM ADB21Q ADB21S ADB21SAR ADB21SAT ADB21SLH ADB21SLS ADB21SP ADB21SPH ADB21SS ADB21T ADB21TAC ADB21TC ADB21TDE ADB21TFK ADB21TH ADB21THD ADB21TIM ADB21TIN ADB21TN ADB21TNC ADB21TPH ADB21TPK ADB21TPS ADB21TRE ADB21TRH ADB21TRI ADB21TSE ADB21TXC ADB21V ADB21VV ADB21X ADB21XC ADB21XP ADB21XPH ADB21XPS ADB21XRH ADB21XS ADB21XSH ADB21Y ADB21Z ADB21ZDH ADB21ZDI ADB21ZDS ADB21ZPS ADB21ZRH ADB21ZX ADB22 ADB223T ADB230 ADB231 ADB231X ADB2310 ADB2311 ADB2311X ADB2312 ADB2312X ADB2313 ADB2314 ADB2314X ADB232 ADB233 ADB234 ADB235 ADB236 ADB237 ADB238 ADB239 ADB24 ADB25L ADB25LD ADB25LE ADB25T ADB25TL1 ADB26CTF ADB26CTP ADB26DDR ADB26DT ADB26Q ADB26QR ADB27 ADB27AC ADB27C ADB27CR ADB28ADD ADB28ASD ADB28ATD ADB28M ADB28MC ADB28MM ADB28M2 ADB28S ADB28T ADB28UL1 ADB3000
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK70330
UP11/08/04 P F108
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:
02 September 2011