Excluded Command Summary

Command code cannot be optimized.

None.

Commands ignored because the database/file/command code or descriptor has not been defined for optimization.

None required or define a new database/file parameter, or remove command code/exclusion from file definitions. Define optimization for these if you believe there is sufficient benefit.

The most common reason is that a database/file has been disconnected, or a job is in the process of termination. It is also possible that a job has been unable to connect or the buffer is down.

Use SYSAFP to check whether a database or file is not optimizing. Consider increase to the Maximum Jobs count in the Buffer parameters.

Read-ahead optimization was not possible because the command was already set to perform prefetch or multifetch.

Consider if Fastpaths’ totally dynamic read-ahead is more flexible than specific programming.

Commands were ignored for direct access optimization because the Set ID length exceeded the limit.

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

Commands that could not be optimized because the Adabas record buffer length exceeds the limit.

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