IBM Support

II10279: CHANGES TO DB2 COMMAND REFERENCE SC26-3276-00, THAT DID NOT MAKE V4.1 GA PUBS. CONTINUATION OF II09145.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as canceled.

Error description

  • 5740xyr00 DB2 R410 V4
    This APAR documents changes to the DB2 Command Reference
    SC26-3267-00 which did not make Version 4.1 GA pubs.
    continuation of II09145.
    ================================================================
    Version 4 Book Title: Command Reference
    Page: 28
    Change Description:
    In the DSN Subcommand Parsing section, modify the second
    paragraph as follows:
    
    To continue a subcommand on the next line while using the
    DSN processor, type either a hyphen (-) or a plus sign (+)
    at the end of the current line. If you use a plus sign,
    precede it by at least one blank character to prevent the
    concatenation of character strings from line to line. Using
    a plus sign causes TSO/E to delete leading delimiters
    (blanks, commas, tabs, and comments) on the continuation
    line, and will reduce the overall size of the command.
    ============================================================
    Version 4 Book Title: Command Reference
    Page:35
    Change Description:
    The following sentence in the description of the
    CASTOUT(NO) option of the -ALTER BUFFERPOOL command
    is incorrect:
      "Prevents MVS from discarding data cached in the
       hiperpool unless expanded storage pages are
       reconfigured out of the system."
    
    Replace the above sentence with:
      "Tells MVS to assign a high priority to keeping
       the data cached in the hiperpool."
    ===========================================================
    Version 4 Book Title: Command Reference
    Page: 66
    Add the following information to the LIBRARY option
    description, just above "Defaults:"
    
    "For BIND PACKAGE, you can specify only one library to search.
    For BIND PLAN, you can specify one or more libraries to search."
    ============================================================
    Version 4 Book Title:  Command Reference
    Pages: 72 and 246
    
    Page 72:  Add the following sentence to RELEASE(DEALLOCATE):
    
    RELEASE(DEALLOCATE) can increase the package or plan size,
    because additional items become resident in the package or
    plan.
    
    Page 246:  Add the following sentence to the description of
    AT(COMMIT):
    
    Specify AT(COMMIT) to break in on threads that are bound
    with RELEASE(DEALLOCATE), especially in situations where
    there is high thread reuse.
    ============================================================
    Version 4 Book Title:  Command Reference
    Page:  103
    Change Description:
    Add a new Usage Note:
    
    Displaying Restricted Objects:  To display all resources
    that are in restricted status, you must issue the
    DISPLAY DATABASE command twice.  To display table spaces
    and indexes in restricted status, use the SPACENAM
    parameter with RESTRICT.  To display databases in
    restricted status, do NOT use the SPACENAM parameter.
    Spaces could be unavailable even if they show RW mode
    if the database is in restricted status.
    ============================================================
    Version 4 Book Title: Command Reference
    Page: 142
    Change Description:
    In the DSN (TSO) command section:
    
    Add the group-attachment-name keyword as an option to the
    syntax diagram:
    
      >>--DSN------------------------------------------------->
               |           ---DSN---------------------     |
               '-SYSTEM-(--|--subsystem-name---------|--)--|
    |                      `--group-attachment-name--'
    
    Also, add the group-attachment-name definition to the Option
    Description section under the SYSTEM keyword:
    
    | group-attachment-name specifies the group attachment name
    | of the data sharing group.
    |
    | If you do not supply the subsystem name or group
    | attachment name, the default is SYSTEM(DSN). This value
    | can be modified during DB2 installation.
    ============================================================
    Version 4 Book Title: Command Reference
    Pages: 189
    Change Description:
    
    In the "MODIFY irlmproc,STATUS (MVS IRLM)" section, remove
    the following paragraph under the "Usage Notes" heading:
    
    "No Communication during Command Processing: No
    communication is involved in the processing of the
    STATUS command. Therefore, if the sharing state is COMM,
    irlmproc cannot have the latest information relating to the
    subsystems connected to irlmx."
    ============================================================
    Version 4 Book Title: Command Reference
    Pages: 192
    Change Description:
      Modify the third bullet under the description of MODIFY
       TRACE to delete an incorrect statement about MODIFY
       beginning a new statistics interval. The bullet should
       read as follows:
    
       'Writes statistics records.'
    ============================================================
    Version 4 Book Title: Command Reference
    Page: 195
    Change Description:
    In REBIND PACKAGE, change the second sentence of the second
    paragraph on this page to:
    
    "You should use BIND PACKAGE with the ACTION(REPLACE)
    option under the following conditions:
         * When you change the SQL statements
         * When you recompile the program
         * You previously ran BIND PACKAGE with the
           SQLERROR(CONTINUE) option"
    ============================================================
    Version 4 Book Title: Command Reference
    Pages: 221
    
    Change Description:
    Replace first paragraph under "Restricted Mode (RO and UT)
    with:
    When a START DATABASE command for a restricted mode (RO
    and UT) takes effect depends upon whether applications
    are started after -START DATABASE has completed, or whether
    applications are executing at the time the command is issued.
    For applications started after -START DATABASE has completed,
    access restrictions are effective immediately.  For
    applications executing at the time -START DATABASE is issued,
    the access restrictions take effect when a subsequent claim
    is requested or the application is allowed to run to
    completion.  Whether the application is interrupted by the
    -START DATABASE command depends upon various factors.
    These factors include the ACCESS mode specified on the
    -START DATABASE command, the type of drain activity, if any,
    on the table space or partition, and whether there are held
    cursors on the table space or partition.
    ============================================================
    Version 4 Book Title:  Command Reference
    Pages:  228
    Change Description:
    
    Replace the following sentences under MAXCSA=nn:
    
    The number indicates what multiple of 100KB of CSA storage
    the IRLM will use.  For example MAXCSA=30 allows the IRLM
    to use 3000KB (3 megabytes) of ECSA.
    
    With the following sentences:
    
    The number indicates what mutliple of 1MB of storage the
    IRLM will use.  For example, MAXCSA=3 allows the IRLM to
    use 3MB of CSA and ECSA.
    ============================================================
    Version 4 Book Title: Command Reference
    Pages: 228
    Change Description:
    
    IRLMID=n
    
    | "n can be either a 1- to 3-digit number from 1 to 255, or
    | a printable character in quotation marks.  Note that this
    | IRLM ID does not relate directly to the limit of IRLM
    | members that can be in the group.  That limit is determined
    | by the current hardware limits (currently 32).
    
      When n is specified as a printable character, IRLM
      uses the EBCDIC value of the printable character
    | as the IRLMID (such as X'C4').
    | The printable character must be surrounded by enough
    | single quotes to permit IRLM to see it as a printable
    | character. Because of the way MVS interprets quotes,
    | there must be seven quotes on either side of the
    | characters. For example, if you want to specify the
    | printable character 'D', you must specify it here as
    | IRLMID='''''''D'''''''.
    ============================================================
    Version 4 Book Title: Command Reference
    Page: 248
    
    Change Description: The following table summarizes the
    locking used by the STOP DATABASE command.
    
    Table. Locking used by the STOP DATABASE command
    
    Command | Table space type |     | Serialization
    --------------------------------------------------
    STOP    |Partitioned       |PART | Drain-all on
    AT      |                  |     | partition
    COMMITT |                  |     | specified.
            |                  |-----|----------------
            |                  |     | Drain-all on
            |                  |     | all partitions.
            |------------------|-----|----------------
            |Non-partitioned   |     | Drain-all on
            |                  |     | table space.
    --------------------------------------------------
    STOP    |Partitioned       |PART | X-lock table
            |                  |     | space.
            |                  |     | Drain-all on
            |                  |     | partitions
            |                  |     | specified.
            |                  |-----|----------------
            |                  |     | X-lock table
            |                  |     | space.
            |                  |     | Drain-all on
            |                  |     | all partitions.
            |------------------|-----|----------------
            |Non-partitioned   |     | X-lock table
            |                  |     | space.
             |                  |     | Drain-all on
             |                  |     | all partitions.
     --------------------------------------------------
     ============================================================
    Version 4 Book Title:  Command Reference
    Pages: 250
    Change Description:
    Add a description under the MODE(FORCE) option as follows:
    
    Some tasks, such as stored procedures tasks and DB2 service
    tasks, terminate abnormally.  When they terminate abnormally,
    you might see dumps and messages from these failures.
    ============================================================
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • close for INTERNET viewing
    

APAR Information

  • APAR number

    II10279

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    CLOSED CAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    1997-02-18

  • Closed date

    1997-11-01

  • Last modified date

    1999-11-23

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 November 1999