PM95731: NEW FUNCTION FOR DB2 10 FOR Z/OS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function for DB2 10 for z/OS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users who need the       *
  *                 capability to keep a table space partition   *
  *                 in a persistent read only status.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Enabling APAR for new function:  A new  *
  *                      restricted status PRO, Persistent Read  *
  *                      Only status, is added for table space   *
  *                      partitions. Read access is allowed,     *
  *                      but updates are prohibited for table    *
  *                      space partitions in PRO status.         *
  *                      ..                                      *
  *                      The preconditioning APAR for this new   *
  *                      function is PM95478.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A new restricted status, PRO, which stands for Persistent Read
  Only status, is added for table space partitions.  Read access
  is allowed, but updates are prohibited.  The PRO status is
  persistent because the -STOP DB and -START DB commands do not
  affect it, these commands do not turn on or turn off the PRO
  status.
  ..
  Behavior for table space partitions in PRO restricted status:
  -DB2 will issue SQLCODE -904 with a new resource unavailable
   reason code, RC00C90635, when a SQL INSERT is attempted on a
   table space partition in PRO restricted status.
  -SQL UPDATE or DELETE operations on a table space partition in
   PRO restricted status has the same behavior as if the
   partition was started for RO (read only) access.
  -If the UPDATE or DELETE has a predicate with a value that
   qualifies to the partition in PRO state and the partition is
   empty, then it will succeed with SQLCODE000 with zero rows
   updated or deleted.
  -If the UPDATE or DELETE has a predicate with a value that
   qualifies to the partition in PRO state and the partition
   contains data, then it will fail with SQLCODE -904 RC00C90635.
  -DELETEs without a predicate (or SQL TRUNCATE TABLE) when a
   partition is in PRO state will fail with SQLCODE -904
   RC00C90635.
  -SQL ALTER TABLE ROTATE PARTITION will fail with SQLCODE -904
   RC00C90635 if the partition to be rotated is in PRO state.
  ..
  Display database command support:  The output messages from the
  -DIS DB command will display table space partitions in the PRO
  status.
  ..
  Utilities support:
  -Utilities attempting to update partitions in PRO status will
   receive a new error message.
  -REPAIR - turn on or turn off PRO status on a table space
   partition.
  -MODIFY RECOVERY - when a partition is in PRO status, it must
   be executed at the partition level and will force RETAIN
   LAST(2) to keep the two most recent full image copies.
  -COPY - when a partition is in PRO status, image copies will
   not be taken and a new informational message will be issued.
  ..
  Recommended procedure for setting the PRO restricted status on
  a table space partition:
  1. -STOP DB() SP() PART() - wait for the command to complete
     successfully, verify that the object is in STOP status
     (not STOPP) with the -DIS DB command.
  2. -START DB() SP() PART() ACCESS(UT)
  3. Create two full image copies of the table space partition
     with COPY SHRLEVEL REFERENCE
  4. Use REPAIR utility to turn on PRO status
  5. -START DB() SP() PART() ACCESS(RW)
  
  Additional Keywords:
  IDAAV4R1/K
  

Problem conclusion

Temporary fix

Comments

