Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Reorg for Db2 13.1.

+SYSINORDER

The +SYSINORDER parameter controls the order in which SYSIN statements are processed. You can use this parameter in 

BMC AMI Load

 only in conjunction with 

BMC AMI Unload

.

SYSINORDER.png

The values are defined as follows:

RANDOM

(Default) BMC AMI Utilities processing determines the order in which SYSIN statements are processed.

HONOR

BMC AMI Utilities processing follows the specified order for processing SYSIN statements.

Always use +SYSINORDER(RANDOM) unless you have a specific job step that needs to do multiple things specifically in SYSIN order, such as a LOAD followed by a REORG.  You have to perform these actions in separate steps. If you are required to perform the steps in a particular order  and there is a need to have them in one step, other +parms should be reviewed and overridden or both for that step, for example ONERROR.

Using +SYSINORDER(HONOR) can cause performance degradation and limits parallelism.

Example

Consider the following unload statements in a SYSIN part of a job file:

//SYSIN   DD *
LOAD DATA INTO TABLE USR001.EXPENSES
LOAD DATA INTO TABLE USR001.PAYROLL
LOAD DATA INTO TABLE USR001.GEN_LEDGER
UNLOAD FROM TABLE USR001.EXPENSES
UNLOAD FROM TABLE USR001.PAYROLL
UNLOAD FROM TABLE USR001.GEN_LEDGER

In the following example, the EXPENSES, PAYROLL, and GEN_LEDGER tables are unloaded in any order, and this order can vary from job to job. BMC AMI Utilities processing determines the best order to optimize performance.

+SYSINORDER(RANDOM)

In the following example, the tables are unloaded in the order specified: EXPENSES, PAYROLL, GEN_LEDGER:

+SYSINORDER(HONOR)

Best practice
Use one Load statement per SYSIN and use multiple steps or multiple jobs to run the loads serially or in parallel.  If for some reason you need multiple Load statements in one SYSIN specify +SYSINORDER(HONOR) if you want to process them serially like Db2 Load does. 

Important

  • Loading tables that have Db2 enforced referential integrity (RI) in parallel can cause contention issues.
  • For the rules that apply to parameter syntax, see Parameter syntax rules.

Related topic

Global-parameters-UTLPARMS

 

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