Version 7.4.2
 —  Defining and Tuning Optimization Parameters  —

Excluded Command Summary

Adabas Fastpath Online Services can be used to display commands excluded from optimization by exclusion category. This section provides a more detailed explanation for each exclusion category.


Excluded: Reasons

Job area not available
Explanation

Commands ignored for optimization because job areas were not available.

Action

Increase the buffer parameter maximum jobs.


Not a Fastpath command
Explanation

Only the commands L1, L2, L3, L9, S1, S2, S8, S9, and RC are eligible for optimization.

Action

None required.


DBID not qualified
Explanation

Commands ignored because none of the files for the database have been defined for optimization.

Action

Consider using AFPLOOK to sample the database(s) and then create new file parameters.


DB list overflow
Explanation

Commands ignored because the database list area has overflowed.

Action

Indicates a shortage of either local or common storage.


File not qualified
Explanation

Commands ignored because the file has not been defined for optimization.

Action

None required, or define a new file parameter.


Misc/temp off switch
Explanation

Commands ignored for reasons related to functions that have been temporarily switched off. Most common reason is that a database/file has been disconnected, or a job is in the process of termination.

Action

Use SYSAFP to check whether a database or file is not optimizing.


User area shortage
Explanation

Commands cannot be processed because a user area is not available.

Action

Indicates a shortage of either local or common storage.


Non-AFP CB settings
Explanation

Certain commands are not processed by Adabas Fastpath because of special Adabas control block options; for example, Command IDs set to hex 'FFFFFFFF'.

Action

If the volumes are significant, contact Software AG for assistance.


CID area shortage
Explanation

Commands cannot be processed because a Adabas Fastpath Command ID area is not available.

Action

Indicates a shortage of either local or common storage.


Multifetch already used
Explanation

Optimization could not proceed because the command being processed was already set to perform prefetch or multifetch.

Action

None needed, but avoid the conflicting use of read-ahead techniques (Example: ADAPREF and Adabas Fastpath).


Set ID length exceeded
Explanation

Commands were ignored for direct access optimization because the Set ID length exceeded the parameter. A Set ID comprises the Adabas FB+SB+12 bytes.

Action

Review the buffer and file parameters set ID length limit and increase if required.


Descriptor not qualified
Explanation

Although the file is defined for optimization, the descriptor is not included or is explicitly excluded.

Action

None needed, or identify and add the descriptor to the file parameter.


FB/SB not recognized
Explanation

Commands ignored for optimization because Adabas Fastpath does not recognize the syntax in the Adabas format or search buffer.

Action

If the number is significant, contact Software AG for assistance.


Unknown status
Explanation

Commands ignored for optimization because the status within the command sequence is not known.

Action

None possible.


Sequence detection
Explanation

Count of commands that are not optimized because they are the first in a command sequence and are used for detection of the sequence.

Action

None required.


Top of page

Direct Not Optimized

Reposition size overflow
Explanation

Count of commands that could not be optimized because the reposition area in the Adabas Fastpath user area was not large enough.

Action

None possible.


Concurrency clash
Explanation

Count of commands that could not be optimized because

  • other commands were using the direct access file/set; or

  • updates were processing data in the set.

Action

If the volume of commands ignored is significant, the buffer parameter set concurrency can be increased by 1.


Startup/set off/rej
Explanation

Count of commands that could not be optimized because

  • the start-up process had not completed; or

  • a set was switched off or rejected.

Action

None required.


DA set not found
Explanation

Count of commands not optimized because the direct access set has not yet been created.

Action

The optimization process takes time before sets are created and this count will always show a certain number. If the volumes are significant and continue to increase, the buffer parameter size should be reviewed and increased if necessary.


DA data not in set
Explanation

Count of commands not optimized because, while the set has been found, the required data item is not present.

Action

None required.


RBL exceeds maximum
Explanation

Count of commands that could not be optimized because the Adabas record buffer length exceeds the parameter.

Action

Review the buffer and file parameter RB length limit and increase if required.


Top of page

Read-Ahead Not Optimized

Memory shortage
Explanation

Count of commands that could not be optimized because no read-ahead memory area was available.

Action

Indicates a shortage of local storage.


Read-ahead primer
Explanation

Count of commands used to prime the read-ahead memory areas; that is, the commands that Adabas Fastpath sets to multifetch.

Action

None required.


Sx command ignored
Explanation

Count of S1,S2,S8,S9 commands that form a command sequence but which Adabas Fastpath cannot optimize.

Action

None required.


Top of page