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.

Extract and Load Utility function

This section describes the Extract and Load Tables utility, which lets you extract data from a Db2 table to a data set, or load data from a data set to a Db2 table. A full table or a subset of rows can be extracted.

File-AID for Db2 offers two methods of extracting and loading:

1. File-AID Extract for DB2 and File-AID Load for DB2 are options supporting Db2 LOB and XML data type and creating extract files in a masked format.

2. File-AID for Db2 Legacy Functions perform as in previous releases of File-AID for Db2, but do not exploit all new Db2 Version 9 or higher functionality.

Either utility can be run both online and in batch. In addition, the extracted data can be disguised to provide security either as part of the extract or at a later time using Option 7, Data Disguise (see also Disguise-Existing-Extract-File).

New Extract and Load Tables Utility

The New Extract and Load Tables utility allows you to extract Db2 table data, including LOB and XML column data, to a standard extract file, and load a Db2 table using that extract file.

Extract processing for Option 1, File-AID Extract for DB2, has been enhanced to utilize Db2 for z/OS Multi-row fetch feature providing potential reduction in CPU time, Service Units and improved performance. When extracting from tables with LOB or XML column types, multi-row fetch processing will not be used unless these columns are excluded from the extract.

You can also extract Db2 table data to tape and load it from tape. This option is only available in batch mode.

Option 1, File-AID Extract for DB2 also provides the option to extract only selected columns with the Selective Columns option.

Using File-AID Extract for DB2 or the legacy method, you can also extract data in delimited file format to load into other RDBMS or spreadsheets that accept delimited file format.

Legacy Extract and Load Functions

Using the legacy method, you can combine extract and load into a single operation, enabling you to copy across subsystems or locations.

When you perform an extract operation in standard file format, using the legacy method, two data sets are created: an unload data set and a control data set. The unload data set contains all the row data extracted from the specified object. The control data set contains information about the structure of the data. These two data sets are then used as the input to the load operation.

A third data set, a record layout, can be created during the extract operation. This data set can then be used in File-AID/MVS to view the extract data set in formatted mode.

Important

You should not mix unload and control data sets from different releases of File-AID for Db2.

When you perform an extract operation in delimited file format (see Specify Extract Dataset Format), only the unload data set is created. Unload data sets in delimited file format cannot be loaded with the File-AID for Db2 load option.

When you perform a load operation, you may choose to perform either an SQL load or a Db2 load. If you select SQL load, data is loaded into the target table using a number of insert statements. If you select Db2 load, data is loaded into the target table using the IBM Db2 Batch load utility.

Unload and control card data sets are completely interchangeable between batch and online modes. Data sets created during an online extract operation can be used as source data sets in a batch load process. Data sets created during a batch extract operation can be used as the source data sets in an online load process.

This section provides information about the following topics:

 

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