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.

Db2 delete JCL

The delete JCL shown in the following figure performs the execution phase of the delete process for Db2 objects. You can code and execute the JCL separately in a batch job. In addition, File-AID/RDX can automatically generate the JCL through the interactive portion of the Delete option.

Delete JCL (continues on next topic)

//*                                                             XFRJDLT1
//*SQLID TSOID01 IS AUTHORIZED FOR ALL THE DELETE STEPS
//*                                                             XFRJSTRD
//*-------------------------------------------------------------------
//* CLEAN1ST: - THIS STEP WILL ENSURE THAT ALL TEMPORARY FILES
//*             USED IN THIS JOB ARE DELETED.
//*           - THIS ALLOWS FOR KEEPING AND RERUNNING THE JOB EVEN IF
//*             SUBSEQUENT STEPS FAIL.
//*           - THIS JCL IS ALSO RESTARTABLE AT ANY STEP BY CODING
//*             RESTART=XXXXXXXX ON THE JOBCARD. (XXXXXXXX = STEPNAME)
//*-------------------------------------------------------------------
//CLEAN1ST EXEC PGM=IDCAMS,COND=(4,LT),DYNAMNBR=2048          
//SYSPRINT  DD  SYSOUT=*
//SYSIN     DD  *        IDCAMS DELETE STATEMENTS FOLLOW
  DELETE File-AID-split-file

  DELETE File-AID-deletbl-file

  DELETE File-AID-discard-file

 SET MAXCC=0
 SET LASTCC=0
/*
//*                                                            
//* --------------------------------------------------------------------
//* DLDRV:- DELETE DRIVER
//*         THE FOLLOWING IS PERFORMED IN THIS STEP.
//*         - ENSURE TABLES EXIST.
//*         - SPLIT EXTRACT FILE INTO SEPARATE DELETE FILES.
//* --------------------------------------------------------------------
//DLDRV   EXEC PGM=XFREXEC,REGION=8192K,COND=(4,LT),
//  PARM=(FR,9,B)
//*
//STEPLIB  DD DSN=File-AID/RDX-load-libraries,DISP=SHR
//         DD DSN=DB2-load-library,DISP=SHR
//RDXMLIB  DD DSN=File-AID-message-library,DISP=SHR
//EXTRACT  DD DSN=TSOID01.FRSAMP.EXTRACT,
//            DISP=SHR
//EXTPARMS DD DSN=TSOID01.prefix.PARMS.Dnnnnnn.Tnnnnnn.suffix,
//            DISP=SHR                              
//*
//DISCARDS DD DSN=File-AID-discard-file,
//            DCB=(RECFM=VB,LRECL=302,BLKSIZE=306,DSORG=PS),
//            SPACE=(TRK,(1,1),RLSE),
//            UNIT=SYSDA,
//            DISP=(NEW,CATLG,DELETE)
//*
//DELETBL  DD DSN=File-AID-loadtbl-file,
//            DCB=(RECFM=FB,LRECL=80,BLKSIZE=27920,DSORG=PS),
//            SPACE=(TRK,(1,1),RLSE),
//            UNIT=SYSDA,
//            DISP=(NEW,CATLG,DELETE)
//*
//SPLITnnn DD DSN=File-AID-split-file,
//            DCB=(RECFM=VB,LRECL=119,BLKSIZE=123,DSORG=PS),
//            SPACE=(123,(2300,460),RLSE),
//            UNIT=SYSDA,
//            DISP=(NEW,CATLG,DELETE)
//SYSOUT   DD SYSOUT=(*)
//RDXSQLCD DD SYSOUT=(*)
//SYSPRINT DD SYSOUT=(*)
//SYSTERM  DD SYSOUT=(*)
//SYSIN    DD DSN=TSOID01.prefix.VBCNTL.D
nnnnnn.Tnnnn
nn.suffix(DB2DCT),
//            DISP=SHR 

Db2 Delete JCL (continued)

//*-XFRDLT2----------------------------------------------------------
//* DELETE:  -  DELETE FROM TABLES
//*
//*   NOTE:  WHEN FILE-AID/RDX PERFORMS A DELETE, ALL DB2 DELETE RULES
//*          ARE OBSERVED.  THE CASCADE AND SET NULL DELETE RULES MAY
//*          HAVE AN IMPACT ON WHICH ROWS ARE DELETED AND FROM WHICH
//*          TABLES.  SEE THE REFERENCE MANUAL FOR MORE DETAILS.
//*
//*-------------------------------------------------------------------
//DELETE  EXEC PGM=XFREXEC,REGION=8192K,COND=(4,LT),
//  PARM=(FR,8,B)
//*
//STEPLIB  DD DSN=File-AID/RDX-load-libraries,DISP=SHR
//         DD DSN=DB2-load-library,DISP=SHR
//RDXMLIB  DD DSN=File-AID-message-library,DISP=SHR
//SYSIN    DD DSN=TSOID01.prefix.VBCNTL.Dnnnnnn.Tnnnnnn.suffix(DB2DCT),
//            DISP=(SHR)
//EXTPARMS DD DSN=TSOID01.prefix.PARMS.Dnnnnnn.Tnnnnnn.suffix,
//            DISP=SHR                              
//DELETEIN DD DSN=TSOID01.prefix.SPLITnnn.Dnnnnnn.Tnnnnnn.suffix,
//            DISP=(OLD,KEEP,KEEP)
//XCPTNRPT DD SYSOUT=(*)
//TOTLSRPT DD SYSOUT=(*)
//COMMTRPT DD SYSOUT=(*)
//RDXSQLCD DD SYSOUT=(*)
//SYSOUT   DD SYSOUT=(*)
//DISCARDS DD DSN=TSOID01.DISCARD,
//            DISP=MOD
//SYSPRINT DD SYSOUT=(*)
//TPTPRINT DD SYSOUT=(*)
//*
//*-------------------------------------------------------------------
//* CLEANLST: - THIS STEP WILL PERFORM A DELETE OF ALL TEMPORARY
//*             FILES USED IN THIS JOB.
//*           - KEEPING THE FILES UNTIL ALL STEPS RUN SUCCESSFULLY

//
*             ALLOWS FOR THE RESTARTING OF THE JCL AT ANY STEP.
//*-------------------------------------------------------------------
//CLEAN1ST EXEC PGM=IDCAMS,COND=(4,LT),DYNAMNBR=2048
//SYSPRINT  DD  SYSOUT=*
//SYSIN     DD  *        IDCAMS DELETE STATEMENTS FOLLOW
  DELETE File-AID-sort-file

  DELETE File-AID-split-file

  DELETE File-AID-deletbl-file

  DELETE File-AID-discard-file


 SET MAXCC=0
 SET LASTCC=0
/*
/*-------------------------------------------------------------------
//CLEANCTL EXEC PGM=IEFBR14,COND=(4,LT)                               
//DFBPDSE  DD DSN=DSN=TSOID01.prefix.FBCNTL.Dnnnnnn.Tnnnnnn
.suffix,            
//            DISP=(OLD,DELETE,DELETE)                                
//DVBPDSE  DD DSN=DSN=TSOID01.prefix.VBCNTL.Dnnnnnn.Tnnnnnn
.suffix,            
//            DISP=(OLD,DELETE,DELETE)                                
//CLEANEXT EXEC PGM=IDCAMS,COND=(4,LT),DYNAMNBR=2048          XFRJCLXT
//SYSPRINT  DD  SYSOUT=*
//SYSIN     DD  *        IDCAMS DELETE STATEMENTS FOLLOW
 DELETE extract-parms-file,
 SET MAXCC=0
 SET LASTCC=0
//*
//*                                                   /*XFRJCLXT*/

DLDRV Step Parameter List and DD Statements

XFREXEC is the File-AID/RDX program name.

The parameter information in the PARM field on the EXEC statement for the DLDRV step must have the following format:

EXEC Statement PARM Field—DLDRV Step

Parameter

Default Value

Length

Description

Product

FR

2

File-AID/RDX

Option

9

1

File-AID/RDX option number.

Operating Mode

B

1

B : Batch

The following DD statements are required for the DLDRV step:

DD Statements—DLDRV Step

DD Statement

Description

STEPLIB

File-AID/RDX load libraries (CXVJLOAD and SXVJLOAD); Db2 load library.

RDXMLIB

Library containing File-AID/RDX messages.

EXTRACT

File-AID/RDX extract file name.

EXTPARMS

File containing the load parameters (see EXTPARMS File).

DISCARDS

File-AID/RDX discard file.

DELETBL

File into which File-AID/RDX reads the Delete Control Table. The Delete Control Table is used by the DELETE step.

SPLITnnn

Output file to which File-AID/RDX writes data from a single table from the extract file.

  • One file for each table, where 001≤ nnn ≤ 099.
  • The LRECL and BLKSIZE parameters must be large enough to hold the extracted records.
  • The SPACE parameters must be large enough to hold all extracted records.

SYSOUT

Output class for error messages and reports.

RDXSQLCD

Output class for detailed SQL error information from Db2.

SYSPRINT

Standard output stream.

SYSTERM

Output class for runtime errors.

TPTPRINT

Standard output stream for optional diagnostics.

SYSIN

File-AID/RDX’s Delete Control Table. Used to verify authorities and identify tables from which data is to be deleted.

Related topics

Delete-control-table

 

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