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. | |
RI Relationship Detail Screen
Depending on your RI Load Scope option selection in the DB2 RI Update Online Options Screen the RI Relationship Detail screen has a different look.
RI Load Scope Option 1
When selecting RI Load Scope Option 1, the RI Relationship Detail screen displays as shown in the following figure.
RI Relationship Detail Screen RI Load Option 1
This screen lists all Db2 RI relationships associated with the driving table, the Db2 table specified in the Base Object: field, the table for which you had specified the Load RI option or L line command.
Use this screen to load and refresh relationships in the File-AID relationship file (S line command or ALL primary command), delete relationships from the relationship file (D line command), and select relationships about which you want to view more detailed information (I line command).
This screen displays information from the Db2 catalog and File-AID’s relationship file about all RI relationships involving the specified table.
Relationships in which the driving table is either the parent or the dependent are listed first. Those relationships that involve the dependents of the driving table are listed below and are marked ASSOCIATED REL.
RI Load Scope Options 2, 3, or 4
When selecting RI Load Scope Options 2, 3, or 4, the RI Relationship Detail screen displays as shown in RI Relationship Detail Screen RI Load Option 2, RI Relationship Detail Screen RI Load Option 3, and RI Relationship Detail Screen RI Load Option 4. The screens are identical, only the listed relationships are different.
In this version of the RI Relationship Detail screen you can only load or update RI relationships in your relationship file. The D (Delete) and I (Information) line commands are not available.
RI Relationship Detail Screen RI Load Option 2
RI Relationship Detail Screen RI Load Option 3
RI Relationship Detail Screen RI Load Option 4
For each relationship, the following columns are displayed:
CMD
Enter line commands in this column. See Line Commands for information about commands that are valid for this screen.
Parent/Dependent
Displays the name of the Db2 table defined as the parent in an RI relationship in the upper row (the row with the CMD input field). The foreign keys in the dependent table refer to this table. Table names are displayed in the format location.creator.table.
Displays the name of the Db2 table defined as the dependent in an RI relationship in the lower row. This table contains the foreign keys. Table names are displayed in the format location.creator.table.
Obj Type
Indicates the object type of the parent and dependent. For RI relationships, the object type should always be DB2.
Rel Type
Indicates the kind of relationship that exists between the corresponding parent and dependent objects.
RI | Db2-defined referential integrity. |
Status
Indicates the condition of each relationship in the upper row (Status) for each relationship. If there is an error for the dependent object, it will override the Description in the lower row. The status row is blank if the relationship file is consistent with the Db2 catalog for the particular relationship. If the relationship file is not consistent with the Db2 catalog, File-AID displays one of the following messages:
Message | Explanation |
Not in Dataset | Indicates that this relationship exists in the Db2 catalog, but does not exists in the relationship file specified on the RI Relationship screen. May indicate that the relationship did not exist the last time the relationship file was refreshed. |
Not in DB2 Cat | Indicates that this relationship exists in the relationship but does not exist in the Db2 catalog. Indicates that the parent or dependent tables, or a foreign key has been dropped. |
Out of Sync1 | Indicates the relationship exists in both the relationship file and the Db2 catalog, but the timestamps on each table do not match each other. May also indicate that the columns that comprise the foreign key are inconsistent. |
In addition, File-AID displays the following messages as a result of line command processing: | |
Deleted | Displayed after you enter the D line command. Indicates that this relationship has been deleted from the relationship file. It does not, however, indicate that the relationship has been deleted from the Db2 catalog. |
Loaded | Displayed after you enter the S line command. Indicates that this relationship has been loaded into the relationship file. |
Refreshed | Displayed after you enter the S line command for a relationship that had the message Out of Sync 1 displayed. Indicates that the Db2 catalog and the relationship file are now consistent with respect to this relationship. |
Line Commands
The following File-AID-specific line commands are valid on this screen:
D (Delete)
(Load Option 1 only, see RI Relationship Detail Screen RI Load Option 1) Deletes an RI relationship only from the relationship file and displays the message Deleted in the Status column. Use this command to delete a relationship from the relationship file when it no longer exists in the Db2 catalog.
I (Relationship Information)
(Load Option 1 only, see RI Relationship Detail Screen RI Load Option 1) If you enter the I line command on a relationship for which a message is displayed in the Status column, the RI Information window is displayed (see RI Information Screen). If you enter the I line command on a relationship for which the Status column is blank (RI already in relationship file), the Relationship Information window is displayed (see Relationship Information Screen—RI relationship information).
S (Select)
Selects a relationship to be loaded or refreshed. File-AID retrieves information about the RI relationship from the Db2 catalog. If the relationship does not yet exist in the relationship file, File-AID loads the relationship and displays the message Loaded in the Status column. If the relationship does exist but is inconsistent with the Db2 catalog, File-AID uses the information from the Db2 catalog to refresh the relationship file and displays the message Refreshed in the Status column. File-AID also displays the messages Loaded and Refreshed in the Status column.
Primary Commands
The following File-AID-specific primary command is valid on this screen:
ALL
Enter the ALL command to select and load all RI relationships into the relationship file. There are no operands associated with this command.
GRAPHIC (G)
Enter the GRAPHIC command to invoke the Graphical Relationship Display screen and show RI relationships for the selected table. See Graphical Relationship Display for more information on the Graphical Relationship Display screen. There are no operands associated with this command.
SQLID
Enter the SQLID primary command to change the current Db2 SQLID. Enter the SQLID command without an operand to change the current SQLID to match the current userid. Use the new-sqlid operand to specify any SQLID.
RI Information Screen
The RI Information screen is displayed when you enter the I line command on the RI Relationship Detail screen on a relationship and press Enter. This window contains detailed information about the relationship on which you invoked the I line command on the RI Relationship Detail screen.
RI Information Screen
Parent and Dependent Object Name Area
The fields in this area provide information about the parent and dependent objects.
Parent Name
Displays the name of the table defined as the parent table in an RI relationship. This table’s primary index contains values that match the foreign keys defined in the corresponding dependent table. Tables are displayed in the format location.creator.table.
Type
Indicates the object type of the parent and dependent object.
DB2 | indicates a Db2 table. |
Dependent Name
Displays the name of the table defined as the dependent table in an RI relationship. This table contains the foreign key, the values of which match the parent table’s primary index. Tables are displayed in the format location.creator.table.
Relationship Details Area
The fields in this area provide information about the relationship such as the Relationship Description, the Status of the relationship, creation and modification dates.
Description
A description of the selected relationship.
RI | The RELNAME from the Db2 catalog table, SYSIBM.SYSRELS (see Relationship Information Screen—RI relationship information). |
Status
Displays the message displayed in the Status column on the RI Relationship Detail screen.
Message | Explanation |
Not in Dataset | Relationship in Db2 catalog is not loaded in the relationship file. |
NOT IN DB2 CAT | Relationship cannot found in the Db2 catalog. |
OUT OF SYNC 1 | Timestamp is inconsistent between Db2 catalog and relationship file. |
Created
Displays the date and time that the relationship was created. For Db2 RI relationships it represents when it was loaded into the Db2 catalog. File-AID displays date and time in the format specified at the time of Db2 installation.
User
Displays the user ID of the person who loaded the RI relationship into the relationship file using either the initial load batch job or the Load RI option or line command.
Last Modified
Display date, time, and user ID indicating when the relationship was last modified and who modified it. File-AID displays date and time in the format specified at the time of Db2 installation.
Parent Columns
Displays the names of the columns from the parent table that are referenced by the foreign key.
Dependent Columns
Displays the names of the columns from the dependent table that comprise the foreign key.
Type(Length)
The line directly below the parent column’s name displays the column’s data type. The length of the data is displayed in parentheses immediately following the data type for CHAR, VCHAR, GRPH, VGRPH, and DEC data types only. Note that the length value only displays after the RI has been loaded into the relationship file.