APAR status
Closed as canceled.
Error description
This apar documents changes to the DB2 Administration Guide Volume I which did not make the GA R230 Pubs. 5740xyr00 sc26-4374-02 ac26437402 ============================================================ DB2 Admin. Guide Volume 1 SC26-4374-02 on page 2-50 table 29 the number of datasets multiplied by 3K is incorrect, it should read: number of datasets multiplied by .3K . ============================================================= DB2 Admin. Guide Volume 1 SC26-4374-02 on page 2-52 table 31 category - code size (4 address spaces) with virtual storage size of 5200K does not match code size of 4200K in table 30 on the previous page. This is because table 31 category should say code size + 1000 (for the 4 address spaces) with virtual storage size 5200K. category - working storage + (DSCF + DDF) but DSCF is not defined. DSCF is another name for MSTR address space. DDF is another name for the DIST address space. ============================================================== Admin. Guide Volume 1 SC26-4372-02 page 2-53 table 32 sort pool factor is incorrectly listed as .5, it should be listed as 1.0 category - code size (4 address spaces) should be listed as code size + 1000 (for 4 address spaces) with virtual storage size of (4200 + 1000) or 5200K. category - working storage + (DSCF + DDF) DSCF is not defined. DSCF is another name for MSTR address space. DDF is another name for DIST address space. ============================================================== In the Administration Guide Vol I on page 2-71, replace the last line on with: Expect a return code of 4 from this job. Also expect the following linkedit error messages, which will cause linkedit return codes of 8: ============================================================ On page 2-72, message MSGGIM6731 should be MSGGIM67301. Add DSNCSM21 and DSNCSM31 to list of modules receiving MSGIEW0642. ============================================================== Book Title: DB2 Administration Guide, Volume I (SC26-4374-02) Page Number: 2-85 The acceptable values in the CATALOG ALIAS field on panel DSNTIPA2 should read "1-8 characters". ============================================================== Book Title: DB2 Administration Guide, Volume I (SC26-4374-02) Page Number: 2-87 Add the following to the end of the second paragraph under the description of "DEFINE CATALOG" : The alias you defined in field 1 is used to build the catalog name, but the high-level qualifier of the catalog name cannot be the same as the alias. DB2 changes the high-level qualifier by adding a 1 to the end of the name if the name has less than eight characters. If the name has eight characters, DB2 changes the last character of the high-level qualifier into a 1. If the last character was already a 1, DB2 changes the 1 into a 2. ============================================================ On page 2-87 for fields 3-9, the DB2 install Clist does not support SMS for these fields. Only valid volume serial num- bers can be specified for these fields. ============================================================ In the Administration Guide, Vol. I, page 2-93: The timestamp format as shown is not the format of the suffix to the archive log data set prefix. The suffix has the format: ".Dyyddd.Thhmmsst". ================================================================ Book Title: Administration Guide, Sect. 2: 'Planning and Installing DB2', SC26-4374-02 Page Number: 2-100 Change Description: In the second paragraph after the numbered list, replace the sentence 'If you do not have COBOL at your site ...' with 'If you do not have OS/VS COBOL at your site ...' ================================================================ Book Title: Administration Guide, Sect. 2: 'Planning and Installing DB2', SC26-4374-02 Page Number: 2-100 Change Description: Replace the last paragraph with: 'If you do not have VS COBOL II at your site, remove the DSNHCOB2 procedure from job DSNTIJMV and the statement that renames the procedure from jobs DSNTIJFV and DSNTIJMV. If neither OS/VS COBOL nor VS COBOL II is installed on your system, do not run jobs DSNTEJ2C, DSNTEJ3C, DSNTEJ4C, DSNTEJ5C, or DSNTEJ6.' ============================================================ On page 2-157 add to the paragraph that begins "The DSNTINST CLIST uses the values .....", the following statements 'The DSNTINST CLIST does not support the use of SMS for those installations that are completely controlled by SMS. Verify that the input to the IDCAMS steps do NOT conflict with any requirements for SMS.' ================================================================ On page 2-161, after the third paragraph add the following statement. When you execute DSNTINST in UPDATE mode, the datasets listed on panel DSNTIPT on page 2-95 of this manual, will be over-written. The only dataset you can rename in UPDATE mode is prefix.NEW.DSNSAMP. ================================================================ Book Title: Administration Guide, Sect. 2: 'Planning and Installing DB2', SC26-4374-02 Page Number: 2-162 Change Description: Add the following bullet to the bottom of the page: o To UPDATE DB2 to use the distributed data facility (DDF), follow these steps: 1. Go through the normal UPDATE process of running the CLIST to add DDF information to installation panel DSNTIPR. 2. Run job DSNTIJUZ. 3. Create the Communications Database (CDB). You can use step DSNTIJD of job DSNTISG to do this. 4. Populate the CDB. 5. Stop and Start DB2. 6. Bind or rebind these plans: BIND PLAN(DSNESPCS) PKLIST(*.DSNESPCS.DSNESM68) ISOLATION(CS) ACTION(REPLACE) BIND PLAN(DSNESPRR) PKLIST(*.DSNESPRR.DSNESM68) ISOLATION(RR) ACTION(REPLACE) 7. Start DDF if you specified COMMAND instead of AUTO as the DDF STARTUP OPTION on installation panel DSNTIPR. ========================================================= Book Title: Administration Guide, Sect. 2: 'Planning and Installing DB2', SC26-4374-02 Page Number: 2-165 Change Description: Replace the last sentence in the first bullet with : 'For MVS/ESA systems and MVS/XA systems that use the Interactive Problem Control System instead of AMDPRECT, the IRLM dump formatting module name is in control table BLSCECT in SYS1.PARMLIB.' ================================================================ On page 2-168 in step 9 (DSNTIJMV): Paragraph 3 (starting with "Be sure to remove...") and paragraph 7 (starting with "Check the disposition...") are obsolete and can be disre- garded. ============================================================== Book Title: DB2 Administration Guide, Volume I (SC26-4374-02) Page Number: 2-168 Remove the paragraph that begins, "Be sure to remove the comment characters...". Also remove the paragraph that begins, "Check the disposition for...". ================================================================ Book Title: Administration Guide, Sect. 2: 'Planning and Installing DB2', SC26-4374-02 Page Number: 2-175 Change Description: Add this sentence to the end of the second-to-last paragraph: 'SYS1.HELP(COMMANDS) is HELP information only. It describes DB2 function; it does not provide that function.' ================================================================ Book Title: Administration Guide, Sect. 2: 'Planning and Installing DB2', SC26-4374-02 Page Number: 2-182 Change Description: Replace the last sentence of the third complete paragraph with: 'When migrating, you also might receive a return code of 12 if the temporary database DSNDB07 was dropped before running job DSNTIJTM.' ============================================================ In the Administration Guide, Vol. 1, page 2-200, Step 21: Start Version 2 Release 3, there should be a note to RLF users. If you specified YES for RLF AUTO START on installation panel DSNTIPO, you will get an unavailable resource message C900A6 stating that the database DSNDB06 is unavailable and you will need to run job DSNTIJTC. This message can be ignored because job DSNTIJTC will be run in migration step 22. Additional keywords: RC00C900A6 TYPE100 Database NAME DSNDB06 DSNTCSTR 'START RLIMIT' ABNORMAL COMPLETION ============================================================ On page 2-200, under the section titled "Perform the follow- ing steps to start DB2 Version 2 Release" add in item # 2: In order to run Migration step 28, you must copy DSN8EAE1 from DSN220.DSNEXIT to DSN230.DSNEXIT before starting DB2. Otherwise you may receive SQLCODE904 RC00C9008A TYPE240 for DSN8EAE1 while running the V2R2 IVPs as documented in Migration step 28. DSN8EAE1 will be replaced with a R230 version when the R230 IVP DSNTEJ1 is executed. ============================================================== Book Title: DB2 Administration Guide, Volume I (SC26-4374-02) Page Number: 2-200 Under "Migration Step 21" in item number 2, replace the sentence beginning, "Start DB2 from..." with the following sentence: "After you are sure DSN8EAE1 is in DSN230.DSNEXIT, start DB2 from the MVS console using the command..." ============================================================= In the Administration guide Vol I page 2-201 in step 21 you are directed to use the command: -DISPLAY DATABASE(*) SPACENAM(*) RESTRICT ... DB2 issues RC00C900A6 TYPE 100 NAME DSNDB06. This is caused because step 22 has not been run yet. ============================================================ On page 2-203, Migration Step 28: Verify Your Version 2 Release 3 System, step 4. Instructions are given to make changes to 2.2 DSNTEP2 source. After that, step 1 of job DSNTEJ1P needs to be run to precompile/compile/linkedit the changed version prior to running DSNTEJ1P Step 2. ============================================================ Book Title: DB2 Administration Guide, Volume I (SC26-4374-02) Page Number: 2-203 Under "Migration Step 28" in step 4, replace the paragraph that begins, "Performing this step will execute..." with the following paragraph: "Since performing this step will execute DSNTEP2 from your prior release, you must make some changes to your prior release's DSNTEP2. Then, you must recompile DSNTEP2 by running step 1 of DSNTEJ1P. Following is the list of changes:" ============================================================= In the Administration Guide Vol I on page 2-212, under the heading "Installation Verification Phases and Programs", Table 56 should be modified to add a line for job DSNTEJ1S. See the table excerpt below. | Table 56 (Page 1 of 2). Relationship of Phases to Programs +------+-----------+-----------+---------------------------- | PHASE| JOB | PROGRAM | DESCRIPTION +------+-----------+-----------+---------------------------- : DSNTEJ1S**| DSNHSP | JCL to bind and run the | schema processor : In addition, Table 56 should have the following note added at the end of the table: **Note: Job DSNTEJ1S, which contains sample JCL to run the schema processor, is not a part of the sample applications that you can use to verify For more information on job DSNTEJ1S and the the schema processor, see page 4-68. ============================================================ In the Administration Guide Vol I on page 2-219, Table 62 does not have the right number of steps in it. It will be replaced with the following: ... +------------------------------------+ | Table 62 DSNTEJ1 | | Version 2 Release 3 | | Return Codes | +----------+------------+------------+ | STEP | PROCSTEP | RETURN | | | | CODE | +----------+------------+------------+ | PH01S01 | | 0000 | +----------+------------+------------+ | PH01S02 | | 0000 | +----------+------------+------------+ | PH01S03 | | 0000 | +----------+------------+------------+ | PH01S04 | | 0000 | +----------+------------+------------+ | PH01S05 | | 0000 | +----------+------------+------------+ | PH01S06 | ASM | 0000 | | | LKED | 0000 | +----------+------------+------------+ | PH01S07 | ASM | 0000 | | | LKED | 0000 | +----------+------------+------------+ | PH01S08 | PC | 0004 | | | ASM | 0000 | | | LKED | 0000 | +----------+------------+------------+ | PH01S09 | DSNUPROC | 0000 | +----------+------------+------------+ | PH01S10 | DSNUPROC | 0004 | +----------+------------+------------+ | PH01S11 | DSNUPROC | 0000 | +----------+------------+------------+ | PH01S12 | DSNUPROC | 0000 | +----------+------------+------------+ | PH01S13 | DSNUPROC | 0000 | +----------+------------+------------+ ====================================== On DSNTEJ1 step PH01S03, if you use the decimal instead ofthe comma as a separator, all instances of substr(firstnme, 1, 1) needs to be input as above (with a blank after the commas).
Local fix
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II05811
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
1992-03-09
Closed date
1992-03-17
Last modified date
1996-09-25
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:
13 December 2020