• This APAR introduces the following changes:
  ..
  -DISPLAY DATABASE command:
  The -DISPLAY DATABASE command will display the PRO status for
  table space partitions.  Ojbects in PRO status will be displayed
  for -DISPLAY DATABASE ... RESTRICT.  The PRO status will be
  accepted as one of the restricted states for the -DIS DB command
  RESTRICT option:
             +- , --------+
             |            |
  RESTRICT ( --         --| )
               |- PRO -|
  The explanation for messages issued by the -DIS DB command,
  DSNT389I and DSNT806I, will be updated in the DB2 Messages
  manual to include:
    PRO  Persistent Read Only restrictive status.  Read access to
         the table space partition(s) are allowed.  Updates to
         the table space partition(s) in PRO status are
         prohibited.
  ..
  -STOP DATABASE and START DATABASE commands support:
  When the -STOP DATABASE or -START DATABASE commands are executed
  on a table space partition in PRO status, the PRO restricted
  status will not be affected.  The PRO status will remain on.
  The -START DATABASE command with the ACCESS(FORCE) option
  will not turn off the PRO restricted status.
  ..
  Utilities support:
    Utilities attempting to update table space partitions in a PRO
  restricted status will issue a new error message, DSNU1425I -
  PRO RESTRICTED STATE ON object-type object-qualifier.object-name
  PROHIBITS PROCESSING, during serialization in the UTILINIT
  phase.
    Recommendation:  When one or more partitions of a table space
  have been placed in PRO status, then utilities should be
  executed at the partition level because the PRO restricted
  partitions cannot be processed in the same way as R/W parti-
  tions.
    For example, utilities run at the table space level which
  require updates such as REORG at the table space level will
  fail when one or more partitions are in PRO status.
  ..
  REPAIR utility:
  New syntax to turn on PRO:
    REPAIR SET TABLESPACE db-name.tsname PART n PRO
  New syntax to turn off PRO:
    REPAIR SET TABLESPACE db-name.tsname PART n NOPRO
  The PART option is required when PRO or NOPRO is specified.
  Use of this new REPAIR syntax is allowed only in DB2 10 NFM
  or higher.
  ..
  COPY and MODIFY RECOVERY utilities:
    If COPY and MODIFY RECOVERY are executed at the table space
  level (DSNUM ALL) and one or more partitions are in PRO status,
  then a new error message, DSNU1424I - utility UTILITY MUST BE
  EXECUTED AT THE PARTITION LEVEL ON object-type
  object-qualifier.object-name IN PRO RESTRICTED STATE, will be
  issued.
    COPY DSNUM(n) on a partition in PRO status will issue a new
  informational message, DSNU1423I - utility  UTILITY WILL NOT
  PROCESS object-type object-qualifier.object-name PARTITION part
  IN PRO RESTRICTED STATE, and will not create a new image copy of
  the partition.  A new image copy will not be created because it
  is assumed that if a table space partition is in PRO status, a
  new image copy is not needed because no updates have been made.
    MODIFY RECOVERY DSNUM(n) on a partition in PRO status will
  override and force the deletion criteria to RETAIN LAST(2) to
  always keep the two most recent image copies.  The AGE, DATE, or
  RETAIN option that was specified will be ignored and overridden,
  unless RETAIN LAST was specified with a value higher than 2.
  A new warning message, DSNU1422I - DELETE CRITERIA IS IGNORED
  AND RETAIN LAST(2) IS IN EFFECT DUE TO PRO RESTRICTED STATE ON
  object-type object-qualifier.object-name PARTITION part, will be
  issued.
  ..
  New reason code:
  00C90635
  Explanation:  An attempt was made to allocate to a table space
  partition for update operations.  However, the table space
  partition is in a Persistent Read Only (PRO) restricted status,
  and updates are not allowed.  This condition occurs as a result
  of previously using the REPAIR utility to set the PRO restricted
  status for the purpose of prohibiting updates.
  System action:  The allocation process is not allowed.
  User response:  Check with the DB2 system administrator and the
  database administrator.  Do not remove the PRO restricted status
  without their consent because updates to the data may cause data
  loss.
  Problem determination: The requested operation is not performed.
  An SQLCODE -904 and/or message DSNT501I is issued. For more
  information, refer to the SQL return code in Codes, or to the
  description of the DSNT501I message in Messages.
  ..
  New Utility messages:
  ..
  DSNU1420I csect-name -SET status OPERATION SUCCESSFUL
  Explanation:  This message reports the successful completion of
  the REPAIR SET TABLESPACE utility operation.
    status  PRO
  REPAIR SET TABLESPACE PRO was specified, and the Persistent
  Read Only (PRO) restricted status has been turned on for the
  specified table space partition.
    status  NOPRO
  REPAIR SET TABLESPACE NOPRO was specified, and the Persistent
  Read Only (PRO) restricted status has been turned off from the
  specified table space partition.
  Warning:  Do not remove the PRO restricted status without the
  consent of the DB2 system administrator or database administra-
  tor because updates to the partition may cause data loss.
  System action:  The REPAIR utility has completed normally.
  User response:  No action is required.
  Severity:  0 (informational)
  ..
  DSNU1421I csect-name -TABLESPACE  object-type
  object-qualifier.object-name PART= part IS IN PRO RESTRICTED
  STATE
  Explanation:  This message is issued when:
  -the REPAIR utility has previously been used to set the
   Persistent Read Only restricted status
  -read only operations by a utility have occurred on a partition
   in PRO restricted status
  System action:  Utility processing on the object has completed
  normally.
  User response:  No action is required.  Do not remove the PRO
  restricted status without the consent of the DB2 system
  administrator or database administrator because updates to the
  partition may cause data loss.
  Severity:  4 (warning)
  ..
  DSNU1422I csect-name - DELETE CRITERIA IS IGNORED AND RETAIN
  LAST(2) IS IN EFFECT DUE TO PRO RESTRICTED STATE ON object-type
  object-qualifier.object-name PARTITION part
  Explanation:  The MODIFY RECOVERY utility was executed on a
  table space partition in Persistent Read Only (PRO) restricted
  state.  The two most recent full image copies for the partition
  will be retained along with the SYSIBM.SYSLGRNX records for the
  partition. This condition occurs as a result of previously
  using the REPAIR utility to set the PRO restricted status for
  the purpose of prohibiting updates.
  System action:  Utility processing on the object is terminated.
  User response:  No action is required.  Do not remove the PRO
  restricted status without the consent of the DB2 system
  administrator or database administrator because updates to the
  partition may cause data loss.
  Severity:  4 (warning)
  ..
  DSNU1423I csect-name - utility UTILITY WILL NOT PROCESS
  object-type object-qualifier.object-name PARTITION part IN PRO
  RESTRICTED STATE
  Explanation:
    utility     COPY
  The COPY utility was executed on a table space partition in
  Persistent Read Only (PRO) restricted status.  An image copy
  will not be created for this partition due to the PRO status.
  This condition occurs as a result of previously using the REPAIR
  utility to set the PRO restricted status for the purpose of
  prohibiting updates.
  System action:  The table space partition has not been
  processed.
  User response:  No action is required.  Do not remove the PRO
  restricted status without the consent of the DB2 system
  administrator or database administrator because updates to the
  partition may cause data loss.
  Severity:  0 (informational)
  ..
  DSNU1424I csect-name -  utility UTILITY MUST BE EXECUTED AT THE
  PARTITION LEVEL ON object-type object-qualifier.object-name DUE
  TO PRO RESTRICTED STATE
  Explanation:
    utility     COPY or MODIFY RECOVERY
  An attempt was made to execute the COPY or MODIFY RECOVERY
  utility at the table space level (DSNUM ALL option) against
  a table space with one or more partitions in the Persistent
  Read Only (PRO) restricted state.
  This condition occurs as a result of previously using the REPAIR
  utility to set the PRO restricted status for the purpose of
  prohibiting updates.
  System action:  Utility processing on the object is terminated.
  User response:  Execute the COPY and MODIFY RECOVERY utilities
  at the partition level using the DSNUM n option or by using a
  LISTDEF list with the PARTLEVEL option. Do not remove the PRO
  restricted status without the consent of the DB2 system
  administrator or database administrator because updates to the
  partition may cause data loss.
  Severity:  8 (error)
  ..
  DSNU1425I csect-name PRO RESTRICTED STATE ON object-type
  object-qualifier.object-name PROHIBITS PROCESSING
  Explanation:  An attempt was made to execute a utility against
  a table space partition  in the Persistent Read Only (PRO)
  restricted state, and updates are not allowed. This condition
  occurs as a result of previously using the REPAIR utility to
  set the PRO restricted status for the purpose of prohibiting
  updates.
  System action:  Utility processing on the object is terminated.
  User response:  Check with the DB2 system administrator or
  database administrator.  Do not remove the PRO restricted state
  without their consent because updates to the partition may cause
  data loss.
  Severity:  8 (error)
  ..
  Note:  The documentation updates above are subject to change.
  ..
  Warning:  In a data sharing group, if the pre-conditioning
  PTF is not applied to all members and the new PRO status is
  turned on from a member with the enabling PTF applied, then
  the members without the preconditioning PTF will not recog-
  nize the PRO status and updates will be allowed.
  ..
  Additional keywords:  MSGDSNT389I MSGDSNT806I MSGDSNU1420I
  MSGDSNU1421I MSGDSNU1422I MSGDSNU1423I MSGDSNU1424I MSGDSNU1425I
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI12323

Modules/Macros

• DSNUCBRL DSNUFCMN DSNUGDDN DSNUGPRT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI12323

     UP13/11/27 P F311

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.