II07609: CHANGES TO DB2 SQL REFERENCE SC26-4890-00 THAT DID NOT MAKE THE VERSION 3 GA PUBS. CONTINUED IN II08226.

APAR status

• Closed as canceled.

Error description

• This Info. APAR documents changes to the DB2 SQL Reference
  SC26-4890-00 which did not make the Version 3 GA pubs.
  This Info. APAR is continued in II08226.
  5740xyr00 R310
  ================================================================
  Version 3 Book Title:  SQL Reference
  Pages: 49 and 50
  Change Description:
  
  Change the descriptions of database-name, plan-name,
  stogroup-name, and table-space-name from:
  
       "A short identifier that designates ......"
  To:
       "A short identifier that begins with a letter,
        followed by one to seven letters or digits, which
        designates ......"
  ================================================================
  Version 3 Book Title:  SQL Reference
  Pages:  63
  Change Description:
  
    Under 'Restrictions on the Use of LOCAL Datetime Formats',
    add the following text as a third bullet:
  
      When binding a package using the COPY option, a
      LOCAL date or time format specification will
      not be copied to the remote site.  The LOCAL format
      option is changed to ISO in the package at the
      remote site.
  ================================================================
  Version 3 Book Title:  SQL Reference
  Pages:  75
  Change Description:
  
  A maximum of 124 characters can be specified.
  ================================================================
  Version 3 Book Title:  SQL Reference
  Pages: 90
  Change Description:
  
  Replace the last paragraph on the page with:
  
  The use of DEC15 or DEC31 is an installation option and a
  precompiler option. The installation option applies to
  dynamic SQL and provides the default for the precompiler
  option.
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 122
  Change Description:
  
  Change the first bulleted paragraph to:
  
  If p is greater than 15 or the DEC31 option is in effect,
  P is 31 and S is MAX(0,28-p+s).
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 126
  
  Change the end of the sentence leading into the first
  bulleted paragraph to:
  
  argument values and the decimal precision option:
  
  Change the first bulleted paragraph to:
  
  If the precision of the argument values is greater than 15
  or the DEC31 option is in effect, the precision of the
  result is 31.
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 192
  Change Description:
  
  Add to the description of ADD VOLUMES:
  
  If the storage group is defined with one or more
  asterisks (*) listed after VOLUMES, listing one or more
  asterisks after ADD VOLUMES extends the first list.
  SMS uses as many volumes as there as asterisks in the
  concatentation of the two lists, to manage extension of
  data sets for shared read-only data.
  You cannot use both a volume-id and an asterisk in the same
  list after ADD VOLUMES.
  
  Add to the first paragraph under REMOVE VOLUMES:
  
  To remove volumes from a storage group that is defined
  with a list of asterisks, specify one asterisk for each
  volume you wish to remove from the list after
  REMOVE VOLUMES.
  ================================================================
  Book Title: SQL Reference
  Page Number: 205
  Change Description:
  
  At the bottom of the page, replace the four bullets that
  follow the statement 'Let S denote an SQL statement that
  refers to a table in the table space:' with these three
  bullets:
  
  '- The LOCKSIZE change will affect S if S is prepared and
   executed after the change.  This includes dynamic statements
   and static statements that are not bound with VALIDATE(RUN).
  
   - If the level of the new LOCKSIZE is greater than the level
  of the old LOCKSIZE, the change will affect S if S is a static
  statement that is executed after the change and S is either:
     - In a package, or
     - In a plan that is bound with ACQUIRE(USE).
  
   - In all other cases, the LOCKSIZE has no affect on S until
  S is rebound.'
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 245
  Change Description:
  
  Add to the description of VOLUMES:
  
  List more than one asterisk (*) after VOLUMES, as in
  VOLUMES('*','*','*'), for SMS to manage the extension of
  data sets for shared read-only data.
  SMS uses one volume for each asterisk in the list.
  You cannot use both a volume-id and an asterisk in
  the same list after VOLUMES.
  ================================================================
  Book Title: SQL Reference
  Page Number: 266
  Change Description:
  
  Under PRIQTY, preceding the last sentence in the first
  paragraph that begins 'To more closely ..', add this
  sentence:
  
  Note that the amount of storage space requested must be
  available on some volume in the storage group based on VSAM
  space allocation restrictions.
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 266
  Change Description:
  
  Add to the description of PRIQTY:
  
  When a data set in a simple or segmented table space
  reaches its maximum size of two gigabytes, DB2 might
  automatically create a new data set.  The primary data set
  allocation is obtained for each new data set.
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 278
  Change Description:
  
  The paragraph:
  
   WITH HOLD is ignored in CICS pseudo-conversational programs
   and IMS message driven programs (MPP, IFP, and message-
   driven BMP).
  
  will be replaced with:
  
   WITH HOLD is ignored in IMS message driven programs (MPP,
   and message-driven BMP).
   For details on restrictions that apply to declaring WITH
   HOLD cursors, see Section 3 of Application Programming and
   SQL Guide.
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 298
  Change Description:
  
  Add the following example:
  
  Example 5:  Drop the package DSN8CC0 with the version
  identifier "1994-07-14-09.56.30.196952".  When a version
  identifier is generated by the VERSION(AUTO) precompiler
  option, delimit the version identifier.
  
  DROP PACKAGE DSN8CC23.DSN8CC0 VERSION
  "1994-07-14-09.56.30.196952"
  ===============================================================
  Book Title: SQL Reference
  Page Number: 321
  Change Description:
  
  Change the last sentence in the paragraph describing
  ON DATABASE from 'however a grant of a privilege on DSNDB06
  implies the granting of the same privilege on DSNDB01.'
  to read 'however a grant of a privilege on
  DSNDB06 implies the granting of the same privilege on DSNDB01
  for utility operations only.'
  ================================================================
  Book Title: SQL Reference
  Page Number: 370
  Change Description:
  
  Add a third paragraph to the 'Notes' section:
  
  Revoking the use of all buffer pools does not ensure that
  the use of every individual buffer pool is revoked.
  The result of this revoke depends upon how the privelege to
  use a buffer pool was granted.
  A revoke of all buffer pools only cascades to priveleges
  that were obtained by a grant of all buffer pools.
  ================================================================
  Version 3 Book Title:  SQL Reference
  Pages:  393
  Change Description:
  
  Item                                          Limit
  ----                                          -----
  Maximum length of a graphic string constant   124 characters
  ================================================================
  Book Title: SQL Reference
  Page Number: 395
  Change Description:
  
  Remove the second item from the 'DB2 System Limits' table:
  
  Most temporary files active for a single agent   255
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 395
  Change Description:
  
  Add to the DB2 System Limits table:
  
  Item                                           Limit
  ----                                           -----
  Maximum simple or segmented data set size      2 gigabytes
  
  Maximum partitioned data set size
    1 to 16 partitions                           4 gigabytes
   17 to 32 partitions                           2 gigabytes
   33 to 64 partitions                           1 gigabytes
  ================================================================
  Book Title: SQL Reference
  Page Number: 434, 437, 440, 441
  Change Description:
  
  In each of these catalog tables:
  SYSIBM.SYSPACKAGE, SYSIBM.SYSPACKAUTH, SYSIBM.SYSPACKSTMT,
  and SYSIBM.SYSPKSYSTEM, replace the row:
  
     'Column Name    Data Type    Description     Use
        blank         CHAR(16)    Not used         N
                      NOT NULL
  with:
      Column Name    Data Type    Description     Use
        LOCATION      CHAR(16)    Not used         G '
                      NOT NULL
  ================================================================
  Page Number: 438
  Change Description:
  
  In the SYSIBM.SYSPACKDEP catalog table, replace the row:
     'Column Name    Data Type    Description     Use
        blank         CHAR(16)    Not used         N
                      NOT NULL
  with:
      Column Name    Data Type    Description     Use
       DLOCATION      CHAR(16)    Not used         G '
                      NOT NULL
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 451
  Change Description:
  
  Under the description of TRANSTYPE, add the GG value:
  
   GG  ASCII GRAPHIC to EBCDIC GRAPHIC
  ================================================================
  Book Title: SQL Reference
  Page Numbers: 459, 462
  Change Description:
  
  Remove the sentence that begins 'This includes any row
  transformed by an editproc ...' from the description of the
  PCTROWCOMP column in both the SYSTABLES and SYSTABSTATS
  catalog tables.
  
  Replace it with:
  
  This includes any row in a tablespace that is created or
  altered with data compression applied to the rows.
  ================================================================
  This info. APAR is continued in II08226.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• closed for internet viewing
  

APAR Information

• 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