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.

SQL insert load job steps

This section describes the steps in the load job when you select the SQL Insert option and your load includes Db2 tables.

Important

Which of the steps described below File-AID/RDX includes in the load job depends on:

  • The processing options specified.
  • Whether referential integrity relationships exist.

  1. CREATE—Create New Tables and Indexes (XFREXEC)This step creates any new tables and indexes that did not exist at the time of the interactive portion of the Load function. The extract file being used must contain DDL for the tables and indexes to be created.

    For more information about how File-AID/RDX creates new tables, see Generating-CREATE-DDL.

  2. CLEAN1ST—File Cleanup (IDCAMS)

    This step deletes any existing files that are to be created in this job. This enables you to keep and rerun a JCL stream.

  3. LDDRV—Load Driver (XFREXEC)This step checks user authorization for subsequent steps and separates the extract file into multiple files, one file per table to be loaded.

  4. SORTnnn—File Sort Utility (SORT) or ICETOOL Multiple File SortThis step sorts file(s) containing the data to be loaded in the associated LDSQLIN step.

    The sortsequence is based on the clustering index for that table. If no clustering index exists, sort sequence is based on the primary index for that table. If no primary index exists, sort sequence is based on the first-defined index for that table.

    This step is generated and executed for each table to be loaded (SORT), or once for all files to be loaded (ICETOOL).

  5. DELETE—Delete Rows (XFREXEC)This step is generated when you specify Yes in the Delete ALL Existing Data field on the SQL Insert Load Option screen. Db2 delete rules are in effect for this step.
  6. LDSQLIN—SQL Insert (XFREXEC)This step generates and executes the SQL INSERT and UPDATE statements to load data into tables from the sorted files created in step 4. If you specified Yes in the Replace Matches field on the Insert/Load Option screen and the target table contains a unique key, File-AID/RDX will replace existing data in the target table with data from the extract file. If you specified No in the Replace Matches field and the target table contains a unique key, File-AID/RDX will discard data that already exists in the target table.
  7. CLEANLST—File Cleanup (IDCAMS)This step deletes all File-AID/RDX temporary files used in this job. Deleting these files in the last job step enables the job to be restarted in any prior step.

  8. CLEANCTL—File Cleanup (IEFBR14) - OptionalThis step deletes the File-AID/RDX control card PDSEs. Whether step CLEANCTL is commented out or executed is determined by the global job option Delete in-stream data data sets at EOJ. If the job option is set to NO, File-AID/RDX control card PDSEs created in the load and delete jobs will NOT be deleted. Keeping the data sets until all steps run successfully allows for the restarting of the JCL at any step.

  9. CLEANEXT—File Cleanup (IDCAMS) - OptionalThis step deletes the File-AID/RDX EXTPARMS parameter file. Whether step CLEANEXT is commented out or executed is determined by the global job option Delete in-stream data data sets at EOJ. If the job option is set to NO, File-AID/RDX EXTPARMS files created in the load and delete jobs will NOT be deleted. Keeping the data sets until all steps run successfully allows for the restarting of the JCL at any step.

 

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