A fix is available
APAR status
Closed as new function.
Error description
NFDB210 IBM INTERNAL
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS that use DB2 column masks or * * row permissions. * * * * Users of the DB2 Administration Tool for * * z/OS who wish to copy privileges from * * one set of objects to another set of * * objects. * * * * Users of the DB2 Administration Tool's * * authorization switching function * * (ADBTEPA). * * * * Users of DB2 Administration Tool's * * Change Management function. * * * * Users of the DB2 Administration Tool * * for z/OS that use the ADB21 'System * * Catalog' panel to show views. * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Administration Tool does * * not support creating or dropping * * column masks or row permissions. * * * * The "Copy Privileges" capability was * * added to the object display panels * * ADB21A, ADB21D, ADB21E, ADB21F, * * ADB21G, ADB21H, ADB21O, ADB21Q, * * ADB21S, ADB21T, ADB21VV, as well * * as to the version scope panel * * ADB2C42 and the GRANT privileges * * panel ADB2G. This capability may be * * used to copy privileges held on one or * * more objects to another set of objects. * * * * The authorization switching function * * (load module ADBTEPA) has been * * enhanced to support DB2 V10 DDL * * that requires SECADM authority. * * In addition, it has been enhanced to * * allow running of utilities in the input * * stream (similar to what ADBTEP2 * * allows). In order to use the new * * authorization switching function, * * a new load module ADBTEPX must * * be called, which in turn calls * * APF-authorized load module ADBTEPA. * * * * The ALT function, when used with * * Change Management, has been * * enhanced to allow one to specify * * how truncated data should be handled. * * This capability was previously only * * available in ALT when Change * * Management was not being used. * * * * The panel that shows views * * list the DBNAME and TSNAME * * from the SYSTABLES catalog * * table but in some instances, * * those values are only partially * * correct. Views can be built * * with tables in different * * databases and/or table * * spaces so these values * * shown are misleading. * **************************************************************** * RECOMMENDATION: APPLY PTF. * **************************************************************** Column masks and row permissions are new functions in DB2. The DB2 Administration Tool for z/OS only supports listing column masks and row permissions. The "Copy Privileges" enhancement was added to allow copying of object privileges from one set of objects to another. The authorization switching function (ADBTEPA) has been enhanced to support DB2 Version 10 DDL which require SECADM authority. The truncation option panel ADB27CT may now be displayed and used in ALT when using Change Management. In some instances, the panel showing views shows only one DBNAME and TSNAME even though the view is based on objects in multiple databases and/or multiple table spaces.
Problem conclusion
Temporary fix
Comments
Support to create and drop column masks and row permissions has been added. A new panel, ADB21VV 'Views', is created to show views. If the view is based on objects that reside in different databases and/or different table spaces, the DBNAME and TSNAME fields is displayed with the characters, '++++++++'. Also, the new panel shows the CHECK OPTION of the view and the number of tables that created the view. The enhancements have been delivered.
APAR Information
APAR number
PM27184
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-11-20
Closed date
2011-02-01
Last modified date
2011-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBASW ADBASWSI ADBASW1 ADBA1TC ADBA1TG ADBA1TH ADBA1TM ADBA1TP ADBA1TV ADBA1TX ADBBIND ADBBND01 ADBCCMM ADBCDTS ADBCDTW ADBCIMU ADBCIMV ADBCP ADBCRCA ADBCRCM ADBCRCR ADBCVIC ADBCVSE ADBCVSX ADBC04 ADBC12 ADBDICT ADBEALT ADBECP ADBEIPV6 ADBEQTAB ADBEZ52 ADBGAJOB ADBHAC ADBHAD ADBHAG ADBHAH ADBHAK ADBHAL ADBHAO ADBHAP ADBHAQ ADBHAR ADBHAS ADBHAT ADBHCP ADBHG ADBHMEX ADBHUSC ADBHUSE ADBHUSK ADBHUSM ADBHUSN ADBHUSO ADBHUSQ ADBHUSR ADBHUSU ADBHUSV ADBHUS2 ADBHUTC ADBHUX ADBHUXK ADBHUXN ADBHUXO ADBHUXR ADBHUXV ADBHZBH2 ADBHZSB ADBHZSR ADBHZ2RI ADBHZ2RM ADBHZ2RS ADBHZ52U ADBHZ57U ADBH1 ADBH1A ADBH1CDH ADBH1D ADBH1I ADBH1J ADBH1KD ADBH1N ADBH1PD ADBH1Q ADBH1REM ADBH1S ADBH1SP ADBH1SSI ADBH1T ADBH1TA ADBH1TDE ADBH1TH ADBH1TN ADBH1TPS ADBH1TSE ADBH1TUP ADBH1VV ADBH1X ADBH1XA ADBH1XAR ADBH1XPS ADBH1Y ADBH5L ADBH5TU ADBH6CCM ADBH6CC0 ADBH6CFR ADBH6CFV ADBH6CJ ADBH6CO ADBH6COU ADBH6COV ADBH6COW ADBH6CPM ADBH6CQ ADBH6CT ADBH6CTB ADBH6CTF ADBH6CTP ADBH6CTQ ADBH6CTS ADBH6CTU ADBH6CUU ADBH6CX ADBH6TOP ADBH8M ADBMAIN ADBMSG ADBMSGT ADBNSPB ADBPALT ADBPCP ADBPDEC ADBPQTAB ADBPTAP ADBPTAV ADBP1PMA ADBP6CCM ADBP6CC0 ADBP6CPM ADBP6CTB ADBP9000 ADBRRAC ADBSALT ADBSCP ADBTCHK ADBTCL ADBTEPA ADBTEPR ADBTEP2 ADBTIMC ADBTREL ADBTREO ADB0001 ADB2AC ADB2ACI1 ADB2AD ADB2ADI1 ADB2AEI1 ADB2AG ADB2AGI1 ADB2AHI1 ADB2AK ADB2AKI1 ADB2AL ADB2ALI1 ADB2ALL0 ADB2AOI1 ADB2AP ADB2API1 ADB2AQI1 ADB2AR ADB2ARI1 ADB2AS ADB2ASI1 ADB2AT ADB2ATI1 ADB2AUH ADB2A2WS ADB2CCR ADB2CCT ADB2CCV ADB2CID ADB2CJAB ADB2CJDB ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CR0 ADB2C1 ADB2C12 ADB2C2 ADB2C22 ADB2C3 ADB2C4 ADB2C42 ADB2C44 ADB2C6 ADB2DIPD ADB2EMAC ADB2G ADB2IGN ADB2LINE ADB2M ADB2MES ADB2MESG ADB2MEX ADB2MEXG ADB2MSK ADB2MSP ADB2M1 ADB2M1M ADB2M1S ADB2M1SI ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2PRP ADB2PSQL ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2REP6 ADB2RER ADB2REZ ADB2SPFB ADB2TEP ADB2UCU2 ADB2UCU3 ADB2UOPS ADB2UOPT ADB2US ADB2USE ADB2USK ADB2USKL ADB2USKO ADB2USM ADB2USN ADB2USO ADB2USOF ADB2USOO ADB2USOP ADB2USOW ADB2USO1 ADB2USO2 ADB2USQ ADB2USU ADB2USV ADB2USVG ADB2USVO ADB2USV1 ADB2US0 ADB2US2 ADB2UTC ADB2UTIL ADB2UTLX ADB2UTZ ADB2UT0 ADB2UUOP ADB2UX ADB2UXB ADB2UXBO ADB2UXK ADB2UXO ADB2UXOO ADB2UXO1 ADB2UXO2 ADB2UXR ADB2UXV ADB2UXVO ADB2UX2 ADB2WL ADB2WL4 ADB2WVL ADB2W1 ADB2W1B1 ADB2ZBA ADB2ZBAA ADB2ZBA2 ADB2ZBD ADB2ZBH ADB2ZBH2 ADB2ZD ADB2ZDL ADB2ZD1 ADB2ZD1U ADB2ZP ADB2ZP1U ADB2ZSB ADB2ZSR ADB2ZZ ADB2Z2D ADB2Z2RI ADB2Z2RM ADB2Z2RS ADB2Z2RU ADB2Z2Z ADB2Z5 ADB2Z5L ADB2Z5LU ADB2Z51U ADB2Z52U ADB2Z53U ADB2Z54U ADB2Z55U ADB2Z56U ADB2Z57U ADB21 ADB21A ADB21C ADB21CDI ADB21CM ADB21CPS ADB21CUR ADB21D ADB21DA ADB21DAJ ADB21DI ADB21DI1 ADB21DI2 ADB21E ADB21EI1 ADB21F ADB21FKI ADB21G ADB21GA ADB21GI1 ADB21H ADB21I ADB21KD ADB21KF ADB21M ADB21MI1 ADB21N ADB21O ADB21OJ ADB21OJI ADB21OP ADB21PB ADB21PD ADB21PDI ADB21PM ADB21Q ADB21QI1 ADB21S ADB21SAL ADB21SAU ADB21SAX ADB21SAY ADB21SI1 ADB21SP ADB21SSI ADB21SUR ADB21T ADB21TA ADB21TAU ADB21TAV ADB21TC ADB21TH ADB21THD ADB21THI ADB21TIM ADB21TI5 ADB21TI9 ADB21TN ADB21TPI ADB21TPS ADB21TR ADB21TSE ADB21TXC ADB21TXR ADB21VV ADB21VVI ADB21VV0 ADB21X ADB21XAR ADB21XAS ADB21XAV ADB21XC ADB21XP ADB21XPI ADB21XPS ADB21XSD ADB21XSI ADB21XUR ADB21Y ADB21YI1 ADB221E ADB222E ADB223 ADB23 ADB230 ADB231X ADB2311 ADB2311X ADB2312 ADB2312X ADB2313 ADB2314I ADB2314T ADB233 ADB236 ADB237 ADB238 ADB239 ADB25 ADB25L ADB25LA ADB25LD ADB25LE ADB25LEA ADB25LU ADB25LUO ADB25TL1 ADB25TU ADB25TU4 ADB26 ADB26CA ADB26CD ADB26CFO ADB26CFV ADB26CFX ADB26CFY ADB26CG ADB26CJ ADB26CL ADB26CNA ADB26CO ADB26COQ ADB26COU ADB26COV ADB26COW ADB26CQ ADB26CRT ADB26CS ADB26CSU ADB26CT ADB26CTF ADB26CTP ADB26CTQ ADB26CTS ADB26CTU ADB26CUU ADB26CX ADB26CXU ADB26CY ADB26DD ADB26DS ADB26DT ADB26RT ADB26TOP ADB27 ADB27AC ADB27C ADB27CAA ADB27CF ADB27CFU ADB27CMR ADB27CT ADB27CU ADB27CX ADB27IFF ADB27M ADB27PTR ADB27SP ADB278C1 ADB28CR ADB28HPU ADB28MCT ADB28M2 ADB28SE ADB28T ADB28UL1 ADB28USK ADB28UT ADB3000 ADB33 ADB46 ADB5000 ADB52 ADB53 ADB56 ADB57 ADB6000 ADB7000 ADB74 ADB75 ADB8000 ADB9000 H0IHA10J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK64491
UP11/02/06 P F102
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 March 2011