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 number
II07609
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
1994-02-10
Closed date
1997-10-28
Last modified date
1997-10-28
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:
14 December 2020