Thema:

Kommentar:
: Hallo, : durch ein PTF gibt es neue DB2 UT Stati ... : : IBM APAR Database : Query words are surrounded by . The hyperlinks take you to the next or previous highlighted word. : APAR NUMBER: PQ20558 RESOLVED AS: COULD NOT REPRODUCE : ABSTRACT: : PQ20558: ENHANCE DISPLAY DATABASE() RESTRICT TO ALLOW THE SPECIFICATION : OF INDIVIDUAL RESTRICTIVE STATES TO DISPLAY : ORIGINATING DETAILS: : Enhance -DISPLAY DATABASE() RESTRICT to allow the specification : of individual restrictive states to display. : LOCAL FIX AS REPORTED BY ORIGINATOR: : RESPONDER SUMMARY: : **************************************************************** : * USERS AFFECTED: All users of the DB2 DISPLAY DATABASE * : * command. * : **************************************************************** : * PROBLEM DESCRIPTION: The customers need to extend Display * : * support so that more individual * : * restricted states can be explicitly * : * specified via the Display command. * : * For instance, some customers would * : * like to more easily generate a list of * : * objects needing to be copied by * : * restricting the display output to all * : * objects in a copy pending state. * : * There is also the same need for * : * other types of restricted states like * : * recover pending, reorg pending, etc. * : **************************************************************** : * RECOMMENDATION: * : **************************************************************** : Added the following parameters in the RESTRICT keyword for the : DISPLAY DATABASE command: : COPY : CHKP : RECP : RBDP : LPL : : REORP : GRECP : UT : UTRW : UTRO : UTUT : UT* : RO : STOP : . : Please note that a new restrict status, , was introduced by : this APAR for the object has write error page range information. : . : RESPONDER CONCLUSION: : TEMPORARY FIX: : COMMENTS: : The Display Database command code has been updated to support : the parameters of the RESTRICT keyword. : RESTRICT : Display objects that are in a restricted state. If there are : a list of objects listed within parentheses, then only those : objects which are in one of the listed restricted states are : displayed. : COPY : Display objects that are in copy pending : CHKP : Display objects that are in check pending. : RECP : Displays objects that are in recover pending. This includes : restricted states RECP, PSRCP, RECP*, LPL, and and : (Write Error Page Range). : RBDP : Displays index objects that are in rebuild or recover : pending includes restricted states RBDP, PSRCP, LPL, and : . : LPL : Displays objects that are in logical page list entries. : : Display objects that are in write error page range. : REORP : Displays objects that are in reorg pending. : GRECP : Displays objects that are in group buffer pool recover : pending. : RO : Displays object in read only mode. : UT : Display objects in utility access mode. : UTRW : Display objects that are serialized for utility access and : available for read/write access. : UTRO : Display objects that are serialized for utility access and : available for read access. : UTUT : Display objects that are serialized for utility access and : unavailable for other access. : UT* : Display objects that are in UT, UTRW, UTRO, or UTUT states. : STOP : Display objects that are stopped. This includes restricted : states STOP, STOPE, STOPP, and LSTOP. : The syntax of V51 DISPLAY DATABASE command is extended as : follows: : >>--DISPLAY--DATABASE--(---.-database-name-.---)--------------- : |-*-------------| : |-name1:name2---| : '-name*---------' : --SPACENAM--(---.-space-name--.---)--------------------------- : |-*-----------| : |-name1:name2-| : '-name*-------' : >--.-------------------------------------.--.-----.--.-------.- : | --.----------.--.-------.--.--------------------------.------- : '-CLAIMERS-' '-AFTER-' | .-50------. | : '-LIMIT--(--+-integer-+--)-' : '-*-------' : >--.---------------------------------.--.-----.---------------- : '-RESTRICT--.-------------------.-' '-LPL-' '-ACTIVE-' : | <-,-------< | : '-(---.-COPY--.---)-' : |-CHKP--| : |-RECP--| : |-RBDP--| : |-LPL---| : |-WEPR--| : |-REORP-| : |-GRECP-| : |-UT----| : |-UTRW--| : |-UTRO--| : |-UTUT--| : |-UT*---| : |-RO----| : '-STOP--'). : APAR INFORMATION: : Reported to correct a PTF in error: NO : Reported as a highly pervasive problem: NO : Reported as a duplicate problem: NO : PE Apar?: NoPE : HIPER Apar?: NoHIPER : DUP Apar?: NoDUP : Status: CLOSED UR1 : Component Name: 5740 IBM DATABA : Version: 510 : Component ID: 5740XYR00 : Submitted: 98/10/21 : Closed: 99/01/21 : Last Modified: 99/07/28 : Change Team: SJ4107 : FIX INFORMATION: : Reported release thought to contain the error: R510 : Applicable Component Levels: : R510 PSY UQ25726 UP99/02/05 P F902 : APAR is fixed by one or more of the following PTFs: : UQ25726 : APAR is sysrouted FROM one or more of the following items: : APAR is sysrouted TO one or more of the following items: : UQ25726

Optionale Link URL:   
Link Titel:                  
Optionale Image URL: