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