Writer instructions

Purpose

Use this page to display a banner announcement on each page of the space. Create the Space announcements page in the master space, outside of the Home branch.

You can version the Space announcements page to enable different banners to be published into different target spaces, however, the banner that is displayed in the versioned (master) space itself only displays the most recently-published banner.  If you find errors in the banner area of your versioned space and you are sure the Space announcements page is set up correctly, try publishing the page to the same space.

For more information, see Space-announcements-banners.

Removing

When an announcement is no longer needed, remove the BMC Space Banner macro.

Translation

Localized spaces using the L10n Viewport theme must change the name of this page to Space announcements l10n.  See Configuring-the-Scroll-ViewPort-theme-for-translated-spaces.

Usage

Choose one or none of the following BMC Space Banner macros.

If your space requires another kind of announcement, you can use this page in coordination with your team lead and editors.

When should I use a space announcement banner?

Use the space organization announcement after you change the content from a book-like organization (such as User Manual, Configuration Manual, and Administration Guide) to the product model.

Use the latest version announcement to push traffic to later versions. You do not need to add this to every previous version, but if you have a specific reason that you want users to be aware—for example, Google searches show content for an obsolete version—use the banner to help users find a relevant version.

When an announcement is no longer needed, remove the BMC Space Banner macro.

Space announcement This documentation space provides the same content as before, but the organization of the content has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

File-AID for DB2


The verification steps for File-AID for Db2 use Db2 sample tables which are built with Task 11.2 Create Db2 Training Files (XVJTRNDB).

Task 13.20 Verify Primary Options

  1. Invoke  through the method chosen during customization of your environment.
  2. From the File-AID for Db2 Primary Option Menu, verify that you can invoke each of the primary options by entering the appropriate number or letter and pressing Enter.
  3. As you confirm that you can invoke an option, invoke the next one by either returning to the Primary Option Menu using the END command or pressing PF3 and then selecting the next option or by going directly to the option using a jump command (for example, =3 to go to option 3, Utilities).

Task 13.21 Verify XFDCOPY CLIST

The XFDCOPY CLIST must be available to you in order to continue the verification process (see Installing-Training-Files).

  1. Type TSO %XFDCOPY on the COMMAND line to execute the XFDCOPY CLIST.
    File-AID displays progress messages as the sample files are created.
  2. Answer the question OK TO DELETE? with Y (Yes) to delete existing FDSAMP.RELATION and SHOW.SQL files, then create new copies.

Task 13.22 Verify Option 2, Edit

  1. Invoke option 2, Edit.

    Edit Options screen, shown in the following figure, is displayed.

    Edit Options

    image2021-7-19_21-53-43.png

  2. Fill in the screen information as shown other than the following fields:
  3. In the SSID field, specify the subsystem ID that was used when creating the sample tables (Task 11.2 Create Db2 Training Files (XVJTRNDB)).
  4. In the Creator field, specify the creator name for ORDER_TABLE that was used when creating the sample tables.
  5. In the Table Name field, specify ORDER_1.
  6. In the Relationship File field, specify the Relationship file name you built using XFDCOPY (Task 13.21).
  7. Press Enter.

    The File-AID for Db2 Edit screen (Table mode), shown in the following figure, displays in Table Mode.

    Edit Table Mode

    image2021-7-19_21-55-5.png

  8. Issue REDIT primary command on the screen, to invoke Related Edit function.
  9. Press Enter.

    File-AID for Db2 displays the Related Table List window, shown in the following figure.

    Related Table List

    image2021-7-19_21-55-43.png

  10. Enter S line command in front of the ORDER_LINE_1 entry.
  11. Press Enter.

    File-AID for Db2 displays the Related Table screen as shown in the following figure.

    Related Table Edit Screen

    image2021-7-19_21-57-11.png

    The screen has one row of ORDER_1 in the half top of the screen as the parent table row, and the corresponding rows in the related table ORDER_LINE_1 in the half bottom of the screen as the dependent table rows.

    The related keys between these tables are ORDER_NUMBER in ORDER_1 and ORDER_NUM in ORDER_LINE_1.

  12. With the cursor in the bottom half of the screen, press PF3 (END) to return to the original Edit screen.
  13. Enter the ROW primary command.

    File-AID for Db2 displays the Edit screen (Row mode) as shown in the following figure.

    Edit Row Mode

    image2021-7-19_21-58-2.png

  14. Press PF4 (RETURN) to return to the File-AID for Db2 Primary Option Menu.

Task 13.23 Verify Option 3.4, Object List Utility

  1. Invoke option 3.4 Object List Utility.

    File-AID for Db2 displays the Object List Utility screen as shown in the following figure.

    Object List Utility

    image2021-7-19_22-1-58.png

  2. Fill in the following information:
  3. In the SSID field, verify that the subsystem ID that was used when creating the sample tables (Task 11.2 Create Db2 Training Files (XVJTRNDB)) is prefilled.
  4. In the Object Name field, specify * (asterisk).
  5. Type S in front of Table to select Table object.
  6. In the Object Creator field, enter the Creator name that was used when creating the sample tables.
  7. Press Enter.

    File-AID for Db2 displays the Object List Selection screen as shown in the following figure.

    Object List Selection

    image2021-7-19_22-2-42.png

  8. Type GD line command for the ORDER_1 to view the DDL for the table.
  9. Press Enter.

    File-AID for Db2 displays the Getting Started with the Object Administration Utility window (see the following figure). (The window is not displayed, if you set to not display the window in option 0.5.)

    Getting Started with the Object Administration Utility

    image2021-7-19_22-3-20.png

  10. Scroll down (PF8) to read the remainder of the short tutorial.
  11. Press Enter to go forward.

    File-AID for Db2 Object Administration generates DDL for the table and displays it (see the following figure).

    DDL for ORDER_TABLE

    image2021-7-19_22-3-59.png

  12. Press PF4 (RETURN) twice to return to the File-AID for Db2 Primary Option Menu.

Task 13.24 Verify Option 5.1 (Print Table Data)

  1. Invoke option 5.1, Print Table Data.

    File-AID for Db2 displays the Print Options screen as shown in the following figure.

    Print Options

    image2021-7-19_22-4-51.png

  2. Fill in the following information as shown other than the following fields:
  3. In the SSID field, verify that the subsystem ID that was used when creating the sample tables (Task 11.2 Create Db2 Training Files (XVJTRNDB)) is prefilled.
  4. In the Creator field, enter the Creator name that was used when creating the sample tables.
  5. In the Table Name field, enter CUSTOMER_1.
  6. Press Enter.

    File-AID for Db2 displays the Table Print Output Specification screen as shown in the following figure.

    Table Print Output Specification

    image2021-7-19_22-5-41.png

  7. Type S line command in front of TO PRINTER to select output to printer.
  8. Enter your site’s printer name in the Printer Destination field.
  9. Specify your site’s Sysout Class, if necessary.
  10. Press Enter.

    File-AID for Db2 generates Print JCL and displays it as shown in the following figure.

    Print JCL

    image2021-7-19_22-6-20.png

  11. Verify the generated JCL. Use the scroll commands to view all.
  12. Type SUBMIT in the command line to submit the job.
  13. Press Enter.
  14. Verify the job output.

    Table data is printed in F2SYSOUT DD. See the following figure for a partial listing.

    Table Print Report

    image2021-7-19_22-7-31.png

  15. Press PF4 (RETURN) to return to the File-AID for Db2 Primary Option Menu.
  16. Press PF3 (END) to exit File-AID for Db2.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*